Trades Samples
Explore sample Trades flat file data, including preview rows and downloadable datasets for testing.
Trades Data Samples
The Trades flat files provide details of executed transactions across supported exchanges. Each row represents a single trade, including essential fields such as price, size, trade direction, and timestamps.
These samples allow you to:
- Inspect the file structure and column layout.
- Preview the first few rows of real trade data.
- Download an extended sample file for deeper testing.
File Structure
Trade files use the same path layout in both buckets; the bucket and partition date determine which dataset you are reading.
T-TRADES/
└── D-{YYYYMMDD | YYYYMMDDHH}/
└── E-[EXCHANGE]/
└── IDDI-[IDENTIFIER]+SC-[COINAPI_SYMBOL_ID]+S-[EXCHANGE_SYMBOL].csv.gzExamples:
T-TRADES/D-2025090112/E-BINANCE/IDDI-138123+SC-BINANCE_SPOT_BTC_USDT+S-BTCUSDT.csv.gz — hourly partition in coinapi
T-TRADES/D-20250901/E-BYBIT/IDDI-5763642+SC-BYBIT_PERP_BTC_USDT+S-BTCUSDT.csv.gz — legacy daily partition in coinapi
Data Samples (First 10 Rows)
File Location: T-TRADES/D-2025090112/E-BINANCE/IDDI-138123+SC-BINANCE_SPOT_BTC_USDT+S-BTCUSDT.csv.gz
Symbol Type: SPOT
File Preview:
time_exchange;time_coinapi;guid;price;base_amount;taker_side;id_exch_guid;id_exch_int_inc;order_id_maker;order_id_taker
2025-09-01T00:00:00.1780000;2025-09-01T00:00:00.2998242;8a61934b-2ca0-4e94-b4ec-cb5409a28c53;108246.36;0.00023;BUY;;5205379727;;
2025-09-01T00:00:00.3360000;2025-09-01T00:00:00.4577685;2e4c3a07-0a44-46f9-b247-ac9c09f2ebc7;108246.36;0.00027;BUY;;5205379728;;
2025-09-01T00:00:00.3960000;2025-09-01T00:00:00.5178241;c108ba4f-f0cf-4a15-84fe-156838285afc;108246.36;0.00046;BUY;;5205379729;;
2025-09-01T00:00:00.5550000;2025-09-01T00:00:00.6768373;696237f5-5341-49d0-a358-2f17230f9fb9;108246.36;0.00711;BUY;;5205379730;;
2025-09-01T00:00:00.6210000;2025-09-01T00:00:00.7428083;25ecc252-97c4-4975-a4c3-6819b09701ab;108246.36;0.00006;BUY;;5205379731;;
2025-09-01T00:00:00.8420000;2025-09-01T00:00:00.9637713;30b5fffc-1a01-4801-be8e-84380bd06efa;108246.36;0.001;BUY;;5205379732;;
2025-09-01T00:00:00.9870000;2025-09-01T00:00:01.1097964;77c53316-7669-4253-a67e-74e626c63da6;108246.36;0.0001;BUY;;5205379733;;
2025-09-01T00:00:01.1140000;2025-09-01T00:00:01.2358517;85b8e278-d6db-4b6c-a44d-e9412e5bf9d9;108246.36;0.00009;BUY;;5205379734;;
2025-09-01T00:00:01.1710000;2025-09-01T00:00:01.2927324;86a1bfe4-e4fa-40f2-b507-09d23649505e;108246.36;0.01274;BUY;;5205379735;;
2025-09-01T00:00:01.1790000;2025-09-01T00:00:01.3017914;cb9a1ae7-319a-4834-b7c7-c826c3af15bd;108246.35;0.00005;SELL;;5205379736;;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-TRADES/D-20250901/E-BYBIT/IDDI-5763642+SC-BYBIT_PERP_BTC_USDT+S-BTCUSDT.csv.gz
Symbol Type: PERPETUAL
File Preview:
time_exchange;time_coinapi;guid;price;base_amount;taker_side;id_exch_guid;id_exch_int_inc;order_id_maker;order_id_taker
2025-09-01T00:00:00.0990000;2025-09-01T00:00:00.3189043;c2b5a58f-e702-4e7d-95c4-450404743836;108200;0.045;BUY;d3e280bb-03b1-5708-833a-ef1d9e49fccc;;;
2025-09-01T00:00:00.1650000;2025-09-01T00:00:00.3988325;2bc94549-8878-45ae-b862-557996e25b26;108199.9;0.001;SELL;798911c5-f0f4-52b6-ba22-5b87363db71e;;;
2025-09-01T00:00:00.2730000;2025-09-01T00:00:00.4161495;70b8d0b1-8157-41ce-8057-0eacf6a5c030;108200;0.001;BUY;dc756ac4-cea5-502d-8557-a991052f0541;;;
2025-09-01T00:00:00.2930000;2025-09-01T00:00:00.4186887;720dd28d-1abd-41f5-9a72-60c5ede3399e;108199.9;0.3;SELL;112d6e48-7308-550d-8331-4953d4d1f707;;;
2025-09-01T00:00:00.3000000;2025-09-01T00:00:00.4188298;c0cc9bd3-f20b-4c0c-9527-e87b7d81de97;108199.9;0.3;SELL;681b9e49-cb54-5e8e-b25f-81239e234cac;;;
2025-09-01T00:00:00.3030000;2025-09-01T00:00:00.4215246;461d4283-a98f-455e-9e87-0a1cd3ac4c92;108199.9;0.082;SELL;adac4979-0612-5a3a-8f8d-83314376fac4;;;
2025-09-01T00:00:00.3030000;2025-09-01T00:00:00.4215246;07b8a2e2-08b2-4a33-8974-ea88608b1553;108199.9;0.141;SELL;3f788e0b-d77d-5fae-a241-788d52f9da3f;;;
2025-09-01T00:00:00.3030000;2025-09-01T00:00:00.4215246;9ae587b0-0c07-4a4b-bd7d-e6c112651679;108199.9;0.077;SELL;0b56f511-617d-5712-b640-7240618f4438;;;
2025-09-01T00:00:00.3340000;2025-09-01T00:00:00.4278393;8e8c2be2-9e99-45e5-91e4-319e32085ebb;108199.9;0.005;SELL;c14a55c3-0087-5197-9911-0b644e1f3de7;;;
2025-09-01T00:00:00.3540000;2025-09-01T00:00:00.4390493;11eaf8e2-2230-4c3e-9ef3-947b73675d29;108199.9;0.271;SELL;c9e194ef-cd3b-50c3-81e4-6a9e29d50ad6;;;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-TRADES/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;guid;price;base_amount;taker_side;id_exch_guid;id_exch_int_inc;order_id_maker;order_id_taker
2025-09-01T00:01:18.9170000;2025-09-01T00:01:19.0392119;bf219434-7635-428a-8995-dc1559f32104;4404.43;250;BUY;;2879625;;
2025-09-01T00:01:43.0970000;2025-09-01T00:01:43.1629105;424f32fe-cafa-4c3d-8278-752881a7a66a;4405.22;250;BUY;;2879626;;
2025-09-01T00:02:04.2800000;2025-09-01T00:02:04.3664934;b90fba61-9673-493e-83f3-b75e82fd87dd;4403.47;4;BUY;;2879627;;
2025-09-01T00:02:12.8800000;2025-09-01T00:02:12.9171410;39934bdd-f7d0-4cc6-a421-5b0781c9c3f3;4400.72;4;BUY;;2879628;;
2025-09-01T00:02:14.4300000;2025-09-01T00:02:14.5069316;4b2c9d81-532e-4e65-a6f7-8c9808f5fbf2;4400.31;4;BUY;;2879629;;
2025-09-01T00:02:15.4400000;2025-09-01T00:02:15.4752687;7e3a75cd-1504-4915-a230-3e62feb76fb3;4400.62;4;BUY;;2879630;;
2025-09-01T00:02:16.8590000;2025-09-01T00:02:16.8955796;0aae2dfe-45a7-44ed-b136-43e2a9ed74cd;4400.62;4;BUY;;2879631;;
2025-09-01T00:02:47.3670000;2025-09-01T00:02:47.5680482;16e5addb-838b-4ea8-ae4e-dff7c7c56382;4402.5;68;BUY;;2879632;;
2025-09-01T00:02:47.3670000;2025-09-01T00:02:47.5680782;427b8aab-6e26-4fe8-9826-a50dadcb8583;4402.51;250;BUY;;2879633;;
2025-09-01T00:03:05.5300000;2025-09-01T00:03:05.6280097;b94b9568-c82d-4912-9fa9-93b189fdc13e;4402.62;32;BUY;;2879634;;A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
File Location: T-TRADES/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;guid;price;base_amount;taker_side;id_exch_guid;id_exch_int_inc;order_id_maker;order_id_taker
2025-09-01T00:24:42.9600000;2025-09-01T00:24:43.2502543;265a6f82-550b-4e63-86bc-89352c040613;470;0.04;SELL;;114;;
2025-09-01T00:24:43.0610000;2025-09-01T00:24:43.4207657;11fb8d76-2570-4ea1-b887-64bc178aea88;470;0.11;SELL;;115;;
2025-09-01T00:24:43.1940000;2025-09-01T00:24:43.4734356;d99f3ceb-4e61-40ad-8a34-4d6f5ef7c267;470;0.11;SELL;;116;;
2025-09-01T00:24:43.4130000;2025-09-01T00:24:43.6776299;0d77190a-b02e-42d3-8025-ba5651bbca92;470;0.08;SELL;;117;;
2025-09-01T00:24:43.5140000;2025-09-01T00:24:43.7379430;989c45c8-677a-4957-91d8-1a032025609a;470;0.08;SELL;;118;;
2025-09-01T00:25:20.3340000;2025-09-01T00:25:20.8039231;7e75eeac-3180-4fdc-9f52-85eea8d31206;470;0.01;SELL;;119;;
2025-09-01T00:27:16.7100000;2025-09-01T00:27:16.9900555;e77b0970-dac2-4e87-8e26-abb46d5517eb;465;0.06;SELL;;120;;
2025-09-01T00:27:18.7450000;2025-09-01T00:27:18.9910879;e3b44a31-8252-4f2c-af9e-7e151fd58a5a;465;0.1;SELL;;121;;
2025-09-01T00:27:32.5060000;2025-09-01T00:27:41.4380713;0c2a0eba-6dc6-4d35-92c6-0094e10b1bd8;465;0.04;SELL;;122;;
2025-09-01T00:27:32.6080000;2025-09-01T00:28:10.0092890;9c2d8315-4f46-4c80-8556-f1b620cdc2da;465;0.12;SELL;;123;;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.