Baselight
Sign In

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

Nwsa
@kaggle.benjaminpo_sp500_spx_components_stock_price.nwsa

  • 51.57 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)22.54999923706054722.54999923706054722.69000053405761722.45000076293945322.54000091552734418476
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)22.6399993896484422.6399993896484422.6399993896484422.53000068664550822.5499992370605475942
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)22.60000038146972722.60000038146972722.69000053405761722.60000038146972722.69000053405761710601
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)22.620000839233422.620000839233422.620000839233422.60000038146972722.610000610351565379
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)22.64999961853027722.64999961853027722.64999961853027722.60000038146972722.629999160766611070
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)22.64999961853027722.64999961853027722.69000053405761722.6399993896484422.6499996185302776514
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)22.6800003051757822.6800003051757822.6800003051757822.6399993896484422.6499996185302778225
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)22.70000076293945322.70000076293945322.7150001525878922.69000053405761722.6900005340576174151
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)22.69000053405761722.69000053405761722.70999908447265622.68499946594238322.70000076293945314066
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)22.7199993133544922.7199993133544922.72500038146972722.70999908447265622.7099990844726563576

CREATE TABLE nwsa (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);