> ## 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 High Freshness 🌱

> Minute-level Polymarket orderbook snapshots with 15-minute bid/ask price levels.

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

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