Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tfc
@kaggle.rprkh15_sp500_stock_prices.tfc

  • 434.14 KB
  • 10670 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.62367889377946760.59564834833145140.59564834833145143375
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.60265579328233480.57462525367736820.57462525367736822250
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.60265579328233480.57462525367736820.57462525367736825625
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.59564806783950420.56761753559112550.56761753559112557875
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.58163344096361920.55360317230224610.553603172302246112375
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.56761749133212490.53958696126937870.53958696126937873375
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.56061001426817560.53257948160171510.53257948160171511125
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.56061001426817560.53257948160171510.53257948160171512250
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.56061001426817560.53257948160171510.53257948160171516750
Mon Mar 31 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.53257948160171510.53257948160171510.53257948160171510.5325794816017151

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