SUM(ABS(AMOUNT_IN_USD) + ABS(AMOUNT_OUT_USD))/2 AS Transaction_Volume

FROM ETHEREUM.core.ez_dex_swaps

Where platform = 'uniswap-v3'

AND event_name = 'Swap'

AND Month >= CURRENT_DATE - Interval '1 Year'

GROUP BY 1

ORDER BY 1, 2 DESC;