Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Txn
@kaggle.rprkh15_sp500_stock_prices.txn

  • 618.21 KB
  • 12637 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.77411778239584820.7676125545487880.7729350924491882825600
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.7812144457181980.78890236440254640.7812144457181980.78712832927703862496000
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.7871284336075290.79599904355131050.78535439824688050.7883111238479614960000
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.78831108178558920.79008511705157950.75519359111785890.75519359111785891824000
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.75519374798052940.75874225239009190.75223702192306520.7522370219230652604800
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.75223706639643510.76169902348033090.75164572114998110.75341975688934331180800
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.75341950306460970.75460219315907320.74395754916841740.7498714327812195451200
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.75282815868911950.75519353888015680.75282815868911950.7546021938323975153600
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.7581507038665470.78594565391540520.7581507038665470.7859456539154053700800
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.79008498809331640.80309544420136670.79008498809331640.7995473742485046787200

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