amirozaholders count
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with ww_nft as (select distinct asset_id id
from algorand.asset
where asset_name like 'Warrior Croc%'
and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'))
select address, count(*) nft_hold
from algorand.account_asset
where ASSET_CLOSED='FALSE' and AMOUNT>0
and ASSET_ID in (select id from ww_nft)
group by 1
order by 2 desc
Run a query to Download Data