STRASMORE/EXPLORE 2,170 QUERIES

Upcoming US stock market holidays and early closes

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-25, from Stock Market Holidays 2026–2027: NYSE & Nasdaq.

as of series 12×6read in context →
Upcoming US stock market holidays and early closes — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
holiday_dateweekdayholidayday_statusearly_close_etdays_away
2026-09-07MonLabor Dayclosed13
2026-11-26ThuThanksgivingclosed93
2026-11-27FriThanksgivingearly-close01:00 PM94
2026-12-24ThuChristmasearly-close01:00 PM121
2026-12-25FriChristmasclosed122
2027-01-01FriNew Years Dayclosed129
2027-01-18MonMartin Luther King, Jr. Dayclosed146
2027-02-15MonWashington's Birthdayclosed174
2027-03-26FriGood Fridayclosed213
2027-05-31MonMemorial Dayclosed279
2027-06-18FriJuneteenthclosed297
2027-07-05MonIndependence Dayclosed314
Rows × columns
12 × 6
Period covered
to
Computed
Completeness
Some fields are partly empty — see the columns below
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Upcoming US stock market holidays and early closes, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-09-07 to 2027-07-05
weekday date Fri to Thu
holiday date Christmas to Washington
day_status text 2 distinct values (closed, early-close)
early_close_et text 1 distinct value (01:00 PM) 2 of 12 rows populated
days_away number 13 to 314

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

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 Upcoming US stock market holidays and early closes, from the exchange calendar series 12×6 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening print series 11×6 See all 2,170 queries →