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

Swks
@kaggle.benjaminpo_sp500_spx_components_stock_price.swks

  • 74.89 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)136.1300048828125136.1300048828125136.46499633789062135.85000610351562135.8500061035156219745
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)135.8300018310547135.8300018310547136.35000610351562135.8300018310547136.214996337890624502
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)135.8300018310547135.8300018310547136.01499938964844135.8300018310547135.83000183105471010
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)135.39999389648438135.39999389648438135.75135.3800048828125135.753131
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)135.1649932861328135.1649932861328135.4199981689453134.86000061035156135.419998168945311138
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)135.30999755859375135.30999755859375135.55990600585938135.25999450683594135.259994506835943851
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)135.55499267578125135.55499267578125135.55499267578125135.47000122070312135.55000305175782305
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)135.8300018310547135.8300018310547135.97999572753906135.67999267578125135.679992675781255063
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)135.77999877929688135.77999877929688135.84500122070312135.77999877929688135.845001220703122609
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)135.63999938964844135.63999938964844135.7100067138672135.5135.69999694824223050

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