Skip to main content
The 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.
Don’t sum market_oi_yes_contracts across the members of an event. Because conversions create Yes tokens of other outcomes without adding collateral (USDC or pUSD), the sum can overstate the collateral at stake several times over. Don’t sum event_oi_contracts across members either, because it is repeated on every member row. For total open interest, take event_oi_contracts once per event and hour, grouping by COALESCE(event_id, market_id) so that each standalone market counts as its own event. The example below does this.
Volume is in this table, not on the candles, because adding up the Yes and No candles counts every Yes-versus-No trade twice. Per-token prices are in 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

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.