About this Dataset

Pepsi Vs. Coca-Cola: Comparative Analysis Of Stock

Dataset Description: Pepsi vs. Coca-Cola Stock Performance

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.

Key Components:

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.

Purpose:

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.

Tables

Ko Stock Dividend

@kaggle.prathamjyotsingh_pepsi_vs_coca_cola.ko_stock_dividend

4.66 KB
251 rows
2 columns


CREATE TABLE ko_stock_dividend (
  "date" VARCHAR,
  "dividend" DOUBLE
);

Ko Stock Price

@kaggle.prathamjyotsingh_pepsi_vs_coca_cola.ko_stock_price

188.97 KB
6292 rows
6 columns


CREATE TABLE ko_stock_price (
  "date" TIMESTAMP,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "volume" DOUBLE
);

Ko Stock Split

@kaggle.prathamjyotsingh_pepsi_vs_coca_cola.ko_stock_split

2.22 KB
8 rows
2 columns


CREATE TABLE ko_stock_split (
  "date" VARCHAR,
  "stock_splits" VARCHAR
);

Pep Stock Dividend

@kaggle.prathamjyotsingh_pepsi_vs_coca_cola.pep_stock_dividend

4.4 KB
211 rows
2 columns


CREATE TABLE pep_stock_dividend (
  "date" VARCHAR,
  "dividend" DOUBLE
);

Pep Stock Price

@kaggle.prathamjyotsingh_pepsi_vs_coca_cola.pep_stock_price

219.92 KB
6292 rows
6 columns


CREATE TABLE pep_stock_price (
  "date" TIMESTAMP,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "volume" DOUBLE
);

Pep Stock Split

@kaggle.prathamjyotsingh_pepsi_vs_coca_cola.pep_stock_split

2.17 KB
4 rows
2 columns


CREATE TABLE pep_stock_split (
  "date" VARCHAR,
  "stock_splits" VARCHAR
);