polymarket_polygon.positions table shows what every wallet holds each day and what it is worth. It covers regular markets and Combos (multi-leg parlays, is_combo = TRUE). Positions are valued at the day’s closing price from ohlcv_hourly. Once a market is decided, they are valued at its exact payout.
There is one row per day, wallet and outcome token, unique on (day, address, market_id, outcome_index).
The table holds balances and prices only. For market names, outcomes, resolution and links, join on outcome_id to market_details for markets or combo_details for combos. Tokens missing from those tables are left out.
It covers both generations of Polymarket contracts: the original Conditional Tokens contracts (CTF) and Protocol V2. A position moved from the CTF to Protocol V2 keeps its outcome_id, so the wallet’s history continues on the same id.
Rows left out:
- Zero balances. Once a wallet exits a position, it has no more rows for it.
- The address where No tokens are burned (
kNoTokenBurnAddressof the NegRiskAdapter contract). It is not a real holder. - From the day after a market is decided, positions worth less than one cent: losing positions and tiny winning leftovers that cannot be redeemed. The decision day still shows every position, and earlier days are complete.
Table Schema
Table sample
Query performance
positions is partitioned by day. Always filter on day.
market_id is a 0x... string here, so it joins market_details directly. combo_details stores market_id as VARBINARY, so join combos on outcome_id.
Example queries
Previous version
Previous version (v1)
Previous version (v1)
Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.