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
Can You Cancel a Mutual Fund Order? 4 pm Cutoff
Upcoming sessions where the standard 4 p.m. cutoff does not applyseries · 2026-11-07 · 12×6Preview: a 12-point series, ending higher.
Upcoming sessions where the standard 4 p.m. cutoff does not apply

Upcoming sessions where the standard 4 p.m. cutoff does not apply

most recentas of series 12×6read in context →
Upcoming sessions where the standard 4 p.m. cutoff does not apply — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
holiday_dateweekdayholidayday_statuscutoff_etdays_away
2026-11-26ThuThanksgivingclosedno NAV struck19
2026-11-27FriThanksgivingearly-close01:00 PM20
2026-12-24ThuChristmasearly-close01:00 PM47
2026-12-25FriChristmasclosedno NAV struck48
2027-01-01FriNew Years Dayclosedno NAV struck55
2027-01-18MonMartin Luther King, Jr. Dayclosedno NAV struck72
2027-02-15MonWashington's Birthdayclosedno NAV struck100
2027-03-26FriGood Fridayclosedno NAV struck139
2027-05-31MonMemorial Dayclosedno NAV struck205
2027-06-18FriJuneteenthclosedno NAV struck223
2027-07-05MonIndependence Dayclosedno NAV struck240
2027-09-06MonLabor Dayclosedno NAV struck303
the exact SQL behind every number 
SELECT
    toString(date)                       AS holiday_date,
    formatDateTime(date, '%a')           AS weekday,
    any(name)                            AS holiday,
    any(status)                          AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'America/New_York'), '%I:%i %p'),
           'no NAV struck'))             AS cutoff_et,
    dateDiff('day', today(), date)       AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
Related queries
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 → How far SPY trades from its own open and close, by time of day series 13×3 → Share of SPY's session volume by half hour, June 2026 average series 13×2 → See all 3,293 queries →
$