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

3,256 answered market questions

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

US Stock Market Hours in UAE Time (GST)
Upcoming US market closures, with early-close times in GSTseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Share of September 2026 volume by US session windowranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. SPY volume by clock hour, New York and Dubai (1 to 25 September 2026)ranking · 2026-10-04 · 16×4Preview: 16 ranked values, largest first. The US trading day on a UAE clock, across a US time changetable · 2026-10-04 · 10×7
US Stock Market Hours in Sydney Time
Sydney open and close of the first US session each weekseries · 2026-10-04 · 57×5Preview: a 16-point series, roughly flat. The three Sydney opening times, counted from a year of SPY sessionsranking · 2026-10-04 · 3×4Preview: 3 ranked values, smallest first. Upcoming US market closures, in Sydney date and timeseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher.
US Stock Market Hours in Singapore Time
Twelve months of dividends per share, gross and after 30% US withholdingranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. Upcoming US closures, with the early-close finish in Singapore timeseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. SPY volume by Singapore half hour: US winter month vs US summer monthseries · 2026-10-04 · 34×3Preview: a 16-point series, ending higher. Every US clock change since 2022, detected from the opening printseries · 2026-10-04 · 9×5Preview: a 9-point series, roughly flat.
US Stock Market Hours in Mountain Time
The regular session, half hour by half hour, on both clocksseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Sessions grouped by the local time the open landedranking · 2026-10-04 · 2×3Preview: 2 ranked values, largest first. The 9:30 a.m. Eastern open, read on three clocks, by monthseries · 2026-10-04 · 14×6Preview: a 14-point series, roughly flat. Upcoming market closures, with early-close times in Mountain Timeseries · 2026-10-04 · 12×8Preview: a 12-point series, ending higher.
US Market Hours in German Time (CET/CEST)
Upcoming US market closures and half days, in German timeseries · 2026-10-04 · 12×8Preview: a 12-point series, ending higher. US session milestones in ET, UTC and German local timetable · 2026-10-04 · 5×7 The German clock time of the US open, week by weekseries · 2026-10-04 · 57×4Preview: a 16-point series, roughly flat. US sessions each year that land an hour earlier in Germanytable · 2026-10-04 · 5×6 SPY volume and one-minute range by 30-minute bucketseries · 2026-10-04 · 16×4Preview: a 16-point series, ending lower.
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
US Market Hours and Daylight Saving Time
London and Frankfurt distance from New York, session by session, March to April 2026series · 2026-08-04 · 29×6Preview: a 16-point series, ending lower. The New York open on two clocks: month-end sessions, August 2024 to July 2026series · 2026-08-04 · 24×6Preview: a 16-point series, ending higher. The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026table · 2026-08-04 · 8×5 London and Tokyo distance from New York, session by session, October to November 2025series · 2026-08-04 · 25×6Preview: a 16-point series, roughly flat.
Upcoming US market closures, with early-close times in GST

Upcoming US market closures, with early-close times in GST

most recentas of series 12×6read in context →
Upcoming US market closures, with early-close times in GST — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
closure_dateclosure_labelholidayday_statusearly_close_gstdays_away
2026-11-26Thu, November 26Thanksgivingclosed53
2026-11-27Fri, November 27Thanksgivingearly-close22:0054
2026-12-24Thu, December 24Christmasearly-close22:0081
2026-12-25Fri, December 25Christmasclosed82
2027-01-01Fri, January 1New Years Dayclosed89
2027-01-18Mon, January 18Martin Luther King, Jr. Dayclosed106
2027-02-15Mon, February 15Washington's Birthdayclosed134
2027-03-26Fri, March 26Good Fridayclosed173
2027-05-31Mon, May 31Memorial Dayclosed239
2027-06-18Fri, June 18Juneteenthclosed257
2027-07-05Mon, July 5Independence Dayclosed274
2027-09-06Mon, September 6Labor Dayclosed337
the exact SQL behind every number 
SELECT
    toString(date)                                                                            AS closure_date,
    concat(formatDateTime(date, '%a, '), monthName(date), ' ', toString(toDayOfMonth(date)))  AS closure_label,
    any(name)                                                                                 AS holiday,
    any(status)                                                                               AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Asia/Dubai'), '%H:%i'),
           ''))                                                                               AS early_close_gst,
    dateDiff('day', today(), date)                                                            AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
More from this analysisUS Stock Market Hours in UAE Time (GST)
SPY volume by clock hour, New York and Dubai (1 to 25 September 2026) ranking 16×4 → The US trading day on a UAE clock, across a US time change table 10×7 → Share of September 2026 volume by US session window ranking 5×4 → UTC offsets and the Israel to New York gap, one Wednesday per week ahead series 57×5 → See all 3,256 queries →
$