Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pwr
@kaggle.rprkh15_sp500_stock_prices.pwr

  • 297.82 KB
  • 6143 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Feb 12 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.2315624493104527.7246235467734247.2315624493104527.395916461944583903750
Fri Feb 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.4780929980419387.5602704745787077.3137399258472217.39591646194458504000
Tue Feb 17 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.6424476143633097.8068016399799837.6424476143633097.724624156951904132600
Wed Feb 18 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.806801119784778.2176847457885747.7657123810086218.217684745788574140700
Thu Feb 19 1998 00:00:00 GMT+0000 (Coordinated Universal Time)8.2998629006938328.5463934725912788.0533323287963878.053332328796387235050
Fri Feb 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.9711544106349658.0533318904205237.4780932936794127.683536052703857204750
Mon Feb 23 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.724623839471717.8068013191223147.5191820212240927.80680131912231460600
Tue Feb 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.7657130950134487.8068018375674297.4370059759001227.560271263122559261300
Wed Feb 25 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.6424478077910127.6424478077910127.39591723334614057.560271263122559129000
Thu Feb 26 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.4780931175273547.9711542228684867.4780931175273547.84788894653320387000

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