select BLOCK_TIMESTAMP::date as date

,count(distinct ORIGIN_FROM_ADDRESS)as daily_unique_traders,count (distinct tx_hash)as daily_trade_count

,avg(daily_unique_traders)over(order by date asc)as avg_daily_traders

,avg(daily_trade_count)over(order by date asc)as avg_daily_trade_count

from polygon.core.fact_event_logs

where (ORIGIN_TO_ADDRESS='0x65187fec6ecc4774c1f632c7503466d5b4353db1'

or ORIGIN_TO_ADDRESS='0xd8d177efc926a18ee455da6f5f6a6cfcee5f8f58'

or ORIGIN_TO_ADDRESS='0xf8a140db8b05bec52c7e86d0d40d72f8e54fe559')

and EVENT_NAME='Transfer'

and ORIGIN_FUNCTION_SIGNATURE='0x9aa7c0e5'

and date>='2022-04-18'

group by 1