DATE_TRUNC('day', block_timestamp) AS report_date,

blockchain AS blockchain_type,

COUNT(DISTINCT tx_hash) AS total_registrations,

COUNT(DISTINCT origin_from_address) AS total_signers,

COUNT(DISTINCT agent_ids) AS total_agents,

COUNT(DISTINCT owner_address) AS total_owners,

FROM

crosschain.olas.ez_service_registrations

WHERE

block_timestamp::date >= '2024-01-01'

GROUP BY

report_date, blockchain_type

ORDER BY

report_date;