Table Details
| Property | Value |
|---|---|
| Table Name | ethereum.dex.uniswap_v3_protocol_liquidity |
| Table Status | Production-Ready |
| Unique Key | liquidity_pool_address, tick_price_1_0_0 |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| liquidity_pool_address | VARCHAR(42) | Contract address of the liquidity pool where this trade was executed. Null when the routing path is not emitted by the event (common for aggregator trades). |
| pool_name | VARCHAR(16777216) | Pool name from Curve API |
| fee | NUMBER(38,0) | Fee tier of the liquidity pool, expressed in hundredths of a basis point (e.g. 3000 = 0.3%). Paid by traders to liquidity providers on each swap. |
| tick | NUMBER(38,0) | Current price tick of the AMM pool. In Uniswap V3/V4, the price is represented as 1.0001^tick. Only meaningful for concentrated liquidity AMMs. |
| tick_price_1_0 | FLOAT | Price of token1 in terms of token0 at the current active tick, derived from the tick’s sqrt price. |
| tick_price_0_1 | FLOAT | Price of token0 in terms of token1 at the current active tick, derived from the tick’s sqrt price. |
| token0_decimals | NUMBER(38,0) | Decimal precision of token0 in the liquidity pool. |
| token0_symbol | VARCHAR(16777216) | Ticker symbol of token0 in the liquidity pool. |
| token0_amount_raw | FLOAT | Raw amount of token0 involved in this event, not decimal-adjusted. |
| token0_adjusted | FLOAT | Decimal-adjusted amount of token0 held in this Uniswap V3 position at the snapshot, computed from the V3 liquidity math. |
| token1_decimals | NUMBER(38,0) | Decimal precision of token1 in the liquidity pool. |
| token1_symbol | VARCHAR(16777216) | Ticker symbol of token1 in the liquidity pool. |
| token1_amount_raw | FLOAT | Raw amount of token1 involved in this event, not decimal-adjusted. |
| token1_adjusted | FLOAT | Decimal-adjusted amount of token1 held in this Uniswap V3 position at the snapshot, computed from the V3 liquidity math. |
| tick_spacing | NUMBER(38,0) | Minimum tick interval between initializable price ticks in this pool. Higher fee tiers typically have larger tick spacing. |
| current_tick | FLOAT | Current tick of the pool |
| current_price_1_0 | FLOAT | Current pool price of token1 denominated in token0 at the time of the snapshot, derived from the active tick. |
| current_price_0_1 | FLOAT | Current pool price of token0 denominated in token1 at the time of the snapshot, derived from the active tick. |
Guide: See Uniswap V3 Virtual Liquidity for worked examples querying current liquidity distribution.