Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ice
@kaggle.rprkh15_sp500_stock_prices.ice

  • 215.85 KB
  • 4190 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Nov 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.9939152550109437.9282304135866876.9150092795743987.03874778747558697759000
Thu Nov 17 2005 00:00:00 GMT+0000 (Coordinated Universal Time)7.2270439088451767.4870739769298286.0972577419460626.321421623229980534308500
Fri Nov 18 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.4917860458399456.6262844652826526.19768338830112956.276588916778564512810000
Mon Nov 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.3214210149575036.4487458375807986.2443086780001176.4379858970642096404000
Tue Nov 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.3572878897027886.3590810707976966.151057099234676.2676219940185556533000
Wed Nov 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.2227890992493286.2676216168347585.6578960427154186.08829069137573212421000
Fri Nov 25 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.052425052089056.177956711230766.0344919579259486.1241574287414551316000
Mon Nov 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)6.0793249337124326.0793249337124325.837227947671955.9717259407043463155000
Tue Nov 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)5.9717250143648696.0057980164060165.6076832149757175.7332148551940924477500
Wed Nov 30 2005 00:00:00 GMT+0000 (Coordinated Universal Time)5.7565289256935085.81212139069391755.6668634526805735.7923951148986823894500

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