STRASMORE/EXPLORE 3,293 QUERIES

Every upcoming NYSE closure and early close on the calendar feed, with a countdown

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-18, from Is the Stock Market Open Today?.

as of series 12×6read in context →
Every upcoming NYSE closure and early close on the calendar feed, with a countdown — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
closure_datefalls_onholidayday_statuscloses_at_etdays_away
2026-11-26ThuThanksgivingclosed39
2026-11-27FriThanksgivingearly-close13:0040
2026-12-24ThuChristmasearly-close13:0067
2026-12-25FriChristmasclosed68
2027-01-01FriNew Years Dayclosed75
2027-01-18MonMartin Luther King, Jr. Dayclosed92
2027-02-15MonWashington's Birthdayclosed120
2027-03-26FriGood Fridayclosed159
2027-05-31MonMemorial Dayclosed225
2027-06-18FriJuneteenthclosed243
2027-07-05MonIndependence Dayclosed260
2027-09-06MonLabor Dayclosed323
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 Every upcoming NYSE closure and early close on the calendar feed, with a countdown, derived from the stored result.
ColumnTypeRangeNotes
closure_date date 2026-11-26 to 2027-09-06
falls_on 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)
closes_at_et text 1 distinct value (13:00) 2 of 12 rows populated
days_away number 39 to 323

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 falls_on,
       any(name) AS holiday,
       any(status) AS day_status,
       any(if(status = 'early-close', formatDateTime(toTimeZone(close, 'America/New_York'), '%H:%i'), '')) AS closes_at_et,
       dateDiff('day', today(), date) AS days_away
FROM global_markets.stocks_market_holidays
WHERE exchange = 'NYSE' AND date >= today()
GROUP BY date
ORDER BY date
LIMIT 16
⌘/Ctrl + Enter

在你的 AI 助手中使用这些数据

打开即可查询,已带上本页数据。免费,无需账号。

More from this analysisIs the Stock Market Open Today?
SPY across recent weekends and holiday weekends: Friday's close vs. the reopening print series 10×6 → Unscheduled closures on the tape: zero regular-session bars on an ordinary weekday series 5×4 → This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar) table 2×5 → Weekdays in the trailing year when stocks traded but no Treasury yield printed table 2×2 → Market status computed at this page's refresh: weekday check, holiday check, and the ET clock scalar 1×7 → The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observed scalar 1×6 → See all 3,293 queries →