DEX

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 Tables	Description
Trades	Token swaps on major DEXes that route through the protocol's or DEX's liquidity pool.
Aggregator Trades	DEX aggregator trades are trades executed by aggregators or contracts that route swaps across multiple liquidity pools on-chain or through market makers.
Liquidity Pool Events	Liquidity pool events specific to each DEX protocol. Includes events such as mints, burns, sync, and collect.
Liquidity Pools	Pool creation events and parameters.
Uniswap X Trades	Uniswap X Orders are executed on the Ethereum mainnet. Includes swaps that failed to execute as well.
JIT Liquidty Events	Just-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 Trades	The 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.