Dex
Trades
Dex
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.
If you require tx-level detail for records in this table, see here for more info.
DEX Coverage
The existing project and protocol coverage includes:
| Project | Protocols Supported |
|---|---|
| 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:
| Aggregators | Versions |
|---|---|
| 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
| Column Name | Description | Type | Example |
|---|---|---|---|
| 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 |