Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Otis
@kaggle.rprkh15_sp500_stock_prices.otis

  • 34.25 KB
  • 583 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)38.8697334416004844.7001934578405638.8697334416004843.971385955810557000
Fri Mar 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)43.7381780242476344.7099216291195943.7284622192382943.728462219238283600
Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)40.8132305145263740.8132305145263738.85030803066547438.8697433471679711900
Tue Mar 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)38.8697433471679738.8697433471679737.8979997634887738.8697433471679777800
Wed Mar 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)38.8697370593529243.5341047650938736.9262502063852739.85119628906257000
Thu Mar 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)43.7284622192382946.1578212314181942.9996545155843143.7284622192382829100
Fri Mar 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)43.7284535174485246.1578120461956743.7187377143725943.95681381225586263200
Mon Mar 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)42.999655265808148.58718109130859442.999655265808148.587181091308594118100
Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)45.1860784149169948.58718109130859443.514678199165548.587181091308594210300
Wed Apr 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)44.690491225778947.1295661088250642.7567197688309845.380428314208981206100

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

Share link

Anyone who has the link will be able to view this.