中国节假日美股休市吗？国庆黄金周、中秋、春节美股交易时间

SELECT
    toString(date)                                                              AS holiday_date,
    concat(toString(toMonth(date)), '月', toString(toDayOfMonth(date)), '日')   AS holiday_label,
    formatDateTime(date, '%a')                                                  AS weekday,
    any(name)                                                                   AS holiday,
    any(if(status = 'closed', '全天休市', '提前收盘'))                            AS day_status,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'America/New_York'), '%H:%i'),
           ''))                                                                 AS early_close_et,
    dateDiff('day', today(), date)                                              AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date

WITH
daily AS
(
    SELECT
        ticker,
        date,
        max(toFloat64(volume)) AS vol
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('BABA', 'PDD', 'JD', 'BIDU', 'NIO', 'LI', 'XPEV', 'SPY')
      AND date >= '2021-08-01'
      AND date <  '2025-10-08'
      AND toMonth(date) IN (8, 9, 10)
    GROUP BY ticker, date
),
prior_sessions AS
(
    SELECT
        ticker,
        toYear(date) AS yr,
        vol,
        row_number() OVER (PARTITION BY ticker, toYear(date) ORDER BY date DESC) AS rn
    FROM daily
    WHERE toMonth(date) IN (8, 9)
),
pre_holiday AS
(
    SELECT ticker, yr, avg(vol) AS base_vol
    FROM prior_sessions
    WHERE rn <= 20
    GROUP BY ticker, yr
),
golden_week AS
(
    SELECT ticker, toYear(date) AS yr, avg(vol) AS gw_vol, count() AS gw_sessions
    FROM daily
    WHERE toMonth(date) = 10
      AND toDayOfMonth(date) BETWEEN 1 AND 7
    GROUP BY ticker, yr
)
SELECT
    g.ticker                                    AS ticker,
    round(avg(g.gw_vol / b.base_vol) * 100, 1)  AS golden_week_vs_prior20_pct,
    round(min(g.gw_vol / b.base_vol) * 100, 1)  AS lowest_year_pct,
    round(max(g.gw_vol / b.base_vol) * 100, 1)  AS highest_year_pct
FROM golden_week AS g
INNER JOIN pre_holiday AS b ON g.ticker = b.ticker AND g.yr = b.yr
GROUP BY g.ticker
ORDER BY golden_week_vs_prior20_pct DESC

WITH
daily AS
(
    SELECT
        ticker,
        date,
        max(toFloat64(volume)) AS vol
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('BABA', 'PDD', 'JD', 'BIDU', 'NIO', 'LI', 'XPEV', 'SPY')
      AND date >= '2021-08-01'
      AND date <  '2025-10-08'
      AND toMonth(date) IN (8, 9, 10)
    GROUP BY ticker, date
),
prior_sessions AS
(
    SELECT
        ticker,
        toYear(date) AS yr,
        vol,
        row_number() OVER (PARTITION BY ticker, toYear(date) ORDER BY date DESC) AS rn
    FROM daily
    WHERE toMonth(date) IN (8, 9)
),
pre_holiday AS
(
    SELECT ticker, yr, avg(vol) AS base_vol
    FROM prior_sessions
    WHERE rn <= 20
    GROUP BY ticker, yr
),
golden_week AS
(
    SELECT ticker, toYear(date) AS yr, avg(vol) AS gw_vol, count() AS gw_sessions
    FROM daily
    WHERE toMonth(date) = 10
      AND toDayOfMonth(date) BETWEEN 1 AND 7
    GROUP BY ticker, yr
)
SELECT
    g.yr                                                             AS year,
    round(avgIf(g.gw_vol / b.base_vol, g.ticker != 'SPY') * 100, 1)  AS adr_basket_pct,
    round(avgIf(g.gw_vol / b.base_vol, g.ticker = 'SPY') * 100, 1)   AS spy_pct,
    min(g.gw_sessions)                                               AS session_count
FROM golden_week AS g
INNER JOIN pre_holiday AS b ON g.ticker = b.ticker AND g.yr = b.yr
GROUP BY g.yr
HAVING countIf(g.ticker = 'SPY') > 0
   AND countIf(g.ticker != 'SPY') > 0
ORDER BY year

WITH
daily AS
(
    SELECT
        ticker,
        date,
        toYear(addMonths(date, 1)) AS season,
        max(toFloat64(volume))     AS vol
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('BABA', 'PDD', 'JD', 'BIDU', 'NIO', 'LI', 'XPEV', 'SPY')
      AND date >= '2021-12-01'
      AND date <  '2026-02-24'
      AND toMonth(date) IN (12, 1, 2)
    GROUP BY ticker, date
),
spans AS
(
    SELECT
        ticker,
        date,
        season,
        vol,
        multiIf(season = 2022, toDate('2022-01-31'),
                season = 2023, toDate('2023-01-21'),
                season = 2024, toDate('2024-02-10'),
                season = 2025, toDate('2025-01-28'),
                toDate('2026-02-15'))   AS h_start,
        multiIf(season = 2022, toDate('2022-02-06'),
                season = 2023, toDate('2023-01-27'),
                season = 2024, toDate('2024-02-17'),
                season = 2025, toDate('2025-02-04'),
                toDate('2026-02-23'))   AS h_end
    FROM daily
),
prior_sessions AS
(
    SELECT
        ticker,
        season,
        vol,
        row_number() OVER (PARTITION BY ticker, season ORDER BY date DESC) AS rn
    FROM spans
    WHERE date < h_start
),
pre_holiday AS
(
    SELECT ticker, season, avg(vol) AS base_vol
    FROM prior_sessions
    WHERE rn <= 20
    GROUP BY ticker, season
),
festival AS
(
    SELECT ticker, season, avg(vol) AS fest_vol
    FROM spans
    WHERE date >= h_start
      AND date <= h_end
    GROUP BY ticker, season
)
SELECT
    f.ticker                                        AS ticker,
    round(avg(f.fest_vol / b.base_vol) * 100, 1)    AS spring_festival_vs_prior20_pct,
    round(min(f.fest_vol / b.base_vol) * 100, 1)    AS lowest_year_pct,
    round(max(f.fest_vol / b.base_vol) * 100, 1)    AS highest_year_pct
FROM festival AS f
INNER JOIN pre_holiday AS b ON f.ticker = b.ticker AND f.season = b.season
GROUP BY f.ticker
ORDER BY spring_festival_vs_prior20_pct DESC