> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Market Orderbook

> Polymarket US orderbook snapshots with bid/ask price levels.

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

```sql theme={null}
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
```