Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Cpb
@kaggle.rprkh15_sp500_stock_prices.cpb

  • 526.79 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.74601429700851440.72623378736472490.7460142970085144268800
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.76014394602081480.74601470712405540.7573179602622986208000
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.75731796026229860.7516663336931770.7573179602622986390400
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.76296974169580560.75166648626327510.7516664862632751403200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.75731811397954040.75166648626327510.751666486263275164000
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.75449247259539810.75166648626327510.751666486263275189600
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.75731754486377420.73471105098724370.7347110509872437176000
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.72905936837196350.71210449934005740.7234077453613281150400
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.72340842216245590.6951502806717350.700801908969879265600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.71493089199066160.7008016539136190.714930891990661652800

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