Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wst
@kaggle.rprkh15_sp500_stock_prices.wst

  • 427.85 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.4612959581613540.43518486618995660.435184866189956648000
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.45259228044626660.42648118734359740.426481187343597428800
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.4612959581613540.43518486618995660.435184866189956622400
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.45259228044626660.42648118734359740.426481187343597414400
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.45259228044626660.42648118734359740.426481187343597417600
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.45259228044626660.42648118734359740.426481187343597441600
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44388841278851030.41777732968330380.417777329683303816000
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44388841278851030.41777732968330380.417777329683303838400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.40907392447645010.38296282291412350.382962822914123565600
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.41777728398640950.39166620373725890.391666203737258946400

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