UPDATE data_universe_permid SET QuotePermID = 236807338493, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'OCU', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475442988, Ticker = NULL, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17', PermOrgIPODate = NULL WHERE SecCode = 19506 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 31448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358466, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921478929, ExchCode = 'GTX' WHERE SecCode = 35017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 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 QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334267, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-17' WHERE SecCode = 38580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475608783, ExchCode = 'GER', PermQuoteRetireDate = '2010-03-05' WHERE SecCode = 38608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331050, ExchCode = 'BER' WHERE SecCode = 38610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836523767, ExchCode = 'FRA' WHERE SecCode = 41385 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 41508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474913868, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'MLPHD' WHERE SecCode = 47429 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 49484 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236801607810, ExchCode = 'GTX' WHERE SecCode = 53597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478545911, Ticker = 'CTV', ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 55766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483123, ExchCode = 'QTX' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243527, ExchCode = 'MUN', PermQuoteRetireDate = '2008-10-06' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783641141, ExchCode = 'MUN' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 56571 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 57155 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21541076135, ExchCode = 'FRA' WHERE SecCode = 57437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457930, Ticker = 'VTDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-05-23' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 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 = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474986024, ExchCode = 'DEU' WHERE SecCode = 64559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524268066, ExchCode = 'STU' WHERE SecCode = 64572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475349368, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-04' WHERE SecCode = 64581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036172, ExchCode = 'TDG' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475610158, Ticker = 'SPJG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475428110, ExchCode = 'GER' WHERE SecCode = 64940 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 67930 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 74558 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 76579 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TKMO' WHERE SecCode = 76663 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 78626 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 79419 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 79483 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 81938 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 82326 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 82327 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NVA' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 82762 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 83840 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 84237 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 86645 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BYOGF' WHERE SecCode = 87243 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 88511 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 88973 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 91198 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 95865 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 98901 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 99171 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 99858 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21499583574, ExchCode = 'TDG' WHERE SecCode = 111715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338020, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 111718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 113906 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 114384 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951259.0 WHERE SecCode = 119373 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 123563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472972, ExchCode = 'FRA' WHERE SecCode = 132940 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 133032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560377986, ExchCode = 'BTE' WHERE SecCode = 137860 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 139747 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'EN8', PermSecMapEndDate = NULL WHERE SecCode = 142067 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 143838 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519207, ExchCode = 'DUS', PermQuoteRetireDate = '2014-12-16' WHERE SecCode = 144542 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951259.0 WHERE SecCode = 147444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474940370, ExchCode = 'DEU' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178184 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178254 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913478289, Ticker = 'GG9B', ExchCode = 'TDG' WHERE SecCode = 178972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474902041, ExchCode = 'DEU', PermQuoteRetireDate = '2020-12-28' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 309330 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 340891 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 359993 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 379152 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 391333 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 425244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 467519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335096, ExchCode = 'BER' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853580515, ExchCode = 'FRA' WHERE SecCode = 552856 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 553225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856395007, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 575470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379754, ExchCode = 'LAS' WHERE SecCode = 593055 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 597085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954835919, ExchCode = 'DUS' WHERE SecCode = 597462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230062, ExchCode = 'FRA', PermQuoteRetireDate = '2016-11-03' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538883522, ExchCode = 'STU' WHERE SecCode = 623935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287353, ExchCode = 'BIV' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 786036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532857661, ExchCode = 'TDG' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 938241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 990921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890382, ExchCode = 'AQX' WHERE SecCode = 1108496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806640336, ExchCode = 'FRA' WHERE SecCode = 1111460 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1130688 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1182141 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1226331 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1254621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 1425684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734632074, ExchCode = 'DEU' WHERE SecCode = 1441088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073457, ExchCode = 'DEU' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792391622, ExchCode = 'DUS' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419448, ExchCode = 'HAM' WHERE SecCode = 1472577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481643753, ExchCode = 'MUN' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109482, ExchCode = 'DEU' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1505404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384788, ExchCode = 'FRA' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646184463, PermQuoteStatus = 'AC', Ticker = '5EV0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071858, ExchCode = 'TDG' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098667, ExchCode = 'FRA' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1529950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558559889, ExchCode = 'STU' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043659, ExchCode = 'STU' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524560434, Ticker = 'RBTQ', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787321763, ExchCode = 'FRA' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492713347, ExchCode = 'STU' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954843, ExchCode = 'LAS' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497743025, ExchCode = 'DEU' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807437495, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-10', PermSecMapEndDate = '2025-11-10' WHERE SecCode = 1564475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615254983, ExchCode = 'DEU', PermQuoteRetireDate = '2018-10-05' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524608957, ExchCode = 'CHI' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1592793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505186360, ExchCode = 'BUR' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538181095, ExchCode = 'STU' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506938763, ExchCode = 'FRA' WHERE SecCode = 1618089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176932253, ExchCode = 'DEU' WHERE SecCode = 1622873 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1623752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742592, Ticker = 'KJ7', ExchCode = 'HAN', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535814698, Ticker = 'BMZ.GB', ExchCode = 'ISD', PermQuoteRetireDate = '2015-04-20' WHERE SecCode = 1635481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822238, ExchCode = 'DEU' WHERE SecCode = 1655502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512412458, Ticker = 'CTY1SN011', ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431652, ExchCode = 'FRA' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955323, ExchCode = 'DEU' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387414, ExchCode = 'LAS' WHERE SecCode = 1723207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195856, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644523837, ExchCode = 'STU' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431292, ExchCode = 'FRA' WHERE SecCode = 2213927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532444506, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644782383, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-02-16' WHERE SecCode = 2222230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324218, ExchCode = 'DEU' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563544, ExchCode = 'FRA' WHERE SecCode = 2239343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303284, ExchCode = 'TDG' WHERE SecCode = 2267521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370630, ExchCode = 'SGO' WHERE SecCode = 2272715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525274948, ExchCode = 'FRA' WHERE SecCode = 2278225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525339865, ExchCode = 'DEU' WHERE SecCode = 2278227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525273252, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2278243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525927737, ExchCode = 'FRA' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526080169, ExchCode = 'DEU' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2287239 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21526973502.0 WHERE SecCode = 2307812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609618572, Ticker = 'GPAB', ExchCode = 'STU', PermQuoteRetireDate = '2018-05-23' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670892655, ExchCode = 'QTX' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780887285, ExchCode = 'CHI' WHERE SecCode = 2365610 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 = 236799419067, ExchCode = 'LAS' WHERE SecCode = 2377960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890421682, ExchCode = 'STU' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656977, ExchCode = 'GTX' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531848797, ExchCode = 'FRA' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531978999, ExchCode = 'FRA' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921479660, ExchCode = 'GTX' WHERE SecCode = 2391353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615450, ExchCode = 'MUN' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336720, ExchCode = 'FRA' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169500042, ExchCode = 'DEU' WHERE SecCode = 2402414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847717686, ExchCode = 'GTX' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527246, ExchCode = 'FRA' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534457668, ExchCode = 'FRA' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443169, ExchCode = 'TDG' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2459997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724351602, ExchCode = 'QTX' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451292, Ticker = 'MER', ExchCode = 'SWX' WHERE SecCode = 2465112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298337, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-04' WHERE SecCode = 2465278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535774912, ExchCode = 'BER', PermQuoteRetireDate = '2018-09-21' WHERE SecCode = 2467266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907546243, ExchCode = 'MUN' WHERE SecCode = 2470092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538229, ExchCode = 'GTX' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800269665, ExchCode = 'FRA' WHERE SecCode = 2482710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536674787, ExchCode = 'STU' WHERE SecCode = 2487654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537024389, ExchCode = 'DEU' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786358, ExchCode = 'BTE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 2515703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720364225, ExchCode = 'TDG' WHERE SecCode = 2515711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538118516, ExchCode = 'DEU' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108940988, ExchCode = 'DEU' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551088215, ExchCode = 'DEU' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848757217, ExchCode = 'QTX', PermQuoteRetireDate = '2023-01-17', PermSecMapEndDate = NULL WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539181248, ExchCode = 'FRA' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539859456, ExchCode = 'DEU' 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 QuotePermID = 21667478404, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-24' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230438, ExchCode = 'FRA' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684125, ExchCode = 'STU' WHERE SecCode = 2545058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378729, ExchCode = 'GTX' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637306664, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890729, ExchCode = 'DEU' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368221, ExchCode = 'FRA' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550101775, ExchCode = 'FRA' WHERE SecCode = 2559800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793909715, ExchCode = 'TDG' WHERE SecCode = 2568912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543010837, ExchCode = 'BER', PermQuoteRetireDate = '2023-03-30' WHERE SecCode = 2578880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986686943, ExchCode = 'DEU' WHERE SecCode = 2578881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543010984, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708914, ExchCode = 'DEU' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726151, ExchCode = 'DEU' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545617420, ExchCode = 'DEU' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662661878, ExchCode = 'MUN' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547157215, ExchCode = 'DEU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548037377, ExchCode = 'DEU', PermQuoteRetireDate = '2020-11-12' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548030533, ExchCode = 'DEU' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548030535, ExchCode = 'DEU' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359766, ExchCode = 'STU' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414445, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548207169, ExchCode = 'DEU' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830304824, ExchCode = 'GTX', PermQuoteRetireDate = '2025-05-02' WHERE SecCode = 2644169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548686714, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-30' WHERE SecCode = 2650642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589498059, ExchCode = 'TDG' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549921078, ExchCode = 'BTE' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647223374, ExchCode = 'MUN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379555, Ticker = 'HCL', ExchCode = 'BRN' WHERE SecCode = 2682233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451625, Ticker = 'GMT', ExchCode = 'SWX', PermQuoteRetireDate = '2017-09-13', PermSecMapEndDate = '2017-09-13' WHERE SecCode = 2682394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451261, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2016-08-05' WHERE SecCode = 2682397 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21550627860.0 WHERE SecCode = 2685352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551131018, ExchCode = 'DEU', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2706346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540948191, Ticker = '0QTP', ExchCode = 'LSE', PermQuoteRetireDate = '2020-03-10' WHERE SecCode = 2710438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21553068778.0 WHERE SecCode = 2727836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2747570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704488, ExchCode = 'MXQ' WHERE SecCode = 2747774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554995304, ExchCode = 'STU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2774681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589784, ExchCode = 'DEU' WHERE SecCode = 2810887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558477129, ExchCode = 'DEU' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155337, ExchCode = 'FRA' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21716468870, ExchCode = 'DEU' WHERE SecCode = 2824459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560442240, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2849907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374532, ExchCode = 'FRA' WHERE SecCode = 2849922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274949, ExchCode = 'GTX' WHERE SecCode = 2855817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734475861, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 2873688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073295, ExchCode = 'FRA', PermQuoteRetireDate = '2022-03-09' WHERE SecCode = 2880970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478695, ExchCode = 'QTX' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562620362, ExchCode = 'MUN' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865170, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654291757, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2911861 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21565229902.0 WHERE SecCode = 2912882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890828, PermQuoteStatus = 'AC', Ticker = 'VZLBd', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823342, ExchCode = 'GTX' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011968, Ticker = '2EBAY' WHERE SecCode = 2925433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2926161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985207, ExchCode = 'TDG' WHERE SecCode = 2935962 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2939987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783066619, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2955167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520298, ExchCode = 'QTX' WHERE SecCode = 3038439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619609100, ExchCode = 'MUN' WHERE SecCode = 3065856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386888, ExchCode = 'LAS' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3075371 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3101370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933862, ExchCode = 'MUN' WHERE SecCode = 3105902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3155220 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3160087 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 3162845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604828800, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589835342, ExchCode = 'DEU' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169497784, ExchCode = 'DEU' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-06' WHERE SecCode = 3213357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496462, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593818616, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3228677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000075, ExchCode = 'DEU' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597107042, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-01' WHERE SecCode = 3237127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3245596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3276822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633333080, ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-02', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 3338477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3370809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908261084, Ticker = '1FBm', ExchCode = 'EQD' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3405230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850703278, PermQuoteStatus = 'DC', Ticker = 'SOG', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-02' WHERE SecCode = 3409010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3410310 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3429659 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 3432247 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 3433392 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3434591 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 = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3588036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609678, ExchCode = 'DEU' WHERE SecCode = 3588082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995361, ExchCode = 'DEU' WHERE SecCode = 3588110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872250, ExchCode = 'FRA' WHERE SecCode = 3588112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197812, ExchCode = 'FRA' WHERE SecCode = 3588113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' 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 = 21690033954, ExchCode = 'MUN' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-10' WHERE SecCode = 3661135 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3671085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394405, ExchCode = 'BIV' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830030, ExchCode = 'QTX' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702763885, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3890307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272890, ExchCode = 'GTX' WHERE SecCode = 3951450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727293094, Ticker = NULL, ExchCode = 'MEX', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 3952658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011956, Ticker = '2GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026865, Ticker = '11COV' WHERE SecCode = 4031771 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 = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 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 = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026937, Ticker = '1SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4053516 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4054101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995390, ExchCode = 'DEU' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776435514, Ticker = 'ZWIPEs', ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-21' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260229, ExchCode = 'DEU' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359629, ExchCode = 'MEX' WHERE SecCode = 4139229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704289, Ticker = 'AZULBN', ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026841, Ticker = '1NOW' WHERE SecCode = 4214371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026766, Ticker = '1AMT' WHERE SecCode = 4214372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026951, Ticker = '1AWK' WHERE SecCode = 4214377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026829, Ticker = '1GD' WHERE SecCode = 4214384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026900, Ticker = '1HLT' WHERE SecCode = 4214387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026927, Ticker = '1K' WHERE SecCode = 4214388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026939, Ticker = '1SPG' WHERE SecCode = 4214395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026966, Ticker = '1SYK' WHERE SecCode = 4214397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026844, Ticker = '1TROW' WHERE SecCode = 4214399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026809, Ticker = '1WEC' WHERE SecCode = 4214401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787665340, Ticker = '4APH', ExchCode = 'ETX' WHERE SecCode = 4214403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699193157, Ticker = 'BYND', ExchCode = 'SWX' WHERE SecCode = 4214409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600490, Ticker = '1PLUGm', ExchCode = 'BCO' WHERE SecCode = 4214415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752247732, ExchCode = 'DEU' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588255, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-16', PermSecMapEndDate = NULL WHERE SecCode = 4259226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156845, ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 4298618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342160, ExchCode = 'MEX' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690939, ExchCode = 'BTE' WHERE SecCode = 4315108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803438809, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763901203, ExchCode = 'QTX' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766378279, ExchCode = 'QTX' WHERE SecCode = 4333278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782605835, ExchCode = 'QTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650250, ExchCode = 'DUS' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003928, ExchCode = 'MUN', PermQuoteRetireDate = '2024-11-25' WHERE SecCode = 4401406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787553936, ExchCode = 'DEU', PermQuoteRetireDate = '2021-01-07' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 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 = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4456235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956950, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801282977, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4487598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817595, ExchCode = 'DEU' WHERE SecCode = 4487625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780165906, ExchCode = 'MXQ' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141623, ExchCode = 'MXQ' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097393503, ExchCode = 'FRA' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4565159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659635, ExchCode = 'QTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848426, ExchCode = 'FRA' WHERE SecCode = 4591965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812836218, ExchCode = 'TDG' WHERE SecCode = 4592022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' 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 = 21814722256, ExchCode = 'DEU' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WO62' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842017348, ExchCode = 'BCO' WHERE SecCode = 4608547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263610, ExchCode = 'BIV' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527622, ExchCode = 'FRA' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778677427, ExchCode = 'QTX' WHERE SecCode = 4632109 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 = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963730, ExchCode = 'STU' WHERE SecCode = 4641628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, ExchCode = 'MUN' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954880, ExchCode = 'LAS', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4670156 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4677594 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 = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933374646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2023-01-02' WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235607, ExchCode = 'MEX' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098692, ExchCode = 'DEU' WHERE SecCode = 4753666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742239, ExchCode = 'FRA' WHERE SecCode = 4761587 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 = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043646, ExchCode = 'LAS' WHERE SecCode = 4790646 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'NVA' WHERE SecCode = 4798367 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 = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000077, ExchCode = 'FRA' WHERE SecCode = 4823658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590398, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536829, ExchCode = 'STU' WHERE SecCode = 4823661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866160214, ExchCode = 'TDG' WHERE SecCode = 4823663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897370, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4823669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861142851, ExchCode = 'DEU' WHERE SecCode = 4829216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792865438, ExchCode = 'GTX' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877551047, ExchCode = 'DEU' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806835525, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4940671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884081519, PermQuoteStatus = 'AC', Ticker = 'K9N', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4949680 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 = 22179518902, Ticker = '2MUEd', ExchCode = 'BTE' WHERE SecCode = 4965038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321224, ExchCode = 'MUN' WHERE SecCode = 5004799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097175, ExchCode = 'LAS' WHERE SecCode = 5011695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894948499, ExchCode = 'PAR' WHERE SecCode = 5013560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908066901, ExchCode = 'DEU' WHERE SecCode = 5102905 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5122870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238773, ExchCode = 'LAS' WHERE SecCode = 5174471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783133624, ExchCode = 'TDG' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942349169, ExchCode = 'QTX' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956352320, ExchCode = 'TDG' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951358875, PermQuoteStatus = 'AC', Ticker = '3QP', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747349, ExchCode = 'STU' WHERE SecCode = 5395770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667447, ExchCode = 'STU' WHERE SecCode = 5436573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667355, ExchCode = 'STU' WHERE SecCode = 5436574 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5446036 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5450871 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5454652 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5462279 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 = 5476899 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5481068 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5495257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776471889, ExchCode = 'BIV' WHERE SecCode = 5503860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309751, Ticker = '3LPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891290, ExchCode = 'FRA' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5511073 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5513352 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5515094 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5517574 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5525173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5544127 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786107921, ExchCode = 'FRA' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5572142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' 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 PermOrgIPODate = NULL WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 5624000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942898, ExchCode = 'MEX' WHERE SecCode = 5631516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781013274, ExchCode = 'FRA' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460745, ExchCode = 'FRA' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569267651, ExchCode = 'BTE' WHERE SecCode = 5638833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460738, ExchCode = 'FRA' WHERE SecCode = 5638838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460803, ExchCode = 'GER' WHERE SecCode = 5638843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803622939, Ticker = 'TS2S', ExchCode = 'LSE' WHERE SecCode = 5638844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830322, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835007, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5678867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799652775, ExchCode = 'LAS' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031489244, Ticker = 'SOXL', ExchCode = 'MIL' WHERE SecCode = 5740824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031488834, Ticker = 'MAG7', ExchCode = 'MIL' WHERE SecCode = 5740826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690931, ExchCode = 'BTE' WHERE SecCode = 5740827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 5740830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246029, ExchCode = 'CHI' WHERE SecCode = 5740832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807274847, InstrPermID = 232932732631, ValQuotePermID = 236807018323.0, IsPrimaryInstr = 1, PermQuoteStatus = 'AC', Ticker = 'Y8R', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-19', PermSecMapEndDate = NULL WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5749879 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5775760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784438281, ExchCode = 'STU' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785978750, ExchCode = 'STU' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888214, ExchCode = 'BIV' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798426612, ExchCode = 'GTX' WHERE SecCode = 5947065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786839717, ExchCode = 'STU' WHERE SecCode = 5947076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6050909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171969, ExchCode = 'MEX' WHERE SecCode = 6097384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834940, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791108496, ExchCode = 'FRA' WHERE SecCode = 6177691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791667937, ExchCode = 'BIV' WHERE SecCode = 6226138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760171626, ExchCode = 'STU' WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293760, Ticker = '2IU0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21553068778.0 WHERE SecCode = 6299130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792866696, ExchCode = 'FRA' WHERE SecCode = 6303058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793107258, ExchCode = 'MUN' WHERE SecCode = 6310331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797747578, ExchCode = 'TDG' WHERE SecCode = 6310332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988748, ExchCode = 'MUN' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116657866, ExchCode = 'DEU' WHERE SecCode = 6368870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655573, ExchCode = 'FRA' WHERE SecCode = 6368872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655581, ExchCode = 'GER' WHERE SecCode = 6368874 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 QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794616561, ExchCode = 'FRA' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794619095, ExchCode = 'QTX' WHERE SecCode = 6418488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794616600, ExchCode = 'STU' WHERE SecCode = 6418489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796057730, ExchCode = 'GTX' WHERE SecCode = 6448294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125760536, ExchCode = 'MIL' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451435, ExchCode = 'CHI' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158030, ExchCode = 'CHI' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231077, ExchCode = 'BCO' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158021, ExchCode = 'CHI' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703201, ExchCode = 'CHI' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451434, ExchCode = 'CHI' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447621, ExchCode = 'CHI' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158040, ExchCode = 'CHI' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451424, ExchCode = 'CHI' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796026166, ExchCode = 'FRA' WHERE SecCode = 6457997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798271089, Ticker = 'S0N', ExchCode = 'QTX' WHERE SecCode = 6503395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22139574682, ExchCode = 'DEU' WHERE SecCode = 6587374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541597, ExchCode = 'FRA' WHERE SecCode = 6627152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541595, ExchCode = 'FRA' WHERE SecCode = 6627153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541760, ExchCode = 'FRA' WHERE SecCode = 6627155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451421, ExchCode = 'CHI' WHERE SecCode = 6627463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22155220901, ExchCode = 'DEU' WHERE SecCode = 6629415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191250, ExchCode = 'SGO' WHERE SecCode = 6678589 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-02-25' WHERE SecCode = 6685945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755612, ExchCode = 'FRA' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755696, ExchCode = 'FRA' WHERE SecCode = 6737927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755694, ExchCode = 'FRA' WHERE SecCode = 6737928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804838546, ExchCode = 'MEX' WHERE SecCode = 6748872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804998678, ExchCode = 'FRA' WHERE SecCode = 6748898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804998679, ExchCode = 'FRA' WHERE SecCode = 6748899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804998676, ExchCode = 'FRA' WHERE SecCode = 6748900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169965637, ExchCode = 'DEU' WHERE SecCode = 6753080 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 6806346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807168148, ExchCode = 'TDG' WHERE SecCode = 6862202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22180065660, ExchCode = 'MXQ' WHERE SecCode = 6862277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408711, ExchCode = 'MEX' WHERE SecCode = 6900891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782483, ExchCode = 'TDG' WHERE SecCode = 6900894 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'FITB' WHERE SecCode = 6901294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808059081, ExchCode = 'MUN' WHERE SecCode = 6902160 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 6917413 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6921006 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6921011 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6921026 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6921033 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6921034 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951599.0 WHERE SecCode = 11009656 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11014419 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11045531 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11054827 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11056046 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TMED.X' WHERE SecCode = 11078563 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FRTU' WHERE SecCode = 11129237 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 11142421 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 21550627860.0 WHERE SecCode = 11146245 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'WRDLD' WHERE SecCode = 11156631 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 11160125 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 11160247 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 11194215 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11210042 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ALURD' WHERE SecCode = 11221773 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727253308, InstrPermID = 25727253311, OrgPermID = 5082500824, PriTrdQuotePermID = 25727253308.0, ValQuotePermID = 25727253309.0, PriInstrPermID = 25727234269.0, PermInstrStatus = 'DC', ExchCode = 'ASE', DomCntry = 'SGP', IncCntry = 'SGP', PriTRBCIndPermID = 4294951705.0, PermQuoteRetireDate = '2023-08-15', PermOrgIPODate = '2023-08-15', PermSecMapStartDate = '2021-07-14', PermSecMapEndDate = '2023-08-15' WHERE SecCode = 11227480 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 11241243 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11245885 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 11247676 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 21553068778.0 WHERE SecCode = 11254937 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11267228 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5097117599, DomCntry = 'TWN', PriTRBCIndPermID = 4294951265.0, PermOrgIPODate = NULL WHERE SecCode = 11271694 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11274658 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5097117599, DomCntry = 'TWN', PriTRBCIndPermID = 4294951265.0, PermOrgIPODate = NULL WHERE SecCode = 11274684 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11274685 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-17' WHERE SecCode = 11295026 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11295230 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236808503555.0 WHERE SecCode = 11297252 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 47767465140.0 WHERE SecCode = 11297328 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11297511 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808501307, IsPrimaryQuote = 1, ExchCode = 'PNK' WHERE SecCode = 11297512 AND Type_ = 1;
