Beta ProductThis product is currently in beta. The schema and data may change as we refine our methodology.Historical coverage: CEX data is currently available from April 2026 onward only.We are actively backfilling these schemas; older history and fuller coverage will appear over time.
Available Tables
| Table | Granularity | Description |
|---|
cex.prices.ohlcv_5min_beta | 5-minute | 5-minute candlesticks by venue (one row per venue, pair, 5-min window) |
cex.prices.ohlcv_hourly_beta | Hourly | Hourly candlesticks by venue (one row per venue, pair, hour) |
cex.prices.ohlcv_daily_beta | Daily | Daily candlesticks by venue (one row per venue, pair, day) |
cex.prices.ohlcv_weekly_beta | Weekly | Weekly candlesticks by venue (one row per venue, pair, week) |
cex.prices.ohlcv_monthly_beta | Monthly | Monthly candlesticks by venue (one row per venue, pair, month) |
Sample Query
Get hourly BTC/USD prices from Coinbase for the past 7 days:
select
timestamp,
venue,
base_asset,
quote_asset,
open,
high,
low,
close,
volume,
volume_quote
from cex.prices.ohlcv_hourly_beta
where base_asset = 'BTC'
and quote_asset = 'USD'
and venue = 'coinbase'
and timestamp >= current_date - 7
order by timestamp desc
Table Columns
Unique Key: timestamp, base_asset, quote_asset, venue, granularity
| Column | Data Type | Description |
|---|
timestamp | TIMESTAMP_NTZ(9) | Start of the candle window (UTC, truncated to the candle boundary) |
base_asset | VARCHAR | Base asset of the trading pair (e.g. BTC, ETH) |
quote_asset | VARCHAR | Quote asset of the trading pair (e.g. USD, USDC) |
venue | VARCHAR | CEX venue identifier (e.g. coinbase, kraken, binance) |
granularity | VARCHAR | Candle granularity label (5min, 1h, 1d, 1w, 1m) |
open | FLOAT | First trade price within the candle period |
high | FLOAT | Highest trade price within the candle period |
low | FLOAT | Lowest trade price within the candle period |
close | FLOAT | Last trade price within the candle period |
volume | FLOAT | Total base asset volume traded within the candle period |
volume_quote | FLOAT | Total notional volume in quote asset (sum of price × quantity) within the candle period |
trade_count | INTEGER | Number of individual trades aggregated into this candle |
_created_at | TIMESTAMP_NTZ(9) | Row creation timestamp |
_updated_at | TIMESTAMP_NTZ(9) | Row last-update timestamp |
Venues Supported
- backpack
- binance
- binanceusa
- bitget
- bitmart
- bitso
- bitstamp
- bitvavo
- bullish
- bybit
- cexio
- coinbase
- deribit
- gate
- kraken
- kucoin
- luno
- mexc
- okx
- pionex
- poloniex
- upbit
- whitebit
