Quotes Samples
Explore sample Quotes flat file data, including preview rows and downloadable datasets for testing.
Quotes Data Samples
The Quotes flat files provide information about the best bid and ask prices for a specific trading pair on an exchange. This data is crucial for understanding the current state of the market and the spread between buy and sell orders.
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
Quote files use the same path layout in both buckets; the bucket and partition date determine which dataset you are reading.
T-QUOTES/
└── D-{YYYYMMDD | YYYYMMDDHH}/
└── E-[EXCHANGE]/
└── IDDI-[IDENTIFIER]+SC-[COINAPI_SYMBOL_ID]+S-[EXCHANGE_SYMBOL].csv.gzExamples:
T-QUOTES/D-20250901/E-BINANCE/IDDI-138123+SC-BINANCE_SPOT_BTC_USDT+S-BTCUSDT.csv.gz — legacy daily partition in coinapi
T-QUOTES/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-QUOTES/D-20250901/E-BINANCE/IDDI-138123+SC-BINANCE_SPOT_BTC_USDT+S-BTCUSDT.csv.gz
Symbol Type: SPOT
File Preview:
id_site_coinapi;time_exchange;time_coinapi;ask_px;ask_sx;bid_px;bid_sx
;2025-09-01T00:00:00.1140000;2025-09-01T00:00:00.2350442;108246.36;6.61982;108246.35;3.26623
;2025-09-01T00:00:00.2140000;2025-09-01T00:00:00.3352338;108246.36;6.61959;108246.35;3.26613
;2025-09-01T00:00:00.4140000;2025-09-01T00:00:00.5350984;108246.36;6.63886;108246.35;1.64421
;2025-09-01T00:00:00.5140000;2025-09-01T00:00:00.6352523;108246.36;6.63886;108246.35;1.62736
;2025-09-01T00:00:00.6140000;2025-09-01T00:00:00.7350581;108246.36;6.63175;108246.35;1.62736
;2025-09-01T00:00:00.7140000;2025-09-01T00:00:00.8352466;108246.36;6.63169;108246.35;1.62736
;2025-09-01T00:00:00.8140000;2025-09-01T00:00:00.9351643;108246.36;6.63169;108246.35;1.56053
;2025-09-01T00:00:00.9140000;2025-09-01T00:00:01.0350801;108246.36;6.69374;108246.35;0.745
;2025-09-01T00:00:01.0140000;2025-09-01T00:00:01.1352831;108246.36;6.95099;108246.35;0.76093
;2025-09-01T00:00:01.1140000;2025-09-01T00:00:01.2351738;108246.36;6.95099;108246.35;1.33273A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-QUOTES/D-20250901/E-BYBIT/IDDI-5763642+SC-BYBIT_PERP_BTC_USDT+S-BTCUSDT.csv.gz
Symbol Type: PERPETUAL
File Preview:
id_site_coinapi;time_exchange;time_coinapi;ask_px;ask_sx;bid_px;bid_sx
;2025-09-01T00:00:00.0270000;2025-09-01T00:00:00.0270000;108200;11.182;108199.9;10.211
;2025-09-01T00:00:00.1280000;2025-09-01T00:00:00.1280000;108200;10.137;108199.9;10.193
;2025-09-01T00:00:00.2270000;2025-09-01T00:00:00.2270000;108200;10.137;108199.9;10.192
;2025-09-01T00:00:00.3280000;2025-09-01T00:00:00.3280000;108200;10.14;108199.9;9.292
;2025-09-01T00:00:00.4280000;2025-09-01T00:00:00.4280000;108196.7;15.733;108196.6;0.26
;2025-09-01T00:00:00.5270000;2025-09-01T00:00:00.5270000;108196.7;9.507;108196.6;0.26
;2025-09-01T00:00:00.6270000;2025-09-01T00:00:00.6270000;108196.7;9.507;108196.6;0.308
;2025-09-01T00:00:00.7270000;2025-09-01T00:00:00.7270000;108196.7;9.509;108196.6;0.308
;2025-09-01T00:00:00.8270000;2025-09-01T00:00:00.8270000;108193.4;11.133;108193.3;0.189
;2025-09-01T00:00:00.9290000;2025-09-01T00:00:00.9290000;108193.4;10.203;108193.3;0.221A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-QUOTES/D-20250901/E-OKEX/IDDI-37803609+SC-OKEX_FTS_ETH_USD_250926+S-ETH__002DUSD__002D250926.csv.gz
Symbol Type: FUTURES
File Preview:
id_site_coinapi;time_exchange;time_coinapi;ask_px;ask_sx;bid_px;bid_sx
;2025-09-01T00:00:00.0050000;2025-09-01T00:00:00.0050000;4406.57;71;4406.56;34
;2025-09-01T00:00:00.2050000;2025-09-01T00:00:00.2050000;4406.2;71;4406.16;34
;2025-09-01T00:00:00.3050000;2025-09-01T00:00:00.3050000;4406.2;319;4406.19;134
;2025-09-01T00:00:00.3300000;2025-09-01T00:00:01.4226209;4406.2;0;4406.16;0
;2025-09-01T00:00:00.4050000;2025-09-01T00:00:00.4050000;4406.2;319;4406.19;134
;2025-09-01T00:00:00.5050000;2025-09-01T00:00:00.5050000;4406.02;71;4405.88;2
;2025-09-01T00:00:00.6050000;2025-09-01T00:00:00.6050000;4406.02;71;4406.01;273
;2025-09-01T00:00:00.7050000;2025-09-01T00:00:00.7050000;4406.02;71;4405.99;102
;2025-09-01T00:00:00.8050000;2025-09-01T00:00:00.8050000;4406.36;20;4405.91;2
;2025-09-01T00:00:00.8150000;2025-09-01T00:00:02.5584263;4406.02;0;4405.99;0A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-QUOTES/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:
id_site_coinapi;time_exchange;time_coinapi;ask_px;ask_sx;bid_px;bid_sx
;2025-09-01T00:00:01.1800000;2025-09-01T00:00:01.4174588;615;5;605;1
;2025-09-01T00:00:02.1860000;2025-09-01T00:00:02.4021362;615;5;600;1.03
;2025-09-01T00:00:04.8640000;2025-09-01T00:00:05.0667400;610;1.23;600;20.55
;2025-09-01T00:00:05.6890000;2025-09-01T00:00:06.3297681;615;1.64;605;1.39
;2025-09-01T00:00:07.6080000;2025-09-01T00:00:07.8485961;615;1.64;600;16.75
;2025-09-01T00:00:08.7680000;2025-09-01T00:00:08.9832128;610;1.43;605;1
;2025-09-01T00:00:09.7760000;2025-09-01T00:00:09.9660278;610;1.43;600;1.42
;2025-09-01T00:00:10.7430000;2025-09-01T00:00:11.2776484;610;0.1;595;1.21
;2025-09-01T00:00:14.0140000;2025-09-01T00:00:14.3599672;610;2.68;595;0.91
;2025-09-01T00:00:15.7220000;2025-09-01T00:00:15.9614196;605;2;595;0.91A 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.