Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Usb
@kaggle.rprkh15_sp500_stock_prices.usb

  • 481.93 KB
  • 12407 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu May 03 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16492055356502530.17187523572075390.16492055356502530.16492055356502539000
Fri May 04 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17187535145652680.16790103912353510.167901039123535113500
Mon May 07 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790092606394650.17187523572075390.16492055356502530.164920553565025345000
Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17187535145652680.16790103912353510.167901039123535190000
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17485572596234390.16790103912353510.167901039123535181000
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17485572596234390.16790103912353510.167901039123535113500
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17485572596234390.16790103912353510.16790103912353514500
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17485572596234390.16790103912353510.16790103912353519000
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17485572596234390.16790103912353510.16790103912353519000
Wed May 16 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.16790103912353510.17485572596234390.16790103912353510.167901039123535113500

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