Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Vfc
@kaggle.rprkh15_sp500_stock_prices.vfc

  • 491.93 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.12010930744218620.11793838890412220.11866229027509693527539
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11721475266307040.11576773699953990.116491250693798285466
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.1143208728977250.11070292443037030.1107029244303703149530
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11432080715894690.1107028607720480.1143208071589469305856
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.12083280086517330.11504432282899570.1208328008651733190310
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11938574416320410.11504429578781120.1150442957878112183514
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11432078678857040.11287377029657360.1128737702965736163123
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11576785147190090.11432083437754610.115767851471900933984
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11432084492747850.10780886288952570.1092558801174163618509
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.11070292443037030.10997942150190880.110702924430370347578

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