select

symbol_out AS To_assest,

COUNT(DISTINCT tx_hash) AS transaction_count,

sum(coalesce(amount_in_usd, amount_out_usd)) as volume_usd,

FROM blast.defi.ez_dex_swaps

GROUP BY To_assest

HAVING volume_usd IS NOT NULL

order by volume_usd desc

LIMIT 10;

SELECT *