SELECT

BLOCK_TIMESTAMP,

TX_HASH,

SWAPPER,

COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD) AS AMOUNT_USD,

SYMBOL_IN AS TOKEN_IN,

SYMBOL_OUT AS TOKEN_OUT

FROM aptos.defi.ez_dex_swaps

WHERE EVENT_ADDRESS = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'

TOKENS,

COUNT(DISTINCT TX_HASH) AS SWAP_COUNT,

COUNT(DISTINCT SWAPPER) AS Total_swappers,

SUM(AMOUNT_USD) AS Total_swap_Volume

FROM (

SELECT TOKEN_IN AS TOKENS, TX_HASH, AMOUNT_USD, SWAPPER FROM Tb1

UNION ALL

SELECT TOKEN_OUT AS TOKENS, TX_HASH, AMOUNT_USD, SWAPPER FROM Tb1

) AS Combined

GROUP BY TOKENS

ORDER BY 4 DESC

LIMIT 10