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_tradescontains 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:

ProjectsProtocols
1inch1inch_ar_v3, 1inch_ar_v6, 1inch_ar_v2, 1inch_ar_v4, 1inch_lop_v3, 1inch_lop_v4, 1inch_lop_v2, 1inch_ar_v5
cow_protocolcow_protocol
dodododo_x_v1, dodo_x_v2
hashflowhashflow_x
kyberswap_aggregatorkyberswap_aggregator_v2
okxokx_ar_v1
openoceanopenocean_v2
paraswapparaswap_v4, paraswap_v2, paraswap_v3, paraswap_v1, paraswap_v5
tokenlontokenlon_amm_v2, tokenlon_pmm, tokenlon_amm_v1, tokenlon_rfq_v2, tokenlon_rfq_v1
uniswap_xuniswap_x
zeroexzeroex_v4

Data Caveats

There are several data caveats that you should take note of while using this table.

  1. 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.

  2. Trades indexed from trace calls will have a -1 log index assigned.

  3. Due to the limitation of trace calls, there are edge cases where the token-bought address is null.

Table Column

Column NameDescriptionExample
projectName of the project. Includes dodo, paraswap, zeroex, cow_protocol, kyberswap_aggregator, tokenlon, openocean.cow_protocol
protocolDEX protocol or project contract which executed the aggregator trade.cow_protocol
event_nameThis field will be null for majority of DEX aggregator trades. Unless the event specifies the pools that the trade was routed through.Trade
contract_addressThe name of the event (or the function call) for this trade.0x9008d19f58aabd9ed0d60971565aa8510560ab41
liquidity_pool_addressThe contract address of the aggregator.null
sender_addressAddress of the sender of the swap event log, which can be the Router.0x2fb4aa67cc48c9dd126dc2f6a437c5c995b2732d
to_addressAddress of the recipient of the swap event.0x2fb4aa67cc48c9dd126dc2f6a437c5c995b2732d
token_sold_addressAddress of the token sold.0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
token_sold_nameName of the token sold.USD Coin
token_sold_symbolSymbol of the token sold.USDC
token_sold_amount_raw_strAmount of token sold (not divided by the number of decimals) in string.6250000000
token_sold_amount_rawAmount of token sold (not divided by the number of decimals).6250000000
token_sold_amount_strtoken_sold_amount_raw divided by the number of decimals of the token in string.6250
token_sold_amounttoken_sold_amount_raw divided by the number of decimals of the token.6250
usd_sold_amountUSD value of tokens sold.6245
token_bought_addressToken address of the token bought, i.e. the asset acquired from the trade.0xccccb68e1a848cbdb5b60a974e07aae143ed40c3
token_bought_nameName of the token bought.TOPIA
token_bought_symbolSymbol of the token bought.TOPIA
token_bought_amount_raw_strAmount of token bought (not divided by the number of decimals) in string.64632249553876898925672
token_bought_amount_rawAmount of token bought (not divided by the number of decimals).6.46322E+22
token_bought_amount_strtoken_bought_amount_raw divided by the number of decimals of the token in string.64632.24955
token_bought_amounttoken_bought_amount_raw divided by the number of decimals of the token.64632.24955
usd_bought_amountUSD value of tokens bought.6048.867603
usd_amountUSD value of the swap. Note that this preferentially selects the price and value of the more reputable token.6245
extra_fieldsThis 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_addressThe address of the sending party of this transaction.0xbf54079c9bc879ae4dd6bc79bce11d3988fd9c2b
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).0x9008d19f58aabd9ed0d60971565aa8510560ab41
transaction_hashTransaction hash of this trade.0x7a3be25e6fffa9fd29ef9aa9eafdfd0d8ee4a24aedb074ebb6c1a473ce750fce
transaction_indexTransaction index of this trade in the block.17
transaction_feesFees paid at the transaction level.0.02354155877
transaction_fees_usdFees paid in USD.95.02173534
fee_detailsAdditional 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_selectorThe call data selector of the transaction.0x13d79a0b
log_indexLog index of this trade.42
block_timestampBlock timestamp of this trade.2024-03-11 12:48:59
block_numberBlock number of this trade.19411959
block_hashBlock hash of this trade.0xe1944bbf513fa729bc78f34bee665dfafebede27cb73fd99d86ed4265c2b0852
unique_idUnique ID of each trade.txn-0x7a3be25e6fffa9fd29ef9aa9eafdfd0d8ee4a24aedb074ebb6c1a473ce750fce_log_index-42
_created_atTimestamp of the entry creation.2024-04-16 11:46:12
_updated_atTimestamp of the entry update.2024-04-16 11:46:12
_changed_since_full_refreshWhether the entry was recreated.FALSE