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 197 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_ESTATE · Industrial REITs
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
ABAT American Battery Technology Company Common St… CS Equity Materials Metals & Mining
$343.76M 0.900 LLM
TMCR The Metals Royalty Company Inc. Common Stock CS Equity Materials Metals & Mining
$389.97M 0.900 LLM
GMTL Guardian Metal Resources PLC American Deposit… ADRC Equity Materials Metals & Mining
$509.62M 0.950 LLM
NB NioCorp Developments Ltd. Common Stock CS Equity Materials Metals & Mining
$759.96M 0.950 LLM
GGN GAMCO Global Gold, Natural Resources & Income… FUND Equity Materials Metals & Mining
$837.36M 0.900 LLM
IPX IperionX Limited American Depositary Share ADRC Equity Materials Metals & Mining
$894.47M 0.900 LLM
SID Companhia Siderurgica Nacional S.A. (CSN) ADRC Equity Materials Metals & Mining
$1.15B 0.900 LLM