select

date_trunc('day', block_timestamp) as date1,

sum(amount_usd) as amount1

from ethereum.dex_swaps

where platform like '%uniswap%' and amount_usd < 1000000000

group by 1

)

select *,

sum(amount1) OVER(ORDER BY date1

ROWS BETWEEN 2 PRECEDING AND CURRENT ROW )

as moving_average

from tab1