Abbas_ra21Lp stats by New Lpers 3
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
›
⌄
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
date_trunc('Month',Timedate) AS Month,
count(user) AS "New Users Number"
from tb
where
Timedate >= dateadd(
'Month',
- {{Last_N_Months}},
current_date
)
group by 1
Run a query to Download Data