Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ste
@kaggle.rprkh15_sp500_stock_prices.ste

  • 348.04 KB
  • 7585 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Jun 01 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.3612742929747611.54903626441955571.3612742929747611.54903626441955573012000
Tue Jun 02 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.5490363000044181.5959767939439461.50209580606489031.5725065469741821220800
Wed Jun 03 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.59597630378527521.83067870140075681.5490358242621791.83067870140075681423200
Thu Jun 04 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.92455966044694931.92455966044694931.78373822187766031.8306787014007568883200
Fri Jun 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.83067914924106081.83067914924106081.59597669421015561.7367981672286987413600
Mon Jun 08 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.73679816722869871.73679816722869871.6429171852163371.7367981672286987307200
Tue Jun 09 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.7367987036705021.7367987036705021.45515567064285281.502096176147461175200
Wed Jun 10 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.50209557669503371.64291703701019291.50209557669503371.642917037010192970400
Thu Jun 11 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.64291703701019291.64291703701019291.54903606346675331.6429170370101929120800
Fri Jun 12 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.68985767622251771.73679816722869871.6429171852163371.7367981672286987151600

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