Rodolfo-LimaConcentrated Liquidity - UNI V3
Updated 2022-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
SELECT
POOL_NAME,
PRICE_UPPER_0_1,
PRICE_LOWER_0_1,
NF_TOKEN_ID,
SUM(lIQUIDITY_ADJUSTED) AS LIQUIDITY
FROM
(SELECT
BLOCK_TIMESTAMP
POOL_NAME,
POOL_ADDRESS,
PRICE_UPPER_0_1,
PRICE_LOWER_0_1,
tick_lower,
tick_upper,
tokens_owed0_usd,
tokens_owed1_usd,
lIQUIDITY_ADJUSTED,
TOKEN0_SYMBOL,
TOKEN1_SYMBOL,
NF_TOKEN_ID
FROM
ethereum.uniswapv3.ez_positions
WHERE IS_ACTIVE = TRUE
AND DATE_TRUNC('day',BLOCK_TIMESTAMP) >= CURRENT_DATE - INTERVAL '6months'
AND POOL_ADDRESS = LOWER('0x88e6A0c2dDD26FEEb64F039a2c41296FcB3f5640')
ORDER BY PRICE_UPPER_0_1 ASC
)
GROUP BY 1,2,3,4
Run a query to Download Data