Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mar
@kaggle.rprkh15_sp500_stock_prices.mar

  • 313.91 KB
  • 6117 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 23 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.48097419738769513.48097419738769513.48097419738769513.4809741973876951073
Tue Mar 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.6682050126152213.99586772918701213.6682050126152213.995867729187012116711
Wed Mar 25 1998 00:00:00 GMT+0000 (Coordinated Universal Time)14.18310481283718814.20650863647460814.0426772739151114.2065086364746127891
Thu Mar 26 1998 00:00:00 GMT+0000 (Coordinated Universal Time)14.1128947235977414.13630008697509813.97246867279892314.13630008697509876163
Fri Mar 27 1998 00:00:00 GMT+0000 (Coordinated Universal Time)14.08949126031260614.08949126031260613.62140083657827313.808637619018556847444
Mon Mar 30 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.62139512500759213.78522647476372913.38735077746046413.457565307617188384890
Tue Mar 31 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.5277759824923813.6447981361715413.29373167513406413.410752296447754644701
Wed Apr 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.10649774585468713.1533069235941412.63840903319173713.0596885681152341004918
Thu Apr 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.0596908178704413.7150163543822413.0596908178704413.6682071685791021046539
Fri Apr 03 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.6213992498584413.9490620485940113.38735483143765813.878849029541016766990

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