Get the latest distribution of virtual liquidity on any Uniswap v3 pool.

This view computes the current distribution of liquidity based on the cumulative sum of LP added and removed from the pool.

The predicate for liquidity_pool_address must be added when querying this view.

Uniswap WETH-USDC 0.3% Pool

 select * from ethereum.dex.uniswap_v3_protocol_liquidity 

 where liquidity_pool_address = '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8' -- LP Address

Uniswap v3 USDC-WETH 0.3% Virtual Liquidity (output from query above)

Uniswap Equivalent

Uniswap v3 Liquidity https://info.uniswap.org/#/pools/0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8

Column Names

Column NameDescriptionExample
liquidity_pool_addressLiquidity Pool Address0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8
pool_nameName of LP poolUSDC-WETH 3000
feeFee amount.3,000
tickPrice tick.143,280
tick_price_1_0Price tick of token1 per token0.0.000001668246525
tick_price_0_1Price tick of token0 per token1 (inverse of the above).599,431.79
token0_decimalsToken0 decimals6
token0_symbolToken0 symbol.USDC
token0_amount_rawToken0 raw amount, not normalized.426,960,531.90
token0_adjustedToken0 amount normalized.426.9605319
token1_decimalsToken1 decimals18
token1_symbolToken1 symbol.WETH
token1_amount_rawToken1 raw amount, not normalized.257,370,042,465,219,000
token1_adjustedToken1 amount normalized.0.2573700425
tick_spacingTick spacing60
current_tickCurrent tick based on last swap.202,181
current_price_1_0Current tick price (token1/token0) based on last swap.0.0006027958634
current_price_0_1Current tick price (token0/token1) based on last swap.1,658.94