septembers_by_year

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-18, from the-september-effect.

Rows × columns

22 × 2

Computed

2026-09-18

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

WITH month_ends AS
(
    SELECT
        toStartOfMonth(date)           AS month_start,
        argMax(toFloat64(close), date) AS month_end_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date < toStartOfYear(today())
    GROUP BY month_start
),
monthly_returns AS
(
    SELECT
        month_start,
        month_end_close,
        lagInFrame(month_end_close, 1) OVER (ORDER BY month_start ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS prev_close
    FROM month_ends
)
SELECT
    toYear(month_start)                                AS year,
    round((month_end_close / prev_close - 1) * 100, 2) AS sep_return_pct
FROM monthly_returns
WHERE prev_close > 0
  AND toMonth(month_start) = 9
ORDER BY year