STRASMORE/EXPLORE 2,830 QUERIES

closures

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-30, from us-premarket-and-after-hours-philippine-time.

as of series 12×5read in context →
closures — 12 rows by 5 columns, computed from US exchange, SIP and OPRA data.
holiday_datedate_labelholidayday_statusdays_away
2026-11-2626 Nob 2026Thanksgivingclosed57
2026-11-2727 Nob 2026Thanksgivingearly-close58
2026-12-2424 Dis 2026Christmasearly-close85
2026-12-2525 Dis 2026Christmasclosed86
2027-01-011 Ene 2027New Years Dayclosed93
2027-01-1818 Ene 2027Martin Luther King, Jr. Dayclosed110
2027-02-1515 Peb 2027Washington's Birthdayclosed138
2027-03-2626 Mar 2027Good Fridayclosed177
2027-05-3131 May 2027Memorial Dayclosed243
2027-06-1818 Hun 2027Juneteenthclosed261
2027-07-055 Hul 2027Independence Dayclosed278
2027-09-066 Set 2027Labor Dayclosed341
Rows × columns
12 × 5
Period covered
to
Computed
Completeness
No missing values
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, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-11-26 to 2027-09-06
date_label text 12 distinct values (1 Ene 2027, 15 Peb 2027, 18 Ene 2027…)
holiday text 10 distinct values (Christmas, Good Friday, Independence Day…)
day_status text 2 distinct values (closed, early-close)
days_away number 57 to 341

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,
    concat(toString(toDayOfMonth(date)), ' ',
           arrayElement(['Ene', 'Peb', 'Mar', 'Abr', 'May', 'Hun', 'Hul', 'Ago', 'Set', 'Okt', 'Nob', 'Dis'], toMonth(date)),
           ' ', toString(toYear(date)))              AS date_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
⌘/Ctrl + Enter

Gamitin ang datos na ito sa iyong AI assistant

Bubukas nang handang mag-query, kasama ang datos ng pahinang ito. Libre, walang account.

Claude ChatGPT Gemini Muse Sarili mong agent