SELECT

CONCAT(symbol_in, ' --> ', symbol_out) AS asset_pair,

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 asset_pair

HAVING volume_usd IS NOT NULL

ORDER BY transaction_count DESC

LIMIT 20;