STRASMORE/EXPLORE 3,293 QUERIES

viradas

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-11-01, from us-stock-market-hours-brasilia-time.

as of table 4×7read in context →
viradas — 4 rows by 7 columns, computed from US exchange, SIP and OPRA data.
data_isoviradadia_da_semanaabertura_brt_ate_a_vesperaabertura_brt_a_partir_daihoras_de_diferencasegunda_seguinte
2026-03-088 de março de 2026domingo11:3010:3019 de março de 2026
2026-11-011 de novembro de 2026domingo10:3011:3022 de novembro de 2026
2027-03-1414 de março de 2027domingo11:3010:30115 de março de 2027
2027-11-077 de novembro de 2027domingo10:3011:3028 de novembro de 2027
Rows × columns
4 × 7
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 viradas, derived from the stored result.
ColumnTypeRangeNotes
data_iso date 2026-03-08 to 2027-11-07
virada text 4 distinct values
dia_da_semana text 1 distinct value (domingo)
abertura_brt_ate_a_vespera text 2 distinct values (10:30, 11:30)
abertura_brt_a_partir_dai text 2 distinct values (10:30, 11:30)
horas_de_diferenca number 1 to 2
segunda_seguinte text 4 distinct values

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(d)                                                                 AS data_iso,
    concat(toString(toDayOfMonth(d)), ' de ',
           multiIf(toMonth(d) = 3, 'março', toMonth(d) = 11, 'novembro', monthName(d)),
           ' de ', toString(toYear(d)))                                         AS virada,
    multiIf(toDayOfWeek(d) = 7, 'domingo', toDayOfWeek(d) = 6, 'sábado', 'dia útil') AS dia_da_semana,
    formatDateTime(toDateTime(concat(toString(d - 1), ' 09:30:00'), 'America/New_York'), '%H:%i', 'America/Sao_Paulo') AS abertura_brt_ate_a_vespera,
    formatDateTime(toDateTime(concat(toString(d), ' 09:30:00'), 'America/New_York'), '%H:%i', 'America/Sao_Paulo')     AS abertura_brt_a_partir_dai,
    intDiv(toInt64(toUnixTimestamp(toDateTime(concat(toString(d), ' 12:00:00'), 'America/New_York')))
           - toInt64(toUnixTimestamp(toDateTime(concat(toString(d), ' 12:00:00'), 'America/Sao_Paulo'))), 3600) AS horas_de_diferenca,
    concat(toString(toDayOfMonth(d + 1)), ' de ',
           multiIf(toMonth(d + 1) = 3, 'março', toMonth(d + 1) = 11, 'novembro', monthName(d + 1)),
           ' de ', toString(toYear(d + 1)))                                     AS segunda_seguinte
FROM
(
    SELECT toDate('2026-01-01') + arrayJoin(range(730)) AS d
)
WHERE abertura_brt_ate_a_vespera != abertura_brt_a_partir_dai
ORDER BY d
⌘/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