iboo-jbj2MVUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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'
LIMIT 10
)
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