> ## 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.

# Order Books

### Table Details

| Property          | Value                   |
| ----------------- | ----------------------- |
| Table Name        | `dydx.raw.order_books`  |
| Table Status      | Production-Ready        |
| Clustering Key(s) | `to_date("flushed_at")` |

### Table Columns

| Column Name   | Data Type         | Description                                                                  |
| ------------- | ----------------- | ---------------------------------------------------------------------------- |
| ticker        | VARCHAR(16777216) | Market ticker symbol identifying the traded instrument.                      |
| flushed\_at   | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when this order book state was flushed.                      |
| is\_snapshot  | BOOLEAN           | Whether this row is a full snapshot (true) or an incremental update (false). |
| bids          | VARIANT           | Bid side of the order book snapshot.                                         |
| asks          | VARIANT           | Ask side of the order book snapshot.                                         |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                     |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                |