Dataset: Big Tech : Stock Data (2014-2023)

About this Dataset

Big Tech : Stock Data (2014-2023)

The dataset consists of stock market data from four major technology companies: Apple (AAPL), Amazon (AMZN), Google (GOOG), and Microsoft (MSFT). The data spans from 2005 to 2023, covering nearly two decades of stock performance and providing a comprehensive view of key financial indicators.

The dataset is composed of the following key files:

AAPL.csv - Stock data for Apple.
AMZN.csv - Stock data for Amazon.
GOOG.csv - Stock data for Google.
MSFT.csv - Stock data for Microsoft.
Stocks_Market.csv - A consolidated file containing overall market data for the period from 2014 to 2023.

Each file includes the following columns:

Date: The trading date (daily frequency).
Price: The stock's closing price for the given day.
Open: The price at which the stock opened for trading.
High: The highest price reached during the trading session.
Low: The lowest price during the trading session.
Volume: The total number of shares traded on that day.

Tables

Aapl

@kaggle.mustaphaoutgougua_tech_giants_stock_data_2014_2023.aapl

131.38 KB
2517 rows
7 columns


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

Amzn

@kaggle.mustaphaoutgougua_tech_giants_stock_data_2014_2023.amzn

133.25 KB
2517 rows
7 columns


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

Goog

@kaggle.mustaphaoutgougua_tech_giants_stock_data_2014_2023.goog

132.96 KB
2517 rows
7 columns


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

Market Data

@kaggle.mustaphaoutgougua_tech_giants_stock_data_2014_2023.market_data

33.1 KB
1177 rows
5 columns


CREATE TABLE market_data (
  "date" TIMESTAMP,
  "mkt_rf" DOUBLE,
  "smb" DOUBLE,
  "hml" DOUBLE,
  "rf" DOUBLE
);

Msft

@kaggle.mustaphaoutgougua_tech_giants_stock_data_2014_2023.msft

129.03 KB
2517 rows
7 columns


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