Dataframe: P04:clean_rates -

Dataframe: P04:clean_rates -#

Cleaned Treasury rate panel used in Figure 1. Converts Treasury APRs into continuously compounded rates using log(1+r), while keeping the monthly risk-free proxy consistent with project conventions.

DataFrame Glimpse#

Rows: 7828
Columns: 5
$ date         <datetime[ns]> 2025-12-31 00:00:00
$ rf_1m                 <f64> 0.0002
$ treasury_1y           <f64> 0.034208171329736956
$ treasury_2y           <f64> 0.03411152962876782
$ treasury_10y          <f64> 0.04094998632895417


Dataframe Manifest#

Dataframe Name

Dataframe ID

clean_rates

Data Sources

Derived from fred_treasury_rates

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)

2025-12-31 00:00:00

Data available up to (max)

2025-12-31 00:00:00

Dataframe Path

/Users/jielin/Desktop/full_stack/p04_golez_jackwerth_2024/_data/clean_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