CPI month-over-month, computed from the index against the prior month

Name: CPI month-over-month, computed from the index against the prior month
Creator: Strasmore
Published: 2026-08-11
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-08-11, from Macro Picture Entering H2 2026, With Receipts.

as of 2026-08-11 ranking 6×3read in context →

CPI month-over-month, computed from the index against the prior month — 6 rows by 3 columns, computed 2026-08-11 from US exchange, SIP and OPRA data.
period_start	headline_mom_pct	core_mom_pct
2026-01-01	0.17	0.3
2026-02-01	0.27	0.22
2026-03-01	0.87	0.2
2026-04-01	0.64	0.38
2026-05-01	0.47	0.21
2026-06-01	-0.42	-0.02

Rows × columns: 6 × 3
Period covered: 2026-01-01 to 2026-06-01
Computed: 2026-08-11
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 CPI month-over-month, computed from the index against the prior month, derived from the stored result.
Column	Type	Range	Notes
`period_start`	date	2026-01-01 to 2026-06-01
`headline_mom_pct`	number	-0.42 to 0.87	percent
`core_mom_pct`	number	-0.02 to 0.38	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 2026-08-11, and the query below is what returned them.

the exact SQL behind every number

SELECT toString(date) AS period_start,
    round((cpi / any(cpi_prev) - 1) * 100, 2) AS headline_mom_pct,
    round((cpi_core / any(core_prev) - 1) * 100, 2) AS core_mom_pct
FROM global_markets.inflation
INNER JOIN (
    SELECT date + INTERVAL 1 MONTH AS match_date, cpi AS cpi_prev, cpi_core AS core_prev
    FROM global_markets.inflation
    WHERE date >= toDate('2025-12-01') AND date <= toDate('2026-05-01')
) AS p ON date = p.match_date
WHERE date >= toDate('2026-01-01') AND date <= toDate('2026-06-01')
GROUP BY date, cpi, cpi_core
ORDER BY date

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisMacro Picture Entering H2 2026, With Receipts

SPY month by month in H1 2026: regular-hours open-to-close return per month ranking 6×4 → Model-based inflation expectations by horizon, monthly ranking 6×4 → The labor market, monthly: unemployment, participation, average hourly earnings, with ingest receipts table 6×5 → The Treasury curve at each month-end of H1 2026: bill, 2-year, 10-year, and the spreads between them table 6×8 → CPI year-over-year, computed from the index against the same month a year earlier table 6×5 → The as-of receipts: every June print on file, the July CPI column armed as the next tripwire scalar 1×5 → See all 2,170 queries →