Order book
L2 snapshots and price-level updates. is_snapshot identifies snapshot rows; a zero amount removes a level.
On this page
How to read these records
L2 snapshots and price-level updates. is_snapshot identifies snapshot rows; a zero amount removes a level.
Fields match the inspected Binance Futures BTCUSDT Parquet files. All six file types share exchange, market, symbol, timestamp and local_timestamp. Both observation clocks use UTC epoch microseconds; nullable means a value may be absent.
Fields
Incremental order book L2
| Field | Storage type | Meaning |
|---|---|---|
exchangeNullable | STRING | Exchange identifier; binance in the inspected files. |
marketNullable | STRING | Market identifier; futures in the inspected files. |
symbolNullable | STRING | Native instrument identifier, for example BTCUSDT. |
timestampNullable | INT64 | Exchange timestamp in UTC epoch microseconds. JSON examples use strings. |
local_timestampNullable | INT64 | Local receive timestamp in UTC epoch microseconds. JSON examples use strings. |
is_snapshotNullable | BOOLEAN | True for a snapshot row; false for an incremental level update. |
sideNullable | STRING | Source side: bid/ask for book updates; buy/sell for executions. Liquidation direction is not converted into long/short. |
priceNullable | DOUBLE | Price stored as a 64-bit floating-point number; this file does not use exact decimal storage. |
amountNullable | DOUBLE | Amount in the source instrument's units. Contract-to-coin conversion is not implied. |
Order book snapshots
| Field | Storage type | Meaning |
|---|---|---|
exchangeNullable | STRING | Exchange identifier; binance in the inspected files. |
marketNullable | STRING | Market identifier; futures in the inspected files. |
symbolNullable | STRING | Native instrument identifier, for example BTCUSDT. |
timestampNullable | INT64 | Exchange timestamp in UTC epoch microseconds. JSON examples use strings. |
local_timestampNullable | INT64 | Local receive timestamp in UTC epoch microseconds. JSON examples use strings. |
asks[0].priceNullable | DOUBLE | Ask price at level 1. Level 0 is the best price; storage is float64. |
asks[0].amountNullable | DOUBLE | Ask amount at level 1, in source instrument units. |
bids[0].priceNullable | DOUBLE | Bid price at level 1. Level 0 is the best price; storage is float64. |
bids[0].amountNullable | DOUBLE | Bid amount at level 1, in source instrument units. |
asks[1].priceNullable | DOUBLE | Ask price at level 2. Level 0 is the best price; storage is float64. |
asks[1].amountNullable | DOUBLE | Ask amount at level 2, in source instrument units. |
bids[1].priceNullable | DOUBLE | Bid price at level 2. Level 0 is the best price; storage is float64. |
bids[1].amountNullable | DOUBLE | Bid amount at level 2, in source instrument units. |
asks[2].priceNullable | DOUBLE | Ask price at level 3. Level 0 is the best price; storage is float64. |
asks[2].amountNullable | DOUBLE | Ask amount at level 3, in source instrument units. |
bids[2].priceNullable | DOUBLE | Bid price at level 3. Level 0 is the best price; storage is float64. |
bids[2].amountNullable | DOUBLE | Bid amount at level 3, in source instrument units. |
asks[3].priceNullable | DOUBLE | Ask price at level 4. Level 0 is the best price; storage is float64. |
asks[3].amountNullable | DOUBLE | Ask amount at level 4, in source instrument units. |
bids[3].priceNullable | DOUBLE | Bid price at level 4. Level 0 is the best price; storage is float64. |
bids[3].amountNullable | DOUBLE | Bid amount at level 4, in source instrument units. |
asks[4].priceNullable | DOUBLE | Ask price at level 5. Level 0 is the best price; storage is float64. |
asks[4].amountNullable | DOUBLE | Ask amount at level 5, in source instrument units. |
bids[4].priceNullable | DOUBLE | Bid price at level 5. Level 0 is the best price; storage is float64. |
bids[4].amountNullable | DOUBLE | Bid amount at level 5, in source instrument units. |
asks[5].priceNullable | DOUBLE | Ask price at level 6. Level 0 is the best price; storage is float64. |
asks[5].amountNullable | DOUBLE | Ask amount at level 6, in source instrument units. |
bids[5].priceNullable | DOUBLE | Bid price at level 6. Level 0 is the best price; storage is float64. |
bids[5].amountNullable | DOUBLE | Bid amount at level 6, in source instrument units. |
asks[6].priceNullable | DOUBLE | Ask price at level 7. Level 0 is the best price; storage is float64. |
asks[6].amountNullable | DOUBLE | Ask amount at level 7, in source instrument units. |
bids[6].priceNullable | DOUBLE | Bid price at level 7. Level 0 is the best price; storage is float64. |
bids[6].amountNullable | DOUBLE | Bid amount at level 7, in source instrument units. |
asks[7].priceNullable | DOUBLE | Ask price at level 8. Level 0 is the best price; storage is float64. |
asks[7].amountNullable | DOUBLE | Ask amount at level 8, in source instrument units. |
bids[7].priceNullable | DOUBLE | Bid price at level 8. Level 0 is the best price; storage is float64. |
bids[7].amountNullable | DOUBLE | Bid amount at level 8, in source instrument units. |
asks[8].priceNullable | DOUBLE | Ask price at level 9. Level 0 is the best price; storage is float64. |
asks[8].amountNullable | DOUBLE | Ask amount at level 9, in source instrument units. |
bids[8].priceNullable | DOUBLE | Bid price at level 9. Level 0 is the best price; storage is float64. |
bids[8].amountNullable | DOUBLE | Bid amount at level 9, in source instrument units. |
asks[9].priceNullable | DOUBLE | Ask price at level 10. Level 0 is the best price; storage is float64. |
asks[9].amountNullable | DOUBLE | Ask amount at level 10, in source instrument units. |
bids[9].priceNullable | DOUBLE | Bid price at level 10. Level 0 is the best price; storage is float64. |
bids[9].amountNullable | DOUBLE | Bid amount at level 10, in source instrument units. |
asks[10].priceNullable | DOUBLE | Ask price at level 11. Level 0 is the best price; storage is float64. |
asks[10].amountNullable | DOUBLE | Ask amount at level 11, in source instrument units. |
bids[10].priceNullable | DOUBLE | Bid price at level 11. Level 0 is the best price; storage is float64. |
bids[10].amountNullable | DOUBLE | Bid amount at level 11, in source instrument units. |
asks[11].priceNullable | DOUBLE | Ask price at level 12. Level 0 is the best price; storage is float64. |
asks[11].amountNullable | DOUBLE | Ask amount at level 12, in source instrument units. |
bids[11].priceNullable | DOUBLE | Bid price at level 12. Level 0 is the best price; storage is float64. |
bids[11].amountNullable | DOUBLE | Bid amount at level 12, in source instrument units. |
asks[12].priceNullable | DOUBLE | Ask price at level 13. Level 0 is the best price; storage is float64. |
asks[12].amountNullable | DOUBLE | Ask amount at level 13, in source instrument units. |
bids[12].priceNullable | DOUBLE | Bid price at level 13. Level 0 is the best price; storage is float64. |
bids[12].amountNullable | DOUBLE | Bid amount at level 13, in source instrument units. |
asks[13].priceNullable | DOUBLE | Ask price at level 14. Level 0 is the best price; storage is float64. |
asks[13].amountNullable | DOUBLE | Ask amount at level 14, in source instrument units. |
bids[13].priceNullable | DOUBLE | Bid price at level 14. Level 0 is the best price; storage is float64. |
bids[13].amountNullable | DOUBLE | Bid amount at level 14, in source instrument units. |
asks[14].priceNullable | DOUBLE | Ask price at level 15. Level 0 is the best price; storage is float64. |
asks[14].amountNullable | DOUBLE | Ask amount at level 15, in source instrument units. |
bids[14].priceNullable | DOUBLE | Bid price at level 15. Level 0 is the best price; storage is float64. |
bids[14].amountNullable | DOUBLE | Bid amount at level 15, in source instrument units. |
asks[15].priceNullable | DOUBLE | Ask price at level 16. Level 0 is the best price; storage is float64. |
asks[15].amountNullable | DOUBLE | Ask amount at level 16, in source instrument units. |
bids[15].priceNullable | DOUBLE | Bid price at level 16. Level 0 is the best price; storage is float64. |
bids[15].amountNullable | DOUBLE | Bid amount at level 16, in source instrument units. |
asks[16].priceNullable | DOUBLE | Ask price at level 17. Level 0 is the best price; storage is float64. |
asks[16].amountNullable | DOUBLE | Ask amount at level 17, in source instrument units. |
bids[16].priceNullable | DOUBLE | Bid price at level 17. Level 0 is the best price; storage is float64. |
bids[16].amountNullable | DOUBLE | Bid amount at level 17, in source instrument units. |
asks[17].priceNullable | DOUBLE | Ask price at level 18. Level 0 is the best price; storage is float64. |
asks[17].amountNullable | DOUBLE | Ask amount at level 18, in source instrument units. |
bids[17].priceNullable | DOUBLE | Bid price at level 18. Level 0 is the best price; storage is float64. |
bids[17].amountNullable | DOUBLE | Bid amount at level 18, in source instrument units. |
asks[18].priceNullable | DOUBLE | Ask price at level 19. Level 0 is the best price; storage is float64. |
asks[18].amountNullable | DOUBLE | Ask amount at level 19, in source instrument units. |
bids[18].priceNullable | DOUBLE | Bid price at level 19. Level 0 is the best price; storage is float64. |
bids[18].amountNullable | DOUBLE | Bid amount at level 19, in source instrument units. |
asks[19].priceNullable | DOUBLE | Ask price at level 20. Level 0 is the best price; storage is float64. |
asks[19].amountNullable | DOUBLE | Ask amount at level 20, in source instrument units. |
bids[19].priceNullable | DOUBLE | Bid price at level 20. Level 0 is the best price; storage is float64. |
bids[19].amountNullable | DOUBLE | Bid amount at level 20, in source instrument units. |
asks[20].priceNullable | DOUBLE | Ask price at level 21. Level 0 is the best price; storage is float64. |
asks[20].amountNullable | DOUBLE | Ask amount at level 21, in source instrument units. |
bids[20].priceNullable | DOUBLE | Bid price at level 21. Level 0 is the best price; storage is float64. |
bids[20].amountNullable | DOUBLE | Bid amount at level 21, in source instrument units. |
asks[21].priceNullable | DOUBLE | Ask price at level 22. Level 0 is the best price; storage is float64. |
asks[21].amountNullable | DOUBLE | Ask amount at level 22, in source instrument units. |
bids[21].priceNullable | DOUBLE | Bid price at level 22. Level 0 is the best price; storage is float64. |
bids[21].amountNullable | DOUBLE | Bid amount at level 22, in source instrument units. |
asks[22].priceNullable | DOUBLE | Ask price at level 23. Level 0 is the best price; storage is float64. |
asks[22].amountNullable | DOUBLE | Ask amount at level 23, in source instrument units. |
bids[22].priceNullable | DOUBLE | Bid price at level 23. Level 0 is the best price; storage is float64. |
bids[22].amountNullable | DOUBLE | Bid amount at level 23, in source instrument units. |
asks[23].priceNullable | DOUBLE | Ask price at level 24. Level 0 is the best price; storage is float64. |
asks[23].amountNullable | DOUBLE | Ask amount at level 24, in source instrument units. |
bids[23].priceNullable | DOUBLE | Bid price at level 24. Level 0 is the best price; storage is float64. |
bids[23].amountNullable | DOUBLE | Bid amount at level 24, in source instrument units. |
asks[24].priceNullable | DOUBLE | Ask price at level 25. Level 0 is the best price; storage is float64. |
asks[24].amountNullable | DOUBLE | Ask amount at level 25, in source instrument units. |
bids[24].priceNullable | DOUBLE | Bid price at level 25. Level 0 is the best price; storage is float64. |
bids[24].amountNullable | DOUBLE | Bid amount at level 25, in source instrument units. |
Sample records
BTCUSDT · illustrative values using the verified file columns. This reference does not confirm available download inventory.
[ { "exchange": "binance", "market": "futures", "symbol": "BTCUSDT", "timestamp": "1783728000000000", "local_timestamp": "1783728000012000", "is_snapshot": true, "side": "bid", "price": "64210.50", "amount": "0.142" }, { "exchange": "binance", "market": "futures", "symbol": "BTCUSDT", "timestamp": "1783728000100000", "local_timestamp": "1783728000112000", "is_snapshot": false, "side": "ask", "price": "64211.00", "amount": "0.272" }][ { "exchange": "binance", "market": "futures", "symbol": "BTCUSDT", "timestamp": "1783728000000000", "local_timestamp": "1783728000012000", "asks[0].price": "64211.00", "asks[0].amount": "0.142", "bids[0].price": "64210.00", "bids[0].amount": "0.142", "asks[1].price": "64211.50", "asks[1].amount": "0.152", "bids[1].price": "64209.50", "bids[1].amount": "0.152", "asks[2].price": "64212.00", "asks[2].amount": "0.162", "bids[2].price": "64209.00", "bids[2].amount": "0.162", "asks[3].price": "64212.50", "asks[3].amount": "0.172", "bids[3].price": "64208.50", "bids[3].amount": "0.172", "asks[4].price": "64213.00", "asks[4].amount": "0.182", "bids[4].price": "64208.00", "bids[4].amount": "0.182", "asks[5].price": "64213.50", "asks[5].amount": "0.192", "bids[5].price": "64207.50", "bids[5].amount": "0.192", "asks[6].price": "64214.00", "asks[6].amount": "0.202", "bids[6].price": "64207.00", "bids[6].amount": "0.202", "asks[7].price": "64214.50", "asks[7].amount": "0.212", "bids[7].price": "64206.50", "bids[7].amount": "0.212", "asks[8].price": "64215.00", "asks[8].amount": "0.222", "bids[8].price": "64206.00", "bids[8].amount": "0.222", "asks[9].price": "64215.50", "asks[9].amount": "0.232", "bids[9].price": "64205.50", "bids[9].amount": "0.232", "asks[10].price": "64216.00", "asks[10].amount": "0.242", "bids[10].price": "64205.00", "bids[10].amount": "0.242", "asks[11].price": "64216.50", "asks[11].amount": "0.252", "bids[11].price": "64204.50", "bids[11].amount": "0.252", "asks[12].price": "64217.00", "asks[12].amount": "0.262", "bids[12].price": "64204.00", "bids[12].amount": "0.262", "asks[13].price": "64217.50", "asks[13].amount": "0.272", "bids[13].price": "64203.50", "bids[13].amount": "0.272", "asks[14].price": "64218.00", "asks[14].amount": "0.282", "bids[14].price": "64203.00", "bids[14].amount": "0.282", "asks[15].price": "64218.50", "asks[15].amount": "0.292", "bids[15].price": "64202.50", "bids[15].amount": "0.292", "asks[16].price": "64219.00", "asks[16].amount": "0.302", "bids[16].price": "64202.00", "bids[16].amount": "0.302", "asks[17].price": "64219.50", "asks[17].amount": "0.312", "bids[17].price": "64201.50", "bids[17].amount": "0.312", "asks[18].price": "64220.00", "asks[18].amount": "0.322", "bids[18].price": "64201.00", "bids[18].amount": "0.322", "asks[19].price": "64220.50", "asks[19].amount": "0.332", "bids[19].price": "64200.50", "bids[19].amount": "0.332", "asks[20].price": "64221.00", "asks[20].amount": "0.342", "bids[20].price": "64200.00", "bids[20].amount": "0.342", "asks[21].price": "64221.50", "asks[21].amount": "0.352", "bids[21].price": "64199.50", "bids[21].amount": "0.352", "asks[22].price": "64222.00", "asks[22].amount": "0.362", "bids[22].price": "64199.00", "bids[22].amount": "0.362", "asks[23].price": "64222.50", "asks[23].amount": "0.372", "bids[23].price": "64198.50", "bids[23].amount": "0.372", "asks[24].price": "64223.00", "asks[24].amount": "0.382", "bids[24].price": "64198.00", "bids[24].amount": "0.382" }, { "exchange": "binance", "market": "futures", "symbol": "BTCUSDT", "timestamp": "1783728000100000", "local_timestamp": "1783728000112000", "asks[0].price": "64211.00", "asks[0].amount": "0.142", "bids[0].price": "64210.00", "bids[0].amount": "0.142", "asks[1].price": "64211.50", "asks[1].amount": "0.152", "bids[1].price": "64209.50", "bids[1].amount": "0.152", "asks[2].price": "64212.00", "asks[2].amount": "0.162", "bids[2].price": "64209.00", "bids[2].amount": "0.162", "asks[3].price": "64212.50", "asks[3].amount": "0.172", "bids[3].price": "64208.50", "bids[3].amount": "0.172", "asks[4].price": "64213.00", "asks[4].amount": "0.182", "bids[4].price": "64208.00", "bids[4].amount": "0.182", "asks[5].price": "64213.50", "asks[5].amount": "0.192", "bids[5].price": "64207.50", "bids[5].amount": "0.192", "asks[6].price": "64214.00", "asks[6].amount": "0.202", "bids[6].price": "64207.00", "bids[6].amount": "0.202", "asks[7].price": "64214.50", "asks[7].amount": "0.212", "bids[7].price": "64206.50", "bids[7].amount": "0.212", "asks[8].price": "64215.00", "asks[8].amount": "0.222", "bids[8].price": "64206.00", "bids[8].amount": "0.222", "asks[9].price": "64215.50", "asks[9].amount": "0.232", "bids[9].price": "64205.50", "bids[9].amount": "0.232", "asks[10].price": "64216.00", "asks[10].amount": "0.242", "bids[10].price": "64205.00", "bids[10].amount": "0.242", "asks[11].price": "64216.50", "asks[11].amount": "0.252", "bids[11].price": "64204.50", "bids[11].amount": "0.252", "asks[12].price": "64217.00", "asks[12].amount": "0.262", "bids[12].price": "64204.00", "bids[12].amount": "0.262", "asks[13].price": "64217.50", "asks[13].amount": "0.272", "bids[13].price": "64203.50", "bids[13].amount": "0.272", "asks[14].price": "64218.00", "asks[14].amount": "0.282", "bids[14].price": "64203.00", "bids[14].amount": "0.282", "asks[15].price": "64218.50", "asks[15].amount": "0.292", "bids[15].price": "64202.50", "bids[15].amount": "0.292", "asks[16].price": "64219.00", "asks[16].amount": "0.302", "bids[16].price": "64202.00", "bids[16].amount": "0.302", "asks[17].price": "64219.50", "asks[17].amount": "0.312", "bids[17].price": "64201.50", "bids[17].amount": "0.312", "asks[18].price": "64220.00", "asks[18].amount": "0.322", "bids[18].price": "64201.00", "bids[18].amount": "0.322", "asks[19].price": "64220.50", "asks[19].amount": "0.332", "bids[19].price": "64200.50", "bids[19].amount": "0.332", "asks[20].price": "64221.00", "asks[20].amount": "0.342", "bids[20].price": "64200.00", "bids[20].amount": "0.342", "asks[21].price": "64221.50", "asks[21].amount": "0.352", "bids[21].price": "64199.50", "bids[21].amount": "0.352", "asks[22].price": "64222.00", "asks[22].amount": "0.362", "bids[22].price": "64199.00", "bids[22].amount": "0.362", "asks[23].price": "64222.50", "asks[23].amount": "0.372", "bids[23].price": "64198.50", "bids[23].amount": "0.372", "asks[24].price": "64223.00", "asks[24].amount": "0.382", "bids[24].price": "64198.00", "bids[24].amount": "0.382" }]Storage and interpretation
incremental_book_L2 has one bid/ask price level per row and an is_snapshot flag. Apply all snapshot rows together; amount=0 removes an incremental level. book_snapshot_25 has one row per observed book, with 25 ask and bid levels in 100 price/amount columns plus five common columns. These files do not contain sequence IDs, so do not infer verified sequence continuity from this schema.