keshanAlgo distribution non jan wallets
    Updated 2022-02-14
    select (case when amount = 0 then '0'
    when amount > 0 and amount <=1 then '0 - 1'
    when amount > 1 and amount <=10 then '1 - 10'
    when amount > 10 and amount <=100 then '10 - 100'
    when amount > 100 and amount <=1000 then '100 - 1000'
    when amount > 1000 and amount <=10000 then '1000 - 10000'
    when amount > 10000 and amount <=1000000 then '10000 - 1000000'
    when amount > 1000000 then '1M+'
    end)
    as bracket,
    count(address) as count from
    (select address,
    sum(balance) as amount
    from algorand.account
    left join algorand.block on block_id = created_at
    where date_trunc('month', block_timestamp) != '2022-1-1'
    group by address)
    group by bracket
    Run a query to Download Data