Abbas_ra21Lp stats by New Lpers 2
Updated 2023-07-03
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
›
⌄
-- forked from Lp stats by New Lpers @ https://flipsidecrypto.xyz/edit/queries/b555be04-ec60-438a-b304-2e44e7ceb636
with
tb AS (
select
LIQUIDITY_PROVIDER AS user,
min(BLOCK_TIMESTAMP) AS Timedate
from
ethereum.uniswapv3.ez_lp_actions
group by
1
having
Timedate >= dateadd(
'Month',
- {{Last_N_Months}},
current_date
)
)
select
case
when ACTION = 'DECREASE_LIQUIDITY' then 'Decrease'
else 'Increase'
end AS Action,
count(*) AS "Events Number",
sum(AMOUNT0_USD + AMOUNT1_USD) AS "Amount (USD)"
from ethereum.uniswapv3.ez_lp_actions
where
BLOCK_TIMESTAMP >= dateadd(
'Month',
- {{Last_N_Months}},
current_date
)
and LIQUIDITY_PROVIDER in (select User from tb)
group by 1
Run a query to Download Data