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 876 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
PAX Patria Investments Limited Class A Common Sha… CS Equity Financials Asset Management
$1.79B 0.950 LLM
PGY Pagaya Technologies Ltd. Class A Ordinary Sha… CS Equity Financials Financial Technology
$1.69B 0.900 LLM
QFIN Qfin Holdings, Inc. American Depositary Shares ADRC Equity Financials Consumer Finance
$1.53B 0.950 LLM
TOP TOP Financial Group Limited Class A Ordinary … CS Equity Financials Capital Markets
$1.34B 0.950 LLM
LU Lufax Holding Ltd. American Depositary Shares… ADRC Equity Financials Consumer Finance
$1.33B 0.800 LLM
PWP Perella Weinberg Partners Class A Common Stock CS Equity Financials Capital Markets
$1.28B 0.950 LLM