Our DEX schema is designed to capture and organize data related to decentralized exchanges (DEX). It includes tables for recording token swap events, liquidity pool creations, and events such as mints and burns.

DEX TablesDescription
TradesToken swaps on major DEXes that route through the protocol’s or DEX’s liquidity pool.
Aggregator TradesDEX aggregator trades are trades executed by aggregators or contracts that route swaps across multiple liquidity pools on-chain or through market makers.
Liquidity Pool EventsLiquidity pool events specific to each DEX protocol. Includes events such as mints, burns, sync, and collect.
Liquidity PoolsPool creation events and parameters.
Uniswap X TradesUniswap X Orders are executed on the Ethereum mainnet. Includes swaps that failed to execute as well.
JIT Liquidty EventsJust-in-time (JIT) Liquidity events for UniswapV3 protocols executed. Includes data such as the liquidity action and swap that was sandwiched between a JIT liquidity provision.
Sanwich TradesThe Sandwich Trades table captures DEX events where sandwich trading activity is detected. Sandwich trading involves placing two trades (a front-run and a back-run) around a victim’s trade to manipulate the market price for profit.