STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

The Rule of 72 (and Where It Breaks)
An 8% average return at rising volatility: compound rate and doubling timeranking · 2026-10-09 · 8×3Preview: 8 ranked values, largest first. Rule of 72 against the exact doubling time, by annual returnranking · 2026-10-09 · 11×4Preview: 11 ranked values, largest first. Average return against compound return, five price histories, 2015 through 2024ranking · 2026-10-09 · 5×4Preview: 5 ranked values, smallest first. Ten-year US inflation rate and the time to halve a dollar's purchasing powertable · 2026-10-09 · 26×4 Years to double: the Rule of 72 on the average against the compounded pathtable · 2026-10-09 · 5×5
Local Volatility vs Implied Volatility
SPY at-the-money and downside implied volatility across expiry bands, September 2026ranking · 2026-10-09 · 5×4Preview: 5 ranked values, smallest first. SPY implied volatility by strike distance from spot, 20 to 45 day expiries, September 2026ranking · 2026-10-09 · 7×3Preview: 7 ranked values, largest first. SPY at-the-money implied volatility and downside skew spread, week by week, 2026series · 2026-10-09 · 39×4Preview: a 16-point series, ending lower. Forward volatility embedded in the SPY monthly expiry curve, last week of September 2026series · 2026-10-09 · 5×4Preview: a 5-point series, ending higher.
Highest IV Rank Stocks Right Now
Where IV percentile sits furthest above IV rank, latest sessiontable · 2026-10-08 · 12×6 How the screened universe distributes across IV rank, latest sessiontable · 2026-10-08 · 10×7 The top-ranked name's implied volatility by week, with its 52-week high and lowseries · 2026-10-08 · 53×4Preview: a 16-point series, roughly flat. Highest IV rank, screened US underlyings, latest options sessionseries · 2026-10-08 · 15×7Preview: a 15-point series, ending lower. IV rank and IV percentile for twelve widely held tickers, latest sessionseries · 2026-10-08 · 12×7Preview: a 12-point series, roughly flat.
Why VIX Options Don't Track the VIX
SPY near-the-money implied volatility by distance to expirationranking · 2026-10-04 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-10-04 · 81×3Preview: a 16-point series, ending lower. The near-to-far implied volatility gap across liquid namesranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
Why Stocks Halt: Limit Up-Limit Down Bands
Where listed symbols sit by price, and which band rule governs each zoneranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-10-04 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first.
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-10-04 · 14×5Preview: a 14-point series, roughly flat. SPY option volume by expiration through one session, June 17 2026series · 2026-10-04 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-10-04 · 8×4Preview: 8 ranked values, smallest first.
What Is a High VIX? Levels and Extremes
SPY realized volatility by calendar year, with the biggest day and the count of 2%+ sessionsranking · 2026-10-04 · 23×4Preview: 16 ranked values, smallest first. SPY daily closes from the VIX record close (March 16, 2020) through March 27series · 2026-10-04 · 10×4Preview: a 10-point series, ending higher. SPY on August 5, 2024, in half-hour buckets (ET): the low and the close of eachseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. SPY 30-day at-the-money implied volatility, sessions per VIX-style rungranking · 2026-10-04 · 4×4Preview: 4 ranked values, largest first.
Volatility Targeting for Position Sizing
SPY realised volatility by month against a 10% targetseries · 2026-10-04 · 72×4Preview: a 16-point series, roughly flat. What the lookback window costs in daily turnover (SPY, 10% target, 2x cap)ranking · 2026-10-04 · 4×4Preview: 4 ranked values, largest first. One 10% risk budget, six names, six different weightsranking · 2026-10-04 · 6×4Preview: 6 ranked values, smallest first. Weekly realised volatility and the weight it implied, Nov 2019 to Apr 2020series · 2026-10-04 · 25×4Preview: a 16-point series, ending lower.
How VIX Settlement Works: the SOQ
Listed versus traded strikes by moneyness (SPY, Sep 18 2026 expiry, as of Aug 14 2026)ranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first. Upcoming VIX settlement dates and the SPX expiry each one usesseries · 2026-10-04 · 13×5Preview: a 13-point series, ending higher. Average high to low range by minute, first half hour (SPY, trailing ~4 months)series · 2026-10-04 · 30×3Preview: a 16-point series, ending lower. Expirations three to six weeks out on a pinned session (SPY, Aug 14 2026)series · 2026-10-04 · 3×4Preview: a 3-point series, ending higher.
TSLA Implied Volatility: IV Now & Its History
TSLA ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. TSLA vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. TSLA at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
The Low-Volatility Anomaly
Growth of $100: a calm name (KO), the market (SPY), a wild name (NVDA), weeklyseries · 2026-10-04 · 114×4Preview: a 16-point series, ending higher. Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years)ranking · 2026-10-04 · 25×3Preview: 16 ranked values, smallest first. Volatility thirds: median return, and the range from worst to best name in eachtable · 2026-10-04 · 3×6
SPY Implied Volatility: IV Now & Its History
SPY ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. SPY vs QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×3Preview: a 16-point series, ending lower. SPY at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, roughly flat.
QQQ Implied Volatility: IV Now & Its History
QQQ ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. QQQ vs SPY: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×3Preview: a 16-point series, ending lower. QQQ at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
PLTR Implied Volatility: IV Now & Its History
PLTR ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. PLTR vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. PLTR at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
NVDA Implied Volatility: IV Now & Its History
NVDA ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. NVDA vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. NVDA at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
MSTR Implied Volatility: IV Now & Its History
MSTR ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. MSTR vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. MSTR at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
MSFT Implied Volatility: IV Now & Its History
MSFT ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. MSFT vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. MSFT at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
META Implied Volatility: IV Now & Its History
META ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. META vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. META at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, roughly flat.
The Lowest-Volatility Stocks
The calmest large caps: annualized realized volatility over the past year, lowest firstranking · 2026-10-04 · 15×2Preview: 15 ranked values, smallest first. Maximum drawdown of the calmest names: the worst peak-to-trough fall over the past yearranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first.
IV Rank vs IV Percentile: Formulas Explained
IV rank vs IV percentile, eight liquid names, 52 week lookbacktable · 2026-10-04 · 8×5 The same session scored at five different lookback windowsranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. Current, 52 week low and 52 week high ATM IV for each nametable · 2026-10-04 · 8×6 AAPL at the money implied volatility, weekly, trailing 52 weeksseries · 2026-10-04 · 53×5Preview: a 16-point series, roughly flat. One stock, one session, three definitions of the IV inputtable · 2026-10-04 · 3×6
Historical Volatility vs Implied Volatility
SPY: monthly implied volatility against the next month's realized volatilityseries · 2026-10-04 · 18×4Preview: a 16-point series, ending higher. Average implied volatility against next-month realized volatility, by nametable · 2026-10-04 · 6×5 Annualized historical volatility over three lookback windowsranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first. AAPL realized volatility: 20-session against 60-session lookbackseries · 2026-10-04 · 72×3Preview: a 16-point series, ending higher.
The Real Risk of One Stock
Annualized volatility: the S&P 500 index versus six single stocks (last ~250 sessions)ranking · 2026-10-04 · 7×2Preview: 7 ranked values, smallest first. Same $100 invested: one single stock versus the S&P 500 index, indexed to 100series · 2026-10-04 · 14×3Preview: a 14-point series, ending lower. Maximum drawdown: deepest peak-to-trough drop over the last yearranking · 2026-10-04 · 7×2Preview: 7 ranked values, smallest first.
COIN Implied Volatility: IV Now & Its History
COIN ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. COIN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. COIN at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
AMZN Implied Volatility: IV Now & Its History
AMZN ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. AMZN at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
AMD Implied Volatility: IV Now & Its History
AMD ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. AMD vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. AMD at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
AAPL Implied Volatility: IV Now & Its History
AAPL ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. AAPL vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. AAPL at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, roughly flat.
When Do VIX Futures Expire? 2026 Dates
The walk-back arithmetic, step by step, for four contractstable · 2026-10-01 · 4×7 Contract months since 2015 that did not settle on a Wednesdaytable · 2026-10-01 · 5×4 Days between consecutive VIX futures settlements, 2026 cycleseries · 2026-10-01 · 12×3Preview: a 12-point series, ending lower. VIX futures final settlement dates, 2026 monthly contractsseries · 2026-10-01 · 12×5Preview: a 12-point series, ending lower.
Why Trading Volume Dies at Midday: U-Shape
Share of regular-session volume by half hour, SPY and AAPLseries · 2026-09-28 · 13×3Preview: a 13-point series, ending lower. Average one-minute SPY range in basis points, by half hourseries · 2026-09-28 · 13×3Preview: a 13-point series, ending lower. SPY open, midday and close volume against an average minute, by yearranking · 2026-09-28 · 8×4Preview: 8 ranked values, smallest first. Open, midday and close volume against an average session minuteranking · 2026-09-28 · 6×4Preview: 6 ranked values, smallest first.
What Is the TTM Squeeze? Formula and Limits
Bollinger width against Keltner width, KO, first quarter 2026series · 2026-09-27 · 61×5Preview: a 16-point series, ending higher.
page 1 of 2
An 8% average return at rising volatility: compound rate and doubling time

An 8% average return at rising volatility: compound rate and doubling time

most recentas of ranking 8×3read in context →
An 8% average return at rising volatility: compound rate and doubling time — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
annual_volatilitycompound_return_pctdoubling_years
0%89
5%7.889.1
10%7.59.6
15%6.8810.4
20%611.9
25%4.8814.6
30%3.520.1
35%1.8837.3
the exact SQL behind every number
SELECT
    concat(toString(vol_pct), '%')       AS annual_volatility,
    round(compound * 100, 2)             AS compound_return_pct,
    round(log(2) / log(1 + compound), 1) AS doubling_years
FROM
(
    SELECT
        vol_pct,
        0.08 - 0.5 * pow(vol_pct / 100.0, 2) AS compound
    FROM
    (
        SELECT arrayJoin([0, 5, 10, 15, 20, 25, 30, 35]) AS vol_pct
    )
)
ORDER BY vol_pct ASC
$