BitqueryBitqueryData Store
Multi-chain logoMulti-chainOHLCV

Token Price History Hourly

Hourly USD price history for the 1,000 most traded DEX tokens on ten chains, up to 12 months, one row per token and hour.

Coverage
Last 12 monthsto Oct 8, 2026 · yesterday
Rows
≈7.4Mrows · estimate
Tokens
≈1Kdistinct · estimate
Table
1token_ohlcv_1h
Columns
16typed
Coverage ends yesterday, UTC

Overview

We build one USD candle per token and hour from decoded DEX trades, for the 1,000 tokens with the highest trading volume over the window you buy, on Solana, BNB Smart Chain, Base, Ethereum, Polygon, Arbitrum, Optimism, Tron, Robinhood Chain and Arc. The file holds price and volume only: no market cap or supply columns. A row is one token in one UTC hour.

Most buyers filter Token_Id and order by Interval_Time_Start to get a candle series. Hours with no trade have no row, so reindex to a full hourly grid before computing returns.

Use cases

  • Backtests on a year of hourly bars with volume
  • Hourly return and correlation matrices across tokens and chains
  • Intraday seasonality studies over many months
  • Comparing the same coin's price across chains hour by hour

Table

16 columns · free sample for the table

token_ohlcv_1h

16 columns

One row per token and UTC hour: USD open, high, low and close, and volume.

multichain/price_history/token_ohlcv_1h<YYYY-MM-DD>.parquetone file per UTC day

Schema reference

copies a column name
16 columns
ColumnTypeDescription
Block_DateDateUTC day of the bar
Interval_Time_StartDateTimeUTC start of the bar
Token_NetworkStringChain the token trades on
Token_AddressStringToken contract or mint address; empty for a chain's native coin
Token_IdStringBitquery token id, the chain prefix plus the address; the join key
Token_SymbolStringSymbol reported by the token; not unique
Token_NameStringName reported by the token; not unique
Token_IsNativeBoolTrue for a chain's native coin
Currency_IdStringBitquery currency id that groups this token with its copies on other chains
Currency_SymbolStringSymbol of that currency
Price_Ohlc_OpenFloat64First USD price in the hour
Price_Ohlc_HighFloat64Highest USD price in the hour
Price_Ohlc_LowFloat64Lowest USD price in the hour
Price_Ohlc_CloseFloat64Last USD price in the hour
Volume_UsdFloat64USD value traded in the hour
Volume_BaseFloat64Amount of the token traded in the hour, decimal adjusted
Sample file

Ask an AI about this data

Send this dataset’s full schema to an assistant and ask it anything. It reads the plain-text brief first, so the answer comes from the real column list rather than a guess.

Start with

Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.

Delivery

Parquet files in a Requester Pays S3 bucket or a Cloudflare R2 bucket, chosen at checkout. On S3 you download with your own AWS account and AWS bills the transfer; on R2 you download with a read-only API key and pay no egress. Layout:

# token_ohlcv_1h: one file per UTC day
multichain/price_history/token_ohlcv_1h<YYYY-MM-DD>.parquet
  1. Download a free sampleNo email needed.
  2. Pay nowName, work email and licence check.
  3. Pay the invoiceBy card or bank transfer.
  4. Download from S3 or R2The team prepares the export and emails the bucket path, plus a read-only API key for R2 orders.

Time windows

Every window includes 16 columns. Only the time range changes.

183 days
Last 6 months
Apr 8, 2026 → Oct 8, 2026
$1,500
Pay now
365 days
Last 12 months
Oct 8, 2025 → Oct 8, 2026
$3,000
Pay now
In every window
  • The token_ohlcv_1h table, 16 columns
  • Parquet files in the layout under Delivery
  • S3 or R2 download, chosen at checkout
  • Licensed under the Data License

FAQ

9 questions
What is in Token Price History Hourly?

One Parquet table, token_ohlcv_1h, with 16 columns: the hour, the token and its chain, USD open, high, low and close, and USD and token volume.

How big is it?

About 7.4 million rows for 12 months and half that for 6. This is an estimate scaled from the latest 30 days, which hold about 617,000 rows; exact figures arrive with the delivery manifest.

Which tokens and chains are included?

The 1,000 tokens with the highest USD trading volume over the window you buy, on Solana, BNB Smart Chain, Base, Ethereum, Polygon, Arbitrum, Optimism, Tron, Robinhood Chain and Arc. The list is fixed when your order is built and shipped inside the files.

How far back does it go?

You choose 6 or 12 months at checkout. Each order is built once, when you buy, and covers the 6 or 12 months up to the latest full UTC day. It is a fixed set of files and does not update afterwards. A chain younger than the window is covered from its first block, so a chain that launched three months ago has three months of rows.

How are the candles produced, and how was the sample checked?

Candles are built from decoded DEX trades on each chain, priced in USD at trade time. No market cap or supply figures are included, which is what lets this dataset reach back a year. We read the published sample back before release: no duplicate bars, no blank names, and no bar with a high below its low.

What was left out, and why?

Market cap and supply columns, trades on centralized exchanges, and hours with no trade, which have no row. Nothing is forward filled.

What should I watch out for?

Symbols and names repeat, so join on Token_Id. The same coin appears once per chain under a different Token_Id; Currency_Id groups those copies. These are DEX prices: for widely traded coins they follow exchange prices closely, and for a thinly traded token a bar can be missing.

How do I load it?

One line in DuckDB: SELECT * FROM read_parquet('token_ohlcv_1h/*.parquet') LIMIT 10. Pandas works too: pandas.read_parquet(path). The sample file opens without credentials.

How current is it, and how is it delivered?

Each order is built once, when you buy, and covers the 6 or 12 months up to the latest full UTC day. It is a fixed set of files and does not update afterwards. Delivered as Parquet with ZSTD compression, one file per day, under a stable layout with a JSON manifest listing every file and its sha256. We prepare the files within 7 business days of purchase and email you the location. You choose at checkout where to collect them: a Requester Pays S3 bucket, downloaded with your own AWS account, or a Cloudflare R2 bucket with a read-only API key and no egress fees. Files stay available for 7 days from delivery.