STRASMORE/EXPLORE 2,170 QUERIES

One expiration, four strikes: every OSI field cut out of the symbol

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-08-22, from How to Read an Options Symbol (OSI Format).

as of table 8×7read in context →
One expiration, four strikes: every OSI field cut out of the symbol — 8 rows by 7 columns, computed from US exchange, SIP and OPRA data.
contractrootexpiry_fieldright_codestrike_fieldstrike_dollarslisted_expiration
SPY260116C00500000SPY260116C00500000500Jan 16, 2026
SPY260116P00500000SPY260116P00500000500Jan 16, 2026
SPY260116C00600000SPY260116C00600000600Jan 16, 2026
SPY260116P00600000SPY260116P00600000600Jan 16, 2026
SPY260116C00650000SPY260116C00650000650Jan 16, 2026
SPY260116P00650000SPY260116P00650000650Jan 16, 2026
SPY260116C00700000SPY260116C00700000700Jan 16, 2026
SPY260116P00700000SPY260116P00700000700Jan 16, 2026
Rows × columns
8 × 7
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 One expiration, four strikes: every OSI field cut out of the symbol, derived from the stored result.
ColumnTypeRangeNotes
contract text 8 distinct values
root text 1 distinct value (SPY)
expiry_field text 1 distinct value (260116)
right_code text 2 distinct values (C, P)
strike_field text 4 distinct values (00500000, 00600000, 00650000…)
strike_dollars number 500 to 700 US dollars
listed_expiration text 1 distinct value (Jan 16, 2026)

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.

the exact SQL behind every number 
SELECT
    contract,
    substring(contract, 1, length(contract) - 15)                  AS root,
    substring(contract, length(contract) - 14, 6)                  AS expiry_field,
    substring(contract, length(contract) - 8, 1)                   AS right_code,
    substring(contract, length(contract) - 7, 8)                   AS strike_field,
    toFloat64(substring(contract, length(contract) - 7, 8)) / 1000 AS strike_dollars,
    listed_expiration
FROM
(
    SELECT
        replaceRegexpOne(ticker, '^O:', '')               AS contract,
        formatDateTime(any(expiration_date), '%b %e, %Y') AS listed_expiration
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND expiration_date = '2026-01-16'
      AND toFloat64(strike_price) IN (500, 600, 650, 700)
      AND date >= '2025-12-01'
      AND date <  '2026-01-01'
    GROUP BY contract
)
ORDER BY strike_dollars ASC, right_code ASC

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisHow to Read an Options Symbol (OSI Format)
One eight-digit field, from single-dollar strikes to index levels table 4×6 → One expiration of the SPY chain: closing prices and delta by strike, August 21 2026 expiry, as of July 15 2026 table 8×6 → Median quoted bid and ask by strike: SPY calls expiring August 21 2026, regular session of July 15 2026 table 7×5 → Implied volatility by strike: SPY options expiring August 21 2026, as of July 15 2026 ranking 11×3 → Where the trading happened: SPY contract volume by strike, August 21 2026 expiry, July 15 2026 ranking 8×3 → SPY option volume by time to expiration, July 15 2026 ranking 5×4 → See all 2,170 queries →