DATE_TRUNC('week', block_timestamp) as week,

service_id,

name,

COUNT(*) as days_active_this_week,

(COUNT(*)::FLOAT / 7) * 100 as weekly_consistency_percentage

FROM crosschain.olas.ez_service_checkpoints

GROUP BY 1, 2, 3

ORDER BY 1, 2;