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

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

Column Name
Description
Example

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