STRASMORE/EXPLORE 3,214 QUERIES

calendario_festivos_madrid

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

as of table 12×6read in context →
calendario_festivos_madrid — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
fechadia_semanafestivotipocierre_nycierre_madrid
26 de noviembre de 2026juevesThanksgivingcierre total
27 de noviembre de 2026viernesThanksgivingcierre anticipado13:0019:00
24 de diciembre de 2026juevesChristmascierre anticipado13:0019:00
25 de diciembre de 2026viernesChristmascierre total
1 de enero de 2027viernesNew Years Daycierre total
18 de enero de 2027lunesMartin Luther King, Jr. Daycierre total
15 de febrero de 2027lunesWashington's Birthdaycierre total
26 de marzo de 2027viernesGood Fridaycierre total
31 de mayo de 2027lunesMemorial Daycierre total
18 de junio de 2027viernesJuneteenthcierre total
5 de julio de 2027lunesIndependence Daycierre total
6 de septiembre de 2027lunesLabor Daycierre total
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_festivos_madrid, derived from the stored result.
ColumnTypeRangeNotes
fecha text 12 distinct values
dia_semana 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_ny text 1 distinct value (13:00) 2 of 12 rows populated
cierre_madrid text 1 distinct value (19:00) 2 of 12 rows populated

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
    concat(toString(toDayOfMonth(date)), ' de ',
           ['enero','febrero','marzo','abril','mayo','junio','julio','agosto','septiembre','octubre','noviembre','diciembre'][toMonth(date)],
           ' de ', toString(toYear(date)))                                           AS fecha,
    ['lunes','martes','miercoles','jueves','viernes','sabado','domingo'][toDayOfWeek(date)] AS dia_semana,
    min(name)                                                                        AS festivo,
    max(if(status = 'early-close', 'cierre anticipado', 'cierre total'))             AS tipo,
    max(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'America/New_York'), '%H:%i'), ''))      AS cierre_ny,
    max(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Europe/Madrid'), '%H:%i'), ''))         AS cierre_madrid
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