SELECT

DATE_TRUNC('day', block_timestamp) as day,

topic_0 as event_signature,

COUNT(*) as event_count,

COUNT(DISTINCT service_id) as unique_services_affected

FROM crosschain.olas.fact_service_events

GROUP BY 1, 2

ORDER BY 1, 4 DESC;

select *

FROM crosschain.olas.fact_service_events