Where the consolidated tape starts and stops each day (AAPL, September 2026)

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.

SELECT
    toString(d)             AS session_date,
    min(et_label)           AS first_print_et,
    max(et_label)           AS last_print_et,
    min(et_minutes)         AS first_print_et_minutes,
    max(et_minutes)         AS last_print_et_minutes
FROM
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York'))                        AS d,
        formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i')       AS et_label,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York'))                AS et_minutes
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-09-01 00:00:00'
      AND window_start <  '2026-09-19 00:00:00'
      AND volume > 0
)
GROUP BY d
HAVING count() > 200
ORDER BY d