0DTE期权策略 交易方法

SELECT multiIf(price < 0.10, 'Under $0.10',
               price < 0.50, '$0.10 to $0.50',
               price < 2, '$0.50 to $2',
               price < 10, '$2 to $10',
               '$10 and up') AS premium_paid,
       round(sum(size) / 1e6, 2) AS contracts_m,
       round(100.0 * sum(size) / sum(sum(size)) OVER (), 1) AS pct_of_contracts,
       round(100.0 * sum(price * size) / sum(sum(price * size)) OVER (), 1) AS pct_of_premium_dollars
FROM global_markets.options_trades
WHERE sip_timestamp >= toDateTime64('2026-07-10 13:30:00', 9)
  AND sip_timestamp < toDateTime64('2026-07-10 20:00:00', 9)
  AND substring(ticker, length(ticker) - 14, 6) = '260710'
GROUP BY premium_paid
ORDER BY min(price)

SELECT multiIf(days_to_expiry = 0, '0 (same day)',
               days_to_expiry <= 2, '1-2 days',
               days_to_expiry <= 7, '3-7 days',
               days_to_expiry <= 30, '8-30 days',
               'Over 30 days') AS time_to_expiry,
       count() AS contracts,
       round(quantileExact(0.5)(gamma), 4) AS median_gamma,
       round(quantileExact(0.5)(abs(theta)), 3) AS median_abs_theta,
       round(quantileExact(0.5)(abs(delta)), 2) AS median_abs_delta
FROM global_markets.options_greeks
WHERE date = toDate('2026-07-15')
  AND iv_converged
  AND implied_volatility BETWEEN 0.02 AND 5
  AND abs(strike_price / underlying_close - 1) <= 0.02
  AND days_to_expiry >= 0
GROUP BY time_to_expiry
ORDER BY min(days_to_expiry)

SELECT toString(session_date) AS date,
       formatDateTimeInJodaSyntax(session_date, 'MMM d') AS session_label,
       round(100 * (close_px / open_px - 1), 2) AS close_vs_open_pct,
       round(100 * (high_px / open_px - 1), 2) AS session_high_pct,
       round(100 * (low_px / open_px - 1), 2) AS session_low_pct
FROM (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           argMin(open, window_start) AS open_px,
           argMax(close, window_start) AS close_px,
           max(high) AS high_px,
           min(low) AS low_px
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-01 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-11 16:01:00', 'America/New_York')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY session_date
)
ORDER BY session_date

WITH (
    SELECT round(argMax(close, window_start), 2)
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-07-10 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-10 16:01:00', 'America/New_York')
) AS spy_close
SELECT if(expired_at_zero, 'Expired at zero (out of the money)',
                           'Settled with value (in the money)') AS at_the_bell,
       count() AS strikes,
       round(sum(vol) / 1e6, 2) AS contracts_m,
       round(100.0 * sum(vol) / sum(sum(vol)) OVER (), 1) AS pct_of_spy_same_day_volume
FROM (
    SELECT substring(ticker, length(ticker) - 8, 1) AS opt_type,
           toFloat64(substring(ticker, length(ticker) - 7, 8)) / 1000 AS strike,
           (opt_type = 'C' AND strike > spy_close) OR (opt_type = 'P' AND strike < spy_close) AS expired_at_zero,
           sum(toFloat64(volume)) AS vol
    FROM global_markets.options_minute_aggs
    WHERE window_start >= toDateTime('2026-07-10 08:00:00')
      AND window_start < toDateTime('2026-07-11 04:00:00')
      AND startsWith(ticker, 'O:SPY260710')
    GROUP BY ticker, opt_type, strike, expired_at_zero
)
GROUP BY expired_at_zero
ORDER BY expired_at_zero DESC