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

Hrl
@kaggle.benjaminpo_sp500_spx_components_stock_price.hrl

  • 49.67 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)47.61999893188476647.61999893188476647.7000007629394547.45999908447265647.5299987792968827948
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)47.4199981689453147.4199981689453147.5499992370605547.4199981689453147.549999237060551465
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)47.490001678466847.490001678466847.490001678466847.4199981689453147.419998168945312207
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)47.54000091552734447.54000091552734447.5449981689453147.4199981689453147.41999816894531769
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)47.5200004577636747.5200004577636747.5200004577636747.4399986267089847.43999862670898859
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)47.490001678466847.490001678466847.54000091552734447.47000122070312547.520000457763672797
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)47.5200004577636747.5200004577636747.5200004577636747.490001678466847.49000167846682990
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)47.5149993896484447.5149993896484447.56000137329101647.547.520000457763674366
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)47.5200004577636747.5200004577636747.56000137329101647.5200004577636747.5600013732910162362
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)47.5206985473632847.5206985473632847.56000137329101647.5206985473632847.529998779296881929

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