Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Lly
@kaggle.rprkh15_sp500_stock_prices.lly

  • 613.28 KB
  • 12637 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.927752562649480.9170682733523980.9224103093147278456000
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.92419085958629440.93309432268142680.92419085958629440.933094322681427640000
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.9313134868162620.9313134868162620.9170677754873120.9206292033195496464000
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.9206295002493120.9206295002493120.91172581911087040.9117258191108704796800
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.9117260200176460.9241911328837860.90994541382101020.9224103093147278584000
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.92241010605357580.92597153503447760.90994521330660640.9117258191108704726400
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.91350684358670420.9241911328837860.91350684358670420.9224103093147278296000
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.92240980854951640.92953266421399120.91528695288504120.9206292033195496473600
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.92240931841605480.93309359623554560.92240931841605480.9295321702957152478400
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.93309410657395520.95268206864238660.93309410657395520.9491206407546996795200

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