STRASMORE/EXPLORE 3,293 QUERIES

ZM at-the-money IV before and on the biggest one-session drop in each quarter

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 ZM Implied Volatility: Zoom IV and Earnings.

as of table 9×5read in context →
ZM at-the-money IV before and on the biggest one-session drop in each quarter — 9 rows by 5 columns, computed from US exchange, SIP and OPRA data.
labeliv_two_weeks_pctiv_peak_pctiv_after_pctcrush_pct
Nov 26, 202452.465.629.336.3
Feb 25, 202549.350.833.916.9
May 22, 202542.942.829.313.5
Aug 22, 202540.841.727.913.8
Nov 25, 2025454233.78.3
Feb 26, 202653.954.440.813.6
May 21, 202663.46541.223.8
Aug 26, 202649.352.440.312.1
Nov 5, 202645.158.554.34.2
Rows × columns
9 × 5
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 ZM at-the-money IV before and on the biggest one-session drop in each quarter, derived from the stored result.
ColumnTypeRangeNotes
label text 9 distinct values (Aug 22, 2025, Aug 26, 2026, Feb 25, 2025…)
iv_two_weeks_pct number 40.8 to 63.4 percent
iv_peak_pct number 41.7 to 65.6 percent
iv_after_pct number 27.9 to 54.3 percent
crush_pct number 4.2 to 36.3 percent

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 atm_daily AS
(
    SELECT
        date,
        round(100 * avg(toFloat64(implied_volatility)), 1) AS iv_pct
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'ZM'
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 20 AND 45
      AND toFloat64(underlying_close) > 0
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
    GROUP BY date
),
seq AS
(
    SELECT
        date,
        iv_pct,
        toInt64(rn_raw) AS rn
    FROM
    (
        SELECT
            date,
            iv_pct,
            row_number() OVER (ORDER BY date) AS rn_raw
        FROM atm_daily
    )
),
events AS
(
    SELECT
        c.date                        AS crush_date,
        p.iv_pct                      AS iv_two_weeks_pct,
        b.iv_pct                      AS iv_peak_pct,
        c.iv_pct                      AS iv_after_pct,
        round(b.iv_pct - c.iv_pct, 1) AS crush_pct,
        row_number() OVER (PARTITION BY toStartOfQuarter(c.date) ORDER BY b.iv_pct - c.iv_pct DESC) AS quarter_rank
    FROM seq AS c
    INNER JOIN seq AS b ON b.rn = c.rn - 1
    INNER JOIN seq AS p ON p.rn = c.rn - 10
)
SELECT
    formatDateTime(crush_date, '%b %e, %Y') AS label,
    iv_two_weeks_pct,
    iv_peak_pct,
    iv_after_pct,
    crush_pct
FROM events
WHERE quarter_rank = 1
  AND crush_pct > 0
  AND crush_date >= today() - 760
ORDER BY crush_date
⌘/Ctrl + Enter

Work with this data in your AI assistant

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

More from this analysisZM Implied Volatility: Zoom IV and Earnings
ZM at-the-money IV by calendar year: average, low and high table 8×5 → ZM at-the-money 30-day implied volatility, recent sessions series 85×4 → ZM at-the-money IV by days to expiry, most recent week of data ranking 5×4 → Where IV percentile sits furthest above IV rank, latest session table 12×6 → The same reading against each name's own 52-week implied volatility range (July 28, 2026) table 11×5 → How the screened universe distributes across IV rank, latest session table 10×7 → See all 3,293 queries →