binhachonLofty AI Platform Dashboard - #1
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
Select
asset_id,
asset_name,
sum(amount) * 50 as total_amount_raised_in_USD,
sum(amount) as token_amount,
sum(total_amount_raised_in_USD) over () as total_amount_usd,
sum(token_amount) over () as total_asset_amount
from algorand.account_asset
where amount > 0 and asset_id != '237267329' and asset_id in (select asset_id
from algorand.asset
where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')
group by 1, 2
order by total_amount_raised_in_USD desc
Run a query to Download Data