STRASMORE/EXPLORE 2,170 QUERIES

Longest breaks between US trading sessions, January to late July 2026

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-01, from When Do Mutual Fund Trades Settle?.

as of ranking 10×2read in context →
Longest breaks between US trading sessions, January to late July 2026 — 10 rows by 2 columns, computed from US exchange, SIP and OPRA data.
session_paircalendar_days
Fri Jan 16 to Tue Jan 204
Fri Feb 13 to Tue Feb 174
Thu Apr 2 to Mon Apr 64
Fri May 22 to Tue May 264
Thu Jun 18 to Mon Jun 224
Thu Jul 2 to Mon Jul 64
Fri Jan 2 to Mon Jan 53
Fri Jan 9 to Mon Jan 123
Fri Jan 23 to Mon Jan 263
Fri Jan 30 to Mon Feb 23
Rows × columns
10 × 2
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 Longest breaks between US trading sessions, January to late July 2026, derived from the stored result.
ColumnTypeRangeNotes
session_pair text 10 distinct values
calendar_days number 3 to 4

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 
WITH sessions AS (
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2026-01-01') AND toDate('2026-07-24')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
),
ordered AS (
    SELECT arraySort(groupArray(session_date)) AS days
    FROM sessions
),
pairs AS (
    SELECT arrayJoin(arrayZip(arraySlice(days, 1, length(days) - 1), arraySlice(days, 2))) AS pair
    FROM ordered
)
SELECT concat(formatDateTimeInJodaSyntax(pair.1, 'EEE MMM d'), ' to ',
              formatDateTimeInJodaSyntax(pair.2, 'EEE MMM d')) AS session_pair,
       dateDiff('day', pair.1, pair.2) AS calendar_days
FROM pairs
WHERE dateDiff('day', pair.1, pair.2) > 1
ORDER BY calendar_days DESC, pair.1 ASC
LIMIT 10

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 analysisWhen Do Mutual Fund Trades Settle?
How far the S&P 500 tracker moved open to close: sessions by size band, July 2025 to June 2026 ranking 5×3 → Short end vs long end of the Treasury curve: monthly averages, July 2024 to June 2026 series 24×4 → Trading sessions vs calendar days, twelve months through June 2026 series 12×4 → Quoted bid-ask spread by fund: venue quotes, 11:00 to 13:59 ET, July 22, 2026 ranking 7×4 → How far the price travels inside a day: seven ETFs, July 2026 sessions ranking 7×4 → Average one-day move across six widely held funds, since 2021 ranking 6×2 → See all 2,170 queries →