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

Thb X
@kaggle.benjaminpo_sp500_spx_components_stock_price.thb_x

  • 152.63 KB
  • 9695 rows
  • 7 columns
datetime

Datetime

adj_close

Adj Close

close

Close

high

High

low

Low

open

Open

volume

Volume

Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)32.937000274658232.937000274658232.937000274658232.93500137329101632.935001373291016
Mon Feb 07 2022 00:01:00 GMT+0000 (Coordinated Universal Time)32.9389991760253932.9389991760253932.9389991760253932.937999725341832.9379997253418
Mon Feb 07 2022 00:02:00 GMT+0000 (Coordinated Universal Time)
Mon Feb 07 2022 00:03:00 GMT+0000 (Coordinated Universal Time)
Mon Feb 07 2022 00:04:00 GMT+0000 (Coordinated Universal Time)
Mon Feb 07 2022 00:05:00 GMT+0000 (Coordinated Universal Time)32.93999862670898432.93999862670898432.93999862670898432.93999862670898432.939998626708984
Mon Feb 07 2022 00:06:00 GMT+0000 (Coordinated Universal Time)32.97499847412109432.97499847412109432.97499847412109432.97499847412109432.974998474121094
Mon Feb 07 2022 00:07:00 GMT+0000 (Coordinated Universal Time)32.93999862670898432.93999862670898432.9799995422363332.9319992065429732.93199920654297
Mon Feb 07 2022 00:08:00 GMT+0000 (Coordinated Universal Time)32.94800186157226632.94800186157226632.94800186157226632.9449996948242232.94499969482422
Mon Feb 07 2022 00:09:00 GMT+0000 (Coordinated Universal Time)32.9500007629394532.9500007629394532.9780006408691432.9500007629394532.95000076293945

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