Session verification: five sessions, no holiday, next scheduled closure

Name: Session verification: five sessions, no holiday, next scheduled closure
Creator: Strasmore
Published: 2026-07-26
License: https://www.strasmore.com/terms/

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-07-26, from Market Recap: Week of July 6, 2026.

as of 2026-07-26 scalar 1×6read in context →

sessions in week

first session

2026-07-06

last session

2026-07-10

holiday rows in week

next closure date

2026-09-07

next closure name

Labor Day

Rows × columns: 1 × 6
Period covered: 2026-07-06
Computed: 2026-07-26
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 Session verification: five sessions, no holiday, next scheduled closure, derived from the stored result.
Column	Type	Range
`sessions_in_week`	number	every row is 5
`first_session`	date	2026-07-06
`last_session`	date	2026-07-10
`holiday_rows_in_week`	number	every row is 0
`next_closure_date`	date	2026-09-07
`next_closure_name`	text	1 distinct value (Labor Day)

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 2026-07-26, and the query below is what returned them.

the exact SQL behind every number

SELECT
    uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS sessions_in_week,
    toString(min(toDate(toTimeZone(window_start, 'America/New_York')))) AS first_session,
    toString(max(toDate(toTimeZone(window_start, 'America/New_York')))) AS last_session,
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-06' AND date <= '2026-07-10') AS holiday_rows_in_week,
    (SELECT toString(min(date)) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-10' AND status = 'closed') AS next_closure_date,
    (SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-10' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-10 20:00:00'
  AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199

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 analysisMarket Recap: Week of July 6, 2026

Next week on the calendar: closures, ex-dividends, and the monthly expiry's pull scalar 1×4 → SK Hynix's US debut: the raise, the delayed open, the close vs offer, and where the first-day tape ranks in 2026 scalar 1×14 → The week's corporate calendar: filings, dividends, splits, news scalar 1×10 → SPY's week in trailing-year context (open-to-close weekly returns, ~53 weeks) scalar 1×5 → Treasury curve: the Friday July 10 print vs the July 2 close, both late receipts on file scalar 1×6 → Weekly breadth: July 10 close vs July 2 close, names with $5M+ traded during the week scalar 1×4 → See all 2,170 queries →