STRASMORE/EXPLORE 3,127 QUERIES

upcoming

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-06, from us-market-holidays-in-japan-time.

as of series 12×7read in context →
upcoming — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
holiday_datejp_weekdayholidayday_statusjst_closeus_date_labeldays_away
2026-11-26木Thanksgivingclosed2026年11月26日51
2026-11-27金Thanksgivingearly-close03:002026年11月27日52
2026-12-24木Christmasearly-close03:002026年12月24日79
2026-12-25金Christmasclosed2026年12月25日80
2027-01-01金New Years Dayclosed2027年1月1日87
2027-01-18月Martin Luther King, Jr. Dayclosed2027年1月18日104
2027-02-15月Washington's Birthdayclosed2027年2月15日132
2027-03-26金Good Fridayclosed2027年3月26日171
2027-05-31月Memorial Dayclosed2027年5月31日237
2027-06-18金Juneteenthclosed2027年6月18日255
2027-07-05月Independence Dayclosed2027年7月5日272
2027-09-06月Labor Dayclosed2027年9月6日335
Rows × columns
12 × 7
Period covered
to
Computed
Completeness
Some fields are partly empty — see the columns below
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for upcoming, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-11-26 to 2027-09-06
jp_weekday text 3 distinct values (月, 木, 金)
holiday text 10 distinct values (Christmas, Good Friday, Independence Day…)
day_status text 2 distinct values (closed, early-close)
jst_close text 1 distinct value (03:00) 2 of 12 rows populated
us_date_label text 12 distinct values (2026年11月26日, 2026年11月27日, 2026年12月24日…)
days_away number 51 to 335

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(date)                                 AS holiday_date,
    arrayElement(['月', '火', '水', '木', '金', '土', '日'], toDayOfWeek(date)) AS jp_weekday,
    any(name)                                      AS holiday,
    any(status)                                    AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Asia/Tokyo'), '%H:%i'),
           ''))                                    AS jst_close,
    concat(toString(toYear(date)), '年',
           toString(toMonth(date)), '月',
           toString(toDayOfMonth(date)), '日')     AS us_date_label,
    dateDiff('day', today(), date)                 AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
  AND upper(exchange) IN ('NYSE', 'NASDAQ')
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent