UPDATE data_universe SET RkdRIC = 'WHI.L^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 12348 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, 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, SecMapEndDate = '2026-03-20', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2001-01-31', endDate = '2026-03-20' WHERE SecCode = 24869 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-03-24' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55847866145.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'BOS', PermQuoteRetireDate = '2026-03-20', PermSecMapStartDate = '2004-11-19', PermSecMapEndDate = '2026-03-20', endDate = '2026-03-20' WHERE SecCode = 50228 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, 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 WHERE SecCode = 56167 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'WAREHOUSE DE PAUW NPV' WHERE SecCode = 59348 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605378798.0, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71847 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-23' WHERE SecCode = 75052 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SCIE.KL^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', SecMapEndDate = '2026-02-26', endDate = '2026-02-26' WHERE SecCode = 76309 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 76821 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US98386D4060', RkdSEDOL = 'BTG0MN', RkdCUSIP = '98386D40', DsPrimQtSedol = 'BTG0MN3', ShPerListing = 400.0 WHERE SecCode = 82732 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'GCG.TO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', PermQuoteRetireDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 94805 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'GCGa.TO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 94806 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 96185 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96193 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837363471.0, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', endDate = '2011-05-28' WHERE SecCode = 99829 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MONV', QuotePermID = 55835784509.0, ExchCode = 'DUS', PermQuoteRetireDate = '2014-06-03', endDate = '2012-11-14' WHERE SecCode = 100671 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616157076.0, ExchCode = 'MCX' WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156380.0, ExchCode = 'MCX' WHERE SecCode = 102863 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838239701.0, ExchCode = 'MUN', PermQuoteRetireDate = '2012-08-10' WHERE SecCode = 103998 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASTO.GB', QuotePermID = 55847123002.0, ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17', endDate = '2012-01-17' WHERE SecCode = 104775 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836339935.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-19', endDate = '2018-11-16' WHERE SecCode = 111823 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-23' WHERE SecCode = 135942 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GAS', QuotePermID = 21475431308.0, ExchCode = 'OSL', PermQuoteRetireDate = '2008-07-30' WHERE SecCode = 141248 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836323663.0, ExchCode = 'BER', PermQuoteRetireDate = '2016-03-04', endDate = '2016-03-03' WHERE SecCode = 141320 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475425498.0, ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26', endDate = '2008-04-26' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 145250 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837367607.0, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', endDate = '2011-05-28' WHERE SecCode = 150698 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21528682235.0, ExchCode = 'QMF', PermQuoteRetireDate = '2012-09-03', endDate = '2012-08-31' WHERE SecCode = 164836 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 196165 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21830289175.0, ExchCode = 'GTX' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE945H01021', RkdSEDOL = 'BW5WNG', RkdCUSIP = 'Y9382Y13', DsPrimQtSedol = 'BW5WNG1' WHERE SecCode = 303642 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 377947 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE348N01042', RkdSEDOL = 'BNTYJZ', RkdCUSIP = 'Y5S80L11', DsPrimQtSedol = 'BNTYJZ1' WHERE SecCode = 521517 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000461881', RkdTicker = 'USM', RkdSEDOL = 'BTLSVL', RkdRIC = 'USM.AX', RkdDisplayRIC = 'USM.AX', DsPrimQtSedol = 'BTLSVL3', SecMapEndDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 553567 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2009-12-22' WHERE SecCode = 561400 AND Type_ = 10;
UPDATE data_universe SET Name = 'CXI HEALTHCARE TEC USD 0.5' WHERE SecCode = 574547 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PVA.HNO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', SecMapEndDate = '2024-05-31', endDate = '2024-05-31' WHERE SecCode = 586465 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 587668 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NTB.HNO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', SecMapEndDate = '2023-12-08', endDate = '2023-12-08' WHERE SecCode = 684152 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'HOUSE.PS^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-24', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 863684 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 1196407 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779440.0, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NHP.HNO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', SecMapEndDate = '2024-05-31', endDate = '2024-05-31' WHERE SecCode = 2831954 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTLSVL3' WHERE SecCode = 2985302 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SJF', RkdRIC = 'SJF.CO', RkdDisplayRIC = 'SJF.CO' WHERE SecCode = 3038482 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '8990P.PS^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-24', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 3406739 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-03-23' WHERE SecCode = 3409197 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'BCPL', RkdRIC = 'BCPL.NS', RkdDisplayRIC = 'BCPL.NS', RkdExchCode = 'NSE' WHERE SecCode = 3619752 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4035749 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'COPC', RkdRIC = 'COPC.L', RkdDisplayRIC = 'COPC.L' WHERE SecCode = 4366517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4442693 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTLSVL3' WHERE SecCode = 4464616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-24', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 4495557 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4540662 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4615788 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4701662 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, 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, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2021-10-07' WHERE SecCode = 4731832 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 4854749 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21885689383.0, ExchCode = 'FRA' WHERE SecCode = 4959594 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6908.TW', RkdDisplayRIC = '6908.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5152274 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7116.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-25', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 5286272 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, 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, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2023-04-20' WHERE SecCode = 5398946 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5511073 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5513352 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21890431098.0, ExchCode = 'FRA' WHERE SecCode = 6256382 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6538865 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'SE', OrgPermID = 5090646141.0, DomCntry = 'SWE', IncCntry = 'SWE', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 6608224 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6627229 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TREEMPA00012', RkdTicker = 'EMPAE.E', RkdSEDOL = 'BTMMR0', RkdCUSIP = 'M4031711', RkdRIC = 'EMPAE.IS', RkdDisplayRIC = 'EMPAE.IS', RkdCode = 144538.0, RkdIssueID = 1.0, RkdIssueCode = 184725.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'IST', RkdExchCtry = 'TUR', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6686350 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007JD5' WHERE SecCode = 6702406 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, 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, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-03-16' WHERE SecCode = 6719150 AND Type_ = 10;
UPDATE data_universe SET Name = 'FS COM LTD CNY1 H' WHERE SecCode = 6731964 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11024269 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, 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 = '2013-04-05' WHERE SecCode = 11030696 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11156315 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11178785 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11183588 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0287921096', RkdSEDOL = 'BTG0N5', RkdCUSIP = '02879210', Name = 'AMERICAN PAC MNG CORP COM NEW CL A', DsPrimQtSedol = 'BTG0N52' WHERE SecCode = 11184600 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11192817 AND Type_ = 1;
UPDATE data_universe SET Name = 'CORVEX INC COM NEW' WHERE SecCode = 11221473 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11230025 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11235694 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US68237Q3020', RkdSEDOL = 'BTG0MP', RkdCUSIP = '68237Q30', DsPrimQtSedol = 'BTG0MP5' WHERE SecCode = 11238670 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11250693 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11253112 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'DTCKF', RkdRIC = 'DTCKF.PK', RkdDisplayRIC = 'DTCKF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11257345 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11264467 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11265202 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11268806 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000066687.0, PriInstrPermID = 232849924168.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 11271326 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11274664 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11277444 AND Type_ = 1;
UPDATE data_universe SET Name = 'AURANOVA RES INC COM SHS' WHERE SecCode = 11278789 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11288510 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NBRG', ModelCntry = 'HK', QuotePermID = 236804538039.0, InstrPermID = 232816459926.0, OrgPermID = 5096749614.0, PriTrdQuotePermID = 236804538039.0, PriValQuotePermID = 25727029785.0, PriInstrPermID = 232816459926.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'VGB', PriTRBCIndPermID = 4294951348.0, PermSecMapStartDate = '2026-03-20', startDate = '2026-03-20' WHERE SecCode = 11293574 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MUZE', ModelCntry = 'US', QuotePermID = 236804596272.0, InstrPermID = 232913683809.0, OrgPermID = 5097054987.0, PriTrdQuotePermID = 236804596272.0, PriValQuotePermID = 25727029610.0, PriInstrPermID = 232913683809.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 = '2026-01-30', PermSecMapStartDate = '2026-03-21', startDate = '2026-01-30' WHERE SecCode = 11293576 AND Type_ = 1;