Skip to main content

New Unified Schema

The avalanche.dex.events table provides a unified, protocol-agnostic schema for DEX liquidity events on Avalanche. This approach allows you to analyze liquidity patterns across different DEX protocols using consistent semantics.

Available Events

  • initialize_pool: Pool initialization events
  • add_liquidity: Liquidity addition events
  • remove_liquidity: Liquidity removal events
  • swap_tokens: Token swap events

Key Features

  • Protocol-agnostic: Unified schema across Uniswap V2/V3, Trader Joe LB, Pangolin, and other major Avalanche DEX protocols
  • Enriched data: Includes token metadata, USD prices, and normalized ownership through LP units
  • Event-agnostic semantics: Consistent field structure regardless of underlying protocols
For detailed schema information and advanced queries, see the DEX Events documentation.

Protocol-Specific Tables

The following individual protocol tables are still available:
  • Uniswap V2 Events: Swap, Sync, Mint, Burn events
  • Uniswap V3 Events: Swap, Sync, Mint, Collect, Burn, Initialize, Flash events
  • Uniswap V4 Events: OperatorSet, OwnershipTransferred, ProtocolFeeControllerUpdated, Transfer, ProtocolFeeUpdated, Initialize, Swap, ModifyLiquidity, and Donate events
For pool creation events, use the dex.pools table.
I