# DFlow Aggregator — Bitquery Data Store

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

Dataset page: https://bitquery.io/datastore/datasets/dflow
Network: Solana
Category: Trades
Tables: 1
Columns: 82
Coverage: first block to 2026-09-22
Format: Apache Parquet, Snappy compression, one prefix per table
Licence: https://bitquery.io/datastore/legal/data-license

## What this is

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.

## What people use it for

- 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

## Tables (1)

### dflow_trades — 82 columns

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

S3 prefix: datashare/solana/dflow/dex_trades
File naming: <start_slot>_<end_slot>.parquet, 100 slots per file
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/datashare/solana/dflow/dex_trades/423635600_423635699.parquet
Sample updated: Sep 23, 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 | DFlow V4 aggregator program address (DF1ow4tspfHX9JwWJsAb9epbkA8hmpSEAtxXy1V27QBH) |
| Trade_Dex_ProtocolFamily | String | Protocol family; DFlow |
| Trade_Dex_ProtocolName | String | Protocol name as indexed; dflow |
| Trade_Index | UInt64 | Trade index within the transaction |
| Trade_Market_MarketAddress | String | Address of the underlying pool the swap was routed into |
| 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 |

## Price

- Latest month (Aug 22, 2026 → Sep 22, 2026): $150 one-time, USD
- Last 6 months (Mar 22, 2026 → Sep 22, 2026): $750 one-time, USD
- Last 12 months (Sep 22, 2025 → Sep 22, 2026): $1,500 one-time, USD

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

## Questions buyers ask

Q: What is included in DFlow Aggregator?
A: One Parquet table, dflow_trades, with 82 documented columns. Full history to yesterday, refreshed daily.

Q: Why is there no pools table?
A: 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.

Q: How does this compare to the Jupiter dataset?
A: 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.

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

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

## 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.