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

Apd
@kaggle.benjaminpo_sp500_spx_components_stock_price.apd

  • 79.43 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)251.75999450683597251.75999450683597252.08999633789065251.2525280899
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)252.3600006103516252.3600006103516252.3600006103516251.8000030517578251.837097167968751621
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)252.33999633789065252.33999633789065252.66000366210935252.0800018310547252.13000488281253932
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)252.30999755859372252.30999755859372252.5500030517578252252.55000305175784158
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)252.19000244140625252.19000244140625252.6699981689453251.92999267578125252.279998779296889929
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)252.83489990234372252.83489990234372252.83489990234372252.1649932861328252.16499328613282613
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)253.0072021484375253.0072021484375253.0072021484375252.6150054931641252.6254168
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)253.6000061035156253.6000061035156253.6000061035156253.1699981689453253.16999816894532765
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)252.96499633789065252.96499633789065253.42999267578125252.96499633789065253.429992675781252241
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)253.5538024902344253.5538024902344253.5538024902344253.3000030517578253.30000305175781029

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