STRASMORE/EXPLORE 3,094 QUERIES

holidays_ict

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-vietnam-time.

as of series 12×7read in context →
holidays_ict — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
holiday_datedate_vnweekday_vnholidayday_statusclose_ictdays_away
2026-11-2626/11/2026Thứ NămThanksgivingNghỉ cả ngày52
2026-11-2727/11/2026Thứ SáuThanksgivingĐóng sớm01:0053
2026-12-2424/12/2026Thứ NămChristmasĐóng sớm01:0080
2026-12-2525/12/2026Thứ SáuChristmasNghỉ cả ngày81
2027-01-0101/01/2027Thứ SáuNew Years DayNghỉ cả ngày88
2027-01-1818/01/2027Thứ HaiMartin Luther King, Jr. DayNghỉ cả ngày105
2027-02-1515/02/2027Thứ HaiWashington's BirthdayNghỉ cả ngày133
2027-03-2626/03/2027Thứ SáuGood FridayNghỉ cả ngày172
2027-05-3131/05/2027Thứ HaiMemorial DayNghỉ cả ngày238
2027-06-1818/06/2027Thứ SáuJuneteenthNghỉ cả ngày256
2027-07-0505/07/2027Thứ HaiIndependence DayNghỉ cả ngày273
2027-09-0606/09/2027Thứ HaiLabor DayNghỉ cả ngày336
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 holidays_ict, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-11-26 to 2027-09-06
date_vn text 12 distinct values (01/01/2027, 05/07/2027, 06/09/2027…)
weekday_vn text 3 distinct values (Thứ Hai, Thứ Năm, Thứ Sáu)
holiday text 10 distinct values (Christmas, Good Friday, Independence Day…)
day_status text 2 distinct values (Nghỉ cả ngày, Đóng sớm)
close_ict text 1 distinct value (01: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 , 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,
    formatDateTime(date, '%d/%m/%Y')                                  AS date_vn,
    arrayElement(['Thứ Hai', 'Thứ Ba', 'Thứ Tư', 'Thứ Năm',
                  'Thứ Sáu', 'Thứ Bảy', 'Chủ Nhật'],
                 toDayOfWeek(date))                                   AS weekday_vn,
    any(name)                                                         AS holiday,
    any(if(status = 'closed', 'Nghỉ cả ngày', 'Đóng sớm'))            AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Asia/Ho_Chi_Minh'), '%H:%i'),
           ''))                                                       AS close_ict,
    dateDiff('day', today(), date)                                    AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter

Làm việc với dữ liệu này trong trợ lý AI của bạn

Mở ra sẵn sàng truy vấn, với dữ liệu của trang này. Miễn phí, không cần tài khoản.

Claude ChatGPT Gemini Muse Agent của riêng bạn