> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# polymarket_polygon.positions

> Polymarket open positions — current outcome token holdings by address and market.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

The `polymarket_polygon.positions` table contains daily user position balances by market outcome token on Polymarket.

## Table Schema

| Column              | Type        | Description                        |
| ------------------- | ----------- | ---------------------------------- |
| `condition_id`      | `VARBINARY` | Unique market condition identifier |
| `token_id`          | `UINT256`   | Token ID for the outcome           |
| `token_outcome`     | `VARCHAR`   | Token outcome (YES/NO)             |
| `address`           | `VARBINARY` | User wallet address                |
| `balance`           | `DOUBLE`    | Position balance in outcome tokens |
| `value_usd`         | `DOUBLE`    | Position value in USD              |
| `question`          | `VARCHAR`   | Market question text               |
| `event_market_name` | `VARCHAR`   | Event market name                  |
| `polymarket_link`   | `VARCHAR`   | Link to Polymarket page            |
| `unique_key`        | `VARCHAR`   | Unique position identifier         |

## Table sample

<TableSample tableSchema="polymarket_polygon" tableName="positions" />

## Example query

```sql theme={null}
-- Top position holders across all active markets
SELECT
  user_address,
  COUNT(DISTINCT condition_id) AS markets_held,
  SUM(position_value_usd) AS total_position_usd
FROM polymarket_polygon.positions
GROUP BY 1
ORDER BY 3 DESC
LIMIT 20
```