us_fruehschluss
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.
| datum | wochentag | anlass | schluss_new_york | schluss_berlin | handelsstunden | xetra |
|---|---|---|---|---|---|---|
| 27.11.2026 | Fr | Thanksgiving | 13:00 | 19:00 | 3.5 | offen |
| 24.12.2026 | Do | Christmas | 13:00 | 19:00 | 3.5 | geschlossen |
- Rows × columns
- 2 × 7
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
datum |
text | 2 distinct values (24.12.2026, 27.11.2026) | |
wochentag |
text | 2 distinct values (Do, Fr) | |
anlass |
text | 2 distinct values (Christmas, Thanksgiving) | |
schluss_new_york |
text | 1 distinct value (13:00) | |
schluss_berlin |
text | 1 distinct value (19:00) | |
handelsstunden |
number | every row is 3.5 | |
xetra |
text | 2 distinct values (geschlossen, offen) |
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
[
('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 anlass,
formatDateTime(toTimeZone(any(close), 'America/New_York'), '%H:%i') AS schluss_new_york,
formatDateTime(toTimeZone(any(close), 'Europe/Berlin'), '%H:%i') AS schluss_berlin,
round(dateDiff('minute', any(open), any(close)) / 60, 1) AS handelsstunden,
multiIf(date > xetra_liste_ende, 'nicht hinterlegt',
has(xetra_geschlossen, date), 'geschlossen',
'offen') AS xetra
FROM global_markets.stocks_market_holidays
WHERE date >= today()
AND status = 'early-close'
AND (exchange ILIKE '%nyse%' OR exchange ILIKE '%nasdaq%')
GROUP BY date
ORDER BY date
Arbeiten Sie mit diesen Daten in Ihrem KI-Assistenten
Öffnet sich abfragebereit, mit den Daten dieser Seite. Kostenlos, ohne Konto.