2,173 answered market questions

WITH trading_days 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 >= toDateTime('2025-01-01 05:00:00')
      AND window_start < toDateTime('2026-07-01 04:00:00')
)
SELECT formatDateTime(toStartOfMonth(session_date), '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(session_date), 'MMMM yyyy') AS month_label,
       count() AS sessions
FROM trading_days
GROUP BY month, month_label
ORDER BY month