select BLOCK_TIMESTAMP::date as date,sum(EVENT_INPUTS:value/1e18) as daily_usd_volume
,avg(daily_usd_volume)over(order by date asc)as avg_daily_usd_volume
from polygon.core.fact_event_logs
where (ORIGIN_TO_ADDRESS='0x65187fec6ecc4774c1f632c7503466d5b4353db1'
or ORIGIN_TO_ADDRESS='0xd8d177efc926a18ee455da6f5f6a6cfcee5f8f58'
or ORIGIN_TO_ADDRESS='0xf8a140db8b05bec52c7e86d0d40d72f8e54fe559')
and CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063'
and EVENT_NAME='Transfer'
and ORIGIN_FUNCTION_SIGNATURE='0x9aa7c0e5'
and date>='2022-04-18'
group by 1