Stock Market and ESG
This topic combines daily stock-market records with company-level environmental, social, and governance information. Optional financial statements support deeper comparisons of company scale and performance.
Core data
stock_markets <- readr::read_csv(
"https://bcdanl.github.io/data/stock_history_2024_10.csv"
)
esg_info <- readr::read_csv(
"https://bcdanl.github.io/data/stock_esg_list.csv"
)The common company key is Ticker. Inspect its formatting and uniqueness before joining the two tables.
Important variables
Stock history
Date, Ticker, Open, High, Low, Close, Volume, Dividends, and Stock_Splits describe daily trading activity and corporate actions.
ESG and company information
Company_Name, Sector, Industry, Market_Cap, Country, and IPO_Year describe each company. total_esg, environmental, social, governance, and controversy contain ESG measures.
Optional financial data
Use optional tables only when they directly support your question; more data does not automatically create a clearer story.
Possible story directions
- How do ESG scores vary across sectors or countries?
- Are ESG scores related to market capitalization or trading behavior?
- Which ESG dimensions tend to move together?
- How did selected industries or companies change over time?
- Do companies with controversy scores show distinct market patterns?
A useful first pass
Choose a manageable set of companies or sectors. Check the time coverage for each ticker, summarize ESG missingness, and verify the row count before and after every join.