date_trunc('{{ period }}', block_timestamp) as date,

count(distinct tx_hash) as transactions,

count(distinct origin_from_address) as users,

count(distinct service_id) as services,

count(distinct agent_ids) as agents,

count(distinct owner_address) as owners,

sum(transactions) over (order by date) as cumulative_transactions

crosschain.olas.ez_service_registrations

where block_timestamp >= '2024-01-01'

group by 1

order by 1