Skip to main content
The polygon.predictions.market_orderbook_high_freshness table provides minute-level orderbook snapshots for Polymarket prediction markets, capturing bid and ask price levels at 15-minute intervals for all active markets. Use this table for real-time market analysis, trading strategies, and monitoring orderbook dynamics with higher granularity than the daily snapshots.

​
Table Columns

Unique Key: unique_key
Column NameData TypeDescription
projectVARCHARProject identifier, always ‘polymarket’.
protocolVARCHARProtocol identifier, always ‘polymarket’.
order_dateDATEDate of the orderbook snapshot.
market_unique_idVARCHARUnique key for grouping related markets.
condition_idVARCHARUnique condition identifier.
market_questionVARCHARMarket question text.
token_idVARCHARToken ID for this outcome.
token_nameVARCHARCombined outcome and question name.
token_outcomeVARCHARToken outcome name.
sideVARCHAROrderbook side (BUY or SELL).
priceFLOATPrice level in dollars.
quantityNUMBERQuantity at this price level.
tick_sizeNUMBERMinimum price increment (tick size).
neg_riskBOOLEANWhether this is a NegRisk market.
min_order_sizeNUMBERMinimum order size in dollars.
orderbook_hashVARCHARHash of the orderbook state.
order_timestampTIMESTAMP_NTZ(9)Timestamp of the orderbook snapshot.
ingested_atTIMESTAMP_NTZ(9)Data ingestion timestamp.
unique_keyVARCHARUnique record key (YYYYMMDDHHMM-condition_id-token_id-side-price_dollars).

​
Comparison with Daily Orderbook

Featuremarket_orderbookmarket_orderbook_high_freshness
Snapshot FrequencyDaily15 minutes
Side Valuesbid/askBUY/SELL
Markets CoveredAll marketsActive markets only
Use CaseHistorical analysisIntraday monitoring

​
Sample Query

SELECT 
  order_timestamp,
  market_question,
  token_outcome,
  side,
  price,
  quantity
FROM polygon.predictions.market_orderbook_high_freshness
WHERE order_timestamp >= CURRENT_TIMESTAMP - INTERVAL '1 hour'
ORDER BY order_timestamp DESC, price DESC
LIMIT 100;