Position Holdings
Position Holdings Overview
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
- Uniswap v4 Position Holdings Hourly: Tracks hourly v4 position amounts across Ethereum, Polygon, and Unichain.
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