> ## 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 varies by venue** — major venues reach back to 2013–2014, while newer venues start in 2026. See [Venues supported](#venues-supported) for the earliest available date per venue.
</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

The **Data since** column shows the earliest daily candle available for each `venue`.

| Venue         | `venue`         | Data since     |
| ------------- | --------------- | -------------- |
| Kraken        | `kraken`        | September 2013 |
| Bitstamp      | `bitstamp`      | October 2014   |
| Coinbase      | `coinbase`      | December 2014  |
| Binance       | `binance`       | July 2017      |
| Gate.io       | `gate`          | November 2017  |
| OKX           | `okx`           | December 2017  |
| Crypto.com    | `cryptodotcom`  | October 2021   |
| Bullish       | `bullish`       | November 2021  |
| Bybit         | `bybit`         | March 2022     |
| Deribit       | `deribit`       | January 2024   |
| Bitget        | `bitget`        | March 2026     |
| BitMart       | `bitmart`       | March 2026     |
| KuCoin        | `kucoin`        | March 2026     |
| MEXC          | `mexc`          | March 2026     |
| Pionex        | `pionex`        | March 2026     |
| Poloniex      | `poloniex`      | March 2026     |
| Backpack      | `backpack`      | March 2026     |
| Binance.US    | `binanceusa`    | March 2026     |
| Bitso         | `bitso`         | March 2026     |
| Bitvavo       | `bitvavo`       | March 2026     |
| CEX.IO        | `cexio`         | March 2026     |
| Luno          | `luno`          | April 2026     |
| Upbit         | `upbit`         | April 2026     |
| WhiteBIT      | `whitebit`      | April 2026     |
| HashKey       | `hashkey`       | April 2026     |
| itBit         | `itbit`         | April 2026     |
| LMAX Digital  | `lmax`          | April 2026     |
| Binance Alpha | `binance-alpha` | June 2026      |