Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Rol
@kaggle.rprkh15_sp500_stock_prices.rol

  • 444.72 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.11021059862126820.10425319522619240.10425319522619242478623
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.10663610114600790.09650879332493920.10484915226697925261440
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.10604064473884130.10306167602539060.10306167602539062084296
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.10604062128250740.10306165322800850.10365766286849971622371
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.10484914607605150.10306165322800850.10365766286849974134793
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.10604065412105960.09531733393669120.09531733393669123019413
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.09710431744753210.08816848025423150.09293439984321594743183
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.09829579995642440.09352988004684440.09352988004684445520569
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.0917428709482110.07506215402183390.08578547090291979362434
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.09531733393669120.08816845648081180.09531733393669127311937

CREATE TABLE rol (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);