期权几点开始交易？美东时间9:30开盘

WITH
    tape AS
    (
        SELECT
            intDiv(
                toHour(toTimeZone(window_start, 'America/New_York')) * 60
              + toMinute(toTimeZone(window_start, 'America/New_York')), 30) * 30 AS bucket_minute,
            sum(volume)                                                          AS contracts
        FROM global_markets.options_minute_aggs
        WHERE window_start >= today() - 12
          AND window_start <  today() - 2
        GROUP BY bucket_minute
    ),
    shares AS
    (
        SELECT
            bucket_minute,
            contracts,
            round(100 * contracts / sum(contracts) OVER (), 2) AS share_pct
        FROM tape
    )
SELECT
    formatDateTime(toDateTime('2026-01-01 00:00:00') + grid.bucket_minute * 60, '%H:%i') AS et_time,
    round(ifNull(s.contracts, 0) / 1000000, 2)                                           AS contracts_millions,
    ifNull(s.share_pct, 0)                                                               AS share_pct
FROM
(
    SELECT 420 + 30 * arrayJoin(range(21)) AS bucket_minute
) AS grid
LEFT JOIN shares AS s ON s.bucket_minute = grid.bucket_minute
ORDER BY grid.bucket_minute

WITH tape AS
(
    SELECT
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
      + toMinute(toTimeZone(window_start, 'America/New_York'))              AS minute_of_day,
        countDistinct(toDate(toTimeZone(window_start, 'America/New_York'))) AS days_traded,
        sum(volume)                                                         AS contracts
    FROM global_markets.options_minute_aggs
    WHERE startsWith(ticker, 'O:SPY')
      AND length(ticker) = 20
      AND window_start >= today() - 12
      AND window_start <  today() - 2
    GROUP BY minute_of_day
)
SELECT
    formatDateTime(toDateTime('2026-01-01 00:00:00') + grid.minute_of_day * 60, '%H:%i')         AS et_time,
    toUInt64(round(ifNull(t.contracts, 0) / greatest((SELECT max(days_traded) FROM tape), 1)))   AS contract_volume,
    round(100 * ifNull(t.days_traded, 0) / greatest((SELECT max(days_traded) FROM tape), 1), 1)  AS active_pct
FROM
(
    SELECT 555 + arrayJoin(range(46)) AS minute_of_day
) AS grid
LEFT JOIN tape AS t ON t.minute_of_day = grid.minute_of_day
ORDER BY grid.minute_of_day

SELECT
    formatDateTime(date, '%b %e')                                          AS holiday_label,
    any(name)                                                              AS holiday,
    formatDateTime(toTimeZone(any(open),  'America/New_York'), '%I:%i %p') AS scheduled_open_et,
    formatDateTime(toTimeZone(any(close), 'America/New_York'), '%I:%i %p') AS scheduled_close_et,
    round((toHour(toTimeZone(any(open),  'America/New_York')) * 60
         + toMinute(toTimeZone(any(open),  'America/New_York'))) / 60, 2)  AS open_hour_et,
    round((toHour(toTimeZone(any(close), 'America/New_York')) * 60
         + toMinute(toTimeZone(any(close), 'America/New_York'))) / 60, 2)  AS close_hour_et
FROM global_markets.stocks_market_holidays
WHERE date >= today()
  AND status = 'early-close'
GROUP BY date
ORDER BY date