UPDATE data_universe SET PermIDTicker = 'KFXl', QuotePermID = 21475788761.0, ExchCode = 'BTE', PermQuoteRetireDate = '2015-03-31', endDate = '2015-03-30' WHERE SecCode = 3735 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PCIl', QuotePermID = 21538768656.0, ExchCode = 'BCO', PermQuoteRetireDate = '2016-09-27', endDate = '2016-04-14' WHERE SecCode = 4613 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 30893 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951441.0 WHERE SecCode = 41285 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 42884 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 45372 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'mvzm', PermInstrStatus = 'DC' WHERE SecCode = 49805 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 49809 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 49931 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 51541 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'D1178M10' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 53105 AND Type_ = 10;
UPDATE data_universe SET Country = 'DEU' WHERE SecCode = 56898 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951641.0 WHERE SecCode = 57526 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ACOM.I', QuotePermID = 21475575563.0, ExchCode = 'CST', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 61968 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838751244.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 62963 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 64492 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7229.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermSecMapEndDate = '2026-06-09', endDate = '2026-06-09' WHERE SecCode = 69402 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'BOM', DsExchQtStartDate = '1990-01-01' WHERE SecCode = 74999 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'USA' WHERE SecCode = 75203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75860 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 Name = 'BIG SKY INDL INC COM' WHERE SecCode = 78205 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 0.08333 WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q1714E10' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET Name = 'DEL MONTE CORP ORD' WHERE SecCode = 84234 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 85334 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'BOM', DsExchQtStartDate = '1990-01-01' WHERE SecCode = 86203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87204 AND Type_ = 10;
UPDATE data_universe SET Name = 'HYPER CORPORATION KRW1000' WHERE SecCode = 88964 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 RkdRIC = '7999.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermSecMapEndDate = '2026-06-09', endDate = '2026-06-09' WHERE SecCode = 89948 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ORIENTBIO INC KRW1000' WHERE SecCode = 90013 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG2125A3043', RkdSEDOL = 'BXGT6V', RkdCUSIP = 'G2125A30', DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 90242 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 94249 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94501 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 RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 100359 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 100361 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 101206 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BOBST GROUP AG CHF1' WHERE SecCode = 101564 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'yars', PermInstrStatus = 'DC' WHERE SecCode = 102229 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'uzem', PermInstrStatus = 'DC' WHERE SecCode = 102737 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 102859 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 102999 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'galo', PermInstrStatus = 'DC' WHERE SecCode = 103162 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 111499 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 115256 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 115439 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SONOKONG CO LTD KRW2500' WHERE SecCode = 124911 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LASERNET GROUP AB NPV' WHERE SecCode = 125258 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 134720 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137982 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 140784 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'WIMP.NS^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-08', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-09', endDate = '2026-06-08' WHERE SecCode = 142567 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 142629 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET Name = 'YARI RESOURCES LTD NPV', PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 145910 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 147015 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 197332 AND Type_ = 10;
UPDATE data_universe SET Country = 'DEU' WHERE SecCode = 343997 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 391687 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IDN' WHERE SecCode = 393864 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 510592 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'atlm', PermInstrStatus = 'DC' WHERE SecCode = 519169 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'atlmp', PermInstrStatus = 'DC' WHERE SecCode = 519171 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 519434 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'acbk', PermInstrStatus = 'DC' WHERE SecCode = 519564 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 534987 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 547504 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'EVOL.SI', RkdDisplayRIC = 'EVOL.SI' WHERE SecCode = 549697 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 553420 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555882 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555937 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555942 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555955 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555974 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 556045 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 556058 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 557920 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 656218 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG9375G1626', RkdSEDOL = 'BW7YYW', RkdCUSIP = 'G9375G16', DsPrimQtSedol = 'BW7YYW8' WHERE SecCode = 703142 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'acnd', PermInstrStatus = 'DC' WHERE SecCode = 703147 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'bchv', PermInstrStatus = 'DC' WHERE SecCode = 703153 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703154 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703166 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703167 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703174 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703176 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'mlnk', PermInstrStatus = 'DC' WHERE SecCode = 703177 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703179 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703181 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703182 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'pgmt', PermInstrStatus = 'DC' WHERE SecCode = 703186 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703205 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703207 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'brarp', PermInstrStatus = 'DC' WHERE SecCode = 703218 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'uramp', PermInstrStatus = 'DC' WHERE SecCode = 703232 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703235 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ritm', PermInstrStatus = 'DC' WHERE SecCode = 703239 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703241 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'vorgp', PermInstrStatus = 'DC' WHERE SecCode = 703254 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703255 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'kbkc', PermInstrStatus = 'DC' WHERE SecCode = 703288 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ktyr', PermInstrStatus = 'DC' WHERE SecCode = 703310 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703318 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703353 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703358 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703373 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703382 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703397 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703410 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'zsgp', PermInstrStatus = 'DC' WHERE SecCode = 703440 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdTicker = 'oksa', Name = 'SAIANOG A', PermInstrStatus = 'DC' WHERE SecCode = 703484 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'bstdp', PermInstrStatus = 'DC' WHERE SecCode = 706299 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 706300 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 709575 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BW7YYW8' WHERE SecCode = 770039 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 890820 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 891406 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 896531 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 907511 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 907513 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 907514 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SCCMM', RkdRIC = 'SCCMM.MC', RkdDisplayRIC = 'SCCMM.MC' WHERE SecCode = 940796 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'vorg', PermInstrStatus = 'DC' WHERE SecCode = 1012880 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2015-08-03' WHERE SecCode = 1012884 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1065401 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1095599 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1111756 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 1122451 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1144815 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 1210106 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '140910.KS^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-09', endDate = '2026-06-09' WHERE SecCode = 1226331 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1469481 AND Type_ = 10;
UPDATE data_universe SET Name = 'PARTNER AEROSPACE PLN0.10' WHERE SecCode = 1542751 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1631778 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'uram', PermInstrStatus = 'DC' WHERE SecCode = 1631784 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1631827 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'elvp', PermInstrStatus = 'DC' WHERE SecCode = 1631853 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1631869 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1631887 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1631960 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'tmpap', RkdSEDOL = NULL WHERE SecCode = 1632047 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 1671641 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN011', QuotePermID = 21512412458.0, ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1693310 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2082539 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2102890 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2164413 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 2300024 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2324942 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2441664 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 2484920 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 2650077 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2882492 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 2897580 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 96743.0 WHERE SecCode = 2905774 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NLD' WHERE SecCode = 2926138 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2930560 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2980488 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'KEOC', PermIDTicker = 'KEOC', RkdRIC = 'KEOC.ST', RkdDisplayRIC = 'KEOC.ST' WHERE SecCode = 3219525 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3230631 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3275548 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG981251260', RkdSEDOL = 'BVMWFD', RkdCUSIP = 'G9812512', DsPrimQtSedol = 'BVMWFD8', PermSecMapEndDate = '2026-06-09', endDate = '2026-06-09' WHERE SecCode = 3289743 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'M TEK COPPER LTD INR5' WHERE SecCode = 3317563 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TBX0.F^F26', RkdIssueStatus = 0.0 WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CULT.MI^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 3377791 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3384115 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 3615170 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 3656403 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ESYS.L^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 3848178 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = NULL 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 PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 3965132 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4178606 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 DsCtryQtStatus = 'A' WHERE SecCode = 4423820 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 4456234 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951624.0 WHERE SecCode = 4457144 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4464617 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'G5413M10' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21799903115.0, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4524454 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4533297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 4537807 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 DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 4854770 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4890283 AND Type_ = 10;
UPDATE data_universe SET Name = 'ES GROUP AB SER''B''NPV' WHERE SecCode = 4938168 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '688287.SS^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-08', PermQuoteRetireDate = '2026-06-10', endDate = '2026-06-08' WHERE SecCode = 5019011 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOMAD COMPUTE PLC ORD GBP 0.0001' WHERE SecCode = 5067274 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 5072185 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-09' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5438120 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '451700.KQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-05-15', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-09', endDate = '2026-05-15' WHERE SecCode = 5450871 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 5454700 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL WHERE SecCode = 5491796 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5513351 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'DIAD.MI^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 5859846 AND Type_ = 10;
UPDATE data_universe SET Name = 'MACH TRAVEL SOLUTI INR10' WHERE SecCode = 5912080 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'E8S35R14', Name = 'REDEGAL SA EUR0.10' WHERE SecCode = 6092923 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6101727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6173318 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 6622164 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 6667827 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 6705487 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 130012.0, RelType = 4.0 WHERE SecCode = 6802675 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE19RO25039', RkdTicker = '544752', RkdSEDOL = 'BTY024', RkdCUSIP = 'Y7S8L512', RkdRIC = 'POPS.BO', RkdDisplayRIC = 'POPS.BO', RkdCode = 145004.0, RkdIssueID = 1.0, RkdIssueCode = 185487.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6806143 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6870725 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-08' WHERE SecCode = 6901119 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-08' WHERE SecCode = 6901123 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 11026516 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 11148269 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11165130 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11180183 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11181738 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'TRUL.CD^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-10', PermQuoteRetireDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2018-12-14' WHERE SecCode = 11192690 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0037352063', PermIDTicker = 'ZAIRD', RkdSEDOL = 'BTBLDQ', RkdCUSIP = '00373520', DsPrimQtSedol = 'BTBLDQ1' WHERE SecCode = 11198984 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA52637P1062', RkdSEDOL = 'BSGZH0', RkdCUSIP = '52637P10', DsPrimQtSedol = 'BSGZH03' WHERE SecCode = 11199570 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11225909 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11228344 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11229681 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11238076 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0529421095', RkdTicker = 'AREE', RkdSEDOL = 'BVMH71', RkdCUSIP = '05294210', RkdRIC = 'AREE.CD', RkdDisplayRIC = 'AREE.CD', DsPrimQtSedol = 'BVMH715', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11243216 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-10', PermQuoteRetireDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11261977 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US28256A1097', RkdTicker = 'ENRD', RkdSEDOL = 'BVTD8P', RkdCUSIP = '28256A10', RkdRIC = 'ENRD.O', RkdDisplayRIC = 'ENRD.OQ', DsPrimQtSedol = 'BVTD8P7', RkdListingType = 'ADR', RkdExchCode = 'NASD', ShPerListing = 0.0 WHERE SecCode = 11263764 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteRetireDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11275347 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AIBZ', QuotePermID = 236808161776.0, ExchCode = 'SCN', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-09', endDate = NULL WHERE SecCode = 11289183 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA44892A6016', RkdTicker = 'ICG', RkdSEDOL = 'BWTZ2M', RkdCUSIP = '44892A60', RkdRIC = 'ICG.CD', RkdDisplayRIC = 'ICG.CD', RkdCode = 145001.0, RkdIssueID = 1.0, RkdIssueCode = 185484.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294399 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = 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 = 11294533 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = 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 = 11295229 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295910 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295942 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = 'APCPU', PermIDTicker = NULL, RkdCUSIP = NULL, RkdRIC = 'APCPU.K', RkdDisplayRIC = 'APCPU.N', DsCtryQtStatus = 'D', RkdCode = 127802.0, RkdIssueCode = 161932.0, RkdIssueStatus = 0.0, RkdExchCode = 'NYSE', PrimaryIssueType = 'IPO', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-09', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 11296309 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = 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 = 11296313 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = 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 = 11296373 AND Type_ = 1;
UPDATE data_universe SET Name = 'ENVIRI II CORP COM' WHERE SecCode = 11296509 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG230171095', RkdTicker = 'ETSS', RkdSEDOL = 'BV3PY9', RkdCUSIP = 'G2301710', RkdRIC = 'ETSS.K', RkdDisplayRIC = 'ETSS.N', RkdCode = 143079.0, RkdIssueID = 1.0, RkdIssueCode = 182659.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11297053 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6956D1051', RkdTicker = 'PECE', RkdSEDOL = 'BX529T', RkdCUSIP = 'G6956D10', RkdRIC = 'PECE.O', RkdDisplayRIC = 'PECE.OQ', RkdCode = 143426.0, RkdIssueID = 1.0, RkdIssueCode = 183114.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11297056 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'NL00150745D9', RkdTicker = 'INIO', RkdSEDOL = 'BV4HGG', RkdCUSIP = 'N52A8C10', RkdRIC = 'INIO.O', RkdDisplayRIC = 'INIO.OQ', RkdCode = 145000.0, RkdIssueID = 1.0, RkdIssueCode = 185483.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '', PermOrgIPODate = '2026-06-04' WHERE SecCode = 11297059 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6722R1074', RkdTicker = 'OHAC', RkdSEDOL = 'BQKQTF', RkdCUSIP = 'G6722R10', RkdRIC = 'OHAC.O', RkdDisplayRIC = 'OHAC.OQ', RkdCode = 144633.0, RkdIssueID = 1.0, RkdIssueCode = 184873.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11297192 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6486G1073', RkdTicker = 'NHIV', PermIDTicker = 'NHIV', RkdSEDOL = 'BSGYVM', RkdCUSIP = 'G6486G10', RkdRIC = 'NHIV.O', RkdDisplayRIC = 'NHIV.OQ', RkdCode = 144464.0, RkdIssueID = 1.0, RkdIssueCode = 184557.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND', QuotePermID = 236808063266.0, InstrPermID = 232925300249.0, OrgPermID = 6000033688.0, PriTrdQuotePermID = 236808063266.0, PriValQuotePermID = 25727018955.0, PriInstrPermID = 232925300249.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-04-15', PermSecMapStartDate = '2026-06-06', startDate = '2026-04-15' WHERE SecCode = 11297250 AND Type_ = 1;
