Aggregator Trades
Dex trades from aggregators.
This table is not compatible with dex.trades
in terms of columns. There are additional gas fees and transaction details available on DEX aggregator trades.
ethereum.dex.aggregator_trades
contains successful DEX trades from DEX aggregators.
In addition to the convention fields involved in DEX swaps, this table includes transaction fees, extra fee details (priority fees), and additional fields emitted specifically to each aggregator contract.
Coverage
The project and protocol coverage for our aggregator_trades
table includes:
Projects | Protocols |
---|---|
1inch | 1inch_ar_v3, 1inch_ar_v6, 1inch_ar_v2, 1inch_ar_v4, 1inch_lop_v3, 1inch_lop_v4, 1inch_lop_v2, 1inch_ar_v5 |
cow_protocol | cow_protocol |
dodo | dodo_x_v1, dodo_x_v2 |
hashflow | hashflow_x |
kyberswap_aggregator | kyberswap_aggregator_v2 |
okx | okx_ar_v1 |
openocean | openocean_v2 |
paraswap | paraswap_v4, paraswap_v2, paraswap_v3, paraswap_v1, paraswap_v5 |
tokenlon | tokenlon_amm_v2, tokenlon_pmm, tokenlon_amm_v1, tokenlon_rfq_v2, tokenlon_rfq_v1 |
uniswap_x | uniswap_x |
zeroex | zeroex_v4 |
Data Caveats
There are several data caveats that you should take note of while using this table.
The scope of DEXs and calls indexed in this table represents a subset of all on-chain DEX aggregator volume. For protocols and projects covered, please refer to the list above.
Trades indexed from trace calls will have a
-1
log index assigned.Due to the limitation of trace calls, there are edge cases where the token-bought address is null.
Table Column
Column Name | Description | Example |
---|---|---|
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 |
Last updated