Dex Swaps
Chain
SolanaDataset name
solana.dex_swapsVersion
1.0.0Description
Decoded Solana DEX swaps including the bought and sold token mints with amounts, the DEX program, and the trader, transaction, and instruction identifiers.
Example data
| id | project | version | block_timestamp | block_slot | trade_source | token_bought_amount | token_sold_amount | token_bought_amount_raw | token_sold_amount_raw | token_bought_mint_address | token_sold_mint_address | token_bought_decimals | token_sold_decimals | project_main_id | trader_id | tx_id | instruction_index | parent_instruction_index |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| kMJyi7Y8bbGLPgdXXVcwi3MDtHmrc7xh3YoX6UTg7SvWinY6WdZ6xzFFhx2eJtp2TUfWJ2gP3EsmoX61HustaDP_3 | pump_amm | 1 | 1788915836 | 445481234 | direct | 39640982.560065 | 12.263942719 | 39640982560065 | 12263942719 | 8ANwef8thLHXRyx7UTfdm5ihhysUd1mveJQL8nsJhayt | So11111111111111111111111111111111111111112 | 6 | 9 | pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA | 3XHKmFHK27YBuFMZvugoCoxep2p21KS3X55c2Rp3pwzH | kMJyi7Y8bbGLPgdXXVcwi3MDtHmrc7xh3YoX6UTg7SvWinY6WdZ6xzFFhx2eJtp2TUfWJ2gP3EsmoX61HustaDP | 3 | |
| pJtZioNBtiRSy8F3C5ZKmKzyjDa52JKnTVeLtNYdEwR7yUChNGZHN8KMnuxrCZPsZ9dvn47qKXkCRwC2cVBUA66_5_3 | raydium_clmm | 2 | 1788915836 | 445481234 | FLASHX8DrLbgeR8FcfNV1F5krxYcYMUdBkrP1EPBtxB9 | 84.006753 | 0.79459785 | 84006753 | 79459785 | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | Xs78JED6PFZxWc2wCEPspZW9kL3Se5J7L5TChKgsidH | 6 | 8 | CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK | GJ66YhpB7cNXwxeH55ZauwihqQ1e263Z3E3PbZjjtPkr | pJtZioNBtiRSy8F3C5ZKmKzyjDa52JKnTVeLtNYdEwR7yUChNGZHN8KMnuxrCZPsZ9dvn47qKXkCRwC2cVBUA66 | 5 | 3 |
| 4gLLScD1AttvKFCcafuFvjR7gcbnM3SWeTxvqNYZhpdST2v4kPNKhngknRDeHTuB7SX9rRT3zu8kEebSGPyrj5pu_1 | orca_whirlpool | 2 | 1788915836 | 445481234 | direct | 72.6267 | 51.052102 | 72626700 | 51052102 | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE | 6 | 6 | whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc | MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa | 4gLLScD1AttvKFCcafuFvjR7gcbnM3SWeTxvqNYZhpdST2v4kPNKhngknRDeHTuB7SX9rRT3zu8kEebSGPyrj5pu | 1 |
Schema
| Column | Type |
|---|---|
| id | string |
| project | string |
| version | long |
| block_timestamp | long |
| block_slot | long |
| trade_source | string |
| token_bought_amount | decimal |
| token_sold_amount | decimal |
| token_bought_amount_raw | long |
| token_sold_amount_raw | long |
| token_bought_mint_address | string |
| token_sold_mint_address | string |
| token_bought_decimals | long |
| token_sold_decimals | long |
| project_main_id | string |
| trader_id | string |
| tx_id | string |
| instruction_index | long |
| parent_instruction_index | long |