lagandispenserTop ASA Holders
    Updated 2022-06-14
    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