xetra_zu_us_offen

Name: xetra_zu_us_offen
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-vs-german-market-holidays.

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

xetra_zu_us_offen — 4 rows by 6 columns, computed 2026-11-01 from US exchange, SIP and OPRA data.
datum	wochentag	xetra_feiertag	us_sitzung	ny_eroeffnung_berlin	tage_bis
24.12.2026	Do	Heiligabend	verkürzter Handelstag	15:30	53
31.12.2026	Do	Silvester	voller Handelstag	15:30	60
29.03.2027	Mo	Ostermontag	voller Handelstag	15:30	148
17.05.2027	Mo	Pfingstmontag	voller Handelstag	15:30	197

Rows × columns: 4 × 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 xetra_zu_us_offen, derived from the stored result.
Column	Type	Range
`datum`	text	4 distinct values (17.05.2027, 24.12.2026, 29.03.2027…)
`wochentag`	text	2 distinct values (Do, Mo)
`xetra_feiertag`	text	4 distinct values (Heiligabend, Ostermontag, Pfingstmontag…)
`us_sitzung`	text	2 distinct values (verkürzter Handelstag, voller Handelstag)
`ny_eroeffnung_berlin`	text	1 distinct value (15:30)
`tage_bis`	number	53 to 197

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.

WITH
    (
        SELECT groupArray(date)
        FROM global_markets.stocks_market_holidays
        WHERE status = 'closed'
          AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
    ) AS us_geschlossen,
    (
        SELECT groupArray(date)
        FROM global_markets.stocks_market_holidays
        WHERE status = 'early-close'
          AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
    ) AS us_verkuerzt,
    (
        SELECT max(date)
        FROM global_markets.stocks_market_holidays
        WHERE exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%'
    ) AS us_kalender_ende
SELECT
    formatDateTime(d, '%d.%m.%Y')                                                               AS datum,
    transform(toDayOfWeek(d), [1, 2, 3, 4, 5, 6, 7], ['Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So'], '')    AS wochentag,
    xetra_feiertag,
    if(has(us_verkuerzt, d), 'verkürzter Handelstag', 'voller Handelstag')                       AS us_sitzung,
    formatDateTime(
        toTimeZone(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), 'Europe/Berlin'),
        '%H:%i')                                                                                AS ny_eroeffnung_berlin,
    dateDiff('day', today(), d)                                                                 AS tage_bis
FROM
(
    SELECT
        tupleElement(t, 1)          AS xetra_feiertag,
        toDate(tupleElement(t, 2))  AS d
    FROM
    (
        SELECT arrayJoin([
            ('Neujahr',          '2026-01-01'),
            ('Karfreitag',       '2026-04-03'),
            ('Ostermontag',      '2026-04-06'),
            ('Tag der Arbeit',   '2026-05-01'),
            ('Pfingstmontag',    '2026-05-25'),
            ('Heiligabend',      '2026-12-24'),
            ('1. Weihnachtstag', '2026-12-25'),
            ('2. Weihnachtstag', '2026-12-26'),
            ('Silvester',        '2026-12-31'),
            ('Neujahr',          '2027-01-01'),
            ('Karfreitag',       '2027-03-26'),
            ('Ostermontag',      '2027-03-29'),
            ('Tag der Arbeit',   '2027-05-01'),
            ('Pfingstmontag',    '2027-05-17'),
            ('Heiligabend',      '2027-12-24'),
            ('1. Weihnachtstag', '2027-12-25'),
            ('2. Weihnachtstag', '2027-12-26'),
            ('Silvester',        '2027-12-31')
        ]) AS t
    )
)
WHERE d >= today()
  AND toDayOfWeek(d) BETWEEN 1 AND 5
  AND d <= us_kalender_ende
  AND NOT has(us_geschlossen, d)
ORDER BY d

SQL to run

WITH
    (
        SELECT groupArray(date)
        FROM global_markets.stocks_market_holidays
        WHERE status = 'closed'
          AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
    ) AS us_geschlossen,
    (
        SELECT groupArray(date)
        FROM global_markets.stocks_market_holidays
        WHERE status = 'early-close'
          AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
    ) AS us_verkuerzt,
    (
        SELECT max(date)
        FROM global_markets.stocks_market_holidays
        WHERE exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%'
    ) AS us_kalender_ende
SELECT
    formatDateTime(d, '%d.%m.%Y')                                                               AS datum,
    transform(toDayOfWeek(d), [1, 2, 3, 4, 5, 6, 7], ['Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So'], '')    AS wochentag,
    xetra_feiertag,
    if(has(us_verkuerzt, d), 'verkürzter Handelstag', 'voller Handelstag')                       AS us_sitzung,
    formatDateTime(
        toTimeZone(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), 'Europe/Berlin'),
        '%H:%i')                                                                                AS ny_eroeffnung_berlin,
    dateDiff('day', today(), d)                                                                 AS tage_bis
FROM
(
    SELECT
        tupleElement(t, 1)          AS xetra_feiertag,
        toDate(tupleElement(t, 2))  AS d
    FROM
    (
        SELECT arrayJoin([
            ('Neujahr',          '2026-01-01'),
            ('Karfreitag',       '2026-04-03'),
            ('Ostermontag',      '2026-04-06'),
            ('Tag der Arbeit',   '2026-05-01'),
            ('Pfingstmontag',    '2026-05-25'),
            ('Heiligabend',      '2026-12-24'),
            ('1. Weihnachtstag', '2026-12-25'),
            ('2. Weihnachtstag', '2026-12-26'),
            ('Silvester',        '2026-12-31'),
            ('Neujahr',          '2027-01-01'),
            ('Karfreitag',       '2027-03-26'),
            ('Ostermontag',      '2027-03-29'),
            ('Tag der Arbeit',   '2027-05-01'),
            ('Pfingstmontag',    '2027-05-17'),
            ('Heiligabend',      '2027-12-24'),
            ('1. Weihnachtstag', '2027-12-25'),
            ('2. Weihnachtstag', '2027-12-26'),
            ('Silvester',        '2027-12-31')
        ]) AS t
    )
)
WHERE d >= today()
  AND toDayOfWeek(d) BETWEEN 1 AND 5
  AND d <= us_kalender_ende
  AND NOT has(us_geschlossen, d)
ORDER BY d

⌘/Ctrl + Enter

Arbeiten Sie mit diesen Daten in Ihrem KI-Assistenten

Öffnet sich abfragebereit, mit den Daten dieser Seite. Kostenlos, ohne Konto.

Claude ChatGPT Gemini Muse Ihr eigener Agent