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

Hca
@kaggle.benjaminpo_sp500_spx_components_stock_price.hca

  • 73.74 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)232.375232.375233.5231.6699981689453232.72000122070312196690
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)231.72999572753903231.72999572753903231.72999572753903231.72999572753903231.729995727539032501
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)233.02999877929688233.02999877929688233.02999877929688232.2899932861328232.304992675781251215
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)233.50010681152344233.50010681152344234.30999755859372233.1499938964844233.30000305175783265
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)234234234.3999938964844233.8999938964844233.970001220703122741
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)234.19000244140625234.19000244140625234.3800048828125234234.38000488281251107
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)233.25999450683597233.25999450683597234.42999267578125233.25999450683597234.19999694824227716
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)233.4900054931641233.4900054931641233.72999572753903233.33999633789065233.63000488281252447
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)233.92999267578125233.92999267578125233.92999267578125233.3500061035156233.35000610351561041
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)233.77999877929688233.77999877929688233.82000732421875233.72999572753903233.82000732421875906

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