UPDATE data_universe_permid SET QuotePermID = 21633621299, Ticker = '0OAL', ExchCode = 'LSE' WHERE SecCode = 323 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 PermOrgIPODate = NULL WHERE SecCode = 7493 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 9451 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 17729 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 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 QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 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 = 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 = 55837366078, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35746 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', 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 PermOrgIPODate = NULL WHERE SecCode = 43286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838502175, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474843390, ExchCode = 'DEU' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 49034 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836523121, ExchCode = 'FRA' WHERE SecCode = 52842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298120, ExchCode = 'GTX' WHERE SecCode = 53702 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 54829 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 55088 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 56011 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667485853, ExchCode = 'QTX' WHERE SecCode = 56532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477785253, ExchCode = 'TDG' WHERE SecCode = 57399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541076135, ExchCode = 'FRA' WHERE SecCode = 57437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480783964, ExchCode = 'STU', PermQuoteRetireDate = '2014-12-08' WHERE SecCode = 57439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475610723, Ticker = 'TSW', ExchCode = 'MUN', PermQuoteRetireDate = '2008-02-18' WHERE SecCode = 57453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329985, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 57474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488059, ExchCode = 'QTX' WHERE SecCode = 57475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512040094, ExchCode = 'TDG' WHERE SecCode = 57520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475514359, Ticker = 'BTBA.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 59414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356389, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60190 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 = 21474884530, ExchCode = 'DEU', PermQuoteRetireDate = '2024-01-05', PermSecMapEndDate = '2024-01-05' WHERE SecCode = 60526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492943, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 60564 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 = 21910168159, ExchCode = 'TDG' WHERE SecCode = 60683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339538, ExchCode = 'BER' WHERE SecCode = 60831 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 = 21475569932, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 61651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051162, ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-25' WHERE SecCode = 61749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867727417, PermQuoteRetireDate = '2025-03-04' WHERE SecCode = 62125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474870462, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2012-03-08' WHERE SecCode = 62561 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 PermOrgIPODate = NULL WHERE SecCode = 63995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328758, ExchCode = 'BER' WHERE SecCode = 64435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475583420, ExchCode = 'GER', PermQuoteRetireDate = '2008-07-07' WHERE SecCode = 65172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474894114, ExchCode = 'DEU' WHERE SecCode = 65308 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 68614 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 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 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 PermOrgIPODate = NULL WHERE SecCode = 80738 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21483761938, ExchCode = 'CHA' WHERE SecCode = 80783 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 81567 AND Type_ = 10;
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 PermOrgIPODate = NULL WHERE SecCode = 83481 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', 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 PermOrgIPODate = NULL WHERE SecCode = 86086 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87347 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 PermOrgIPODate = NULL WHERE SecCode = 94005 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 95444 AND Type_ = 10;
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 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 = 4294951405.0 WHERE SecCode = 105003 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' 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 = 21821641631, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241914, ExchCode = 'MUN' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589493827, ExchCode = 'STU' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295813, ExchCode = 'GTX' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390726, ExchCode = 'DEU' WHERE SecCode = 112049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334705, ExchCode = 'BER' WHERE SecCode = 112064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661189712, ExchCode = 'DEU' WHERE SecCode = 112078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786286858, ExchCode = 'QTX' WHERE SecCode = 112079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750431812, ExchCode = 'MUN' WHERE SecCode = 112129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557034633, ExchCode = 'FRA' WHERE SecCode = 112135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179805, ExchCode = 'FRA' WHERE SecCode = 112143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085576, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853681433, ExchCode = 'FRA', PermQuoteRetireDate = '2018-03-01' WHERE SecCode = 112633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546270799, ExchCode = 'MUN' WHERE SecCode = 112657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387792, ExchCode = 'LAS' WHERE SecCode = 112665 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 QuotePermID = 21830308508, ExchCode = 'GTX' WHERE SecCode = 113809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002576, ExchCode = 'FRA' WHERE SecCode = 113864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273562, ExchCode = 'GTX' WHERE SecCode = 114028 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 114433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754472, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 116327 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 QuotePermID = 21474967821, Ticker = 'GJR', ExchCode = 'STU', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 123262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644782383, ExchCode = 'FRA' WHERE SecCode = 124828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525792698, ExchCode = 'DEU' WHERE SecCode = 131777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957798876, ExchCode = 'DEU' WHERE SecCode = 131976 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 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 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 QuotePermID = 21554252789, PermQuoteRetireDate = '2015-01-09' WHERE SecCode = 143248 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 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 QuotePermID = 21522633023, ExchCode = 'MUN' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514316877, ExchCode = 'STU' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 177671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593612748, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284975, ExchCode = 'GTX' WHERE SecCode = 178350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380371, ExchCode = 'LAS' WHERE SecCode = 178391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650181, ExchCode = 'DUS' WHERE SecCode = 179171 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 180517 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 197200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 210189 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 249282 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 DomCntry = 'USA' WHERE SecCode = 286286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, ExchCode = 'FRA' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373346, ExchCode = 'DEU' WHERE SecCode = 290846 AND Type_ = 10;
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 PermOrgIPODate = NULL WHERE SecCode = 304979 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836320461, ExchCode = 'BER', PermQuoteRetireDate = '2017-10-03' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 317618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531772020, ExchCode = 'STU' WHERE SecCode = 319526 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 321821 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 326895 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796405819, InstrPermID = 21498107911, ValQuotePermID = 236795665850.0, IsPrimaryInstr = 1, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '8BZ', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 328509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320592, ExchCode = 'BER' WHERE SecCode = 329370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419277, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 329388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479301, ExchCode = 'QTX' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950784269, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 330668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475510397, PermQuoteStatus = 'DC', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 335172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 341242 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 DomCntry = 'USA' WHERE SecCode = 367386 AND Type_ = 1;
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 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 QuotePermID = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 520275 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 534958 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 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 QuotePermID = 21910180831, ExchCode = 'FRA' WHERE SecCode = 587892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859812767, Ticker = 'SVV', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 637382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 703142 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 770039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475065837, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 780725 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 793380 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 PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 873492 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 = 21745958575, ExchCode = 'FRA' WHERE SecCode = 1447807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480912846, ExchCode = 'DEU' WHERE SecCode = 1447851 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 QuotePermID = 21482228292, Ticker = 'BLIT', ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535814877, Ticker = 'JPRL.GB', ExchCode = 'ISD' WHERE SecCode = 1461500 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 1472778 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-30' WHERE SecCode = 1472965 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 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 = 21513239137, Ticker = 'BO4', ExchCode = 'DEU' WHERE SecCode = 1740287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 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' 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 = 2227874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370630, ExchCode = 'SGO' WHERE SecCode = 2272715 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 2286304 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2298762 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2315212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 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 = 21532119904, ExchCode = 'DEU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534035790, ExchCode = 'BCO', PermQuoteRetireDate = '2021-12-07' WHERE SecCode = 2441640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955921, ExchCode = 'TDG', PermQuoteRetireDate = '2018-01-23', PermSecMapEndDate = '2018-01-23' WHERE SecCode = 2452490 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 QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536758187, ExchCode = 'DEU' WHERE SecCode = 2490811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535535779, ExchCode = 'BTE', PermQuoteRetireDate = '2014-01-28' WHERE SecCode = 2494242 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2495686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430820, ExchCode = 'DEU' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 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 QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696140082, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379929, ExchCode = 'FRA' WHERE SecCode = 2531802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 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 QuotePermID = 21540108935, ExchCode = 'STU' WHERE SecCode = 2544431 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2545795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792941383, ExchCode = 'DEU' WHERE SecCode = 2591696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067641975, ExchCode = 'CHI' WHERE SecCode = 2600378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545105822, ExchCode = 'FRA' WHERE SecCode = 2604390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374749, ExchCode = 'DEU' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2630115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547450530, ExchCode = 'BER' WHERE SecCode = 2636990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779391120, ExchCode = 'GTX' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548045877, ExchCode = 'DEU' WHERE SecCode = 2642451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534619, ExchCode = 'QTX' WHERE SecCode = 2642453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538237, ExchCode = 'GTX' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478457, ExchCode = 'QTX' WHERE SecCode = 2642458 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 QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 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 QuotePermID = 21725178081, Ticker = '1FPB', ExchCode = 'BER', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 2664122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549921078, ExchCode = 'BTE' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2679880 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 2693648 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 2696739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551920812, ExchCode = 'MUN' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119337, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 2700711 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 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 = 21630041766, ExchCode = 'TDG' WHERE SecCode = 2720693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784881963, ExchCode = 'QTX' WHERE SecCode = 2747510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533308745, ExchCode = 'FRA' WHERE SecCode = 2747656 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 = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367198, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598947, ExchCode = 'STU' WHERE SecCode = 2796968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589784, ExchCode = 'DEU' WHERE SecCode = 2810887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557265431, ExchCode = 'DEU' WHERE SecCode = 2810889 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 = 236784387968, ExchCode = 'LAS' WHERE SecCode = 2821450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274949, ExchCode = 'GTX' WHERE SecCode = 2855817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955946, ExchCode = 'TDG' WHERE SecCode = 2856999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603343761, ExchCode = 'TDG' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 2864442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732998267, ExchCode = 'QTX' WHERE SecCode = 2872658 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 = 21619609060, ExchCode = 'MUN' WHERE SecCode = 2887282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562944695, ExchCode = 'DEU' WHERE SecCode = 2887317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564309877, ExchCode = 'FRA' WHERE SecCode = 2902752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943057400, ExchCode = 'STU' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564888920, ExchCode = 'FRA' WHERE SecCode = 2909921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779358960, ExchCode = 'GTX' WHERE SecCode = 2909922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565404048, ExchCode = 'FRA' WHERE SecCode = 2912969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890828, Ticker = 'VZLBd', ExchCode = 'AQX' WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2925389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568560697, ExchCode = 'FRA' WHERE SecCode = 2929653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211564, Ticker = '34LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-21', PermSecMapEndDate = NULL WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672243657, PermQuoteStatus = 'DC', Ticker = '16IE', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2935960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953914119, ExchCode = 'GTX' WHERE SecCode = 2935971 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 QuotePermID = 21565562433, ExchCode = 'SGO' WHERE SecCode = 2936007 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2939975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856730657, ExchCode = 'STU' WHERE SecCode = 2944415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704188, ExchCode = 'MXQ' WHERE SecCode = 2944451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762568152, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891239, ExchCode = 'STU' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641460082, ExchCode = 'BER' WHERE SecCode = 2958533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726926, ExchCode = 'MUN' WHERE SecCode = 2975172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488199, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895439, ExchCode = 'STU' WHERE SecCode = 3008027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513500, ExchCode = 'DEU' WHERE SecCode = 3015987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286312, ExchCode = 'GTX' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576625962, ExchCode = 'FRA' WHERE SecCode = 3026615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260230, ExchCode = 'FRA' WHERE SecCode = 3030075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576576313, PermQuoteStatus = 'DC', Ticker = 'IWI', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603201534, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-04', PermSecMapEndDate = NULL WHERE SecCode = 3033923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740543, ExchCode = 'LAS' WHERE SecCode = 3038477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822880896, ExchCode = 'DUS' WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578813192, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788253479, ExchCode = 'BIV' WHERE SecCode = 3060652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611487587, ExchCode = 'FRA' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991744, ExchCode = 'DEU' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700996629, ExchCode = 'BER' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580910339, ExchCode = 'DEU' WHERE SecCode = 3090322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779496553, ExchCode = 'GTX' WHERE SecCode = 3120784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3128125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704364, Ticker = 'BRSS*', ExchCode = 'MXQ' WHERE SecCode = 3130990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535987, ExchCode = 'QTX' WHERE SecCode = 3145983 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 = 21589578727, ExchCode = 'STU' WHERE SecCode = 3162853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296679, ExchCode = 'GTX' WHERE SecCode = 3172332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011949508, ExchCode = 'AQX' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589591762, ExchCode = 'FRA' WHERE SecCode = 3195464 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3196346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758877, ExchCode = 'SIG' WHERE SecCode = 3197040 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3198784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608121110, ExchCode = 'TDG', PermQuoteRetireDate = '2017-07-14' WHERE SecCode = 3201372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3211361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926812, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-08', PermSecMapEndDate = '2023-06-08' WHERE SecCode = 3213267 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3213375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592182710, ExchCode = 'FRA' WHERE SecCode = 3215568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641516, ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 3219383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21868288662, ExchCode = 'BER' WHERE SecCode = 3222984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066780, ExchCode = 'DEU' WHERE SecCode = 3223419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386946, ExchCode = 'LAS' WHERE SecCode = 3230847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598163107, ExchCode = 'STU' WHERE SecCode = 3236427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3244966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595700790, ExchCode = 'TDG' WHERE SecCode = 3247292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348456, ExchCode = 'DUS' WHERE SecCode = 3247427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779584053, ExchCode = 'GTX' WHERE SecCode = 3247560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597660312, ExchCode = 'AUX' WHERE SecCode = 3256336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882266791, ExchCode = 'HAN' WHERE SecCode = 3269645 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', 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 = 21858452378, ExchCode = 'BER', PermQuoteRetireDate = '2023-02-23' WHERE SecCode = 3280089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792256326, ExchCode = 'MUN' WHERE SecCode = 3282366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755977768, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3282701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604346350, ExchCode = 'BER', PermQuoteRetireDate = '2022-01-06' WHERE SecCode = 3283289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624943992, ExchCode = 'FRA' WHERE SecCode = 3288205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 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 = 21606233655, PermQuoteStatus = 'AC', Ticker = 'SGLD', ExchCode = 'AEX', PermQuoteRetireDate = NULL WHERE SecCode = 3301728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606471109, ExchCode = 'DEU' WHERE SecCode = 3301863 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 = 21667482882, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 3305485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552260, ExchCode = 'LAS' WHERE SecCode = 3307824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 3315890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379972, ExchCode = 'FRA' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234907, ExchCode = 'BER' WHERE SecCode = 3317120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658809885, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3317174 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 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 = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722337, ExchCode = 'DEU' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387046, ExchCode = 'LAS' WHERE SecCode = 3322821 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 PermOrgIPODate = NULL WHERE SecCode = 3350464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631068545, Ticker = 'BIOSs', ExchCode = 'BCO', PermQuoteRetireDate = '2024-05-21' WHERE SecCode = 3350742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220383, ExchCode = 'STU' WHERE SecCode = 3352147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614671400, ExchCode = 'DEU' WHERE SecCode = 3357942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525598, ExchCode = 'FRA' WHERE SecCode = 3357972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615253063, ExchCode = 'TDG' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481714442, ExchCode = 'FRA' WHERE SecCode = 3358616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050504, ExchCode = 'FRA' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615498721, ExchCode = 'FRA' WHERE SecCode = 3363519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561787, ExchCode = 'GTX' WHERE SecCode = 3365684 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3366961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616206400, ExchCode = 'DEU' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783783668, ExchCode = 'QTX' WHERE SecCode = 3367998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744646634, PermQuoteStatus = 'AC', Ticker = '90S', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186397, ExchCode = 'DEU' WHERE SecCode = 3371968 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 = 21830301090, ExchCode = 'GTX' WHERE SecCode = 3379253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954032, ExchCode = 'STU' WHERE SecCode = 3379346 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 PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 3392097 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141211, ExchCode = 'SIG' WHERE SecCode = 3392282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544660, ExchCode = 'DUS' WHERE SecCode = 3396441 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 = 236790014898, ExchCode = 'BER' WHERE SecCode = 3401720 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 QuotePermID = 21667704620, ExchCode = 'MXQ' WHERE SecCode = 3404480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705003, ExchCode = 'MXQ' WHERE SecCode = 3404905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705412, ExchCode = 'MXQ' WHERE SecCode = 3404907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628935588, ExchCode = 'STU' WHERE SecCode = 3405606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818264981, ExchCode = 'FRA' WHERE SecCode = 3409089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890620, ExchCode = 'FRA' WHERE SecCode = 3409161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630052863, Ticker = 'CJC', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 3409167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388177, ExchCode = 'LAS' WHERE SecCode = 3409178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397561, ExchCode = 'FRA' WHERE SecCode = 3409182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240759, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-23', PermSecMapEndDate = NULL WHERE SecCode = 3409186 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 DomCntry = 'USA' WHERE SecCode = 3432019 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-30' 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 = 25727356606, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2020-04-21' WHERE SecCode = 3435592 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 = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 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 = 21652317413, ExchCode = 'TDG' WHERE SecCode = 3473357 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 QuotePermID = 236788075106, ExchCode = 'TDG' WHERE SecCode = 3490864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487113, ExchCode = 'CHI' WHERE SecCode = 3501235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749468782, ExchCode = 'FRA' WHERE SecCode = 3503523 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 = 236782100415, ExchCode = 'QTX' WHERE SecCode = 3509155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779955765, ExchCode = 'QTX' WHERE SecCode = 3523385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796817245, ExchCode = 'DEU' WHERE SecCode = 3525431 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3526140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344034, ExchCode = 'QTX' WHERE SecCode = 3529091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653736303, PermQuoteStatus = 'AC', ExchCode = 'TDG', 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 = 236781272952, ExchCode = 'DUS' WHERE SecCode = 3535855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 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 = 21776452965, PermQuoteStatus = 'AC', Ticker = '28S0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951331, ExchCode = 'CHI' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692715167, ExchCode = 'CHI' WHERE SecCode = 3551896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789697925, ExchCode = 'QTX' WHERE SecCode = 3555055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 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 QuotePermID = 21660609512, ExchCode = 'DEU' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731994491, ExchCode = 'FRA' WHERE SecCode = 3588110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872233, ExchCode = 'DEU' WHERE SecCode = 3588112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197226, ExchCode = 'DEU' WHERE SecCode = 3588113 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 = 21878957446, ExchCode = 'SIG', PermQuoteRetireDate = '2023-09-23' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059052, ExchCode = 'MUN' WHERE SecCode = 3603358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665422440, Ticker = 'NBPU', ExchCode = 'LSE' WHERE SecCode = 3616805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665885520, ExchCode = 'FRA' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642439, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-04-09' WHERE SecCode = 3619536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202587, ExchCode = 'MUN' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632710, ExchCode = 'FRA' WHERE SecCode = 3639274 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 = 21669469691, ExchCode = 'DEU' WHERE SecCode = 3648237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114251, ExchCode = 'FRA' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220426, ExchCode = 'TDG' WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712565, ExchCode = 'STU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296352, ExchCode = 'GTX' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376097, ExchCode = 'MEX' WHERE SecCode = 3799556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689566285, ExchCode = 'HAM' WHERE SecCode = 3807820 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 QuotePermID = 236781650229, ExchCode = 'DUS' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694479665, ExchCode = 'TDG' WHERE SecCode = 3830032 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 = 236789587917, ExchCode = 'LAS' WHERE SecCode = 3845904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371514, ExchCode = 'BIV' WHERE SecCode = 3849233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388260, ExchCode = 'LAS' WHERE SecCode = 3851567 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 PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 3863409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353726, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702680664, ExchCode = 'FRA' WHERE SecCode = 3879165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016561, ExchCode = 'MUN' WHERE SecCode = 3881153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' 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 QuotePermID = 21705375051, ExchCode = 'BER', PermQuoteRetireDate = '2024-06-24' WHERE SecCode = 3894967 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 = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2025-09-30' WHERE SecCode = 3948975 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3997063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819929880, ExchCode = 'DUS' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727361952, ExchCode = 'MEX' WHERE SecCode = 4001279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359395, ExchCode = 'SIG' WHERE SecCode = 4024795 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 = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026845, Ticker = '1GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327741, Ticker = '1BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026785, Ticker = '1NDX' WHERE SecCode = 4031953 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4032045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, ExchCode = 'BER' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788219439, ExchCode = 'BER' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779663, ExchCode = 'MUN' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763476024, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-06-11' WHERE SecCode = 4095970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 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 = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966716, ExchCode = 'FRA' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659890, ExchCode = 'BIV' WHERE SecCode = 4194640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963695, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 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 QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349093, ExchCode = 'MEX' WHERE SecCode = 4236034 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, ExchCode = 'DUS' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727345444, ExchCode = 'MEX' WHERE SecCode = 4282147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518785, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 4282397 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 = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 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 = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966496, ExchCode = 'DEU' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796439340, ExchCode = 'LAS' WHERE SecCode = 4333278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765297153, ExchCode = 'DEU' WHERE SecCode = 4335866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768726868, ExchCode = 'STU' WHERE SecCode = 4346650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' WHERE SecCode = 4346668 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 = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4376007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775812436, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-09' WHERE SecCode = 4385267 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 PermOrgIPODate = NULL WHERE SecCode = 4419254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, ExchCode = 'DUS' 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 QuotePermID = 236779047734, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785455473, ExchCode = 'DEU' WHERE SecCode = 4436993 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 = 21787027751, Ticker = '60P', ExchCode = 'STU' WHERE SecCode = 4444001 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 = 21793533769, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-24' WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689591, ExchCode = 'FRA' WHERE SecCode = 4474387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991627, ExchCode = 'FRA' WHERE SecCode = 4482374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794991035, ExchCode = 'DEU' WHERE SecCode = 4482375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-30', PermSecMapEndDate = NULL WHERE SecCode = 4482720 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 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 QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 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 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 PermOrgIPODate = NULL WHERE SecCode = 4524579 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4531983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804415050, ExchCode = 'MUN' WHERE SecCode = 4539323 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 QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 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 QuotePermID = 21811992005, ExchCode = 'FRA' WHERE SecCode = 4586561 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 = 236781829998, ExchCode = 'QTX' WHERE SecCode = 4591965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848146, ExchCode = 'DEU' WHERE SecCode = 4592022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 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 = 21816288537, ExchCode = 'FRA' WHERE SecCode = 4609999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806471, ExchCode = 'BER' WHERE SecCode = 4610043 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 4611019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22007949146, ExchCode = 'DEU' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387260, Ticker = 'WWT', ExchCode = 'LAS' WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4616837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, ExchCode = 'DEU' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820739202, ExchCode = 'DEU' WHERE SecCode = 4631954 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4635265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228224, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824693646, ExchCode = 'BER' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048901, ExchCode = 'MUN' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831917747, ExchCode = 'FRA' WHERE SecCode = 4677594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833427447, ExchCode = 'DEU' WHERE SecCode = 4680380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793284943, Ticker = '94Y', ExchCode = 'TDG' WHERE SecCode = 4682737 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 = 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 QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4702642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581874, ExchCode = 'QTX' WHERE SecCode = 4707177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4716084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381561, ExchCode = 'STU' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852728632, ExchCode = 'BER' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844719378, ExchCode = 'DEU' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 4724704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381821, ExchCode = 'LAS' WHERE SecCode = 4754868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742271, ExchCode = 'DEU' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 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 QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 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 = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861532579, ExchCode = 'GTX' WHERE SecCode = 4802327 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 QuotePermID = 21906823813, Ticker = 'KWE3l', ExchCode = 'AQX' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628121, ExchCode = 'DUS' WHERE SecCode = 4813698 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 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 = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869001966, ExchCode = 'DEU' WHERE SecCode = 4848926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002203, PermQuoteStatus = 'AC', Ticker = '57Z', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4848927 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 PermOrgIPODate = NULL WHERE SecCode = 4914393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883533876, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4938296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919010696, ExchCode = 'MUN' WHERE SecCode = 4950865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875594, PermQuoteStatus = 'AC', Ticker = 'VC9', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884970416, InstrPermID = 21872305855, ValQuotePermID = 21872305854.0, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2022-11-21', PermSecMapEndDate = '2022-11-21' WHERE SecCode = 4956702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200981, ExchCode = 'MEX' WHERE SecCode = 4956738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888276703, ExchCode = 'GTX' WHERE SecCode = 4972276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21926264784, PermQuoteStatus = 'DC', Ticker = 'V6M', ExchCode = 'DEU', PermQuoteRetireDate = '2022-11-07' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784862125, ExchCode = 'FRA' WHERE SecCode = 4975856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894548291, ExchCode = 'QTX' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902367523, ExchCode = 'MUN' WHERE SecCode = 5041763 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 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 QuotePermID = 21907898584, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5104499 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 = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292306, ExchCode = 'GER' WHERE SecCode = 5129738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, ExchCode = 'GTX' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5161308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, ExchCode = 'STU' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198685, ExchCode = 'BIV' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173435, ExchCode = 'MEX' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380702, ExchCode = 'LAS' WHERE SecCode = 5277530 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 QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942546883, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-07' WHERE SecCode = 5299987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794189399, ExchCode = 'TDG' WHERE SecCode = 5314256 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 = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059916, ExchCode = 'DEU' 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 QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 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 QuotePermID = 21921513369, ExchCode = 'QTX', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5434325 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5444000 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 = 236785348315, ExchCode = 'QTX' WHERE SecCode = 5466221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 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 QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 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 = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986459012, Ticker = 'USFAl', ExchCode = 'SIG' WHERE SecCode = 5516823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223797, ExchCode = 'QTX' WHERE SecCode = 5516829 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 = 21831436884, Ticker = 'SFTG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5534997 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 PermOrgIPODate = NULL WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786107921, ExchCode = 'FRA' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, ExchCode = 'FRA' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779690490, ExchCode = 'FRA' WHERE SecCode = 5558240 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 5561610 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 QuotePermID = 21794060301, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-05', PermSecMapEndDate = NULL WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 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 QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 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 QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 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 = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020600429, ExchCode = 'DEU' WHERE SecCode = 5687957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047387470, PermQuoteStatus = 'AC', Ticker = 'ZK7', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5697992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782180690, ExchCode = 'STU' WHERE SecCode = 5703062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782109056, ExchCode = 'BIV' WHERE SecCode = 5709076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028649127, ExchCode = 'DEU' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782809101, ExchCode = 'TDG' WHERE SecCode = 5745658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810015, ExchCode = 'FRA' WHERE SecCode = 5745661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810012, ExchCode = 'FRA' WHERE SecCode = 5745662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810016, ExchCode = 'FRA' WHERE SecCode = 5745663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810019, ExchCode = 'FRA' WHERE SecCode = 5745664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937290998, ExchCode = 'DEU' WHERE SecCode = 5749952 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 = 22036237406, ExchCode = 'QTX' WHERE SecCode = 5772686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791141189, ExchCode = 'FRA' WHERE SecCode = 5782810 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 = 236784107268, ExchCode = 'FRA' WHERE SecCode = 5814835 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '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 = 22052269961, ExchCode = 'DEU' WHERE SecCode = 5881402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587695, ExchCode = 'MUN' WHERE SecCode = 5881403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788448869, ExchCode = 'BCO' WHERE SecCode = 5886974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054245159, ExchCode = 'DEU' WHERE SecCode = 5888374 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 QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736829339, ExchCode = 'FRA' WHERE SecCode = 5944851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786839717, ExchCode = 'STU' WHERE SecCode = 5947076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066678467, ExchCode = 'DEU' WHERE SecCode = 5963924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787449425, ExchCode = 'SIG' WHERE SecCode = 5972437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089452738, Ticker = 'MST3d', ExchCode = 'CHI' WHERE SecCode = 5999093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847043, ExchCode = 'MUN' WHERE SecCode = 6043475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012125626, ExchCode = 'DUS' WHERE SecCode = 6097334 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' 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 = 21917827739, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 6097546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 6097549 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 = 236789902797, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30', PermSecMapEndDate = '2025-01-30' WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790416915, ExchCode = 'FRA' WHERE SecCode = 6128378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791216241, ExchCode = 'MUN' WHERE SecCode = 6182411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791216534, ExchCode = 'FRA' WHERE SecCode = 6186428 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6190695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791969104, ExchCode = 'FRA' WHERE SecCode = 6232187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909392, ExchCode = 'FRA' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22082082625, ExchCode = 'DUS' WHERE SecCode = 6256447 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 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 PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6297524 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6297525 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 6302010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793449671, ExchCode = 'QTX' WHERE SecCode = 6329880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793846300, ExchCode = 'FRA' WHERE SecCode = 6371577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793846301, ExchCode = 'FRA' WHERE SecCode = 6371578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866541, ExchCode = 'MEX' WHERE SecCode = 6375353 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 = 236794030748, ExchCode = 'QTX' WHERE SecCode = 6383874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118827967, ExchCode = 'DEU' WHERE SecCode = 6383881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515593, ExchCode = 'BIV' WHERE SecCode = 6394335 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 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 QuotePermID = 22123374791, ExchCode = 'GER' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '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 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 QuotePermID = 22126226547, ExchCode = 'DEU' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126226689, ExchCode = 'DEU' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6448319 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 = 236795754736, ExchCode = 'FRA' WHERE SecCode = 6450941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788641196, ExchCode = 'MEX' WHERE SecCode = 6450945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438836, ExchCode = 'STU' WHERE SecCode = 6451088 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL 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 WHERE SecCode = 6457996 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 PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6464963 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '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 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6472017 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 OrgTypeCode = 'COM' WHERE SecCode = 6472088 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 PermOrgIPODate = NULL WHERE SecCode = 10920501 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11009046 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11015634 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11033942 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11062344 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11108135 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 WHERE SecCode = 11194108 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 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 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 DomCntry = 'CYM' WHERE SecCode = 11227627 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11232072 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 PermOrgIPODate = NULL WHERE SecCode = 11241414 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11244761 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11249579 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 PermOrgIPODate = NULL WHERE SecCode = 11259265 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11262266 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 DomCntry = 'CYM' WHERE SecCode = 11285377 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV', PermOrgIPODate = '2025-09-25' WHERE SecCode = 11285809 AND Type_ = 1;
