SELECT

symbol_in,

symbol_out,

COUNT(DISTINCT tx_hash) AS "swap count",

COUNT(DISTINCT swapper) AS "distinct swappers"

FROM aptos.defi.ez_dex_swaps

GROUP BY symbol_in, symbol_out

CASE

WHEN symbol_in = 'APT' AND symbol_out = 'USDC' THEN 'APT-USDC'

WHEN symbol_in = 'USDC' AND symbol_out = 'APT' THEN 'USDC-APT'

WHEN symbol_in = 'APT' AND symbol_out = 'USDT' THEN 'APT-USDT'

WHEN symbol_in = 'USDT' AND symbol_out = 'APT' THEN 'USDT-APT'

WHEN symbol_in = 'USDT' AND symbol_out = 'USDC' THEN 'USDT-USDC'

WHEN symbol_in = 'USDC' AND symbol_out = 'USDT' THEN 'USDC-USDT'

WHEN symbol_in = 'amAPT' AND symbol_out = 'APT' THEN 'amAPT-APT'

WHEN symbol_in = 'APT' AND symbol_out = 'WETH' THEN 'APT-WETH'

WHEN symbol_in = 'APT' AND symbol_out = 'amAPT' THEN 'APT-amAPT'

WHEN symbol_in = 'USDC' AND symbol_out = 'USDC' THEN 'USDC-USDC'

WHEN symbol_in = 'USDT' AND symbol_out = 'USDT' THEN 'USDT-USDT'

ELSE symbol_out

END AS swap_pairs,

"swap count",

"distinct swappers"

FROM top_tokens

ORDER BY "swap count" DESC

LIMIT 10;