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

Trv
@kaggle.benjaminpo_sp500_spx_components_stock_price.trv

  • 60.26 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)172.77000427246094172.77000427246094172.77000427246094172.02999877929688172.67999267578125158441
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)172.6699981689453172.6699981689453172.91000366210938172.6699981689453172.91000366210938378
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)172.42999267578125172.42999267578125172.44000244140625172.41000366210938172.440002441406251417
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)172.17999267578125172.17999267578125172.36000061035156172.17999267578125172.240005493164061496
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)172.47000122070312172.47000122070312172.47000122070312172.17999267578125172.17999267578125496
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)172.13499450683594172.13499450683594172.5093994140625172.0800018310547172.50939941406252480
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)171.9199981689453171.9199981689453172.05999755859375171.9199981689453172.059997558593751767
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)171.77000427246094171.77000427246094171.77000427246094171.77000427246094171.77000427246094101
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)171.9499969482422171.9499969482422171.9499969482422171.75999450683594171.88000488281251325
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)171.72000122070312171.72000122070312171.72000122070312171.72000122070312171.72000122070312526

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