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

Wu
@kaggle.benjaminpo_sp500_spx_components_stock_price.wu

  • 55.75 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)18.2600002288818418.2600002288818418.35000038146972718.2518.27000045776367247474
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)18.20999908447265618.20999908447265618.2518.17000007629394518.255896
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)18.2518.2518.2518.20000076293945318.21999931335449627
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)18.20000076293945318.20000076293945318.27000045776367218.18009948730468818.2399997711181643008
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)18.19000053405761718.19000053405761718.2199993133544918.19000053405761718.2000007629394532063
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)18.120000839233418.120000839233418.20000076293945318.11499977111816418.20000076293945319329
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)18.0949993133544918.0949993133544918.129999160766618.0949993133544918.11499977111816417318
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)18.1100006103515618.1100006103515618.120000839233418.0900001525878918.10000038146972713517
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)18.11499977111816418.11499977111816418.120000839233418.10000038146972718.1149997711181647887
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)18.07500076293945318.07500076293945318.129999160766618.07500076293945318.120000839233420373

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