/*SELECT
date_trunc('month', block_timestamp) as monthly_metrics,
sum(amount_usd) as usd_volume
FROM
ethereum.udm_events
WHERE
FROM_LABEL = 'uniswap'
AND FROM_LABEL_TYPE = 'dex'
AND block_timestamp >= CURRENT_DATE - INTERVAL '1 YEAR'
--AND monthly_metrics > DATEADD(MONTH,-1,GETDATE())
GROUP BY 1
ORDER BY 1, 2 DESC;*/
SELECT date_trunc('month', block_timestamp) AS monthly_metrics,
SUM(ABS(amount_in_usd) + ABS(amount_out_usd))/2 AS Transaction_Volume
FROM ethereum.core.ez_dex_swaps
WHERE event_name = 'Swap'
AND platform = 'uniswap-v3'
AND block_timestamp >= CURRENT_DATE - INTERVAL '365 Days'
GROUP BY 1
ORDER BY 1, 2 DESC