par_rndaily average transfer size over last 6 months
    Updated 2022-12-24
    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
    Run a query to Download Data