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

CREATE TABLE IF NOT EXISTS "holdings_investor" (
  "date" TEXT,
  "investorid" TEXT,
  "investorname" TEXT,
  "shrholdings" INTEGER,
  "cllholdings" INTEGER,
  "putholdings" INTEGER,
  "wntholdings" INTEGER,
  "dbtholdings" INTEGER,
  "prfholdings" INTEGER,
  "fndholdings" INTEGER,
  "undholdings" INTEGER,
  "shrunits" REAL,
  "cllunits" REAL,
  "putunits" REAL,
  "wntunits" REAL,
  "dbtunits" REAL,
  "prfunits" REAL,
  "fndunits" REAL,
  "undunits" REAL,
  "shrvalue" REAL,
  "cllvalue" REAL,
  "putvalue" REAL,
  "wntvalue" REAL,
  "dbtvalue" REAL,
  "prfvalue" REAL,
  "fndvalue" REAL,
  "undvalue" REAL,
  "totalvalue" REAL,
  "percentoftotal" REAL
);

CREATE UNIQUE INDEX IF NOT EXISTS "holdings_investor_date_investorid_idx" ON "holdings_investor" ("date", "investorid");

CREATE INDEX IF NOT EXISTS "holdings_investor_investorid_idx" ON "holdings_investor" ("investorid");