Papasotlofty whales
    Updated 2023-01-03
    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