Delamir-601403- new users in each year
Updated 2023-01-25
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
›
⌄
with New_User as (
select
min(block_timestamp::date) as date,
from_address
from ethereum.core.fact_transactions
where to_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
group by 2
)
, Num as (
select
date,
case when date > '2021-01-01' and date < '2022-01-01' then '2021'
when date >= '2022-01-01' and date < '2023-01-01' then '2022'
else '2023' end as Years,
count (from_address) as Num_New_user
from new_user
group by 1,2
order by 1
)
select
years,
sum(Num_New_user)
from Num
group by 1
Run a query to Download Data