BitqueryBitqueryData Store
Multi-chain logoMulti-chainOHLCV

All Tokens OHLCV

Daily USD candles for every DEX-traded token with a USD price on ten chains, last 30 days, one row per token and day.

Coverage
Latest monthto Oct 8, 2026 · yesterday
Rows
≈5.5Mrows · estimate
Size
≈1.0 GBParquet · estimate
Tokens
≈3.0Mdistinct · estimate
Table
1all_token_ohlcv_1d
Columns
20typed
Coverage ends yesterday, UTC

Overview

We build one USD candle per token and day from the Bitquery price index, for every token it priced in the window, with no ranking and no volume floor. That is about 3 million tokens over 30 days on Solana, BNB Smart Chain, Base, Ethereum, Polygon, Arbitrum, Optimism, Tron, Robinhood Chain and Arc, most of them on Solana and most of them short lived. A row is one token on one UTC day.

Most buyers start by filtering: Volume_Usd above a floor, or Interval_Bars above a few hours, removes the tokens that traded once and died. Join on Token_Id, because symbols and names repeat heavily in the long tail. Market cap is present for every row, but circulating supply is known for only about 4,800 tokens, so for the rest it is price times total supply.

Use cases

  • Screening the full token universe by daily volume or price change
  • Survival and launch studies: how many new tokens still trade after a week
  • Daily closes for long-tail tokens that price feeds do not list
  • Training data for models that need the whole market, not a top list

Table

20 columns · free sample for the table

all_token_ohlcv_1d

20 columns

One row per token and UTC day for every token with a USD price: open, high, low and close, volume, and supply figures at the day's last bar.

multichain/ohlcv/all_token_ohlcv_1d<YYYY-MM-DD>.parquetone file per UTC day
Browse columns Sample fileSample updated Oct 9, 2026

Schema reference

copies a column name
20 columns
ColumnTypeDescription
Block_DateDateUTC day 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 day
Price_Ohlc_HighFloat64Highest USD price in the day
Price_Ohlc_LowFloat64Lowest USD price in the day
Price_Ohlc_CloseFloat64Last USD price in the day
Volume_UsdFloat64USD value traded in the day
Volume_BaseFloat64Amount of the token traded in the day, decimal adjusted
Interval_BarsUInt32Hours of the day that had at least one trade, 1 to 24
Supply_MarketCapFloat64USD price times circulating supply; price times total supply when circulating supply is unknown
Supply_CirculatingSupplyFloat64Circulating supply from CryptoRank reference data; 0 when unknown
Supply_TotalSupplyFloat64Total supply read from the chain, decimal adjusted
Supply_FullyDilutedValuationUsdFloat64USD price times total supply
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:

# all_token_ohlcv_1d: one file per UTC day
multichain/ohlcv/all_token_ohlcv_1d<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.

Price

Latest month
Sep 8, 2026 → Oct 8, 2026
$400one-time, USD
  • The all_token_ohlcv_1d table, 20 columns
  • Parquet files in the layout under Delivery
  • S3 or R2 download, chosen at checkout
  • Licensed under the Data License
Pay now

FAQ

10 questions
What is in All Tokens OHLCV?

One Parquet table, all_token_ohlcv_1d, with 20 columns: the day, the token and its chain, USD open, high, low and close, USD and token volume, the number of hourly bars behind the day, and four supply figures. About 5.5 million rows for about 3 million tokens over 30 days.

How big is it?

About 5.5 million rows and roughly 1 GB as Parquet, estimated from a sample of 40,000 rows at 187 bytes per row. The live table held 5,498,018 token days for the 30 days to 8 October 2026; exact figures arrive with the delivery manifest.

Which chains are covered?

Solana, BNB Smart Chain, Base, Ethereum, Polygon, Arbitrum, Optimism, Tron, Robinhood Chain and Arc.

How far back does it go?

30 days. The price index keeps 30 days of bars, so that is the longest window this dataset can hold. Each order is built once, when you buy, and covers the 30 days up to the latest full UTC day. It is a fixed set of files and does not update afterwards. For prices that keep updating, use the Bitquery Trading API.

How are the daily candles produced, and how were they checked?

Bars come from the Bitquery price index, the same series the Trading API serves. It prices each token in USD from its DEX trades and filters out MEV trades. A daily bar is rolled up from the hourly bars: open of the first hour, close of the last, highest high, lowest low, summed volume. We ran the export for a 14-day window before release: 2,714,784 rows, every day present, and no bar with a high below its low.

What was left out, and why?

Nothing is filtered by size. A token is missing only if the price index never priced it in USD, or if it trades on centralized exchanges alone. Days with no trade have no row.

What should I watch out for?

Most rows are tokens with tiny volume, and a new token can move tenfold or more inside one day, so filter before you average anything. Market cap for a token without a known circulating supply is price times total supply and can be very large for a token nobody trades. Symbols and names repeat; join on Token_Id.

How do I find tokens that launched in the window?

Take each Token_Id's first Block_Date. A first day later than the window's first day is a token the index first priced inside the window.

How do I load it?

One line in DuckDB: SELECT * FROM read_parquet('all_token_ohlcv_1d/*.parquet') LIMIT 10. Pandas works too: pandas.read_parquet(path).

How current is it, and how is it delivered?

Each order is built once, when you buy, and covers the 30 days up to the latest full UTC day. It is a fixed set of files and does not update afterwards. For prices that keep updating, use the Bitquery Trading API. 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.