STRASMORE/EXPLORE 2,170 QUERIES

The closure calendar ahead, at a glance

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 scalar 1×6read in context →
full closures ahead
10
early closes ahead
2
total closures ahead
12
next closure pretty
September 7, 2026
calendar from
2026-09-07
calendar through
2027-07-05
Rows × columns
1 × 6
Period covered
Computed
Completeness
No missing values
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 The closure calendar ahead, at a glance, derived from the stored result.
ColumnTypeRangeNotes
full_closures_ahead number every row is 10
early_closes_ahead number every row is 2
total_closures_ahead number every row is 12
next_closure_pretty text 1 distinct value (September 7, 2026)
calendar_from date 2026-09-07
calendar_through date 2027-07-05

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
    countDistinctIf(date, status = 'closed')      AS full_closures_ahead,
    countDistinctIf(date, status = 'early-close') AS early_closes_ahead,
    countDistinct(date)                           AS total_closures_ahead,
    concat(monthName(min(date)), ' ', toString(toDayOfMonth(min(date))), ', ', toString(toYear(min(date)))) AS next_closure_pretty,
    toString(min(date))                           AS calendar_from,
    toString(max(date))                           AS calendar_through
FROM global_markets.stocks_market_holidays
WHERE date >= today()

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
Regular trading sessions over the trailing year scalar 1×3 Upcoming US stock market holidays and early closes series 12×6 Recently-passed weekday closures, recovered from the SPY tape series 4×3 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 Trading sessions over the trailing year, counted from the SPY tape scalar 1×7 See all 2,170 queries →