STRASMORE/EXPLORE 3,022 QUERIES

sessions_taipei

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

as of table 4×6read in context →
sessions_taipei — 4 rows by 6 columns, computed from US exchange, SIP and OPRA data.
session_nameet_windowtaipei_summertaipei_wintersession_hourstaipei_note
夜盤 Overnight20:00 - 04:0008:00 - 16:0009:00 - 17:008台北白天，與台股盤中並行
盤前 Pre-Market04:00 - 09:3016:00 - 21:3017:00 - 22:305.5台北傍晚到深夜
正常盤 Regular09:30 - 16:0021:30 - 04:0022:30 - 05:006.5台北深夜到隔天清晨
盤後 After-Hours16:00 - 20:0004:00 - 08:0005:00 - 09:004台北隔天清晨到上班前
Rows × columns
4 × 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_taipei, derived from the stored result.
ColumnTypeRangeNotes
session_name text 4 distinct values (夜盤 Overnight, 正常盤 Regular, 盤前 Pre-Market…)
et_window text 4 distinct values
taipei_summer text 4 distinct values
taipei_winter text 4 distinct values
session_hours number 4 to 8
taipei_note 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.

WITH us_sessions AS
(
    SELECT arrayJoin([
        (1, '夜盤 Overnight',    '20:00:00', '04:00:00', '台北白天，與台股盤中並行'),
        (2, '盤前 Pre-Market',   '04:00:00', '09:30:00', '台北傍晚到深夜'),
        (3, '正常盤 Regular',    '09:30:00', '16:00:00', '台北深夜到隔天清晨'),
        (4, '盤後 After-Hours',  '16:00:00', '20:00:00', '台北隔天清晨到上班前')
    ]) AS s
)
SELECT
    tupleElement(s, 2)                                                       AS session_name,
    concat(substring(tupleElement(s, 3), 1, 5), ' - ',
           substring(tupleElement(s, 4), 1, 5))                              AS et_window,
    concat(
        formatDateTime(toTimeZone(toDateTime(concat('2026-07-15 ', tupleElement(s, 3)), 'America/New_York'), 'Asia/Taipei'), '%H:%i'),
        ' - ',
        formatDateTime(toTimeZone(toDateTime(concat('2026-07-15 ', tupleElement(s, 4)), 'America/New_York'), 'Asia/Taipei'), '%H:%i')
    )                                                                        AS taipei_summer,
    concat(
        formatDateTime(toTimeZone(toDateTime(concat('2026-12-15 ', tupleElement(s, 3)), 'America/New_York'), 'Asia/Taipei'), '%H:%i'),
        ' - ',
        formatDateTime(toTimeZone(toDateTime(concat('2026-12-15 ', tupleElement(s, 4)), 'America/New_York'), 'Asia/Taipei'), '%H:%i')
    )                                                                        AS taipei_winter,
    round(
        modulo(
            dateDiff('minute',
                toDateTime(concat('2026-07-15 ', tupleElement(s, 3)), 'America/New_York'),
                toDateTime(concat('2026-07-15 ', tupleElement(s, 4)), 'America/New_York')
            ) + 1440, 1440) / 60.0, 1)                                       AS session_hours,
    tupleElement(s, 5)                                                       AS taipei_note
FROM us_sessions
ORDER BY tupleElement(s, 1)
⌘/Ctrl + Enter

在你的 AI 助理中使用這些資料

開啟即可查詢，已帶入本頁資料。免費，無需帳號。

Claude ChatGPT Gemini Muse 你自己的代理