vahid-2jsEENALGO balance of new Wallets
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with new_wallets_balance as(select address , balance from flipside_prod_db.algorand.account a join algorand.block b
on a.created_at=b.block_id where date(block_timestamp) >= date('2022-05-01') and date(block_timestamp) < date('2022-05-31')
),
wallets_balance as (select case
when balance = 0 then 1
when balance>0 and balance<=1 then 2
when balance>1 and balance<=10 then 3
when balance>10 and balance<=1000 then 4
when balance>1000 then 5
end as id ,case
when balance = 0 then ' Balance = 0'
when balance>0 and balance<=1 then '0 < Balance ≤ 1'
when balance>1 and balance<=10 then '1 < Balance ≤ 10'
when balance>10 and balance<=1000 then '10 < Balance ≤ 1000'
when balance>1000 then '1000 < Balance'
end as wallet_balance from new_wallets_balance )
select id , wallet_balance as "Balance (ALGO)", count(*) as "Number of Wallets"
from wallets_balance group by 1 , 2 order by 1
Run a query to Download Data