UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 430 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BWXJZR9' WHERE SecCode = 3002 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'FIN' WHERE SecCode = 13012 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 57487 AND Type_ = 1;
UPDATE data_universe SET Name = 'C CAPITAL HOLDINGS CHF0.42(BR)' WHERE SecCode = 65128 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BRSCTT8' WHERE SecCode = 74536 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 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, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GLOBAL BIO-CHEM TE HKD1' WHERE SecCode = 79506 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82584 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 86877 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 ISIN = NULL, Name = 'IN THE F CO LTD KRW2500' WHERE SecCode = 90338 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1991-09-03' WHERE SecCode = 91559 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000170804.0, DomCntry = NULL, PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2001-08-22' WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe SET Name = 'BLUE INDUSTRIAL DE KRW100' WHERE SecCode = 99231 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 101044 AND Type_ = 1;
UPDATE data_universe SET Name = 'AIMAX BHD NPV' WHERE SecCode = 112408 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 114528 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 115380 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 399760, DsSecCode = 274249, DsCmpyCode = 214694, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BNZJJ94', DsSecDelistDate = NULL, DsExchQtStartDate = '2024-07-24', SecMapStartDate = '2024-07-24', SecMapEndDate = '2079-06-06', startDate = '2018-11-20', endDate = NULL WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-16', endDate = '2026-06-16' WHERE SecCode = 143655 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 225124 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 238617 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 330355 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 345666 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-06-26' WHERE SecCode = 561082 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2010-11-09' WHERE SecCode = 798142 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1154797 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1476676 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1610436 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2241775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 2693646 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2808086 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTZCDG0', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 3024441 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3174450 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3183978 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 3235105 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 3296210 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3365585 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 3610166 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BV4G4F3' WHERE SecCode = 3961764 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 DomCntry = 'LUX', IncCntry = 'LUX' WHERE SecCode = 4043104 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 PermSecMapEndDate = '2026-06-25' WHERE SecCode = 4426889 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4536482 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 Name = 'FUCHUN DYE & WEAVE A CNY1' WHERE SecCode = 4608560 AND Type_ = 10;
UPDATE data_universe SET Name = 'KIDSWANT DIGITAL T A CNY1' WHERE SecCode = 4739241 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5482565 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTZCDG0' WHERE SecCode = 5607472 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6467512 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 6658285 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6870729 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6900880 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-12', startDate = '2026-06-02' WHERE SecCode = 6914476 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-12', startDate = '2026-06-02' WHERE SecCode = 6921020 AND Type_ = 10;
UPDATE data_universe SET Name = 'BE EPITAXY TWD10' WHERE SecCode = 6923708 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-06-25' WHERE SecCode = 6941637 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11148647 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11154987 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11163549 AND Type_ = 1;
UPDATE data_universe SET Name = 'VIVOPOWER PLC CL A ORD SHS' WHERE SecCode = 11166235 AND Type_ = 1;
UPDATE data_universe SET Name = 'SMARTWELL TECHNOLOGY CORP CL A' WHERE SecCode = 11178978 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11190074 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11224867 AND Type_ = 1;
UPDATE data_universe SET Country = 'JEY' WHERE SecCode = 11226945 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11230564 AND Type_ = 1;
UPDATE data_universe SET Name = 'TENX PROTOCOLS INC COM SHS' WHERE SecCode = 11233791 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 11234124 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTH2852' WHERE SecCode = 11240570 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-05-02' WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-05-02', startDate = '2025-05-02' WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297631 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DSC', QuotePermID = 236808931694.0, InstrPermID = 232937857798.0, OrgPermID = 6000153818.0, PriTrdQuotePermID = 236808931694.0, PriValQuotePermID = 25727016001.0, PriInstrPermID = 232937857798.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ADR', InstrClass = 'ADR', OrgTypeCode = 'COM', DomCntry = 'CHN', IncCntry = 'CYM', PermOrgIPODate = '2026-06-25', PermSecMapStartDate = '2026-06-25' WHERE SecCode = 11298205 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CGCFU', QuotePermID = 236808191539.0, InstrPermID = 232939550396.0, OrgPermID = 6000157948.0, PriTrdQuotePermID = 236808191539.0, PriValQuotePermID = 25727018538.0, PriInstrPermID = 232939550396.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-25', PermSecMapStartDate = '2026-06-25' WHERE SecCode = 11298231 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DPC', QuotePermID = 236808831335.0, InstrPermID = 232940847325.0, OrgPermID = 5076905786.0, PriTrdQuotePermID = 236808831335.0, PriValQuotePermID = 25727016404.0, PriInstrPermID = 232940847325.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'JEY', PriTRBCIndPermID = 4294951866.0, PermOrgIPODate = '2026-06-25', PermSecMapStartDate = '2026-06-23', startDate = '2026-06-23' WHERE SecCode = 11298232 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FWACU', QuotePermID = 236806769225.0, InstrPermID = 232934261563.0, OrgPermID = 6000122345.0, PriTrdQuotePermID = 236806769225.0, PriValQuotePermID = 25727023677.0, PriInstrPermID = 232934261563.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-25', PermSecMapStartDate = '2026-06-25' WHERE SecCode = 11298233 AND Type_ = 1;
