STRASMORE/EXPLORE 2,500 QUERIES

medios_dias

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 bmv-hours-vs-us-market-hours.

as of table 5×5read in context →
medios_dias — 5 rows by 5 columns, computed from US exchange, SIP and OPRA data.
sesiondiaminutos_operadoscierre_hora_nycierre_hora_centro
2024-11-29viernes21113:0112:01
2024-12-24martes21113:0112:01
2025-07-03jueves21113:0111:01
2025-11-28viernes21113:0112:01
2025-12-24miércoles21113:0112:01
Rows × columns
5 × 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 medios_dias, derived from the stored result.
ColumnTypeRangeNotes
sesion date 2024-11-29 to 2025-12-24
dia text 4 distinct values (jueves, martes, miércoles…)
minutos_operados number every row is 211
cierre_hora_ny text 1 distinct value (13:01)
cierre_hora_centro text 2 distinct values (11:01, 12:01)

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(sesion)                                                                                           AS sesion,
    arrayElement(['lunes', 'martes', 'miércoles', 'jueves', 'viernes', 'sábado', 'domingo'],
                 toDayOfWeek(sesion))                                                                          AS dia,
    minutos_operados,
    cierre_hora_ny,
    cierre_hora_centro
FROM
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York'))                                                   AS sesion,
        count()                                                                                                AS minutos_operados,
        formatDateTime(toTimeZone(max(window_start), 'America/New_York') + toIntervalMinute(1), '%H:%i')        AS cierre_hora_ny,
        formatDateTime(toTimeZone(max(window_start), 'America/Mexico_City') + toIntervalMinute(1), '%H:%i')     AS cierre_hora_centro
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= today() - 760
      AND window_start <  today() - 3
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
    GROUP BY sesion
    HAVING minutos_operados BETWEEN 30 AND 379
)
ORDER BY sesion
⌘/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