SPY through July 2024 against a level 2% above the July 1 close

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-08-07, from Probability of Touch vs Probability ITM.

Rows × columns

28 × 6

Period covered

2024-07-01 to 2024-08-08

Computed

2026-08-07

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

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-08-07, and the query below is what returned them.

WITH
    bars AS (
        SELECT
            date,
            any(toFloat64(close)) AS c,
            max(toFloat64(high))  AS h
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date BETWEEN '2024-07-01' AND '2024-08-08'
        GROUP BY date
    ),
    anchor AS (
        SELECT argMin(c, date) * 1.02 AS lvl
        FROM bars
    )
SELECT
    toString(b.date)                  AS session_date,
    round(b.c, 2)                     AS spy_close,
    round(b.h, 2)                     AS spy_high,
    round(a.lvl, 2)                   AS strike_level,
    round(100 * (b.c / a.lvl - 1), 2) AS close_vs_level_pct,
    round(100 * (max(b.h) OVER (ORDER BY b.date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) / a.lvl - 1), 2) AS run_max_vs_level_pct
FROM bars AS b
CROSS JOIN anchor AS a
ORDER BY b.date