Name: S&P500 Top 20 Companies Stocks
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P500 Top 20 Companies Stocks

'Close' stock prices and normalized percentage change of S&P500 and its top 20 companies as of 2024.
The top 20s are ranked in terms of market capitalization.

Some companies are publicly listed later than 2008; thus, there are some null values for those before-listing periods.

Part of my school project for Nanyang Polytechnic | AI & Data Engineering

Tables

Stocks

@kaggle.myrios_s_and_p500_top_20_companies_stocks.stocks

616.08 kB
5,843 rows
21 columns

CREATE TABLE stocks (
  "n__gspc" DOUBLE  -- ^GSPC,
  "aapl" DOUBLE,
  "msft" DOUBLE,
  "nvda" DOUBLE,
  "googl" DOUBLE,
  "goog" DOUBLE,
  "amzn" DOUBLE,
  "meta" DOUBLE,
  "lly" DOUBLE,
  "avgo" DOUBLE,
  "tsla" DOUBLE,
  "jpm" DOUBLE,
  "wmt" DOUBLE,
  "unh" DOUBLE,
  "xom" DOUBLE,
  "v" DOUBLE,
  "ma" DOUBLE,
  "pg" DOUBLE,
  "jnj" DOUBLE,
  "orcl" DOUBLE,
  "cost" DOUBLE
);

Stocks Pct

@kaggle.myrios_s_and_p500_top_20_companies_stocks.stocks_pct

817.13 kB
5,843 rows
22 columns

CREATE TABLE stocks_pct (
  "date" TIMESTAMP,
  "n__gspc" DOUBLE  -- ^GSPC,
  "aapl" DOUBLE,
  "msft" DOUBLE,
  "nvda" DOUBLE,
  "googl" DOUBLE,
  "goog" DOUBLE,
  "amzn" DOUBLE,
  "meta" DOUBLE,
  "lly" DOUBLE,
  "avgo" DOUBLE,
  "tsla" DOUBLE,
  "jpm" DOUBLE,
  "wmt" DOUBLE,
  "unh" DOUBLE,
  "xom" DOUBLE,
  "v" DOUBLE,
  "ma" DOUBLE,
  "pg" DOUBLE,
  "jnj" DOUBLE,
  "orcl" DOUBLE,
  "cost" DOUBLE
);