Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Psa
@kaggle.rprkh15_sp500_stock_prices.psa

  • 425.04 KB
  • 10500 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Nov 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.65325808525085452.7236985653902572.65325808525085452.65325808525085453200
Wed Nov 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.67673993110656742.7471804556093722.67673993110656742.67673993110656748000
Thu Nov 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.6767382452973222.6767382452973222.65325808525085452.653258085250854516600
Fri Nov 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.74717950820922852.79413984168289042.74717950820922852.747179508209228518700
Mon Nov 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.7236985653902572.7236985653902572.65325808525085452.653258085250854540900
Tue Nov 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.5828187333212962.5828187333212962.5358583927154542.53585839271545425800
Wed Nov 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.65325808525085452.7236985653902572.65325808525085452.653258085250854575000
Fri Nov 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.7002186775207522.7236988399339762.7002186775207522.70021867752075219300
Mon Dec 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.7002181432076862.7002181432076862.6297776699066162.62977766990661626200
Tue Dec 02 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.5358583652056182.5358583652056182.44193768501281742.441937685012817420000

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