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

Mrk
@kaggle.benjaminpo_sp500_spx_components_stock_price.mrk

  • 59.69 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)
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)76.7600021362304776.7600021362304777.3300018310546976.7099990844726677.0999984741211548028
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)76.4899978637695376.4899978637695376.7399978637695376.4199981689453176.6999969482421993209
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)76.5299987792968876.5299987792968876.6149978637695376.3000030517578176.519996643066469225
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)76.4950027465820376.4950027465820376.5400009155273476.2576.54000091552734107554
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)76.6800003051757876.6800003051757876.7099990844726676.4100036621093876.5100021362304777637
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)76.5599975585937576.5599975585937576.6800003051757876.4899978637695376.6650009155273450563
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)76.4400024414062576.4400024414062576.605003356933676.4199981689453176.5699996948242239497
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)76.6100006103515676.6100006103515676.6100006103515676.4349975585937576.4400024414062588233
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)76.5599975585937576.5599975585937576.6949996948242276.5400009155273476.6200027465820347900

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

Share link

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