Papasot2022 algorand wallets ASA popularity
    Updated 2023-01-03
    with addresses as(
    select distinct address

    from algorand.account account
    left join algorand.block block on account.created_at = block.block_id
    where block.block_timestamp::date >= '2022-01-01')

    select
    ASA.asset_id,
    ASA.asset_name,
    count(addresses.address) as number_of_wallets
    from algorand.account_asset ASA
    left join addresses addresses on ASA.address = addresses.address
    where addresses.address is not null
    and ASA.amount > 0
    group by ASA.asset_id, ASA.asset_name
    order by number_of_wallets desc
    limit 10
    Run a query to Download Data