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

Chrw
@kaggle.benjaminpo_sp500_spx_components_stock_price.chrw

  • 59.11 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)89.5699996948242289.5699996948242289.9798965454101689.400001525878989.6699981689453116235
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)89.5149993896484489.5149993896484489.5299987792968889.400001525878989.440002441406251719
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)89.3700027465820389.3700027465820389.6699981689453189.3700027465820389.51999664306643453
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)89.4449996948242289.4449996948242289.4550018310546989.3300018310546989.40000152587894441
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)89.6999969482421989.6999969482421989.6999969482421989.4449996948242289.444999694824223824
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)89.4599990844726689.4599990844726689.6999969482421989.4599990844726689.619598388671882935
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)89.349998474121189.349998474121189.4199981689453189.349998474121189.419998168945311737
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)89.0100021362304789.0100021362304789.3399963378906289.0100021362304789.339996337890627185
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)88.9100036621093888.9100036621093888.9899978637695388.9100036621093888.989997863769531089
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)88.6100006103515688.6100006103515688.9024963378906288.6100006103515688.902496337890621797

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