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

Cms
@kaggle.benjaminpo_sp500_spx_components_stock_price.cms

  • 54.29 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)65.2399978637695365.2399978637695365.4499969482421964.9599990844726665.3099975585937512800
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)65.1999969482421965.1999969482421965.1999969482421965.1699981689453165.180000305175781233
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)65.1999969482421965.1999969482421965.2600021362304765.1999969482421965.209999084472663927
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)65.2900009155273465.2900009155273465.2900009155273465.1999969482421965.279998779296881226
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)65.1999969482421965.1999969482421965.2900009155273465.1999969482421965.290000915527341256
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)65.1100006103515665.1100006103515665.2200012207031265.1100006103515665.220001220703123912
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)65.0800018310546965.0800018310546965.1149978637695365.0800018310546965.11499786376953774
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)65.099998474121165.099998474121165.150001525878965.0699996948242265.120002746582031159
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)65.1999969482421965.1999969482421965.2200012207031265.1100006103515665.139999389648441766
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)65.1200027465820365.1200027465820365.1800003051757865.1200027465820365.180000305175782956

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