Dataframe: P04:implied_rates -

Calculated option-implied rates from SPX options using the outer product approach for 1996–2003 and the regression approach for 2004 onward. Contains all date-exdate combinations before interpolation to constant maturity.

DataFrame Glimpse

Rows: 3633
Columns: 4
$ date      <datetime[ns]> 2024-12-31 00:00:00
$ exdate    <datetime[ns]> 2029-12-21 00:00:00
$ r_implied          <f64> 0.045081989534843984
$ tau                <f64> 4.975342465753425

Dataframe Manifest

Dataframe Name
Dataframe ID	implied_rates
Data Sources	Derived from clean_options
Data Providers	Internal pipeline
Links to Providers
Topic Tags
Type of Data Access
How is data pulled?	Constructed by calc_implied_rates.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/calc/implied_rates.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