select
date_trunc('month', block_timestamp) as month,
count(distinct service_id) as new_services,
count(distinct owner_address) as unique_owners,
avg(array_size(agent_ids)) as avg_agents_per_service,
count(case when multisig_address is not null then 1 end) as multisig_services
from crosschain.olas.ez_service_registrations
group by 1
order by 1 DESC;