STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
US Stock Market Hours in London Time (BST/GMT)
Upcoming US market closures, with London's status on each daytable · 2026-09-26 · 12×7 US trading sessions on a London clocktable · 2026-09-26 · 4×5 The four-hour weeks of 2026 and 2027, when 9:30 a.m. New York is 13:30 Londontable · 2026-09-26 · 4×5
Upcoming US market closures, with London's status on each day

Upcoming US market closures, with London's status on each day

most recentas of table 12×7read in context →
Upcoming US market closures, with London's status on each day — 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
the exact SQL behind every number 
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
More from this analysisUS Stock Market Hours in London Time (BST/GMT)
US trading sessions on a London clock table 4×5 → The four-hour weeks of 2026 and 2027, when 9:30 a.m. New York is 13:30 London table 4×5 → Sydney open and close of the first US session each week series 57×5 → Upcoming US market closures, in Sydney date and time series 12×6 → See all 3,293 queries →
$