OHLCV Active Consolidated

CoinAPI

Trade-derived OHLCV bars available in period-specific CSV and Parquet files.

Get This Dataset

Category📊OHLCV

Update Frequencyhourly

SizeMedium

CoverageSupported exchanges and symbols with trade coverage

FormatsCSV.gz, Parquet

Overview

Trade-derived OHLCV bars available in period-specific CSV and Parquet files.

CoinAPI packages this dataset for teams that need analysis-ready market data with clear schema documentation, representative samples, and commercial access across CoinAPI datasets.

Product and Channel Availability

Where applicable for this dataset, access is available through: Flat Files (Snowflake, S3 Pull, S3 Push, GCS Push), REST API, Market Data API, WebSocket API (v1, v2), FIX API.

File Format

Formats: CSV.gz, Parquet
Refresh frequency: hourly
Size profile: Medium

Coverage

Supported exchanges and symbols with trade coverage

Data Structure

ohlcv: Trade-derived OHLCV bars.

The schema and sample rows below document the available fields, data types, nullability, and example values for this dataset.

Tables

Column	Type	Nullable	Description	Example
exchange_id	`string`	No	Exchange identifier.	`COINBASE`
date	`date`	No	ISO calendar date.	`2026-03-24`
date_str	`string`	No	Date in YYYYMMDD format.	`20260324`
time_period	`string`	No	Aggregation period, such as 1MIN.	`1MIN`
symbol_id_int	`number`	No	Numeric CoinAPI symbol identifier.	`12345`
time_period_start	`timestamp`	No	Inclusive bar start time.	`2026-03-24T13:15:00.0000000`
time_period_end	`timestamp`	No	Inclusive bar end time.	`2026-03-24T13:15:59.9999999`
time_open	`timestamp`	No	Timestamp of the first trade in the bar.	`2026-03-24T13:15:01.0020000`
time_close	`timestamp`	No	Timestamp of the last trade in the bar.	`2026-03-24T13:15:58.9910000`
px_open	`number`	Yes	Opening price.	`67230.1`
px_high	`number`	Yes	Highest traded price in the bar.	`67241.5`
px_low	`number`	Yes	Lowest traded price in the bar.	`67228.9`
px_close	`number`	Yes	Closing price.	`67234.12`
sx_cnt	`number`	No	Trade count in the bar.	`184`
sx_sum	`number`	No	Sum of traded size in the bar.	`12.8745`

Sample Data

ohlcv

exchange_id	date	date_str	time_period	symbol_id_int	time_period_start	time_period_end	time_open	time_close	px_open	px_high	px_low	px_close	sx_cnt	sx_sum
COINBASE	2026-03-24	20260324	1MIN	12345	2026-03-24T13:15:00.0000000	2026-03-24T13:15:59.9999999	2026-03-24T13:15:01.0020000	2026-03-24T13:15:58.9910000	67230.1	67241.5	67228.9	67234.12	184	12.8745