STRASMORE/EXPLORE 3,256 QUERIES

calendario

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

as of table 12×6read in context →
calendario — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
fechadiafestivotipocierre_hora_espanoladias_restantes
26/11/2026juevesThanksgivingcierre total48
27/11/2026viernesThanksgivingcierre anticipado19:0049
24/12/2026juevesChristmascierre anticipado19:0076
25/12/2026viernesChristmascierre total77
01/01/2027viernesNew Years Daycierre total84
18/01/2027lunesMartin Luther King, Jr. Daycierre total101
15/02/2027lunesWashington's Birthdaycierre total129
26/03/2027viernesGood Fridaycierre total168
31/05/2027lunesMemorial Daycierre total234
18/06/2027viernesJuneteenthcierre total252
05/07/2027lunesIndependence Daycierre total269
06/09/2027lunesLabor Daycierre total332
Rows × columns
12 × 6
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 calendario, derived from the stored result.
ColumnTypeRangeNotes
fecha text 12 distinct values (01/01/2027, 05/07/2027, 06/09/2027…)
dia text 3 distinct values (jueves, lunes, viernes)
festivo text 10 distinct values (Christmas, Good Friday, Independence Day…)
tipo text 2 distinct values (cierre anticipado, cierre total)
cierre_hora_espanola text 1 distinct value (19:00) 2 of 12 rows populated
dias_restantes number 48 to 332

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
    formatDateTime(date, '%d/%m/%Y') AS fecha,
    ['lunes', 'martes', 'miércoles', 'jueves', 'viernes', 'sábado', 'domingo'][toDayOfWeek(date)] AS dia,
    any(name) AS festivo,
    any(if(status = 'early-close', 'cierre anticipado', 'cierre total')) AS tipo,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Europe/Madrid'), '%H:%i'),
           '')) AS cierre_hora_espanola,
    dateDiff('day', today(), date) AS dias_restantes
FROM global_markets.stocks_market_holidays
WHERE date >= today()
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