2,173 answered market questions

WITH sessions AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           argMax(formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i'), volume) AS busiest_minute
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2025-07-01')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-30')
    GROUP BY session_date
)
SELECT formatDateTime(toStartOfMonth(session_date), '%Y-%m') AS month,
       count() AS sessions,
       toDayOfMonth(toLastDayOfMonth(min(session_date))) AS calendar_days,
       countIf(busiest_minute < '15:00') AS short_sessions
FROM sessions
GROUP BY toStartOfMonth(session_date)
ORDER BY toStartOfMonth(session_date)