STRASMORE/EXPLORE 2,707 QUERIES

kos_kontrak

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-27, from what-is-a-strike-price.

as of ranking 14×3read in context →
kos_kontrak — 14 rows by 3 columns, computed from US exchange, SIP and OPRA data.
strike_usdexercise_cost_usdpremium_pct
250250009.07
255255007.31
260260005.96
265265004.56
267.5267503.93
270270003.17
272.5272502.77
275275002.28
277.5277501.87
280280001.61
282.5282501.33
285285001.02
287.5287500.84
290290000.67
Rows × columns
14 × 3
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for kos_kontrak, derived from the stored result.
ColumnTypeRangeNotes
strike_usd text 14 distinct values (250, 255, 260…)
exercise_cost_usd number 25,000 to 29,000 US dollars
premium_pct number 0.67 to 9.07 percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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 snapshot AS
(
    SELECT max(date) AS as_of
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'JNJ'
),
expiry_pick AS
(
    SELECT min(expiration_date) AS expiry
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'JNJ'
      AND date = (SELECT as_of FROM snapshot)
      AND days_to_expiry BETWEEN 20 AND 45
      AND volume > 0
)
SELECT
    toString(toFloat64(strike_price))                                     AS strike_usd,
    round(toFloat64(strike_price) * 100, 0)                               AS exercise_cost_usd,
    round(100 * avg(toFloat64(option_close)) / toFloat64(strike_price), 2) AS premium_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'JNJ'
  AND date = (SELECT as_of FROM snapshot)
  AND expiration_date = (SELECT expiry FROM expiry_pick)
  AND lower(option_type) IN ('call', 'c')
  AND iv_converged = 1
  AND volume > 0
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.08
GROUP BY strike_price
ORDER BY toFloat64(strike_price)
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.