(SELECT swap_to_asset_id, sum(swap_from_amount) as total_amt, avg(swap_from_amount) as avg_swap_amount from algorand.swaps

where swap_from_asset_id = '0' and date(block_timestamp) >= '2022-01-01'

GROUP by 1

ORDER by 2 desc

LIMIT 10)

SELECT asset_name, total_amt, avg_swap_amount from algorand.asset

INNER join top10assets

on swap_to_asset_id = asset_id

ORDER by total_amt desc