MLDZMNwildliffe-algo balance
Updated 2022-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with tb1 as (select *
from algorand.asset
where asset_name like 'Warrior Croc%'
and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
),
tb2 as (SELECT
*
from flipside_prod_db.algorand.account_asset
where ASSET_ID in (select ASSET_ID from tb1)
)
SELECT
case
when BALANCE between 0 and 100 then '0-100 ALGOs'
when BALANCE between 100 and 500 then '100-500 ALGOs'
when BALANCE between 500 and 1500 then '500-1500 ALGOs'
when BALANCE>=1500 then 'above 1500 ALGOs'
end as distribution,
count(distinct ADDRESS) wallets
from flipside_prod_db.algorand.account
where ADDRESS in (select ADDRESS from tb2)
group by 1
Run a query to Download Data