select top 10 swap_from_asset_id as asset_id, sum(swap_to_amount) as amount from flipside_prod_db.algorand.swaps

where swap_to_asset_id = 0

and swap_from_amount > 0

group by asset_id

order by amount desc

select asset_name, amount from amounts join flipside_prod_db.algorand.asset on amounts.asset_id = asset.asset_id