STRASMORE/EXPLORE 2,985 QUERIES

Upcoming US market closures 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-09-26, from Mutual Fund Order Cutoff Times by Broker.

as of series 12×7read in context →
Upcoming US market closures and early closes — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
closure_dateweekdaydate_labelclosure_nameday_statusearly_close_etdays_away
2026-11-26ThuNovember 26Thanksgivingclosed61
2026-11-27FriNovember 27Thanksgivingearly-close01:00 PM62
2026-12-24ThuDecember 24Christmasearly-close01:00 PM89
2026-12-25FriDecember 25Christmasclosed90
2027-01-01FriJanuary 1New Years Dayclosed97
2027-01-18MonJanuary 18Martin Luther King, Jr. Dayclosed114
2027-02-15MonFebruary 15Washington's Birthdayclosed142
2027-03-26FriMarch 26Good Fridayclosed181
2027-05-31MonMay 31Memorial Dayclosed247
2027-06-18FriJune 18Juneteenthclosed265
2027-07-05MonJuly 5Independence Dayclosed282
2027-09-06MonSeptember 6Labor Dayclosed345
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 closures and early closes, derived from the stored result.
ColumnTypeRangeNotes
closure_date date 2026-11-26 to 2027-09-06
weekday text 3 distinct values (Fri, Mon, Thu)
date_label text 12 distinct values (December 24, December 25, February 15…)
closure_name 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 61 to 345

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 closure_date,
    formatDateTime(date, '%a')                                 AS weekday,
    concat(monthName(date), ' ', toString(toDayOfMonth(date))) AS date_label,
    any(name)                                                  AS closure_name,
    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

このデータをAIアシスタントで使う

このページのデータで、すぐにクエリできる状態で開きます。無料、アカウント不要。

More from this analysisMutual Fund Order Cutoff Times by Broker
Shortened sessions on the SPY tape since January 2024 series 6×5 → Full sessions versus shortened sessions over the trailing year ranking 2×2 → One session's price path, SPY every 15 minutes on June 17, 2026 series 27×2 → Share of SPY's session volume by half hour, June 2026 average series 13×2 → Average distance from each ET clock mark to the closing print (SPY, trailing months) series 13×3 → How far SPY trades from its own open and close, by time of day series 13×3 → See all 2,985 queries →