STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-10-08 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-10-08 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-10-08 · 1×3251 The closure calendar ahead, at a glancescalar · 2026-10-08 · 1×610
Mutual Fund Cutoffs on Early-Close Days
Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025ranking · 2026-10-04 · 2×4Preview: 2 ranked values, smallest first. SPY volume by half hour: a 1:00 p.m. half day against an ordinary Fridayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Upcoming 1:00 p.m. early closes, with the hour before each oneseries · 2026-10-04 · 2×6Preview: a 2-point series, ending higher. Every upcoming closure, tagged full closure or early closeseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher.
After-Hours Trading on Holidays and Weekends
Average SPY minute bars per calendar day, by weekdayseries · 2026-10-04 · 7×4Preview: a 7-point series, roughly flat. Upcoming US market closures and early closesseries · 2026-10-04 · 12×7Preview: a 12-point series, ending higher. SPY minute bars by ET clock hour: a normal day, a holiday, a half dayranking · 2026-10-04 · 15×4Preview: 15 ranked values, smallest first. First and last SPY print, Thanksgiving 2025 week and the week afterseries · 2026-10-04 · 12×5Preview: a 12-point series, roughly flat.
Upcoming US stock market holidays and early closes

Upcoming US stock market holidays and early closes

most recentas 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-11-26ThuThanksgivingclosed49
2026-11-27FriThanksgivingearly-close01:00 PM50
2026-12-24ThuChristmasearly-close01:00 PM77
2026-12-25FriChristmasclosed78
2027-01-01FriNew Years Dayclosed85
2027-01-18MonMartin Luther King, Jr. Dayclosed102
2027-02-15MonWashington's Birthdayclosed130
2027-03-26FriGood Fridayclosed169
2027-05-31MonMemorial Dayclosed235
2027-06-18FriJuneteenthclosed253
2027-07-05MonIndependence Dayclosed270
2027-09-06MonLabor Dayclosed333
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 3,256 queries →
$