Aggregator Trades

If you require tx-level detail for records in this table, see here for more info. solana.dex.aggregator_trades currently includes the following aggregator programs:

Table Details

Property	Value
Table Name	`solana.dex.aggregator_trades`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `txn_id`, `unique_id`

Program
raydium-router
jupiter-aggregator-v2
jupiter-aggregator-v3
jupiter-aggregator-v4
jupiter-aggregator-v5
jupiter-aggregator-v5.1
jupiter-aggregator-v6
saber-router
photon
dflow-v3
dflow-v4
okx-aggregator
okx-aggregator-v6
zeroex-aggregator

Most of the columns in this table have the same meaning as the ones in trades. Main differences:

The aggregators use a variety of fill sources to fill the trade order. These can be found in the column FILL_SOURCES.
This table has a USD_AMOUNTS column to gain visibility of the amounts traded at each of the hops.

Notes on referrers

There is a class of aggregators termed ‘referrers’ who do not using a custom program to call their fill sources. Instead, the referrers call existing aggregators/AMMs in a direct instruction, but attach a subsequent instruction to transfer a fee for usage. e.g. of a pumpfun initiated by photon
In our dataset, aggregator trades are represented with aggregator=<aggregator> and program_id=<aggregator's program_id>
In contrast, referrer initiated trades are represented with aggregator=<referrer> and program_id=<underlying aggregator/amm's program id>

Known gaps

Due to lack of the most updated IDL, okx aggregator decoding fails for instruction methods FillOrderByResolver PlatformFeeSplProxySwap PlatformFeeSolProxySwap CommissionFillOrder. Trades for these methods will be backfilled when IDL is available. Collectively, it is estimated that these methods take up 0.5-1% of okx aggregator swaps
In dflow, there are cases such as this tx where the series of swaps resulted in excess intermediate assets leftover. These are currently termed as partial swaps and we do not include them in the final table. Partial swaps could be a result of:
- one of the swap legs giving an output less than expected, resulting in the next swap leg not executing
- one of the swap legs consuming less than expected inputs, resulting in leftover of the input asset

Data coverage

dflow, jupv6, okx: All transactions are included, regardless of whether the fill source is part of our coverage in solana.dex.trades.
All other aggregators: We rollup dex trades to get aggregator trades, so coverage is limited to that of solana.dex.trades.

Table Columns

Column Name	Data Type	Description
aggregator	VARCHAR(16777216)	The aggregator/referrer that executes the trade. See #notes-on-referrers
sender_address	VARCHAR(44)	The address of the sender emitted on the swap event logs. This can be a router or pool address, which is different from the transaction initatior transaction_from_address that initiated the swap.
to_address	VARCHAR(44)	Address where the token is being transferred to.
sender_token_acc	VARCHAR(44)	Address of the account sending the token.
to_token_acc	VARCHAR(44)	Address of the account receiving the token.
token_sold_mint	VARCHAR(44)	Mint address of the token sold.
token_sold_symbol	VARCHAR(16777216)	Symbol of the token sold.
token_sold_amount_raw	FLOAT	Raw amount of tokens sold (unnormalized).
token_sold_amount_raw_str	VARCHAR(16777216)	Raw amount of tokens sold (unnormalized) in string.
token_sold_amount	FLOAT	Amount of tokens sold.
token_sold_amount_str	VARCHAR(16777216)	Amount of tokens sold in string.
usd_sold_amount	FLOAT	Amount of token sold in USD value.
usd_sold_exchange_rate	FLOAT	USD exchange rate of the token sold.
token_bought_mint	VARCHAR(44)	Mint address of the token bought.
token_bought_symbol	VARCHAR(16777216)	Symbol of the token bought.
token_bought_amount_raw	FLOAT	Raw amount of tokens bought (unnormalized).
token_bought_amount_raw_str	VARCHAR(16777216)	Raw amount of tokens bought (unnormalized) in string.
token_bought_amount	FLOAT	Amount of tokens bought.
token_bought_amount_str	VARCHAR(16777216)	Amount of tokens bought in string.
usd_bought_amount	FLOAT	Amount of token bought in USD value.
usd_bought_exchange_rate	FLOAT	USD exchange rate of the token bought.
usd_amount	FLOAT	USD value of the token amount transferred.
token_fee_mint	VARCHAR(16777216)	Mint address of the token used to pay protocol fees (if different from the swap tokens).
raw_fees	VARCHAR(16777216)	Fees paid for the NFTs in the currency used to purchase (not divided by the number of decimals).
fees	FLOAT	Fees paid for the NFTs in this trade.
usd_fees	FLOAT	USD value of fees for this trade
fill_sources	VARIANT	The underlying fill sources that are used to fulfil the trade
tokens_sold_symbols	VARIANT	Array of tokens bought.
tokens_bought_symbols	VARIANT	Array of tokens sold.
token_pairs	VARIANT	Array of token pairs traded.
usd_amounts	VARIANT	The USD amounts traded at each of the fill sources.
signer	VARCHAR(44)	Address of the transaction signer.
block_slot	NUMBER(38,0)	Block slot of the transfer.
block_height	NUMBER(38,0)	Block height of the transfer
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the transfer.
block_hash	VARCHAR(44)	Block hash of the transfer.
txn_id	VARCHAR(88)	Transaction ID of the transfer.
txn_index	NUMBER(38,0)	Transaction Index of the transfer.
instruction_index	NUMBER(38,0)	Transfer instruction index.
inner_instruction_index	NUMBER(38,0)	Transfer inner instruction index.
program_id	VARCHAR(44)	Program ID of the program that executed the trade. See #notes-on-referrers
outer_program_id	VARCHAR(44)	Program ID of the outermost instruction that invoked this inner instruction on Solana
accounts	VARIANT	Array of pubkey addresses from the account_keys field
data	VARCHAR(16777216)	Data field.
selector	VARCHAR(16777216)	The first bytes of the program data
unique_id	VARCHAR(16777216)	Unique id of the trade.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Notes on referrers

Known gaps

Data coverage

Table Columns

​Table Details

​Notes on referrers

​Known gaps

​Data coverage

​Table Columns

Table Details

Notes on referrers

Known gaps

Data coverage

Table Columns