Market Orderbook High Freshness 🌱

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 Details

Property	Value
Table Name	`polygon.predictions.market_orderbook_high_freshness`
Table Status	Beta 🌱
Unique Key	`unique_key`

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project identifier, always ‘polymarket’.
protocol	VARCHAR(16777216)	Protocol identifier, always ‘polymarket’.
order_date	DATE	Date of the orderbook snapshot.
market_unique_id	VARCHAR(16777216)	Unique key for grouping related markets.
condition_id	VARCHAR(16777216)	Unique condition identifier.
market_question	VARCHAR(16777216)	Market question text.
token_id	VARCHAR(16777216)	Token ID for this outcome.
token_name	VARCHAR(16777216)	Combined outcome and question name.
token_outcome	VARCHAR(16777216)	Token outcome name.
side	VARCHAR(16777216)	Orderbook side (BUY or SELL).
price	FLOAT	Price level in dollars.
quantity	NUMBER(38,0)	Quantity at this price level.
tick_size	FLOAT	Minimum price increment (tick size).
neg_risk	BOOLEAN	Whether this is a NegRisk market.
min_order_size	FLOAT	Minimum order size in dollars.
orderbook_hash	VARCHAR(16777216)	Hash of the orderbook state.
order_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the orderbook snapshot.
ingested_at	TIMESTAMP_NTZ(9)	Data ingestion timestamp.
unique_key	VARCHAR(16777216)	Unique record key (YYYYMMDDHHMM-condition_id-token_id-side-price_dollars).

Comparison with Daily Orderbook

Feature	market_orderbook	market_orderbook_high_freshness
Snapshot Frequency	Daily	15 minutes
Side Values	bid/ask	BUY/SELL
Markets Covered	All markets	Active markets only
Use Case	Historical analysis	Intraday 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;

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

Comparison with Daily Orderbook

Sample Query

​Table Details

​Table Columns

​Comparison with Daily Orderbook

​Sample Query

Table Details

Table Columns

Comparison with Daily Orderbook

Sample Query