Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Fox
@kaggle.rprkh15_sp500_stock_prices.fox

  • 46.21 KB
  • 840 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Mar 13 2019 00:00:00 GMT+0000 (Coordinated Universal Time)36.78976563992744537.456938309210836.2179054295694537.361629486083984306000
Thu Mar 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)37.6475606747852138.74363035128196537.4760018795805338.08598709106445279700
Fri Mar 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)38.6483158726226839.12486724869890538.6006614621747539.09627532958984164200
Mon Mar 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)39.7729812630537239.7729812630537238.5720732787845838.94378280639648581700
Tue Mar 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)39.4584556000659139.4584556000659137.2186619392992837.695213317871092540200
Wed Mar 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)37.9811435007331237.9820997157358535.7032284879169535.836662292480475147900
Thu Mar 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)36.2179053525362137.0852287300202636.0654090543785237.0566368103027348865500
Fri Mar 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)36.9422608396142437.0185108044865934.8359046432946835.703227996826174902500
Mon Mar 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)35.8080669260890236.0368131660336734.6452805083168134.740592956542974035100
Tue Mar 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)34.75012761755504435.59838853764378534.75012761755504434.98840332031253350900

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

Share link

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