Data Dictionary

Data Dictionary#

Every dataset this book uses, documented in one place: the data provider, sample years and frequency, the build_data/ notebook that regenerates the file, and every page of the book that relies on it. Click any dataset in the tables below for its detail page.

Students access course data through the course Box folder linked from the course site — the repository and this site do not ship the data files themselves. These listings document where each dataset comes from and how it is rebuilt.


Datasets#

Click a dataset for its detail page: provider, sample, how to rebuild it, and every page that uses it.

Dataset

Source

Years

Freq

Vintage

Used by

barnstable_analysis_data.xlsx

CRSP

1926-2025

M

rolling

3 pages

crsp_corp_fin_2013.xlsx

CRSP

—

—

pinned

1 page

crsp_market_data.xlsx

CRSP via WRDS

1926-2026

M

rolling

3 pages

crsp_stock_data_1995.csv

CRSP

1995-2024

D

pinned

1 page

dfa_analysis_data.xlsx

French

1926-2026

M

rolling

3 pages

factor_pricing_data_{SAMPLING}.xlsx

French

1980-2026

per sampling (D/W/M)

rolling

5 pages

gmo_returns_weekly.xlsx

BB

1996-2025

W

rolling

1 page

ltcm_exhibits_data.xlsx

Manual

1994-1998

M

rolling

1 page

market_expected_return.csv

Manual

—

Snap

rolling

1 page

momentum_data.xlsx

French

1927-2025

M

rolling

2 pages

msft.csv

CRSP

1995-2024

D

rolling

1 page

multi_asset_etf_data.xlsx

Yahoo via yahooquery

2011-2026

M

rolling

4 pages

port_decomp_example.xlsx

Derived

2010-2025

M

rolling

2 pages

private_equity_data.xlsx

Yahoo

2015-2025

W

rolling

2 pages

project_risk_parity_20261023.xlsx

—

—

—

pinned

1 page

project_situational_awareness_20261026.xlsx

—

—

—

pinned

1 page

proshares_analysis_data.xlsx

BB

2011-2025

M

rolling

1 page

risk_etf_data.xlsx

Yahoo via yahooquery

2017-2026

D

rolling

11 pages

sector_etf_data.xlsx

Yahoo

2000-2026

W

rolling

1 page

sector_etf_data_daily.xlsx

Yahoo

2000-2026

D

rolling

2 pages

spx_data_weekly.xlsx

BB

2015-2025

W

rolling

1 page

spx_ret_1995.csv

CRSP

1995-2024

D

pinned

1 page

spx_returns_daily_full.parquet

Yahoo

2016-2026

D

rolling

2 pages

spx_returns_weekly_legacy_2025.xlsx

BB

2015-2025

W

pinned

2 pages

spx_returns_{SAMPLING}.xlsx

BB

2015-2026

per sampling (D/W)

rolling

11 pages

spy_data_daily.xlsx

Yahoo

1994-2026

D

rolling

1 page

spy_data_monthly.xlsx

Yahoo

1993-2025

M

rolling

1 page

spy_forecasting_data.xlsx

BB

1993-2025

M

rolling

2 pages

Datasets by chapter#

Legend#

  • BB — Bloomberg Terminal

  • CRSP — Center for Research in Security Prices (via WRDS)

  • CRSP via WRDS — CRSP via WRDS

  • Derived — Derived from other course datasets

  • French — Ken French Data Library (via pandas-datareader)

  • Manual — Hand-collected

  • Yahoo — Yahoo Finance

  • Yahoo via yahooquery — Yahoo via yahooquery

  • Frequency: D daily, W weekly, M monthly, Q quarterly, Snap point-in-time snapshot.

  • Vintage: a dated filename is pinned — it freezes a specific pull as the permanent dataset for its pages; an undated filename is rolling — re-running its build notebook refreshes it.