Dataframe: P1:ravenpack_djpr - RavenPack Dow Jones & PR Equities News

Dataframe: P1:ravenpack_djpr - RavenPack Dow Jones & PR Equities News#

RavenPack Dow Jones & PR Edition equities news (US firms only) for 2000-01-01 to 2019-06-30. Filtered to relevance >= 90 and restricted to single-firm stories (one distinct rp_entity_id per provider story). Contains event metadata, similarity measures, headline, and composite sentiment score (css).

DataFrame Glimpse#

Rows: 28809067
Columns: 26
$ timestamp_utc         <datetime[ns]> 2000-01-01 17:52:28
$ rp_story_id                    <str> '52D513EA9040443376A6B1747B0FA8CC'
$ rp_entity_id                   <str> '047E26'
$ entity_type                    <str> 'COMP'
$ entity_name                    <str> 'Sprint Corp.'
$ country_code                   <str> 'US'
$ relevance                      <f64> 92.0
$ event_sentiment_score          <f64> None
$ event_relevance                <f64> None
$ event_similarity_key           <str> None
$ event_similarity_days          <f64> None
$ topic                          <str> None
$ rp_group                       <str> None
$ rp_type                        <str> None
$ sub_type                       <str> None
$ property                       <str> None
$ fact_level                     <str> None
$ category                       <str> None
$ news_type                      <str> 'FULL-ARTICLE'
$ rp_source_id                   <str> 'B5569E'
$ source_name                    <str> 'Dow Jones Newswires'
$ provider_id                    <str> 'DJ'
$ provider_story_id              <str> 'DN20000101000112'
$ headline                       <str> 'Sprint Says No Y2K Rollover Problems Reported >FON'
$ css                            <f64> -0.06
$ year                           <i64> 2000

Dataframe Manifest#

Dataframe Name

RavenPack Dow Jones & PR Equities News

Dataframe ID

ravenpack_djpr

Data Sources

RavenPack

Data Providers

WRDS

Links to Providers

Topic Tags

Type of Data Access

How is data pulled?

Pulled via WRDS from ravenpack_dj.rpa_djpr_equities_YYYY tables; filtered to US firms, relevance >= 90, single-firm stories.

Data available up to (min)

N/A (large file)

Data available up to (max)

N/A (large file)

Dataframe Path

/Users/reecevdw/UChicago/FINM 32900/old_project/p17_chen_kelly_xiu_2022/_data/ravenpack_djpr.parquet

Linked Charts:

Pipeline Manifest#

Pipeline Name

p17_chen_kelly_xiu_2022

Pipeline ID

P1

Lead Pipeline Developer

Reece VanDeWeghe

Contributors

Andrew Moukabary

Git Repo URL

reecevdw/p17_chen_kelly_xiu_2022

Pipeline Web Page

Pipeline Web Page

Date of Last Code Update

2026-02-09 21:03:13

OS Compatibility

Linked Dataframes

P1:crsp_daily
P1:ravenpack_djpr
P1:ravenpack_crsp_merged
Contents