Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ter
@kaggle.rprkh15_sp500_stock_prices.ter

  • 480.93 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.13175058364868161.13175058364868161.13175058364868161.131750583648681614400
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.1244485378265381.1244485378265381.1244485378265381.1244485378265381600
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.08794093132019041.08794093132019041.08794093132019041.087940931320190420800
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.06603562831878661.06603562831878661.06603562831878661.06603562831878664800
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.89809900522232040.89809900522232040.89809900522232040.8980990052223206190400
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.89809900522232040.89809900522232040.89809900522232040.8980990052223206140800
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.96381300687789920.96381300687789920.96381300687789920.963813006877899240000
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.00762271881103521.00762271881103521.00762271881103521.007622718811035244800
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.00032174587249761.00032174587249761.00032174587249761.000321745872497617600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.00032174587249761.00032174587249761.00032174587249761.0003217458724976

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