米国株プレマーケットと時間外取引は日本時間で何時？

SELECT
    jst_time,
    summer_volume_mn,
    winter_volume_mn
FROM
(
    SELECT
        formatDateTime(toStartOfHour(toTimeZone(window_start, 'Asia/Tokyo')), '%H:%i') AS jst_time,
        (toHour(toTimeZone(window_start, 'Asia/Tokyo')) + 7) % 24                      AS session_order,
        round(avgIf(volume, timeZoneOffset(toTimeZone(window_start, 'America/New_York')) = -14400) / 1e6, 3) AS summer_volume_mn,
        round(avgIf(volume, timeZoneOffset(toTimeZone(window_start, 'America/New_York')) = -18000) / 1e6, 3) AS winter_volume_mn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= today() - 400
      AND window_start <  today() - 2
    GROUP BY jst_time, session_order
    HAVING countIf(timeZoneOffset(toTimeZone(window_start, 'America/New_York')) = -14400) > 0
       AND countIf(timeZoneOffset(toTimeZone(window_start, 'America/New_York')) = -18000) > 0
)
ORDER BY session_order

SELECT
    ticker,
    round(100 * sumIf(volume, et_minutes <  570) / sum(volume), 2)                        AS premarket_pct,
    round(100 * sumIf(volume, et_minutes >= 570 AND et_minutes < 960) / sum(volume), 2)   AS regular_pct,
    round(100 * sumIf(volume, et_minutes >= 960) / sum(volume), 2)                        AS afterhours_pct
FROM
(
    SELECT
        ticker,
        volume,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minutes
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'NVDA', 'AMZN', 'KO')
      AND window_start >= today() - 120
      AND window_start <  today() - 2
)
GROUP BY ticker
ORDER BY premarket_pct + afterhours_pct DESC

SELECT
    jst_hour,
    spread_bps,
    quote_count
FROM
(
    SELECT
        formatDateTime(toStartOfHour(toTimeZone(sip_timestamp, 'Asia/Tokyo')), '%H:%i') AS jst_hour,
        (toHour(toTimeZone(sip_timestamp, 'Asia/Tokyo')) + 7) % 24                      AS session_order,
        round(quantileDeterministic(0.5)(
            10000 * (toFloat64(ask_price) - toFloat64(bid_price)) / toFloat64(bid_price),
            toUInt64(sequence_number)), 2)                                              AS spread_bps,
        count()                                                                         AS quote_count
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-09-16 08:00:00')
      AND sip_timestamp <  toDateTime('2026-09-17 00:00:00')
      AND bid_price > 0
      AND ask_price > bid_price
    GROUP BY jst_hour, session_order
)
ORDER BY session_order

SELECT
    jst_weekday,
    bar_count,
    session_days
FROM
(
    SELECT
        ['月', '火', '水', '木', '金', '土', '日'][toDayOfWeek(toTimeZone(window_start, 'Asia/Tokyo'))] AS jst_weekday,
        toDayOfWeek(toTimeZone(window_start, 'Asia/Tokyo'))                                            AS weekday_order,
        count()                                                                                        AS bar_count,
        countDistinct(toDate(toTimeZone(window_start, 'Asia/Tokyo')))                                  AS session_days
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= today() - 180
      AND window_start <  today() - 2
    GROUP BY jst_weekday, weekday_order
)
ORDER BY weekday_order