Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Gww
@kaggle.rprkh15_sp500_stock_prices.gww

  • 521.63 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.45813608169555662.45813608169555662.45813608169555662.458136081695556620000
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.47503042221069342.47503042221069342.47503042221069342.47503042221069346400
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.55950284004211432.55950284004211432.55950284004211432.559502840042114343200
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.55950284004211432.55950284004211432.55950284004211432.55950284004211434800
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.52571392059326172.52571392059326172.52571392059326172.52571392059326171600
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.5003736019134522.5003736019134522.5003736019134522.50037360191345265600
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.50882077217102052.50882077217102052.50882077217102052.50882077217102053200
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.5003736019134522.5003736019134522.5003736019134522.5003736019134521600
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.4834783077239992.4834783077239992.4834783077239992.48347830772399914400
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)2.4919271469116212.4919271469116212.4919271469116212.491927146911621108000

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