Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Etr
@kaggle.rprkh15_sp500_stock_prices.etr

  • 534.53 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)1.25298393486502621.23074161649464121.23815572261810342000
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.23815524507136581.25298345159916651.23074114180746541.24556934833526617600
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.24556982874156461.2603980409884881.2381557226181031.23815572261810313200
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.24656614101294321.24656614101294321.23154727184411251.2390567064285278157000.265
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.23905670642852781.24656614101294321.23905670642852781.23905670642852785000
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.2390571174446061.25407599159544961.22403824329376221.224038243293762232900
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.22403713067372631.23154656092325831.21652770042419461.216527700424194318500
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.21652801443890831.23905631100259181.21652801443890831.231546878814697310600
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.23154656092325831.23154656092325831.20150883992513041.216527700424194338400
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.2090190799930431.2090190799930431.1864907741546631.186490774154663126800

CREATE TABLE etr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Share link

Anyone who has the link will be able to view this.