S&P 500 vs Fed Balance Sheet: Paired Weekly Time Series for Post-GFC Liquidity-Equity Analysis Since 2003

S&P 500 vs Fed Balance Sheet is an Eco3min weekly composite that pairs the S&P 500 price index with Fed total assets (WALCL) on aligned timestamps. From 2009 to 2022, the visual co-movement of these two series defined the post-GFC investment narrative: “stocks follow the Fed’s balance sheet.” This dataset provides the raw paired series required to evaluate that thesis quantitatively rather than rhetorically. Coverage runs from December 2002, when WALCL began on FRED, through 2026.

Dataset: S&P 500 vs Fed Balance Sheet (2003–2026) · Updated —

Source: FRED series SP500 · S&P Dow Jones Indices & Federal Reserve (WALCL) via FRED

Macro Takeaway

Construction & Components

S&P 500 vs Fed Balance Sheet is not a ratio or a derived indicator: it is a paired time series. The Eco3min pipeline aligns two FRED series on a weekly grid (Wednesday close, matching the WALCL release timestamp) to enable direct visual and statistical comparison. A derived ratio column is available in the CSV for users who want a single-line normalization.

Formula:

Paired series:  (date, SP500_t, WALCL_t)
Derived ratio:  SP500_WALCL_Ratio_t = SP500_t / WALCL_t

Components:

• S&P 500 Price Index — FRED series SP500 (S&P Dow Jones Indices via FRED) — daily, sampled at Wednesday close for weekly alignment with WALCL.
• Fed Total Assets (WALCL) — FRED series WALCL (Federal Reserve H.4.1 release) — weekly, Wednesday close, millions of USD. The H.4.1 release is published every Thursday at 4:30 PM ET.

Frequency reconciliation: WALCL is the binding frequency. The S&P 500 is sampled at Wednesday close (the WALCL reference date) rather than Thursday or Friday to avoid look-ahead bias when WALCL is later published. This eliminates the “phantom correlation” that arises when a daily equity series is naively merged onto a weekly balance sheet snapshot using inconsistent timestamps.

Coverage: December 2002–2026, limited by the start of the WALCL series on FRED (December 18, 2002, the first H.4.1 release published in the modern format). For pre-2003 Fed balance sheet analysis, the FRED series WSHOTSL (Total Securities Held Outright) provides a longer but narrower view.

Dataset Overview

Dataset Variables

The CSV and Excel files contain the following columns.

Column names match the CSV headers exactly.

Download the Complete Dataset

The full dataset is available in CSV and Excel formats.

FRED Direct CSV Access

The two FRED series paired in this dataset can be retrieved directly:

https://fred.stlouisfed.org/graph/fredgraph.csv?id=SP500
https://fred.stlouisfed.org/graph/fredgraph.csv?id=WALCL

Direct CSV Access — Eco3min Structured Dataset

https://eco3min.fr/dataset/sp500-vs-fed-balance-sheet.csv

This URL returns the pre-aligned weekly paired series with consistent Wednesday-close timestamps for both components. It can be used directly in pandas, R, curl, or any data tool.

Using the Dataset in Python

import pandas as pd

url = "https://eco3min.fr/dataset/sp500-vs-fed-balance-sheet.csv"
df = pd.read_csv(url, parse_dates=["date"])

print(df.head())
print(df["sp500_level"].describe())

Using the Dataset in R

library(readr)

url <- "https://eco3min.fr/dataset/sp500-vs-fed-balance-sheet.csv"
df <- read_csv(url)

head(df)
summary(df$sp500_level)

Both examples load the dataset directly from the URL — no download or API key required.

Methodology

The S&P 500 vs Fed Balance Sheet paired series is rebuilt weekly by an Eco3min pipeline. WALCL is pulled from FRED after the Thursday H.4.1 release (typically by Thursday 6:00 PM ET); the S&P 500 series is then sampled at the corresponding Wednesday close to align timestamps exactly with the WALCL reference date. The resulting paired observations are appended to the historical series back to December 2002.

Two methodological choices are worth highlighting. First, no interpolation is applied: weeks with no H.4.1 release (e.g., due to a US Federal Reserve holiday) are skipped rather than filled, preserving the integrity of the original release schedule. Second, WALCL is converted from millions of USD (FRED native unit) to trillions for readability in walcl_trillions; the raw FRED value can be reconstructed by multiplying by 1,000,000.

Data Quality & Provider Notes

The S&P 500 vs Fed Balance Sheet dataset inherits the latency profile of WALCL, which is the slower of the two components:

• Weekly H.4.1 cadence. WALCL is published every Thursday at 4:30 PM ET for the prior Wednesday’s balance. The composite for week t is therefore available roughly 24 hours after Wednesday close. Datasets claiming “daily Fed balance sheet” pricing are interpolated, not native.
• Revisions are rare but possible. The Federal Reserve occasionally restates historical H.4.1 figures when accounting classifications change (e.g., reclassification of MBS holdings, securities lending facilities). Any such revision propagates to the historical paired series at the next Eco3min refresh.
• Why the paired format is unique. FRED itself allows users to overlay SP500 and WALCL in its chart tool, but does not publish a pre-aligned, downloadable paired CSV with consistent timestamps. Most practitioners hand-merge the two series, often introducing subtle look-ahead bias by using Thursday or Friday S&P 500 closes against a Wednesday WALCL snapshot. The Eco3min alignment removes this issue.

What This Index Captures (And What It Doesn’t)

This dataset is the empirical input behind one of the most reproduced visual narratives in post-GFC macro: the “stocks follow the Fed’s balance sheet” chart. Reading the paired series with discipline requires distinguishing what is visible from what is causally interpretable. That distinction is developed in where the balance-sheet signal breaks down as a market gauge.

What it captures:

• The contemporaneous co-movement of US equity prices and the Fed’s balance sheet size from the start of QE1 (2008–2009) onward
• Multi-year regimes of QE expansion (2009–2014, 2020–2022) and QT contraction (2018–2019, 2022–2024)
• A common time grid required to compute rolling correlations, regression coefficients, or beta estimates between the two series

What it does NOT capture (common misinterpretations):

• Causality from WALCL to the S&P 500. The paired chart shows correlation, not causation. Multiple counter-examples (2018–2019 QT with rising equities, 2023–2024 QT with rising equities) suggest the mechanical “Fed balance sheet drives stocks” thesis is incomplete. The Eco3min research on the liquidity illusion develops this argument empirically.
• Effective liquidity to the financial system. WALCL measures Fed assets, but the portion of those assets that actually reaches the banking system depends on the Treasury General Account and overnight reverse repo balances. A WALCL increase offset by a TGA build-up is liquidity-neutral, and the Net Liquidity Index captures this offset.
• International liquidity dynamics. The ECB, BoJ, and PBoC operate on independent schedules. During USD funding stress, foreign central bank liquidity (and FIMA repo usage) can dominate domestic WALCL movements for risk asset pricing.
• Equity valuation. Pairing nominal equity prices with the balance sheet says nothing about earnings, multiples, or expected returns. For valuation context, the CAPE Ratio and the Excess CAPE Yield are more appropriate.

The paired series is best used as raw material for testing hypotheses about the equity–liquidity link rather than as a standalone signal.

Historical Regimes

The S&P 500 vs Fed Balance Sheet paired series spans the entire modern Fed balance sheet era. Reading the data through regime breakpoints clarifies where co-movement was strong, where it was not, and what conditions accompanied each phase.

• 2003–2007 — Pre-QE baseline. WALCL was stable around $850 billion. The S&P 500 rose roughly 70% over the period. No mechanical relationship was visible; equity gains reflected the housing-credit cycle, not balance sheet expansion.
• 2008–2009 — GFC and QE1. WALCL more than doubled (from ~$0.9T to ~$2.3T) during the September 2008–March 2009 crisis. The S&P 500 fell ~55% peak-to-trough, then bottomed in March 2009 as QE1 stabilized funding markets.
• 2009–2014 — QE2 and QE3. WALCL rose from ~$2.3T to ~$4.5T while the S&P 500 roughly tripled. This is the period where the “stocks follow the Fed” thesis took hold in markets and financial media.
• 2014–2018 — Stable balance sheet. WALCL plateaued around $4.5T from 2014 to mid-2017. The S&P 500 rose roughly +35% over the period despite no balance sheet expansion, providing the first significant counter-example to mechanical interpretations.
• 2018–2019 — First QT episode. WALCL contracted by ~$700B from ~$4.5T to ~$3.8T. The S&P 500 finished 2018 down ~6% but recovered sharply in 2019 (+29%) despite continued QT until late 2019.
• 2020–2022 — COVID liquidity injection and peak. WALCL surged from ~$4.2T to a peak near $9.0T in April 2022. The S&P 500 doubled from its March 2020 low.
• 2022–2024 — Second QT episode. WALCL contracted from ~$9.0T toward ~$7.0T. The S&P 500 fell roughly −25% in 2022, then recovered to new highs in 2024 despite continued WALCL decline, the largest visible counter-example to the mechanical thesis.
• 2024–2026 — Tapering of QT. The Fed slowed the pace of balance sheet runoff. The S&P 500 continued to rise.

For the analytical decomposition of these regimes — particularly the role of TGA and RRP in explaining the 2018–2019 and 2023–2024 counter-examples — see the Eco3min research on the liquidity illusion.

Related Macroeconomic Datasets

The S&P 500 vs Fed Balance Sheet dataset is best understood alongside its components and alternative formulations of the equity–liquidity relationship.

Related Research

The dataset above is the raw input. The analytical work below explains why pairing SP500 with WALCL alone produces an incomplete picture of the equity–liquidity relationship.

Macroeconomic Dataset Hub

This dataset is part of the Eco3min macro-financial data repository.

Explore the Eco3min Dataset Hub

Sources

• S&P Dow Jones Indices — S&P 500 price index (FRED series SP500)
• Federal Reserve, H.4.1 statistical release — Total assets (FRED series WALCL)

Dataset Reference

Eco3min Research. (2026). S&P 500 vs Fed Balance Sheet (2003–2026).<br> https://eco3min.fr/en/sp500-vs-fed-balance-sheet-dataset/