Every swap and every pool event across every indexed DEX program on Solana, in one schema, decoded and USD-priced at block time.
Every DEX program Bitquery indexes on Solana, in a single pair of tables: one row per swap and one row per pool event, at slot resolution.
This is the same schema as the per-venue datasets in this catalog — identical column names and types — with the program filter removed. Trade_Dex_ProgramAddress, Trade_Dex_ProtocolName and Trade_Dex_ProtocolFamily identify the venue on every row, so you can slice it back down to any single DEX, or group by family to compare them.
A one-day census of the sample window found 32 distinct DEX programs in the trades table and 27 in the pools table. The protocol families present include PumpSwap, Pump.fun, Meteora, Raydium, Jupiter, Orca Whirlpool, DFlow, OKX, PancakeSwap, SolFi, BisonFi, GoonFi, AlphaQ, Aquifer, Manifest, Phoenix, Bonkswap, Aldrin and Magic Eden — AMMs, launchpads, aggregators and central limit order books side by side. That set grows as new programs launch and are indexed; nothing is pinned to a fixed venue list.
One row per swap on any indexed Solana DEX program, with buy and sell sides, venue identifiers, token metadata and USD pricing.
datashare/solana/all_dex/dex_trades<start_slot>_<end_slot>.parquet. The public sample is one file covering a full daycapped at 20 rows per DEX program; delivered files are uncapped and split by slot range.One row per pool or market state change on any indexed Solana DEX program, with the change amount and the resulting balance for both sides, USD-valued at block time.
datashare/solana/all_dex/dex_pools<start_slot>_<end_slot>.parquet. The public sample is one file covering a full daycapped at 20 rows per DEX program; delivered files are uncapped and split by slot range.all_dex_trades82 columnsOne row per swap on any indexed Solana DEX program, with buy and sell sides, venue identifiers, token metadata and USD pricing.all_dex_pools64 columnsOne row per pool or market state change on any indexed Solana DEX program, with the change amount and the resulting balance for both sides, USD-valued at block time.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.
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, delivered as signed download links by email after payment, in this layout:
# all_dex_trades: capped at 20 rows per DEX program; delivered files are uncapped and split by slot range. datashare/solana/all_dex/dex_trades<start_slot>_<end_slot>.parquet. The public sample is one file covering a full day # all_dex_pools: capped at 20 rows per DEX program; delivered files are uncapped and split by slot range. datashare/solana/all_dex/dex_pools<start_slot>_<end_slot>.parquet. The public sample is one file covering a full day
Every window includes all 2 tables and 146 columns. Only the time range changes.
Two Parquet tables: all_dex_trades and all_dex_pools, with 146 documented columns. Every indexed DEX program on Solana, covering the most recent month to yesterday, refreshed daily.
We counted 32 distinct DEX programs in the trades table and 27 in the pools table over a single sampled day (2026-06-01), spanning families from PumpSwap, Meteora and Raydium at the top of the volume table down to Phoenix, Bonkswap and Aldrin in the long tail. The number is not fixed: it is whatever programs traded that day, and it grows over time as new venues launch and are indexed. Over a longer window the count is higher.
Aggregators and routers — Jupiter, DFlow, OKX DEX and others — execute swaps but hold no liquidity of their own, so they produce trade rows and no pool events. That accounts for the gap between 32 and 27 in the sampled day.
Yes, and deliberately. The public sample is capped at 20 rows per DEX program so that one small file shows you the full breadth of venues rather than a few busy minutes of Pump.fun. It holds 622 trade rows and 503 pool rows across a full day. The delivered dataset has no such cap — it is every row.
It supersedes them. Anything you can do with the Raydium, Meteora, Pump.fun or Phoenix datasets you can do here by filtering on Trade_Dex_ProgramAddress. Buy a single venue if that is all you need; buy this if you are working across the market.
Yes. Central limit order books such as Phoenix and Manifest are indexed into the same tables, where a trade row is a matched fill and a pool row is market state rather than constant-product reserves. Filter by protocol family if you need to separate the two models before comparing prices.
As flat Parquet files under a stable S3 layout, one prefix per table, with a JSON manifest listing every file and its sha256. Signed HTTPS links are emailed to you once the files are prepared.
Refreshed daily with T+1 latency. A purchase made today includes everything up to yesterday.
Yes. Every table links to a public sample file with real records, and the sample bucket holds full Parquet files you can load directly. No email address required.
Every bonding-curve trade, token creation, migration and pool on Pump.fun, plus per-token OHLCV, decoded and USD-priced.
Every Pons launch, bonding-curve trade and graduation on Robinhood Chain, decoded from the chain and priced in USD.
Every swap and liquidity change on Raydium's concentrated liquidity pools, decoded and USD-priced at block time.
Tell us the chain, tables and date range.