Calendar days against regular trading sessions since the SPCX debut

WITH sessions AS
(
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS d
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPCX'
      AND window_start >= '2026-06-01'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
)
SELECT
    week,
    calendar_days_elapsed,
    toUInt32(sum(sessions_in_week) OVER (ORDER BY week)) AS sessions_elapsed
FROM
(
    SELECT
        toString(toMonday(d))                                       AS week,
        dateDiff('day', (SELECT min(d) FROM sessions), max(d)) + 1  AS calendar_days_elapsed,
        count()                                                     AS sessions_in_week
    FROM sessions
    GROUP BY week
)
ORDER BY week