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

# Depth 10

> Best 10 bid and ask levels per outcome, sampled on a regular time grid

> [!NOTE]
>
> Depth 10 is an **early access** dataset available through [SQL](https://docs.probalytics.io/docs/sql-guide/overview.md). It requires orderbook access. To request access, email [support@probalytics.io](mailto:support@probalytics.io).

The best 10 price levels on each side of the book, sampled on a regular grid. Computed at query time from verified [orderbook snapshots](https://docs.probalytics.io/docs/datasets/orderbook.md) (`state = 'VERIFIED'`).

| View | Rows |
| - | - |
| `depth10_1s`, `depth10_10s`, `depth10_1m`, `depth10_5m` | One per outcome per bucket |

There is no raw per-snapshot view; use `arraySlice(bids, 1, 10)` on `orderbook_snapshots` for that.

## Sampled views

The `_1s`, `_10s`, `_1m`, and `_5m` views are parameterized and return the book **as of** each bucket boundary, on a regular time grid:

```sql theme={null}
SELECT *
FROM depth10_1m(
    market_id = '00000000-0000-0000-0000-000000000000',
    start = '2026-11-01 00:00:00',
    end = '2026-11-02 00:00:00'
)
```

| Parameter | Type | Meaning |
| - | - | - |
| `market_id` | `UUID` | Market. Joins to `markets.id`. |
| `start` | `DateTime` (UTC) | Range start, rounded down to the bucket boundary. Inclusive. |
| `end` | `DateTime` (UTC) | Range end. Exclusive. |

* Each row describes the last verified snapshot at or before `timestamp`. The book is carried forward through buckets with no updates.
* The views look back at most **1 day before `start`** for the starting book. If an outcome had no update in that window, its rows are `null` until the first update.
* Every outcome of the market gets a row per bucket.

## Fields

| Field | Type | Values and meaning |
| - | - | - |
| `platform` | `enum` | Source venue. |
| `market_id` | `UUID` | Probalytics market ID. |
| `market_platform_id` | `string` | Venue market ID. |
| `outcome` | `tuple` | Outcome struct. |
| `timestamp` | `datetime` | Bucket time. |
| `bids` | `array` | Best 10 bid levels, same structure as `orderbook_snapshots.bids`. |
| `asks` | `array` | Best 10 ask levels, same structure as `orderbook_snapshots.asks`. |
| `spread` | `decimal \| null` | Best ask minus best bid. `null` if either side is empty. |
| `mid` | `decimal \| null` | Midpoint of best bid and best ask. `null` if either side is empty. |

## Usage tips

* Use the sampled views to align the book with other time series, such as [OHLC candles](https://docs.probalytics.io/docs/datasets/ohlc.md).
* Coverage and history follow [orderbook snapshots](https://docs.probalytics.io/docs/datasets/orderbook.md#coverage-by-venue-and-product).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.