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
Do Mutual Funds Trade on Market Holidays?
Scheduled early closes ahead, with the exchange close timeseries · 2026-11-07 · 2×4Preview: a 2-point series, ending higher. Upcoming US market closures and shortened sessionsseries · 2026-11-07 · 12×4Preview: a 12-point series, ending higher. Short regular sessions on the SPY tape since January 2024ranking · 2026-11-07 · 6×3Preview: 6 ranked values, largest first. 2026 sessions that reopened more than three calendar days laterseries · 2026-11-07 · 7×3Preview: a 7-point series, roughly flat.
Scheduled early closes ahead, with the exchange close time

Scheduled early closes ahead, with the exchange close time

most recentas of series 2×4read in context →
Scheduled early closes ahead, with the exchange close time — 2 rows by 4 columns, computed from US exchange, SIP and OPRA data.
early_close_labelholidaysession_ends_etdays_away
Fri Nov 27, 2026Thanksgiving01:00 PM20
Thu Dec 24, 2026Christmas01:00 PM47
the exact SQL behind every number 
SELECT
    concat(formatDateTime(date, '%a %b '), toString(toDayOfMonth(date)), ', ', toString(toYear(date))) AS early_close_label,
    any(name)                                                              AS holiday,
    any(formatDateTime(toTimeZone(close, 'America/New_York'), '%I:%i %p')) AS session_ends_et,
    dateDiff('day', today(), date)                                         AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
  AND status = 'early-close'
GROUP BY date
ORDER BY date
More from this analysisDo Mutual Funds Trade on Market Holidays?
Upcoming US market closures and shortened sessions series 12×4 → 2026 sessions that reopened more than three calendar days later series 7×3 → Short regular sessions on the SPY tape since January 2024 ranking 6×3 → Average SPY volume per minute over the final half hour of the session series 30×2 → See all 3,293 queries →
$