Full Limit Order Book Samples
Explore sample Full Limit Order Book flat file data, including preview rows and downloadable datasets for testing.
Full Limit Order Book Data Samples
The Full Limit Order Book flat files provide a comprehensive view of the order book for a specific trading pair on an exchange. It captures all changes to the order book, allowing for a detailed reconstruction of the market state at any given moment.
These samples allow you to:
- Inspect the file structure and column layout.
- Preview the first few rows of real data.
- Download an extended sample file for deeper testing.
File Structure
Full Limit Order Book files use the same path layout in both buckets; the bucket and partition date determine which dataset you are reading.
T-LIMITBOOK_FULL/
└── D-{YYYYMMDD | YYYYMMDDHH}/
└── E-[EXCHANGE]/
└── IDDI-[IDENTIFIER]+SC-[COINAPI_SYMBOL_ID]+S-[EXCHANGE_SYMBOL].csv.gzExamples:
T-LIMITBOOK_FULL/D-20250901/E-BINANCE/IDDI-138123+SC-BINANCE_SPOT_BTC_USDT+S-BTCUSDT.csv.gz — legacy daily partition in coinapi
T-LIMITBOOK_FULL/D-2026011722/E-COINBASE/IDDI-6002426+SC-COINBASE_SPOT_AVAX_USD+S-AVAX__002DUSD.csv.gz — hourly partition in coinapi
Data Samples (First 10 Rows)
File Location: T-LIMITBOOK_FULL/D-20250901/E-BINANCE/IDDI-138123+SC-BINANCE_SPOT_BTC_USDT+S-BTCUSDT.csv.gz
Symbol Type: SPOT
File Preview:
time_exchange;time_coinapi;update_type;is_buy;entry_px;entry_sx;order_id
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;0;108246.36;6.61982;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;1;108246.35;3.35184;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;0;108246.37;0.04719;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;1;108246.34;0.00055;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;0;108246.48;0.00005;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;1;108246.01;0.00005;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;0;108246.49;0.05618;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;1;108246;0.04435;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;0;108246.5;0.00005;
00:00:00.0140000;00:00:00.1353783;SNAPSHOT;1;108245.28;0.00005;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-LIMITBOOK_FULL/D-20250901/E-BYBIT/IDDI-5763642+SC-BYBIT_PERP_BTC_USDT+S-BTCUSDT.csv.gz
Symbol Type: PERPETUAL
File Preview:
time_exchange;time_coinapi;update_type;is_buy;entry_px;entry_sx;order_id
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;0;108200;11.182;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;1;108199.9;10.211;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;0;108200.1;0.002;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;1;108199.8;0.001;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;0;108200.4;0.001;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;1;108199.4;0.001;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;0;108200.5;0.001;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;1;108198.9;0.001;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;0;108201.1;0.048;
00:00:00.0270000;00:00:00.0270000;SNAPSHOT;1;108198.2;0.924;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-LIMITBOOK_FULL/D-20250901/E-OKEX/IDDI-37803609+SC-OKEX_FTS_ETH_USD_250926+S-ETH__002DUSD__002D250926.csv.gz
Symbol Type: FUTURES
File Preview:
time_exchange;time_coinapi;update_type;is_buy;entry_px;entry_sx;order_id
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;0;4406.57;71;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;1;4406.56;34;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;0;4406.59;20;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;1;4406.14;22;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;0;4406.86;2;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;1;4405.99;52;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;0;4406.95;2;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;1;4405.88;2;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;0;4407.05;97;
00:00:00.0050000;00:00:00.0050000;SNAPSHOT;1;4405.74;97;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-LIMITBOOK_FULL/D-20250901/E-BINANCEOPT/IDDI-46273375+SC-BINANCEOPT_OPT_BTC_USDT_250902_109000_C+S-BTC__002D250902__002D109000__002DC.csv.gz
Symbol Type: OPTION
File Preview:
time_exchange;time_coinapi;update_type;is_buy;entry_px;entry_sx;order_id
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;0;615;5;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;1;605;1;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;0;620;0.87;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;1;600;1.99;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;0;625;3;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;1;595;5.83;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;0;630;1.83;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;1;555;0.1;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;0;635;2.09;
00:00:01.1800000;00:00:01.4174588;SNAPSHOT;1;550;5;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
[!NOTE]
The downloadable files are still not the full flat files, but it provides more rows than the preview to help test ingestion pipelines and parsing logic.