UPDATE data_universe SET Name = 'BANK OF HI CORP COM' WHERE SecCode = 8222 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CEPL', RkdRIC = 'CEPL.O', RkdDisplayRIC = 'CEPL.OQ', RkdExchCode = 'NASD' WHERE SecCode = 12307 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVK8VB8' WHERE SecCode = 19848 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MELON.SN^H26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 29796 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2026-07-28' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-08-24' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21563604590.0, PermSecMapEndDate = '2026-08-24' WHERE SecCode = 55155 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605378798.0, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL WHERE SecCode = 62335 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = '1GBS', RkdRIC = '1GBS.DE', RkdDisplayRIC = '1GBS.DE' WHERE SecCode = 65664 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' 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 DsCtryQtStatus = 'S' WHERE SecCode = 70969 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 72129 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-24', SecMapEndDate = '2024-08-21', PermQuoteRetireDate = '2026-08-24', PermSecMapEndDate = '2026-08-24', endDate = '2024-08-21' WHERE SecCode = 73890 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 73894 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 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 DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 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 = 79086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82801 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET Name = 'HILLGROVE RESOURCE NPV DFD 27/08/26(EX-SPLT)' WHERE SecCode = 83058 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83328 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86683 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88495 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 DsCtryQtStatus = 'A' WHERE SecCode = 89771 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TH0670C10Z00', RkdSEDOL = 'BVMHG6', RkdCUSIP = 'Y007G313' WHERE SecCode = 90115 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CXXI.CD^H26', RkdDisplayRIC = 'CXXI.CD^H26', RkdIssueStatus = 0.0 WHERE SecCode = 92961 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 95504 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 DsPrimQtSedol = 'BXCW974' WHERE SecCode = 97630 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 = 'A' WHERE SecCode = 104850 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 111487 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 112694 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114460 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 RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 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 = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 125258 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 = 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 = 126457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 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 = 131672 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 = 135125 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 = 136034 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 DsCtryQtStatus = 'S' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VIVOBIOT', RkdRIC = 'VIVO.NS', RkdDisplayRIC = 'VIVO.NS', RkdExchCode = 'NSE' WHERE SecCode = 141014 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142542 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BXNRYG27', RkdSEDOL = 'BXNRYG', RkdCUSIP = 'G9322Y21' WHERE SecCode = 146694 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21915101821.0, ExchCode = 'FRA' WHERE SecCode = 147555 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 RkdRIC = 'AVEI.BO', RkdDisplayRIC = 'AVEI.BO' WHERE SecCode = 243364 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 = 'A' WHERE SecCode = 322272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 340660 AND Type_ = 10;
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 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 = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 431231 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 PermOrgIPODate = NULL, startDate = '2008-06-19' WHERE SecCode = 522882 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 551009 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '0195.HK^H26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 568903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 574547 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 601139 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 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 = 'S' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-14' WHERE SecCode = 1160469 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 = 1209863 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET Name = 'TD POWER SYSTEMS P INR1(POST SUBD)' WHERE SecCode = 1310566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BEIJING SPORTS AND HKD0.05' WHERE SecCode = 1494004 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622760 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1693310 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 = 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 = 'S' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2529641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2535221 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580912 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 RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2782958 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 = 2923366 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'XET', DsExchQtStartDate = '2015-11-11' WHERE SecCode = 2932355 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueCode = 130204.0, RelType = 8.0 WHERE SecCode = 3037819 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 Name = 'DELTA AIRLINES INC BDR 6 REPR 1 COM' WHERE SecCode = 3151350 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3192982 AND Type_ = 10;
UPDATE data_universe SET Name = 'MSDI CO LTD KRW1000' WHERE SecCode = 3196334 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOLUTIONS CAP MGMT NPV' WHERE SecCode = 3213357 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3220460 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3229199 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365459.0 WHERE SecCode = 3256348 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3272839 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-08' WHERE SecCode = 3283798 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000487159', RkdTicker = 'GGM', PermIDTicker = 'GGM', RkdSEDOL = 'BXLTLK', RkdRIC = 'GGM.AX', RkdDisplayRIC = 'GGM.AX', DsPrimQtSedol = 'BXLTLK3', DsExchQtStartDate = '2017-02-24', PermSecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 3309732 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3317677 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '269620.KQ^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 3410196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3587036 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ID8', DsPrimQtSedol = 'BYVN4F8' WHERE SecCode = 3623744 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-25', endDate = '2026-08-25' WHERE SecCode = 3661124 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET Name = 'CAPITAL ONE FINL BDR EACH 16 REP 1 COM' WHERE SecCode = 3837227 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KINDER MORGAN INC BDR EACH 3 REPR 1 P ORD SHS' WHERE SecCode = 3837263 AND Type_ = 10;
UPDATE data_universe SET Name = 'TAPESTRY INC BDR EACH 10 REPR 1 COM SHS' WHERE SecCode = 3837271 AND Type_ = 10;
UPDATE data_universe SET Name = 'CONSTELLATION BRDS BDR EACH 12 REP 1 COM CL ''A' WHERE SecCode = 3838945 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '327610.KN^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 3881173 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 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 DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET Name = 'TRUIST FINL CORP 4 BDR REPR 1 COM' WHERE SecCode = 4054206 AND Type_ = 10;
UPDATE data_universe SET Name = 'FIRSTENERGY CORP BDR 4 REPR 1 COM' WHERE SecCode = 4054225 AND Type_ = 10;
UPDATE data_universe SET Name = 'INTL PAPER CO BDR  3  REPR 1 COM' WHERE SecCode = 4054234 AND Type_ = 10;
UPDATE data_universe SET Name = 'JOHNSON CTLS INTL BDR EACH REPR 15 COM' WHERE SecCode = 4054236 AND Type_ = 10;
UPDATE data_universe SET Name = 'KROGER CO BDR EACH REPR 6 COM' WHERE SecCode = 4054239 AND Type_ = 10;
UPDATE data_universe SET Name = 'LENNAR CORP BDR EACH 8 REPR 1 COM' WHERE SecCode = 4054241 AND Type_ = 10;
UPDATE data_universe SET Name = 'PHILLIPS 66 BDR EACH 16 REPR 1 COM' WHERE SecCode = 4054255 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOUTHERN CO. BDR 8 REPR 1 COM' WHERE SecCode = 4054257 AND Type_ = 10;
UPDATE data_universe SET Name = 'SEAGATE TECH HLDGS 55 BDR REPR 1 COM' WHERE SecCode = 4054258 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DELL TECHNOLOGIES BDR 25 REPR 1 COM' WHERE SecCode = 4057452 AND Type_ = 10;
UPDATE data_universe SET Name = 'WELLTOWER INC. BDR EACH 16 REPR 1 COM' WHERE SecCode = 4077624 AND Type_ = 10;
UPDATE data_universe SET Name = 'IRON MOUNTAIN INC BDR 12 REPR 1 COM' WHERE SecCode = 4077662 AND Type_ = 10;
UPDATE data_universe SET Name = 'TRANE TECHNOLOGIES BDR EACH 40 REPR 1 COM' WHERE SecCode = 4077663 AND Type_ = 10;
UPDATE data_universe SET Name = 'CADENCE DESIGN SYS BDR EACH 34 REPR 1 COM' WHERE SecCode = 4077690 AND Type_ = 10;
UPDATE data_universe SET Name = 'REALTY INCOME CORP BDR EACH 6 REPR 1 COM' WHERE SecCode = 4077711 AND Type_ = 10;
UPDATE data_universe SET Name = 'JEFFERIES FINL GRP BDR  5  REPR 1 COM' WHERE SecCode = 4079113 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMERICAN WATER WOR BDR EACH 12 REPR 1 COM' WHERE SecCode = 4079137 AND Type_ = 10;
UPDATE data_universe SET Name = 'RAYMOND JAMES FINL BDR EACH 12 REPR 1 COM' WHERE SecCode = 4079154 AND Type_ = 10;
UPDATE data_universe SET Name = 'IQVIA HOLDINGS INC BDR EACH 16 REPR 1 COM' WHERE SecCode = 4079184 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4197876 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 RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'LTG.HNO^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-06-19', PermQuoteRetireDate = '2026-08-25', endDate = '2026-06-19' WHERE SecCode = 4333241 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4333242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', PermQuoteRetireDate = '2026-08-25', endDate = '2026-08-24' WHERE SecCode = 4500401 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 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 PrimaryIssueCode = 128966.0 WHERE SecCode = 4707165 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 130204.0 WHERE SecCode = 4770131 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4838007 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KLVDA', DsPrimQtSedol = 'BNC3HS4', PermSecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 4871191 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4932395 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5061308 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951694.0 WHERE SecCode = 5350567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5597158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5657384 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 140761.0 WHERE SecCode = 5993893 AND Type_ = 10;
UPDATE data_universe SET Name = 'C.P. TOWER LEASEHO THB9.0283 (LOCAL)' WHERE SecCode = 6006779 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 141258.0 WHERE SecCode = 6043439 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6448312 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A420ZL4', RkdTicker = 'EVAC', RkdSEDOL = 'BVR0QB', RkdCUSIP = 'D2R0XZ10', RkdRIC = 'EVACG.DE', RkdDisplayRIC = 'EVACG.DE', RkdCode = 145389.0, RkdIssueID = 1.0, RkdIssueCode = 186100.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ETR', RkdExchCtry = 'DEU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6789603 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-06-01' WHERE SecCode = 6930637 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6951879 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6992706 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7000386 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'NVDR' WHERE SecCode = 7025897 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7061732 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'RMAX.N^H26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-25', endDate = '2026-08-25' WHERE SecCode = 11108370 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'EDVA', RkdRIC = 'EDVA.K', RkdDisplayRIC = 'EDVA.A', Name = 'ENDOVIA HEALTH SCIENCES INC COM NEW' WHERE SecCode = 11132638 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11160338 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US08862E3071', RkdSEDOL = 'BXCH07', RkdCUSIP = '08862E30' WHERE SecCode = 11196254 AND Type_ = 1;
UPDATE data_universe SET Name = 'HUMACYTE INC *W EXP 08/26/2026' WHERE SecCode = 11214672 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US64081V2088', RkdSEDOL = 'BT6M3W', RkdCUSIP = '64081V20' WHERE SecCode = 11215364 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-24', SecMapEndDate = '2026-08-21', endDate = '2026-08-21' WHERE SecCode = 11218585 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BV8CX05' WHERE SecCode = 11223968 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF HAWAII 4.375% DEP PFD A' WHERE SecCode = 11225319 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BV8CXW7' WHERE SecCode = 11229943 AND Type_ = 1;
UPDATE data_universe SET Name = 'NEXTPOWER INC COM' WHERE SecCode = 11249583 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11255290 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT', PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11257663 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 11264520 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF HI CORP DEP SHS SER B' WHERE SecCode = 11266183 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2021-10-07' WHERE SecCode = 11278468 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11298691 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299678 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299863 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11300389 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'YOAIF', QuotePermID = 236812374858.0, InstrPermID = 232929358456.0, OrgPermID = 6000123174.0, PriValQuotePermID = 236806714500.0, PriInstrPermID = 232929358456.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GTC', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2026-05-07', PermSecMapStartDate = '2026-08-12' WHERE SecCode = 11300460 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OSPR', QuotePermID = 236812779405.0, InstrPermID = 232926430894.0, OrgPermID = 6000165942.0, PriTrdQuotePermID = 236812779405.0, PriValQuotePermID = 25726992858.0, PriInstrPermID = 232926430894.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-07-01', PermSecMapStartDate = '2026-08-20', startDate = '2026-07-01' WHERE SecCode = 11300806 AND Type_ = 1;