Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ccl
@kaggle.rprkh15_sp500_stock_prices.ccl

  • 425.08 KB
  • 8812 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jul 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.93513631820678691.9044198687114411.93513631820678715566400
Mon Jul 27 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.93513429069519051.90441787338256831.91977608203887961931200
Tue Jul 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.9197766819307881.90441846847534161.90441846847534162074800
Wed Jul 29 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.9197766819307881.90441846847534161.90441846847534164930800
Thu Jul 30 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.91977791121748641.87370324134826681.87370324134826644654400
Fri Jul 31 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.85834510367492081.75083753569372761.78155398368835453006800
Mon Aug 03 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.88906073570251441.72012034470472861.88906073570251441277600
Tue Aug 04 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.91977620124816871.8429851531982421.8583433628082275698400
Wed Aug 05 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.8737015724182131.8429851531982421.8583433628082275262000
Thu Aug 06 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.85834480524063151.82762836217880231.8429865837097168480400

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