STRASMORE/EXPLORE 3,171 QUERIES

iv_trend

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-10-07, from how-to-read-a-crypto-option-chain.

as of series 28×4read in context →
iv_trend — 28 rows by 4 columns, computed from US exchange, SIP and OPRA data.
weekweek_labelibit_iv_pctcoin_iv_pct
2026-03-30Mar 305073.3
2026-04-06Apr 644.574.7
2026-04-13Apr 1344.476.3
2026-04-20Apr 204378.9
2026-04-27Apr 2740.375.5
2026-05-04May 439.573.7
2026-05-11May 1138.871.3
2026-05-18May 1836.766.8
2026-05-25May 2535.565.8
2026-06-01Jun 144.271.6
2026-06-08Jun 84470.8
2026-06-15Jun 153967.2
2026-06-22Jun 2242.571.3
2026-06-29Jun 2941.274.6
2026-07-06Jul 637.678.5
2026-07-13Jul 1336.481
2026-07-20Jul 2036.981
2026-07-27Jul 2736.377.7
2026-08-03Aug 333.870.5
2026-08-10Aug 1033.962.2
2026-08-17Aug 1737.365.5
2026-08-24Aug 2440.665.4
2026-08-31Aug 3138.365.1
2026-09-07Sep 739.266.1
2026-09-14Sep 1437.666.1
2026-09-21Sep 2138.165.6
2026-09-28Sep 2836.264.7
2026-10-05Oct 536.363.9
Rows × columns
28 × 4
Period covered
to
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 iv_trend, derived from the stored result.
ColumnTypeRangeNotes
week date 2026-03-30 to 2026-10-05
week_label text 28 distinct values (Apr 13, Apr 20, Apr 27…)
ibit_iv_pct number 33.8 to 50 percent
coin_iv_pct number 62.2 to 81 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.

SELECT
    toStartOfWeek(date, 1)                                              AS week,
    any(formatDateTime(toStartOfWeek(date, 1), '%b %e'))                AS week_label,
    round(avgIf(implied_volatility, underlying_symbol = 'IBIT') * 100, 1) AS ibit_iv_pct,
    round(avgIf(implied_volatility, underlying_symbol = 'COIN') * 100, 1) AS coin_iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol IN ('IBIT', 'COIN')
  AND date >= today() - 189
  AND iv_converged = 1
  AND volume > 0
  AND days_to_expiry BETWEEN 20 AND 45
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
GROUP BY week
HAVING countIf(underlying_symbol = 'IBIT') > 0
   AND countIf(underlying_symbol = 'COIN') > 0
ORDER BY week
⌘/Ctrl + Enter

இந்தத் தரவுடன் உங்கள் AI உதவியாளரில் வேலை செய்யுங்கள்

இந்தப் பக்கத்தின் தரவுடன், வினவத் தயாராகத் திறக்கும். இலவசம், கணக்கு தேவையில்லை.