# Solana DEX — All Venues | Bitquery Data Store

Every swap and every pool event across every indexed DEX program on Solana, in one schema, decoded and USD-priced at block time.

Dataset page: https://bitquery.io/datastore/datasets/solana-dex-all
Network: Solana
Category: Trades, Pools
Tables: 2
Columns: 146
Coverage: first block to 2026-09-24
Format: Apache Parquet, Snappy compression, one prefix per table
Licence: https://bitquery.io/datastore/legal/data-license

## What this is

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.

## What people use it for

- Whole-market volume, liquidity and market-share analysis without stitching venue datasets together
- Cross-venue arbitrage and routing research across the full DEX surface
- Backtesting strategies that need every venue a token traded on, not a chosen few
- Training and evaluating models on complete Solana DEX order flow

## Tables (2)

### all_dex_trades: 82 columns

One row per swap on any indexed Solana DEX program, with buy and sell sides, venue identifiers, token metadata and USD pricing.

S3 prefix: datashare/solana/all_dex/dex_trades
File naming: <start_slot>_<end_slot>.parquet. The public sample is one file covering a full day, capped at 20 rows per DEX program; delivered files are uncapped and split by slot range.
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/datashare/solana/all_dex/dex_trades/423000000_424000000.parquet
Sample updated: Sep 25, 2026

| column | type | description |
| --- | --- | --- |
| Block_Date | Date | UTC date of the block |
| Block_Height | UInt64 | Block height |
| Block_Slot | UInt64 | Solana slot |
| Block_Time | DateTime | Block timestamp, UTC |
| Instruction_CallPath | Array | Nested call path of the instruction |
| Instruction_ExternalSeqNumber | UInt64 | Sequence number of the outer instruction |
| Instruction_Index | UInt64 | Position of the instruction within the transaction |
| Instruction_InternalSeqNumber | UInt64 | Sequence number of the inner instruction |
| Instruction_Program_Address | String | Program that executed the instruction |
| Instruction_Program_Method | String | Decoded program method |
| Instruction_Program_Name | String | Decoded program name |
| Trade_Buy_Account_Address | String | Trade buy account address |
| Trade_Buy_Account_Token_Owner | String | Trade buy account token owner |
| Trade_Buy_Amount | Decimal | Amount bought, decimal adjusted |
| Trade_Buy_AmountInUSD | Float64 | Amount bought in USD |
| Trade_Buy_Currency_CollectionAddress | String | Trade buy currency collection address |
| Trade_Buy_Currency_Decimals | UInt64 | Decimals of the bought currency |
| Trade_Buy_Currency_EditionNonce | UInt64 | Trade buy currency edition nonce |
| Trade_Buy_Currency_Fungible | Bool | Trade buy currency fungible |
| Trade_Buy_Currency_MetadataAddress | String | Trade buy currency metadata address |
| Trade_Buy_Currency_MintAddress | String | Mint of the bought currency |
| Trade_Buy_Currency_Name | String | Name of the bought currency |
| Trade_Buy_Currency_ProgramAddress | String | Trade buy currency program address |
| Trade_Buy_Currency_SellerFeeBasisPoints | UInt64 | Trade buy currency seller fee basis points |
| Trade_Buy_Currency_Symbol | String | Symbol of the bought currency |
| Trade_Buy_Currency_TokenCreator_Address | Array | Trade buy currency token creator address |
| Trade_Buy_Currency_TokenStandard | String | Trade buy currency token standard |
| Trade_Buy_Currency_Uri | String | Trade buy currency uri |
| Trade_Buy_Currency_UpdateAuthority | String | Trade buy currency update authority |
| Trade_Buy_Currency_VerifiedCollection | Bool | Trade buy currency verified collection |
| Trade_Buy_Order_Account | String | Trade buy order account |
| Trade_Buy_Order_BuySide | Bool | Trade buy order buy side |
| Trade_Buy_Order_LimitAmount | UInt64 | Trade buy order limit amount |
| Trade_Buy_Order_LimitPrice | UInt64 | Trade buy order limit price |
| Trade_Buy_Order_Mint | String | Trade buy order mint |
| Trade_Buy_Order_OrderId | String | Trade buy order order id |
| Trade_Buy_Order_Owner | String | Trade buy order owner |
| Trade_Buy_Order_Payer | String | Trade buy order payer |
| Trade_Buy_Price | Float64 | Price of the bought currency in units of the sold currency |
| Trade_Buy_PriceInUSD | Float64 | Price of the bought currency in USD |
| Trade_Dex_ProgramAddress | String | Program address of the DEX that executed the trade, base58. Filter on this to isolate a single venue. |
| Trade_Dex_ProtocolFamily | String | Protocol family of the venue, for example Pumpswap, Meteora, Raydium, Jupiter, OrcaWhirpool, Phoenix, OKX |
| Trade_Dex_ProtocolName | String | Protocol name as indexed, for example raydium_clmm, phoenix_v1, dex_solana_v3 |
| Trade_Index | UInt64 | Trade index within the transaction |
| Trade_Market_MarketAddress | String | Pool or market address the trade executed against |
| Trade_PriceAsymmetry | Float64 | Relative difference between buy and sell side USD values |
| Trade_Sell_Account_Address | String | Trade sell account address |
| Trade_Sell_Account_Token_Owner | String | Trade sell account token owner |
| Trade_Sell_Amount | Decimal | Amount sold, decimal adjusted |
| Trade_Sell_AmountInUSD | Float64 | Amount sold in USD |
| Trade_Sell_Currency_CollectionAddress | String | Trade sell currency collection address |
| Trade_Sell_Currency_Decimals | UInt64 | Decimals of the sold currency |
| Trade_Sell_Currency_EditionNonce | UInt64 | Trade sell currency edition nonce |
| Trade_Sell_Currency_Fungible | Bool | Trade sell currency fungible |
| Trade_Sell_Currency_MetadataAddress | String | Trade sell currency metadata address |
| Trade_Sell_Currency_MintAddress | String | Mint of the sold currency |
| Trade_Sell_Currency_Name | String | Name of the sold currency |
| Trade_Sell_Currency_ProgramAddress | String | Trade sell currency program address |
| Trade_Sell_Currency_SellerFeeBasisPoints | UInt64 | Trade sell currency seller fee basis points |
| Trade_Sell_Currency_Symbol | String | Symbol of the sold currency |
| Trade_Sell_Currency_TokenCreator_Address | Array | Trade sell currency token creator address |
| Trade_Sell_Currency_TokenStandard | String | Trade sell currency token standard |
| Trade_Sell_Currency_Uri | String | Trade sell currency uri |
| Trade_Sell_Currency_UpdateAuthority | String | Trade sell currency update authority |
| Trade_Sell_Currency_VerifiedCollection | Bool | Trade sell currency verified collection |
| Trade_Sell_Order_Account | String | Trade sell order account |
| Trade_Sell_Order_BuySide | Bool | Trade sell order buy side |
| Trade_Sell_Order_LimitAmount | UInt64 | Trade sell order limit amount |
| Trade_Sell_Order_LimitPrice | UInt64 | Trade sell order limit price |
| Trade_Sell_Order_Mint | String | Trade sell order mint |
| Trade_Sell_Order_OrderId | String | Trade sell order order id |
| Trade_Sell_Order_Owner | String | Trade sell order owner |
| Trade_Sell_Order_Payer | String | Trade sell order payer |
| Trade_Sell_Price | Float64 | Price of the sold currency in units of the bought currency |
| Trade_Sell_PriceInUSD | Float64 | Price of the sold currency in USD |
| Transaction_Fee | Decimal | Network fee paid, in SOL |
| Transaction_FeeInUSD | Float64 | Network fee valued in USD at block time |
| Transaction_FeePayer | String | Fee payer address |
| Transaction_Index | UInt64 | Position of the transaction within the block |
| Transaction_Result_Success | Bool | Whether the transaction succeeded |
| Transaction_Signature | String | Transaction signature, base58 |
| Transaction_Signer | String | Transaction signer address |

### all_dex_pools: 64 columns

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.

S3 prefix: datashare/solana/all_dex/dex_pools
File naming: <start_slot>_<end_slot>.parquet. The public sample is one file covering a full day, capped at 20 rows per DEX program; delivered files are uncapped and split by slot range.
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/datashare/solana/all_dex/dex_pools/423000000_424000000.parquet
Sample updated: Sep 25, 2026

| column | type | description |
| --- | --- | --- |
| Block_Date | Date | UTC date of the block |
| Block_Slot | UInt64 | Solana slot |
| Block_Time | DateTime | Block timestamp, UTC |
| Instruction_CallPath | Array | Nested call path of the instruction |
| Instruction_ExternalSeqNumber | UInt64 | Sequence number of the outer instruction |
| Instruction_Index | UInt64 | Position of the instruction within the transaction |
| Instruction_InternalSeqNumber | UInt64 | Sequence number of the inner instruction |
| Instruction_Program_Address | String | Program that executed the instruction |
| Instruction_Program_Method | String | Decoded program method |
| Instruction_Program_Name | String | Decoded program name |
| Pool_BaseCurrency_ChangeAmount | Decimal | Base-token amount added to or removed from the pool by this event, decimal adjusted |
| Pool_BaseCurrency_ChangeAmountInUSD | Float64 | Base-token change valued in USD at block time |
| Pool_BaseCurrency_PostAmount | Decimal | Base-token pool reserve after the event, decimal adjusted |
| Pool_BaseCurrency_PostAmountInUSD | Float64 | Base-token reserve after the event, valued in USD at block time |
| Pool_BaseCurrency_Price | Float64 | Base-token price in quote-token units after the event |
| Pool_BaseCurrency_PriceInUSD | Float64 | Base-token price in USD at block time |
| Pool_Dex_ProgramAddress | String | Program address of the DEX that owns the pool or market, base58. Filter on this to isolate a single venue. |
| Pool_Dex_ProtocolFamily | String | Protocol family of the venue, for example Pumpswap, Meteora, Raydium, OrcaWhirpool, Phoenix, Manifest |
| Pool_Dex_ProtocolName | String | Protocol name as indexed, for example raydium_clmm, phoenix_v1, manifest |
| Pool_Market_BaseCurrency_CollectionAddress | String | Pool market base currency collection address |
| Pool_Market_BaseCurrency_Decimals | UInt64 | Pool market base currency decimals |
| Pool_Market_BaseCurrency_EditionNonce | UInt64 | Pool market base currency edition nonce |
| Pool_Market_BaseCurrency_Fungible | Bool | Pool market base currency fungible |
| Pool_Market_BaseCurrency_MetadataAddress | String | Pool market base currency metadata address |
| Pool_Market_BaseCurrency_MintAddress | String | Pool market base currency mint address |
| Pool_Market_BaseCurrency_Name | String | Pool market base currency name |
| Pool_Market_BaseCurrency_ProgramAddress | String | Pool market base currency program address |
| Pool_Market_BaseCurrency_SellerFeeBasisPoints | UInt64 | Pool market base currency seller fee basis points |
| Pool_Market_BaseCurrency_Symbol | String | Pool market base currency symbol |
| Pool_Market_BaseCurrency_TokenCreators_Address | Array | Pool market base currency token creators address |
| Pool_Market_BaseCurrency_TokenStandard | String | Pool market base currency token standard |
| Pool_Market_BaseCurrency_Uri | String | Pool market base currency uri |
| Pool_Market_BaseCurrency_UpdateAuthority | String | Pool market base currency update authority |
| Pool_Market_BaseCurrency_VerifiedCollection | Bool | Pool market base currency verified collection |
| Pool_Market_MarketAddress | String | Pool or market address |
| Pool_Market_QuoteCurrency_CollectionAddress | String | Pool market quote currency collection address |
| Pool_Market_QuoteCurrency_Decimals | UInt64 | Pool market quote currency decimals |
| Pool_Market_QuoteCurrency_EditionNonce | UInt64 | Pool market quote currency edition nonce |
| Pool_Market_QuoteCurrency_Fungible | Bool | Pool market quote currency fungible |
| Pool_Market_QuoteCurrency_MetadataAddress | String | Pool market quote currency metadata address |
| Pool_Market_QuoteCurrency_MintAddress | String | Pool market quote currency mint address |
| Pool_Market_QuoteCurrency_Name | String | Pool market quote currency name |
| Pool_Market_QuoteCurrency_ProgramAddress | String | Pool market quote currency program address |
| Pool_Market_QuoteCurrency_SellerFeeBasisPoints | UInt64 | Pool market quote currency seller fee basis points |
| Pool_Market_QuoteCurrency_Symbol | String | Pool market quote currency symbol |
| Pool_Market_QuoteCurrency_TokenCreators_Address | Array | Pool market quote currency token creators address |
| Pool_Market_QuoteCurrency_TokenStandard | String | Pool market quote currency token standard |
| Pool_Market_QuoteCurrency_Uri | String | Pool market quote currency uri |
| Pool_Market_QuoteCurrency_UpdateAuthority | String | Pool market quote currency update authority |
| Pool_Market_QuoteCurrency_VerifiedCollection | Bool | Pool market quote currency verified collection |
| Pool_QuoteCurrency_ChangeAmount | Decimal | Quote-token amount added to or removed from the pool by this event, decimal adjusted |
| Pool_QuoteCurrency_ChangeAmountInUSD | Float64 | Quote-token change valued in USD at block time |
| Pool_QuoteCurrency_PostAmount | Decimal | Quote-token pool reserve after the event, decimal adjusted |
| Pool_QuoteCurrency_PostAmountInUSD | Float64 | Quote-token reserve after the event, valued in USD at block time |
| Pool_QuoteCurrency_Price | Float64 | Quote-token price in base-token units after the event |
| Pool_QuoteCurrency_PriceInUSD | Float64 | Quote-token price in USD at block time |
| PoolEvent_Index | UInt64 | Index of the pool event within the instruction |
| Transaction_Fee | Decimal | Network fee paid, in SOL |
| Transaction_FeeInUSD | Float64 | Network fee valued in USD at block time |
| Transaction_FeePayer | String | Fee payer address |
| Transaction_Index | UInt64 | Position of the transaction within the block |
| Transaction_Result_Success | Bool | Whether the transaction succeeded |
| Transaction_Signature | String | Transaction signature, base58 |
| Transaction_Signer | String | Transaction signer address |

## Price

- Latest month (Aug 24, 2026 → Sep 24, 2026): $600 one-time, USD
- Last 6 months (Mar 24, 2026 → Sep 24, 2026): $3,000 one-time, USD
- Last 12 months (Sep 24, 2025 → Sep 24, 2026): $6,000 one-time, USD

Every window includes all 2 tables and 146 columns. Only the time range changes.

## Questions buyers ask

Q: What is included in Solana DEX — All Venues?
A: 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.

Q: How many DEXes does this actually cover?
A: 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.

Q: Why does the pools table cover fewer programs than the trades table?
A: 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.

Q: Is the sample file capped?
A: 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.

Q: How does this relate to the per-venue datasets?
A: 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.

Q: Are order books included alongside AMMs?
A: 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.

Q: How is the data delivered?
A: 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.

Q: How current is the data?
A: Refreshed daily with T+1 latency. A purchase made today includes everything up to yesterday.

Q: Can I try before I buy?
A: 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.

## What this file is, and is not

This is a description of one dataset sold by Bitquery, written for assistants and for people. It lists every column but holds no data rows. The sample files linked under each table are real Parquet and are free to download. Figures here come from the product record and are exact unless marked otherwise; the delivery manifest is authoritative for a purchased file. If a question needs a row that is not in a sample, say so rather than guessing at it.