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

2,170 answered market questions

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

Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-08-25 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-08-25 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-08-25 · 1×3252 The closure calendar ahead, at a glancescalar · 2026-08-25 · 1×610
Is the Stock Market Open Today?
This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar)table · 2026-08-25 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-08-25 · 11×6Preview: a 11-point series, ending lower. Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-08-25 · 12×6Preview: a 12-point series, ending higher. Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-08-25 · 5×4Preview: a 5-point series, roughly flat. Market status computed at this page's refresh: weekday check, holiday check, and the ET clockscalar · 2026-08-25 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-08-25 · 1×6211 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-08-25 · 2×2
Stock Market Hours: Open 9:30, Close 4:00 ET
Upcoming US stock market holidays and early closes, from the exchange calendarseries · 2026-08-22 · 12×6Preview: a 12-point series, ending higher. Trading sessions over the trailing year, counted from the SPY tapescalar · 2026-08-22 · 1×7253 A full trading day on the SPY tape, split by session window (recent full-length session)scalar · 2026-08-22 · 1×15390 Single-name vs. ETF options at the 4:00 p.m. bell: AAPL and SPY options trades around the close (same session)series · 2026-08-22 · 2×6Preview: a 2-point series, ending higher. The most recent early-close session on the SPY tape, split by session windowscalar · 2026-08-22 · 1×13210 SPY volume by half hour on the early-close session, premarket through the shortened after-hours (ET clock)ranking · 2026-08-22 · 21×2Preview: 16 ranked values, smallest first. SPY volume by half hour, premarket through after-hours (same session, ET clock)table · 2026-08-22 · 32×2
Options Expiration Calendar 2026: All 12 Dates
Every Friday of 2026 through July, shortest session firstseries · 2026-08-22 · 31×4Preview: a 16-point series, ending higher. Every 2026 monthly options expiration dateseries · 2026-08-22 · 12×6Preview: a 12-point series, ending higher. Was the April expiration Friday a trading day?ranking · 2026-08-22 · 11×4Preview: 11 ranked values, largest first. AAPL contracts traded into each 2026 expiration date, H1series · 2026-08-22 · 68×4Preview: a 16-point series, ending lower.
Premarket and After-Hours Trading Hours (ET)
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)table · 2026-08-22 · 3×5 The session envelope, read from SPY minute bars (last two weeks, ET)scalar · 2026-08-22 · 1×7240 Stock headlines by ET hour of publication (last 30 days, all days)ranking · 2026-08-22 · 24×3Preview: 16 ranked values, smallest first. AAPL median quoted spread: regular session vs extended hours (past week, full sessions)series · 2026-08-22 · 2×3Preview: a 2-point series, ending lower. AAPL median shares per traded minute, and the share of minutes that traded at all (ET)series · 2026-08-22 · 32×3Preview: a 16-point series, ending lower.
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.
What Time Do Options Stop Trading?
Share of late session option volume printed after 4:00 p.m. ET, July 15, 2026ranking · 2026-08-16 · 7×3Preview: 7 ranked values, largest first. Last SPY and SPX option print, minutes past the 4:00 p.m. equity closeseries · 2026-08-16 · 12×4Preview: a 12-point series, roughly flat. Last SPY option print on each 1:00 p.m. ET early close since July 2024ranking · 2026-08-16 · 6×3Preview: 6 ranked values, smallest first. SPY and SPX option volume by the minute, 15:45 to 16:25 ETseries · 2026-08-16 · 41×3Preview: a 16-point series, ending lower.
US Market Hours and Daylight Saving Time
London and Frankfurt distance from New York, session by session, March to April 2026series · 2026-08-04 · 29×6Preview: a 16-point series, ending lower. The New York open on two clocks: month-end sessions, August 2024 to July 2026series · 2026-08-04 · 24×6Preview: a 16-point series, ending higher. The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026table · 2026-08-04 · 8×5 London and Tokyo distance from New York, session by session, October to November 2025series · 2026-08-04 · 25×6Preview: a 16-point series, roughly flat.
US Stock Market Hours Around the World
The US trading day converted into ten local clocks: static illustrative reference, July 2026table · 2026-07-31 · 10×6 Local time of the 9:30 a.m. New York open, January against July: static illustrative reference for 2026ranking · 2026-07-31 · 6×4Preview: 6 ranked values, smallest first.
Trading US 0DTE Options From Japan
Same-day options volume by Japan Standard Time hour: all US-listed options, Friday July 10, 2026ranking · 2026-07-31 · 7×4Preview: 7 ranked values, largest first. Median bid-ask spread on SPY same-day contracts quoted $1-$10, by Japan Standard Time hour: July 10, 2026ranking · 2026-07-31 · 7×4Preview: 7 ranked values, smallest first. Japanese local time of each US session boundary, January against July: static illustrative reference for 2026series · 2026-07-31 · 4×4Preview: a 4-point series, roughly flat. The US trading day converted into Japan Standard Time: static illustrative reference, July 2026series · 2026-07-31 · 6×5Preview: a 6-point series, ending higher.
When Do Mutual Funds Trade? NAV Pricing at 4 pm
The same 15 sessions, summarized: the close's floor, average, and peakscalar · 2026-07-26 · 1×416.3 SPY volume share of the final 30 minutes and final minute: last 15 sessions through July 10, 2026series · 2026-07-26 · 15×3Preview: a 15-point series, ending lower. Month-end sessions vs all other sessions: SPY close concentration, January–June 2026scalar · 2026-07-26 · 1×76 The spread a fund buyer never pays: median quoted spread, July 10, 2026 regular sessionranking · 2026-07-26 · 3×3Preview: 3 ranked values, smallest first. How much of SPY's day trades at the very end: July 10, 2026 regular sessionscalar · 2026-07-26 · 1×322.5 The print NAV is struck from: AAPL's closing auction cross, July 10, 2026scalar · 2026-07-26 · 1×65.47
Upcoming US stock market holidays and early closes

Upcoming US stock market holidays and early closes

most recentas of series 12×6read in context →
Upcoming US stock market holidays and early closes — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
holiday_dateweekdayholidayday_statusearly_close_etdays_away
2026-09-07MonLabor Dayclosed13
2026-11-26ThuThanksgivingclosed93
2026-11-27FriThanksgivingearly-close01:00 PM94
2026-12-24ThuChristmasearly-close01:00 PM121
2026-12-25FriChristmasclosed122
2027-01-01FriNew Years Dayclosed129
2027-01-18MonMartin Luther King, Jr. Dayclosed146
2027-02-15MonWashington's Birthdayclosed174
2027-03-26FriGood Fridayclosed213
2027-05-31MonMemorial Dayclosed279
2027-06-18FriJuneteenthclosed297
2027-07-05MonIndependence Dayclosed314
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'),
           ''))                          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 analysisStock Market Holidays 2026–2027: NYSE & Nasdaq
Recently-passed weekday closures, recovered from the SPY tape series 4×3 → Regular trading sessions over the trailing year scalar 1×3 → The closure calendar ahead, at a glance scalar 1×6 → Every upcoming NYSE closure and early close on the calendar feed, with a countdown series 12×6 → See all 2,170 queries →
$