Skip to main content
The polygon.predictions.open_interest_hourly view provides hourly snapshots of open interest across all prediction markets. Use this view for granular liquidity analysis, intraday TVL tracking, and understanding market dynamics at hourly resolution.

​
Table Columns

Unique Key: unique_id
Column NameData TypeDescription
projectVARCHARProject name (polymarket).
protocolVARCHARProtocol name (polymarket).
block_hourTIMESTAMP_NTZ(9)Hour timestamp for the open interest snapshot.
token_addressVARCHARConditional Tokens contract address.
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_descriptionVARCHARDetailed question description.
token_idVARCHARToken ID for the specific outcome token.
token_outcomeVARCHARToken outcome name (Yes/No).
categoryVARCHARMain category of the market.
sub_categoryVARCHARSpecific subcategory of the market.
tagsVARCHARMarket tags.
neg_riskBOOLEANWhether this is a NegRisk market.
resolution_outcomeVARCHARMarket resolution outcome if resolved.
resolved_atTIMESTAMP_NTZ(9)Market resolution timestamp.
open_interestFLOATTotal token supply for this outcome.
token_priceFLOATPrice per token at this hour. After market resolution, prices reflect the final outcome.
open_interest_usdFLOATUSD value of the open interest.
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.
unique_idVARCHARUnique identifier combining block_hour and token_id.

​
Sample Query

SELECT 
  block_hour,
  market_name,
  token_outcome,
  open_interest,
  token_price,
  open_interest_usd
FROM polygon.predictions.open_interest_hourly
WHERE block_hour >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
ORDER BY open_interest_usd DESC
LIMIT 100;