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 Equivalent

Column Names

Column NameDescriptionExample

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

Last updated