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

Mutual Fund Order Cutoff Times by Broker
Upcoming US market closures and early closesseries · 2026-10-04 · 12×7Preview: a 12-point series, ending higher. Full sessions versus shortened sessions over the trailing yearranking · 2026-10-04 · 2×2Preview: 2 ranked values, largest first. Shortened sessions on the SPY tape since January 2024series · 2026-10-04 · 6×5Preview: a 6-point series, roughly flat.
Mutual Fund Forward Pricing Rule Explained
Upcoming exchange closures, the days a fund NAV is skipped or shortenedseries · 2026-10-04 · 12×5Preview: a 12-point series, ending higher. Shares a $10,000 order buys at the screen NAV versus the struck NAV, ten sharpest sessionsranking · 2026-10-04 · 10×4Preview: 10 ranked values, largest first. How far one closing value lands from the last (SPY daily closes, 2023 onward)ranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Average distance from each ET clock mark to the closing print (SPY, trailing months)series · 2026-10-04 · 13×3Preview: a 13-point series, roughly flat.
Can You Cancel a Mutual Fund Order? 4 pm Cutoff
Upcoming sessions where the standard 4 p.m. cutoff does not applyseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher.
Best Time of Day to Sell a Mutual Fund
Overnight gap versus the session that follows, complete yearsranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. How far SPY trades from its own open and close, by time of dayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Average one-day move across six widely held funds, since 2021ranking · 2026-10-04 · 6×2Preview: 6 ranked values, smallest first. How big a one-day move usually is, sessions since 2016ranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first.
How Mutual Fund NAV Is Calculated: Example
Share of SPY's session volume by half hour, June 2026 averageseries · 2026-09-28 · 13×2Preview: a 13-point series, ending higher. Average move from the 11:30 a.m. ET European close to the 4:00 p.m. close, Q2 2026ranking · 2026-09-28 · 5×3Preview: 5 ranked values, largest first. One session's price path, SPY every 15 minutes on June 17, 2026series · 2026-09-28 · 27×2Preview: a 16-point series, ending lower. Distance from the 10:00 a.m. ET price to the close, SPY, by monthseries · 2026-09-28 · 12×4Preview: a 12-point series, roughly flat.
When Do Index Funds Trade? ETFs vs Mutual Funds
Quoted spread on large index ETFs, five-minute slice of September 15, 2026ranking · 2026-09-26 · 6×3Preview: 6 ranked values, smallest first. Two index ETFs through one session, September 15, 2026 (percent change from the day's first print)series · 2026-09-26 · 32×3Preview: a 16-point series, roughly flat. How wide each session ran from high to low, as a percent of the closeseries · 2026-09-26 · 31×3Preview: a 16-point series, roughly flat. How many separate trades an index ETF prints per session (VOO)series · 2026-09-26 · 16×3Preview: a 16-point series, ending higher.
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 26Thanksgivingclosed53
2026-11-27FriNovember 27Thanksgivingearly-close01:00 PM54
2026-12-24ThuDecember 24Christmasearly-close01:00 PM81
2026-12-25FriDecember 25Christmasclosed82
2027-01-01FriJanuary 1New Years Dayclosed89
2027-01-18MonJanuary 18Martin Luther King, Jr. Dayclosed106
2027-02-15MonFebruary 15Washington's Birthdayclosed134
2027-03-26FriMarch 26Good Fridayclosed173
2027-05-31MonMay 31Memorial Dayclosed239
2027-06-18FriJune 18Juneteenthclosed257
2027-07-05MonJuly 5Independence Dayclosed274
2027-09-06MonSeptember 6Labor Dayclosed337
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 → Average distance from each ET clock mark to the closing print (SPY, trailing months) series 13×3 → See all 3,256 queries →
$