WITH swap_pair_activity AS (

SELECT

symbol_in,

symbol_out,

COUNT(DISTINCT tx_id) AS swap_count,

SUM(amount_in_usd) AS total_volume

FROM

sei.defi.ez_dex_swaps

WHERE

symbol_in IS NOT NULL

AND symbol_out IS NOT NULL

GROUP BY

symbol_in, symbol_out

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

swap_count,

total_volume

swap_pair_activity

total_volume IS NOT NULL

ORDER BY

swap_count DESC, total_volume DESC

LIMIT 10;