SELECT

BLOCK_TIMESTAMP,

TX_HASH,

SYMBOL_IN,

SYMBOL_OUT,

(AMOUNT_IN_USD + AMOUNT_OUT_USD) / 2 AS AMOUNT_USD

FROM optimism.defi.ez_dex_swaps

WHERE 1=1

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

TOKENS,

COUNT(DISTINCT TX_HASH) AS TRADE_COUNT,

SUM(AMOUNT_USD) AS TRADED_VOLUME

FROM (

SELECT SYMBOL_IN AS TOKENS, TX_HASH, AMOUNT_USD FROM Tb1

UNION ALL

SELECT SYMBOL_OUT AS TOKENS, TX_HASH, AMOUNT_USD FROM Tb1

) AS Combined

GROUP BY TOKENS

HAVING TRADED_VOLUME IS NOT NULL

ORDER BY TRADED_VOLUME DESC

LIMIT 10