Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

It
@kaggle.rprkh15_sp500_stock_prices.it

  • 271.68 KB
  • 7244 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Oct 05 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.00393068443224243.0922815869155442.9450300827767083.033380985260009825536800
Wed Oct 06 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.06283141117469973.06283141117469972.97448050508312133.00393080711364754008000
Thu Oct 07 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.97448050508312133.0333811091441732.97448050508312133.00393080711364751502400
Fri Oct 08 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.00393080711364753.0333811091441732.9450302030525953.00393080711364751222400
Mon Oct 11 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.9450302124023443.0039308166503912.91557991027832042.9450302124023441073600
Tue Oct 12 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.9155797958374032.9744803977735122.9155797958374032.9155797958374023765600
Wed Oct 13 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.91557991027832042.9744805145263672.91557991027832042.945030212402344960000
Thu Oct 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.9450302124023443.0039308166503912.9450302124023442.9450302124023441547200
Fri Oct 15 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.97448039054870563.03338099234174942.97448039054870562.974480390548706524800
Mon Oct 18 1993 00:00:00 GMT+0000 (Coordinated Universal Time)2.9744803769247883.1511821814945772.9744803769247883.0922815799713131245600

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