UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3260 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BHRB.O' WHERE SecCode = 10804 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 55835320972.0, PriValQuotePermID = 55839093095.0 WHERE SecCode = 26606 AND Type_ = 1;
UPDATE data_universe SET Name = 'HONEYWELL INTL INC COM.' WHERE SecCode = 33894 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, RkdISIN = 'IT0005704439', RkdSEDOL = 'BT6N2T', RkdCUSIP = 'T1R69C10', Name = 'BCA PROFILO POST SPLIT', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 59688 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES0109260291', RkdSEDOL = 'BXV21B', RkdCUSIP = 'E0460053' WHERE SecCode = 60151 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 65399 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67742 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET Name = 'MIRAE KRW100' WHERE SecCode = 70631 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET Name = 'SR MEDICAL TECHNOL NPV' WHERE SecCode = 72486 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXS3K45' WHERE SecCode = 72986 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74528 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000474470', RkdTicker = 'FBRDD', RkdSEDOL = 'BTJTN6', RkdCUSIP = 'Q3R26D22', RkdRIC = 'FBRDD.AX', RkdDisplayRIC = 'FBRDD.AX', DsPrimQtSedol = 'BZ02914' WHERE SecCode = 79182 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE377D01026', RkdSEDOL = 'BNBWTH', RkdCUSIP = 'Y452BZ10' WHERE SecCode = 82333 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG216341450', RkdSEDOL = 'BTMPX0', RkdCUSIP = 'G2163414' WHERE SecCode = 82659 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951836.0 WHERE SecCode = 86170 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 87934 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG9877V2045', RkdSEDOL = 'BTFH0T', RkdCUSIP = 'G9877V20' WHERE SecCode = 90759 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHINA AI INFRSTR HKD0.1' WHERE SecCode = 91155 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91257 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '0495.HK^G26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC' WHERE SecCode = 91841 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 94937 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-25' WHERE SecCode = 95504 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXDQ287' WHERE SecCode = 95878 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115197 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116617 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126529 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126595 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126634 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 131520 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET Name = 'IND OIL&RES PLC(CY NOK1 SNDR' WHERE SecCode = 139223 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 339594, DsPrimQtSedol = NULL, SecMapStartDate = '2012-11-26', startDate = '2006-04-05' WHERE SecCode = 144578 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 288634 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA19682H2063', RkdSEDOL = 'BXS030', RkdCUSIP = '19682H20' WHERE SecCode = 293512 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXJVR03' WHERE SecCode = 300098 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BRCB49' WHERE SecCode = 306753 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 309977 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BRCB42' WHERE SecCode = 352045 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET Name = 'CGRE AG NPV' WHERE SecCode = 379679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 411896 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 432745 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 520567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 636195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-05-21', PermSecMapEndDate = '2026-07-27', endDate = '2026-05-21' WHERE SecCode = 646415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3271.T^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 766928 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 854182 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 1158940 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55850366387.0, ExchCode = 'BER', PermQuoteRetireDate = '2012-05-07', endDate = '2012-05-05' WHERE SecCode = 1265152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ASHIKAG', Name = 'ASHIKA GBL SECS LT INR10' WHERE SecCode = 1465979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BZ02914' WHERE SecCode = 1486652 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET Name = 'PARTNER AEROSPACE PLN10.00' WHERE SecCode = 1542751 AND Type_ = 10;
UPDATE data_universe SET Name = 'GE AEROSPACE BDR EACH 20 REPR 1 COM SH' WHERE SecCode = 1546582 AND Type_ = 10;
UPDATE data_universe SET Name = 'PHILIP MORRIS INTL BDR EACH 16 REP 1 COM' WHERE SecCode = 1546721 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622760 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET Name = 'POLSKA GRUPA HUTNI PLN0.10' WHERE SecCode = 1660626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1934499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2341361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-22', PermQuoteRetireDate = '2026-07-28', endDate = '2026-07-22' WHERE SecCode = 2580219 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21558758023.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 2830908 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BZ02914' WHERE SecCode = 2864335 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET Name = 'MONDELEZ INTL INC BDR EACH 6  REP 1 COM' WHERE SecCode = 2945285 AND Type_ = 10;
UPDATE data_universe SET Name = 'HERSHEY COMPANY BDR EACH 15 REP 1 COM' WHERE SecCode = 2945286 AND Type_ = 10;
UPDATE data_universe SET Name = 'UNION PACIFIC CORP BDR EACH 24 REPR 1 COM' WHERE SecCode = 2945289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXS3K45' WHERE SecCode = 3099400 AND Type_ = 10;
UPDATE data_universe SET Name = 'NODESTREAM LTD NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3124055 AND Type_ = 10;
UPDATE data_universe SET Name = 'MEDTRONIC PLC BDR EACH 8 REP 1 COM' WHERE SecCode = 3151354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET Name = 'FIRST SOLAR INC BDR EACH 20 REPR 1 COM' WHERE SecCode = 3232567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET Name = 'UBS GROUP AG BDR EA 4 REP 1 COM CHF0.10' WHERE SecCode = 3236057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3272839 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 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 RkdISIN = 'KYG719721220', RkdSEDOL = 'BWRXW3', RkdCUSIP = 'G7197212' WHERE SecCode = 3378474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3404165 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 3409577 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2018-02-26', startDate = '2018-02-20' WHERE SecCode = 3438039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3438134 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3444705 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3619075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET Name = 'MOODYS CORP BDR EACH 32 REPR 1 COM SH' WHERE SecCode = 3831352 AND Type_ = 10;
UPDATE data_universe SET Name = 'CME GROUP INC BDR EACH 20 REP 1 COM ''A''' WHERE SecCode = 3838944 AND Type_ = 10;
UPDATE data_universe SET Name = 'NORTHROP GRUMMAN BDR EACH 50 REPR 1 COM' WHERE SecCode = 3839010 AND Type_ = 10;
UPDATE data_universe SET Name = 'VERTEX PHARMACEUTI BDR EACH 32 REP 1 COM' WHERE SecCode = 3839016 AND Type_ = 10;
UPDATE data_universe SET Name = 'SAP SE BDR EACH 16 REPR 1 ADR' WHERE SecCode = 3998138 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4049096 AND Type_ = 10;
UPDATE data_universe SET Name = 'ANALOG DEVICES INC BDR EACH 40 REP 1 COM' WHERE SecCode = 4054199 AND Type_ = 10;
UPDATE data_universe SET Name = 'BOSTON SCIENTIFIC BDR EACH 4 REPR 1 COM' WHERE SecCode = 4054208 AND Type_ = 10;
UPDATE data_universe SET Name = 'NXP SEMICONDUCTORS BDR EACH 20 REP 1 COM' WHERE SecCode = 4054252 AND Type_ = 10;
UPDATE data_universe SET Name = 'WASTE MANAGEMENT BDR EACH 16 REP 1 COM' WHERE SecCode = 4054262 AND Type_ = 10;
UPDATE data_universe SET Name = 'T-MOBILE US INC BDR EACH 14 REPR 1 COM' WHERE SecCode = 4057453 AND Type_ = 10;
UPDATE data_universe SET Name = 'ROYAL CARIBBEAN GR BDR EACH 28 REPR 1 COM' WHERE SecCode = 4077638 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PROGRESSIVE CP(OH) BDR EACH 20 REPR 1 COM' WHERE SecCode = 4077643 AND Type_ = 10;
UPDATE data_universe SET Name = 'AUTODESK INC BDR EACH 20 REPR 1 COM' WHERE SecCode = 4077705 AND Type_ = 10;
UPDATE data_universe SET Name = 'SYNOPSYS INC BDR EACH 40 REPR 1 COM' WHERE SecCode = 4079086 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIGITAL REALTY TRU BDR EACH 16 REPR 1 COM' WHERE SecCode = 4079129 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MOTOROLA SOLUTIONS BDR EACH 32 REPR 1 COM' WHERE SecCode = 4079171 AND Type_ = 10;
UPDATE data_universe SET Name = 'MCKESSON CORP BDR EACH 64 REPR 1 COM' WHERE SecCode = 4079173 AND Type_ = 10;
UPDATE data_universe SET Name = 'KLA CORPORATION BDR EACH 20 REPR 1 COM' WHERE SecCode = 4079180 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4218669 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4298613 AND Type_ = 10;
UPDATE data_universe SET Name = 'AEP PINAGO PLANTAT IDR80' WHERE SecCode = 4341612 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'STRK' WHERE SecCode = 4429541 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 4479214 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 4595600 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 4671303 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4966798 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 5030300 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-27' WHERE SecCode = 5347334 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 5540647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', PermQuoteRetireDate = '2026-07-28', endDate = '2026-07-27' WHERE SecCode = 5617213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5645855 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5674196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-03', endDate = '2026-07-03' WHERE SecCode = 5807861 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21890440366.0, ExchCode = 'DEU' WHERE SecCode = 6256382 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TAI', ExchCode = 'TAI' WHERE SecCode = 6482672 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6608218 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6617659 AND Type_ = 10;
UPDATE data_universe SET Name = 'XIAN TAIJIN XINNEN CNY1' WHERE SecCode = 6752843 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6846670 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 7001234 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7003855 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0, PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 7006702 AND Type_ = 10;
UPDATE data_universe SET Name = 'CXMT CORPORATION CNY1 A' WHERE SecCode = 7009109 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXDPX81' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000176722.0, PriInstrPermID = 232851626455.0, PriTRBCIndPermID = 4294951997.0, PermOrgIPODate = '2024-09-10' WHERE SecCode = 11046293 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BV4JYH', PermSecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 11132638 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-27', SecMapEndDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 11141279 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BRCB6X', Name = 'YARROW BIOSCIENCE INC COM' WHERE SecCode = 11181173 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951889.0 WHERE SecCode = 11187785 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2018-07-11' WHERE SecCode = 11187906 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG1820C1107', RkdSEDOL = 'BXWTPD', RkdCUSIP = 'G1820C11' WHERE SecCode = 11188238 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11193523 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US3073598696', RkdSEDOL = 'BXW27L', RkdCUSIP = '30735986' WHERE SecCode = 11211489 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'NYS' WHERE SecCode = 11213542 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 11216054 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BRCB46' WHERE SecCode = 11220687 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US25401N6067', RkdSEDOL = 'BXW27H', RkdCUSIP = '25401N60' WHERE SecCode = 11224254 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'CNQ' WHERE SecCode = 11228793 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BX2GLK', PermSecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 11235663 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US74319X3061', RkdSEDOL = 'BVMYDD', RkdCUSIP = '74319X30' WHERE SecCode = 11237417 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4860C1078', RkdTicker = 'BIOT', RkdSEDOL = 'BRCB33', RkdCUSIP = 'G4860C10', RkdRIC = 'BIOT.O', RkdDisplayRIC = 'BIOT.OQ', RkdExchCode = 'NASD', PrimaryIssueType = 'EQU', QuotePermID = 236810510258.0, PriTrdQuotePermID = 236810510258.0, ExchCode = 'NMS', PermSecMapStartDate = '2026-07-24' WHERE SecCode = 11240505 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'DPU', RkdRIC = 'DPU.O', RkdDisplayRIC = 'DPU.OQ' WHERE SecCode = 11251027 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 11264900 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 11270798 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US03771D2018', RkdSEDOL = 'BVPL31', RkdCUSIP = '03771D20' WHERE SecCode = 11275656 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232920020267.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11297055 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232937910044.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11297191 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'JE00BPK4NV88', RkdTicker = 'DPC', RkdSEDOL = 'BPK4NV', RkdCUSIP = 'G2R11M10', RkdRIC = 'DPC', RkdDisplayRIC = 'DPC.N', RkdCode = 145238.0, RkdIssueID = 1.0, RkdIssueCode = 185860.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11298232 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299315 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTAKU', QuotePermID = 236810510295.0, InstrPermID = 232940775402.0, OrgPermID = 6000167343.0, PriTrdQuotePermID = 236810510295.0, PriValQuotePermID = 25727003317.0, PriInstrPermID = 232940775402.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-07-24', PermSecMapStartDate = '2026-07-24' WHERE SecCode = 11299614 AND Type_ = 1;
