Aggregator Trades

This table contains aggregator trades that are direct program calls to an aggregator program which in turn calls one or more liquidity sources to execute the trade.

solana.dex.aggregator_trades currently includes the following aggregator programs:

Program
raydium-router
jupiter-aggregator-v2
jupiter-aggregator-v3
jupiter-aggregator-v4
jupiter-aggregator-v5
jupiter-aggregator-v5.1
jupiter-aggregator-v6
saber-router

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.

Table Columns

Column Name	Description	Example
aggregator	The aggregator that executes the trade	jupiter-v4-aggregator
sender_address	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.	9doNJz52PMd8bi3FKRV9gfXa5nXLDjoW1SBVMbmAuuSh
to_address	Address where the token is being transferred to.	9doNJz52PMd8bi3FKRV9gfXa5nXLDjoW1SBVMbmAuuSh
sender_token_acc	Address of the account sending the token.	GaamrfkoR862pJDUBPzzrdZny4RSNFxUr8f7eRYRKqrq
to_token_acc	Address of the account receiving the token.	Dv7HRmd6MTPghRpLSr6aS6y9z638E6Apx3W7w5CabNrR
token_sold_mint	Mint address of the token sold.	7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj
token_sold_symbol	Symbol of the token sold.	stSOL
token_sold_amount_raw	Raw amount of tokens sold (unnormalized).	428,240,429
token_sold_amount_raw_str	Raw amount of tokens sold (unnormalized) in string.	428240429
token_sold_amount	Amount of tokens sold.	0.428240429
token_sold_amount_str	Amount of tokens sold in string.	0.428240429
usd_sold_amount	Amount of token sold in USD value.	10.01002788
usd_sold_exchange_rate	USD exchange rate of the token sold.	23.3748172
token_bought_mint	Mint address of the token bought.	So11111111111111111111111111111111111111112
token_bought_symbol	Symbol of the token bought.	SOL
token_bought_amount_raw	Raw amount of tokens bought (unnormalized).	472,388,367
token_bought_amount_raw_str	Raw amount of tokens bought (unnormalized) in string.	472388367
token_bought_amount	Amount of tokens bought.	0.472388367
token_bought_amount_str	Amount of tokens bought in string.	0.472388367
usd_bought_amount	Amount of token bought in USD value.	9.995737846
usd_bought_exchange_rate	USD exchange rate of the token bought.	21.16
usd_amount	USD value of the token amount transferred.	9.995737846
fill_sources	The underlying fill sources that are used to fulfil the trade	[ "orca|orca-v2", "raydium|raydium-clmm", "raydium|raydium-v4", "raydium|raydium-clmm" ]
usd_amounts	The USD amounts traded at each of the fill sources.	[ "12.859238804", "12.818011912", "8.575348968", "8.548017279" ]
tokens_sold_symbols	Array of tokens bought.	[ "soBTC", "mSOL", "soBTC", "stSOL" ]
tokens_bought_symbols	Array of tokens sold.	[ "mSOL", "SOL", "stSOL", "SOL" ]
token_pairs	Array of token pairs traded.	[ "soBTC-mSOL", "mSOL-SOL", "soBTC-stSOL", "stSOL-SOL" ]
signer	Address of the transaction signer.	9doNJz52PMd8bi3FKRV9gfXa5nXLDjoW1SBVMbmAuuSh
block_slot	Block slot of the transfer.	192,826,770
block_height	Block height of the transfer	175,699,063
block_timestamp	Block timestamp of the transfer.	2023-05-08 16:47:45
block_hash	Block hash of the transfer.	xSiG9AgdNfgKRhXyrd92EgLuQ5N6NVURdHNFN5U3TPM
txn_id	Transaction ID of the transfer.	2HtfMAqb1meoJHB1kmDvPzfZWpjDu3JYV5cmruftATE2VpgASSEUtjsYdc3CD86vyM9RJAGMZDHx6ZFM5VvgiJMX
txn_index	Transaction Index of the transfer.	747
instruction_index	Transfer instruction index.	0
inner_instruction_index	Transfer inner instruction index.	4
program_id	Program ID.	SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ
accounts	Array of pubkey addresses from the account_keys field	<too long to display>
data	Data field.	eDt4c2UN1PNdapr97JsGk7
selector	The first bytes of the program data	e5
unique_id	Unique id of the trade.	txn_id-2HtfMAqb1meoJHB1kmDvPzfZWpjDu3JYV5cmruftATE2VpgASSEUtjsYdc3CD86vyM9RJAGMZDHx6ZFM5VvgiJMX_i_index-0_ii_index-4