SnP 500 Dataset

Latest Data of S&P 500 from yahoo finance

@kaggle.yash16jr_snp500_dataset

Table List

1 table(778.62 KB)

Snp500 History

@kaggle.yash16jr_snp500_dataset.snp500_history

778.62 KB
23970 rows
8 columns

date Date	open Open	high High	low Low	close Close
1927-12-30 00:00:00-05:00	17.65999984741211	17.65999984741211	17.65999984741211	17.65999984741211
1928-01-03 00:00:00-05:00	17.760000228881836	17.760000228881836	17.760000228881836	17.760000228881836
1928-01-04 00:00:00-05:00	17.719999313354492	17.719999313354492	17.719999313354492	17.719999313354492
1928-01-05 00:00:00-05:00	17.549999237060547	17.549999237060547	17.549999237060547	17.549999237060547
1928-01-06 00:00:00-05:00	17.65999984741211	17.65999984741211	17.65999984741211	17.65999984741211
1928-01-09 00:00:00-05:00	17.5	17.5	17.5	17.5
1928-01-10 00:00:00-05:00	17.3700008392334	17.3700008392334	17.3700008392334	17.3700008392334
1928-01-11 00:00:00-05:00	17.350000381469727	17.350000381469727	17.350000381469727	17.350000381469727
1928-01-12 00:00:00-05:00	17.469999313354492	17.469999313354492	17.469999313354492	17.469999313354492
1928-01-13 00:00:00-05:00	17.579999923706055	17.579999923706055	17.579999923706055	17.579999923706055


CREATE TABLE snp500_history (
  "date" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);