kalender_abdeckung

Name: kalender_abdeckung
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 2×6read in context →

kalender_abdeckung — 2 rows by 6 columns, computed 2026-11-01 from US exchange, SIP and OPRA data.
boerse	quelle	erster_termin	letzter_termin	ganztags_geschlossen	verkuerzte_tage
NYSE/Nasdaq	geladener Börsenkalender	26.11.2026	06.09.2027	10	2
Xetra	hinterlegte Liste 2026 und 2027	24.12.2026	31.12.2027	9	0

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 kalender_abdeckung, derived from the stored result.
Column	Type	Range
`boerse`	text	2 distinct values (NYSE/Nasdaq, Xetra)
`quelle`	text	2 distinct values
`erster_termin`	text	2 distinct values (24.12.2026, 26.11.2026)
`letzter_termin`	text	2 distinct values (06.09.2027, 31.12.2027)
`ganztags_geschlossen`	number	9 to 10
`verkuerzte_tage`	number	0 to 2

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
    boerse,
    quelle,
    erster_termin,
    letzter_termin,
    ganztags_geschlossen,
    verkuerzte_tage
FROM
(
    SELECT
        'NYSE/Nasdaq'                                     AS boerse,
        'geladener Börsenkalender'                        AS quelle,
        formatDateTime(min(date), '%d.%m.%Y')             AS erster_termin,
        formatDateTime(max(date), '%d.%m.%Y')             AS letzter_termin,
        countDistinctIf(date, status = 'closed')          AS ganztags_geschlossen,
        countDistinctIf(date, status = 'early-close')     AS verkuerzte_tage
    FROM global_markets.stocks_market_holidays
    WHERE date >= today()
      AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
    UNION ALL
    SELECT
        'Xetra'                                           AS boerse,
        'hinterlegte Liste 2026 und 2027'                 AS quelle,
        formatDateTime(min(d), '%d.%m.%Y')                AS erster_termin,
        formatDateTime(max(d), '%d.%m.%Y')                AS letzter_termin,
        countIf(toDayOfWeek(d) BETWEEN 1 AND 5)           AS ganztags_geschlossen,
        toUInt64(0)                                       AS verkuerzte_tage
    FROM
    (
        SELECT 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()
)
ORDER BY boerse

SQL to run

SELECT
    boerse,
    quelle,
    erster_termin,
    letzter_termin,
    ganztags_geschlossen,
    verkuerzte_tage
FROM
(
    SELECT
        'NYSE/Nasdaq'                                     AS boerse,
        'geladener Börsenkalender'                        AS quelle,
        formatDateTime(min(date), '%d.%m.%Y')             AS erster_termin,
        formatDateTime(max(date), '%d.%m.%Y')             AS letzter_termin,
        countDistinctIf(date, status = 'closed')          AS ganztags_geschlossen,
        countDistinctIf(date, status = 'early-close')     AS verkuerzte_tage
    FROM global_markets.stocks_market_holidays
    WHERE date >= today()
      AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
    UNION ALL
    SELECT
        'Xetra'                                           AS boerse,
        'hinterlegte Liste 2026 und 2027'                 AS quelle,
        formatDateTime(min(d), '%d.%m.%Y')                AS erster_termin,
        formatDateTime(max(d), '%d.%m.%Y')                AS letzter_termin,
        countIf(toDayOfWeek(d) BETWEEN 1 AND 5)           AS ganztags_geschlossen,
        toUInt64(0)                                       AS verkuerzte_tage
    FROM
    (
        SELECT 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()
)
ORDER BY boerse

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