BLOCK_TIMESTAMP :: date as date,

round(sum(AMOUNT_IN_USD),2) as volume,

avg (volume) over (order by date rows between 29 preceding and current row) as "30-day moving average"

from ethereum.core.ez_dex_swaps

where date >= '2022-06-01' and event_name = 'Swap'

group by 1 order by 1