指数基金何时交易？ETF与共同基金对比

WITH
    bars AS
    (
        SELECT
            ticker,
            toTimeZone(window_start, 'America/New_York') AS et,
            toFloat64(close)                             AS px
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('VOO', 'QQQ')
          AND window_start >= toDateTime('2026-09-15 04:00:00')
          AND window_start <  toDateTime('2026-09-16 04:00:00')
    ),
    firsts AS
    (
        SELECT
            ticker,
            argMin(px, et) AS open_px
        FROM bars
        GROUP BY ticker
    )
SELECT
    formatDateTime(toStartOfInterval(b.et, INTERVAL 30 MINUTE), '%H:%i')                                  AS et_time,
    round(100 * (argMaxIf(b.px, b.et, b.ticker = 'VOO') / anyIf(f.open_px, f.ticker = 'VOO') - 1), 2)     AS voo_change_pct,
    round(100 * (argMaxIf(b.px, b.et, b.ticker = 'QQQ') / anyIf(f.open_px, f.ticker = 'QQQ') - 1), 2)     AS qqq_change_pct
FROM bars AS b
INNER JOIN firsts AS f ON f.ticker = b.ticker
GROUP BY et_time
HAVING countIf(b.ticker = 'VOO') > 0
   AND countIf(b.ticker = 'QQQ') > 0
ORDER BY et_time

SELECT
    toString(toDate(toTimeZone(window_start, 'America/New_York'))) AS session_date,
    round(sum(transactions) / 1000, 1)                             AS trade_prints_thousands,
    count()                                                        AS minutes_with_prints
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'VOO'
  AND window_start >= today() - 24
  AND window_start <  today() - 1
GROUP BY session_date
ORDER BY session_date

SELECT
    toString(date)                                                                                                                  AS session_date,
    round(100 * toFloat64(maxIf(high, ticker = 'VOO') - minIf(low, ticker = 'VOO')) / toFloat64(anyIf(close, ticker = 'VOO')), 2)    AS voo_range_pct,
    round(100 * toFloat64(maxIf(high, ticker = 'QQQ') - minIf(low, ticker = 'QQQ')) / toFloat64(anyIf(close, ticker = 'QQQ')), 2)    AS qqq_range_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('VOO', 'QQQ')
  AND date >= today() - 45
  AND date <  today() - 1
GROUP BY date
HAVING countIf(ticker = 'VOO') > 0
   AND countIf(ticker = 'QQQ') > 0
ORDER BY date

SELECT
    ticker                                                                                                                                        AS symbol,
    round(avg(20000 * toFloat64(ask_price - bid_price) / toFloat64(ask_price + bid_price)), 3)                                                     AS avg_spread_bps,
    round(quantileDeterministic(0.9)(20000 * toFloat64(ask_price - bid_price) / toFloat64(ask_price + bid_price), toUInt64(sequence_number)), 3)    AS p90_spread_bps
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('SPY', 'VOO', 'IVV', 'QQQ', 'DIA', 'IWM')
  AND sip_timestamp >= toDateTime('2026-09-15 14:00:00')
  AND sip_timestamp <  toDateTime('2026-09-15 14:05:00')
  AND ask_price > bid_price
  AND bid_price > 0
GROUP BY ticker
ORDER BY avg_spread_bps