Dataframe: P04:clean_crsp_sp500_monthly -

Monthly panel derived from daily CRSP index data. Contains the month-end index level, a monthly market log return series, and an implied monthly dividend proxy constructed from total and ex-dividend return differences.

DataFrame Glimpse

Rows: 347
Columns: 4
$ date        <datetime[ns]> 2024-12-31 00:00:00
$ spindx               <f64> 5881.63
$ div_monthly          <f64> 11.150582818478467
$ mkt_ret              <f64> -0.03212699599105942

Dataframe Manifest

Dataframe Name
Dataframe ID	clean_crsp_sp500_monthly
Data Sources	Derived from crsp_sp500_daily
Data Providers	Internal pipeline
Links to Providers
Topic Tags
Type of Data Access
How is data pulled?	Constructed by clean_data.py.
Data available up to (min)	2024-12-31 00:00:00
Data available up to (max)	2024-12-31 00:00:00
Dataframe Path	/Users/jielin/Desktop/full_stack/p04_golez_jackwerth_2024/_data/clean_crsp_sp500_monthly.parquet

Linked Charts:

• None

Pipeline Manifest

Pipeline Name	Holding Period Effects in Dividend Strip Returns
Pipeline ID	P04
Lead Pipeline Developer	Jie Lin and Zimeng Yi
Contributors	Jie Lin, Zimeng Yi
Git Repo URL
Pipeline Web Page	Pipeline Web Page
Date of Last Code Update	2026-03-16 00:21:10
OS Compatibility
Linked Dataframes	P04:crsp_sp500_daily P04:crsp_treasury_returns P04:fred_treasury_rates P04:fama_french_factors P04:fama_french_monthly P04:optionmetrics_spx_raw P04:optionmetrics_spx_monthly P04:optionmetrics_zero_curve P04:clean_options P04:clean_zero_curve P04:clean_rates P04:clean_crsp_sp500_monthly P04:implied_rates P04:implied_rates_1y P04:zero_curve_1y P04:strip_prices P04:all_strip_prices P04:monthly_returns