Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Apa
@kaggle.rprkh15_sp500_stock_prices.apa

  • 505.01 KB
  • 10883 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue May 15 1979 00:00:00 GMT+0000 (Coordinated Universal Time)1.9765622615814212.0032725302092841.94985199295355761.976562261581421223491.3333333333333333
Wed May 16 1979 00:00:00 GMT+0000 (Coordinated Universal Time)1.9899166116518152.1234680345528781.9899166116518152.1101129055023266008
Thu May 17 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.1101133899415532.13682365417480472.1101133899415532.136823654174804757692
Fri May 18 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.136822632232062.2169533866090082.136822632232062.2035982608795166119023
Mon May 21 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.20359806968780752.25701856797082722.17688782054629742.2436633110046387106549
Tue May 22 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.2436645114997582.29708503836596472.2436645114997582.2703747749328613127339
Wed May 23 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.2703737571315282.2703737571315282.20359826087951662.203598260879516685759
Thu May 24 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.2035992056289842.2169543370842232.1501786798080282.17688894271850680561
Fri May 25 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.1768880094205342.2169533866090082.15017775796155152.203598260879516663410
Tue May 29 1979 00:00:00 GMT+0000 (Coordinated Universal Time)2.2035987799697232.3237948074536472.2035987799697232.283729553222656123181

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