Read-only view of securities_master . Every connection runs with default_transaction_read_only=on ; the ETL in data/ is the only writer.
Classified securities 5,783 assignments matching classification.v_security_classification
Classifications are unreviewed model output. All 5,771 assignments carry source = LLM and is_reviewed = false. Confidence is the model’s own estimate and is not calibrated — it clustered at 0.90–0.98 across the whole first pass, including rows that later proved wrong. Use it to order a review queue, not as a probability. Two share classes of one issuer can disagree.
REAL_ASSET · Infrastructure
FINANCIAL · Insurance
COMMUNICATION · Interactive Media
CORPORATE_CREDIT · Investment Grade
HEALTHCARE · Life Sciences Tools
HEDGE_STRATEGY · Long/Short
INDUSTRIALS · Machinery
HEDGE_STRATEGY · Managed Futures
COMMUNICATION · Media & Entertainment
HEALTHCARE · Medical Devices
MATERIALS · Metals & Mining
FINANCIAL · Mortgage Finance
SECURITIZED · Non-Agency MBS
GOVERNMENT · Non-US Sovereign
ENERGY · Oil & Gas Exploration
ENERGY · Oil & Gas Midstream
ENERGY · Oil & Gas Refining
HEALTHCARE · Pharmaceuticals
COMMODITY · Precious Metals
REAL_ESTATE · Real Estate Services
ENERGY · Renewable Energy
MONEY_MARKET · Repurchase Agreements
REAL_ESTATE · Residential REITs
CONSUMER_DISCRETIONARY · Retail
MUNICIPAL · Revenue
TECHNOLOGY · Semiconductors
TECHNOLOGY · Software
CONSUMER_STAPLES · Staples Retail
TECHNOLOGY · Technology Hardware
COMMUNICATION · Telecommunications
INDUSTRIALS · Transportation
MONEY_MARKET · Treasury Bills
GOVERNMENT · US Agency
GOVERNMENT · US Treasury
UTILITIES · Water Utilities
SNY Sanofi American Depositary Shares (Each repre… ADRC Equity Health Care Pharmaceuticals
$104.74B 0.950 LLM
PBR.A Petroleo Brasileiro S.A.-Petrobras ADRC Equity Energy Oil & Gas Exploration
$102.92B 0.950 LLM
GSK GSK plc American Depositary Shares (Each repr… ADRC Equity Health Care Pharmaceuticals
$100.74B 0.950 LLM
CEG Constellation Energy Corporation Common Stock CS Equity Utilities Electric Utilities
$98.74B 0.950 LLM
CNQ Canadian Natural Resources Limited CS Equity Energy Oil & Gas Exploration
$98.07B 0.950 LLM
MPC MARATHON PETROLEUM CORPORATION CS Equity Energy Oil & Gas Refining
$97.80B 0.950 LLM
EQNR Equinor ASA American Depositary Shares (Each … ADRC Equity Energy Oil & Gas Exploration
$97.34B 0.950 LLM
VLO Valero Energy Corporation CS Equity Energy Oil & Gas Refining
$95.08B 0.950 LLM