# 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>

####