alirslofty 10
Updated 2022-07-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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