with amounts as (
select top 10 swap_to_asset_id as asset_id, sum(swap_from_amount) as amount from flipside_prod_db.algorand.swaps
where swap_from_asset_id = 0
and swap_from_amount > 0
group by swap_to_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