Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Efx
@kaggle.rprkh15_sp500_stock_prices.efx

  • 466.56 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.25585349257996810.25070208208786910.25241911411285457600
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.25070182987462880.24726745486259460.247267454862594619200
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24726745486259460.24726745486259460.24726745486259460.2472674548625946
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24898463487625120.24898463487625120.24898463487625122400
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24555052969192240.24383318424224850.243833184242248512000
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24726756072463370.24383318424224850.24383318424224859600
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24211621284484860.24211621284484860.24211621284484862400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24211615327130850.24039912223815910.24039912223815919600
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24383318430445790.24039912223815910.240399122238159128800
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.24039918380631220.23524777497058440.238681837916374267200

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