maybeyonasalgo_jan_assets
    Updated 2022-02-13
    with
    creation as (
    select
    -- created_at,
    block_timestamp,
    address
    from algorand.account join algorand.block on created_at=block_id
    ),
    jan_users as (
    select address
    from creation
    where date(block_timestamp) >= '2022-01-01'
    and date(block_timestamp) <= '2022-01-31'
    group by 1
    )

    -- select
    -- balance_bucket,
    -- count(distinct address) as users
    -- from (
    -- select *,
    -- case
    -- when balance < 1 then 1
    -- when balance < 10 then 10
    -- when balance < 100 then 100
    -- when balance < 1000 then 1000
    -- when balance < 10000 then 10000
    -- else 100000
    -- end as balance_bucket
    -- from algorand.account
    -- where address in (select address from jan_users)
    -- )
    -- group by 1

    select
    t.asset_id,
    Run a query to Download Data