us_zu_xetra_offen

Name: us_zu_xetra_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 ranking 7×4read in context →

us_zu_xetra_offen — 7 rows by 4 columns, computed 2026-11-01 from US exchange, SIP and OPRA data.
datum	wochentag	us_feiertag	tage_bis
26.11.2026	Do	Thanksgiving	25
18.01.2027	Mo	Martin Luther King, Jr. Day	78
15.02.2027	Mo	Washington's Birthday	106
31.05.2027	Mo	Memorial Day	211
18.06.2027	Fr	Juneteenth	229
05.07.2027	Mo	Independence Day	246
06.09.2027	Mo	Labor Day	309

Rows × columns: 7 × 4
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 us_zu_xetra_offen, derived from the stored result.
Column	Type	Range
`datum`	text	7 distinct values (05.07.2027, 06.09.2027, 15.02.2027…)
`wochentag`	text	3 distinct values (Do, Fr, Mo)
`us_feiertag`	text	7 distinct values (Independence Day, Juneteenth, Labor Day…)
`tage_bis`	number	25 to 309

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
    [
        ('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 xetra_liste,
    arrayMap(t -> toDate(tupleElement(t, 2)), xetra_liste)  AS xetra_geschlossen,
    toDate('2027-12-31')                                    AS xetra_liste_ende
SELECT
    formatDateTime(date, '%d.%m.%Y')                                                            AS datum,
    transform(toDayOfWeek(date), [1, 2, 3, 4, 5, 6, 7], ['Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So'], '') AS wochentag,
    any(name)                                                                                   AS us_feiertag,
    dateDiff('day', today(), date)                                                              AS tage_bis
FROM global_markets.stocks_market_holidays
WHERE date >= today()
  AND status = 'closed'
  AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
  AND toDayOfWeek(date) BETWEEN 1 AND 5
  AND date <= xetra_liste_ende
  AND NOT has(xetra_geschlossen, date)
GROUP BY date
ORDER BY date

SQL to run

WITH
    [
        ('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 xetra_liste,
    arrayMap(t -> toDate(tupleElement(t, 2)), xetra_liste)  AS xetra_geschlossen,
    toDate('2027-12-31')                                    AS xetra_liste_ende
SELECT
    formatDateTime(date, '%d.%m.%Y')                                                            AS datum,
    transform(toDayOfWeek(date), [1, 2, 3, 4, 5, 6, 7], ['Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So'], '') AS wochentag,
    any(name)                                                                                   AS us_feiertag,
    dateDiff('day', today(), date)                                                              AS tage_bis
FROM global_markets.stocks_market_holidays
WHERE date >= today()
  AND status = 'closed'
  AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
  AND toDayOfWeek(date) BETWEEN 1 AND 5
  AND date <= xetra_liste_ende
  AND NOT has(xetra_geschlossen, date)
GROUP BY 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