afonso'new wallets total
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with
t1 as (
select
min(block_timestamp)::date as day,
minter as user
from terra.core.fact_nft_mints
group by user
)
select
iff(year(day) = 2022, 'Before Chrismas', 'After Chrismas') as timespan,
count(distinct(user)) as new_users_count
from t1
where day between date('2023-01-01') - interval '1 weeks' and date('2023-01-01') + interval '1 weeks'
group by timespan
Run a query to Download Data