Skip to main content
The common.predictions.polymarket_us_market_orderbook table contains orderbook snapshots for open Polymarket US markets. Each row is one price level (bid or offer) at a specific snapshot timestamp, enriched with market metadata.

​
Table Columns

Unique Key: unique_key
Column NameData TypeDescription
projectVARCHARProject name.
protocolVARCHARProtocol name.
snapshot_dateDATEDate of the orderbook snapshot.
market_unique_idVARCHARMarket slug identifier.
market_questionVARCHARMarket question text.
market_descriptionVARCHARMarket description.
categoryVARCHARMarket category.
market_typeVARCHARMarket type.
sports_market_typeVARCHARSports market type.
outcome_1VARCHARFirst outcome description.
outcome_2VARCHARSecond outcome description.
sideVARCHAROrderbook side (bid or offer).
priceFLOATPrice level in dollars.
quantityFLOATQuantity at this price level.
snapshot_timestampTIMESTAMP_NTZTimestamp of the orderbook snapshot.
ingested_atTIMESTAMP_NTZData ingestion timestamp.
unique_keyVARCHARUnique record key.
_extra_fieldsVARCHARJSON string with platform-specific metadata.

​
Sample Query

SELECT
    market_unique_id,
    market_question,
    side,
    price,
    quantity
FROM common.predictions.polymarket_us_market_orderbook
WHERE DATE(snapshot_timestamp) = CURRENT_DATE()
    AND market_unique_id = 'aec-nba-atl-orl-2026-04-01'
ORDER BY side, price