option chain — 7 answered market questions

One eight-digit field, from single-dollar strikes to index levels

most recentas of 2026-08-22 table 4×6read in context →

One eight-digit field, from single-dollar strikes to index levels — 4 rows by 6 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
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 →