Query

storage.sqlite — index_minute_data

SQL

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)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
ticker_id INTEGER ✓ Rename | Drop
timestamp INTEGER ✓ Rename | Drop
trade_open_price REAL Rename | Drop
trade_high_price REAL Rename | Drop
trade_low_price REAL Rename | Drop
trade_close_price REAL Rename | Drop

Foreign Keys

Column Destination
ticker_id tickers.None

+ Add index

Indexes

Name Columns Unique SQL Drop?

Triggers

Name SQL Drop?
index_prices_are_vix SQL 
CREATE TRIGGER index_prices_are_vix BEFORE INSERT ON index_minute_data
 WHEN (SELECT symbol FROM tickers WHERE id=NEW.ticker_id) IS NOT 'VIX' BEGIN SELECT RAISE(ABORT,'only VIX prices go to index_minute_data'); END
Drop