pente_par_annee

Name: pente_par_annee
Creator: Strasmore
Published: 2026-09-26
License: https://www.strasmore.com/terms/

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-09-26, from what-is-the-skew-stickiness-ratio.

as of 2026-09-26 table 6×5read in context →

pente_par_annee — 6 rows by 5 columns, computed 2026-09-26 from US exchange, SIP and OPRA data.
year	session_count	pente_vol_pts	pente_fr	correlation
2021	84	-1.81	1,81	-0.9
2022	251	-0.86	0,86	-0.82
2023	250	-0.83	0,83	-0.75
2024	252	-1.04	1,04	-0.8
2025	250	-1.4	1,4	-0.9
2026	166	-1.2	1,2	-0.81

Rows × columns: 6 × 5
Computed: 2026-09-26
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 pente_par_annee, derived from the stored result.
Column	Type	Range	Notes
`year`	text	6 distinct values (2021, 2022, 2023…)
`session_count`	number	84 to 252	count
`pente_vol_pts`	number	-1.81 to -0.83
`pente_fr`	text	6 distinct values (0,83, 0,86, 1,04…)
`correlation`	number	-0.9 to -0.75

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 2026-09-26, 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 iv_atm AS (
    SELECT
        date,
        avg(toFloat64(implied_volatility)) * 100 AS iv_pct
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date >= '2021-09-01'
      AND date <  '2026-09-01'
      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.02
    GROUP BY date
),
spot AS (
    SELECT
        date,
        toFloat64(close) AS px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2021-09-01'
      AND date <  '2026-09-01'
),
apparie AS (
    SELECT
        i.date   AS d,
        i.iv_pct AS iv,
        s.px     AS px,
        any(i.iv_pct) OVER (ORDER BY i.date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS iv_prec,
        any(s.px)     OVER (ORDER BY i.date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS px_prec
    FROM iv_atm AS i
    INNER JOIN spot AS s ON s.date = i.date
),
variations AS (
    SELECT
        toYear(d)                AS y,
        (px / px_prec - 1) * 100 AS rendement_pct,
        iv - iv_prec             AS iv_variation_pct
    FROM apparie
    WHERE px_prec > 0
)
SELECT
    toString(y)                                                     AS year,
    count()                                                         AS session_count,
    round(covarPop(rendement_pct, iv_variation_pct)
          / varPop(rendement_pct), 2)                               AS pente_vol_pts,
    replace(toString(round(abs(covarPop(rendement_pct, iv_variation_pct)
          / varPop(rendement_pct)), 2)), '.', ',')                   AS pente_fr,
    round(corr(rendement_pct, iv_variation_pct), 2)                 AS correlation
FROM variations
GROUP BY y
HAVING count() > 20
ORDER BY y

SQL to run

WITH iv_atm AS (
    SELECT
        date,
        avg(toFloat64(implied_volatility)) * 100 AS iv_pct
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date >= '2021-09-01'
      AND date <  '2026-09-01'
      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.02
    GROUP BY date
),
spot AS (
    SELECT
        date,
        toFloat64(close) AS px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2021-09-01'
      AND date <  '2026-09-01'
),
apparie AS (
    SELECT
        i.date   AS d,
        i.iv_pct AS iv,
        s.px     AS px,
        any(i.iv_pct) OVER (ORDER BY i.date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS iv_prec,
        any(s.px)     OVER (ORDER BY i.date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS px_prec
    FROM iv_atm AS i
    INNER JOIN spot AS s ON s.date = i.date
),
variations AS (
    SELECT
        toYear(d)                AS y,
        (px / px_prec - 1) * 100 AS rendement_pct,
        iv - iv_prec             AS iv_variation_pct
    FROM apparie
    WHERE px_prec > 0
)
SELECT
    toString(y)                                                     AS year,
    count()                                                         AS session_count,
    round(covarPop(rendement_pct, iv_variation_pct)
          / varPop(rendement_pct), 2)                               AS pente_vol_pts,
    replace(toString(round(abs(covarPop(rendement_pct, iv_variation_pct)
          / varPop(rendement_pct)), 2)), '.', ',')                   AS pente_fr,
    round(corr(rendement_pct, iv_variation_pct), 2)                 AS correlation
FROM variations
GROUP BY y
HAVING count() > 20
ORDER BY y

⌘/Ctrl + Enter

Travaillez ces données dans votre assistant IA

S'ouvre prêt à interroger, avec les données de cette page. Gratuit, sans compte.

Claude ChatGPT Gemini Muse Votre propre agent