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

Mmc
@kaggle.benjaminpo_sp500_spx_components_stock_price.mmc

  • 63.72 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)153.1999969482422153.1999969482422153.66000366210938152.47999572753906152.8800048828125302303
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)153.1649932861328153.1649932861328153.1649932861328152.89999389648438152.89999389648438612
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)152.80999755859375152.80999755859375153.10499572753906152.67999267578125153.104995727539068389
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)152.60000610351562152.60000610351562152.80999755859375152.3699951171875152.759994506835944284
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)152.6199951171875152.6199951171875152.74000549316406152.52999877929688152.639999389648443585
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)152.1999969482422152.1999969482422152.52999877929688152.1999969482422152.44999694824222938
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)152.27999877929688152.27999877929688152.4199981689453152.25999450683594152.270004272460942769
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)151.99000549316406151.99000549316406152.13999938964844151.99000549316406152.05000305175782743
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)152.11410522460938152.11410522460938152.23500061035156151.91000366210938151.91999816894536150
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)152.05999755859375152.05999755859375152.16000366210938151.85000610351562152.160003662109386254

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