jejak_kontrak

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 = 'JNJ'
      AND lower(option_type) IN ('call', 'c')
      AND expiration_date BETWEEN '2026-06-15' AND '2026-06-30'
      AND date BETWEEN '2026-03-02' AND '2026-06-19'
      AND volume > 0
    GROUP BY ticker
    ORDER BY sum(volume) DESC, ticker ASC
    LIMIT 1
)
SELECT
    toString(date)                             AS date,
    any(ticker)                                AS contract,
    round(avg(toFloat64(underlying_close)), 2) AS spot_usd,
    round(avg(toFloat64(strike_price)), 2)     AS strike_usd
FROM global_markets.options_greeks
WHERE underlying_symbol = 'JNJ'
  AND ticker = (SELECT ticker FROM pinned)
  AND date BETWEEN '2026-03-02' AND '2026-06-19'
GROUP BY date
ORDER BY date