STRASMORE/EXPLORE 3,094 QUERIES

no_session_days

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-05, from does-the-us-market-close-for-israeli-holidays.

as of series 10×4read in context →
no_session_days — 10 rows by 4 columns, computed from US exchange, SIP and OPRA data.
closed_datedate_ilisraeli_weekdaydays_ago
2025-11-2727.11.2025יום חמישי312
2025-12-2525.12.2025יום חמישי284
2026-01-0101.01.2026יום חמישי277
2026-01-1919.01.2026יום שני259
2026-02-1616.02.2026יום שני231
2026-04-0303.04.2026יום שישי185
2026-05-2525.05.2026יום שני133
2026-06-1919.06.2026יום שישי108
2026-07-0303.07.2026יום שישי94
2026-09-0707.09.2026יום שני28
Rows × columns
10 × 4
Period covered
to
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 no_session_days, derived from the stored result.
ColumnTypeRangeNotes
closed_date date 2025-11-27 to 2026-09-07
date_il text 10 distinct values (01.01.2026, 03.04.2026, 03.07.2026…)
israeli_weekday text 3 distinct values (יום חמישי, יום שישי, יום שני)
days_ago number 28 to 312

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(cal.day)                                     AS closed_date,
    formatDateTime(cal.day, '%d.%m.%Y')                   AS date_il,
    arrayElement(['יום שני', 'יום שלישי', 'יום רביעי', 'יום חמישי', 'יום שישי'],
                 toDayOfWeek(cal.day))                    AS israeli_weekday,
    dateDiff('day', cal.day, today())                     AS days_ago
FROM
(
    SELECT today() - 371 + arrayJoin(range(372)) AS day
) AS cal
WHERE toDayOfWeek(cal.day) BETWEEN 1 AND 5
  AND cal.day <= today() - 3
  AND cal.day NOT IN
  (
      SELECT date
      FROM global_markets.stocks_daily_aggs
      WHERE ticker = 'SPY'
        AND date >= today() - 371
  )
ORDER BY cal.day
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent