Tokens in a liquidity pool (Uniswap v3)

What is this dataset?

The Uniswap V3 Liquidity Estimator offers insight into the token reserves on Uniswap V3.

This data shows the liquidity across all the price levels for a specific pair of tokens on Uniswap V3. Each price level has a range, which is shown aslower_tick (the lowest price of the level) and upper_tick (the highest price of the level). The data shows you the amount of tokens and liquidity available at each price level. We display all price-levels up to 10% either side of the current block price. The data is provided in a block-by-block granularity. Access the methodology here.

Update frequencies

Channel	Update frequency
AWS	New CSV once a day
Azure	New CSV once a day
Google Cloud Platform	New CSV once a day
Snowflake	Not available
BigQuery	Not available

File structure details

• File Name: [kaiko_exchange_code]_[pool_address]_[date].csv

  • Files are created on a daily basis.

  • example: usp3_0xcbfb0745b8489973bf7b334d54fdbd573df7ef3c_2023-02-07.csv

• Cut-off time: 00:00:00 UTC

  • We use the timestamp of the block in order to cut-off the data points between days.

• Column Delimeter: , (comma)

• Decimal Mark (in numbers): . (dot)

Field	Description	Example
block_number	The height of the block.	16028979
timestamp	The timestamp of the block.	1669161611000
lower_tick	The lower tick of the range.	-59580
upper_tick	The upper tick of the range.	-59520
current_price	The current price at this block, normalized using the pool’s tokens decimals.	0.0028577887443084
current_tick	The current tick at this block.	-58580
amount	The amount of liquidity in the specified tick range.	1.7305248294559624e+23
amount0	The amount of token0 in the specified tick range, normalized using the token0 decimals.	0
amount1	The amount of token1 in the specified tick range, normalized using the token1 decimals.	26.4381078606