UPDATE data_universe SET Name = 'AEP PLANTATIONS PL ORD GBP0.025' WHERE SecCode = 430 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET Country = 'CYM' WHERE SecCode = 13989 AND Type_ = 1;
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 PermIDTicker = 'CCAP' WHERE SecCode = 65128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 74539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78742 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79462 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80964 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 81915 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JSMART TECHNOLOGIE HKD0.1' WHERE SecCode = 85080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86473 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87178 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88699 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90338 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA7707671011', RkdTicker = 'ROB', RkdSEDOL = 'BRSCZV', RkdCUSIP = '77076710', RkdRIC = 'ROB.V', RkdDisplayRIC = 'ROB.V' WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 94266 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'SHINANEN HOLDINGS NPV' WHERE SecCode = 95431 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96110 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-06-23' WHERE SecCode = 96476 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISIONARY METALS CORP COM NEW' WHERE SecCode = 98122 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AIMAX' WHERE SecCode = 112408 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'RECSI.OL^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-25', SecMapEndDate = '2026-06-24', PermQuoteRetireDate = '2026-06-25', endDate = '2026-06-24' WHERE SecCode = 114528 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115197 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 115380 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126595 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126831 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 131516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 131520 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134785 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135125 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136734 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 288634 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 330355 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2025-06-03', endDate = '2025-06-03' WHERE SecCode = 345666 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 368238 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 380221 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 391247 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-04-07', endDate = '2026-04-07' WHERE SecCode = 513474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 542367 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 574547 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-04-10', endDate = '2026-04-10' WHERE SecCode = 706545 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 787613 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ESKP.WA^F26', RkdIssueStatus = 0.0 WHERE SecCode = 798142 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET Name = 'ROYAL HEA' WHERE SecCode = 1056463 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-03-02', endDate = '2026-03-02' WHERE SecCode = 1154797 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1569390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1602456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 1610436 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1693310 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2593559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2701612 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCP STANDARD CAPIT NPV' WHERE SecCode = 2830908 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2876226 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET Name = 'BTB KOREA CO LTD KRW500' WHERE SecCode = 2914936 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SFA NEXEL CO LTD KRW100' WHERE SecCode = 2966345 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3059737 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3108173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 3235105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3300838 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEINOR HOMES SA EUR3.8027' WHERE SecCode = 3319123 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2026-06-26', endDate = '2026-06-26' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3392421 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsPrimQtSedol = NULL, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-25', PermQuoteRetireDate = '2026-06-26', endDate = '2026-06-25' WHERE SecCode = 3445080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3526122 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3526124 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET Name = 'DYNAMIC SOLUTION C KRW1000' WHERE SecCode = 3675449 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3978265 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3980012 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-17' WHERE SecCode = 4194828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 4426889 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4557737 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 DsCtryQtStatus = 'A' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET Name = 'TOMAHAWK METALS ORD GBP0.0001' WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5399782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5418727 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6310627 AND Type_ = 10;
UPDATE data_universe SET Name = 'NAF COMPANY SAR 1' WHERE SecCode = 6377041 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6674454 AND Type_ = 10;
UPDATE data_universe SET Country = 'POL' WHERE SecCode = 6832532 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236808829663.0, IsPrimaryQuote = 1.0, ExchCode = 'ASX' WHERE SecCode = 6937641 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6939101 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544798', QuotePermID = 236808846419.0, ExchCode = 'BSE', PermSecMapStartDate = '2026-06-24', startDate = '2026-06-24' WHERE SecCode = 6939106 AND Type_ = 10;
UPDATE data_universe SET Name = 'NUWELLIS INC', DsPrimQtSedol = 'BNVVQV5' WHERE SecCode = 11021598 AND Type_ = 1;
UPDATE data_universe SET Name = 'VIVOPOWER PLC ORD CL A' WHERE SecCode = 11166235 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SMWE', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BNVVVH6' WHERE SecCode = 11178978 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727265879.0, InstrPermID = 25727265881.0, OrgPermID = 5079900530.0, PriTrdQuotePermID = 25727265879.0, PriValQuotePermID = 25727265880.0, PriInstrPermID = 25727265881.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ADR', InstrClass = 'ADR', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951265.0, PermQuoteRetireDate = '2026-06-25', PermOrgIPODate = '2021-05-28', PermSecMapStartDate = '2021-05-28', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11224780 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CWAN.N^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-25', SecMapEndDate = '2026-06-24', PermQuoteRetireDate = '2026-06-25', endDate = '2026-06-24' WHERE SecCode = 11230564 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-26', endDate = '2026-06-26' WHERE SecCode = 11234124 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BNVVR45' WHERE SecCode = 11244002 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11277960 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BNVVR34' WHERE SecCode = 11281757 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-26', SecMapEndDate = '2026-01-15', endDate = '2026-01-15' WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe SET Name = 'AIB DATA CENTERS INC COM' WHERE SecCode = 11293248 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11296578 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297191 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808830362.0, IsPrimaryQuote = 1.0, ExchCode = 'TOR' WHERE SecCode = 11298170 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808831306.0, IsPrimaryQuote = 1.0, ExchCode = 'CVE' WHERE SecCode = 11298186 AND Type_ = 1;