UPDATE data_universe SET ISIN = NULL, Name = 'DCC ENERGY PLC ORD EUR0.25 (CDI)' WHERE SecCode = 3398 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HELICAL PLC ORD GBP0.0105' WHERE SecCode = 5979 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2018-01-15', PermSecMapEndDate = '2026-07-20', endDate = '2018-01-15' WHERE SecCode = 10081 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-17', PermQuoteRetireDate = '2026-07-21', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-17' WHERE SecCode = 13231 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CREG.PK', RkdDisplayRIC = 'CREG.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 14009 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SCAFS', QuotePermID = 236809413457.0, PermQuoteStatus = 'AC', ExchCode = 'MCE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-17', PermSecMapEndDate = NULL, startDate = '1993-02-09' WHERE SecCode = 34112 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 37631 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 40255 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 46163 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 48629 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 49435 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 49698 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 52016 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 52597 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 52734 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 53104 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 53167 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 53347 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 56124 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AMPER SA EUR1.25(POST CONS)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 60151 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 62323 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 = 71892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ISR' WHERE SecCode = 75288 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 76022 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 Name = 'FBR LTD NPV DFD 27/07/26(EX-SPLT)' WHERE SecCode = 79182 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIMPLEX CASTINGS INR2 (POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 81130 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81495 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 81697 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 82721 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 DsCtryQtStatus = 'A' WHERE SecCode = 86521 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DT CAPITAL LIMITED HKD0.15' WHERE SecCode = 87188 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87838 AND Type_ = 10;
UPDATE data_universe SET Name = 'GREAT WALL TERROIR HKD0.1 POST B/L CHANGE', DsPrimQtSedol = 'BXV1RZ6', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 87947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89799 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVMHG63', PermSecMapEndDate = '2026-05-12', endDate = '2026-05-12' WHERE SecCode = 90115 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 OrgPermID = 6000191709.0 WHERE SecCode = 94367 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94937 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TONGYANG INC KRW1000' WHERE SecCode = 97691 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98797 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA38141A6025', RkdSEDOL = 'BTMT3V', RkdCUSIP = '38141A60' WHERE SecCode = 99271 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 100724 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VAX.H', ExchCode = 'NEX' WHERE SecCode = 100792 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102597 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102789 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156380.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102863 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 103626 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 104502 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-16', SecMapEndDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 111353 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVMWHP4', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 112417 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 = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 121264 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 Name = 'STELLAR RESOURCES NPV DFD 24/07/26 (EX-SPLIT)' WHERE SecCode = 125248 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 = 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 137931 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 PermSecMapStartDate = '2016-06-02' WHERE SecCode = 142886 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 PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 146271 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 146275 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 146283 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 179072 AND Type_ = 10;
UPDATE data_universe SET Name = 'ATHENA RESOURCES NPV DFD 23/07/26(EX-SPLT)' WHERE SecCode = 180020 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2019-04-12' WHERE SecCode = 201990 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 239119 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 240051 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 241763 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 241853 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 241855 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 242002 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 IsMajorSec = 'N', PermOrgIPODate = '2025-11-07' WHERE SecCode = 243470 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 Name = 'OSISKO GOLD GROUP INC COM NEW' WHERE SecCode = 322922 AND Type_ = 1;
UPDATE data_universe SET Name = 'GCM CORPORATION LT NPV' WHERE SecCode = 325884 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-21', SecMapEndDate = '2026-07-20', PermQuoteRetireDate = '2026-07-21', endDate = '2026-07-20' WHERE SecCode = 331577 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 336464 AND Type_ = 10;
UPDATE data_universe SET Name = 'PLATAURO METALS CORP COM SHS' WHERE SecCode = 353611 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 364378 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 ISIN = NULL, Name = 'ARTINI HLDGS LTD HKD0.25' WHERE SecCode = 384065 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 388224 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 = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 507425 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 530685 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 531911 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555854 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555870 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555880 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555936 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156917.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 555939 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555982 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555987 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555995 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555998 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 556020 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 556021 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 556079 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 557845 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 557900 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 557901 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 561090 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21606036474.0, ExchCode = 'MUN', PermQuoteRetireDate = '2018-02-19' WHERE SecCode = 564280 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 566157 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 580461 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 656342 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 685120 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-11', endDate = '2023-07-11' WHERE SecCode = 703159 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-11', endDate = '2023-07-11' WHERE SecCode = 703304 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 703334 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2015-08-03' WHERE SecCode = 703347 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703360 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-10-12' WHERE SecCode = 703367 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 703456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-19' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 879276 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET Name = 'BARYS RESOURCES LI NPV' 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 DsCtryQtStatus = 'S' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 1246746 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 PermInstrStatus = 'DC' WHERE SecCode = 1476760 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 1534890 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 1534891 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MBNK', QuotePermID = 21616156536.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 1631839 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1636779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 1773399 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 PermInstrStatus = 'DC' WHERE SecCode = 2004949 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2244322 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 QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-11', endDate = '2023-07-11' WHERE SecCode = 2450666 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 RkdISIN = 'AU0000473282', RkdSEDOL = 'BRCFQ2', RkdCUSIP = 'Q7797A10' WHERE SecCode = 2528745 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2554946 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2579451 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 = 2592377 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 2701549 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2750968 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 ISIN = NULL WHERE SecCode = 2882500 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 = 'A', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', endDate = '2026-07-14' WHERE SecCode = 2935048 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET Name = 'AGOS CO LTD KRW500' WHERE SecCode = 2986160 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 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 = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-20', SecMapEndDate = '2026-07-08', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-08' WHERE SecCode = 3217882 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 PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 3247536 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951994.0 WHERE SecCode = 3267027 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309731 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BWRXW32' WHERE SecCode = 3378474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3535953 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 PrimaryIssueType = 'EQU' WHERE SecCode = 3794666 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3873151 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 = 4036729 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 4054229 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 4409912 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PRE' WHERE SecCode = 4443990 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NGRD3.SA^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 4446111 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 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 PermOrgIPODate = NULL WHERE SecCode = 4627843 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4642911 AND Type_ = 10;
UPDATE data_universe SET Name = 'ANCHORCORE SE EUR1.00' WHERE SecCode = 4744021 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET Name = 'TECHNOLOGY MINERAL ORD GBP0.0005' WHERE SecCode = 4773789 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5320917 AND Type_ = 10;
UPDATE data_universe SET Name = 'GITSN INC. KRW500' WHERE SecCode = 5418727 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5540647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5617108 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-21', SecMapEndDate = '2026-07-17', endDate = '2026-07-17' WHERE SecCode = 5669591 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-21', SecMapEndDate = '2026-07-20', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 5842444 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6400766 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y', PermOrgIPODate = '2025-11-07' WHERE SecCode = 6541027 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-04-02', startDate = '2026-03-18' WHERE SecCode = 6756394 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-03' WHERE SecCode = 6893664 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945364 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6969133 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985918 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232943733091.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6985983 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6989184 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000079192.0, PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 10924415 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 10989949 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11068907 AND Type_ = 1;
UPDATE data_universe SET Name = 'GATES INDUSTRIAL CORP LTD COM' WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVK35P5' WHERE SecCode = 11184721 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXWTPD3' WHERE SecCode = 11188238 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11191670 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BXP2VZ', Name = 'NIKI BIOSOLUTIONS INC COM' WHERE SecCode = 11192828 AND Type_ = 1;
UPDATE data_universe SET Name = 'QUHUO LTD ORD SHS CL A' WHERE SecCode = 11209704 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000097031.0 WHERE SecCode = 11227595 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA67449X1050', RkdTicker = 'OCAL', PermIDTicker = 'OCAL', RkdSEDOL = 'BVK35N', RkdCUSIP = '67449X10', RkdRIC = 'OCAL.V', RkdDisplayRIC = 'OCAL.V', DsPrimQtSedol = 'BVK35N3' WHERE SecCode = 11244657 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE data_universe SET Name = 'OSISKO GOLD GROUP INC *W EXP 05/27/2027' WHERE SecCode = 11252737 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-07-06', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-06' WHERE SecCode = 11260559 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-07-06', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-06' WHERE SecCode = 11260969 AND Type_ = 1;
UPDATE data_universe SET Name = 'MINDFORGE INC ORD SHS CL A' WHERE SecCode = 11263606 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C04JZ28' WHERE SecCode = 11266044 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11267227 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11268942 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-07-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-20', endDate = '2026-07-17' WHERE SecCode = 11274425 AND Type_ = 1;
UPDATE data_universe SET Name = 'BOXABL INC COM', PermOrgIPODate = NULL, startDate = '2025-02-08' WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE' WHERE SecCode = 11275066 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIGL' WHERE SecCode = 11277561 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11284441 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11286103 AND Type_ = 1;
UPDATE data_universe SET Name = 'AGROZ INC. CL A ORD SHS' WHERE SecCode = 11286201 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11296371 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232922966833.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11296650 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11297352 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232941060963.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11298692 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299305 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SHOT', IsMajorSec = 'Y', QuotePermID = 236809896653.0, InstrPermID = 232922445516.0, OrgPermID = 6000045914.0, PriTrdQuotePermID = 236809896653.0, PriValQuotePermID = 25727005250.0, PriInstrPermID = 232922445516.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-06-10', PermSecMapStartDate = '2026-07-16', startDate = '2026-06-10' WHERE SecCode = 11299375 AND Type_ = 1;
