Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Aon
@kaggle.rprkh15_sp500_stock_prices.aon

  • 485.05 KB
  • 10618 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Jun 02 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.1159069557912271.10826349258422831.1082634925842283118800
Tue Jun 03 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.12354981899261471.10826338606352871.1235498189926147141750
Wed Jun 04 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.12354981899261471.1159068485358761.1235498189926147102600
Thu Jun 05 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.13119304180145261.11590670918440481.1311930418014526575100
Fri Jun 06 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.13883674759258141.11590743064880371.115907430648803788425
Mon Jun 09 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.13119318306184021.1159068485358761.1235498189926147151875
Tue Jun 10 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.15412235260009771.11590671757630561.1541223526000977238275
Wed Jun 11 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.1999819278717041.14647974635506441.199981927871704154575
Thu Jun 12 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.2381981736088671.19998203116924241.2229118347167969213300
Fri Jun 13 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.2611276001908891.23055443952966931.2381978034973145369225

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

Share link

Anyone who has the link will be able to view this.