-- Sharadar table schema: holdings_investor (PostgreSQL)
-- As of 2026-08-02
-- https://api.sharadar.com/v1.0/schema/holdings_investor?format=postgres

CREATE TABLE IF NOT EXISTS holdings_investor (
  date text NOT NULL,
  investorname text NOT NULL,
  shrholdings bigint,
  cllholdings bigint,
  putholdings bigint,
  wntholdings bigint,
  dbtholdings bigint,
  prfholdings bigint,
  fndholdings bigint,
  undholdings bigint,
  shrunits double precision,
  cllunits double precision,
  putunits double precision,
  wntunits double precision,
  dbtunits double precision,
  prfunits double precision,
  fndunits double precision,
  undunits double precision,
  shrvalue double precision,
  cllvalue double precision,
  putvalue double precision,
  wntvalue double precision,
  dbtvalue double precision,
  prfvalue double precision,
  fndvalue double precision,
  undvalue double precision,
  totalvalue double precision,
  percentoftotal double precision,
  PRIMARY KEY (date, investorname)
);

CREATE INDEX IF NOT EXISTS holdings_investor_investorname_idx ON public.holdings_investor USING btree (investorname);