選擇權為何會提前被指派？股息、利息與借券

SELECT
    depth_bucket                            AS itm_depth,
    round(avgIf(vega_f, side = 'call'), 3)  AS call_avg_vega,
    round(avgIf(vega_f, side = 'put'), 3)   AS put_avg_vega,
    countIf(side = 'call')                  AS call_contracts,
    countIf(side = 'put')                   AS put_contracts
FROM
(
    SELECT
        if(delta > 0, 'call', 'put') AS side,
        toFloat64(vega)              AS vega_f,
        if(delta > 0,
           toFloat64(underlying_close) / toFloat64(strike_price) - 1,
           toFloat64(strike_price) / toFloat64(underlying_close) - 1) AS depth,
        multiIf(depth < 0.01, 'under 1%',
                depth < 0.03, '1 to 3%',
                depth < 0.05, '3 to 5%',
                depth < 0.10, '5 to 10%',
                              'over 10%') AS depth_bucket
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= today() - 120
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 3 AND 30
      AND toFloat64(underlying_close) > 0
      AND toFloat64(strike_price) > 0
      AND toFloat64(delta) != 0
      AND depth > 0
)
GROUP BY depth_bucket
HAVING countIf(side = 'call') > 0 AND countIf(side = 'put') > 0
ORDER BY min(depth)

SELECT
    dte_bucket,
    round(avg(vega_f), 3)  AS avg_vega,
    round(avg(delta_f), 3) AS avg_delta,
    count()                AS contracts
FROM
(
    SELECT
        toFloat64(vega)  AS vega_f,
        toFloat64(delta) AS delta_f,
        days_to_expiry,
        multiIf(days_to_expiry <= 1,  'under 2 days',
                days_to_expiry <= 3,  '2 to 3 days',
                days_to_expiry <= 7,  '4 to 7 days',
                days_to_expiry <= 14, '8 to 14 days',
                days_to_expiry <= 30, '15 to 30 days',
                                      '31 to 60 days') AS dte_bucket
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= today() - 120
      AND iv_converged = 1
      AND volume > 0
      AND delta > 0
      AND days_to_expiry BETWEEN 0 AND 60
      AND toFloat64(underlying_close) / toFloat64(strike_price) - 1 BETWEEN 0.01 AND 0.05
)
GROUP BY dte_bucket
ORDER BY min(days_to_expiry)

WITH last_price AS
(
    SELECT
        ticker,
        argMax(toFloat64(close), window_start) AS px
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('KO', 'JNJ', 'PG', 'XOM', 'MSFT', 'AAPL')
      AND window_start >= today() - 14
    GROUP BY ticker
)
SELECT
    d.ticker AS ticker,
    formatDateTime(max(d.ex_dividend_date), '%b %e, %Y')           AS latest_ex_date,
    round(argMax(toFloat64(d.cash_amount), d.ex_dividend_date), 2) AS dividend_per_share,
    round(100 * argMax(toFloat64(d.cash_amount), d.ex_dividend_date) / any(p.px), 2) AS dividend_pct
FROM global_markets.stocks_dividends AS d
INNER JOIN last_price AS p ON p.ticker = d.ticker
WHERE d.ticker IN ('KO', 'JNJ', 'PG', 'XOM', 'MSFT', 'AAPL')
  AND d.ex_dividend_date >= today() - 400
  AND d.ex_dividend_date <= today() + 120
GROUP BY d.ticker
ORDER BY dividend_pct DESC

SELECT
    underlying_symbol AS ticker,
    round(100 * avgIf(iv_f, delta_f < 0), 1) AS put_iv,
    round(100 * avgIf(iv_f, delta_f > 0), 1) AS call_iv,
    round(100 * (avgIf(iv_f, delta_f < 0) - avgIf(iv_f, delta_f > 0)), 1) AS put_minus_call
FROM
(
    SELECT
        underlying_symbol,
        toFloat64(implied_volatility) AS iv_f,
        toFloat64(delta)              AS delta_f
    FROM global_markets.options_greeks
    WHERE underlying_symbol IN ('MSTR', 'COIN', 'AAPL', 'MSFT', 'KO')
      AND date >= today() - 120
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 20 AND 45
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
)
GROUP BY underlying_symbol
HAVING countIf(delta_f < 0) > 0 AND countIf(delta_f > 0) > 0
ORDER BY put_minus_call DESC