storage.sqlite — daily_volatility

CREATE TABLE daily_volatility (
  ticker_id INTEGER NOT NULL REFERENCES tickers,
  day INTEGER NOT NULL,
  implied_open REAL NOT NULL,
  implied_high REAL NOT NULL,
  implied_low REAL NOT NULL,
  implied_close REAL NOT NULL,
  historical_open REAL NOT NULL,
  historical_high REAL NOT NULL,
  historical_low REAL NOT NULL,
  historical_close REAL NOT NULL,
  CHECK(implied_low>=0 AND implied_high<=1.7976931348623157e308 AND implied_open BETWEEN implied_low AND implied_high AND implied_close BETWEEN implied_low AND implied_high),
  CHECK(historical_low>=0 AND historical_high<=1.7976931348623157e308 AND historical_open BETWEEN historical_low AND historical_high AND historical_close BETWEEN historical_low AND historical_high),
  PRIMARY KEY(ticker_id,day)
)