contract_trace

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 pinned AS
    (
        SELECT ticker
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
          AND date BETWEEN '2026-02-02' AND '2026-03-20'
          AND days_to_expiry BETWEEN 20 AND 60
          AND volume > 0
          AND iv_converged = 1
        GROUP BY ticker
        ORDER BY sum(volume) DESC, ticker
        LIMIT 1
    )
SELECT
    toString(date)                                        AS session_date,
    ticker                                                AS contract_code,
    formatDateTime(toDate(expiration_date), '%b %e, %Y')  AS expiry_label,
    toString(round(toFloat64(option_close), 2))           AS premium_quote,
    round(toFloat64(option_close) * 100, 0)               AS cost_per_lot,
    toUInt64(volume)                                      AS volume
FROM global_markets.options_greeks
WHERE ticker = (SELECT ticker FROM pinned)
  AND date BETWEEN '2026-02-02' AND '2026-03-20'
ORDER BY date