dst_switches
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.
| switch_date | switch_label | clock_change | beijing_premarket_open | beijing_regular_open | beijing_afterhours_end | days_away |
|---|---|---|---|---|---|---|
| 2026-11-01 | 2026年11月1日 | 美东回到冬令时 EST | 17:00 | 22:30 | 09:00 | 35 |
| 2027-03-14 | 2027年3月14日 | 美东进入夏令时 EDT | 16:00 | 21:30 | 08:00 | 168 |
| 2027-11-07 | 2027年11月7日 | 美东回到冬令时 EST | 17:00 | 22:30 | 09:00 | 406 |
| 2028-03-12 | 2028年3月12日 | 美东进入夏令时 EDT | 16:00 | 21:30 | 08:00 | 532 |
| 2028-11-05 | 2028年11月5日 | 美东回到冬令时 EST | 17:00 | 22:30 | 09:00 | 770 |
- Rows × columns
- 5 × 7
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
switch_date |
date | 2026-11-01 to 2028-11-05 | |
switch_label |
text | 5 distinct values (2026年11月1日, 2027年11月7日, 2027年3月14日…) | |
clock_change |
text | 2 distinct values (美东回到冬令时 EST, 美东进入夏令时 EDT) | |
beijing_premarket_open |
text | 2 distinct values (16:00, 17:00) | |
beijing_regular_open |
text | 2 distinct values (21:30, 22:30) | |
beijing_afterhours_end |
text | 2 distinct values (08:00, 09:00) | |
days_away |
number | 35 to 770 |
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 switch_date,
concat(toString(toYear(d)), '年', toString(toMonth(d)), '月',
toString(toDayOfMonth(d)), '日') AS switch_label,
if(toMonth(d) = 3, '美东进入夏令时 EDT', '美东回到冬令时 EST') AS clock_change,
if(toMonth(d) = 3, '16:00', '17:00') AS beijing_premarket_open,
if(toMonth(d) = 3, '21:30', '22:30') AS beijing_regular_open,
if(toMonth(d) = 3, '08:00', '09:00') AS beijing_afterhours_end,
dateDiff('day', today(), d) AS days_away
FROM
(
SELECT arrayJoin([
toDate(concat(toString(y), '-03-01'))
+ ((7 - toDayOfWeek(toDate(concat(toString(y), '-03-01')))) % 7) + 7,
toDate(concat(toString(y), '-11-01'))
+ ((7 - toDayOfWeek(toDate(concat(toString(y), '-11-01')))) % 7)
]) AS d
FROM (SELECT arrayJoin([2026, 2027, 2028]) AS y)
)
WHERE d >= today()
ORDER BY d
LIMIT 5
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.