STRASMORE/EXPLORE 3,094 QUERIES

hag_sessions

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 11×5read in context →
hag_sessions — 11 rows by 5 columns, computed from US exchange, SIP and OPRA data.
hagsession_datedate_ilisraeli_weekdayvolume_millions
ראש השנה תשפ״ו א׳2025-09-2323.09.2025יום שלישי81.7
ראש השנה תשפ״ו ב׳2025-09-2424.09.2025יום רביעי68.1
יום כיפור תשפ״ו2025-10-0202.10.2025יום חמישי56.9
סוכות א׳2025-10-0707.10.2025יום שלישי72
שמיני עצרת ושמחת תורה2025-10-1414.10.2025יום שלישי88.8
פורים2026-03-0303.03.2026יום שלישי105
פסח א׳2026-04-0202.04.2026יום חמישי68.4
שביעי של פסח2026-04-0808.04.2026יום רביעי93.6
יום העצמאות2026-04-2222.04.2026יום רביעי42.5
שבועות2026-05-2222.05.2026יום שישי41.8
יום כיפור תשפ״ז2026-09-2121.09.2026יום שני50.5
Rows × columns
11 × 5
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 hag_sessions, derived from the stored result.
ColumnTypeRangeNotes
hag text 11 distinct values
session_date date 2025-09-23 to 2026-09-21
date_il text 11 distinct values (02.04.2026, 02.10.2025, 03.03.2026…)
israeli_weekday text 5 distinct values (יום חמישי, יום רביעי, יום שישי…)
volume_millions number 41.8 to 105 count

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.

WITH
    ['2025-09-23', '2025-09-24', '2025-10-02', '2025-10-07', '2025-10-14',
     '2026-03-03', '2026-04-02', '2026-04-08', '2026-04-22', '2026-05-22',
     '2026-09-21'] AS hag_dates,
    ['ראש השנה תשפ״ו א׳', 'ראש השנה תשפ״ו ב׳', 'יום כיפור תשפ״ו', 'סוכות א׳',
     'שמיני עצרת ושמחת תורה', 'פורים', 'פסח א׳', 'שביעי של פסח',
     'יום העצמאות', 'שבועות', 'יום כיפור תשפ״ז'] AS hag_names
SELECT
    arrayElement(hag_names, indexOf(hag_dates, toString(date)))  AS hag,
    toString(date)                                               AS session_date,
    formatDateTime(date, '%d.%m.%Y')                             AS date_il,
    arrayElement(['יום שני', 'יום שלישי', 'יום רביעי', 'יום חמישי', 'יום שישי'],
                 toDayOfWeek(date))                              AS israeli_weekday,
    round(toFloat64(volume) / 1e6, 1)                            AS volume_millions
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
  AND date >= '2025-09-01'
  AND date <= '2026-09-30'
  AND has(hag_dates, toString(date))
ORDER BY date
⌘/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