Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mcd
@kaggle.rprkh15_sp500_stock_prices.mcd

  • 664.74 KB
  • 14101 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jul 05 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12397477850146390.12117828031521190.1221101358532905388800
Wed Jul 06 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12863548099994660.12117831253314590.1286354809999466692550
Thu Jul 07 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.13189760398863870.12304243361194360.12397474795579911858950
Fri Jul 08 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12537285685539240.12117833712724120.12537285685539241239300
Mon Jul 11 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.1286354189239990.12350858769978610.1249066069722175656100
Tue Jul 12 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12397482387454950.12257634475185620.1230425089597702303750
Wed Jul 13 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12444056471756460.12211022879493050.122576393187046291600
Thu Jul 14 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12304252091764040.12117833644151680.1211783364415168328050
Fri Jul 15 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12164442779930390.11931363493204110.1193136349320411376650
Mon Jul 18 1966 00:00:00 GMT+0000 (Coordinated Universal Time)0.12304244718444620.11838177952076820.1193136349320411607500

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