all_token_ohlcv_1d
16 columnsOne row per token and UTC day for every token with a USD price: open, high, low and close, and volume.
multichain/price_history/all_token_ohlcv_1d<YYYY-MM-DD>.parquetone file per UTC dayDaily USD price history for every DEX-traded token with a USD price on ten chains, up to 12 months, one row per token and day.
all_token_ohlcv_1dWe build one USD candle per token and day from decoded DEX trades, for every token that had a USD price in the window, with no ranking and no volume floor, 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 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.
One row per token and UTC day for every token with a USD price: open, high, low and close, and volume.
multichain/price_history/all_token_ohlcv_1d<YYYY-MM-DD>.parquetone file per UTC daySend 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.
Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.
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/price_history/all_token_ohlcv_1d<YYYY-MM-DD>.parquetEvery window includes 16 columns. Only the time range changes.
all_token_ohlcv_1d table, 16 columnsOne Parquet table, all_token_ohlcv_1d, with 16 columns: the day, the token and its chain, USD open, high, low and close, USD and token volume, and the number of hourly bars behind the day.
About 66 million rows for 12 months and half that for 6. This is an estimate scaled from the latest 30 days, which hold about 5.5 million rows; exact figures arrive with the delivery manifest.
Every token with a USD-priced DEX trade in the window, on Solana, BNB Smart Chain, Base, Ethereum, Polygon, Arbitrum, Optimism, Tron, Robinhood Chain and Arc. Nothing is filtered by size.
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.
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.
Market cap and supply columns, trades on centralized exchanges, and days with no trade, which have no row. Nothing is forward filled.
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.
One line in DuckDB: SELECT * FROM read_parquet('all_token_ohlcv_1d/*.parquet') LIMIT 10. Pandas works too: pandas.read_parquet(path). The sample file opens without credentials.
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.
192.6 million address labels on 38 chains, from exchange deposit and hot wallets to casinos, mixers, darknet markets, scams and sanctioned addresses.
Every bonding-curve trade, token creation, migration and pool on Pump.fun, plus per-token OHLCV, decoded and USD-priced.
Daily USD candles for the top 1,000 DEX-traded tokens by market cap on nine chains, last 30 days, one row per token and day.
Tell us the chain, tables and date range.