Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tap
@kaggle.rprkh15_sp500_stock_prices.tap

  • 479.64 KB
  • 11874 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 12 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.5361919090396077.4146404266357427.414640426635742680800
Fri Jun 13 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.6273555446732877.5058040618896487.505804061889648434400
Mon Jun 16 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.5361919090396077.4146404266357427.414640426635742195800
Tue Jun 17 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.3842520314779247.262700557708747.26270055770874278800
Wed Jun 18 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.5969681507203647.4754166603088387.475416660308838178200
Thu Jun 19 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.7185191802978527.5969676971435557.596967697143555190400
Fri Jun 20 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.7489104498905027.6273589134216317.627358913421631304800
Mon Jun 23 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.6881332397460947.5665817260742197.566581726074219119400
Tue Jun 24 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.5361919090396077.4146404266357427.414640426635742240000
Wed Jun 25 1975 00:00:00 GMT+0000 (Coordinated Universal Time)7.4754176061015487.3538661003112797.353866100311279158400

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