STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

US Market Hours in German Time (CET/CEST)
Upcoming US market closures and half days, in German timeseries · 2026-11-01 · 12×8Preview: a 12-point series, ending higher. US session milestones in ET, UTC and German local timetable · 2026-11-01 · 5×7 The German clock time of the US open, week by weekseries · 2026-11-01 · 57×4Preview: a 16-point series, roughly flat. US sessions each year that land an hour earlier in Germanytable · 2026-11-01 · 5×6 SPY volume and one-minute range by 30-minute bucketseries · 2026-11-01 · 16×4Preview: a 16-point series, ending lower.
Tradegate vs Xetra: Hours and Prices
Median quoted spread by clock hour, one symbol, one sessionseries · 2026-09-28 · 16×4Preview: a 16-point series, roughly flat. SPY volume in ten-minute buckets across one full trading dayseries · 2026-09-28 · 96×2Preview: a 16-point series, roughly flat. Evening volume share and the gap to the official closeranking · 2026-09-28 · 6×3Preview: 6 ranked values, largest first. Where one session's volume actually printed, by phaseseries · 2026-09-28 · 5×3Preview: a 5-point series, roughly flat.
Xetra Trading Hours and Holidays 2026–2027
Weekdays, weekday closures and Xetra sessions per calendar yeartable · 2026-09-16 · 2×5 Days when the New York open lands at 14:30 Frankfurt time (three-hour overlap), 2026 and 2027series · 2026-09-16 · 4×5Preview: a 4-point series, ending lower. Xetra non-trading days 2027, from the Deutsche Börse trading calendartable · 2026-09-16 · 8×5 Xetra non-trading days 2026, from the Deutsche Börse trading calendartable · 2026-09-16 · 8×5
Upcoming US market closures and half days, in German time

Upcoming US market closures and half days, in German time

most recentas of series 12×8read in context →
Upcoming US market closures and half days, in German time — 12 rows by 8 columns, computed from US exchange, SIP and OPRA data.
closure_dateclosure_labelweekdayholidayday_statuset_closegerman_closedays_away
2026-11-2626 NovemberThuThanksgivingclosed25
2026-11-2727 NovemberFriThanksgivingearly-close13:November19:November26
2026-12-2424 DecemberThuChristmasearly-close13:December19:December53
2026-12-2525 DecemberFriChristmasclosed54
2027-01-011 JanuaryFriNew Years Dayclosed61
2027-01-1818 JanuaryMonMartin Luther King, Jr. Dayclosed78
2027-02-1515 FebruaryMonWashington's Birthdayclosed106
2027-03-2626 MarchFriGood Fridayclosed145
2027-05-3131 MayMonMemorial Dayclosed211
2027-06-1818 JuneFriJuneteenthclosed229
2027-07-055 JulyMonIndependence Dayclosed246
2027-09-066 SeptemberMonLabor Dayclosed309
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 57×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 →
$