OHLCV Data Samples
Explore sample OHLCV flat file data, including preview rows and downloadable datasets for testing.
OHLCV Data Samples
The OHLCV flat files contain aggregated candlestick data over multiple resolutions (1 second, 1 minute, 1 hour, 1 day). Each row summarises trading activity for a symbol within the time window.
These samples let you:
- Inspect the file layout and header schema.
- Preview real candlestick rows.
- Download a sample file (100 rows) to test your ETL pipeline.
File Structure
OHLCV files are stored only in the coinapi bucket under the active consolidated namespace.
T-OHLCV_ACTIVE_CONSOLIDATED/
└── D-YYYYMMDD/
└── E-[EXCHANGE]/
├── TP-1SEC.csv.gz # 1-second candles
├── TP-1MIN.csv.gz # 1-minute candles
├── TP-1HRS.csv.gz # 1-hour candles
└── TP-1DAY.csv.gz # 1-day candlesExample path for BITSTAMP on 11 Sep 2025:
T-OHLCV_ACTIVE_CONSOLIDATED/D-20250911/E-BITSTAMP/TP-1DAY.csv.gz
Data Samples (First 10 Rows – 1-DAY)
File Location: T-OHLCV_ACTIVE_CONSOLIDATED/D-20250911/E-BITSTAMP/TP-1DAY.csv.gz
symbol_id;time_period_start;time_period_end;time_open;time_close;px_open;px_high;px_low;px_close;sx_cnt;sx_sum
28962;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T00:09:59.0940000;2025-09-11T23:45:34.4680000;0.00002616;0.0000266;0.00002601;0.00002637;336;311129.52253198996
5960616;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T02:46:38.1600000;2025-09-11T22:16:12.4040000;0.67731;0.69377;0.67718;0.69105;20;18599.91622281
5960615;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T00:29:40.4330000;2025-09-11T23:20:56.9470000;0.78654;0.82999;0.78654;0.82999;31;33858.573104519994
5968362;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T16:09:43.3500000;2025-09-11T16:09:43.3500000;1;1;1;1;1;100.28572
5968363;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T01:18:29.7080000;2025-09-11T23:30:14.6410000;2.98968;3.05083;2.98968;3.05083;6;1474.43175271
5968361;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T00:00:09.6540000;2025-09-11T23:44:15.7310000;0.85437;0.85686;0.85175;0.85223;1752;1368206.4252600016
5968795;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T04:05:05.5740000;2025-09-11T17:21:32.2170000;0.08388;0.08467;0.08387;0.08428;7;6664.761867159999
5968794;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T03:23:49.8240000;2025-09-11T22:20:17.6040000;0.09855;0.09957;0.09676;0.09957;7;55950.288868229996
5985325;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T11:23:24.2080000;2025-09-11T22:52:41.6570000;0.64582;0.70424;0.64582;0.7;5;2464.8122367
5968562;2025-09-11T00:00:00.0000000;2025-09-12T00:00:00.0000000;2025-09-11T02:36:45.0320000;2025-09-11T23:19:12.7730000;37.93;38.64;37.62;38.64;11;4.57320563A larger sample file (100 rows) is available for download here: Download Sample (100 rows)
The downloadable file is a subset designed for quick experiments; it is not the full daily file.
symbol_id corresponds to symbol_id_int provided by GET /v1/metadata/symbols/history in the Market Data REST API for the respective exchange.