afonso'new wallets total
    Updated 2023-04-13
    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