델타 헤징의 원리와 실전 운용 방식

SELECT
    concat(if(pct_from_spot >= 0, '+', ''), toString(pct_from_spot), '%') AS strike_vs_spot,
    round(avgIf(delta, is_call), 3) AS call_delta,
    round(avgIf(delta, is_put), 3)  AS put_delta
FROM
(
    SELECT
        toInt16(round((toFloat64(strike_price) / toFloat64(underlying_close) - 1) * 100)) AS pct_from_spot,
        lower(option_type) IN ('call', 'c') AS is_call,
        lower(option_type) IN ('put', 'p')  AS is_put,
        delta
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND iv_converged = 1
      AND volume > 0
      AND underlying_close > 0
      AND days_to_expiry BETWEEN 25 AND 35
      AND date >= '2026-06-01'
      AND date <  '2026-07-01'
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) <= 0.05
)
GROUP BY pct_from_spot
HAVING countIf(is_call) > 0 AND countIf(is_put) > 0
ORDER BY pct_from_spot

SELECT
    multiIf(bucket = 1, '0-2 days',
            bucket = 2, '3-7 days',
            bucket = 3, '8-21 days',
            bucket = 4, '22-45 days',
                        '46-90 days')            AS expiry_window,
    toUInt32(round(avg(shares_per_contract) * 100)) AS hedge_shares
FROM
(
    SELECT
        multiIf(days_to_expiry <= 2,  1,
                days_to_expiry <= 7,  2,
                days_to_expiry <= 21, 3,
                days_to_expiry <= 45, 4,
                                      5) AS bucket,
        toFloat64(gamma) * toFloat64(underlying_close) AS shares_per_contract
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND iv_converged = 1
      AND volume > 0
      AND underlying_close > 0
      AND days_to_expiry BETWEEN 0 AND 90
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) <= 0.01
      AND date >= '2026-06-01'
      AND date <  '2026-07-01'
)
GROUP BY bucket
ORDER BY bucket

SELECT
    ticker,
    round(path, 1)                        AS path_length_pct,
    round(net, 1)                         AS net_move_pct,
    round(path / greatest(net, 0.05), 1)  AS path_to_net_ratio
FROM
(
    SELECT
        ticker,
        arraySum(arrayMap((a, b) -> abs(a / b - 1) * 100,
                          arraySlice(px, 2),
                          arraySlice(px, 1, length(px) - 1))) AS path,
        abs(px[-1] / px[1] - 1) * 100                          AS net
    FROM
    (
        SELECT
            ticker,
            arrayMap(t -> t.2, arraySort(t -> t.1, groupArray((session_date, session_close)))) AS px
        FROM
        (
            SELECT
                ticker,
                date                  AS session_date,
                toFloat64(max(close)) AS session_close
            FROM global_markets.stocks_daily_aggs
            WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'KO')
              AND date >= '2026-06-01'
              AND date <  '2026-07-01'
            GROUP BY ticker, date
        )
        GROUP BY ticker
    )
)
ORDER BY path_to_net_ratio

WITH
    monthly_iv AS
    (
        SELECT
            toStartOfMonth(date)                    AS m,
            round(avg(implied_volatility) * 100, 1) AS implied_vol_pct
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'SPY'
          AND iv_converged = 1
          AND volume > 0
          AND underlying_close > 0
          AND days_to_expiry BETWEEN 20 AND 45
          AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
          AND date >= '2025-08-01'
          AND date <  '2026-08-01'
        GROUP BY m
    ),
    monthly_rv AS
    (
        SELECT
            m,
            round(arrayReduce('stddevPop', rets) * sqrt(252) * 100, 1) AS realized_vol_pct
        FROM
        (
            SELECT
                m,
                arrayMap((a, b) -> log(a / b),
                         arraySlice(px, 2),
                         arraySlice(px, 1, length(px) - 1)) AS rets
            FROM
            (
                SELECT
                    toStartOfMonth(session_date) AS m,
                    arrayMap(t -> t.2, arraySort(t -> t.1, groupArray((session_date, session_close)))) AS px
                FROM
                (
                    SELECT
                        date                  AS session_date,
                        toFloat64(max(close)) AS session_close
                    FROM global_markets.stocks_daily_aggs
                    WHERE ticker = 'SPY'
                      AND date >= '2025-08-01'
                      AND date <  '2026-08-01'
                    GROUP BY date
                )
                GROUP BY m
            )
            WHERE length(rets) > 5
        )
    )
SELECT
    toString(iv.m)      AS month,
    iv.implied_vol_pct  AS implied_vol_pct,
    rv.realized_vol_pct AS realized_vol_pct
FROM monthly_iv AS iv
INNER JOIN monthly_rv AS rv ON rv.m = iv.m
ORDER BY iv.m