BitqueryBitqueryData Store
Browse datasets
SolanaTrades

DFlow Aggregator

Every swap routed through DFlow's V4 aggregator on Solana, decoded and USD-priced at block time.

Coverage
Full historyto Sep 22, 2026 · yesterday
Table
1dflow_trades
Columns
82typed
Coverage ends yesterday, UTC

Overview

Complete historical record of swaps routed through the DFlow V4 aggregator (DF1ow4tspfHX9JwWJsAb9epbkA8hmpSEAtxXy1V27QBH) on Solana, at slot resolution.

DFlow is an order-flow aggregator: it does not hold liquidity of its own, it routes a user's swap into pools run by other programs. Each row is one swap as the aggregator executed it, decoded from the program instructions and priced in USD at block time, with both sides of the trade, full token metadata and the transaction context.

Use cases

  • Aggregator market-share and routing analysis against Jupiter
  • Order-flow research: which venues DFlow routes into and when
  • Execution quality and slippage benchmarking per route
  • Wallet-level trading behaviour across aggregated venues

Table

82 columns · free sample for the table

dflow_trades

82 columns

One row per swap routed through the DFlow V4 aggregator, with buy and sell sides, token metadata and USD pricing.

datashare/solana/dflow/dex_trades<start_slot>_<end_slot>.parquet100 slots per file
Browse columns Sample fileSample updated Sep 23, 2026

Schema reference

copies a column name
82 columns
ColumnTypeDescription
Block4
Block_DateDateUTC date of the block
Block_HeightUInt64Block height
Block_SlotUInt64Solana slot
Block_TimeDateTimeBlock timestamp, UTC
Instruction7
Instruction_CallPathArrayNested call path of the instruction
Instruction_ExternalSeqNumberUInt64Sequence number of the outer instruction
Instruction_IndexUInt64Position of the instruction within the transaction
Instruction_InternalSeqNumberUInt64Sequence number of the inner instruction
Instruction_Program_AddressStringProgram that executed the instruction
Instruction_Program_MethodStringDecoded program method
Instruction_Program_NameStringDecoded program name
Trade_Buy29
Trade_Buy_Account_AddressStringTrade buy account address
Trade_Buy_Account_Token_OwnerStringTrade buy account token owner
Trade_Buy_AmountDecimalAmount bought, decimal adjusted
Trade_Buy_AmountInUSDFloat64Amount bought in USD
Trade_Buy_Currency_CollectionAddressStringTrade buy currency collection address
Trade_Buy_Currency_DecimalsUInt64Decimals of the bought currency
Trade_Buy_Currency_EditionNonceUInt64Trade buy currency edition nonce
Trade_Buy_Currency_FungibleBoolTrade buy currency fungible
Trade_Buy_Currency_MetadataAddressStringTrade buy currency metadata address
Trade_Buy_Currency_MintAddressStringMint of the bought currency
Trade_Buy_Currency_NameStringName of the bought currency
Trade_Buy_Currency_ProgramAddressStringTrade buy currency program address
Trade_Buy_Currency_SellerFeeBasisPointsUInt64Trade buy currency seller fee basis points
Trade_Buy_Currency_SymbolStringSymbol of the bought currency
Trade_Buy_Currency_TokenCreator_AddressArrayTrade buy currency token creator address
Trade_Buy_Currency_TokenStandardStringTrade buy currency token standard
Trade_Buy_Currency_UriStringTrade buy currency uri
Trade_Buy_Currency_UpdateAuthorityStringTrade buy currency update authority
Trade_Buy_Currency_VerifiedCollectionBoolTrade buy currency verified collection
Trade_Buy_Order_AccountStringTrade buy order account
Trade_Buy_Order_BuySideBoolTrade buy order buy side
Trade_Buy_Order_LimitAmountUInt64Trade buy order limit amount
Trade_Buy_Order_LimitPriceUInt64Trade buy order limit price
Trade_Buy_Order_MintStringTrade buy order mint
Trade_Buy_Order_OrderIdStringTrade buy order order id
Trade_Buy_Order_OwnerStringTrade buy order owner
Trade_Buy_Order_PayerStringTrade buy order payer
Trade_Buy_PriceFloat64Price of the bought currency in units of the sold currency
Trade_Buy_PriceInUSDFloat64Price of the bought currency in USD
Trade_Dex3
Trade_Dex_ProgramAddressStringDFlow V4 aggregator program address (DF1ow4tspfHX9JwWJsAb9epbkA8hmpSEAtxXy1V27QBH)
Trade_Dex_ProtocolFamilyStringProtocol family; DFlow
Trade_Dex_ProtocolNameStringProtocol name as indexed; dflow
Trade3
Trade_IndexUInt64Trade index within the transaction
Trade_Market_MarketAddressStringAddress of the underlying pool the swap was routed into
Trade_PriceAsymmetryFloat64Relative difference between buy and sell side USD values
Trade_Sell29
Trade_Sell_Account_AddressStringTrade sell account address
Trade_Sell_Account_Token_OwnerStringTrade sell account token owner
Trade_Sell_AmountDecimalAmount sold, decimal adjusted
Trade_Sell_AmountInUSDFloat64Amount sold in USD
Trade_Sell_Currency_CollectionAddressStringTrade sell currency collection address
Trade_Sell_Currency_DecimalsUInt64Decimals of the sold currency
Trade_Sell_Currency_EditionNonceUInt64Trade sell currency edition nonce
Trade_Sell_Currency_FungibleBoolTrade sell currency fungible
Trade_Sell_Currency_MetadataAddressStringTrade sell currency metadata address
Trade_Sell_Currency_MintAddressStringMint of the sold currency
Trade_Sell_Currency_NameStringName of the sold currency
Trade_Sell_Currency_ProgramAddressStringTrade sell currency program address
Trade_Sell_Currency_SellerFeeBasisPointsUInt64Trade sell currency seller fee basis points
Trade_Sell_Currency_SymbolStringSymbol of the sold currency
Trade_Sell_Currency_TokenCreator_AddressArrayTrade sell currency token creator address
Trade_Sell_Currency_TokenStandardStringTrade sell currency token standard
Trade_Sell_Currency_UriStringTrade sell currency uri
Trade_Sell_Currency_UpdateAuthorityStringTrade sell currency update authority
Trade_Sell_Currency_VerifiedCollectionBoolTrade sell currency verified collection
Trade_Sell_Order_AccountStringTrade sell order account
Trade_Sell_Order_BuySideBoolTrade sell order buy side
Trade_Sell_Order_LimitAmountUInt64Trade sell order limit amount
Trade_Sell_Order_LimitPriceUInt64Trade sell order limit price
Trade_Sell_Order_MintStringTrade sell order mint
Trade_Sell_Order_OrderIdStringTrade sell order order id
Trade_Sell_Order_OwnerStringTrade sell order owner
Trade_Sell_Order_PayerStringTrade sell order payer
Trade_Sell_PriceFloat64Price of the sold currency in units of the bought currency
Trade_Sell_PriceInUSDFloat64Price of the sold currency in USD
Transaction7
Transaction_FeeDecimalNetwork fee paid, in SOL
Transaction_FeeInUSDFloat64Network fee valued in USD at block time
Transaction_FeePayerStringFee payer address
Transaction_IndexUInt64Position of the transaction within the block
Transaction_Result_SuccessBoolWhether the transaction succeeded
Transaction_SignatureStringTransaction signature, base58
Transaction_SignerStringTransaction signer address
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
Ask Claude Ask ChatGPT

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, delivered as signed download links by email after payment, in this layout:

# dflow_trades — 100 slots per file
datashare/solana/dflow/dex_trades<start_slot>_<end_slot>.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. Get signed linksThe team prepares the export and emails the links.

Time windows

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

31 days
Latest month
Aug 22, 2026 → Sep 22, 2026
$150
Pay now
184 days
Last 6 months
Mar 22, 2026 → Sep 22, 2026
$750
Pay now
365 days
Last 12 months
Sep 22, 2025 → Sep 22, 2026
$1,500
Pay now
In every window
  • The dflow_trades table, 82 columns
  • Parquet files in the layout under Delivery
  • Signed download links by email
  • Licensed under the Data License

FAQ

6 questions
What is included in DFlow Aggregator?

One Parquet table, dflow_trades, with 82 documented columns. Full history to yesterday, refreshed daily.

Why is there no pools table?

DFlow is an aggregator, not a pool program. It routes orders into pools run by Raydium, Orca, Meteora and others rather than holding liquidity itself, so it produces no pool reserve events. For pool-level data, buy the dataset for the underlying DEX.

How does this compare to the Jupiter dataset?

Both cover aggregator routing rather than pools. Holding both lets you compare aggregator market share, routing choices and execution quality across the same tokens and time windows.

How is the data delivered?

As flat Parquet files under a stable S3 layout, with a JSON manifest listing every file and its sha256. Signed HTTPS links are emailed to you once the files are prepared.

How current is the data?

Refreshed daily with T+1 latency. A purchase made today includes everything up to yesterday.

Can I try before I buy?

Yes. The 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.

Related datasets

All datasets
SolanaRecent windows

Pump.fun

Every bonding-curve trade, token creation, migration and pool on Pump.fun, plus per-token OHLCV, decoded and USD-priced.

TradesPoolsTransfers
Tables
4
Columns
137
From
$300
SolanaRecent windows

Raydium CLMM

Every swap and liquidity change on Raydium's concentrated liquidity pools, decoded and USD-priced at block time.

TradesPools
Tables
2
Columns
146
From
$300
SolanaRecent windows

PumpSwap

Every swap and pool reserve change on PumpSwap, the AMM Pump.fun tokens graduate to, decoded and USD-priced at block time.

TradesPools
Tables
2
Columns
146
From
$300

Need a custom window, extra tables or CSV?

Tell us the chain, tables and date range.

Request a custom cut