maybeyonasalgo_jan_dec_wallet
    Updated 2022-02-27
    select
    case
    when block_timestamp < '202102-01' then 'jan 2021'
    when month(block_timestamp) = 12 then 'dec 2021'
    else 'jan 2022'
    end month_time,
    date(block_timestamp) as date,
    count(distinct address) as users
    from algorand.transaction_participation
    where block_timestamp > '2021-02-02'
    and month(block_timestamp) in (1,12)
    group by 1,2
    limit 1000

    Run a query to Download Data