UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 1679 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3833 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'JIGI' WHERE SecCode = 5037 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 7493 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836052415, Ticker = 'ZHEH', ExchCode = 'LSE', PermQuoteRetireDate = '2023-05-19' WHERE SecCode = 9121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461399, Ticker = '0Q1Nl', ExchCode = 'BCO' WHERE SecCode = 9338 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 9451 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836049459, Ticker = 'PACC', ExchCode = 'LSE', PermQuoteRetireDate = '2016-03-07' WHERE SecCode = 9856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556856, Ticker = 'KPN', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 9908 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 12961 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 17450 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 17729 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'BZDLF' WHERE SecCode = 18263 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 23221 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 27115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30212 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30254 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 31546 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 33865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386343, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-31' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, ExchCode = 'BER' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384206, ExchCode = 'LAS' WHERE SecCode = 36613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 37852 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333718, ExchCode = 'BER' WHERE SecCode = 38095 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 38106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661362178, ExchCode = 'STU' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 38316 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 38477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521103746, ExchCode = 'STU' WHERE SecCode = 38625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483828644, Ticker = 'EIC', ExchCode = 'STU', PermQuoteRetireDate = '2013-09-17' WHERE SecCode = 38658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325494, ExchCode = 'BER' WHERE SecCode = 38731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950957, Ticker = 'MZN', ExchCode = 'STU', PermQuoteRetireDate = '2020-01-13' WHERE SecCode = 38771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489858, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-22' WHERE SecCode = 38789 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 41632 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 43286 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 44329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846120871, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 49034 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 49323 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 49487 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'NAVBQ' WHERE SecCode = 49821 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 50558 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 52711 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 54468 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 54829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034431, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 54890 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 55088 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21538164352, ExchCode = 'DEU' WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478545911, Ticker = 'CTV', ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 55766 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 56011 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'DUNYH.E' WHERE SecCode = 56148 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 57921 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952000.0 WHERE SecCode = 58361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475416805, Ticker = NULL, ExchCode = 'MUN', PermQuoteRetireDate = '2004-10-11' WHERE SecCode = 58925 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 58953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330754, ExchCode = 'BER' WHERE SecCode = 59806 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 59904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460107, ValQuotePermID = 21842460107.0, IsPrimaryQuote = 1, Ticker = 'NT5', ExchCode = 'HAN', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 59951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427368, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526399804, ExchCode = 'FRA' WHERE SecCode = 60669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 62379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474854031, ExchCode = 'DEU' WHERE SecCode = 62694 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 63202 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VCT0' WHERE SecCode = 63954 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 63995 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 64210 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 64384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521225233, PermQuoteStatus = 'AC', Ticker = 'HVP0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 64448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475633259, ExchCode = 'GER', PermQuoteRetireDate = '2006-11-13' WHERE SecCode = 64462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836508583, ExchCode = 'FRA', PermQuoteRetireDate = '2014-06-11' WHERE SecCode = 64504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298297, ExchCode = 'DUS' WHERE SecCode = 64549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835798417, Ticker = 'ST7C', ExchCode = 'DUS', PermQuoteRetireDate = '2018-08-27' WHERE SecCode = 64555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331912, ExchCode = 'BER', PermQuoteRetireDate = '2014-09-04' WHERE SecCode = 64558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488610, ExchCode = 'QTX' WHERE SecCode = 64572 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ERC' WHERE SecCode = 64798 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 65357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688418757, ExchCode = 'QTX' WHERE SecCode = 65783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324104, ExchCode = 'BER' WHERE SecCode = 65807 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 66304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860086540, ExchCode = 'GTX' WHERE SecCode = 66922 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 68125 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 68614 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 69984 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 70306 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 70899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474875995, ValQuotePermID = 21842460107.0, IsPrimaryQuote = 0, ExchCode = 'IXJ', PermQuoteRetireDate = '2012-09-18' WHERE SecCode = 71468 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 71610 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 73124 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 73630 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 75851 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 78585 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 79390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795167535, InstrPermID = 232898609900, ValQuotePermID = 236795167535.0, PermSecMapStartDate = '2025-09-02', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 80309 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 80738 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 81567 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 81567 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 82248 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 82489 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 82838 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 82864 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 83481 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 83694 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 83801 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 84272 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 84951 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 85118 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 85710 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 85727 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-16' WHERE SecCode = 85934 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 86086 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86753 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 86838 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87347 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 88710 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 89109 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 89706 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 91128 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 91971 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TFM.H', ExchCode = 'NEX' WHERE SecCode = 92906 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 92907 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 93743 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 94005 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 94606 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 94997 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 95444 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'MIT.H', ExchCode = 'NEX' WHERE SecCode = 96779 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 97098 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 97202 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 98647 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236795167513, InstrPermID = 232898610030, ValQuotePermID = 236795167513.0, IsPrimaryInstr = 1, PermSecMapStartDate = '2025-09-02', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 99943 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100097 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 100099 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951263.0 WHERE SecCode = 101000 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 101013 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21863182394, ExchCode = 'MUN' WHERE SecCode = 103666 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BLUME.E' WHERE SecCode = 103786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, ExchCode = 'BER' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ALPAS' WHERE SecCode = 103908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837360475, Ticker = 'SKG', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 104043 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 104986 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 104987 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 105003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793848482, ValQuotePermID = 55851566138.0, IsPrimaryQuote = 0, PermQuoteStatus = 'AC', Ticker = 'AUGO', ExchCode = 'XMS', DomCntry = 'USA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-07-16', PermSecMapEndDate = NULL WHERE SecCode = 110311 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 111297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796466906, ExchCode = 'TDG', PermSecMapStartDate = '2025-09-17' WHERE SecCode = 112657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487385191, ExchCode = 'FRA' WHERE SecCode = 112744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853085558, ExchCode = 'FRA' WHERE SecCode = 112814 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 114433 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 114602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485225160, ExchCode = 'STU', PermQuoteRetireDate = '2024-06-27', PermSecMapEndDate = '2024-06-27' WHERE SecCode = 114758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626522639, ExchCode = 'STU' WHERE SecCode = 114759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809545193, ExchCode = 'TDG' WHERE SecCode = 114789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337680, ExchCode = 'BER' WHERE SecCode = 114831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288989, ExchCode = 'GTX' WHERE SecCode = 114833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838236737, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 114837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331367, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 114840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334482, ExchCode = 'BER' WHERE SecCode = 114845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332480, ExchCode = 'BER' WHERE SecCode = 114850 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 116034 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530619758, ExchCode = 'FRA' WHERE SecCode = 116139 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 116481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474927574, ExchCode = 'DEU' WHERE SecCode = 116528 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 120700 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 122693 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 124316 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21644782383, ExchCode = 'FRA' WHERE SecCode = 124828 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123504, ExchCode = 'FRA' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173501, Ticker = 'ESL', ExchCode = 'BRN' WHERE SecCode = 126877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329157, ExchCode = 'BER' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909445, ExchCode = 'FRA' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 130409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525792698, ExchCode = 'DEU' WHERE SecCode = 131777 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 135529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186346, ExchCode = 'DEU' WHERE SecCode = 136909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776858458, ExchCode = 'STU' WHERE SecCode = 136916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348335, ExchCode = 'QTX' WHERE SecCode = 136931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781307318, ExchCode = 'QTX' WHERE SecCode = 136934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058705, ExchCode = 'DEU' WHERE SecCode = 136936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822360, ExchCode = 'DEU' WHERE SecCode = 136946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452946, ExchCode = 'DEU' WHERE SecCode = 137236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492614, ExchCode = 'QTX' WHERE SecCode = 137300 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 137691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560378012, ExchCode = 'CHI' WHERE SecCode = 137860 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 138026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652758, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-11' WHERE SecCode = 139011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543203134, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-14' WHERE SecCode = 139013 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 139992 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 140027 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 140273 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 140330 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 140617 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 141293 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 141885 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 141906 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 142063 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796519088.0 WHERE SecCode = 142574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838235310, ExchCode = 'MUN' WHERE SecCode = 143197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474896727, ExchCode = 'DEU' WHERE SecCode = 143198 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 143433 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 144125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461396, Ticker = '0NOFl', ExchCode = 'BCO' WHERE SecCode = 144186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551269267, ExchCode = 'STU' WHERE SecCode = 144232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571165, Ticker = '0H6Q', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 144272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782711, ExchCode = 'DUS' WHERE SecCode = 144300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787407, ExchCode = 'DUS' WHERE SecCode = 144320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664445764, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302347, PermQuoteStatus = 'DC', Ticker = 'TMS.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 144414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330935, ExchCode = 'BER' WHERE SecCode = 144437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337718, ExchCode = 'BER' WHERE SecCode = 144438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327294, ExchCode = 'BER' WHERE SecCode = 144439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777643087, ExchCode = 'BER' WHERE SecCode = 144440 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 144506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532071663, ExchCode = 'MUN', PermQuoteRetireDate = '2014-12-15' WHERE SecCode = 144542 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 145178 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 145481 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951840.0 WHERE SecCode = 145863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334976, ExchCode = 'DEU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapStartDate = '2012-12-18' WHERE SecCode = 146206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785774721, ExchCode = 'DEU' WHERE SecCode = 146221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460836, ExchCode = 'HAN' WHERE SecCode = 146223 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'NNW' WHERE SecCode = 146530 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 147126 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522633023, ExchCode = 'MUN' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 163971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 168907 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 176523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856949141, ExchCode = 'FRA' WHERE SecCode = 177328 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 177671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, ExchCode = 'BER' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327136, ExchCode = 'BER' WHERE SecCode = 178451 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 180517 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 183337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131851414, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 185777 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 189259 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 189772 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 197200 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 197415 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 200736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788425927, ExchCode = 'LAS' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849054916, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 203070 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 206747 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796328454, ExchCode = 'LAS' WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 210189 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 221381 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 230089 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 240072 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 248483 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 248734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477154080, ExchCode = 'FRA', PermQuoteRetireDate = '2017-03-01' WHERE SecCode = 249264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475835886, ExchCode = 'BER', PermQuoteRetireDate = '2012-09-21' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 249282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565082887, ExchCode = 'FRA' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856726590, ExchCode = 'STU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474978939, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331035, ExchCode = 'BER' WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528269166, ExchCode = 'DEU' WHERE SecCode = 249402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396050, ExchCode = 'FRA' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957755807, ExchCode = 'STU' WHERE SecCode = 249438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754447, ExchCode = 'MUN' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 252551 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 254067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960077493, ExchCode = 'GTX' WHERE SecCode = 259026 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 278022 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55851566138, ValQuotePermID = 55851566138.0, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', ExchCode = 'FRA', DomCntry = 'USA', PermQuoteRetireDate = NULL WHERE SecCode = 286286 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'L1G', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 292778 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 293438 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 294907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, ExchCode = 'BER' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 297498 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 298972 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 301073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131850953, ExchCode = 'DEU' WHERE SecCode = 303854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320454, ExchCode = 'BER' WHERE SecCode = 304579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320511, Ticker = '31ID', ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 304581 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 304979 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 306178 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 306179 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 316471 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 317424 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 317551 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 317618 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 321821 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21842460107.0 WHERE SecCode = 323753 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 324696 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 325810 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 326385 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 326814 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 326895 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 22131851187, InstrPermID = 21498107911, ValQuotePermID = 236795665850.0, IsPrimaryInstr = 1, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '8BZ', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 328509 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 331506 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 331740 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 336022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 337875 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 341242 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 343539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845607, ExchCode = 'FRA' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334559, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 345858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130920528, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 348479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474950915, ExchCode = 'DEU', PermQuoteRetireDate = '2017-12-15' WHERE SecCode = 351504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388463, Ticker = 'WIHL.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353994 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 354680 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 362805 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 367386 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796440421, ValQuotePermID = 236796440421.0, Ticker = 'FINKURVE', ExchCode = 'NSI' WHERE SecCode = 387505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840906149, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-04' WHERE SecCode = 389776 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 397755 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 415865 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 415923 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 418561 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 439770 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 443161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 520275 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 522198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 534958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 551335 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552210 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475846461, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 556601 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 559560 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 560499 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 586040 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 601148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 703142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863005195, Ticker = 'BABC', ExchCode = 'LSE' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 770039 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 773284 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 775003 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951741.0 WHERE SecCode = 790648 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 793380 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 810840 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 826255 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 841106 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 843180 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 873492 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 933550 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 948082 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 995585 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1019997 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1109305 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1130726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 1372743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541294021, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 1389099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734632074, ExchCode = 'DEU' WHERE SecCode = 1441088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476159348, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1449053 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459433 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 1472778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535814878, ValQuotePermID = 21788257886.0, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', Ticker = 'INSE.GB', ExchCode = 'AQS', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 1472965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491998110, ExchCode = 'TDG', PermQuoteRetireDate = '2016-05-16' WHERE SecCode = 1528650 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 1534257 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1544768 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1565181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131159160, ExchCode = 'HAM', PermSecMapStartDate = '2024-09-23' WHERE SecCode = 1596488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953911750, ExchCode = 'GTX' WHERE SecCode = 1596489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916713839, ExchCode = 'MUN' WHERE SecCode = 1596490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505186418, ExchCode = 'BUR' WHERE SecCode = 1596521 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 1678431 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 1692689 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 1699052 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 1699053 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 1699054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 1926065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585026984, ExchCode = 'BTE' WHERE SecCode = 1931297 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1973244 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1973550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985521, ExchCode = 'STU', PermQuoteRetireDate = '2015-05-27' WHERE SecCode = 2018342 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2226908 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2227874 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 2249250 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2272595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525348690, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2279777 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 2286304 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = '2025-10-10', PermOrgIPODate = NULL, PermSecMapStartDate = '2025-10-01', PermSecMapEndDate = NULL WHERE SecCode = 2298762 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC', PermOrgIPODate = NULL WHERE SecCode = 2315212 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2328684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820384482, Ticker = 'XDN0l', ExchCode = 'BCO' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534157905, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534236849, ExchCode = 'FRA' WHERE SecCode = 2453132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644531039, Ticker = 'HM6Ad', ExchCode = 'BCO' WHERE SecCode = 2453144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554847086, ExchCode = 'DEU' WHERE SecCode = 2453146 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2470135 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2495686 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2513095 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 2515727 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 2526047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909440, ExchCode = 'DEU' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2542444 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2545795 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2560601 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-17' WHERE SecCode = 2566806 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2582177 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2583470 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 2586429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2625089 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2630115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561270622, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-12' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548381098, ExchCode = 'FRA' WHERE SecCode = 2647456 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2650531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548878301, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-03' WHERE SecCode = 2650629 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761648844, ExchCode = 'STU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2657417 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2679880 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2679886 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2685337 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 2693648 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 2696584 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 2696739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551797405, Ticker = 'CBKDe', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2706343 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 2711209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552459618, ExchCode = 'STU' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552380654, ExchCode = 'BER' WHERE SecCode = 2718429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784881963, ExchCode = 'QTX' WHERE SecCode = 2747510 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2747739 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2751766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555272551, ExchCode = 'DEU' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598947, ExchCode = 'STU' WHERE SecCode = 2796968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252740, ExchCode = 'BER' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560442254, ExchCode = 'TDG' WHERE SecCode = 2821436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558562157, ExchCode = 'FRA' WHERE SecCode = 2827908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559812802, ExchCode = 'TDG' WHERE SecCode = 2841897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 2864442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'LKY' WHERE SecCode = 2868637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561682172, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562215255, ExchCode = 'DEU' WHERE SecCode = 2876219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2885891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565698268, ExchCode = 'DEU' WHERE SecCode = 2918012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2925389 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2926162 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748300, ExchCode = 'STU', PermQuoteRetireDate = '2020-05-05' WHERE SecCode = 2936005 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2939975 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2945307 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2946508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568990720, ExchCode = 'TDG' WHERE SecCode = 2947855 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2956426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062311, ExchCode = 'MUN' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2975899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, Ticker = 'DML2', ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AXX' WHERE SecCode = 3011222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574510951, ExchCode = 'FRA' WHERE SecCode = 3024440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678613, ExchCode = 'BIV' WHERE SecCode = 3024446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576069516, ExchCode = 'DEU' WHERE SecCode = 3031579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479850, ExchCode = 'QTX' WHERE SecCode = 3045201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509907562, ExchCode = 'BEC' WHERE SecCode = 3054221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473256, ExchCode = 'DEU' WHERE SecCode = 3074402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927375, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2020-07-09' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916283660, ExchCode = 'BER' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022607, ExchCode = 'DEU' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583964281, ExchCode = 'DEU' WHERE SecCode = 3112921 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3119755 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3121084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077935, ExchCode = 'LAS' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933107501, ExchCode = 'MUN' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = NULL WHERE SecCode = 3128125 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3149671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622175, Ticker = '0R9Ul', ExchCode = 'BCO' WHERE SecCode = 3156022 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3160187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587662536, ExchCode = 'STU' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587055393, ExchCode = 'STU' WHERE SecCode = 3166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599769591, ExchCode = 'TDG' WHERE SecCode = 3169823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3181302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011949508, ExchCode = 'AQX' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825337729, Ticker = '3EML.GB', ExchCode = 'AQS' WHERE SecCode = 3193773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591145177, ExchCode = 'STU', PermQuoteRetireDate = '2021-07-06' WHERE SecCode = 3196331 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3196346 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3198784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3200563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937063404, ExchCode = 'DUS' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3211361 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3213375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778893855, ExchCode = 'BER' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595464532, ExchCode = 'BER' WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386946, ExchCode = 'LAS' WHERE SecCode = 3230847 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3244966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779584053, ExchCode = 'GTX' WHERE SecCode = 3247560 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3247673 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3247805 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3248050 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3257140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598110773, ExchCode = 'STU' WHERE SecCode = 3257553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'S1K0' WHERE SecCode = 3261049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599774622, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 3271586 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3271831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705332, Ticker = 'MBWSN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3273583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704158, ExchCode = 'MXQ' WHERE SecCode = 3273584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 3276419 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3276432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792256326, ExchCode = 'MUN' WHERE SecCode = 3282366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626019590, Ticker = 'BORRo', ExchCode = 'BTE', PermQuoteRetireDate = '2024-12-31' WHERE SecCode = 3283870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602981084, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 3283966 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3296408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606316234, ExchCode = 'DEU' WHERE SecCode = 3301693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487242, ExchCode = 'FRA' WHERE SecCode = 3304225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782726136, ExchCode = 'AQX' WHERE SecCode = 3304228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639800655, PermQuoteStatus = 'DC', Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552260, ExchCode = 'LAS' WHERE SecCode = 3307824 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3308578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658651750, ExchCode = 'TDG' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 3315890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609269032, ExchCode = 'DEU' WHERE SecCode = 3317854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885786, ExchCode = 'TDG' WHERE SecCode = 3317857 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 3318353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610381430, ExchCode = 'DEU', PermQuoteRetireDate = '2022-12-02', PermSecMapEndDate = '2022-12-02' WHERE SecCode = 3318355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827328140, ExchCode = 'FRA' WHERE SecCode = 3318810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3322819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598732, ExchCode = 'DEU' WHERE SecCode = 3342863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669874, ExchCode = 'MUN' WHERE SecCode = 3346903 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3350464 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3350590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614671400, ExchCode = 'DEU' WHERE SecCode = 3357942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615498721, ExchCode = 'FRA' WHERE SecCode = 3363519 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3366961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783783668, ExchCode = 'QTX' WHERE SecCode = 3367998 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3374430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631611214, ExchCode = 'TDG' WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617889189, ExchCode = 'AUX' WHERE SecCode = 3378309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381342, ExchCode = 'LAS' WHERE SecCode = 3378316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461403, Ticker = '0Q1Fl', ExchCode = 'BCO' WHERE SecCode = 3378492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765833817, PermQuoteStatus = 'AC', Ticker = '19U', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761306157, ExchCode = 'FRA' WHERE SecCode = 3386777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622425444, PermQuoteStatus = 'AC', Ticker = 'C5B0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 3392097 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 3395685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624238995, ExchCode = 'TDG' WHERE SecCode = 3396912 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3396930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641222426, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31', PermSecMapEndDate = NULL WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622936, ExchCode = 'FRA' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3402702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131277274, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3404342 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3406836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628602986, Ticker = 'DTS', ExchCode = 'MUN', PermQuoteRetireDate = '2020-10-02' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397561, ExchCode = 'FRA' WHERE SecCode = 3409182 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 3409377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884570, ExchCode = 'MUN' WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644441070, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2025-05-02' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802788, Ticker = 'PU9D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 3429985 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3431616 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3432019 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432509 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL WHERE SecCode = 3432634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633620996, Ticker = '0R2J', ExchCode = 'LSE' WHERE SecCode = 3432940 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3433365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640834967, ExchCode = 'FRA' WHERE SecCode = 3434745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679819, ExchCode = 'BIV' WHERE SecCode = 3434746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863509781, ExchCode = 'MUN' WHERE SecCode = 3436708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758527230, ExchCode = 'MUN' WHERE SecCode = 3436709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640560144, ExchCode = 'DEU' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644992133, Ticker = 'CASl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3446120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21925498341, ExchCode = 'STU' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647042623, ExchCode = 'FRA' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647042502, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647200544, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647152171, ExchCode = 'FRA' WHERE SecCode = 3490823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647142964, ExchCode = 'DEU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647200545, ExchCode = 'FRA' WHERE SecCode = 3490825 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3497955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784910654, Ticker = 'NOKIAk', ExchCode = 'BCO' WHERE SecCode = 3504673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775635085, ExchCode = 'DEU' WHERE SecCode = 3509155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3522158 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3526140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652953801, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3532701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350928, ExchCode = 'FRA' WHERE SecCode = 3532727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720015426, ExchCode = 'FRA' WHERE SecCode = 3533827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654291678, ExchCode = 'FRA' WHERE SecCode = 3534921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590215, ExchCode = 'FRA' WHERE SecCode = 3535859 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3536039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766656811, ExchCode = 'BER' WHERE SecCode = 3539022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350836, ExchCode = 'DEU' WHERE SecCode = 3543305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680887156, ExchCode = 'MUN' WHERE SecCode = 3545291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951331, ExchCode = 'CHI' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288448, ExchCode = 'GTX' WHERE SecCode = 3555035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656056664, ExchCode = 'FRA' WHERE SecCode = 3555038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681761612, ExchCode = 'DEU' WHERE SecCode = 3569619 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3571379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21657694230, ExchCode = 'BIV' WHERE SecCode = 3573698 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3588041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667846371, ExchCode = 'FRA' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 3593745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 3615201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202587, ExchCode = 'MUN' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3634457 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3644638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674884786, ExchCode = 'FRA' WHERE SecCode = 3694159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100413, ExchCode = 'QTX' WHERE SecCode = 3703405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3775362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520379, ExchCode = 'FRA' WHERE SecCode = 3784710 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3791521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687527440, ExchCode = 'STU' WHERE SecCode = 3791543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806182117, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-30' WHERE SecCode = 3792582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376097, ExchCode = 'MEX' WHERE SecCode = 3799556 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 3809957 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 3817741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3831351 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3835747 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3837276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373317, ExchCode = 'MEX' WHERE SecCode = 3843165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371514, ExchCode = 'BIV' WHERE SecCode = 3849233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3858016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696520891, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3858132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697447373, ExchCode = 'TDG' WHERE SecCode = 3862230 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 3863409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702680664, ExchCode = 'FRA' WHERE SecCode = 3879165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850700514, ExchCode = 'STU' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650208, ExchCode = 'DUS' WHERE SecCode = 3888265 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 3896278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704921848, ExchCode = 'DEU' WHERE SecCode = 3906532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706871202, ExchCode = 'BER' WHERE SecCode = 3921293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706614756, ExchCode = 'FRA' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 3948975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711478411, ExchCode = 'DEU' WHERE SecCode = 3956835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713324971, Ticker = '1OD', ExchCode = 'MUN', PermQuoteRetireDate = '2024-07-02' WHERE SecCode = 3965202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924367776, ExchCode = 'MUN' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3997063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719060177, ExchCode = 'STU' WHERE SecCode = 4001204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757864209, ExchCode = 'DEU' WHERE SecCode = 4018119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026863, Ticker = '1ADE', ExchCode = 'MIL' WHERE SecCode = 4031783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4032045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026962, Ticker = '1PM' WHERE SecCode = 4032067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723974167, ExchCode = 'FRA', PermQuoteRetireDate = '2025-03-26' WHERE SecCode = 4034218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724715991, ExchCode = 'TDG' WHERE SecCode = 4038748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725610718, ExchCode = 'DEU' WHERE SecCode = 4043316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729105249, ExchCode = 'STU', PermQuoteRetireDate = '2020-01-20', PermSecMapEndDate = '2020-01-20' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738253265, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 4090028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780356688, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2024-09-21' WHERE SecCode = 4101126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735310153, Ticker = '7M40', ExchCode = 'STU', PermQuoteRetireDate = '2024-02-02' WHERE SecCode = 4103711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304629, ExchCode = 'DEU' WHERE SecCode = 4110883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744442992, ExchCode = 'TDG' WHERE SecCode = 4193439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351143, ExchCode = 'MEX' WHERE SecCode = 4195318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745360055, ExchCode = 'DEU' WHERE SecCode = 4195339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354881, ExchCode = 'BIV' WHERE SecCode = 4211745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351014, ExchCode = 'BIV' WHERE SecCode = 4211785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, PermQuoteStatus = 'DC', Ticker = '4U1', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = '2025-04-01' WHERE SecCode = 4212367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350451, ExchCode = 'BIV' WHERE SecCode = 4212368 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4219597 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4262434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4275426 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4286247 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4286320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863835542, ExchCode = 'MUN' WHERE SecCode = 4291629 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931482979, ExchCode = 'MUN' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792091537, ExchCode = 'BER' WHERE SecCode = 4310575 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4312033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342160, ExchCode = 'MEX' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803438809, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888021179, ExchCode = 'GTX' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782629845, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-03', PermSecMapEndDate = NULL WHERE SecCode = 4348280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784368317, ExchCode = 'MUN' WHERE SecCode = 4348282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768485393, ExchCode = 'FRA' WHERE SecCode = 4351435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769271150, ExchCode = 'DEU' WHERE SecCode = 4355923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770634972, ExchCode = 'BER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4376007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778893562, ExchCode = 'FRA', PermQuoteRetireDate = '2020-11-17' WHERE SecCode = 4400157 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4402242 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4410617 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4419247 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4419248 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4419249 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4419254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, ExchCode = 'BER' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4426956 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 4429545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715481, ExchCode = 'MUN' WHERE SecCode = 4436993 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4438375 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4442086 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4443955 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4443956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783749210, ExchCode = 'QTX' WHERE SecCode = 4449676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306258, ExchCode = 'BIV' WHERE SecCode = 4456073 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21788257886.0, IsPrimaryQuote = 1 WHERE SecCode = 4459229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789568603, ExchCode = 'DEU' WHERE SecCode = 4463053 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ORTIN' WHERE SecCode = 4471741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796082418, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2021-10-13' WHERE SecCode = 4487640 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 4491916 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494204 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494205 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494206 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494207 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494208 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494209 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494210 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494231 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494232 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494233 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494234 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809367, ExchCode = 'DUS' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820703, ExchCode = 'DEU' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4499156 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4500461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409276, ExchCode = 'DEU' WHERE SecCode = 4505803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727409, ExchCode = 'DEU' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066759, ExchCode = 'DEU' WHERE SecCode = 4517641 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4517648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799910326, ExchCode = 'DEU' WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'UDE' WHERE SecCode = 4519547 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4523023 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4524579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430441, ExchCode = 'DEU' WHERE SecCode = 4526142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430439, ExchCode = 'DEU' WHERE SecCode = 4526148 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4527884 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4531983 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4536362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804415050, ExchCode = 'MUN' WHERE SecCode = 4539323 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4548020 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 4550727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 4550805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811337148, ExchCode = 'STU' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385286, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-10', PermSecMapEndDate = NULL WHERE SecCode = 4568425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777449320, ExchCode = 'TDG' WHERE SecCode = 4568460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809547031, ExchCode = 'DEU' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 4579630 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4586555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812338173, ExchCode = 'MUN', PermQuoteRetireDate = '2023-08-09' WHERE SecCode = 4588258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395163, ExchCode = 'FRA' WHERE SecCode = 4593306 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4593314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4603543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815952112, ExchCode = 'FRA' WHERE SecCode = 4607713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387236, ExchCode = 'LAS' WHERE SecCode = 4609996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816477347, ExchCode = 'MUN' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 4611019 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4616837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863900, ExchCode = 'BCO' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4630675 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4630676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820739202, ExchCode = 'DEU' WHERE SecCode = 4631954 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4632082 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4634305 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4635265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100069, ExchCode = 'FRA' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4640253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228224, PermInstrStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824693646, ExchCode = 'BER' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WDCN3' WHERE SecCode = 4655483 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4655498 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4658860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831917747, ExchCode = 'FRA' WHERE SecCode = 4677594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4702642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4716084 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 4724704 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'B40' WHERE SecCode = 4730067 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4738022 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4746935 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4751021 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4751055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854895784, ExchCode = 'FRA' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30' WHERE SecCode = 4771748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789996081, ExchCode = 'LAS' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4792252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334827, ExchCode = 'DEU' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615485, ExchCode = 'STU' WHERE SecCode = 4800489 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4804556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618957147, ExchCode = 'FRA', PermQuoteRetireDate = '2023-05-12' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4808877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823813, Ticker = 'KWE3l', ExchCode = 'AQX' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904412215, ExchCode = 'GTX' WHERE SecCode = 4810002 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ESTM' WHERE SecCode = 4811102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860858404, ExchCode = 'DEU' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4813556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4819878 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 4821625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536811, ExchCode = 'STU' WHERE SecCode = 4827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521115, ExchCode = 'MUN' WHERE SecCode = 4827933 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 4829213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861142799, ExchCode = 'FRA' WHERE SecCode = 4829216 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 4834788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398298, ExchCode = 'GER', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953971, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-17' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580736, ExchCode = 'GER' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487241, ExchCode = 'FRA' WHERE SecCode = 4845067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4854813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872586664, ExchCode = 'DEU' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4895650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204873, ExchCode = 'BIV' WHERE SecCode = 4911170 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4914393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515354, ExchCode = 'GTX' WHERE SecCode = 4918607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21880159462, ExchCode = 'DUS' WHERE SecCode = 4925631 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4940671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883505268, ExchCode = 'DUS' WHERE SecCode = 4946223 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919010696, ExchCode = 'MUN' WHERE SecCode = 4950865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200981, ExchCode = 'MEX' WHERE SecCode = 4956738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727205509, ExchCode = 'BIV' WHERE SecCode = 4962789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888276703, ExchCode = 'GTX' WHERE SecCode = 4972276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894951764, ExchCode = 'DUS' WHERE SecCode = 4991558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580261, ExchCode = 'GER' WHERE SecCode = 4991678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891752426, ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-09' WHERE SecCode = 4991682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321224, ExchCode = 'MUN' WHERE SecCode = 5004799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894542420, ExchCode = 'DEU' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902367523, ExchCode = 'MUN' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5045190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380636, ExchCode = 'LAS' WHERE SecCode = 5047099 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5054835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5072231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777910905, ExchCode = 'GTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5104499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193105, ExchCode = 'MEX' WHERE SecCode = 5107678 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5123686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292297, ExchCode = 'FRA' WHERE SecCode = 5129708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292306, ExchCode = 'GER' WHERE SecCode = 5129738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535489, ExchCode = 'FRA' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917841797, ExchCode = 'FRA' WHERE SecCode = 5152350 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5161308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5161416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727196906, ExchCode = 'BIV' WHERE SecCode = 5161445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921223663, ExchCode = 'STU' WHERE SecCode = 5166540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919946283, ExchCode = 'DEU' WHERE SecCode = 5166568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945897707, ExchCode = 'STU' WHERE SecCode = 5174430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922889048, ExchCode = 'DEU' WHERE SecCode = 5174469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778838011, ExchCode = 'DUS' WHERE SecCode = 5182664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5183026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 5189087 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5206259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890060456, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2024-12-26' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5214532 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5227168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5234116 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5236367 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5241415 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5245385 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5253649 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5258557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009369, ExchCode = 'AUX' WHERE SecCode = 5261340 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5262908 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5269453 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5274288 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5276211 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5277531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5281305 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5281349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5288842 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5290332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948484161, ExchCode = 'DUS' WHERE SecCode = 5292727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388892, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08' WHERE SecCode = 5299987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937480514, ExchCode = 'BER' WHERE SecCode = 5310445 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5316647 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5316694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732426, ExchCode = 'BIV' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580731, ExchCode = 'DEU' WHERE SecCode = 5349603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953951669, ExchCode = 'BER' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776504665, ExchCode = 'MEX' WHERE SecCode = 5354969 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5356151 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5357352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955560974, ExchCode = 'QTX' WHERE SecCode = 5360992 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 5363439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776104211, Ticker = 'ACAG', ExchCode = 'VIE' WHERE SecCode = 5372903 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5381819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581931, ExchCode = 'MEX' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5381930 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5383299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5391446 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5391531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777336250, ExchCode = 'FRA' WHERE SecCode = 5399892 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5403010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223518, ExchCode = 'FRA' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5427962 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5434325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078254, ExchCode = 'LAS' WHERE SecCode = 5443505 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5444000 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5447503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21974979681, ExchCode = 'QTX' WHERE SecCode = 5458313 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5460810 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5463054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299986, ExchCode = 'FRA' WHERE SecCode = 5468673 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5474601 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5478193 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5479477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778500349, ExchCode = 'BIV' WHERE SecCode = 5481081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778622371, ExchCode = 'BER' WHERE SecCode = 5490578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835792, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 5521949 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 5533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5541733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471184, ExchCode = 'BIV' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471180, ExchCode = 'MEX', PermOrgIPODate = NULL WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779690490, ExchCode = 'FRA' WHERE SecCode = 5558240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993737990, ExchCode = 'DEU' WHERE SecCode = 5558538 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 5561610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809860, ExchCode = 'FRA' WHERE SecCode = 5565485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982665105, ExchCode = 'MXQ' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522671160, PermQuoteStatus = 'AC', Ticker = 'YE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5604433 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5610108 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5612375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5629234 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5631498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781224681, ExchCode = 'BER' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5631728 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5635862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637484538, ExchCode = 'DEU' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010677492, ExchCode = 'DEU' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476048637, PermQuoteStatus = 'AC', Ticker = 'N8I', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449511, Ticker = 'TS2Sl', ExchCode = 'BCO' WHERE SecCode = 5638844 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096827291, IncCntry = 'USA', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2022-04-07' WHERE SecCode = 5648490 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5656152 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5656153 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5656154 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5656155 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5656156 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5656157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781757046, ExchCode = 'FRA' WHERE SecCode = 5674580 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5677544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858187, ExchCode = 'FRA' WHERE SecCode = 5679100 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5679588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020600429, ExchCode = 'DEU' WHERE SecCode = 5687957 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5691181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100058, PermQuoteStatus = 'AC', Ticker = 'ZK7', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 5697992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781981056, ExchCode = 'BIV' WHERE SecCode = 5701235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22024905296, Ticker = 'VPCU', ExchCode = 'LSE' WHERE SecCode = 5702903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381254, ExchCode = 'QTX' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782605903, ExchCode = 'TDG' WHERE SecCode = 5753987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22033320189, ExchCode = 'GTX' WHERE SecCode = 5754012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783009907, ExchCode = 'STU' WHERE SecCode = 5758113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812186220, ExchCode = 'FRA' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22035457659, ExchCode = 'DEU' WHERE SecCode = 5765005 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5772358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783190501, ExchCode = 'MEX' WHERE SecCode = 5772576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783327713, ExchCode = 'GTX' WHERE SecCode = 5782814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040671244, ExchCode = 'MUN' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037191743, ExchCode = 'BER' WHERE SecCode = 5785810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116802953, ExchCode = 'FRA' WHERE SecCode = 5785811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783330017, ExchCode = 'FRA' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329733, ExchCode = 'FRA' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353647, ExchCode = 'FRA' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353632, ExchCode = 'FRA' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353639, ExchCode = 'FRA' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783309192, ExchCode = 'BIV' WHERE SecCode = 5801442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783964354, ExchCode = 'STU' WHERE SecCode = 5807637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386901, ExchCode = 'LAS' WHERE SecCode = 5807638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783963974, ExchCode = 'STU' WHERE SecCode = 5807639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784085574, ExchCode = 'TDG' WHERE SecCode = 5808179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22041685187, ExchCode = 'DEU' WHERE SecCode = 5808180 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 5816808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784438281, ExchCode = 'STU' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22050601762, ExchCode = 'MXQ' WHERE SecCode = 5870874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534037, ExchCode = 'FRA' WHERE SecCode = 5890417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786584011, ExchCode = 'STU' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5911931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787449425, ExchCode = 'SIG' WHERE SecCode = 5972437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6012791 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2024-10-18' WHERE SecCode = 6018397 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2024-12-20' WHERE SecCode = 6048000 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 6092925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682858978, ExchCode = 'FRA' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV', PermOrgIPODate = NULL WHERE SecCode = 6097383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171968, ExchCode = 'BIV' WHERE SecCode = 6097384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085290988, ExchCode = 'MXQ' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727345443, ExchCode = 'BIV' WHERE SecCode = 6097390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 6097546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22026330416, ExchCode = 'MXQ' WHERE SecCode = 6097558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, Ticker = '3OISl', ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521439, ExchCode = 'TDG' WHERE SecCode = 6112333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902797, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30', PermSecMapEndDate = '2025-01-30' WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791216534, ExchCode = 'FRA' WHERE SecCode = 6186428 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6190695 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 6196025 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6201045 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6201046 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6211075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909392, ExchCode = 'FRA' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 6258199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792142922, ExchCode = 'FRA' WHERE SecCode = 6258508 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 6263912 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6264135 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6264181 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 6302010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6378722 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6378723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121552149, ExchCode = 'DEU' WHERE SecCode = 6407334 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6411859 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6416433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6422988 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6429307 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6429308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795013278, ExchCode = 'FRA' WHERE SecCode = 6431549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6440008 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-10-02' WHERE SecCode = 6441634 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6441853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22131299417.0, IsPrimaryQuote = 1 WHERE SecCode = 6443422 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6448319 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6449023 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6449334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438804, ExchCode = 'TDG' WHERE SecCode = 6450885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795754736, ExchCode = 'FRA' WHERE SecCode = 6450941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438836, ExchCode = 'STU' WHERE SecCode = 6451088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795802495, ExchCode = 'QTX' WHERE SecCode = 6453946 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 6456244 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6457846 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 6457996 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6460615 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 6460616 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6460626 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6460627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128769340, ExchCode = 'DEU' WHERE SecCode = 6462856 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6464963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184668, ExchCode = 'FRA' WHERE SecCode = 6464987 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6467510 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6467519 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6467527 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-25', PermSecMapEndDate = NULL WHERE SecCode = 6467530 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 6469299 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6469317 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6469318 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6469319 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 6472010 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-25' WHERE SecCode = 6472014 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6472017 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6472018 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6472021 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6472022 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951779.0, PermOrgIPODate = '2025-09-26' WHERE SecCode = 6472088 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796404842.0 WHERE SecCode = 6474420 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6474558 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6474622 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6474623 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-29' WHERE SecCode = 6476446 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-29' WHERE SecCode = 6476449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796405777, ValQuotePermID = 236796404842.0, ExchCode = 'GTX' WHERE SecCode = 6478318 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0, PermOrgIPODate = '2025-09-30' WHERE SecCode = 6478380 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796466991.0, IsPrimaryQuote = 1 WHERE SecCode = 6480217 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796466609.0, IsPrimaryQuote = 1 WHERE SecCode = 6480218 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6480248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438835, ExchCode = 'ASX' WHERE SecCode = 6480251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438808, ExchCode = 'TDG' WHERE SecCode = 6480271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131538896, ExchCode = 'DEU' WHERE SecCode = 6480272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796439130, ExchCode = 'MEX' WHERE SecCode = 6480273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438942, ExchCode = 'TDG' WHERE SecCode = 6480274 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 10811170 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10906505 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 10913779 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10920501 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 10922960 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10965482 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 10965490 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 10966609 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11001800 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11002228 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11009046 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11009381 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11015634 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11025091 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11033942 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11047378 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11051207 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11056359 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11057985 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11059176 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'RMXFF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-01', PermSecMapEndDate = NULL WHERE SecCode = 11061958 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11062344 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'AMUIF' WHERE SecCode = 11063828 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11068733 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11102277 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11105949 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11108135 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11134982 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11136830 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 11138678 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'LNAI' WHERE SecCode = 11142344 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'IMI' WHERE SecCode = 11149536 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11150419 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11150427 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PRHI' WHERE SecCode = 11151122 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11152639 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11152648 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11158291 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11158402 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 11162745 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11169421 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'HLYK' WHERE SecCode = 11172213 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'CMHDF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-01', PermSecMapEndDate = NULL WHERE SecCode = 11174367 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02' WHERE SecCode = 11184890 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11188391 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11189762 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11191438 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951929.0, PermSecMapEndDate = NULL WHERE SecCode = 11194108 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11196861 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11202310 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'TOR' WHERE SecCode = 11202685 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11211846 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11213869 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11213964 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11214225 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11214899 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11214936 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 11215120 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11216054 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 11216608 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AYFIF', PermQuoteRetireDate = NULL WHERE SecCode = 11216856 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11217416 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11217809 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11219738 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11225118 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11225542 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11226120 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11226158 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11227627 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11227879 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11232072 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11232238 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2023-11-22' WHERE SecCode = 11232941 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AVMLF', PermQuoteRetireDate = NULL WHERE SecCode = 11233270 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL, PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11240747 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11241414 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11241585 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5096827291, IncCntry = 'USA', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2022-04-07' WHERE SecCode = 11242359 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11244761 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11245695 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727172565, PriTrdQuotePermID = NULL, Ticker = 'DMYYU', ExchCode = 'PNK' WHERE SecCode = 11246265 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727169310, PriTrdQuotePermID = NULL, ExchCode = 'PNK' WHERE SecCode = 11247542 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5096765318, OrgTypeCode = 'UNK', DomCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11248397 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11249579 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'AQLS' WHERE SecCode = 11249737 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5096839985, IncCntry = 'USA', PriTRBCIndPermID = 1004365444.0, PermOrgIPODate = '2023-04-21' WHERE SecCode = 11252317 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5096839985, IncCntry = 'USA', PriTRBCIndPermID = 1004365444.0, PermOrgIPODate = '2023-04-21' WHERE SecCode = 11253494 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11256248 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PRHIZ', QuoteClass = 'SENIOR', InstrClass = 'SENIOR' WHERE SecCode = 11256281 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11257617 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11258408 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11259265 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PriTRBCIndPermID = 4294951430.0, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11260920 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11262266 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11267719 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 11269314 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11269762 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11270088 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2024-10-18' WHERE SecCode = 11270656 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'UCFI', ExchCode = 'NAS', PriTRBCIndPermID = 4294951430.0 WHERE SecCode = 11274801 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PriTRBCIndPermID = 4294951430.0, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11274949 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'MXXNF' WHERE SecCode = 11275722 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276844 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276871 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276874 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276875 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276924 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276928 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276933 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11276991 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11277168 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280126 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280128 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280129 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280130 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280131 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280132 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280210 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280211 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280212 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280214 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280217 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280218 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280220 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280222 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280223 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280224 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280225 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280269 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280271 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280273 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280274 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PASW' WHERE SecCode = 11280999 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232887386361.0, IsPrimaryInstr = 0 WHERE SecCode = 11281417 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232894674548.0 WHERE SecCode = 11281954 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232896430265.0 WHERE SecCode = 11282047 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232885336450.0 WHERE SecCode = 11282049 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11284221 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232898803122.0, IsPrimaryInstr = 0 WHERE SecCode = 11284441 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 11285120 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796441138, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11285376 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796441203, PriTrdQuotePermID = 236796441203.0, Ticker = 'RITM PR E', ExchCode = 'NYS', PermSecMapStartDate = '2025-09-30' WHERE SecCode = 11285480 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11285716 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11285769 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = '2025-09-25' WHERE SecCode = 11285809 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11285914 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11285986 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796441172, PriTrdQuotePermID = 236796441172.0, ValQuotePermID = 25727059775.0, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11286102 AND Type_ = 1;
