Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pfg
@kaggle.rprkh15_sp500_stock_prices.pfg

  • 266.21 KB
  • 5215 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Oct 23 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.14145097278413112.6685672632828812.0822241567414812.43758392333984432584000
Wed Oct 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.4968062478832513.14829873088325712.43757945312740213.1186847686767585847500
Thu Oct 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.02984839750569213.11868804701174412.82255512888661613.0002355575561522038800
Fri Oct 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.00023512671590913.02984796568404812.67448824977936712.7337150573730493339100
Mon Oct 29 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.02984919530583613.02984919530583612.43758332279193412.5560369491577171758700
Tue Oct 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.674493937270313.177920333235612.43758773024483813.0535449981689442225300
Wed Oct 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.2667552807959314.20845810579784413.0002363167142113.3259820938110355101800
Thu Nov 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.40297537729408413.40297537729408412.85216909849358813.0002355575561522747400
Fri Nov 02 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.08907906856824413.17791874428354313.0002393928529413.1364603042602541183800
Mon Nov 05 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.0890777809810813.14830460218432912.88178447159853813.0298509597778321144000

CREATE TABLE pfg (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Share link

Anyone who has the link will be able to view this.