SELECT
DATE(BLOCK_TIMESTAMP) AS creation_date,
COUNT(DISTINCT SERVICE_ID) AS daily_services_created,
SUM(COUNT(DISTINCT SERVICE_ID)) OVER (
ORDER BY
DATE(BLOCK_TIMESTAMP)
) AS cumulative_services_created
FROM
crosschain.olas.ez_service_registrations
WHERE
BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE) -- Filter for the past year
GROUP BY
creation_date
ORDER BY
creation_date;