STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Equity vs Index Put/Call Ratio: What's High?
The total is a call-volume-weighted blend of the two bucketsranking · 2026-08-22 · 11×4Preview: 11 ranked values, largest first. The same equity ratio, computed with and without ETF optionsseries · 2026-08-22 · 23×4Preview: a 16-point series, ending lower. Single-stock bucket vs ETF bucket, session by sessionseries · 2026-08-22 · 33×6Preview: a 16-point series, roughly flat. Put/call volume ratio by underlying, trailing 60 sessionstable · 2026-08-22 · 12×5
What Is the Put-Call Ratio? A Data Guide
A decade of SPY put-call ratios: median, low and high of the daily reading by yeartable · 2026-08-11 · 12×5 Put-call ratio by underlying: five of the most active names, June 2026ranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest first. Market-wide put-call ratio by day: every listed US option, June 1 through July 10, 2026series · 2026-08-11 · 28×4Preview: a 16-point series, ending lower. The June 2026 put-call range: median, high and low of the daily market-wide ratioscalar · 2026-08-11 · 1×50.793 Index-linked vs single-stock options: put-call ratio by population, June 2026ranking · 2026-08-11 · 3×4Preview: 3 ranked values, largest first. Put-call ratio by days to expiration: every listed US option, June 2026ranking · 2026-08-11 · 5×4Preview: 5 ranked values, largest first.
Is a High Put/Call Ratio Bullish?
Put/call volume ratio percentiles: single-stock basket vs index ETFs, 2022 to July 2026ranking · 2026-08-03 · 8×3Preview: 8 ranked values, smallest first. S&P 500 tracker moves after each fifth of the equity put/call ratio, 2022 to July 2026table · 2026-08-03 · 5×7 Put/call volume ratio by underlying: January 1 to July 31, 2026ranking · 2026-08-03 · 13×4Preview: 13 ranked values, largest first. Top-decile put/call readings per month, grouped by how the S&P 500 tracker movedranking · 2026-08-03 · 4×4Preview: 4 ranked values, smallest first.
The total is a call-volume-weighted blend of the two buckets

The total is a call-volume-weighted blend of the two buckets

most recentas of ranking 11×4read in context →
The total is a call-volume-weighted blend of the two buckets — 11 rows by 4 columns, computed from US exchange, SIP and OPRA data.
index_share_of_call_volumeequity_ratioindex_ratioblended_total_ratio
0%0.5561.3960.556
10%0.5561.3960.64
20%0.5561.3960.724
30%0.5561.3960.808
40%0.5561.3960.892
50%0.5561.3960.976
60%0.5561.3961.06
70%0.5561.3961.144
80%0.5561.3961.228
90%0.5561.3961.312
100%0.5561.3961.396
the exact SQL behind every number 
WITH components AS
(
    SELECT
        round(sumIf(volume, startsWith(lower(option_type), 'p') AND underlying_symbol NOT IN ('SPY', 'QQQ', 'IWM', 'DIA'))
              / sumIf(volume, startsWith(lower(option_type), 'c') AND underlying_symbol NOT IN ('SPY', 'QQQ', 'IWM', 'DIA')), 3) AS equity_ratio,
        round(sumIf(volume, startsWith(lower(option_type), 'p') AND underlying_symbol IN ('SPY', 'QQQ', 'IWM', 'DIA'))
              / sumIf(volume, startsWith(lower(option_type), 'c') AND underlying_symbol IN ('SPY', 'QQQ', 'IWM', 'DIA')), 3) AS index_ratio
    FROM global_markets.options_greeks
    WHERE date >= (SELECT toDate(max(date))
                   FROM global_markets.options_greeks
                   WHERE volume > 0) - 60
      AND volume > 0
      AND underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'TSLA', 'JPM', 'KO', 'JNJ',
                                'SPY', 'QQQ', 'IWM', 'DIA')
    HAVING sumIf(volume, startsWith(lower(option_type), 'c') AND underlying_symbol IN ('SPY', 'QQQ', 'IWM', 'DIA')) > 0
       AND sumIf(volume, startsWith(lower(option_type), 'c') AND underlying_symbol NOT IN ('SPY', 'QQQ', 'IWM', 'DIA')) > 0
)
SELECT
    concat(toString(step * 10), '%')                                    AS index_share_of_call_volume,
    equity_ratio,
    index_ratio,
    round(equity_ratio + (index_ratio - equity_ratio) * (step / 10), 3) AS blended_total_ratio
FROM
(
    SELECT
        equity_ratio,
        index_ratio,
        arrayJoin(range(11)) AS step
    FROM components
)
ORDER BY step
More from this analysisEquity vs Index Put/Call Ratio: What's High?
Single-stock bucket vs ETF bucket, session by session series 33×6 → The same equity ratio, computed with and without ETF options series 23×4 → Put/call volume ratio by underlying, trailing 60 sessions table 12×5 → Put/call volume ratio by underlying: January 1 to July 31, 2026 ranking 13×4 → See all 2,170 queries →
$