Dataset: SPX Dataset

About this Dataset

SPX Dataset

The Standard and Poor's 500, or simply the S&P 500, is a stock market index tracking the stock performance of 500 of the largest companies listed on stock exchanges in the United States. It is one of the most commonly followed equity indices. As of December 31, 2020, more than $5.4 trillion was invested in assets tied to the performance of the index.

Tables

Spx Holdings And Spx Closeprice Spx Holdings And Spx C D24cc318

@kaggle.allanwandia_spx_dataset.spx_holdings_and_spx_closeprice_spx_holdings_and_spx_c_d24cc318

5.79 MB
3506 rows
420 columns


CREATE TABLE spx_holdings_and_spx_closeprice_spx_holdings_and_spx_c_d24cc318 (
  "date" TIMESTAMP,
  "a" VARCHAR,
  "aa" VARCHAR,
  "aapl" VARCHAR,
  "abc" VARCHAR,
  "abt" VARCHAR,
  "adbe" VARCHAR,
  "adi" VARCHAR,
  "adm" VARCHAR,
  "adp" VARCHAR,
  "adsk" VARCHAR,
  "aee" VARCHAR,
  "aep" VARCHAR,
  "aes" VARCHAR,
  "afl" VARCHAR,
  "agn" VARCHAR,
  "aig" VARCHAR,
  "aiv" VARCHAR,
  "akam" VARCHAR,
  "aks" VARCHAR,
  "all" VARCHAR,
  "amat" VARCHAR,
  "amd" VARCHAR,
  "amgn" VARCHAR,
  "amt" VARCHAR,
  "amzn" VARCHAR,
  "an" VARCHAR,
  "andv" VARCHAR,
  "anf" VARCHAR,
  "aon" VARCHAR,
  "apa" VARCHAR,
  "apc" VARCHAR,
  "apd" VARCHAR,
  "aph" VARCHAR,
  "apol" VARCHAR,
  "arg" VARCHAR,
  "atge" VARCHAR,
  "avb" VARCHAR,
  "avy" VARCHAR,
  "axp" VARCHAR,
  "azo" VARCHAR,
  "ba" VARCHAR,
  "bac" VARCHAR,
  "bax" VARCHAR,
  "bbt" VARCHAR,
  "bby" VARCHAR,
  "bcr" VARCHAR,
  "bdx" VARCHAR,
  "ben" VARCHAR,
  "bhge" VARCHAR,
  "biib" VARCHAR,
  "bk" VARCHAR,
  "bll" VARCHAR,
  "bmy" VARCHAR,
  "brcm" VARCHAR,
  "bsx" VARCHAR,
  "bxp" VARCHAR,
  "c" VARCHAR,
  "ca" VARCHAR,
  "cag" VARCHAR,
  "cah" VARCHAR,
  "cam" VARCHAR,
  "cat" VARCHAR,
  "cb" VARCHAR,
  "cbs" VARCHAR,
  "ccl" VARCHAR,
  "celg" VARCHAR,
  "cern" VARCHAR,
  "chk" VARCHAR,
  "chrw" VARCHAR,
  "ci" VARCHAR,
  "cinf" VARCHAR,
  "cl" VARCHAR,
  "clf" VARCHAR,
  "clx" VARCHAR,
  "cma" VARCHAR,
  "cmcsa" VARCHAR,
  "cmi" VARCHAR,
  "cms" VARCHAR,
  "cnp" VARCHAR,
  "cnx" VARCHAR,
  "cof" VARCHAR,
  "cog" VARCHAR,
  "cop" VARCHAR,
  "cost" VARCHAR,
  "cpb" VARCHAR,
  "csco" VARCHAR,
  "csx" VARCHAR,
  "ctas" VARCHAR,
  "ctl" VARCHAR,
  "ctsh" VARCHAR,
  "ctxs" VARCHAR,
  "cvs" VARCHAR,
  "cvx" VARCHAR,
  "d" VARCHAR,
  "de" VARCHAR,
  "df" VARCHAR,
  "dgx" VARCHAR,
  "dhi" VARCHAR,
  "dhr" VARCHAR
);