Market Orderbook

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 Name	Data Type	Description
project	VARCHAR	Project name.
protocol	VARCHAR	Protocol name.
snapshot_date	DATE	Date of the orderbook snapshot.
market_unique_id	VARCHAR	Market slug identifier.
market_question	VARCHAR	Market question text.
market_description	VARCHAR	Market description.
category	VARCHAR	Market category.
market_type	VARCHAR	Market type.
sports_market_type	VARCHAR	Sports market type.
outcome_1	VARCHAR	First outcome description.
outcome_2	VARCHAR	Second outcome description.
side	VARCHAR	Orderbook side (bid or offer).
price	FLOAT	Price level in dollars.
quantity	FLOAT	Quantity at this price level.
snapshot_timestamp	TIMESTAMP_NTZ	Timestamp of the orderbook snapshot.
ingested_at	TIMESTAMP_NTZ	Data ingestion timestamp.
unique_key	VARCHAR	Unique record key.
_extra_fields	VARCHAR	JSON 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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query