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

Does Canada Have After-Hours Trading?
Upcoming US market closures and early closesseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Where US after-hours volume lands in interlisted Canadian names, 15-minute bucketsseries · 2026-10-04 · 16×4Preview: a 16-point series, ending higher. Share of each name's US tape printed outside the regular sessionranking · 2026-10-04 · 13×3Preview: 13 ranked values, largest first. Interlisted US volume on five days the Toronto market sat closedseries · 2026-10-04 · 5×3Preview: a 5-point series, roughly flat.
TSX Trading Hours and Holidays vs NYSE
US volume on five sessions when the TSX was closed and New York was openranking · 2026-08-19 · 5×4Preview: 5 ranked values, smallest first. Where US volume prints across the Eastern clock, July 2026series · 2026-08-19 · 16×3Preview: a 16-point series, roughly flat. How far Shopify's US price wanders after the 4 p.m. close, May to July 2026series · 2026-08-19 · 16×3Preview: a 16-point series, ending lower.
Upcoming US market closures and early closes

Upcoming US market closures and early closes

most recentas of series 12×6read in context →
Upcoming US market closures and early closes — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
holiday_dateweekdayclosure_labelholidayday_statusdays_away
2026-11-26ThuNov 26Thanksgivingclosed53
2026-11-27FriNov 27Thanksgivingearly-close54
2026-12-24ThuDec 24Christmasearly-close81
2026-12-25FriDec 25Christmasclosed82
2027-01-01FriJan 1New Years Dayclosed89
2027-01-18MonJan 18Martin Luther King, Jr. Dayclosed106
2027-02-15MonFeb 15Washington's Birthdayclosed134
2027-03-26FriMar 26Good Fridayclosed173
2027-05-31MonMay 31Memorial Dayclosed239
2027-06-18FriJun 18Juneteenthclosed257
2027-07-05MonJul 5Independence Dayclosed274
2027-09-06MonSep 6Labor Dayclosed337
the exact SQL behind every number 
SELECT
    toString(date)                 AS holiday_date,
    formatDateTime(date, '%a')     AS weekday,
    formatDateTime(date, '%b %e')  AS closure_label,
    any(name)                      AS holiday,
    any(status)                    AS day_status,
    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 analysisDoes Canada Have After-Hours Trading?
Where US after-hours volume lands in interlisted Canadian names, 15-minute buckets series 16×4 → Interlisted US volume on five days the Toronto market sat closed series 5×3 → Share of each name's US tape printed outside the regular session ranking 13×3 → Share of monthly volume by New York clock time, AAPL and KO series 32×3 → See all 3,256 queries →
$