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

Ecl
@kaggle.benjaminpo_sp500_spx_components_stock_price.ecl

  • 71.92 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)186.80999755859372186.80999755859372187.1699981689453186.63999938964844186.6399993896484426772
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)187.33999633789065187.33999633789065187.33999633789065186.6199951171875186.809997558593722140
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)186.80999755859372186.80999755859372187.25186.80999755859372187.158996582031251585
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)186.7550048828125186.7550048828125186.7550048828125186.7550048828125186.7550048828125176
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)186.55499267578125186.55499267578125186.7100067138672186.42999267578125186.63000488281252618
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)186.6100006103516186.6100006103516186.6100006103516186.2700042724609186.559997558593723819
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)186.3249969482422186.3249969482422186.6100006103516186.1100006103516186.60249328613281498
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)186.63999938964844186.63999938964844186.75186.55999755859372186.55999755859372782
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)187.00999450683597187.00999450683597187.00999450683597186.82000732421875186.82000732421875690
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)186.47000122070312186.47000122070312186.81500244140625186.22000122070312186.815002441406251666

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