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:
raydium-router
jupiter-aggregator-v2
jupiter-aggregator-v3
jupiter-aggregator-v4
jupiter-aggregator-v5
jupiter-aggregator-v5.1
jupiter-aggregator-v6
saber-router
photon
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>
Table Columns
aggregator
The aggregator/referrer that executes the trade. See Notes on referrers
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 of the program that executed the trade. See Notes on referrers
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
Last updated