binhachonLofty AI Platform Dashboard - #1
    Updated 2022-07-14
    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