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.
| closed_date | date_il | israeli_weekday | days_ago |
|---|---|---|---|
| 2025-11-27 | 27.11.2025 | יום חמישי | 312 |
| 2025-12-25 | 25.12.2025 | יום חמישי | 284 |
| 2026-01-01 | 01.01.2026 | יום חמישי | 277 |
| 2026-01-19 | 19.01.2026 | יום שני | 259 |
| 2026-02-16 | 16.02.2026 | יום שני | 231 |
| 2026-04-03 | 03.04.2026 | יום שישי | 185 |
| 2026-05-25 | 25.05.2026 | יום שני | 133 |
| 2026-06-19 | 19.06.2026 | יום שישי | 108 |
| 2026-07-03 | 03.07.2026 | יום שישי | 94 |
| 2026-09-07 | 07.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
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
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
עבדו עם הנתונים האלה בעוזר ה-AI שלכם
נפתח מוכן לשאילתות, עם הנתונים של העמוד הזה. בחינם, בלי חשבון.