> ## 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.

# OHLCV by Venue

> 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.

<Warning>
  **Beta Product**

  This 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.
</Warning>

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

| 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:

```sql theme={null}
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