CONCAT(TOKEN_IN, '-', TOKEN_OUT) AS swap_pair,

SUM(AMOUNT_IN_USD) AS total_volume_usd,

COUNT(*) AS total_swaps

FROM aptos.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP >= DATE_TRUNC('day', CURRENT_DATE - 7)

GROUP BY swap_pair

ORDER BY total_volume_usd DESC;