count(*) as swaps

from algorand.swaps swap

left join algorand.asset asset

on swap.swap_to_asset_id = asset.asset_id

where block_timestamp::date BETWEEN '2022-03-01' AND '2022-03-31'

and swap_from_asset_id = 0

and swap_from_amount > 0

group by asset.asset_name

order by swaps desc

limit 10