maybeyonasalgo_wallets_recent_aug
    Updated 2022-02-05
    with
    creation as (
    select
    -- created_at,
    block_timestamp,
    address
    from algorand.account join algorand.block on created_at=block_id
    )

    select
    date(block_timestamp) as date,
    case
    when block_timestamp >= '2021-09-20' and block_timestamp <= '2021-10-14' then 'gov1'
    when block_timestamp >= '2021-12-24' and block_timestamp <= '2022-01-01' then 'gov2'
    else 'not gov' end as gov_type,
    count(distinct address) as users
    from creation
    where date(block_timestamp) >= '2021-09-01'
    group by 1,2
    -- limit 100

    Run a query to Download Data