Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Phm
@kaggle.rprkh15_sp500_stock_prices.phm

  • 476.47 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14070303290910220.13639606535434720.136396065354347270400
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13496039807796470.1306526972109060.1349603980779647230400
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13208909332752220.12921704074712650.1320890933275222153600
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13208911922334560.12921706607988920.130652725696563770400
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13065272569656370.13065272569656370.13065272569656370.1306527256965637
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13065276315191230.12491013399280780.1292171031236648179200
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.12491005235183790.1206030969898840.123474404215812676800
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.12060312070615630.11629541963338850.1162954196333885198400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11485974525664760.10337377073098280.1062450781464576473600
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.12060310691595070.11055278045736710.1206031069159507268800

CREATE TABLE phm (
  "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.