permaryactive services over time
    Updated 2024-11-04
    SELECT
    DATE_TRUNC('month', block_timestamp) as month,
    COUNT(DISTINCT service_id) as active_services,
    SUM(COUNT(DISTINCT service_id)) OVER (ORDER BY DATE_TRUNC('month', block_timestamp)) as cumulative_services
    FROM crosschain.olas.ez_service_checkpoints
    GROUP BY 1
    ORDER BY 1;
    QueryRunArchived: QueryRun has been archived