benbenwallets created in 2022
Updated 2022-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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