Trades
This table contains dex trades that are direct program calls to a liquidity source.
solana.dex.trades contains instruction level swap data from major dex protocols and projects on Solana network.
DEX Coverage
The existing project and protocol coverage includes:
saber
saber-stableswap
meteora
meteora
crema
clmm-v2
raydium
raydium-clmm, raydium-v4, raydium-stable
lifinity
lifinity-v2, lifinity-v1
mercurial
mercurial
stepn
stepn
symmetry
symmetry
orca
orca-v1, orca-v2, orca-whirlpool
invariant
invariant
phoenix
phoenix
Aggregator Coverage
Swaps routed through aggregators are also tagged. Existing aggregator coverage includes:
Jupiter
jupiter-aggregator-v2, jupiter-aggregator-v3, jupiter-aggregator-v4, jupiter-aggregator-v5, jupiter-aggregator-v5.1, jupiter-aggregator-v6
Others
drift, kamino, raydium-router, saber-router com
Table Columns
project
The project (decentralized exchange) of the liquidity pool that the swap occurred from.
varchar
saber
protocol
Version of the protocol.
varchar
saber-stableswap
aggregator
Aggregator, if available.
varchar
jupiter-aggregator-v4
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.
varchar
9doNJz52PMd8bi3FKRV9gfXa5nXLDjoW1SBVMbmAuuSh
to_address
Address where the token is being transferred to.
varchar
9doNJz52PMd8bi3FKRV9gfXa5nXLDjoW1SBVMbmAuuSh
sender_token_acc
Address of the account sending the token.
varchar
GaamrfkoR862pJDUBPzzrdZny4RSNFxUr8f7eRYRKqrq
to_token_acc
Address of the account receiving the token.
varchar
Dv7HRmd6MTPghRpLSr6aS6y9z638E6Apx3W7w5CabNrR
token_sold_mint
Mint address of the token sold.
varchar
7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj
token_sold_symbol
Symbol of the token sold.
varchar
stSOL
token_sold_amount_raw
Raw amount of tokens sold (unnormalized).
float
428,240,429
token_sold_amount_raw_str
Raw amount of tokens sold (unnormalized) in string.
varchar
428240429
token_sold_amount
Amount of tokens sold.
float
0.428240429
token_sold_amount_str
Amount of tokens sold in string.
varchar
0.428240429
usd_sold_amount
Amount of token sold in USD value.
float
10.01002788
usd_sold_exchange_rate
USD exchange rate of the token sold.
float
23.3748172
token_bought_mint
Mint address of the token bought.
varchar
So11111111111111111111111111111111111111112
token_bought_symbol
Symbol of the token bought.
varchar
SOL
token_bought_amount_raw
Raw amount of tokens bought (unnormalized).
float
472,388,367
token_bought_amount_raw_str
Raw amount of tokens bought (unnormalized) in string.
varchar
472388367
token_bought_amount
Amount of tokens bought.
float
0.472388367
token_bought_amount_str
Amount of tokens bought in string.
varchar
0.472388367
usd_bought_amount
Amount of token bought in USD value.
float
9.995737846
usd_bought_exchange_rate
USD exchange rate of the token bought.
float
21.16
usd_amount
USD value of the token amount transferred.
float
9.995737846
tokens_sold_symbols
Array of tokens bought.
variant
[ "stSOL" ]
tokens_bought_symbols
Array of tokens sold.
variant
[ "SOL" ]
token_pairs
Array of token pairs traded.
variant
[ "stSOL-SOL" ]
signer
Address of the transaction signer.
varchar
9doNJz52PMd8bi3FKRV9gfXa5nXLDjoW1SBVMbmAuuSh
block_slot
Block slot of the transfer.
number
192,826,770
block_height
Block height of the transfer
number
175,699,063
block_timestamp
Block timestamp of the transfer.
timestamp_ntz
2023-05-08 16:47:45
block_hash
Block hash of the transfer.
varchar
xSiG9AgdNfgKRhXyrd92EgLuQ5N6NVURdHNFN5U3TPM
txn_id
Transaction ID of the transfer.
varchar
2HtfMAqb1meoJHB1kmDvPzfZWpjDu3JYV5cmruftATE2VpgASSEUtjsYdc3CD86vyM9RJAGMZDHx6ZFM5VvgiJMX
txn_index
Transaction Index of the transfer.
number
747
instruction_index
Transfer instruction index.
number
0
inner_instruction_index
Transfer inner instruction index.
number
4
program_id
Program ID.
varchar
SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ
accounts
Array of account addresses involved in the trade.
variant
<too long to display>
data
Data field.
varchar
eDt4c2UN1PNdapr97JsGk7
selector
Selector data.
varchar
1
unique_id
Unique id of the trade.
varchar
txn_id-2HtfMAqb1meoJHB1kmDvPzfZWpjDu3JYV5cmruftATE2VpgASSEUtjsYdc3CD86vyM9RJAGMZDHx6ZFM5VvgiJMX_i_index-0_ii_index-4
Last updated
Was this helpful?