DEX
Aggregator Trades
DEX
Aggregator Trades
Identify swap volumes executed from DEX aggregators.
The dex.aggregator_trades table contains successful swaps executed by DEX aggregators.
DEX aggregators scan multiple decentralized exchanges (DEXs) simultaneously to find the best trading prices and routes for users, often splitting trades across different liquidity sources to optimize for better rates and lower slippage.
DEX Trades vs Aggregator Trades
DEX projects that execute trades tapping on the liquidity of other protocols/project/market makers or contracts will be included in the aggregator_trades table.
| Feature | DEX Trades | DEX Aggregator Trades |
|---|---|---|
| Liquidity Source | Single liquidity pool (e.g., one Uniswap pool) | Multiple pools/DEXs in one transaction (e.g., split between Uniswap, Curve, Balancer) |
| Route Complexity | Simple A → B swap | Complex routes possible (A → B → C → D) with multi-hop optimization |
| Price Discovery | Price determined by single pool’s AMM formula | Best price found by comparing across multiple DEXs and routes |
This model is not compatible with dex.trades in terms of column coverage. There are integrator fields that are only applicable for dex aggregators.
Table Column
Unique Key: unique_id
| Column Name | Description | Example |
|---|---|---|
| integrator | Name of the integrator/frontend used for the trade (e.g., matcha, 1inch) inferred from the integrator tag. This will be null if there are no integrator | |
| integrator_tag | Contract address, event log field or other relevant field that is used to indicate the frontend integrator | |
| project | Name of the project. Includes dodo, paraswap, zeroex, cow_protocol, kyberswap_aggregator, tokenlon, openocean. | cow_protocol |
| protocol | DEX protocol or project contract which executed the aggregator trade. | cow_protocol |
| event_name | This field will be null for majority of DEX aggregator trades. Unless the event specifies the pools that the trade was routed through. | Trade |
| contract_address | The name of the event (or the function call) for this trade. | 0x9008d19f58aabd9ed0d60971565aa8510560ab41 |
| liquidity_pool_address | The contract address of the aggregator. | null |
| sender_address | Address of the sender of the swap event log, which can be the Router. | 0x2fb4aa67cc48c9dd126dc2f6a437c5c995b2732d |
| to_address | Address of the recipient of the swap event. | 0x2fb4aa67cc48c9dd126dc2f6a437c5c995b2732d |
| token_sold_address | Address of the token sold. | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
| token_sold_name | Name of the token sold. | USD Coin |
| token_sold_symbol | Symbol of the token sold. | USDC |
| token_sold_amount_raw_str | Amount of token sold (not divided by the number of decimals) in string. | 6250000000 |
| token_sold_amount_raw | Amount of token sold (not divided by the number of decimals). | 6250000000 |
| token_sold_amount_str | token_sold_amount_raw divided by the number of decimals of the token in string. | 6250 |
| token_sold_amount | token_sold_amount_raw divided by the number of decimals of the token. | 6250 |
| usd_sold_amount | USD value of tokens sold. | 6245 |
| token_bought_address | Token address of the token bought, i.e. the asset acquired from the trade. | 0xccccb68e1a848cbdb5b60a974e07aae143ed40c3 |
| token_bought_name | Name of the token bought. | TOPIA |
| token_bought_symbol | Symbol of the token bought. | TOPIA |
| token_bought_amount_raw_str | Amount of token bought (not divided by the number of decimals) in string. | 64632249553876898925672 |
| token_bought_amount_raw | Amount of token bought (not divided by the number of decimals). | 6.46322E+22 |
| token_bought_amount_str | token_bought_amount_raw divided by the number of decimals of the token in string. | 64632.24955 |
| token_bought_amount | token_bought_amount_raw divided by the number of decimals of the token. | 64632.24955 |
| usd_bought_amount | USD value of tokens bought. | 6048.867603 |
| usd_amount | USD value of the swap. Note that this preferentially selects the price and value of the more reputable token. | 6245 |
| extra_fields | This field contains all the extra columns emitted from the event/function call that were not part of the convetional DEX trades columns. | { "fee\_amount": "0", "order\_uid": "0E839EC0B7F089F2337620489748E70BA616417C506B3C6BCC7749CAEFE2F3C32FB4AA67CC48C9DD126DC2F6A437C5C995B2732D65EF27BA" } |
| transaction_from_address | The address of the sending party of this transaction. | 0xbf54079c9bc879ae4dd6bc79bce11d3988fd9c2b |
| transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | 0x9008d19f58aabd9ed0d60971565aa8510560ab41 |
| transaction_hash | Transaction hash of this trade. | 0x7a3be25e6fffa9fd29ef9aa9eafdfd0d8ee4a24aedb074ebb6c1a473ce750fce |
| transaction_index | Transaction index of this trade in the block. | 17 |
| transaction_fees | Fees paid at the transaction level. | 0.02354155877 |
| transaction_fees_usd | Fees paid in USD. | 95.02173534 |
| fee_details | Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction. | { "base\_fee\_per\_gas": 88733305846, "block\_gas\_limit": 30000000, "block\_gas\_used": 12073153, "gas": 502304, "gas\_price": 93734307405, "max\_fee\_per\_gas": 358721698469, "max\_priority\_fee\_per\_gas": 5001001559, "priority\_fees": "0.001256011543545968", "priority\_fees\_usd": 5.069689633676332e+00, "priority\_gas\_fee": "5001001559", "receipt\_effective\_gas\_price": 93734307405, "receipt\_gas\_used": 251152 } |
| calldata_selector | The call data selector of the transaction. | 0x13d79a0b |
| log_index | Log index of this trade. | 42 |
| block_timestamp | Block timestamp of this trade. | 2024-03-11 12:48:59 |
| block_number | Block number of this trade. | 19411959 |
| block_hash | Block hash of this trade. | 0xe1944bbf513fa729bc78f34bee665dfafebede27cb73fd99d86ed4265c2b0852 |
| unique_id | Unique ID of each trade. | txn-0x7a3be25e6fffa9fd29ef9aa9eafdfd0d8ee4a24aedb074ebb6c1a473ce750fce_log_index-42 |
| _created_at | Timestamp of the entry creation. | 2024-04-16 11:46:12 |
| _updated_at | Timestamp of the entry update. | 2024-04-16 11:46:12 |
| _changed_since_full_refresh | Whether the entry was recreated. | FALSE |