polymarket_polygon.open_interest_hourly table has hourly open interest and traded volume for every Polymarket market. There is one row per (hour, market_id), unique on (block_month, hour, market_id). Rows run from the hour the market’s tokens were first created to the hour it resolves. Open interest is the amount outstanding at the end of the hour. Volume is what traded during the hour.
Open interest is the number of outcome tokens in circulation. It is rebuilt from every token created and burned on Polymarket’s contracts on Polygon. A position moved to Polymarket’s Protocol V2 contracts still counts under its original token. History starts in April 2021.
Open interest is counted per side. On a standalone market, the Yes and No sides are equal. On a market that is one outcome of a mutually exclusive event (Polymarket calls these neg-risk markets), the sides can differ. Converting No tokens of one outcome creates Yes tokens of every other outcome in the event, without adding collateral (USDC or pUSD). So the No side drops and the other outcomes’ Yes sides grow. event_oi_contracts gives the collateral locked behind the whole event.
event_id is Polymarket’s event id for markets in a mutually exclusive event, and null for standalone markets. In v1 this column held the 0x... neg-risk id, which is now neg_risk_market_id in market_details.
Each row shows the state at the end of its hour. A decided market has no open interest. So the resolution hour shows zero and the rows stop there, even though people still hold tokens: losing tokens are never redeemed, and winners redeem over weeks. Redemptions are in polymarket_polygon.market_actions. A market that opens and resolves within one hour shows volume but no open interest.
Combos are not included. The collateral behind a combo sits in its legs, so it doesn’t add to single-market open interest.
polymarket_polygon.ohlcv_hourly.
Table Schema
Table sample
Query performance
block_month is the partition column. Always filter on block_month or hour.
Example query
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.