SELECT

LEAST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_1,

GREATEST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_2,

COUNT(DISTINCT TX_HASH) AS TRADE_COUNT,

SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/ 2) AS TRADED_VOLUME

FROM polygon.defi.ez_dex_swaps

WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')

GROUP BY 1, 2

),

ranked_pairs AS (

SELECT

CONCAT(SYMBOL_1, ' - ', SYMBOL_2) AS PAIR,

TRADE_COUNT,

TRADED_VOLUME

FROM swap_pairs

WHERE 1=1

AND PAIR IS NOT NULL

AND TRADED_VOLUME IS NOT NULL

PAIR,

TRADE_COUNT

FROM ranked_pairs

ORDER BY TRADE_COUNT DESC

LIMIT 15