COUNT (DISTINCT TX_HASH) AS Total_swaps,

COUNT(DISTINCT SWAPPER) AS Total_swappers,

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS Total_swap_Volume,

COUNT(DISTINCT TOKEN_IN) AS TOTAL_TOKENS,

COUNT(DISTINCT CONCAT(LEAST(SYMBOL_IN, SYMBOL_OUT), '->', GREATEST(SYMBOL_IN, SYMBOL_OUT))) AS Distinct_token_pairs

FROM aptos.defi.ez_dex_swaps

WHERE EVENT_ADDRESS='0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'