storage.sqlite — index_minute_data

CREATE TABLE index_minute_data (
  ticker_id INTEGER NOT NULL REFERENCES tickers,
  timestamp INTEGER NOT NULL,
  trade_open_price REAL NOT NULL,
  trade_high_price REAL NOT NULL,
  trade_low_price REAL NOT NULL,
  trade_close_price REAL NOT NULL,
  CHECK(trade_low_price>0 AND trade_high_price<=1.7976931348623157e308 AND trade_open_price BETWEEN trade_low_price AND trade_high_price AND trade_close_price BETWEEN trade_low_price AND trade_high_price),
  PRIMARY KEY(ticker_id,timestamp)
)