UPDATE data_universe SET DsPrimQtSedol = 'BWPD4D8', PermSecMapEndDate = '2026-06-24', endDate = '2026-06-24' WHERE SecCode = 430 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 847 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 1682 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 2119 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 2372 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 3223 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 3532 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951479.0 WHERE SecCode = 3982 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 6718 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 8775 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'GBR' WHERE SecCode = 8914 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951987.0 WHERE SecCode = 10683 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 10711 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 11945 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 12133 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNVVWV7' WHERE SecCode = 13989 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17271 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 17358 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 18802 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 18836 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 23502 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 23826 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 27615 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0, startDate = '1999-04-26' WHERE SecCode = 30013 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 33326 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 34611 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 36952 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 37039 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 37319 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 38661 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 38702 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 38891 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 38907 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 42317 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 43048 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 43445 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951857.0 WHERE SecCode = 45461 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 45578 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-24' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 49873 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 50014 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 51161 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 51230 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 52171 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 52964 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 55512 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 56330 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951860.0 WHERE SecCode = 64017 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 66093 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 67156 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 67390 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 67717 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 68148 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 68649 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 69150 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = NULL, startDate = '1995-03-28' WHERE SecCode = 69539 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 69553 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951533.0 WHERE SecCode = 70193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70873 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71997 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 74505 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 74634 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 75217 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 75218 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 76157 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77184 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951542.0 WHERE SecCode = 77452 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000470981', RkdTicker = 'BXNDA', RkdSEDOL = 'BTZCS5', RkdRIC = 'BXNDA.AX', RkdDisplayRIC = 'BXNDA.AX', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 79016 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-14' WHERE SecCode = 79403 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 79733 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 79835 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951323.0 WHERE SecCode = 81909 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 82254 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 82770 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 82820 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 83046 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83511 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 84123 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 84849 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 85118 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 85561 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 85587 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 86284 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLADEX INC SHS E' WHERE SecCode = 86958 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 87392 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 87407 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 9744, DsSecCode = 24453, IsMajorSec = 'Y', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BPDXYW0', DsSecDelistDate = NULL, DsExchQtStartDate = '2002-09-03', SecMapStartDate = '2015-03-31', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 87637 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 88683 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KAISA HEALTH GROUP HKD0.0625' WHERE SecCode = 89269 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 89386 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951703.0 WHERE SecCode = 89787 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 90028 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 90195 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 90338 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 91011 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 91351 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 91354 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'XINHUA NEWS MEDIA HKD0.4 POST CONS' WHERE SecCode = 91736 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 91981 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'DCF_pa.TO^L05', RkdIssueStatus = 0.0 WHERE SecCode = 93218 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 93763 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 93859 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 93860 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 93970 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 94276 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-25', SecMapEndDate = '2026-06-24', PermSecMapEndDate = '2026-06-24', endDate = '2026-06-24' WHERE SecCode = 94669 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365417.0 WHERE SecCode = 95086 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 95893 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 96280 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 96476 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 96703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951672.0 WHERE SecCode = 96838 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXD1KX3' WHERE SecCode = 98122 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 98215 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951237.0 WHERE SecCode = 99260 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 99350 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 99650 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 100607 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 112239 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 113210 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 114300 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951184.0 WHERE SecCode = 114311 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0, PermOrgIPODate = NULL, startDate = '2011-07-25' WHERE SecCode = 118157 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 125084 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 126057 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 126329 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2005-03-03' WHERE SecCode = 126441 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 127118 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 127621 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 128977 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 130642 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 131516 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0, PermOrgIPODate = NULL, startDate = '2005-04-15' WHERE SecCode = 131621 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2005-08-22' WHERE SecCode = 134000 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-04-05' WHERE SecCode = 136508 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 138007 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 140900 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 143572 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 147043 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 147044 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 147045 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 164267 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 164802 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 174945 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 187263 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 193848 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 206733 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 207668 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 237745 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243344 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 243354 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 255752 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 257967 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 291871 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 297251 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 331794 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 334208 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 334603 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 381994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 391247 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 392485 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 396025 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 411248 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 542367 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y9003610' WHERE SecCode = 548537 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TWN' WHERE SecCode = 558297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 559254 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 562896 AND Type_ = 10;
UPDATE data_universe SET Name = 'KEM TECH CORP KRW500' WHERE SecCode = 564083 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALEFA', ExchCode = 'PAR' WHERE SecCode = 669718 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 798142 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951794.0 WHERE SecCode = 854257 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 1138003 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-07-03' WHERE SecCode = 1204784 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 1293222 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951210.0, PermOrgIPODate = NULL WHERE SecCode = 1418341 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1454299 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-06-12', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24', endDate = '2026-06-12' WHERE SecCode = 1476676 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1557092 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1656694 AND Type_ = 10;
UPDATE data_universe SET Name = 'JAKOTA CAPITAL (HO HKD0.5' WHERE SecCode = 1660603 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2012-11-29' WHERE SecCode = 1940343 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1962813 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 2065799 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 2271002 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 2386513 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PKP CARGO SA PLN1.00' WHERE SecCode = 2387340 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2428148 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = NULL WHERE SecCode = 2448344 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2513984 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2578222 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 2736322 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 2747503 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2747569 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 2830906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2914936 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2972683 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 3044062 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3281930 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LAFANG JIAHUA CO A CNY1' WHERE SecCode = 3317251 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3384465 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951447.0 WHERE SecCode = 3408076 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3559180 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 3644456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3675449 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX593T2' WHERE SecCode = 3693295 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3978265 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4287534 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 4539159 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951410.0 WHERE SecCode = 4542562 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365429.0 WHERE SecCode = 4553949 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 4557737 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 4751036 AND Type_ = 10;
UPDATE data_universe SET Name = 'MENGTIAN HOME GP A CNY1' WHERE SecCode = 4807507 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 4973304 AND Type_ = 10;
UPDATE data_universe SET Name = 'BURJEEL HLDGS PLC AED0.1' WHERE SecCode = 5188797 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 5213046 AND Type_ = 10;
UPDATE data_universe SET Name = 'SRIBS CONSULTING ''A'' CNY1' WHERE SecCode = 5359400 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-23' WHERE SecCode = 5567944 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2023-12-14', SecMapEndDate = '2024-01-22' WHERE SecCode = 5611206 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6400762 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 6654321 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951541.0 WHERE SecCode = 6664665 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6734290 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6748879 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6857266 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-25', SecMapEndDate = '2026-06-24', PermSecMapEndDate = '2026-06-24', endDate = '2026-06-24' WHERE SecCode = 6862172 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6880027 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-11', startDate = '2026-06-04' WHERE SecCode = 6911162 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236808829663.0 WHERE SecCode = 6937641 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 10907626 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM', DomCntry = 'USA', PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 10924589 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 10925281 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 10928393 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 10929506 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 10988488 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 10989893 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 10990193 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11002517 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11003302 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11005008 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11011028 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11014082 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11030702 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'HAPN', RkdRIC = 'HAPN.O', RkdDisplayRIC = 'HAPN.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11142751 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11163905 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11165973 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteRetireDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', 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, DsSecDelistDate = '2026-06-25', SecMapEndDate = '2026-06-23', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, endDate = '2026-06-23' WHERE SecCode = 11224780 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 11234124 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXD1F16' WHERE SecCode = 11270779 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2025-04-18' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11295026 AND Type_ = 1;
UPDATE data_universe SET Country = 'CYM' WHERE SecCode = 11295148 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11295230 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11295889 AND Type_ = 1;
UPDATE data_universe SET Country = 'CYM' WHERE SecCode = 11297836 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QLEP', QuotePermID = 236808552020.0, InstrPermID = 232917713569.0, OrgPermID = 6000030958.0, PriTrdQuotePermID = 236808552020.0, PriValQuotePermID = 25727017345.0, PriInstrPermID = 232917713569.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CYM', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-01', PermSecMapStartDate = '2026-06-17', startDate = '2026-05-01' WHERE SecCode = 11298136 AND Type_ = 1;
