ob_SOLUSDT
SOL top of book after every book update (~100 ms): best bid/ask, mid, spread, 20-level volumes, imbalance; lob_update_id joins to l2_* · core · 2026-08-01 — 2026-08-28 (28 days)
Schema
| Column | Type | Meaning |
|---|---|---|
| exchange | VARCHAR | Always `binance`. |
| symbol | VARCHAR | Instrument. |
| timestamp_ms | BIGINT | Exchange event time of the diff that produced this top-of-book state, ms UTC. |
| recv_ms | BIGINT | Local receive time, ms UTC. |
| epoch | BIGINT | WebSocket session number. |
| ingest_seq | BIGINT | Arrival counter of the producing frame. |
| lob_update_id | BIGINT | final_id of the l2_* frame after which this state was taken — joins ob_* to l2_* exactly. |
| bid_px | DOUBLE | Best bid price (float). |
| ask_px | DOUBLE | Best ask price (float). |
| mid | DOUBLE | (bid_px + ask_px) / 2. |
| spread_bps | DOUBLE | (ask − bid) / mid × 10 000. |
| bid_vol_20 | DOUBLE | Sum of base-asset quantity on the 20 best bid levels. |
| ask_vol_20 | DOUBLE | Sum of base-asset quantity on the 20 best ask levels. |
| obi | DOUBLE | (bid_vol_20 − ask_vol_20) / (bid_vol_20 + ask_vol_20); −1…1. |
Conventions shared by all streams — UTC
milliseconds, integer prices, what side means where, how gaps are
marked and how to rebuild the book — are in the
data dictionary. The same text is
returned by GET /v1/schema/ob_SOLUSDT and the MCP tool
get_schema.
Sample rows (demo hour)
| exchange | symbol | timestamp_ms | recv_ms | epoch | ingest_seq | lob_update_id | bid_px | ask_px | mid | spread_bps | bid_vol_20 | ask_vol_20 | obi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| binance | SOL/USDT | 1787011200231 | 1787011200230 | 840 | 31276953 | 29740205804 | 76.01 | 76.02 | 76.015 | 1.32 | 11190.653 | 13370.688 | -0.0888 |
| binance | SOLUSDT | 1787011200265 | None | None | None | None | 76.01 | 76.02 | 76.015 | 1.32 | 11190.653 | 13370.688 | -0.0888 |
| binance | SOL/USDT | 1787011200331 | 1787011200330 | 840 | 31276956 | 29740205809 | 76.01 | 76.02 | 76.015 | 1.32 | 11193.285 | 13328.406 | -0.0871 |
Work with this stream in the SQL console and the backtest runner — the data stays with us, the results go to you. Get access