Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
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 |
|---|
| orca | orca-v1, orca-v2, orca-whirlpool |
| raydium | raydium-v4, raydium-clmm, raydium-stable, raydium-cp |
| saber | saber-stableswap |
| lifinity | lifinity-v2, lifinity-v1 |
| mercurial | mercurial |
| meteora | meteora, meteora-dlmm, meteora-vault |
| marinade | marinade |
| stepn | stepn |
| openbook | openbook, openbook-v2 |
| crema | clmm-v2 |
| symmetry | symmetry |
| invariant | invariant |
| phoenix | phoenix |
| cropper | cropper-whirlpool |
| pumpfun | pumpfun |
| goosefx | goosefx-ssl, goosefx-ssl-v2 |
| fluxbeam | fluxbeam |
| dexscreener-moonshot | dexscreener-moonshot |
| stabble | stabble, stabble-weighted |
| jupiter | jupiter-perp |
| obric | obric-v2 |
| solfi | solfi |
| zerofi | zerofi |
| aldrin | aldrin-v1, aldrin-v2 |
| sanctum | sanctum |
| virtuals | virtuals |
| pumpswap | pumpswap |
| gamma | gamma |
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. | 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 | […] |
| data | Data field. | varchar | eDt4c2UN1PNdapr97JsGk7 |
| selector | Selector data. | varchar | 1 |
| unique_id | Unique id of the trade. | varchar | txn_id-…_i_index-0_ii_index-4 |
