Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Expe
@kaggle.rprkh15_sp500_stock_prices.expe

  • 219.5 KB
  • 4273 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jul 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)31.759381684360732.40484370685063531.5090996715606931.64082717895508109200
Fri Jul 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)32.43118902306516632.8000230209557731.5486180084805232.7473335266113356800
Mon Jul 25 2005 00:00:00 GMT+0000 (Coordinated Universal Time)32.80001807526614532.80001807526614531.81206570846600531.93062019348144539600
Tue Jul 26 2005 00:00:00 GMT+0000 (Coordinated Universal Time)32.0755221186395832.0755221186395831.28515968720118331.614477157592773102450
Wed Jul 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)31.6144832345083231.7725567561779631.1534381848397331.7066917419433698100
Thu Jul 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)31.74621437172329831.7725603804223831.49593231406935731.68034934997558293600
Fri Jul 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)31.7462180671891832.07553567678140631.4169004575969632.0623626708984460700
Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)31.9174536748790432.27311720214597631.7462096686912432.07552719116211164950
Tue Aug 02 2005 00:00:00 GMT+0000 (Coordinated Universal Time)34.24902741078168634.24902741078168631.14026873411275531.680349349975582299700
Wed Aug 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time)31.97015044062593631.97015044062593631.29834229334218831.41689682006836147750

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