Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Emn
@kaggle.rprkh15_sp500_stock_prices.emn

  • 359.21 KB
  • 7195 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Dec 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)8.7921650080391069.3033373922274288.766606388829699.2522201538085941077400
Wed Dec 15 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.2011079949847729.2011079949847728.8944043951519469.04775619506836897800
Thu Dec 16 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.0733148283877629.0733148283877628.9966389284295569.04775619506836571200
Fri Dec 17 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.0477565423601629.0477565423601628.8432874679565438.8432874679565431053000
Mon Dec 20 1993 00:00:00 GMT+0000 (Coordinated Universal Time)8.8432903556930599.1244354248046888.8432903556930599.1244354248046881284800
Tue Dec 21 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.0988684385520959.3544546306462569.0988684385520959.252220153808594882800
Wed Dec 22 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.277778773018019.277778773018019.1755442961803469.252220153808594200600
Thu Dec 23 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.2777833861064149.4566938095299549.2777833861064149.431135177612305195800
Mon Dec 27 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.482251026012289.712278678934419.482251026012289.66116142272949268400
Tue Dec 28 1993 00:00:00 GMT+0000 (Coordinated Universal Time)9.635600239672569.635600239672569.5589243756963849.610041618347168273600

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