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

Now
@kaggle.benjaminpo_sp500_spx_components_stock_price.now

  • 83.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)563.989990234375563.989990234375567.0399780273438563.969970703125564.200012207031225692
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)568.719970703125568.719970703125569.8699951171875566.3099975585938567.29998779296883432
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)567.5399780273438567.5399780273438569.0050048828125567.5569.00500488281251515
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)568.9500122070312568.9500122070312569.010009765625567.7100219726562567.729980468754007
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)567.4450073242188567.4450073242188568.739990234375566.9249877929688568.5300292968753190
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)570570570567.2999877929688568.36999511718752608
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)572.2103881835938572.2103881835938572.2103881835938571.489990234375571.8099975585938924
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)573.157470703125573.157470703125573.4199829101562571.6900024414062572.21392822265623796
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)572572573.1699829101562572573.09997558593753765
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)573.7000122070312573.7000122070312573.7000122070312573.7000122070312573.7000122070312598

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