Afonso_DiazUntitled Query
Updated 2023-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with t as (
select
to_address,
min(block_timestamp)::date as min_date
from ethereum.core.fact_token_transfers
where contract_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
group by 1
)
select
min_date as day,
count(distinct to_address) as new_users_count,
sum(new_users_count) over (order by day) as cumulative_new_users_count
from t
where day > current_date - 90
group by day
order by day
Run a query to Download Data