🌱Aggregator Trades

Dex trades from aggregators.

This table is current in beta.

Column names and fields may be changed.

Data freshness is ~ 1 day.

This table is not compatible with dex.trades in terms of columns including.

ethereum.dex.aggregator_trades_betacontains successful DEX trades from aggregator.

In addition to the convention fields involved in swaps, this table includes transaction fees, fee details (priority fees) as well as additional fields emitted specific to each aggregator contract.

Coverage

The following projects, protocols and the corresponding events or function calls are indexed for DEX aggregator trades.

In the event where there are no logs emitted, we will refer to the function calls.

ProjectProtocolEvent/Function Call

uniswap_x

uniswap_x

executeBatchWithCallback, executeBatch, execute executeWithCallback

1inch

1inch_ar_v2,

1inch_ar_v3,

1inch_ar_v4, 1inch_lop_v2

1inch_ar_v2: Swapped

1inch_ar_v3: Swapped

1inch_ar_v4: unoswap, unoswapWithPermit, clipperSwapToWithPermit, clipperSwap, swap, uniswapV3SwapCallback

1inch_lop_v2: fillOrderRFQToWithPermit, fillOrderRFQTo, fillOrderRFQ

1inch

1inch_ar_v5, 1inch_lop_v3

1inch_ar_v5: swap, unoswapTo, unoswap, unoswapToWithPermit, clipperSwap, clipperSwapTo, clipperSwapToWithPermit, uniswapV3SwapCallback 1inch_lop_v3: fillOrderRFQ, fillOrder, fillOrderRFQCompact, fillOrderRFQToWithPermit, fillOrderRFQTo, fillOrderTo, fillOrderToWithPermit

cow_protocol

cow_protocol

Trade

dodo

dodo_x_v2, dodo_x_v1

OrderHistory

kyberswap_aggregator

kyberswap_aggregator_v2

Swapped

openocean

openocean_v2

Swapped

paraswap

paraswap_v5

Swapped, BoughtV3, SwappedDirect, Bought2, Bought, SwappedV3, Swapped2

tokenlon

tokenlon_rfq

FillOrder

zeroex

zeroex_v4

LiquidityProviderSwap, LimitOrderFilled, OtcOrderFilled, RfQOrderFilled

Caveats

For trades that are index from traces calls, they do not have a corresponding log index. These trades will be assigned a default -1 value.

Table Column

Column NameDescriptionExample

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

The name of the event (or the function call) for this trade. Trades identified from function calls (traces) will have a log_index of -1

Trade

contract_address

The contract address of the aggregator.

0x9008d19f58aabd9ed0d60971565aa8510560ab41

liquidity_pool_address

This field will be null for most aggregator trades, unless the event specifies the pools that the trade was routed through.

sender_address

Address of the sender of the swap event log, which can be the Router.

0xb8f8f15861e28b328efecbf173da4479481c03a0

to_address

Address of the recipient of the swap event.

0xb8f8f15861e28b328efecbf173da4479481c03a0

token_sold_address

Address of the token sold.

0xdac17f958d2ee523a2206206994597c13d831ec7

token_sold_name

Name of the token sold.

Tether USD

token_sold_symbol

Symbol of the token sold.

USDT

token_sold_amount_raw

Amount of token sold (not divided by the number of decimals).

2000000000

token_sold_amount_raw_str

Amount of token sold (not divided by the number of decimals) in string.

2000000000

token_sold_amount

token_sold_amount_raw divided by the number of decimals of the token.

2000

token_sold_amount_str

token_sold_amount_raw divided by the number of decimals of the token in string.

2000

usd_sold_amount

USD value of tokens sold.

1999.6

token_bought_address

Token address of the token bought, i.e. the asset acquired from the trade.

0x24fcfc492c1393274b6bcd568ac9e225bec93584

token_bought_name

Name of the token bought.

Heroes of Mavia

token_bought_symbol

Symbol of the token bought.

MAVIA

token_bought_amount_raw

Amount of token bought (not divided by the number of decimals).

2.80E+20

token_bought_amount_raw_str

Amount of token bought (not divided by the number of decimals) in string.

280040678330105666777

token_bought_amount

token_bought_amount_raw divided by the number of decimals of the token.

280.0406783

token_bought_amount_str

token_bought_amount_raw divided by the number of decimals of the token in string.

280.0406783

usd_bought_amount

USD value of tokens bought.

usd_amount

USD value of the swap. Note that this preferentially selects the price and value of the more reputable token.

1999.6

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": "D847B36F042B70A8679953B95497B8EC5D9B06393B737639014F53772A0B389DB8F8F15861E28B328EFECBF173DA4479481C03A065D6C4A6" }

transaction_from_address

The address of the sending party of this transaction.

0x4339889fd9dfca20a423fba011e9dff1c856caeb

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.

0x9ce286e595389b7f5bf0b75a04abca93c16ae0ad414cee13bd23d7c1632c309d

transaction_index

Transaction index of this trade in the block.

9

transaction_fees

Fees paid at the transaction level.

0.01027426677

transaction_fees_usd

Fees paid in USD.

30.00126995

fee_details

Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction.

{ "gas": 520290, "gas_price": 39494384954, "max_fee_per_gas": 77901499362, "max_priority_fee_per_gas": 3710596767, "receipt_effective_gas_price": 39494384954, "receipt_gas_used": 260145 }

calldata_selector

The call data selector of the transaction.

0x13d79a0b

log_index

Log index of this trade.

60

block_timestamp

Block timestamp of this trade.

2024-02-22 03:21:59

block_number

Block number of this trade.

19280453

block_hash

Block hash of this trade.

0xb4e21754477762db977a128d1a1953f58bad9ea89836d553d83b7972e702a327

unique_id

Unique ID of each trade.

txn-0x9ce286e595389b7f5bf0b75a04abca93c16ae0ad414cee13bd23d7c1632c309d_log_index-60

_updated_at

Timestamp of the entry update.

2024-02-22 03:48:00

Last updated