benbenwallets created in 2022
    Updated 2022-05-19
    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