Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pm
@kaggle.rprkh15_sp500_stock_prices.pm

  • 185.95 KB
  • 3606 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 2008 00:00:00 GMT+0000 (Coordinated Universal Time)25.68066163951504427.0417374901209425.2903164446771725.367357254028321988000
Tue Mar 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)25.60362113878506626.70789047080902324.52503403809867825.4752178192138678067600
Wed Mar 19 2008 00:00:00 GMT+0000 (Coordinated Universal Time)25.4752109472215726.194270126564224.08845703735578825.7320175170898443007700
Thu Mar 20 2008 00:00:00 GMT+0000 (Coordinated Universal Time)25.78338648158402425.78338648158402425.1002798937328625.244092941284183007700
Mon Mar 24 2008 00:00:00 GMT+0000 (Coordinated Universal Time)25.58307027143118326.1942691802978525.58307027143118326.194269180297851437000
Tue Mar 25 2008 00:00:00 GMT+0000 (Coordinated Universal Time)26.39971161860149426.5794754028320325.9888196101688926.579475402832031100800
Wed Mar 26 2008 00:00:00 GMT+0000 (Coordinated Universal Time)26.55379491982023826.949277201094825.83473587036132825.8347358703613282023200
Thu Mar 27 2008 00:00:00 GMT+0000 (Coordinated Universal Time)26.168590642940826.7232918315971725.6806577537635526.029914855957038653300
Fri Mar 28 2008 00:00:00 GMT+0000 (Coordinated Universal Time)26.1685846498570826.96468446604661725.96827587873668426.2250823974609389961200
Mon Mar 31 2008 00:00:00 GMT+0000 (Coordinated Universal Time)26.91334139347809228.09465175357758325.6806685207693625.97856521606445319408900

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