Baselight

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

Fast
@kaggle.benjaminpo_sp500_spx_components_stock_price.fast

  • 57.01 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)53.7000007629394553.7000007629394553.7000007629394553.3499984741210953.4399986267089844750
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)53.5499992370605553.5499992370605553.7000007629394553.54000091552734453.700000762939459130
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)53.5149993896484453.5149993896484453.6100006103515653.47000122070312553.569999694824226180
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)53.4099998474121153.4099998474121153.5499992370605553.4099998474121153.5400009155273442685
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)53.38000106811523453.38000106811523453.4500007629394553.3300018310546953.419998168945313368
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)53.3199996948242253.3199996948242253.4199981689453153.3199996948242253.349998474121095507
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)53.36999893188476653.36999893188476653.36999893188476653.2999992370605553.299999237060556865
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)53.3400001525878953.3400001525878953.3499984741210953.3300018310546953.349998474121095271
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)53.3499984741210953.3499984741210953.38000106811523453.3499984741210953.3800010681152346711
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)53.240001678466853.240001678466853.3499984741210953.240001678466853.349998474121097770

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