Dataset: Historical Stock Price Of (FAANG + 5) Companies

About this Dataset

Historical Stock Price Of (FAANG + 5) Companies

Context

The subject matter of this dataset contains the stock prices of the 10 popular companies ( Apple, Amazon, Netflix, Microsoft, Google, Facebook, Tesla, Walmart, Uber and Zoom)

Content

Within the dataset one will encounter the following:
The date - "Date"
The opening price of the stock - "Open"
The high price of that day - "High"
The low price of that day - "Low"
The closed price of that day - "Close"
The amount of stocks traded during that day - "Volume"
The stock's closing price that has been amended to include any distributions/corporate actions that occurs before next days open - "Adj[usted] Close"
Time period - 2015 to 2021 (day level)

Tasks

Exploratory Data Analysis
Tell a visualization story
Compare stock price growth between companies
Stock price prediction
Time series analysis

Tables

Amazon

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.amazon

82.91 KB
1761 rows
7 columns


CREATE TABLE amazon (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Apple

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.apple

88.42 KB
1761 rows
7 columns


CREATE TABLE apple (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Facebook

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.facebook

81.43 KB
1761 rows
7 columns


CREATE TABLE facebook (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Google

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.google

84.86 KB
1761 rows
7 columns


CREATE TABLE google (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Microsoft

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.microsoft

87.05 KB
1761 rows
7 columns


CREATE TABLE microsoft (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Netflix

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.netflix

84.03 KB
1761 rows
7 columns


CREATE TABLE netflix (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Tesla

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.tesla

132.64 KB
2767 rows
7 columns


CREATE TABLE tesla (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Uber

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.uber

33.6 KB
666 rows
7 columns


CREATE TABLE uber (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Walmart

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.walmart

83.89 KB
1761 rows
7 columns


CREATE TABLE walmart (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Zoom

@kaggle.suddharshan_historical_stock_price_of_10_popular_companies.zoom

36.3 KB
681 rows
7 columns


CREATE TABLE zoom (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);