date_trunc(month,block_timestamp::date) as date

,count(DISTINCT tx_hash) as "# of Transactions"

,sum("# of Transactions") over(order by date) as "Cumulative Transactions"

,avg("# of Transactions") over(order by date rows between 7 preceding and 1 preceding) as "7-Day Rolling Avg. Transactions"

from crosschain.olas.fact_service_events

group by 1

order by 1