STRASMORE/EXPLORE 2,985 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,985 answered market questions

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

Mutual Fund Order Cutoff Times by Broker
Upcoming US market closures and early closesseries · 2026-09-26 · 12×7Preview: a 12-point series, ending higher. Full sessions versus shortened sessions over the trailing yearranking · 2026-09-26 · 2×2Preview: 2 ranked values, largest first. Shortened sessions on the SPY tape since January 2024series · 2026-09-26 · 6×5Preview: a 6-point series, roughly flat.
Ex-Dividend Date: Open Orders and Premarket
KO premarket on its latest ex-dividend morning, both references side by sideseries · 2026-09-26 · 11×4Preview: a 11-point series, ending lower. KO's ex-date opening print, measured against both referencesseries · 2026-09-26 · 14×3Preview: a 14-point series, ending lower. KO: every quarterly ex-dividend adjustment over the trailing three yearsseries · 2026-09-26 · 14×3Preview: a 14-point series, ending lower. Upcoming ex-dividend dates and the size of the open-order reductionranking · 2026-09-26 · 3×4Preview: 3 ranked values, largest first.
Upcoming US market closures and early closes

Upcoming US market closures and early closes

most recentas of series 12×7read in context →
Upcoming US market closures and early closes — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
closure_dateweekdaydate_labelclosure_nameday_statusearly_close_etdays_away
2026-11-26ThuNovember 26Thanksgivingclosed61
2026-11-27FriNovember 27Thanksgivingearly-close01:00 PM62
2026-12-24ThuDecember 24Christmasearly-close01:00 PM89
2026-12-25FriDecember 25Christmasclosed90
2027-01-01FriJanuary 1New Years Dayclosed97
2027-01-18MonJanuary 18Martin Luther King, Jr. Dayclosed114
2027-02-15MonFebruary 15Washington's Birthdayclosed142
2027-03-26FriMarch 26Good Fridayclosed181
2027-05-31MonMay 31Memorial Dayclosed247
2027-06-18FriJune 18Juneteenthclosed265
2027-07-05MonJuly 5Independence Dayclosed282
2027-09-06MonSeptember 6Labor Dayclosed345
the exact SQL behind every number 
SELECT
    toString(date)                                             AS closure_date,
    formatDateTime(date, '%a')                                 AS weekday,
    concat(monthName(date), ' ', toString(toDayOfMonth(date))) AS date_label,
    any(name)                                                  AS closure_name,
    any(status)                                                AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'America/New_York'), '%I:%i %p'),
           ''))                                                AS early_close_et,
    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 analysisMutual Fund Order Cutoff Times by Broker
Shortened sessions on the SPY tape since January 2024 series 6×5 → Full sessions versus shortened sessions over the trailing year ranking 2×2 → One session's price path, SPY every 15 minutes on June 17, 2026 series 27×2 → Share of SPY's session volume by half hour, June 2026 average series 13×2 → See all 2,985 queries →
$