nickpayiatis_Untitled Query
    Updated 2022-12-12

    with addresses as(
    select address, amount from "FLIPSIDE_PROD_DB"."ALGORAND"."ACCOUNT_ASSET"
    where asset_id = '849191641'
    and amount > 0
    )


    ,wallet_profile as(
    select acc.address, case
    when amount >= 0 and acc.balance < 10 then '0-10 ALGO'
    when acc.balance >= 10 and acc.balance < 100 then '10-100 ALGO'
    when acc.balance >= 100 and acc.balance < 1000 then '100-1000 ALGO'
    when acc.balance >= 100 and acc.balance < 1000 then '1000-10000 ALGO'
    else '1000-10000 ALGO'
    end as balance_group,
    acc.balance as account_balance,
    block.block_timestamp::Date as created_at
    from group_addresses addr


    )
    select distinct created_at , count(*)
    from wallet_profile
    group by created_at
    Run a query to Download Data