DISTINCT service_id, min(DATE_TRUNC('WEEK', block_timestamp)) AS debut

FROM

crosschain.olas.fact_service_events

GROUP BY 1

select distinct debut, count(distinct service_id) as new_services, sum(new_services) over (order by debut) as total_services

from news group by 1 order by 1 desc