Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Nem
@kaggle.rprkh15_sp500_stock_prices.nem

  • 508.34 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)6.4830506082437686.2129240445181466.399935245513916519375
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.5661664009094245.9220174513354466.566166400909424659250
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.7531772348206186.4414921225290176.711619853973389408000
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.8570690356878176.5869420340430816.732395172119141607125
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.7531746729476826.4414896788963756.649280071258545229125
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.6077227147322036.1298052442760746.192142486572266256875
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.2960387772919856.0466903596266176.275259494781494315750
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.3375948527550636.1505837440490726.150583744049072315000
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.0882506400558255.42332173526110055.818122863769531609000
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)6.2337017059326175.8181213940397366.233701705932617277125

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