orders — 4 answered market questions

Upcoming exchange closures, the days a fund NAV is skipped or shortened

most recentas of 2026-11-07 series 12×5read in context →

Upcoming exchange closures, the days a fund NAV is skipped or shortened — 12 rows by 5 columns, computed 2026-11-07 from US exchange, SIP and OPRA data.
holiday_date	day_label	holiday	day_status	days_away
2026-11-26	Thu Nov 26	Thanksgiving	closed	19
2026-11-27	Fri Nov 27	Thanksgiving	early-close	20
2026-12-24	Thu Dec 24	Christmas	early-close	47
2026-12-25	Fri Dec 25	Christmas	closed	48
2027-01-01	Fri Jan 1	New Years Day	closed	55
2027-01-18	Mon Jan 18	Martin Luther King, Jr. Day	closed	72
2027-02-15	Mon Feb 15	Washington's Birthday	closed	100
2027-03-26	Fri Mar 26	Good Friday	closed	139
2027-05-31	Mon May 31	Memorial Day	closed	205
2027-06-18	Fri Jun 18	Juneteenth	closed	223
2027-07-05	Mon Jul 5	Independence Day	closed	240
2027-09-06	Mon Sep 6	Labor Day	closed	303

the exact SQL behind every number

SELECT
    toString(date)                       AS holiday_date,
    formatDateTime(date, '%a %b %e')     AS day_label,
    any(name)                            AS holiday,
    any(status)                          AS day_status,
    dateDiff('day', today(), date)       AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
LIMIT 12

More from this analysisMutual Fund Forward Pricing Rule Explained

Average distance from each ET clock mark to the closing print (SPY, trailing months) series 13×3 → Shares a $10,000 order buys at the screen NAV versus the struck NAV, ten sharpest sessions ranking 10×4 → How far one closing value lands from the last (SPY daily closes, 2023 onward) ranking 5×3 → One session's price path, SPY every 15 minutes on June 17, 2026 series 27×2 → See all 3,293 queries →