-- Sharadar table schema: daily (SQLite)
-- As of 2026-08-02
-- https://api.sharadar.com/v1.0/schema/daily?format=sqlite

CREATE TABLE IF NOT EXISTS "daily" (
  "ticker" TEXT NOT NULL,
  "date" TEXT NOT NULL,
  "lastupdated" TEXT,
  "ev" REAL,
  "evebit" REAL,
  "evebitda" REAL,
  "marketcap" REAL,
  "pb" REAL,
  "pe" REAL,
  "ps" REAL,
  PRIMARY KEY ("ticker", "date")
);

CREATE INDEX IF NOT EXISTS "daily_date_idx" ON "daily" ("date");

CREATE INDEX IF NOT EXISTS "daily_lastupdated_idx" ON "daily" ("lastupdated");