The dex_aggregator.trades
table captures data on actions taken on aggregators - recording all events across various aggregators and blockchains.
This table stores data on aggregator trades across protocols...
... and chains
dex_aggregator.trades
table captures high-level trade data executed via decentralized exchange (DEX) aggregators. These aggregators aggregate liquidity from multiple DEXs to provide users with the best possible trade execution. Unlike the dex.trades
table, which records each intermediary step of a trade, dex_aggregator.trades
condenses the trade data to reflect the user’s intended trade, presenting it as a single entry.
dex_aggregator.trades
table to provide a high-level view of DEX trades facilitated by aggregators. This table simplifies trade records by showing a single entry for trades that may involve multiple DEXs and liquidity pools.dex_aggregator.trades
will record it as a single USDC -> PEPE trade.
Complimentary to dex_aggregator.trades
is the dex.trades
table, where detailed trade executions are recorded. This table captures the granular steps of each trade, including interactions with different liquidity pools. The volume routed through aggregators is also recorded in the dex.trades
table. One row in dex_aggregator.trades
corresponds to one or more rows in dex.trades
, providing a comprehensive view of the detailed execution path that aggregated trades take.