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

Gs
@kaggle.benjaminpo_sp500_spx_components_stock_price.gs

  • 78.76 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)370.4949951171875370.4949951171875371.2300109863281370.4949951171875371.0799865722656237160
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)370.2950134277344370.2950134277344370.8746948242188370.05999755859375370.32000732421888900
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)369.4949951171875369.4949951171875370.510009765625369.3999938964844370.3984985351562510115
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)369.5899963378906369.5899963378906369.8049926757813369.0700073242188369.640014648437515285
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)369.8981018066406369.8981018066406370.8559875488281369.7749938964844369.77499389648448884
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)370.2699890136719370.2699890136719370.739990234375369.7799987792969369.77999877929697638
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)370.7900085449219370.7900085449219371.0216979980469370.1499938964844370.23999023437513682
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)371.6437072753906371.6437072753906371.7000122070313370.80999755859375370.809997558593758913
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)372.3399963378906372.3399963378906372.3999938964844371.2999877929688371.644989013671922291
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)371.7999877929688371.7999877929688372.3363037109375371.7999877929688372.336303710937516371

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