3,256 answered market questions

Upcoming US stock market holidays and early closesseries · 2026-10-08 · 12×6 Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-10-08 · 4×3 Regular trading sessions over the trailing yearscalar · 2026-10-08 · 1×3251 The closure calendar ahead, at a glancescalar · 2026-10-08 · 1×610 This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar)table · 2026-10-08 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-10-08 · 10×6 Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-10-08 · 12×6 Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-10-08 · 5×4 Market status computed at this page's refresh: weekday check, holiday check, and the ET clockscalar · 2026-10-08 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-10-08 · 1×6211 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-10-08 · 2×2 AAPL quoted spread and top-of-book size by hour, 16 September 2026ranking · 2026-10-05 · 16×4 Upcoming windows where Israel is not seven hours ahead of New Yorkseries · 2026-10-05 · 3×7 This week's US sessions mapped onto Israeli weekdays and clock timestable · 2026-10-05 · 5×5 US session boundaries in New York, UTC and Israel timeseries · 2026-10-05 · 4×7 UTC offsets and the Israel to New York gap, one Wednesday per week aheadseries · 2026-10-05 · 57×5 Extended-hours sale conditions defined on the taperanking · 2026-10-04 · 3×3 SPY daily bar volume vs. the regular-session slice (trailing month)series · 2026-10-04 · 19×5 Where SPY volume prints today, by ET clock hour (trailing month)ranking · 2026-10-04 · 16×4 Share of volume printed outside 9:30 to 4:00 ET, seven household names (trailing month)ranking · 2026-10-04 · 7×4 Upcoming US market closures, with early-close times in GSTseries · 2026-10-04 · 12×6 Share of September 2026 volume by US session windowranking · 2026-10-04 · 5×4 SPY volume by clock hour, New York and Dubai (1 to 25 September 2026)ranking · 2026-10-04 · 16×4 The US trading day on a UAE clock, across a US time changetable · 2026-10-04 · 10×7 Sydney open and close of the first US session each weekseries · 2026-10-04 · 57×5 The three Sydney opening times, counted from a year of SPY sessionsranking · 2026-10-04 · 3×4 Upcoming US market closures, in Sydney date and timeseries · 2026-10-04 · 12×6 Twelve months of dividends per share, gross and after 30% US withholdingranking · 2026-10-04 · 6×3 Upcoming US closures, with the early-close finish in Singapore timeseries · 2026-10-04 · 12×6 SPY volume by Singapore half hour: US winter month vs US summer monthseries · 2026-10-04 · 34×3 Every US clock change since 2022, detected from the opening printseries · 2026-10-04 · 9×5 The regular session, half hour by half hour, on both clocksseries · 2026-10-04 · 13×3 Sessions grouped by the local time the open landedranking · 2026-10-04 · 2×3 The 9:30 a.m. Eastern open, read on three clocks, by monthseries · 2026-10-04 · 14×6 Upcoming market closures, with early-close times in Mountain Timeseries · 2026-10-04 · 12×8 Upcoming US market closures and half days, in German timeseries · 2026-10-04 · 12×8 US session milestones in ET, UTC and German local timetable · 2026-10-04 · 5×7 The German clock time of the US open, week by weekseries · 2026-10-04 · 57×4 US sessions each year that land an hour earlier in Germanytable · 2026-10-04 · 5×6 SPY volume and one-minute range by 30-minute bucketseries · 2026-10-04 · 16×4 Upcoming US stock market holidays and early closes, from the exchange calendarseries · 2026-10-04 · 12×6 Trading sessions over the trailing year, counted from the SPY tapescalar · 2026-10-04 · 1×7254 A full trading day on the SPY tape, split by session window (recent full-length session)scalar · 2026-10-04 · 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-10-04 · 2×6 The most recent early-close session on the SPY tape, split by session windowscalar · 2026-10-04 · 1×13210 SPY volume by half hour on the early-close session, premarket through the shortened after-hours (ET clock)table · 2026-10-04 · 26×2 SPY volume by half hour, premarket through after-hours (same session, ET clock)table · 2026-10-04 · 32×2 Cash-tape sessions by weekday over the trailing windowseries · 2026-10-04 · 5×4 S&P 500 cash-tape volume by Eastern clock hourranking · 2026-10-04 · 16×3 Average quoted spread by Eastern clock hour, Sep 16 2026ranking · 2026-10-04 · 16×3 Average cash-tape volume, minute by minute into the 4:00 p.m. ET closeseries · 2026-10-04 · 31×2 One-minute SPY bars per session, US Thanksgiving week 2025series · 2026-10-04 · 7×3 US market closures ahead that Tokyo trades throughseries · 2026-10-04 · 12×6 What the US tape did on 2026 Tokyo market holidaysseries · 2026-10-04 · 13×5 US sessions through the Golden Week 2026 Tokyo closureseries · 2026-10-04 · 10×4 Average SPY minute bars per calendar day, by weekdayseries · 2026-10-04 · 7×4 Upcoming US market closures and early closesseries · 2026-10-04 · 12×7 SPY minute bars by ET clock hour: a normal day, a holiday, a half dayranking · 2026-10-04 · 15×4 First and last SPY print, Thanksgiving 2025 week and the week afterseries · 2026-10-04 · 12×5 Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)table · 2026-10-04 · 3×5 The session envelope, read from SPY minute bars (last two weeks, ET)scalar · 2026-10-04 · 1×7240 Stock headlines by ET hour of publication (last 30 days, all days)ranking · 2026-10-04 · 24×3 AAPL median quoted spread: regular session vs extended hours (past week, full sessions)series · 2026-10-04 · 2×3 AAPL median shares per traded minute, and the share of minutes that traded at all (ET)series · 2026-10-04 · 32×3 US stock venue records that are not exchangestable · 2026-10-03 · 9×4 AAPL trade prints by ET clock hour, Tue Sep 15 2026ranking · 2026-10-03 · 16×3 AAPL median quoted spread by ET clock hour, Tue Sep 15 2026ranking · 2026-10-03 · 16×3 Share of one session's volume printed before 9 a.m. ETranking · 2026-10-03 · 6×3 SPY volume by New York hour, with the London clock beside itseries · 2026-10-01 · 16×4 AAPL median quoted spread by hour across one full extended dayseries · 2026-10-01 · 16×4 The London clock time of the 9:30am ET open, late October 2025series · 2026-10-01 · 16×4 The same 15 sessions, summarized: the close's floor, average, and peakscalar · 2026-09-28 · 1×417.7 SPY volume share of the final 30 minutes and final minute: last 15 sessions through July 10, 2026series · 2026-09-28 · 15×3 Month-end sessions vs all other sessions: SPY close concentration, January–June 2026scalar · 2026-09-28 · 1×76 The spread a fund buyer never pays: median quoted spread, July 10, 2026 regular sessionranking · 2026-09-28 · 3×3 How much of SPY's day trades at the very end: July 10, 2026 regular sessionscalar · 2026-09-28 · 1×324.6 The print NAV is struck from: AAPL's closing auction cross, July 10, 2026scalar · 2026-09-28 · 1×65.47 The eight widest prior-close to regular-open distances in AAPL, Sep 2023 to Sep 2026table · 2026-09-27 · 8×5 Where AAPL's share volume sits on the ET clock, July to August 2026ranking · 2026-09-27 · 16×3 AAPL quoted spread and top-of-book size by ET hour, September 15, 2026ranking · 2026-09-27 · 16×3 Average quoted spread, 4 a.m. hour vs noon hour, September 15, 2026ranking · 2026-09-27 · 5×3 Upcoming US market closures, with London's status on each daytable · 2026-09-26 · 12×7 US trading sessions on a London clocktable · 2026-09-26 · 4×5 The four-hour weeks of 2026 and 2027, when 9:30 a.m. New York is 13:30 Londontable · 2026-09-26 · 4×5 Every Friday of 2026 through July, shortest session firstseries · 2026-09-26 · 31×4 Every 2026 monthly options expiration dateseries · 2026-09-26 · 12×6 Was the April expiration Friday a trading day?ranking · 2026-09-26 · 11×4 AAPL contracts traded into each 2026 expiration date, H1series · 2026-09-26 · 68×4 US volume on five sessions when the TSX was closed and New York was openranking · 2026-08-19 · 5×4 Where US volume prints across the Eastern clock, July 2026series · 2026-08-19 · 16×3 How far Shopify's US price wanders after the 4 p.m. close, May to July 2026series · 2026-08-19 · 16×3 Share of late session option volume printed after 4:00 p.m. ET, July 15, 2026ranking · 2026-08-16 · 7×3 Last SPY and SPX option print, minutes past the 4:00 p.m. equity closeseries · 2026-08-16 · 12×4 Last SPY option print on each 1:00 p.m. ET early close since July 2024ranking · 2026-08-16 · 6×3 SPY and SPX option volume by the minute, 15:45 to 16:25 ETseries · 2026-08-16 · 41×3 London and Frankfurt distance from New York, session by session, March to April 2026series · 2026-08-04 · 29×6 The New York open on two clocks: month-end sessions, August 2024 to July 2026series · 2026-08-04 · 24×6 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×6 The US trading day converted into ten local clocks: static illustrative reference, July 2026table · 2026-07-31 · 10×6

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