closures_bj

Name: closures_bj
Creator: Strasmore
Published: 2026-09-23
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-09-23, from us-stock-market-hours-beijing-time.

as of 2026-09-23 series 12×7read in context →

closures_bj — 12 rows by 7 columns, computed 2026-09-23 from US exchange, SIP and OPRA data.
holiday_date	date_label	weekday_cn	holiday	day_status	beijing_close	days_away
2026-11-26	11月26日	周四	Thanksgiving	closed		64
2026-11-27	11月27日	周五	Thanksgiving	early-close	次日 02:00	65
2026-12-24	12月24日	周四	Christmas	early-close	次日 02:00	92
2026-12-25	12月25日	周五	Christmas	closed		93
2027-01-01	1月1日	周五	New Years Day	closed		100
2027-01-18	1月18日	周一	Martin Luther King, Jr. Day	closed		117
2027-02-15	2月15日	周一	Washington's Birthday	closed		145
2027-03-26	3月26日	周五	Good Friday	closed		184
2027-05-31	5月31日	周一	Memorial Day	closed		250
2027-06-18	6月18日	周五	Juneteenth	closed		268
2027-07-05	7月5日	周一	Independence Day	closed		285
2027-09-06	9月6日	周一	Labor Day	closed		348

Rows × columns: 12 × 7
Period covered: 2026-11-26 to 2027-09-06
Computed: 2026-09-23
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 closures_bj, derived from the stored result.
Column	Type	Range	Notes
`holiday_date`	date	2026-11-26 to 2027-09-06
`date_label`	text	12 distinct values (11月26日, 11月27日, 12月24日…)
`weekday_cn`	text	3 distinct values (周一, 周五, 周四)
`holiday`	text	10 distinct values (Christmas, Good Friday, Independence Day…)
`day_status`	text	2 distinct values (closed, early-close)
`beijing_close`	text	1 distinct value (次日 02:00)	2 of 12 rows populated
`days_away`	number	64 to 348

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-09-23, 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(toMonth(date)), '月', toString(toDayOfMonth(date)), '日')          AS date_label,
    arrayElement(['周一', '周二', '周三', '周四', '周五', '周六', '周日'], toDayOfWeek(date)) AS weekday_cn,
    any(name)                                                                         AS holiday,
    any(status)                                                                       AS day_status,
    any(if(status = 'early-close',
           concat('次日 ', formatDateTime(toTimeZone(close, 'Asia/Shanghai'), '%H:%i')),
           ''))                                                                       AS beijing_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