polymarket_polygon.positions

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

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

Example query

-- 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