UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2343 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 20297 AND Type_ = 1;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 22164 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67390 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 73855 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74386 AND Type_ = 10;
UPDATE model_universe SET OrgPermID = 6000145979, PriInstrPermID = 8590935125.0, PermOrgIPODate = '1996-08-01' WHERE SecCode = 75029 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-22' WHERE SecCode = 76880 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 78460 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82584 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 84781 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88601 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91746 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94501 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95337 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95877 AND Type_ = 10;
UPDATE model_universe SET PriInstrPermID = NULL WHERE SecCode = 97949 AND Type_ = 1;
UPDATE model_universe SET IncCntry = 'JPN' WHERE SecCode = 98717 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98993 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113724 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 123750 AND Type_ = 10;
UPDATE model_universe SET RkdIssueStatus = 1 WHERE SecCode = 144974 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, RkdTicker = 'ETIHADENERGY', RkdRIC = 'ETIHAD.DU', RkdDisplayRIC = 'ETIHAD.DU', Name = 'ETIHAD ENERGY HOLD AED1' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 195140 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 283464 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 299990 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 322233 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 341321 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 359140 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 558540 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BT5J2R5' WHERE SecCode = 588831 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 637304 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 853527 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2729683 AND Type_ = 10;
UPDATE model_universe SET IsPrimaryInstr = 1 WHERE SecCode = 2912882 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3076058 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3217958 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3358921 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3390477 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3436907 AND Type_ = 10;
UPDATE model_universe SET Name = 'BOOSTHEAT EUR0.2' WHERE SecCode = 3978248 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 4434255 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4440272 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE model_universe SET Name = 'DOLPHIN DRILLING NOK2.5' WHERE SecCode = 5155393 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5272018 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5399782 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 6880028 AND Type_ = 10;
UPDATE model_universe SET Name = 'PARKIT ENTERPRISE INC COM SHS' WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951210.0 WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE model_universe SET RkdIssueStatus = 1 WHERE SecCode = 10973754 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 10987798 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BX55HP4' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BRSCWV1' WHERE SecCode = 11138087 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BRSCZS9' WHERE SecCode = 11198767 AND Type_ = 1;
UPDATE model_universe SET Name = 'FIRY INC COM' WHERE SecCode = 11207267 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 6000156910, PriInstrPermID = 25727305270.0, IsPrimaryInstr = 1, PermOrgIPODate = '2020-11-06', startDate = '2020-11-06' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE model_universe SET RkdIssueStatus = 1 WHERE SecCode = 11232560 AND Type_ = 1;
UPDATE model_universe SET Name = 'SMARTBIRD INC COM CL A' WHERE SecCode = 11233216 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BRSCV25' WHERE SecCode = 11264467 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2025-02-03' WHERE SecCode = 11274579 AND Type_ = 1;
UPDATE model_universe SET Name = 'TEAMSHARES INC CL A SHS', DsPrimQtSedol = 'BVSRPN7' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 5086637871, PriInstrPermID = 232883208784.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11295860 AND Type_ = 1;
