maybeyonasalgo_jan_wallets
    Updated 2022-02-13
    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,
    count(distinct address) as users
    from creation
    where date(block_timestamp) >= '2022-01-01'
    and date(block_timestamp) <= '2022-01-31'
    group by 1
    -- limit 100
    Run a query to Download Data