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

Cmi
@kaggle.benjaminpo_sp500_spx_components_stock_price.cmi

  • 70.17 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)228.67999267578125228.67999267578125228.7400054931641227.66000366210935228.130004882812552165
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)228.19000244140625228.19000244140625228.25999450683597228.19000244140625228.25999450683597203
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)228.82000732421875228.82000732421875229.1499938964844228.22000122070312228.470001220703127815
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)229.1499938964844229.1499938964844229.3699951171875229.1300048828125229.16999816894531172
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)228.8600006103516228.8600006103516229.1100006103516228.8600006103516229.1100006103516332
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)228.8600006103516228.8600006103516228.8600006103516228.8600006103516228.8600006103516528
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)227.4199981689453227.4199981689453228.41000366210935227.4199981689453228.30999755859372653
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)227.42999267578125227.42999267578125227.52999877929688227.42999267578125227.52999877929688618
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)226.6199951171875226.6199951171875227.32000732421875226.6199951171875227.070007324218752348

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