オプション・ポジションを上方かつ先の限月へロールする方法

SELECT
    dte_bucket,
    round(avg(premium_pct), 2) AS call_premium_pct_of_spot,
    count()                    AS sample_count
FROM
(
    SELECT
        multiIf(days_to_expiry <=  7, '1-7 days',
                days_to_expiry <= 14, '8-14 days',
                days_to_expiry <= 30, '15-30 days',
                days_to_expiry <= 60, '31-60 days',
                days_to_expiry <= 90, '61-90 days',
                                      '91-180 days')              AS dte_bucket,
        days_to_expiry                                            AS dte,
        toFloat64(option_close) / toFloat64(underlying_close) * 100 AS premium_pct
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND lower(option_type) IN ('call', 'c')
      AND iv_converged = 1
      AND volume > 0
      AND date >= '2026-02-01'
      AND date <  '2026-08-01'
      AND days_to_expiry BETWEEN 1 AND 180
      AND underlying_close > 0
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02
)
GROUP BY dte_bucket
ORDER BY min(dte)

SELECT
    strike_vs_spot,
    round(avg(premium_pct), 2) AS call_premium_pct_of_spot,
    count()                    AS sample_count
FROM
(
    SELECT
        multiIf(strike_ratio < 0.95, '5%+ below spot',
                strike_ratio < 0.98, '2-5% below spot',
                strike_ratio < 1.02, 'at the money',
                strike_ratio < 1.05, '2-5% above spot',
                strike_ratio < 1.10, '5-10% above spot',
                                     '10%+ above spot')            AS strike_vs_spot,
        strike_ratio,
        premium_pct
    FROM
    (
        SELECT
            toFloat64(strike_price)  / toFloat64(underlying_close)       AS strike_ratio,
            toFloat64(option_close)  / toFloat64(underlying_close) * 100 AS premium_pct
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
          AND lower(option_type) IN ('call', 'c')
          AND iv_converged = 1
          AND volume > 0
          AND date >= '2026-02-01'
          AND date <  '2026-08-01'
          AND days_to_expiry BETWEEN 30 AND 45
          AND underlying_close > 0
    )
)
GROUP BY strike_vs_spot
ORDER BY min(strike_ratio)

SELECT
    dte_bucket,
    round(avg(extrinsic_dollars), 2) AS avg_time_value_dollars,
    round(avg(extrinsic_pct), 2)     AS time_value_pct_of_spot,
    count()                          AS sample_count
FROM
(
    SELECT
        multiIf(days_to_expiry <=  2, '0-2 days',
                days_to_expiry <=  5, '3-5 days',
                days_to_expiry <= 10, '6-10 days',
                days_to_expiry <= 21, '11-21 days',
                                      '22-45 days')  AS dte_bucket,
        days_to_expiry                               AS dte,
        greatest(toFloat64(option_close)
                 - (toFloat64(underlying_close) - toFloat64(strike_price)), 0) AS extrinsic_dollars,
        greatest(toFloat64(option_close)
                 - (toFloat64(underlying_close) - toFloat64(strike_price)), 0)
            / toFloat64(underlying_close) * 100                                AS extrinsic_pct
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'KO'
      AND lower(option_type) IN ('call', 'c')
      AND iv_converged = 1
      AND volume > 0
      AND date >= '2026-02-01'
      AND date <  '2026-08-01'
      AND days_to_expiry BETWEEN 0 AND 45
      AND underlying_close > 0
      AND toFloat64(strike_price) / toFloat64(underlying_close) BETWEEN 0.90 AND 0.99
)
GROUP BY dte_bucket
ORDER BY min(dte)

SELECT
    ticker,
    formatDateTime(max(ex_dividend_date), '%b %e, %Y')         AS latest_ex_label,
    round(toFloat64(argMax(cash_amount, ex_dividend_date)), 2) AS dividend_per_share,
    round(toFloat64(sum(cash_amount)), 2)                      AS dividends_paid_ytd
FROM
(
    SELECT
        ticker,
        ex_dividend_date,
        max(cash_amount) AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'VZ', 'CVX')
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2026-08-01'
    GROUP BY ticker, ex_dividend_date
)
GROUP BY ticker
ORDER BY dividend_per_share DESC