Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

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.
OHLCV (Open, High, Low, Close, Volume) candlestick data aggregated from CEX spot trades, broken down by individual exchange venue. Each row represents a single trading pair on a single exchange during a specific time window. Use these tables for exchange-specific price analysis, comparing prices across venues, or as the source for cross-venue aggregation.

​
Available Tables

TableGranularityDescription
cex.prices.ohlcv_5min_beta5-minute5-minute candlesticks by venue (one row per venue, pair, 5-min window)
cex.prices.ohlcv_hourly_betaHourlyHourly candlesticks by venue (one row per venue, pair, hour)
cex.prices.ohlcv_daily_betaDailyDaily candlesticks by venue (one row per venue, pair, day)
cex.prices.ohlcv_weekly_betaWeeklyWeekly candlesticks by venue (one row per venue, pair, week)
cex.prices.ohlcv_monthly_betaMonthlyMonthly 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
ColumnData TypeDescription
timestampTIMESTAMP_NTZ(9)Start of the candle window (UTC, truncated to the candle boundary)
base_assetVARCHARBase asset of the trading pair (e.g. BTC, ETH)
quote_assetVARCHARQuote asset of the trading pair (e.g. USD, USDC)
venueVARCHARCEX venue identifier (e.g. coinbase, kraken, binance)
granularityVARCHARCandle granularity label (5min, 1h, 1d, 1w, 1m)
openFLOATFirst trade price within the candle period
highFLOATHighest trade price within the candle period
lowFLOATLowest trade price within the candle period
closeFLOATLast trade price within the candle period
volumeFLOATTotal base asset volume traded within the candle period
volume_quoteFLOATTotal notional volume in quote asset (sum of price × quantity) within the candle period
trade_countINTEGERNumber of individual trades aggregated into this candle
_created_atTIMESTAMP_NTZ(9)Row creation timestamp
_updated_atTIMESTAMP_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