These schemas track position holdings in dex pools at an hourly granularity, combining liquidity and price updates to surface token amounts, in-range status, and USD TVL.

Position data is enriched with token metadata, and position/pool context, making it easy to analyze LP behavior over time.

Available Tables

Coming Soon

Support for the following protocols is in our roadmap:

  • Uniswap v3
  • Aerodrome
  • Others by request

Key Features

  • Hourly changes of position holdings and TVL
  • Enriched with token metadata and USD prices
  • Efficient structure for state reconstruction via forward-fill