Papasotlofty whales
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
Select
address,
count(*) as lofty_tokens
from algorand.account_asset
where
address <> 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
AND
asset_id in (select asset_id
from algorand.asset
where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')
group by 1
order by count(*) desc
limit 10
Run a query to Download Data