kiacryptoCompare the number of new wallets on Algorand from May 4th to 10th Vs a week before and after
    Updated 2022-05-21
    select case
    when block_timestamp::date between '2022-04-27' and '2022-05-03' then 'a week before'
    when block_timestamp::date between '2022-05-04' and '2022-05-10' then 'May 4th to 10th'
    when block_timestamp::date between '2022-05-11' and '2022-05-17' then 'a week after' end as date,
    count(distinct address)
    from flipside_prod_db.algorand.account, flipside_prod_db.algorand.block
    where created_at = block_id and block_timestamp::date between '2022-04-27' and '2022-05-17'
    group by 1

    Run a query to Download Data