Uniswap v3 Virtual Liquidity

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 Name	Description	Example
liquidity_pool_address	Liquidity Pool Address	0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8
pool_name	Name of LP pool	USDC-WETH 3000
fee	Fee amount.	3,000
tick	Price tick.	143,280
tick_price_1_0	Price tick of token1 per token0.	0.000001668246525
tick_price_0_1	Price tick of token0 per token1 (inverse of the above).	599,431.79
token0_decimals	Token0 decimals	6
token0_symbol	Token0 symbol.	USDC
token0_amount_raw	Token0 raw amount, not normalized.	426,960,531.90
token0_adjusted	Token0 amount normalized.	426.9605319
token1_decimals	Token1 decimals	18
token1_symbol	Token1 symbol.	WETH
token1_amount_raw	Token1 raw amount, not normalized.	257,370,042,465,219,000
token1_adjusted	Token1 amount normalized.	0.2573700425
tick_spacing	Tick spacing	60
current_tick	Current tick based on last swap.	202,181
current_price_1_0	Current tick price (token1/token0) based on last swap.	0.0006027958634
current_price_0_1	Current tick price (token0/token1) based on last swap.	1,658.94