Baselight
Sign In

2000+ Assets (Stock & FX) Historical Price

frequency update, 2000+ assets, since IPO, included S&P500, NASDAQ and FX

@kaggle.benjaminpo_sp500_spx_components_stock_price

Glw
@kaggle.benjaminpo_sp500_spx_components_stock_price.glw

  • 55.89 KB
  • 1951 rows
  • 7 columns
datetime

Datetime

adj_close

Adj Close

close

Close

high

High

low

Low

open

Open

volume

Volume

Tue Feb 08 2022 14:30:00 GMT+0000 (Coordinated Universal Time)42.5999984741210942.5999984741210942.5999984741210942.4850006103515642.56999969482422151146
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)42.7542.7542.8199996948242242.65000152587890642.700000762939459294
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)42.72000122070312542.72000122070312542.72000122070312542.6991996765136742.69919967651367601
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)42.63000106811523442.63000106811523442.81000137329101642.61999893188476642.7700004577636714051
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)42.5800018310546942.5800018310546942.6599998474121142.5800018310546942.639999389648444138
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)42.5349998474121142.5349998474121142.65000152587890642.5349998474121142.5800018310546910648
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)42.5900001525878942.5900001525878942.5900001525878942.52500152587890642.549999237060558040
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)42.56000137329101642.56000137329101642.6100006103515642.54000091552734442.58499908447265610578
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)42.47000122070312542.47000122070312542.5499992370605542.45999908447265642.549999237060556452
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)42.45999908447265642.45999908447265642.4799995422363342.4500007629394542.4700012207031253125

CREATE TABLE glw (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);