STRASMORE/EXPLORE 2,433 QUERIES

us_holidays_london

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-london-time.

as of table 12×7read in context →
us_holidays_london — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
holiday_dateweekdayholidaynew_yorklondon_exchangelondon_at_ny_closein_words
2026-11-26ThuThanksgivingclosedopenNovember 26, 2026
2026-11-27FriThanksgivingearly-closeopen18:00November 27, 2026
2026-12-24ThuChristmasearly-closeopen18:00December 24, 2026
2026-12-25FriChristmasclosedclosedDecember 25, 2026
2027-01-01FriNew Years DayclosedclosedJanuary 1, 2027
2027-01-18MonMartin Luther King, Jr. DayclosedopenJanuary 18, 2027
2027-02-15MonWashington's BirthdayclosedopenFebruary 15, 2027
2027-03-26FriGood FridayclosedclosedMarch 26, 2027
2027-05-31MonMemorial Dayclosedusually closedMay 31, 2027
2027-06-18FriJuneteenthclosedopenJune 18, 2027
2027-07-05MonIndependence DayclosedopenJuly 5, 2027
2027-09-06MonLabor DayclosedopenSeptember 6, 2027
Rows × columns
12 × 7
Period covered
to
Computed
Completeness
Some fields are partly empty — see the columns below
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_holidays_london, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-11-26 to 2027-09-06
weekday text 3 distinct values (Fri, Mon, Thu)
holiday text 10 distinct values (Christmas, Good Friday, Independence Day…)
new_york text 2 distinct values (closed, early-close)
london_exchange text 3 distinct values (closed, open, usually closed)
london_at_ny_close text 1 distinct value (18:00) 2 of 12 rows populated
in_words text 12 distinct values

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
    toString(date)                                   AS holiday_date,
    formatDateTime(date, '%a')                       AS weekday,
    any(name)                                        AS holiday,
    any(status)                                      AS new_york,
    any(multiIf(
        status = 'early-close',      'open',
        name ILIKE '%new year%',     'closed',
        name ILIKE '%good friday%',  'closed',
        name ILIKE '%christmas%',    'closed',
        name ILIKE '%memorial%',     'usually closed',
                                     'open'))        AS london_exchange,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Europe/London'), '%H:%i'),
           ''))                                      AS london_at_ny_close,
    concat(monthName(date), ' ', toString(toDayOfMonth(date)), ', ', toString(toYear(date))) AS in_words
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter
More from this analysisus-stock-market-hours-london-time
sessions_london table 4×5 → dst_windows table 4×5 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 → See all 2,433 queries →