after_hours_by_month

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH tape AS
(
    SELECT
        toStartOfMonth(toTimeZone(window_start, 'America/New_York')) AS m,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minute,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2024-10-01 04:00:00'
      AND window_start <  '2026-10-01 04:00:00'
)
SELECT
    toString(m)                                                                    AS month,
    formatDateTime(m, '%b %Y')                                                     AS month_label,
    round(100 * sumIf(volume, et_minute < 570 OR et_minute >= 960) / sum(volume), 2) AS outside_rth_volume_pct,
    round(100 * countIf(et_minute < 570 OR et_minute >= 960) / count(), 2)           AS outside_rth_bars_pct
FROM tape
GROUP BY m, month_label
ORDER BY m