alirslofty 10
    Updated 2022-07-15
    SELECT count(DISTINCT unique_wallet) as n_unique_wallets
    FROM(
    SELECT
    address as unique_wallet,
    asset_name as asset_name,
    sum(amount) as total_token_investment_price_USD
    FROM algorand.account_asset
    WHERE asset_id IN (SELECT asset_id
    FROM algorand.asset
    WHERE creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')
    AND asset_closed = 'FALSE'
    GROUP BY address, asset_name
    HAVING total_token_investment_price_USD>=1
    ORDER BY total_token_investment_price_USD DESC)
    Run a query to Download Data