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

blockchain,

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,

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

crosschain.olas.ez_service_registrations

where block_timestamp >= '2024-01-01'

group by 1, 2

order by 1, 2