Rodolfo-LimaTVL Growth - UNI V3
Updated 2022-10-10
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
33
34
35
36
›
⌄
WITH L_PROVIDERS AS (
SELECT
LIQUIDITY_PROVIDER,
ACTION,
SUM(COALESCE(AMOUNT0_USD,0)+ COALESCE(AMOUNT1_USD,0)) AS LIQUIDITY_AMOUNT
FROM
ethereum.uniswapv3.ez_lp_actions
WHERE (AMOUNT1_USD > 0 OR AMOUNT0_USD > 0)
--AND DATE_TRUNC('day', BLOCK_TIMESTAMP) >= CURRENT_DATE - INTERVAL '12months'
GROUP BY 1,2
ORDER BY 1),
TVL_GROWTH AS
(SELECT
DATE_TRUNC('day',BLOCK_TIMESTAMP) AS DATE,
POOL_ADDRESS,
POOL_NAME,
ACTION,
AMOUNT0_USD,
AMOUNT1_USD,
COALESCE(AMOUNT0_USD,0)+ COALESCE(AMOUNT1_USD,0) AS LIQUIDITY_USD,
(CASE
WHEN ACTION = 'DECREASE_LIQUIDITY' THEN -LIQUIDITY_USD
WHEN ACTION = 'INCREASE_LIQUIDITY' THEN LIQUIDITY_USD
ELSE LIQUIDITY_USD END) AS LIQUIDITY_USD_ADJ,
LIQUIDITY_ADJUSTED,
LIQUIDITY_PROVIDER,
(CASE
WHEN LIQUIDITY_PROVIDER IN (SELECT LIQUIDITY_PROVIDER FROM L_PROVIDERS WHERE LIQUIDITY_AMOUNT >= 100000) THEN 'Whale'
ELSE 'Common User' END) AS L_PROVIDER_TYPE
FROM
ethereum.uniswapv3.ez_lp_actions
WHERE (AMOUNT1_USD > 0 OR AMOUNT0_USD > 0)
AND DATE >= CURRENT_DATE - INTERVAL '6months'
ORDER BY DATE ASC)
Run a query to Download Data