early close — 4 answered market questions

Upcoming US stock market holidays and early closes

most recentas of 2026-08-25 series 12×6read in context →

Upcoming US stock market holidays and early closes — 12 rows by 6 columns, computed 2026-08-25 from US exchange, SIP and OPRA data.
holiday_date	weekday	holiday	day_status	early_close_et	days_away
2026-09-07	Mon	Labor Day	closed		13
2026-11-26	Thu	Thanksgiving	closed		93
2026-11-27	Fri	Thanksgiving	early-close	01:00 PM	94
2026-12-24	Thu	Christmas	early-close	01:00 PM	121
2026-12-25	Fri	Christmas	closed		122
2027-01-01	Fri	New Years Day	closed		129
2027-01-18	Mon	Martin Luther King, Jr. Day	closed		146
2027-02-15	Mon	Washington's Birthday	closed		174
2027-03-26	Fri	Good Friday	closed		213
2027-05-31	Mon	Memorial Day	closed		279
2027-06-18	Fri	Juneteenth	closed		297
2027-07-05	Mon	Independence Day	closed		314

the exact SQL behind every number

SELECT
    toString(date)                       AS holiday_date,
    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'), '%I:%i %p'),
           ''))                          AS early_close_et,
    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 analysisStock Market Holidays 2026–2027: NYSE & Nasdaq

Recently-passed weekday closures, recovered from the SPY tape series 4×3 → Regular trading sessions over the trailing year scalar 1×3 → The closure calendar ahead, at a glance scalar 1×6 → Every upcoming NYSE closure and early close on the calendar feed, with a countdown series 12×6 → See all 2,170 queries →