cet — 5 answered market questions

Upcoming US market closures and half days, in German time

most recentas of 2026-11-07 series 12×8read in context →

Upcoming US market closures and half days, in German time — 12 rows by 8 columns, computed 2026-11-07 from US exchange, SIP and OPRA data.
closure_date	closure_label	weekday	holiday	day_status	et_close	german_close	days_away
2026-11-26	26 November	Thu	Thanksgiving	closed			19
2026-11-27	27 November	Fri	Thanksgiving	early-close	13:November	19:November	20
2026-12-24	24 December	Thu	Christmas	early-close	13:December	19:December	47
2026-12-25	25 December	Fri	Christmas	closed			48
2027-01-01	1 January	Fri	New Years Day	closed			55
2027-01-18	18 January	Mon	Martin Luther King, Jr. Day	closed			72
2027-02-15	15 February	Mon	Washington's Birthday	closed			100
2027-03-26	26 March	Fri	Good Friday	closed			139
2027-05-31	31 May	Mon	Memorial Day	closed			205
2027-06-18	18 June	Fri	Juneteenth	closed			223
2027-07-05	5 July	Mon	Independence Day	closed			240
2027-09-06	6 September	Mon	Labor Day	closed			303

the exact SQL behind every number

SELECT
    toString(date)                                             AS closure_date,
    concat(toString(toDayOfMonth(date)), ' ', monthName(date)) AS closure_label,
    formatDateTime(date, '%a')                                 AS weekday,
    any(name)                                                  AS holiday,
    any(status)                                                AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'America/New_York'), '%H:%M'),
           ''))                                                AS et_close,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Europe/Berlin'), '%H:%M'),
           ''))                                                AS german_close,
    dateDiff('day', today(), date)                             AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date

More from this analysisUS Market Hours in German Time (CET/CEST)

The German clock time of the US open, week by week series 58×4 → SPY volume and one-minute range by 30-minute bucket series 16×4 → US session milestones in ET, UTC and German local time table 5×7 → US sessions each year that land an hour earlier in Germany table 5×6 → See all 3,293 queries →