Baselight

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Fast
@kaggle.artemburenok_sp_500_stock_prices.fast

  • 346.49 KB
  • 8901 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Thu Aug 20 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06510400027036660.06315100193023680.06315100193023680.04117494076490466969600
Fri Aug 21 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.0638019964098930.06250.06250.040750492364168117932800
Mon Aug 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06445299834012980.06315100193023680.06315100193023680.0411749407649048889600
Tue Aug 25 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06835900247097010.06640599668025970.06640599668025970.043297227472066820774400
Wed Aug 26 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06900999695062630.06705699861049650.06705699861049650.04372167959809325593600
Thu Aug 27 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06900999695062630.06770800054073330.06770800054073330.04414615035057062630400
Fri Aug 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.07031299918890.06770800054073330.06770800054073330.04414615035057067180800
Mon Aug 31 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06966099888086310.06770800054073330.06770800054073330.04414615035057064435200
Tue Sep 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06966099888086310.06770800054073330.06770800054073330.04414615035057063321600
Wed Sep 02 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.06835900247097010.06445299834012980.06445299834012980.04202385991811757372800

CREATE TABLE fast (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Share link

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