mismatch_windows

Name: mismatch_windows
Creator: Strasmore
Published: 2026-11-01
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-11-01, from us-stock-market-hours-israel-time.

as of 2026-11-01 table 2×6read in context →

mismatch_windows — 2 rows by 6 columns, computed 2026-11-01 from US exchange, SIP and OPRA data.
season_label	starts_il	ends_il	trading_days	open_israel	close_israel
אביב 2026	09.03.2026	26.03.2026	14	15:30	22:00
סתיו 2026	26.10.2026	30.10.2026	5	15:30	22:00

Rows × columns: 2 × 6
Computed: 2026-11-01
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 mismatch_windows, derived from the stored result.
Column	Type	Range
`season_label`	text	2 distinct values (אביב 2026, סתיו 2026)
`starts_il`	text	2 distinct values (09.03.2026, 26.10.2026)
`ends_il`	text	2 distinct values (26.03.2026, 30.10.2026)
`trading_days`	number	5 to 14
`open_israel`	text	1 distinct value (15:30)
`close_israel`	text	1 distinct value (22:00)

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-11-01, 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
    season_label,
    formatDateTime(min(d), '%d.%m.%Y')   AS starts_il,
    formatDateTime(max(d), '%d.%m.%Y')   AS ends_il,
    count()                              AS trading_days,
    any(open_israel)                     AS open_israel,
    any(close_israel)                    AS close_israel
FROM
(
    SELECT
        d,
        concat(if(toMonth(d) <= 6, 'אביב ', 'סתיו '), toString(toYear(d)))                                                       AS season_label,
        formatDateTime(toTimeZone(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), 'Asia/Jerusalem'), '%H:%i') AS open_israel,
        formatDateTime(toTimeZone(toDateTime(concat(toString(d), ' 16:00:00'), 'America/New_York'), 'Asia/Jerusalem'), '%H:%i') AS close_israel,
        toHour(toTimeZone(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), 'Asia/Jerusalem'))                  AS open_hour_israel
    FROM
    (
        SELECT date AS d
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date >= toDate('2026-01-01')
          AND date <= toDate('2026-12-31')
        GROUP BY date
        UNION ALL
        SELECT d
        FROM (SELECT toDate('2026-01-01') + arrayJoin(range(365)) AS d)
        WHERE d > (SELECT max(date) FROM global_markets.stocks_daily_aggs WHERE ticker = 'SPY')
          AND d <= toDate('2026-12-31')
          AND toDayOfWeek(d) BETWEEN 1 AND 5
          AND d NOT IN (SELECT date FROM global_markets.stocks_market_holidays WHERE status = 'closed')
    )
)
WHERE open_hour_israel = 15
GROUP BY season_label
ORDER BY min(d)

SQL to run

SELECT
    season_label,
    formatDateTime(min(d), '%d.%m.%Y')   AS starts_il,
    formatDateTime(max(d), '%d.%m.%Y')   AS ends_il,
    count()                              AS trading_days,
    any(open_israel)                     AS open_israel,
    any(close_israel)                    AS close_israel
FROM
(
    SELECT
        d,
        concat(if(toMonth(d) <= 6, 'אביב ', 'סתיו '), toString(toYear(d)))                                                       AS season_label,
        formatDateTime(toTimeZone(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), 'Asia/Jerusalem'), '%H:%i') AS open_israel,
        formatDateTime(toTimeZone(toDateTime(concat(toString(d), ' 16:00:00'), 'America/New_York'), 'Asia/Jerusalem'), '%H:%i') AS close_israel,
        toHour(toTimeZone(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), 'Asia/Jerusalem'))                  AS open_hour_israel
    FROM
    (
        SELECT date AS d
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date >= toDate('2026-01-01')
          AND date <= toDate('2026-12-31')
        GROUP BY date
        UNION ALL
        SELECT d
        FROM (SELECT toDate('2026-01-01') + arrayJoin(range(365)) AS d)
        WHERE d > (SELECT max(date) FROM global_markets.stocks_daily_aggs WHERE ticker = 'SPY')
          AND d <= toDate('2026-12-31')
          AND toDayOfWeek(d) BETWEEN 1 AND 5
          AND d NOT IN (SELECT date FROM global_markets.stocks_market_holidays WHERE status = 'closed')
    )
)
WHERE open_hour_israel = 15
GROUP BY season_label
ORDER BY min(d)

⌘/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