One contract: premium, cash out, and breakeven across the strikes above the stock

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
    0.65 AS commission_per_contract,
    0.05 AS fees_per_contract,
    (
        SELECT round(toFloat64(close), 2)
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date = '2026-02-20'
    ) AS entry_close
SELECT
    toFloat64(strike_price)                                          AS strike,
    any(ticker)                                                      AS contract_code,
    round(toFloat64(any(option_close)) * 100, 2)                     AS premium_paid,
    round(toFloat64(any(option_close)) * 100
          + commission_per_contract + fees_per_contract, 2)          AS cash_out_one_contract,
    round(toFloat64(strike_price) + toFloat64(any(option_close))
          + (commission_per_contract + fees_per_contract) / 100, 2)  AS breakeven_price,
    round(((toFloat64(strike_price) + toFloat64(any(option_close))
          + (commission_per_contract + fees_per_contract) / 100)
          / entry_close - 1) * 100, 2)                               AS move_needed_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND lower(option_type) LIKE 'c%'
  AND expiration_date = '2026-03-20'
  AND date = '2026-02-20'
  AND toFloat64(option_close) > 0
  AND toFloat64(strike_price) > entry_close
GROUP BY strike_price
ORDER BY strike_price
LIMIT 6