lagandispenserTop ASA Holders
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with january22_personal_account as (
select distinct a.address
from algorand.account a
left join algorand.account_app ap
on a.address = ap.address
where ( app_id is null -- this account never interacted with any application/smart contract
or app_id <> '389002307' ) -- skip Vitalpass App_id
and a.created_at between 18363444 and 18974008
)
select asset_id,
asset_name,
count(distinct address) as holders
from algorand.account_asset
where address in (select * from january22_personal_account)
group by asset_id,asset_name
order by holders DESC
limit 100