美股盘前和盘后对应北京时间几点？夏令时与冬令时

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

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

SELECT
    toString(date)                          AS holiday_date,
    formatDateTime(date, '%a')              AS weekday,
    any(name)                               AS holiday,
    any(status)                             AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'America/New_York'), '%H:%i'),
           ''))                             AS et_close,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Asia/Shanghai'), '%m-%d %H:%i'),
           ''))                             AS beijing_close,
    dateDiff('day', today(), date)          AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date

SELECT
    concat(leftPad(toString(et_h), 2, '0'), ':00') AS et_hour,
    round(avg(
        (toFloat64(ask_price) - toFloat64(bid_price))
        / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000
    ), 2)                                          AS avg_spread_bps,
    count()                                        AS quote_count
FROM
(
    SELECT
        toHour(toTimeZone(sip_timestamp, 'America/New_York')) AS et_h,
        ask_price,
        bid_price
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'KO'
      AND sip_timestamp >= toDateTime('2026-06-10 04:00:00', 'America/New_York')
      AND sip_timestamp <  toDateTime('2026-06-10 20:00:00', 'America/New_York')
      AND bid_price > 0
      AND ask_price > bid_price
)
GROUP BY et_h
HAVING count() >= 20
ORDER BY et_h

SELECT
    multiIf(et_minute < 570, '盘前 04:00-09:30',
            et_minute < 960, '盘中 09:30-16:00',
                            '盘后 16:00-20:00')                  AS label,
    round(100 * sum(volume) / sum(sum(volume)) OVER (), 2)        AS volume_share_pct,
    round(sum(volume) / countDistinct(sess) / 1e6, 2)             AS avg_volume_millions
FROM
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York'))      AS sess,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minute,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= today() - 45
      AND window_start <  today() - 2
)
WHERE et_minute >= 240 AND et_minute < 1200
GROUP BY label
ORDER BY min(et_minute)