select
date_trunc('day',BLOCK_TIMESTAMP) AS day,
symbol,
avg(Amount_USD) AS "Average transfer size",
avg("Average transfer size") over (order by Day, Day rows between 6 preceding and current row) as "transfer size 7 MA"
from ethereum.core.ez_token_transfers
where (CONTRACT_ADDRESS='0x45804880de22913dafe09f4980848ece6ecbaf78' or CONTRACT_ADDRESS='0x68749665ff8d2d112fa859aa293f07a622782f38' )
and BLOCK_TIMESTAMP::date >= dateadd('month',-6,CURRENT_DATE)
group by 1,2