# DEX Trades

#### How we are indexing our dex\_trades table?

\
We have written a Substreams to index this data. Substreams is a powerful blockchain indexing technology developed by [StreamingFast](https://www.streamingfast.io/). You can take a look at our indexing code [here](https://github.com/Topledger/solana-programs/tree/main/dex-trades).

The table below contains the project names and their respective program addresses that we have included in our dex\_trades table.

<table data-full-width="true"><thead><tr><th width="160">Platform Name</th><th width="464">DAPP</th><th>Instructions</th></tr></thead><tbody><tr><td>Pheonix</td><td><a href="https://solscan.io/account/PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY">PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY</a></td><td>Swap</td></tr><tr><td>Saros</td><td><a href="https://solscan.io/account/SSwapUtytfBdBn1b9NUGG6foMVPtcWgpRU32HToDUZr">SSwapUtytfBdBn1b9NUGG6foMVPtcWgpRU32HToDUZr</a></td><td>Swap</td></tr><tr><td>Stepn</td><td><a href="https://solscan.io/account/Dooar9JkhdZ7J3LHN3A7YCuoGRUggXhQaG4kijfLGU2j">Dooar9JkhdZ7J3LHN3A7YCuoGRUggXhQaG4kijfLGU2j</a></td><td>Swap</td></tr><tr><td>Crema</td><td><a href="https://solscan.io/account/CLMM9tUoggJu2wagPkkqs9eFG4BWhVBZWkP1qv3Sp7tR">CLMM9tUoggJu2wagPkkqs9eFG4BWhVBZWkP1qv3Sp7tR</a></td><td>SwapWithPartner</td></tr><tr><td>Meteora</td><td><a href="https://solscan.io/account/Eo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB">Eo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB</a></td><td>Swap</td></tr><tr><td>Openbook</td><td><a href="https://solscan.io/account/srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX">srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX</a></td><td>Serum3PlaceOrder</td></tr><tr><td>Openbook V2</td><td><a href="https://solscan.io/account/opnb2LAfJYbRMAHHvqjCwQxanZn7ReEHp1k81EohpZb">opnb2LAfJYbRMAHHvqjCwQxanZn7ReEHp1k81EohpZb</a></td><td></td></tr><tr><td>Symmetry</td><td><a href="https://solscan.io/account/2KehYt3KsEQR53jYcxjbQp2d2kCp4AkuQW68atufRwSr">2KehYt3KsEQR53jYcxjbQp2d2kCp4AkuQW68atufRwSr</a></td><td>SwapFundTokens</td></tr><tr><td>Invariant</td><td><a href="https://solscan.io/account/HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt">HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt</a></td><td>Swap</td></tr><tr><td>Orca Liquidity Pools</td><td><a href="https://solscan.io/account/whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc">whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc</a></td><td>Swap</td></tr><tr><td>Lifinity v1</td><td><a href="https://solscan.io/account/EewxydAPCCVuNEyrVN68PuSYdQ7wKn27V9Gjeoi8dy3S">EewxydAPCCVuNEyrVN68PuSYdQ7wKn27V9Gjeoi8dy3S</a></td><td>Swap</td></tr><tr><td>Lifinity v2</td><td><a href="https://solscan.io/account/2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c">2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c</a></td><td>Swap</td></tr><tr><td>Saber</td><td><a href="https://solscan.io/account/SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ">SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ</a></td><td>Swap</td></tr><tr><td>Raydium v4</td><td><a href="https://solscan.io/account/675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8">675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8</a></td><td>SwapBaseIn</td></tr><tr><td>Raydium v3</td><td><a href="https://solscan.io/account/27haf8L6oxUeXrHrgEgsexjSY5hbVUWEmvv9Nyxg8vQv">27haf8L6oxUeXrHrgEgsexjSY5hbVUWEmvv9Nyxg8vQv</a></td><td>SwapBaseIn</td></tr><tr><td>Raydium CLMM</td><td><a href="https://solscan.io/account/CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK">CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK</a></td><td>Swap</td></tr><tr><td>Orca legacy</td><td><a href="https://solscan.io/account/9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP">9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP</a></td><td>Swap</td></tr><tr><td>Aldrin AMM</td><td><a href="https://solscan.io/account/AMM55ShdkoGRB5jVYPjWziwk8m5MpwyDgsMWHaMSQWH6">AMM55ShdkoGRB5jVYPjWziwk8m5MpwyDgsMWHaMSQWH6</a></td><td>Swap</td></tr><tr><td>Aldrin AMM v2</td><td><a href="https://solscan.io/account/CURVGoZn8zycx6FXwwevgBTB2gVvdbGTEpvMJDbgs2t4">CURVGoZn8zycx6FXwwevgBTB2gVvdbGTEpvMJDbgs2t4</a></td><td>Swap</td></tr><tr><td>Cropper</td><td><a href="https://solscan.io/account/CTMAxxk34HjKWxQ3QLZK1HpaLXmBveao3ESePXbiyfzh">CTMAxxk34HjKWxQ3QLZK1HpaLXmBveao3ESePXbiyfzh</a></td><td>Swap</td></tr><tr><td>Cykura</td><td><a href="https://solscan.io/account/cysPXAjehMpVKUapzbMCCnpFxUFFryEWEaLgnb9NrR8">cysPXAjehMpVKUapzbMCCnpFxUFFryEWEaLgnb9NrR8</a></td><td>ExactInputSingle</td></tr><tr><td>GooseFX</td><td><a href="https://solscan.io/account/7WduLbRfYhTJktjLw5FDEyrqoEv61aTTCuGAetgLjzN5">7WduLbRfYhTJktjLw5FDEyrqoEv61aTTCuGAetgLjzN5</a></td><td>Swap</td></tr><tr><td>GooseFX V2</td><td><a href="https://solscan.io/account/GFXsSL5sSaDfNFQUYsHekbWBW1TsFdjDYzACh62tEHxn">GFXsSL5sSaDfNFQUYsHekbWBW1TsFdjDYzACh62tEHxn</a></td><td>Swap</td></tr><tr><td>BonkSwap</td><td><a href="https://solscan.io/account/BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p">BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p</a></td><td>Swap</td></tr><tr><td>FluxBeam</td><td><a href="https://solscan.io/account/FLUXubRmkEi2q6K3Y9kBPg9248ggaZVsoSFhtJHSrm1X">FLUXubRmkEi2q6K3Y9kBPg9248ggaZVsoSFhtJHSrm1X</a></td><td>Swap</td></tr><tr><td>Penguin</td><td><a href="https://solscan.io/account/PSwapMdSai8tjrEXcxFeQth87xC4rRsa4VA5mhGhXkP">PSwapMdSai8tjrEXcxFeQth87xC4rRsa4VA5mhGhXkP</a></td><td>Swap</td></tr><tr><td>Balansol</td><td><a href="https://solscan.io/account/D3BBjqUdCYuP18fNvvMbPAZ8DpcRi4io2EsYHQawJDag">D3BBjqUdCYuP18fNvvMbPAZ8DpcRi4io2EsYHQawJDag</a></td><td>Swap</td></tr><tr><td>Step Finance</td><td><a href="https://solscan.io/account/SSwpMgqNDsyV7mAgN9ady4bDVu5ySjmmXejXvy2vLt1">SSwpMgqNDsyV7mAgN9ady4bDVu5ySjmmXejXvy2vLt1</a></td><td>Swap</td></tr><tr><td>Sencha</td><td><a href="https://solscan.io/account/SCHAtsf8mbjyjiv4LkhLKutTf6JnZAbdJKFkXQNMFHZ">SCHAtsf8mbjyjiv4LkhLKutTf6JnZAbdJKFkXQNMFHZ</a></td><td>Swap</td></tr><tr><td>Dradex</td><td><a href="https://solscan.io/account/dp2waEWSBy5yKmq65ergoU3G6qRLmqa6K7We4rZSKph">dp2waEWSBy5yKmq65ergoU3G6qRLmqa6K7We4rZSKph</a></td><td>CreateOrder</td></tr><tr><td>Oasis</td><td><a href="https://solscan.io/account/9tKE7Mbmj4mxDjWatikzGAtkoWosiiZX9y6J4Hfm2R8H">9tKE7Mbmj4mxDjWatikzGAtkoWosiiZX9y6J4Hfm2R8H</a></td><td>Swap</td></tr><tr><td>Mercurial</td><td><a href="https://solscan.io/account/MERLuDFBMmsHnsBPZw2sDQZHvXFMwp8EdjudcU2HKky">MERLuDFBMmsHnsBPZw2sDQZHvXFMwp8EdjudcU2HKky</a></td><td>Exchange</td></tr><tr><td>Orca v1</td><td><a href="https://solscan.io/account/DjVE6JNiYqPL2QXyCUUh8rNjHrbz9hXHNYt99MQ59qw1">DjVE6JNiYqPL2QXyCUUh8rNjHrbz9hXHNYt99MQ59qw1</a></td><td>Swap</td></tr><tr><td>Crema</td><td><a href="https://solscan.io/account/6MLxLqiXaaSUpkgMnWDTuejNZEz3kE7k2woyHGVFw319">6MLxLqiXaaSUpkgMnWDTuejNZEz3kE7k2woyHGVFw319</a></td><td>Swap</td></tr></tbody></table>

#### **dex\_trades**

The table below contains all the dex\_trades table columns , such as signer,  pool\_address, base\_mint, quote\_mint, amount, etc.

<table><thead><tr><th width="221.33333333333331">Column Name</th><th width="139">Column Type</th><th>Description</th></tr></thead><tbody><tr><td>block_time</td><td>timestamp</td><td>The time this block was produced</td></tr><tr><td>block_slot</td><td>bigint</td><td>This block’s slot index in the ledger</td></tr><tr><td>tx_id</td><td>string</td><td>The first signature in the transaction</td></tr><tr><td>signer</td><td>string</td><td>The first value from the account_keys array that initiates the transaction and pays the transaction fee</td></tr><tr><td>pool_address</td><td>string</td><td>The  address of the pool</td></tr><tr><td>base_mint</td><td>string</td><td>Mint of the base token</td></tr><tr><td>quote_mint</td><td>string</td><td>Mint of the quote token</td></tr><tr><td>base_vault</td><td>string</td><td>Vault address of the base token</td></tr><tr><td>quote_vault</td><td>string</td><td>Vault address of the quote token</td></tr><tr><td>base_amount</td><td>double</td><td>Amount of the base token that is traded in the transaction</td></tr><tr><td>quote_amount</td><td>double</td><td>Amount of the quote token that is traded in the transaction</td></tr><tr><td>is_inner_instruction</td><td>boolean</td><td>Tells whether there is any inner instruction in the transaction or not </td></tr><tr><td>instruction_index</td><td>int</td><td>Instruction index of various instructions in a transaction</td></tr><tr><td>instruction_type</td><td>string</td><td>Name of the function of a Solana program invoked via an instruction</td></tr><tr><td>inner_instruxtion_index</td><td>int</td><td>Index of various inner instructions in a instruction</td></tr><tr><td>outer_program</td><td>string</td><td>The main program of an instruction</td></tr><tr><td>inner_program</td><td>string</td><td>The inner programs under the main/outer program</td></tr><tr><td>txn_fee</td><td>big_int</td><td>Fee this transaction was charged, as paid signer</td></tr><tr><td>signer_sol_change</td><td>bigint</td><td>Sol balance change of signer</td></tr><tr><td>partition_0</td><td>string</td><td>The date on which the block was produced</td></tr></tbody></table>

####


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.topledger.xyz/data-tables/smart-tables/dex-trades.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.