case when asset_name is null then 'ALGO' else asset_name end as asset_name,

count(case when swap_to_asset_id = 694432641 then 1 end) as number_of_swaps

from algorand.swaps a

LEFT JOIN algorand.asset b

ON a.swap_from_asset_id = b.asset_id

where block_timestamp >= current_date -30

group by asset_name

order by number_of_swaps desc

limit 10