Dataset: S And P 500 Stocks Data From 2008 To 2023

About this Dataset

S And P 500 Stocks Data From 2008 To 2023

This data is downloaded from Yahoo finance,it is very useful to backtest various trading strategies ,perform data analysis or do portfolio analysis.
It has data from 2008-01-01 to 2023-12-31.
The data is for 503 S&P stocks and it contains some missing values

Tables

Sandp Stocks Data 2008–2023

@kaggle.devanshshukla9876_s_and_p_500_stocks_data_from_2008_to_2023.sandp_stocks_data_2008_2023

12.81 MB
4027 rows
504 columns


CREATE TABLE sandp_stocks_data_2008_2023 (
  "date" TIMESTAMP,
  "a" DOUBLE,
  "aal" DOUBLE,
  "aapl" DOUBLE,
  "abbv" DOUBLE,
  "abnb" DOUBLE,
  "abt" DOUBLE,
  "acgl" DOUBLE,
  "acn" DOUBLE,
  "adbe" DOUBLE,
  "adi" DOUBLE,
  "adm" DOUBLE,
  "adp" DOUBLE,
  "adsk" DOUBLE,
  "aee" DOUBLE,
  "aep" DOUBLE,
  "aes" DOUBLE,
  "afl" DOUBLE,
  "aig" DOUBLE,
  "aiz" DOUBLE,
  "ajg" DOUBLE,
  "akam" DOUBLE,
  "alb" DOUBLE,
  "algn" DOUBLE,
  "all" DOUBLE,
  "alle" DOUBLE,
  "amat" DOUBLE,
  "amcr" DOUBLE,
  "amd" DOUBLE,
  "ame" DOUBLE,
  "amgn" DOUBLE,
  "amp" DOUBLE,
  "amt" DOUBLE,
  "amzn" DOUBLE,
  "anet" DOUBLE,
  "anss" DOUBLE,
  "aon" DOUBLE,
  "aos" DOUBLE,
  "apa" DOUBLE,
  "apd" DOUBLE,
  "aph" DOUBLE,
  "aptv" DOUBLE,
  "are" DOUBLE,
  "ato" DOUBLE,
  "avb" DOUBLE,
  "avgo" DOUBLE,
  "avy" DOUBLE,
  "awk" DOUBLE,
  "axon" DOUBLE,
  "axp" DOUBLE,
  "azo" DOUBLE,
  "ba" DOUBLE,
  "bac" DOUBLE,
  "ball" DOUBLE,
  "bax" DOUBLE,
  "bbwi" DOUBLE,
  "bby" DOUBLE,
  "bdx" DOUBLE,
  "ben" DOUBLE,
  "bf_b" DOUBLE,
  "bg" DOUBLE,
  "biib" DOUBLE,
  "bio" DOUBLE,
  "bk" DOUBLE,
  "bkng" DOUBLE,
  "bkr" DOUBLE,
  "bldr" DOUBLE,
  "blk" DOUBLE,
  "bmy" DOUBLE,
  "br" DOUBLE,
  "brk_b" DOUBLE,
  "bro" DOUBLE,
  "bsx" DOUBLE,
  "bwa" DOUBLE,
  "bx" DOUBLE,
  "bxp" DOUBLE,
  "c" DOUBLE,
  "cag" DOUBLE,
  "cah" DOUBLE,
  "carr" DOUBLE,
  "cat" DOUBLE,
  "cb" DOUBLE,
  "cboe" DOUBLE,
  "cbre" DOUBLE,
  "cci" DOUBLE,
  "ccl" DOUBLE,
  "cdns" DOUBLE,
  "cdw" DOUBLE,
  "ce" DOUBLE,
  "ceg" DOUBLE,
  "cf" DOUBLE,
  "cfg" DOUBLE,
  "chd" DOUBLE,
  "chrw" DOUBLE,
  "chtr" DOUBLE,
  "ci" DOUBLE,
  "cinf" DOUBLE,
  "cl" DOUBLE,
  "clx" DOUBLE,
  "cma" DOUBLE
);