Baselight

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Vrsk
@kaggle.artemburenok_sp_500_stock_prices.vrsk

  • 156.04 KB
  • 3320 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Wed Oct 07 2009 00:00:00 GMT+0000 (Coordinated Universal Time)2728.9699993133544926.4099998474121127.2199993133544926.5577087402343763739500
Thu Oct 08 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.3299999237060527.44000053405761726.526.60000038146972725.952798843383796906700
Fri Oct 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.8299999237060527.48999977111816426.379999160766626.39999961853027725.7576656341552773361300
Mon Oct 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.29000091552734427.89999961853027726.10000038146972726.2525.611314773559577177000
Tue Oct 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.67000007629394527.2600002288818426.54000091552734427.19000053405761726.52844810485843296000
Wed Oct 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.2528.2399997711181642727.98999977111816427.3089771270751953222400
Thu Oct 15 2009 00:00:00 GMT+0000 (Coordinated Universal Time)28.28000068664550828.79999923706054727.7528.30999946594238327.6211929321289033181300
Fri Oct 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)28.45000076293945328.60000038146972727.54999923706054728.5699996948242227.8748664855957033974100
Mon Oct 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)28.52000045776367228.8899993896484427.527.526.830902099609371892100
Tue Oct 20 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.528.10000038146972727.35000038146972728.05999946594238327.3772773742675753387000

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