kurve

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.

SELECT
    concat(toString(toInt32(strike_price)), ' USD')                                       AS basispreis,
    round(toFloat64(delta), 2)                                                             AS delta,
    round(toFloat64(option_close), 2)                                                      AS praemie_je_aktie,
    round((toFloat64(option_close) - greatest(toFloat64(underlying_close) - toFloat64(strike_price), 0)) / toFloat64(option_close) * 100, 1) AS zeitwert_anteil_pct,
    round(toFloat64(delta) * toFloat64(underlying_close) / toFloat64(option_close), 1)     AS hebel
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND option_type IN ('call', 'C', 'CALL')
  AND date = '2026-09-11'
  AND iv_converged = 1
  AND volume > 0
  AND option_close > 0
  AND toFloat64(delta) BETWEEN 0.12 AND 0.95
  AND modulo(toInt32(strike_price), 10) = 0
  AND expiration_date =
  (
      SELECT max(expiration_date)
      FROM
      (
          SELECT expiration_date
          FROM global_markets.options_greeks
          WHERE underlying_symbol = 'SPY'
            AND option_type IN ('call', 'C', 'CALL')
            AND date = '2026-09-11'
            AND iv_converged = 1
            AND volume > 0
            AND days_to_expiry >= 365
          GROUP BY expiration_date
          HAVING count() >= 15
      )
  )
ORDER BY strike_price
LIMIT 60