Trade date to settlement date across real sessions, November 2025

WITH sessions AS
(
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= '2025-11-19 00:00:00'
      AND window_start <  '2025-12-10 00:00:00'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN '2025-11-20' AND '2025-12-09'
)
SELECT
    toString(td)                            AS trade_date,
    formatDateTime(td, '%a %b %e')          AS trade_day_label,
    toString(next_td)                       AS settlement_date,
    formatDateTime(next_td, '%a %b %e')     AS settlement_day_label,
    dateDiff('day', td, next_td)            AS calendar_days_to_settle
FROM
(
    SELECT
        session_date AS td,
        leadInFrame(session_date) OVER (ORDER BY session_date ASC
            ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING) AS next_td
    FROM sessions
)
WHERE next_td > td
  AND td <= '2025-12-05'
ORDER BY td