UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-07-14', endDate = '2026-05-28' WHERE SecCode = 4259 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BKYI.O', RkdDisplayRIC = 'BKYI.OQ', RkdExchCode = 'NASD' WHERE SecCode = 9345 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US2312694084', RkdSEDOL = 'BTCL72', RkdCUSIP = '23126940' WHERE SecCode = 18047 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'MCE' WHERE SecCode = 36934 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-13', SecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 56295 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US7743744093', RkdSEDOL = 'BPXZLR', RkdCUSIP = '77437440' WHERE SecCode = 60432 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 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 = 71892 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DONGIL TECHNOLOGY KRW100' WHERE SecCode = 72682 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' 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 = 78203 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 = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', endDate = '2026-07-13' WHERE SecCode = 79403 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 DsPrimQtSedol = 'BTMPX06' WHERE SecCode = 82659 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83485 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85020 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET Name = 'ADVANCED BLDG INDS SAR10' WHERE SecCode = 85454 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87939 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '0431.HK^G26', RkdIssueStatus = 0.0 WHERE SecCode = 88250 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 Name = 'AVALON ADVANCED MATLS INC COM' WHERE SecCode = 90720 AND Type_ = 1;
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 DsCtryQtStatus = 'S' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 93682 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA03114D1087', RkdSEDOL = 'BSBFLF', RkdCUSIP = '03114D10' WHERE SecCode = 93821 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93941 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95047 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 95337 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 PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-13' WHERE SecCode = 95560 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 96898 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-07-07', PermSecMapEndDate = '2026-07-13', endDate = '2026-07-07' WHERE SecCode = 96998 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 98684 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 99271 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114068 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 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 = 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 = 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 = 126433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126595 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126788 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 = 131516 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 DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET Name = 'DISO VERWALTUNGS A NPV REGD', SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2026-07-13', PermSecMapEndDate = NULL, endDate = '2026-07-09' WHERE SecCode = 145285 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 DsCtryQtStatus = 'S' WHERE SecCode = 193324 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 = 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 DsPrimQtSedol = 'BXS0303' WHERE SecCode = 293512 AND Type_ = 1;
UPDATE data_universe SET Name = 'GCM CORPORATION LT NPV DFD 17/07/26 (EX-SPLIT)' WHERE SecCode = 325884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378075 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 = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 484585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 538910 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 558540 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SHENZHEN PENGFEI G ''A''CNY1' WHERE SecCode = 562535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 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 PrimaryIssueCode = 83596.0 WHERE SecCode = 821832 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET Name = 'BARYS RESOURCES LI NPV DFD 17/07/26 (EX-SPLIT)' WHERE SecCode = 1142412 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 RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AURUS', PermIDTicker = 'AURUS', RkdRIC = 'AURU.NS', RkdDisplayRIC = 'AURU.NS' WHERE SecCode = 1618087 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 = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARVAYA HLTH CARE INR10' WHERE SecCode = 2193116 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AAGB' WHERE SecCode = 2278101 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 = 2385337 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET Name = 'BAAN HOLDING GROUP SAR1' WHERE SecCode = 2583466 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 RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET Name = 'CITIZEN SOLAR LTD INR10' WHERE SecCode = 2701612 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 = 2894516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2952368 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 = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3018534 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMPL CAPITAL LTD INR10 (POST SUBD)' WHERE SecCode = 3075390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3084613 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 DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3267027 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NEEMS HILL AB SER''B''NPV' WHERE SecCode = 3281969 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3301800 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3354056 AND Type_ = 10;
UPDATE data_universe SET Name = 'ATLANTIC SAPPH ASA NOK0.05' WHERE SecCode = 3375309 AND Type_ = 10;
UPDATE data_universe SET Name = 'INSAN INC KRW1000' WHERE SecCode = 3395203 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3435529 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CYKL', PermIDTicker = 'CYKL', RkdRIC = 'CYKL.L', RkdDisplayRIC = 'CYKL.L' WHERE SecCode = 3906622 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-13' WHERE SecCode = 4452295 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 DsCtryQtStatus = 'S' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET Name = 'INMAR COMPANY FOR SAR10' WHERE SecCode = 4753629 AND Type_ = 10;
UPDATE data_universe SET Name = 'SHL FINANCE CO SAR10' WHERE SecCode = 4969391 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-05-26' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-05-04' WHERE SecCode = 5112392 AND Type_ = 10;
UPDATE data_universe SET Name = 'PAMTEK CO LTD KRW100' WHERE SecCode = 5422624 AND Type_ = 10;
UPDATE data_universe SET Name = 'BTG PACTUAL LOGIST COTAS' WHERE SecCode = 6258209 AND Type_ = 10;
UPDATE data_universe SET Name = 'VINCI SHOPPING CEN COTAS' WHERE SecCode = 6407307 AND Type_ = 10;
UPDATE data_universe SET Name = 'LGT GBL HOSP ITY INR10' WHERE SecCode = 6431525 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6448288 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236800860348.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-13', PermSecMapEndDate = '2026-07-13', endDate = '2026-07-13' WHERE SecCode = 6562598 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALIANZA TRUST REND COTAS' WHERE SecCode = 6601465 AND Type_ = 10;
UPDATE data_universe SET Name = 'VINCI LOGISTICA COTAS' WHERE SecCode = 6601472 AND Type_ = 10;
UPDATE data_universe SET Name = 'BRESCO FDO DE INV COTAS' WHERE SecCode = 6601480 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 96743.0, RelType = 4.0 WHERE SecCode = 6796772 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'XHC' WHERE SecCode = 6927579 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6948301 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 6969135 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007RR8', RkdTicker = '1377', RkdSEDOL = 'BVMYMV', RkdCUSIP = 'Y2927V11', RkdRIC = '1377.HK', RkdDisplayRIC = '1377.HK', RkdCode = 145152.0, RkdIssueID = 1.0, RkdIssueCode = 185735.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 134690.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6974605 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565122724.0, ExchCode = 'GSB' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11019958 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-07-07' WHERE SecCode = 11024463 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-07-07' WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ESPR.OQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-10', PermQuoteRetireDate = '2026-07-14', endDate = '2026-07-10' WHERE SecCode = 11078249 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTCL6X8' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BWL888' WHERE SecCode = 11151156 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX0YHS9' WHERE SecCode = 11198134 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US01626W2008', RkdSEDOL = 'BRSCTV', RkdCUSIP = '01626W20' WHERE SecCode = 11210122 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US57142B2034', RkdSEDOL = 'BPXZLQ', RkdCUSIP = '57142B20' WHERE SecCode = 11225381 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BWL861' WHERE SecCode = 11226560 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11231753 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXRVP01' WHERE SecCode = 11268474 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PVF.A', QuotePermID = 236791956824.0, InstrPermID = 232831840773.0, OrgPermID = 5086909885.0, PriValQuotePermID = 236791956824.0, PriInstrPermID = 232831840773.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'CVE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'BMU', IncCntry = 'BMU', PriTRBCIndPermID = 4294951362.0, SecMapStartDate = '2025-04-17', PermOrgIPODate = '2016-06-30', PermSecMapStartDate = '2025-04-16', startDate = '2016-06-30' WHERE SecCode = 11277478 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11277960 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXRYF88' WHERE SecCode = 11279079 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-10', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-13', endDate = '2026-07-10' WHERE SecCode = 11284441 AND Type_ = 1;
UPDATE data_universe SET Name = 'GENERAL FUSION GROUP LTD SHS CL A', PermOrgIPODate = NULL, startDate = '2025-09-27' WHERE SecCode = 11286103 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11297569 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11297725 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'ADR' WHERE SecCode = 11298205 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298319 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SKHY', Name = 'SK HYNIX INC AMERICAN DEPOSIT', QuotePermID = 236809267555.0, InstrPermID = 232936420432.0, OrgPermID = 4295881619.0, PriTrdQuotePermID = 236809267555.0, PriValQuotePermID = 25727015284.0, PriInstrPermID = 8589990061.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ADR', InstrClass = 'ADR', OrgTypeCode = 'COM', DomCntry = 'KOR', IncCntry = 'KOR', PriTRBCIndPermID = 4294951261.0, PermOrgIPODate = '1996-12-26', PermSecMapStartDate = '2026-07-01', startDate = '2026-07-01' WHERE SecCode = 11299029 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SAMO.U', QuotePermID = 236808748405.0, InstrPermID = 232941225291.0, OrgPermID = 6000164605.0, PriTrdQuotePermID = 236808748405.0, PriValQuotePermID = 25727016650.0, PriInstrPermID = 232941225291.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-07-10', PermSecMapStartDate = '2026-07-09', startDate = '2026-07-09' WHERE SecCode = 11299061 AND Type_ = 1;
