Dataframe: P01:ccm_link - CRSP-Compustat Link Table

Contents

Dataframe: `P01:ccm_link` - CRSP-Compustat Link Table#

Crosswalk table linking CRSP PERMNO to Compustat GVKEY. Contains 39K links covering 34,550 unique gvkeys and 35,066 unique permnos.

DataFrame Glimpse#

Rows: 40884
Columns: 6
$ gvkey              <str> '369350'
$ permno             <f64> 27874.0
$ linktype           <str> 'LC'
$ linkprim           <str> 'P'
$ linkdt    <datetime[ns]> 2025-12-08 00:00:00
$ linkenddt <datetime[ns]> None

Dataframe Manifest#

Dataframe Name	CRSP-Compustat Link Table
Dataframe ID	ccm_link
Data Sources	CRSP, Compustat
Data Providers	WRDS
Links to Providers	https://wrds-www.wharton.upenn.edu/
Topic Tags	Linking Table, Crsp, Compustat
Type of Data Access	S,u,b,s,c,r,i,p,t,i,o,n, ,(,W,R,D,S,)
How is data pulled?	WRDS Python API
Data available up to (min)	N/A
Data available up to (max)	N/A
Dataframe Path	C:\Users\Zara\Documents\GitHub\FINM-Winter\full-stack-quant\p01_kelly_pruitt_2013_data\CRSP_Comp_Link_Table.parquet
Download Data as Parquet	Parquet
Download Data as Excel	Excel
Linked Charts	None

Pipeline Manifest#

Pipeline Name	Market Expectations in the Cross-Section of Present Values
Pipeline ID	P01
Lead Pipeline Developer	Zara and Dylan
Contributors	Zara, Dylan
Git Repo URL	zaranip/p01_kelly_pruitt_2013
Pipeline Web Page	Pipeline Web Page
Date of Last Code Update	2026-03-05 23:55:41
OS Compatibility
Linked Dataframes	P01:crsp_monthly_stock P01:crsp_market_returns P01:compustat P01:ccm_link P01:ken_french_ff_factors P01:ken_french_25_portfolios