dst_clock
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-28, from options-expiration-day-clock-beijing-time.
| month | beijing_close_hour | sample_size |
|---|---|---|
| 2025-09 | 4 | 21 |
| 2025-10 | 4 | 23 |
| 2025-11 | 5 | 18 |
| 2025-12 | 5 | 21 |
| 2026-01 | 5 | 20 |
| 2026-02 | 5 | 19 |
| 2026-03 | 4.23 | 22 |
| 2026-04 | 4 | 21 |
| 2026-05 | 4 | 20 |
| 2026-06 | 4 | 21 |
| 2026-07 | 4 | 22 |
| 2026-08 | 4 | 21 |
- Rows × columns
- 12 × 3
- 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 |
|---|---|---|---|
month |
text | 12 distinct values (2025-09, 2025-10, 2025-11…) | |
beijing_close_hour |
number | 4 to 5 | US dollars |
sample_size |
number | 18 to 23 |
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
formatDateTime(toStartOfMonth(session_day), '%Y-%m') AS month,
round(avg(close_hour_bj), 2) AS beijing_close_hour,
count() AS sample_size
FROM
(
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_day,
toHour(toTimeZone(max(window_start) + toIntervalMinute(1), 'Asia/Shanghai')) AS close_hour_bj,
max(toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York'))) AS last_minute
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= '2025-09-01 00:00:00'
AND window_start < '2026-09-01 00:00:00'
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 session_day
HAVING last_minute >= 955
)
GROUP BY month
ORDER BY month
在你的 AI 助手中使用这些数据
打开即可查询，已带上本页数据。免费，无需账号。