Ten-year US inflation rate and the time to halve a dollar's purchasing power

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 yearly AS
(
    SELECT
        toYear(date)        AS year,
        toYear(date) + 10   AS decade_later,
        avg(toFloat64(cpi)) AS cpi_avg
    FROM global_markets.inflation
    WHERE date >= '1990-01-01'
      AND date <  '2026-01-01'
      AND cpi > 0
    GROUP BY year, decade_later
),
windows AS
(
    SELECT
        recent.year                             AS year,
        pow(recent.cpi_avg / base.cpi_avg, 0.1) AS annual_factor
    FROM yearly AS base
    INNER JOIN yearly AS recent ON recent.year = base.decade_later
)
SELECT
    year,
    round((annual_factor - 1) * 100, 2)          AS inflation_rate_pct,
    round(log(2) / log(annual_factor), 1)        AS exact_halving_years,
    round(72.0 / ((annual_factor - 1) * 100), 1) AS rule_of_72_years
FROM windows
ORDER BY year ASC