DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

count (DISTINCT MULTISIG_ADDRESS) AS agent,

count (DISTINCT ORIGIN_FROM_ADDRESS) AS owner,

sum(agent) over (ORDER BY day) AS cumulative_agent,

sum(owner) over (ORDER BY day) AS cumulative_owner,

round(avg(agent) over (ORDER BY day rows BETWEEN 7 preceding and current row)) AS agent_7D_MA

FROM

crosschain.olas.fact_service_events

group by 1

ORDER by 1 desc