STRASMORE/EXPLORE 2,707 QUERIES

sessions_beijing

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-27, from us-premarket-and-after-hours-in-beijing-time.

as of series 3×6read in context →
sessions_beijing — 3 rows by 6 columns, computed from US exchange, SIP and OPRA data.
labelet_windowbeijing_summerbeijing_winterbeijing_calendar_dayhours
盘前 Pre-Market04:00 - 09:30 ET16:00 - 21:3017:00 - 22:30与美东同一天5.5
盘中 Regular09:30 - 16:00 ET21:30 - 04:0022:30 - 05:00当晚开始，次日凌晨结束6.5
盘后 After-Hours16:00 - 20:00 ET04:00 - 08:0005:00 - 09:00整段在次日清晨4
Rows × columns
3 × 6
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 sessions_beijing, derived from the stored result.
ColumnTypeRangeNotes
label text 3 distinct values
et_window text 3 distinct values
beijing_summer text 3 distinct values
beijing_winter text 3 distinct values
beijing_calendar_day text 3 distinct values (与美东同一天, 当晚开始，次日凌晨结束, 整段在次日清晨)
hours number 4 to 6.5

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
    s.1 AS label,
    s.2 AS et_window,
    concat(
        formatDateTime(toTimeZone(toDateTime(concat('2026-07-15 ', s.3), 'America/New_York'), 'Asia/Shanghai'), '%H:%i'),
        ' - ',
        formatDateTime(toTimeZone(toDateTime(concat('2026-07-15 ', s.4), 'America/New_York'), 'Asia/Shanghai'), '%H:%i')
    ) AS beijing_summer,
    concat(
        formatDateTime(toTimeZone(toDateTime(concat('2026-12-15 ', s.3), 'America/New_York'), 'Asia/Shanghai'), '%H:%i'),
        ' - ',
        formatDateTime(toTimeZone(toDateTime(concat('2026-12-15 ', s.4), 'America/New_York'), 'Asia/Shanghai'), '%H:%i')
    ) AS beijing_winter,
    s.5 AS beijing_calendar_day,
    s.6 AS hours
FROM
(
    SELECT arrayJoin([
        ('盘前 Pre-Market',  '04:00 - 09:30 ET', '04:00:00', '09:30:00', '与美东同一天', 5.5),
        ('盘中 Regular',     '09:30 - 16:00 ET', '09:30:00', '16:00:00', '当晚开始，次日凌晨结束', 6.5),
        ('盘后 After-Hours', '16:00 - 20:00 ET', '16:00:00', '20:00:00', '整段在次日清晨', 4.0)
    ]) AS s
)
ORDER BY et_window
⌘/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