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

Mkc
@kaggle.benjaminpo_sp500_spx_components_stock_price.mkc

  • 58.83 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)102.3499984741211102.3499984741211102.5199966430664102.30999755859376102.480003356933618272
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)101.94499969482422101.94499969482422102.29000091552734101.9000015258789102.290000915527341672
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)102.13999938964844102.13999938964844102.13999938964844101.98999786376952102.029998779296881805
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)102.05999755859376102.05999755859376102.30999755859376102.05999755859376102.05999755859376605
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)101.88999938964844101.88999938964844102.2300033569336101.88999938964844102.23000335693361168
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)102.0250015258789102.0250015258789102.0250015258789101.97000122070312101.97000122070312603
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)102.01200103759766102.01200103759766102.05999755859376101.91500091552734101.915000915527341461
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)102.16999816894533102.16999816894533102.16999816894533102.04000091552734102.040000915527341208
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)102.0500030517578102.0500030517578102.11000061035156102.0500030517578102.11000061035156521

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