Time value left in deep in-the-money SPY calls, against the dividend at stake

WITH
    spy_ex AS
    (
        SELECT
            max(ex_dividend_date)                            AS ex_date,
            argMax(toFloat64(cash_amount), ex_dividend_date) AS cash_per_share
        FROM global_markets.stocks_dividends
        WHERE ticker = 'SPY'
          AND ex_dividend_date <= today()
    ),
    chain_date AS
    (
        SELECT max(date) AS d
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'SPY'
          AND date <  (SELECT ex_date FROM spy_ex)
          AND date >= (SELECT ex_date FROM spy_ex) - 10
    ),
    target_expiry AS
    (
        SELECT expiration_date AS e
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'SPY'
          AND date = (SELECT d FROM chain_date)
          AND days_to_expiry BETWEEN 20 AND 45
        GROUP BY expiration_date
        ORDER BY sum(volume) DESC, expiration_date
        LIMIT 1
    )
SELECT
    toString(toUInt32(strike_price))                                    AS strike,
    toString(round(100 * (1 - avg(toFloat64(strike_price))
                            / avg(toFloat64(underlying_close))), 1))    AS pct_below_spy,
    round(avg(greatest(toFloat64(option_close)
              - greatest(toFloat64(underlying_close)
                         - toFloat64(strike_price), 0), 0)) * 100, 2)   AS time_value_per_contract_usd,
    round((SELECT cash_per_share FROM spy_ex) * 100, 2)                 AS dividend_per_contract_usd
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND option_type IN ('call', 'C')
  AND date = (SELECT d FROM chain_date)
  AND expiration_date = (SELECT e FROM target_expiry)
  AND toFloat64(strike_price) BETWEEN toFloat64(underlying_close) * 0.88
                                  AND toFloat64(underlying_close) * 0.99
  AND toUInt32(strike_price) % 5 = 0
GROUP BY strike_price
ORDER BY strike_price