UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-15', SecMapEndDate = '2025-09-11', PermQuoteRetireDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-11' WHERE SecCode = 697 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 915 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 1413 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2587 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3726 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3727 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 4.0 WHERE SecCode = 4537 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4798 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6319 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 9703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 10228 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 10823 AND Type_ = 10;
UPDATE data_universe SET Name = 'BIO GREEN MED SOLUTION  INC COM JUNE 2025' WHERE SecCode = 18200 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIO GREEN MED SOLUTION  INC PFD CONV EX 6%' WHERE SecCode = 18201 AND Type_ = 1;
UPDATE data_universe SET Name = 'DURECT CORP COM NEW', PermOrgIPODate = NULL WHERE SecCode = 22244 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951370.0 WHERE SecCode = 24355 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 27831 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1992-04-09' WHERE SecCode = 28670 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 29232 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 29237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GREEN EARTH GROUP EUR0.02' WHERE SecCode = 36076 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 41247 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 43390 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096762193.0, PermOrgIPODate = '1993-10-27', startDate = '1993-10-27' WHERE SecCode = 45120 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 45301 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 48471 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 51257 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 53012 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 53655 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 53984 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 55037 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 56762 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'DGRG.F', RkdDisplayRIC = 'DGRG.F', RkdExchCode = 'FRA', QuotePermID = 55836397121.0, PriValQuotePermID = 55836397121.0, ExchCode = 'FRA' WHERE SecCode = 59308 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BTBB', QuotePermID = 21474924570.0, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06', endDate = '2023-11-03' WHERE SecCode = 59414 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 64039 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 66291 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 67561 AND Type_ = 10;
UPDATE data_universe SET Name = 'SANOFI SA SPONSORED ADR' WHERE SecCode = 68127 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '1757.T^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 69984 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GYET CO LTD NPV', PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 72106 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE305A01023', RkdSEDOL = 'BVPGMZ', DsPrimQtSedol = 'BVPGMZ8' WHERE SecCode = 72200 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951989.0 WHERE SecCode = 73818 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 74556 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000419624', RkdTicker = 'GA8', PermIDTicker = 'GA8', RkdSEDOL = 'BVPGHD', RkdCUSIP = 'Q9118P22', RkdRIC = 'GA8.AX', RkdDisplayRIC = 'GA8.AX', Name = 'GOLDARC RESOURCES NPV', DsPrimQtSedol = 'BVPGHD1', PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 74740 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5096776198.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 74992 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 74993 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '', QuotePermID = 55838787463.0, InstrPermID = 8590012870.0, PriValQuotePermID = 55838787463.0, PermSecMapStartDate = '2000-02-22', startDate = '2000-02-22' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75698 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951274.0 WHERE SecCode = 75919 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 76313 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'INTELLIMARK AI INT HKD0.1' WHERE SecCode = 76927 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 76948 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GANESH HOUSING LTD INR10(DEMAT)' WHERE SecCode = 78667 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 78834 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'ANTELOPUS', PermIDTicker = 'ANTELOPUS', RkdRIC = 'ANTL.NS', RkdDisplayRIC = 'ANTL.NS' WHERE SecCode = 79139 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdISIN = 'INE768C01028', RkdSEDOL = 'BMYS75', RkdCUSIP = 'Y9896K11', Name = 'ZYDUS WELLNESS LTD INR2(POST SUBD)', DsPrimQtSedol = 'BMYS757' WHERE SecCode = 79392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79893 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = NULL WHERE SecCode = 80309 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81729 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82108 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 82119 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '', QuotePermID = 55838792474.0, InstrPermID = 8590011819.0, PriValQuotePermID = 55838792474.0, PermSecMapStartDate = '2001-09-13', startDate = '2001-09-13' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 82468 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 82586 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 82610 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 83038 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83062 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 83505 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83510 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 84791 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, RkdISIN = 'INE133B01027', RkdSEDOL = 'BMVD3V', RkdCUSIP = 'Y4S6DW13', Name = 'KESAR ENTERPRISES INR1(POST SUBD)', DsPrimQtSedol = 'BMVD3V3' WHERE SecCode = 86206 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 88557 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88710 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90284 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 90297 AND Type_ = 10;
UPDATE data_universe SET Name = 'APOLLO SILVER CORP COM NEW', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90372 AND Type_ = 1;
UPDATE data_universe SET Name = 'MPR AUSTRALIA LTD NPV' WHERE SecCode = 90560 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 90958 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-15' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 92234 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 92577 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 92955 AND Type_ = 10;
UPDATE data_universe SET Name = 'DPM METALS INC COM', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 93359 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 93473 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 93474 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95444 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8506K14' WHERE SecCode = 95744 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000417149', RkdTicker = 'SOLDA', PermIDTicker = 'SOLDA', RkdSEDOL = 'BT8NLQ', RkdRIC = 'SOLDA.AX', RkdDisplayRIC = 'SOLDA.AX', Name = 'WASHINGTON H SOUL NPV DFD 23/09/25 (EX-SPLIT)', DsPrimQtSedol = 'BT8NLQ6', OrgPermID = 5095369017.0, PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'MNX.H', PermIDTicker = 'MNX.H', RkdRIC = 'MNXh.V', RkdDisplayRIC = 'MNXh.V', RkdExchCode = 'NEX', ExchCode = 'NEX' WHERE SecCode = 96381 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 96922 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951889.0 WHERE SecCode = 97070 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 97211 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951616.0 WHERE SecCode = 97291 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA98956J1066', RkdSEDOL = 'BVN5M6', RkdCUSIP = '98956J10', Name = '01 QUANTUM INC. COM', DsPrimQtSedol = 'BVN5M68', PermSecMapEndDate = '2025-09-17', endDate = '2025-09-17' WHERE SecCode = 97479 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '', QuotePermID = 55834997382.0, InstrPermID = 8590928464.0, PriValQuotePermID = 55834997382.0, PermSecMapStartDate = '1990-03-23' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CEMPRO', PermIDTicker = 'CEMPRO', RkdRIC = 'CEMI.NS', RkdDisplayRIC = 'CEMI.NS', Name = 'CEMINDIA PROJECTS INR1' WHERE SecCode = 97785 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TRA.H', RkdRIC = 'TRAh.V', RkdDisplayRIC = 'TRAh.V', RkdExchCode = 'NEX' WHERE SecCode = 98247 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 99011 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = NULL WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '', QuotePermID = 55834788915.0, InstrPermID = 8589984984.0, PriValQuotePermID = 55834788915.0, PermSecMapStartDate = '1995-01-19', startDate = '1995-01-19' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99460 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'HOENLE AG NPV' WHERE SecCode = 99529 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 99982 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5096776198.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1990-10-04' WHERE SecCode = 100020 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 100312 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'NF.CD^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-17', PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17', endDate = '2025-09-17' WHERE SecCode = 100742 AND Type_ = 1;
UPDATE data_universe SET RkdCode = 17605.0, RkdIssueCode = 25193.0 WHERE SecCode = 100845 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ALXIL', PermIDTicker = 'ALXIL', RkdRIC = 'ALXIL.PA', RkdDisplayRIC = 'ALXIL.PA' WHERE SecCode = 102258 AND Type_ = 10;
UPDATE data_universe SET Name = 'TMC CONTENT GROUP CHF0.20 (REGD)' WHERE SecCode = 104532 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000SYA5', RkdTicker = 'SYA', PermIDTicker = 'SYA', RkdSEDOL = 'BBX4LR', RkdCUSIP = 'Q8329N31', RkdRIC = 'SYA.AX', RkdDisplayRIC = 'SYA.AX', Name = 'SAYONA MINING LTD NPV DFD 19/09/25 (EX-SPLIT)', DsPrimQtSedol = 'BBX4LR9', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 111747 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 112954 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116434 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ALCAP.PA^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2015-10-09', endDate = '2015-10-09' WHERE SecCode = 116794 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 120434 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 124043 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 132725 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'EURO PRATIK SALES INR1', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 134942 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 135281 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000413502', RkdTicker = 'OB1DD', PermIDTicker = 'OB1DD', RkdSEDOL = 'BTQM15', RkdRIC = 'OB1DD.AX', RkdDisplayRIC = 'OB1DD.AX', DsPrimQtSedol = 'BTQM154' WHERE SecCode = 140027 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 141593 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEVERLY WILSHIRE NPV (POST-SPLT)' WHERE SecCode = 144934 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 145409 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 145496 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 152731 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 153607 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 163971 AND Type_ = 10;
UPDATE data_universe SET Name = 'QUALITY HOUSES BUS THB8.8847 (LOCAL) REIT' WHERE SecCode = 186191 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 194176 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'MLEDU.EUA^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, endDate = '2025-09-18' WHERE SecCode = 202318 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE809Q01020', RkdSEDOL = 'BMYS0F', RkdCUSIP = 'Y271BT10', Name = 'GHV INFRA PROJECTS INR5', DsPrimQtSedol = 'BMYS0F8' WHERE SecCode = 214104 AND Type_ = 10;
UPDATE data_universe SET RkdDisplayRIC = 'MLCO.Z' WHERE SecCode = 224179 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 252435 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 255424 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258792 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GENEDRIVE PLC ORD GBP0.00015' WHERE SecCode = 284262 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FLNGo', RkdSEDOL = 'BH3T3L', RkdRIC = 'FLNG.K', RkdDisplayRIC = 'FLNG.N', DsCtryQtStatus = 'D', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', QuotePermID = 21512264643.0, PriTrdQuotePermID = 25727370253.0, PriValQuotePermID = 21475535100.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'STO', DsSecDelistDate = '2025-09-16', SecMapEndDate = '2025-09-15', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16', endDate = '2025-09-15' WHERE SecCode = 286050 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 293451 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA28619K2083', RkdSEDOL = 'BTZP33', RkdCUSIP = '28619K20', Name = 'ELEMENTAL ALTUS ROYALTIES CO COM NEW', DsPrimQtSedol = 'BTZP336' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 309977 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 319114 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 320072 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'YDKG', PermIDTicker = 'YDKG', RkdRIC = 'YDKG.O', RkdDisplayRIC = 'YDKG.OQ', Name = 'YUEDA DIGITAL HOLDING USD ORD SHS' WHERE SecCode = 331506 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096760835.0, PermOrgIPODate = '2007-11-19', startDate = '2007-11-19' WHERE SecCode = 331648 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdSEDOL = NULL, RkdRIC = 'XIN.N^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-18', SecMapEndDate = '2025-09-03', PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, endDate = '2025-09-03' WHERE SecCode = 334399 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365381.0 WHERE SecCode = 336707 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 345744 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 347012 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951202.0 WHERE SecCode = 358625 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 376026 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 383497 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AOTECAR NEW ENGY T ''A''CNY1' WHERE SecCode = 384307 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 391897 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CRZK.F', RkdDisplayRIC = 'CRZK.F', RkdExchCode = 'FRA', PriValQuotePermID = 55843596535.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-17', endDate = '2025-09-17' WHERE SecCode = 427461 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 450695 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 516109 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 521487 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 535628 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE814H01029' WHERE SecCode = 536728 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 537585 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 549234 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 550827 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'YUZHOU GROUP HOLDI HKD1' WHERE SecCode = 551335 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 558354 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 559630 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 560461 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'VGG5884M1041', RkdTicker = 'MSP', RkdSEDOL = 'B96TSD', RkdCUSIP = 'G5884M10', RkdRIC = 'MSPJ.J', RkdDisplayRIC = 'MSPJ.J', RkdCode = 93061.0, RkdIssueID = 1.0, RkdIssueCode = 117114.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'JNB', RkdExchCtry = 'ZAF', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 588823 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 595308 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 692769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 703064 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 767057 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 776068 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 839885 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BLINDATA LIMITED ORD EUR 0.01' WHERE SecCode = 844012 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 847318 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 918649 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 940672 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'XMH HOLDINGS LTD NPV' WHERE SecCode = 966010 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1082058 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1110147 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GRAK.BO', RkdDisplayRIC = 'GRAK.BO' WHERE SecCode = 1175373 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1209873 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1262130 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1270231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1316139 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OB1DD', DsPrimQtSedol = 'BTQM154' WHERE SecCode = 1372743 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1382814 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21481777624.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 1453952 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1485736 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 1622683 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1630431 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SKYI.SI', RkdDisplayRIC = 'SKYI.SI', Name = 'SKYLINK HOLDINGS L NPV (POST-CONS)', DsCtryQtStatus = 'A' WHERE SecCode = 1631746 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1631904 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1643769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1725334 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1997858 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2065778 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2152212 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PHXM.PA^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-18', SecMapEndDate = '2025-09-05', PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18', endDate = '2025-09-05' WHERE SecCode = 2217733 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GA8', DsPrimQtSedol = 'BVPGHD1', PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 2255680 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2287227 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2294759 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 2295691 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TIGERLOGS', PermIDTicker = 'TIGERLOGS', RkdRIC = 'TIGE.NS', RkdDisplayRIC = 'TIGE.NS', RkdExchCode = 'NSE', QuotePermID = 236796022220.0, PriValQuotePermID = 236796022220.0, ExchCode = 'NSI' WHERE SecCode = 2349750 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2373426 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-08-25' WHERE SecCode = 2378956 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SYA', DsPrimQtSedol = 'BBX4LR9' WHERE SecCode = 2384507 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2461864 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2462091 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-08-21', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-14', endDate = '2025-08-21' WHERE SecCode = 2483617 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2514702 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2529648 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2563183 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 2623925 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'T-CORP ASSET JSC VND10000' WHERE SecCode = 2639379 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OB1DD', DsPrimQtSedol = 'BTQM154' WHERE SecCode = 2711209 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GA8', DsPrimQtSedol = 'BVPGHD1', PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 2800403 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 2832701 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2870124 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2891380 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2928723 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2937551 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2947814 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2947876 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2950178 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2959530 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2961761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2974277 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3018641 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3022438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3044826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3048457 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3049345 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3050876 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051792 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051797 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 3059403 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3064787 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3067181 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 3072619 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 3076182 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3087022 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3098026 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3133501 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3157196 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3160080 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3162862 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3162863 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172341 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172415 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3177070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3181407 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3184000 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 3201363 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3213023 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 3213375 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3242484 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951315.0 WHERE SecCode = 3245596 AND Type_ = 10;
UPDATE data_universe SET Name = 'ENVIROTAINER AG NPV' WHERE SecCode = 3247387 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283859 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283969 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3285690 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3288172 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 3288947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S', COATypeCode = '' WHERE SecCode = 3295160 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3316489 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3318951 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'EWICAP', RkdRIC = 'EWIC.KL', RkdDisplayRIC = 'EWIC.KL' WHERE SecCode = 3319768 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-09-09', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15', endDate = '2025-09-09' WHERE SecCode = 3338654 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347459 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347763 AND Type_ = 10;
UPDATE data_universe SET Name = 'FONCIERE IMMOB TUN NPV' WHERE SecCode = 3349716 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3357084 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3365085 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3368522 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3374472 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3375335 AND Type_ = 10;
UPDATE data_universe SET Name = 'HONG KONG ENTERTAI HKD0.6' WHERE SecCode = 3377999 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3392350 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3393831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401731 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401776 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3402856 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3407187 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3407498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3407823 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OB1DD', DsPrimQtSedol = 'BTQM154' WHERE SecCode = 3409377 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3409783 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '2292.HK^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 3429657 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3435135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3441470 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445582 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3504370 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3511850 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3520029 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3527769 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3537021 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3559180 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3586927 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE467X01023', RkdSEDOL = 'BV2FG0', RkdCUSIP = 'Y7T16H10', Name = 'SAPTAK CHEM AND B INR10 (POST SPLT)', DsPrimQtSedol = 'BV2FG01' WHERE SecCode = 3587036 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3588090 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3593756 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3619075 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3497.T^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 3634457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3651875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3657853 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3671059 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3719721 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3735950 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3745523 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3750914 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3773445 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'ILTY.MI^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2019-03-05', endDate = '2025-09-17' WHERE SecCode = 3779974 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3784691 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3799576 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3809775 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3827729 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3857447 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3885291 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3901291 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3919538 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3939942 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3972133 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3978268 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4041269 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4041320 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4046400 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4054122 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4054495 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4058524 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4059279 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S', COATypeCode = '' WHERE SecCode = 4060785 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4081906 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4087371 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4197878 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4286258 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4291239 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4310593 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4313231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4337006 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4339145 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4341610 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4377200 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4382912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4408313 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4446112 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'SPOT.OL^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2020-12-18', endDate = '2025-09-18' WHERE SecCode = 4447189 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4456283 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4482176 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 4548098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4549203 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4550734 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4557733 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4592043 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4603473 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615772 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615787 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615941 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4616827 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4620141 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4622018 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4638782 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7379.T^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 4655498 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4716072 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4767831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4786370 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4807668 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4893249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4929226 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4989476 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5002422 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5025166 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5104594 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5122912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5162450 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5194295 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 5267077 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5347334 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5367666 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5434330 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5440961 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5500244 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5516786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5535014 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'XX10', PermIDTicker = 'XX10', RkdSEDOL = NULL, RkdRIC = 'XX10k.H', RkdDisplayRIC = 'XX10k.H', RkdIssueStatus = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL WHERE SecCode = 5536057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5549569 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5550758 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5563070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5610275 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5658429 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5686490 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5804325 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5807642 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7750.TW', RkdDisplayRIC = '7750.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5807735 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5814581 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5820916 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5822373 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5839359 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5886911 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5886937 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5985400 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5999070 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BLAK.NS', RkdDisplayRIC = 'BLAK.NS' WHERE SecCode = 6008774 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6018364 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6020925 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 6025993 AND Type_ = 10;
UPDATE data_universe SET Name = 'QUALITY HOUSES BUS THB8.8847 (LOCAL) REIT' WHERE SecCode = 6047857 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6069623 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6082594 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6092920 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6114249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6117162 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6128250 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6141555 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6159033 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6164287 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951831.0 WHERE SecCode = 6196011 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6205869 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6205870 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6215205 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 6215207 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6220150 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6223905 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6253475 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6272209 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6285562 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6291854 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6297427 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6297438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6301989 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6303031 AND Type_ = 10;
UPDATE data_universe SET Name = 'GARMENT MANTRA INR1.2(PPD 0.60 UPD0.60 )' WHERE SecCode = 6305182 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6310627 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6318878 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6318887 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PLPRTSD00022', RkdTicker = 'PRE', RkdSEDOL = 'BQT5TF', RkdCUSIP = 'X6924C10', RkdRIC = 'PRE2.WA', RkdDisplayRIC = 'PRE2.WA', RkdCode = 142985.0, RkdIssueID = 1.0, RkdIssueCode = 182533.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'WAR', RkdExchCtry = 'POL', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6320971 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6322343 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6336207 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6339507 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6339508 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6341752 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6347455 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 6351573 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6354184 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6354186 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6356123 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361849 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361850 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361852 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6366713 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IL0011962110', RkdTicker = 'DLPR', RkdSEDOL = 'BVPCRV', RkdCUSIP = 'M2773M12', RkdRIC = 'DLPR.TA', RkdDisplayRIC = 'DLPR.TA', RkdCode = 142979.0, RkdIssueID = 1.0, RkdIssueCode = 182526.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6377048 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6389714 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6396775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6405360 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6414079 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-19', SecMapEndDate = '2025-09-18', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 6416392 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6422982 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6434972 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6440004 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6440013 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 6445464 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6448554 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6449036 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6450902 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-09-15' WHERE SecCode = 6453918 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'M9563J10', COATypeCode = 'IND' WHERE SecCode = 6453919 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236796059179.0 WHERE SecCode = 6460635 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236796059855.0, IsPrimaryQuote = 1.0, ExchCode = 'GER' WHERE SecCode = 6460642 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA73015G1046', RkdSEDOL = 'BRJJYV', RkdCUSIP = '73015G10', Name = 'PMET RES INC COM', DsPrimQtSedol = 'BRJJYV5', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 10933062 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10934016 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10963618 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10979389 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10983013 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10985917 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10990193 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8173234050', RkdSEDOL = 'BVBHF9', RkdCUSIP = '81732340', DsPrimQtSedol = 'BVBHF90', ShPerListing = 100.0 WHERE SecCode = 11002303 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11002517 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11003868 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11020243 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11031081 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11046194 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 11062007 AND Type_ = 1;
UPDATE data_universe SET Name = 'VISIONSYS AI INC SPONSORED ADS', DsTypeCode = 'EQ' WHERE SecCode = 11131840 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11143036 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11143909 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11153770 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11156633 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11158900 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11159154 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11159248 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11165973 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11166433 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11169166 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11174613 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11176658 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2017-11-07' WHERE SecCode = 11177652 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11180458 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0500591049', RkdSEDOL = 'BTZP31', RkdCUSIP = '05005910', Name = 'A2 GOLD CORP COM', DsPrimQtSedol = 'BTZP314' WHERE SecCode = 11181676 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11183295 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096758753.0, PermOrgIPODate = '2018-03-23' WHERE SecCode = 11183359 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11186234 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11186810 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'YMAB.OQ^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-17', SecMapEndDate = '2025-09-15', PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17', endDate = '2025-09-15' WHERE SecCode = 11189988 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11190161 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11192011 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11192602 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11194907 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11196231 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11198674 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11203034 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11203252 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232885330517.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11203282 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11203428 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11204795 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11205189 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9618843018', RkdSEDOL = 'BTZNZT', RkdCUSIP = '96188430', DsPrimQtSedol = 'BTZNZT0', PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11206889 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-12' WHERE SecCode = 11208299 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11209243 AND Type_ = 1;
UPDATE data_universe SET Name = 'ARGO GROUP INTERNATIONAL HOL DEPOSITARY SHARE', SecMapEndDate = '2025-09-12', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15', startDate = '2020-07-08', endDate = '2025-09-12' WHERE SecCode = 11209772 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11210480 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11211492 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US04746L2034', RkdSEDOL = 'BQT3G4', RkdCUSIP = '04746L20', DsPrimQtSedol = 'BQT3G47' WHERE SecCode = 11212286 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11214158 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11214658 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11214796 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11214925 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217686 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9290332074', PermIDTicker = NULL, RkdSEDOL = 'BRJJYT', RkdCUSIP = '92903320', DsPrimQtSedol = 'BRJJYT3', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2021-02-05' WHERE SecCode = 11218924 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11226015 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'FAAS.OQ^I25', RkdIssueStatus = 0.0 WHERE SecCode = 11229729 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11235400 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, PermIDTicker = 'ANGX', RkdCUSIP = NULL, RkdRIC = 'ANGX.N', RkdCode = 142993.0, RkdIssueCode = 182544.0, PrimaryIssueType = 'PVT', COATypeCode = '', QuotePermID = 236795665875.0, IsPrimaryQuote = 1.0, PermQuoteStatus = 'AC', ExchCode = 'NYS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-09', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11237780 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'HLVX.OQ^I25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18', endDate = '2025-09-18' WHERE SecCode = 11241414 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-06-20', startDate = '2022-06-20' WHERE SecCode = 11243073 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NMS' WHERE SecCode = 11243561 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US09076W3079', RkdSEDOL = 'BRJJLZ', RkdCUSIP = '09076W30', DsPrimQtSedol = 'BRJJLZ8', QuotePermID = 25727191708.0, IsPrimaryQuote = 0.0, ExchCode = 'SCB', PermSecMapStartDate = '2022-08-09', startDate = '2022-08-09' WHERE SecCode = 11244579 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TWELF' WHERE SecCode = 11245290 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA87670N5010', PermIDTicker = 'TARGD', RkdSEDOL = 'BTZNZ8', RkdCUSIP = '87670N50', Name = 'TAURUS GOLD CORP COM NEW', DsPrimQtSedol = 'BTZNZ89' WHERE SecCode = 11247040 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US27877D2036', RkdSEDOL = 'BQT3HR', RkdCUSIP = '27877D20', DsPrimQtSedol = 'BQT3HR7' WHERE SecCode = 11248018 AND Type_ = 1;
UPDATE data_universe SET Name = 'STRIVE INC CL A COM', PriTRBCIndPermID = 4294951361.0, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11249437 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA69639G1081', RkdSEDOL = 'BPCR7M', RkdCUSIP = '69639G10', DsPrimQtSedol = 'BPCR7M4', PermSecMapEndDate = '2025-09-17', endDate = '2025-09-17' WHERE SecCode = 11249518 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11250261 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG982181114', RkdSEDOL = 'BTZNZL', RkdCUSIP = 'G9821811', DsPrimQtSedol = 'BTZNZL2' WHERE SecCode = 11251558 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FDXTF' WHERE SecCode = 11251873 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA42804X3058', PermIDTicker = 'HZLID', RkdSEDOL = 'BQT3HL', RkdCUSIP = '42804X30', DsPrimQtSedol = 'BQT3HL1', PermSecMapEndDate = '2024-12-12', endDate = '2024-12-12' WHERE SecCode = 11252776 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SABA', Name = 'SABA ENERGY LTD COM', Country = 'CAN', DsPrimQtSedol = 'BVN5M79' WHERE SecCode = 11255290 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11256311 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11258687 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11258995 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'ZOG.X', RkdRIC = 'ZOGx.CD', RkdDisplayRIC = 'ZOGx.CD' WHERE SecCode = 11260136 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11262695 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'NCLR.CD^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-17', PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17', startDate = '2021-04-27', endDate = '2025-09-17' WHERE SecCode = 11263056 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11265031 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11266729 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11267641 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11272073 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11273643 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11275070 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951741.0 WHERE SecCode = 11275276 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11276362 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11276401 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277132 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277332 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277553 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11277668 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277924 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 11278193 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232885330517.0, IsPrimaryInstr = 1.0 WHERE SecCode = 11278309 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11278441 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11279414 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11279787 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282049 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282097 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282117 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282205 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'US', OrgPermID = 5057764257.0, PriInstrPermID = 25727283306.0, IsPrimaryInstr = 0.0, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2021-04-14' WHERE SecCode = 11284186 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'US', OrgPermID = 5000069094.0, PriInstrPermID = 8590933196.0, IsPrimaryInstr = 0.0, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951864.0, PermOrgIPODate = '1961-10-11' WHERE SecCode = 11284197 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284220 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284225 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284441 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284555 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284951 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PVS.PR.U', QuotePermID = 236795699218.0, InstrPermID = 232898321106.0, OrgPermID = 4295860712.0, PriValQuotePermID = 236795699218.0, PriInstrPermID = 192818697641.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '2015-10-29', PermSecMapStartDate = '2025-09-10', startDate = '2025-09-10' WHERE SecCode = 11285114 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285141 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'FR', Country = 'FRA', SecMapStartDate = '2025-09-11', startDate = '2025-09-11' WHERE SecCode = 11285148 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11285173 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-09-11', startDate = '2025-09-11' WHERE SecCode = 11285175 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11285177 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EMETF', QuotePermID = 236795803667.0, InstrPermID = 21737704119.0, OrgPermID = 5073354458.0, PriValQuotePermID = 21737704120.0, PriInstrPermID = 21737704119.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GTC', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2020-03-05', PermSecMapStartDate = '2025-09-11', startDate = '2020-03-05' WHERE SecCode = 11285215 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11285221 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VIA', COATypeCode = '', QuotePermID = 236795698805.0, InstrPermID = 232895278183.0, OrgPermID = 5043315335.0, PriTrdQuotePermID = 236795698805.0, PriValQuotePermID = 25727062349.0, PriInstrPermID = 232895278183.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2025-09-12', PermSecMapStartDate = '2025-09-10', startDate = '2025-09-10' WHERE SecCode = 11285245 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '', PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6757R1056', RkdTicker = 'ONCH', PermIDTicker = 'ONCH', RkdSEDOL = 'BRSFHM', RkdCUSIP = 'G6757R10', RkdRIC = 'ONCH.O', RkdDisplayRIC = 'ONCH.OQ', ModelCntry = 'US', RkdCode = 142697.0, RkdIssueID = 3.0, RkdIssueCode = 182506.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND', QuotePermID = 236795754566.0, InstrPermID = 232880117527.0, OrgPermID = 5095647428.0, PriTrdQuotePermID = 236795754566.0, PriValQuotePermID = 25727062090.0, PriInstrPermID = 232880117527.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2025-07-02', PermSecMapStartDate = '2025-09-11', startDate = '2025-07-02' WHERE SecCode = 11285255 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236796062189.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11285479 AND Type_ = 1;