Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Gis
@kaggle.rprkh15_sp500_stock_prices.gis

  • 513.23 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.335098056633690.31951216910204450.3214603960514068557532
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.32730516791343690.31951222283701120.3273051679134369660133
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.33509812331201650.32535691469013760.32925340533256531167332
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.33120158314704890.32340863899580540.3312015831470489785965
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.32730516391356820.321460446185580.3253569006919861338778
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.33120163266958880.32340868735311420.32925340533256531080218
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.32730516391356820.3234086734387830.3253569006919861524622
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.33314990997314450.3273052270854760.3331499099731445694979
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.33120161841997410.31951221893237710.3253569006919861967937
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.35068442477718630.32535702888576240.34873619675636291322202

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