us_holidays_msk

Name: us_holidays_msk
Creator: Strasmore
Published: 2026-10-05
License: https://www.strasmore.com/terms/

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-05, from us-stock-market-hours-moscow-time.

as of 2026-10-05 series 12×7read in context →

us_holidays_msk — 12 rows by 7 columns, computed 2026-10-05 from US exchange, SIP and OPRA data.
holiday_date	date_ru	weekday_ru	holiday	day_status	msk_close	days_away
2026-11-26	26 ноября	чт	Thanksgiving	closed		52
2026-11-27	27 ноября	пт	Thanksgiving	early-close	21:00	53
2026-12-24	24 декабря	чт	Christmas	early-close	21:00	80
2026-12-25	25 декабря	пт	Christmas	closed		81
2027-01-01	1 января	пт	New Years Day	closed		88
2027-01-18	18 января	пн	Martin Luther King, Jr. Day	closed		105
2027-02-15	15 февраля	пн	Washington's Birthday	closed		133
2027-03-26	26 марта	пт	Good Friday	closed		172
2027-05-31	31 мая	пн	Memorial Day	closed		238
2027-06-18	18 июня	пт	Juneteenth	closed		256
2027-07-05	5 июля	пн	Independence Day	closed		273
2027-09-06	6 сентября	пн	Labor Day	closed		336

Rows × columns: 12 × 7
Period covered: 2026-11-26 to 2027-09-06
Computed: 2026-10-05
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 us_holidays_msk, derived from the stored result.
Column	Type	Range	Notes
`holiday_date`	date	2026-11-26 to 2027-09-06
`date_ru`	text	12 distinct values (1 января, 15 февраля, 18 июня…)
`weekday_ru`	text	3 distinct values (пн, пт, чт)
`holiday`	text	10 distinct values (Christmas, Good Friday, Independence Day…)
`day_status`	text	2 distinct values (closed, early-close)
`msk_close`	text	1 distinct value (21:00)	2 of 12 rows populated
`days_away`	number	52 to 336

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 2026-10-05, 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,
    concat(toString(toDayOfMonth(date)), ' ',
           arrayElement(['января','февраля','марта','апреля','мая','июня','июля','августа','сентября','октября','ноября','декабря'], toMonth(date))) AS date_ru,
    arrayElement(['пн','вт','ср','чт','пт','сб','вс'], toDayOfWeek(date))        AS weekday_ru,
    any(name)                                                                    AS holiday,
    any(status)                                                                  AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Europe/Moscow'), '%H:%i'),
           ''))                                                                  AS msk_close,
    dateDiff('day', today(), date)                                               AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date

SQL to run

⌘/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