afonsonew wallets
    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
    day,
    iff(year(day) = 2022, 'Before Chrismas', 'After Chrismas') as timespan,
    count(distinct(user)) as new_users_count,
    sum(new_users_count) over (partition by timespan order by day) as cumulative_new_users_count
    from t1
    where day between date('2023-01-01') - interval '2 weeks' and date('2023-01-01') + interval '2 weeks'
    group by day, timespan
    order by day
    Run a query to Download Data