SELECT

date_trunc('day',BLOCK_TIMESTAMP) as day,

sum(AMOUNT0_ADJUSTED) as sum_amount

FROM ethereum.uniswapv3.ez_swaps

WHERE TOKEN0_SYMBOL = 'USDC'

GROUP BY 1

SELECT

day,

sum_amount,

avg(sum_amount) OVER (ORDER BY day ROWS BETWEEN 4 PRECEDING AND CURRENT ROW) AS "5-day moving avg USDC swap volume"

FROM usdc_swaps;