UPDATE data_universe SET SecMapEndDate = '2026-06-05', PermSecMapEndDate = '2026-06-08', endDate = '2026-06-05' WHERE SecCode = 13060 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-06-05', PermSecMapEndDate = '2026-06-08', endDate = '2026-06-05' WHERE SecCode = 27902 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-05', PermSecMapEndDate = '2026-06-08', endDate = '2026-06-05' WHERE SecCode = 28602 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 28992 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 43789 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 44507 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-08' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 68823 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74319 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74858 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74991 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 75029 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75412 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77113 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77356 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET Name = 'BIG SKY INDUSTRIAL INC COM' WHERE SecCode = 78205 AND Type_ = 1;
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 = 78742 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 = 'S' WHERE SecCode = 79236 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79462 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79872 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81157 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET Name = 'GUANGZHOU PEARL ''A''CNY1' WHERE SecCode = 81854 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82235 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82359 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82506 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82577 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82699 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83485 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83503 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83885 AND Type_ = 10;
UPDATE data_universe SET Name = 'DEL MONTE CORPORATION ORD' WHERE SecCode = 84234 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85973 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86078 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 86781 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87170 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88602 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88699 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88976 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89357 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89697 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90113 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90338 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0, PrimaryIssueType = 'PVT' WHERE SecCode = 91969 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93156 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94459 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94465 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 95324 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96347 AND Type_ = 10;
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 RkdIssueStatus = 1.0 WHERE SecCode = 100359 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 100361 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 104848 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105007 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 = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115981 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 RkdTicker = 'LASER', PermIDTicker = 'LASER', RkdRIC = 'LASER.ST', RkdDisplayRIC = 'LASER.ST' 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 Name = 'AUDROC LTD INR1', 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 = 126439 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 = 126831 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'TWN' WHERE SecCode = 127614 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 131520 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ARKADIAN STRAT MET ORD GBP0.0001' WHERE SecCode = 132696 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 = 134785 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 = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136734 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 = 137011 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 = 140966 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142567 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 DsCtryQtStatus = 'S' WHERE SecCode = 145002 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HOTEL.ST^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-09', SecMapEndDate = '2026-06-08', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09', endDate = '2026-06-08' WHERE SecCode = 145102 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55856245271.0, ExchCode = 'DUS', PermQuoteRetireDate = '2018-11-14', endDate = '2018-11-13' WHERE SecCode = 147917 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 309233 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 312298 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 340660 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 357924 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 = 409378 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 DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'B4LNSX' WHERE SecCode = 545311 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 559737 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 559920 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 564083 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474908406.0, ExchCode = 'DEU', PermQuoteRetireDate = '2018-02-05' WHERE SecCode = 564280 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 564879 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 574547 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 637304 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 643063 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 700678 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-08', PermSecMapEndDate = NULL, startDate = '2010-06-15' WHERE SecCode = 726788 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 820885 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 833514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 850130 AND Type_ = 10;
UPDATE data_universe SET Name = 'COMPARTAMOS BANCO PEN39.81' WHERE SecCode = 1187507 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 DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1476354 AND Type_ = 10;
UPDATE data_universe SET Name = 'HYDROTEK PUBLIC CO THB1 (LOCAL)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1485605 AND Type_ = 10;
UPDATE data_universe SET Name = 'HYDROTEK PUBLIC CO THB1 (NVDR)' WHERE SecCode = 1485607 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1997851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2193116 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2367784 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 = 2469416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2536874 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 = 2593559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646553 AND Type_ = 10;
UPDATE data_universe SET Name = 'HUA HONG GRACE SEM NPV' WHERE SecCode = 2650541 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2698374 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2701612 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2702970 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2747569 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2763364 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHONGQING JIHENG P ''A''CNY1' WHERE SecCode = 2800425 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2835196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL WHERE SecCode = 2905774 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2914936 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2918009 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2963471 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-01', PermSecMapEndDate = '2026-06-07', endDate = '2026-06-01' WHERE SecCode = 2980488 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3007952 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3026618 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3076058 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3108173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3200691 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3200982 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-04', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-07', endDate = '2026-06-04' WHERE SecCode = 3207291 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000RAN0', RkdTicker = 'RAN', PermIDTicker = 'RAN', RkdSEDOL = 'BY7QHQ', RkdCUSIP = 'Q8019A10', RkdRIC = 'RAN.AX', RkdDisplayRIC = 'RAN.AX', DsPrimQtSedol = 'BY7QHQ3' WHERE SecCode = 3207868 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 = 3238739 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21597458276.0, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27', endDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3262686 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3276031 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309472 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3312494 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MTEK.NS', RkdDisplayRIC = 'MTEK.NS' WHERE SecCode = 3317563 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3317888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3384115 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3410196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3506552 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3509112 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3514834 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3532684 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3547828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3549443 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3559204 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3675449 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3713187 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 3721197 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3799568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3894832 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3903723 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4049146 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 4052366 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4223305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4320807 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4355918 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4362605 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4365041 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 4396708 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4423820 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4433933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4510022 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '9JKn.MU', RkdDisplayRIC = '9JKn.MU', RkdIssueStatus = 1.0, RkdExchCode = 'MNC', PriValQuotePermID = 21799903115.0 WHERE SecCode = 4524454 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4533297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 4571231 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARIBIOLAB CO LTD KRW500' WHERE SecCode = 4748376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4865371 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5019011 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5054827 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-08' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5264846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5288763 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5450871 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET Name = 'HUA HONG GRACE SEM CNY1 A' WHERE SecCode = 5490557 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5506529 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '464680.KQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-09', SecMapEndDate = '2026-06-08', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-08', endDate = '2026-06-08' WHERE SecCode = 5572142 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5600661 AND Type_ = 10;
UPDATE data_universe SET Name = 'PPI PUB PROP INV A NOK0.05', Country = 'SWE' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5740523 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5912053 AND Type_ = 10;
UPDATE data_universe SET Name = 'MACHINE TRAVEL INR10' WHERE SecCode = 5912080 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES0105857033', RkdSEDOL = 'BTCKLQ', DsPrimQtSedol = 'BTCKLQ3' WHERE SecCode = 6092923 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6163807 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'TWN' WHERE SecCode = 6291848 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6403358 AND Type_ = 10;
UPDATE data_universe SET Name = 'HUA HONG GRACE SEM DR70:1' WHERE SecCode = 6426959 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET Name = 'CIE DE ST-GOBAIN EUR4 (RFD 01/01/2026)', PermInstrStatus = 'DC', SecMapEndDate = '2026-06-05', PermSecMapEndDate = '2026-06-08', endDate = '2026-06-05' WHERE SecCode = 6622164 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 6796772 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007PJ9' WHERE SecCode = 6802661 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007PK7' WHERE SecCode = 6806185 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 6813227 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-05', PermSecMapEndDate = '2026-06-07', endDate = '2026-06-05' WHERE SecCode = 6820121 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007PH3' WHERE SecCode = 6839611 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007PL5' WHERE SecCode = 6870722 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'VN000000AAN7', RkdTicker = 'AAN', RkdSEDOL = 'BX9J7X', RkdCUSIP = 'Y0063210', RkdRIC = 'AAN.HM', RkdDisplayRIC = 'AAN.HM', RkdCode = 144995.0, RkdIssueID = 1.0, RkdIssueCode = 185473.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HCM', RkdExchCtry = 'VNM', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6870730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11025239 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2079-06-06', endDate = '2026-06-06' WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11181696 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11183460 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHARBONE CORP NEW COM' WHERE SecCode = 11189015 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2019-07-16' WHERE SecCode = 11198774 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US67623L5057', RkdSEDOL = 'BXCGJ3', RkdCUSIP = '67623L50', DsPrimQtSedol = 'BXCGJ32' WHERE SecCode = 11216072 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365405.0 WHERE SecCode = 11221669 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11227902 AND Type_ = 1;
UPDATE data_universe SET Name = 'TALAMORE MNG CORP COM' WHERE SecCode = 11229681 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-03-07', startDate = '2022-03-07' WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA', SecMapEndDate = '2026-06-05', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-08', endDate = '2026-06-05' WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe SET Name = 'FACTORIAL ENERGY INC COM CL A', PermOrgIPODate = NULL, startDate = '2025-06-21' WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5880S1131', RkdSEDOL = 'BVMH32', RkdCUSIP = 'G5880S11', Name = 'PING AN BIOMEDICAL CO LTD USD CL A ORD SHS', DsPrimQtSedol = 'BVMH328' WHERE SecCode = 11280999 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11284219 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US64828T8053', RkdTicker = 'RITM PR E', RkdSEDOL = 'BSBK3D', RkdCUSIP = '64828T80', RkdRIC = 'RITM_pe.K', RkdDisplayRIC = 'RITM_pe.N', RkdCode = 94418.0, RkdIssueID = 2.0, RkdIssueCode = 185469.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11285480 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11285566 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'AIBZ.U', RkdRIC = 'AIBZu.CD', RkdDisplayRIC = 'AIBZu.CD', PermQuoteRetireDate = '2026-06-09', endDate = '2026-06-09' WHERE SecCode = 11289183 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE' WHERE SecCode = 11289698 AND Type_ = 1;
UPDATE data_universe SET Name = 'NEWHOLD INVTS CORP IV UNIT 04/14/2031', IsMajorSec = 'N' WHERE SecCode = 11294533 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11296310 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11296313 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11296373 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11297056 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VGC', QuotePermID = 236807982143.0, InstrPermID = 232930361041.0, OrgPermID = 6000151779.0, PriValQuotePermID = 236807982143.0, PriInstrPermID = 232930361041.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951916.0, SecMapStartDate = '2026-06-03', PermOrgIPODate = '2026-06-05', PermSecMapStartDate = '2026-06-04', startDate = '2026-06-03' WHERE SecCode = 11297183 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FTRA.U', QuotePermID = 236807983935.0, InstrPermID = 232937910691.0, OrgPermID = 6000139512.0, PriTrdQuotePermID = 236807983935.0, PriValQuotePermID = 25727019429.0, PriInstrPermID = 232937910691.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-05', PermSecMapStartDate = '2026-06-04', startDate = '2026-06-04' WHERE SecCode = 11297191 AND Type_ = 1;
