payoff

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
    venc AS (
        SELECT expiration_date AS exp
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
          AND date = '2026-06-12'
          AND iv_converged = 1
          AND volume > 0
          AND days_to_expiry BETWEEN 20 AND 75
        GROUP BY expiration_date
        ORDER BY sum(volume) DESC
        LIMIT 1
    ),
    marks AS (
        SELECT
            toFloat64(strike_price)          AS strike,
            avg(toFloat64(option_close))     AS mark,
            avg(toFloat64(underlying_close)) AS spot
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
          AND date = '2026-06-12'
          AND expiration_date IN (SELECT exp FROM venc)
          AND lower(toString(option_type)) IN ('call', 'c')
          AND iv_converged = 1
          AND volume > 0
        GROUP BY strike
    ),
    anchor AS (
        SELECT max(strike) AS k1
        FROM marks
        WHERE modulo(toUInt32(round(strike * 100)), 500) = 0
          AND strike <= spot
    ),
    legs AS (
        SELECT
            a.k1   AS k1,
            l.mark AS p_baixa,
            b.mark AS p_corpo,
            u.mark AS p_alta,
            s.mark AS p_simetrica
        FROM anchor AS a
        CROSS JOIN marks AS l
        CROSS JOIN marks AS b
        CROSS JOIN marks AS u
        CROSS JOIN marks AS s
        WHERE l.strike = a.k1
          AND b.strike = a.k1 + 5
          AND u.strike = a.k1 + 15
          AND s.strike = a.k1 + 10
    ),
    grade AS (SELECT arrayJoin(range(0, 19)) AS passo)
SELECT
    round(preco, 2) AS preco_no_vencimento_usd,
    round(greatest(preco - k1, 0)
        - 2 * greatest(preco - k1 - 5, 0)
        + greatest(preco - k1 - 15, 0)
        + caixa_quebrada, 2) AS asa_quebrada_usd,
    round(greatest(preco - k1, 0)
        - 2 * greatest(preco - k1 - 5, 0)
        + greatest(preco - k1 - 10, 0)
        + caixa_simetrica, 2) AS simetrica_usd
FROM
(
    SELECT
        p.k1                                      AS k1,
        p.k1 - 15 + 2.5 * g.passo                 AS preco,
        2 * p.p_corpo - p.p_baixa - p.p_alta      AS caixa_quebrada,
        2 * p.p_corpo - p.p_baixa - p.p_simetrica AS caixa_simetrica
    FROM legs AS p
    CROSS JOIN grade AS g
)
ORDER BY preco_no_vencimento_usd