How to Read an Options Symbol (OSI Format)
One eight-digit field, from single-dollar strikes to index levelstable ·
2026-08-22 · 4×6
One expiration, four strikes: every OSI field cut out of the symboltable ·
2026-08-22 · 8×7
One eight-digit field, from single-dollar strikes to index levels
One eight-digit field, from single-dollar strikes to index levels
| underlying | lowest_strike | lowest_strike_field | highest_strike | highest_strike_field | strike_count |
|---|---|---|---|---|---|
| KO | 32.5 | 00032500 | 135 | 00135000 | 58 |
| NVDA | 0.5 | 00000500 | 460 | 00460000 | 252 |
| AAPL | 5 | 00005000 | 600 | 00600000 | 114 |
| SPY | 50 | 00050000 | 1480 | 01480000 | 452 |
the exact SQL behind every number
SELECT
underlying,
round(toFloat64(min(strike)), 2) AS lowest_strike,
argMin(strike_field, strike) AS lowest_strike_field,
round(toFloat64(max(strike)), 2) AS highest_strike,
argMax(strike_field, strike) AS highest_strike_field,
uniqExact(strike) AS strike_count
FROM
(
SELECT
underlying_symbol AS underlying,
strike_price AS strike,
substring(replaceRegexpOne(ticker, '^O:', ''),
length(replaceRegexpOne(ticker, '^O:', '')) - 7, 8) AS strike_field
FROM global_markets.options_greeks
WHERE underlying_symbol IN ('KO', 'NVDA', 'AAPL', 'SPY', 'SPX')
AND date >= today() - 7
)
GROUP BY underlying
ORDER BY highest_strike ASC
More from this analysisHow to Read an Options Symbol (OSI Format)
One expiration, four strikes: every OSI field cut out of the symbol
table 8×7
→
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
→
See all 2,170 queries →