The polygon.predictions.open_interest table provides daily snapshots of open interest across all prediction markets. Open interest represents the total value of outstanding positions. These holdings include positions that have not been redeemed. Use this table for market liquidity analysis, total value locked tracking, and understanding the overall size of prediction markets.

​
Table Columns

Unique Key: unique_id
Column NameData TypeDescription
projectVARCHARProject name (ex. polymarket).
protocolVARCHARProtocol name (ex. polymarket).
unique_idVARCHARUnique identifier combining day, address, and token_id.
dayDATEDate for the open interest snapshot.
addressVARCHARWallet address holding the position.
condition_idVARCHARUnique condition identifier for the market.
market_unique_idVARCHARUnique key for grouping related markets.
market_idVARCHARMarket identifier.
market_nameVARCHARMarket name.
market_descriptionVARCHARMarket description.
question_idVARCHARUnique question identifier.
questionVARCHARMarket question text.
question_descriptionVARCHARMarket description from API.
token_idVARCHARToken ID for the specific outcome token.
token_outcomeVARCHARToken outcome name.
categoryVARCHARMain category of the market.
sub_categoryVARCHARSpecific subcategory of the market.
tagsVARCHARAPI category tags.
neg_riskBOOLEANWhether this is a NegRisk market.
resolution_outcomeVARCHARMarket resolution outcome (API data).
resolved_atTIMESTAMP_NTZ(9)Market resolution timestamp (API data).
open_interestFLOATNumber of outcome tokens held (position size).
token_priceFLOATCurrent token price.
open_interest_usdFLOATUSD value of the open interest position.
market_activeBOOLEANWhether market is currently active.
market_closedBOOLEANWhether market is closed.
market_accepting_ordersBOOLEANWhether market is accepting new orders.
is_winnerBOOLEANWhether this outcome won the market (API data).
_created_atTIMESTAMP_NTZ(9)Record creation timestamp.
_updated_atTIMESTAMP_NTZ(9)Record update timestamp.

​
Sample Query

Analyze total open interest by market & category:
select
  market_name,
  category,
  sum(open_interest_usd) as total_tvl_usd
from polygon.predictions.open_interest
 where day = current_date - interval '7 days'
group by market_name, category
limit 20