STRASMORE/EXPLORE 3,293 QUERIES
Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan

gamma_wall

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-11-07, from what-is-a-gamma-squeeze.

as of ranking 11×4read in context →
gamma_wall — 11 rows by 4 columns, computed from US exchange, SIP and OPRA data.
strikeas_ofcall_gamma_sharescall_volume
1752026年11月6日37252472
1802026年11月6日38541648
182.52026年11月6日66862044
1852026年11月6日4647311834
187.52026年11月6日8121117585
1902026年11月6日20197946991
192.52026年11月6日8419820919
1952026年11月6日17607157496
197.52026年11月6日7323729251
2002026年11月6日15743177972
202.52026年11月6日5328432473
Rows × columns
11 × 4
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 gamma_wall, derived from the stored result.
ColumnTypeRangeNotes
strike number 175 to 202.5 US dollars
as_of text 1 distinct value (2026年11月6日)
call_gamma_shares number 3,725 to 201,979 count
call_volume number 1,648 to 77,972 count

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 (
    SELECT max(date)
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'NVDA'
      AND date >= today() - 30
) AS latest_day
SELECT
    round(toFloat64(strike_price), 2)                                      AS strike,
    concat(toString(toYear(latest_day)), '年',
           toString(toMonth(latest_day)), '月',
           toString(toDayOfMonth(latest_day)), '日')                        AS as_of,
    round(sum(toFloat64(gamma) * toFloat64(volume)) * 100, 0)               AS call_gamma_shares,
    round(sum(toFloat64(volume)), 0)                                        AS call_volume
FROM global_markets.options_greeks
WHERE underlying_symbol = 'NVDA'
  AND option_type IN ('call', 'C')
  AND date = latest_day
  AND iv_converged = 1
  AND volume > 0
  AND days_to_expiry BETWEEN 1 AND 10
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.08
GROUP BY strike
HAVING sum(volume) > 1000
ORDER BY strike
⌘/Ctrl + Enter

Work with this data in your AI assistant

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