Upcoming US market closures, in Sydney date and time
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-09-20, from US Stock Market Hours in Sydney Time.
| holiday_date | holiday | day_status | session_open_sydney | session_end_sydney | days_away |
|---|---|---|---|---|---|
| 2026-11-26 | Thanksgiving | closed | Fri 27 Nov 01:30 | Fri 27 Nov 08:00 | 67 |
| 2026-11-27 | Thanksgiving | early-close | Sat 28 Nov 01:30 | Sat 28 Nov 05:00 | 68 |
| 2026-12-24 | Christmas | early-close | Fri 25 Dec 01:30 | Fri 25 Dec 05:00 | 95 |
| 2026-12-25 | Christmas | closed | Sat 26 Dec 01:30 | Sat 26 Dec 08:00 | 96 |
| 2027-01-01 | New Years Day | closed | Sat 2 Jan 01:30 | Sat 2 Jan 08:00 | 103 |
| 2027-01-18 | Martin Luther King, Jr. Day | closed | Tue 19 Jan 01:30 | Tue 19 Jan 08:00 | 120 |
| 2027-02-15 | Washington's Birthday | closed | Tue 16 Feb 01:30 | Tue 16 Feb 08:00 | 148 |
| 2027-03-26 | Good Friday | closed | Sat 27 Mar 00:30 | Sat 27 Mar 07:00 | 187 |
| 2027-05-31 | Memorial Day | closed | Mon 31 May 23:30 | Tue 1 Jun 06:00 | 253 |
| 2027-06-18 | Juneteenth | closed | Fri 18 Jun 23:30 | Sat 19 Jun 06:00 | 271 |
| 2027-07-05 | Independence Day | closed | Mon 5 Jul 23:30 | Tue 6 Jul 06:00 | 288 |
| 2027-09-06 | Labor Day | closed | Mon 6 Sep 23:30 | Tue 7 Sep 06:00 | 351 |
- Rows × columns
- 12 × 6
- Period covered
- to
- 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 |
|---|---|---|---|
holiday_date |
date | 2026-11-26 to 2027-09-06 | |
holiday |
text | 10 distinct values (Christmas, Good Friday, Independence Day…) | |
day_status |
text | 2 distinct values (closed, early-close) | |
session_open_sydney |
text | 12 distinct values | |
session_end_sydney |
text | 12 distinct values | |
days_away |
number | 67 to 351 |
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.
SELECT
holiday_date,
holiday,
day_status,
concat(formatDateTime(open_syd, '%a '), toString(toDayOfMonth(open_syd)), formatDateTime(open_syd, ' %b %H:%i')) AS session_open_sydney,
concat(formatDateTime(end_syd, '%a '), toString(toDayOfMonth(end_syd)), formatDateTime(end_syd, ' %b %H:%i')) AS session_end_sydney,
days_away
FROM
(
SELECT
toString(date) AS holiday_date,
any(name) AS holiday,
any(status) AS day_status,
toTimeZone(toDateTime(concat(toString(date), ' 09:30:00'), 'America/New_York'), 'Australia/Sydney') AS open_syd,
toTimeZone(toDateTime(concat(toString(date), ' ', any(if(status = 'early-close', '13:00:00', '16:00:00'))), 'America/New_York'), 'Australia/Sydney') AS end_syd,
dateDiff('day', today(), date) AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
)
ORDER BY holiday_date