STRASMORE/EXPLORE 3,127 QUERIES

Upcoming US 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-10-06, from How After-Market Orders Work: AMO vs Live.

as of series 12×7read in context →
Upcoming US market holidays and early closes — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
holiday_dateclosure_prettyweekdayholidayday_statusearly_close_etdays_away
2026-11-26Nov 26ThuThanksgivingclosed51
2026-11-27Nov 27FriThanksgivingearly-close01:00 PM52
2026-12-24Dec 24ThuChristmasearly-close01:00 PM79
2026-12-25Dec 25FriChristmasclosed80
2027-01-01Jan 1FriNew Years Dayclosed87
2027-01-18Jan 18MonMartin Luther King, Jr. Dayclosed104
2027-02-15Feb 15MonWashington's Birthdayclosed132
2027-03-26Mar 26FriGood Fridayclosed171
2027-05-31May 31MonMemorial Dayclosed237
2027-06-18Jun 18FriJuneteenthclosed255
2027-07-05Jul 5MonIndependence Dayclosed272
2027-09-06Sep 6MonLabor Dayclosed335
Rows × columns
12 × 7
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 market holidays and early closes, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-11-26 to 2027-09-06
closure_pretty text 12 distinct values (Dec 24, Dec 25, Feb 15…)
weekday text 3 distinct values (Fri, Mon, Thu)
holiday text 10 distinct values (Christmas, Good Friday, Independence Day…)
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 51 to 335

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.

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(date)                                           AS holiday_date,
    concat(formatDateTime(date, '%b '), toString(toDayOfMonth(date))) AS closure_pretty,
    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
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisHow After-Market Orders Work: AMO vs Live
AAPL volume by ET half hour, September 2026 series 32×3 → Share of monthly volume by session phase, September 2026 ranking 5×4 → Median overnight gap against median intraday range, twelve months to September 2026 ranking 5×3 → Average quoted spread by half hour, AAPL and KO, June 17 2026 series 15×3 → KO quoted spread by half hour of the ET clock, one pinned session series 14×3 → Distance from AAPL's daily VWAP to that morning's opening print series 9×2 → See all 3,127 queries →