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

Hon
@kaggle.benjaminpo_sp500_spx_components_stock_price.hon

  • 74.02 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)192.69000244140625192.69000244140625192.82000732421875192.47999572753903192.4799957275390379010
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)192.3800048828125192.3800048828125192.7545928955078192.22000122070312192.6399993896484413722
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)192.30999755859372192.30999755859372192.30999755859372192.1750030517578192.259994506835974605
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)191.9821014404297191.9821014404297192.3800048828125191.8800048828125192.25500488281255714
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)191.8300018310547191.8300018310547191.94000244140625191.80999755859372191.940002441406252508
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)191.32000732421875191.32000732421875191.5500030517578191.32000732421875191.55000305175785774
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)191.43499755859372191.43499755859372191.4980010986328191.42999267578125191.44999694824224282
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)191.3800048828125191.3800048828125191.5800018310547191.3800048828125191.49000549316417315
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)191.3249969482422191.3249969482422191.50999450683597191.25999450683597191.259994506835974351
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)191.2050018310547191.2050018310547191.2050018310547191.2050018310547191.20500183105472674

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