SELECT
SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD) / 2) AS "Total Transaction Volume"
FROM
avalanche.defi.ez_dex_swaps
WHERE
platform = 'trader-joe-v1'
AND EXTRACT(MONTH FROM block_timestamp) = 5
AND EXTRACT(YEAR FROM block_timestamp) = EXTRACT(YEAR FROM CURRENT_DATE);