Pepsi Vs. Coca-Cola: Comparative Analysis Of Stock
An Examination of Stock Prices, Dividends, and Splits Over Time
@kaggle.prathamjyotsingh_pepsi_vs_coca_cola
An Examination of Stock Prices, Dividends, and Splits Over Time
@kaggle.prathamjyotsingh_pepsi_vs_coca_cola
This dataset provides a comprehensive analysis of the stock performance of two leading beverage companies: PepsiCo (PEP) and The Coca-Cola Company (KO). It includes historical data on stock prices, stock splits, and dividend payments to facilitate a detailed comparison between the two industry giants.
Daily Stock Prices: This section includes the daily open, high, low, close prices, and trading volume for both Pepsi and Coca-Cola, allowing for the examination of market trends and price movements over time.
Stock Splits: The dataset details any stock splits that have occurred for both companies, including the date of the split and the split ratio. Understanding stock splits is crucial for assessing changes in stock value and investor sentiment.
Dividends: This includes historical dividend payments made by each company, providing insights into their profitability and shareholder return strategies.
This dataset is designed for financial analysts, investors, and researchers interested in the beverage industry and its leading players. By examining the historical stock prices, dividend payments, and stock splits, users can gain insights into the financial health and market dynamics of Pepsi and Coca-Cola, aiding in informed investment decisions and strategic analysis.
CREATE TABLE ko_stock_dividend (
"date" VARCHAR,
"dividend" DOUBLE
);CREATE TABLE ko_stock_price (
"date" TIMESTAMP,
"open_price" DOUBLE,
"high_price" DOUBLE,
"low_price" DOUBLE,
"close_price" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ko_stock_split (
"date" VARCHAR,
"stock_splits" VARCHAR
);CREATE TABLE pep_stock_dividend (
"date" VARCHAR,
"dividend" DOUBLE
);CREATE TABLE pep_stock_price (
"date" TIMESTAMP,
"open_price" DOUBLE,
"high_price" DOUBLE,
"low_price" DOUBLE,
"close_price" DOUBLE,
"volume" DOUBLE
);CREATE TABLE pep_stock_split (
"date" VARCHAR,
"stock_splits" VARCHAR
);Anyone who has the link will be able to view this.