UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474988450, PermQuoteStatus = 'AC', Ticker = '0M6S', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531136784, Ticker = 'ZHEHl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-08-29' WHERE SecCode = 9121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629381057, Ticker = '0Q1N', ExchCode = 'LSE' WHERE SecCode = 9338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530716, Ticker = 'OAK', ExchCode = 'VTX', PermQuoteRetireDate = '2006-09-21' WHERE SecCode = 9856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556855, Ticker = '31QX', ExchCode = 'LSE', PermQuoteRetireDate = '2008-04-25' WHERE SecCode = 9908 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 12961 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 17729 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838693553, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-12' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322896, ExchCode = 'BER', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, ExchCode = 'DEU' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339577, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 35746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215890, ExchCode = 'FRA' WHERE SecCode = 36613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139058, ExchCode = 'TDG' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838403123, ExchCode = 'STU' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475606794, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 54890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459836, ExchCode = 'HAN' WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323787, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 57589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838234962, ExchCode = 'MUN', PermQuoteRetireDate = '2012-04-17' WHERE SecCode = 57595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474881490, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2016-04-27', PermSecMapEndDate = '2017-04-12' WHERE SecCode = 57612 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 59904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358975, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340932, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 60564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526392841, ExchCode = 'DEU' WHERE SecCode = 60669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836555411, ExchCode = 'FRA' WHERE SecCode = 60831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393801, ExchCode = 'FRA' WHERE SecCode = 62694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520470, ExchCode = 'DEU' WHERE SecCode = 64435 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 68614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524860585, ExchCode = 'AUX' WHERE SecCode = 80783 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 82248 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 82838 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ALHDD' WHERE SecCode = 83713 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 83801 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 93743 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 100099 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 100312 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'VXT' WHERE SecCode = 104532 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 110311 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 111297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140929, ExchCode = 'DEU' WHERE SecCode = 113074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525789042, ExchCode = 'FRA' WHERE SecCode = 131777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560377986, ExchCode = 'BTE' WHERE SecCode = 137860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537703084, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 145644 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 147126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684961175, ExchCode = 'MUN' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782821783, ExchCode = 'MUN' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273282, ExchCode = 'GTX' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838699115, ExchCode = 'STU' WHERE SecCode = 179171 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 180517 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21830294096, ExchCode = 'GTX' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536548828, ExchCode = 'FRA' WHERE SecCode = 186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956383102, ExchCode = 'FRA' WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22043721486, ExchCode = 'DEU' WHERE SecCode = 255607 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 286286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325722, ExchCode = 'BER' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373387, ExchCode = 'FRA' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 310249 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 310250 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 310251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349692, ExchCode = 'FRA', PermQuoteRetireDate = '2011-04-01' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519091, ExchCode = 'DUS' WHERE SecCode = 319526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629957388, ExchCode = 'TDG' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321382, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2022-02-07' WHERE SecCode = 330668 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 337161 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116848257, ExchCode = 'DEU' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997542, ExchCode = 'DEU' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502570914, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 345858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033888, ExchCode = 'TDG', PermQuoteRetireDate = '2017-08-15' WHERE SecCode = 351504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675808, Ticker = '0GWG', ExchCode = 'LSE', PermQuoteRetireDate = '2018-07-27' WHERE SecCode = 353994 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 383684 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 383685 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 383686 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 383687 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 383688 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 383689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840901357, ExchCode = 'BER', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 389776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547316142, ExchCode = 'STU' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542942791, ExchCode = 'STU' WHERE SecCode = 548782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859812314, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 637343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863112368, Ticker = 'BABC.GB', ExchCode = 'PLU' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475065394, ExchCode = 'FRA', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 780725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550677284, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2016-01-27' WHERE SecCode = 1389099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785622122, ExchCode = 'MUN' WHERE SecCode = 1441088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513584728, ExchCode = 'CHI', PermQuoteRetireDate = '2020-06-25' WHERE SecCode = 1449053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516194767, ExchCode = 'BER', PermQuoteRetireDate = '2016-11-01' WHERE SecCode = 1528650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514707492, ExchCode = 'DEU' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544843699, ExchCode = 'FRA' WHERE SecCode = 2055322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371118, ExchCode = 'BEC' WHERE SecCode = 2195863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307002, ExchCode = 'SGO' WHERE SecCode = 2226896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369738, ExchCode = 'BEC' WHERE SecCode = 2232870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679429, ExchCode = 'BIV' WHERE SecCode = 2292972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22004161785, Ticker = 'XDN0', ExchCode = 'SWX' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534457668, ExchCode = 'FRA' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536675650, ExchCode = 'STU' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537024389, ExchCode = 'DEU' WHERE SecCode = 2495669 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 QuotePermID = 21538087646, ExchCode = 'FRA' WHERE SecCode = 2514695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538369403, ExchCode = 'DEU' WHERE SecCode = 2521751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538369434, ExchCode = 'DEU' WHERE SecCode = 2521752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539181248, ExchCode = 'FRA' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539325972, ExchCode = 'TDG' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145685, ExchCode = 'TDG' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451848, Ticker = 'BKNG', ExchCode = 'SWX' WHERE SecCode = 2537377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835976, Ticker = '53S1d', ExchCode = 'BCO', PermQuoteRetireDate = '2021-09-27' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543086754, ExchCode = 'FRA' WHERE SecCode = 2572303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708914, ExchCode = 'DEU' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' 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 = 21616206318, ExchCode = 'STU' WHERE SecCode = 2621782 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 = 21548016931, ExchCode = 'MUN' WHERE SecCode = 2642451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548012786, ExchCode = 'FRA' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548031769, ExchCode = 'DEU' WHERE SecCode = 2642453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548037285, ExchCode = 'FRA' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548771924, ExchCode = 'TDG' WHERE SecCode = 2642458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109507, ExchCode = 'FRA', PermQuoteRetireDate = '2018-06-11' WHERE SecCode = 2643269 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 = 21548381242, ExchCode = 'DEU' WHERE SecCode = 2647456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840146, ExchCode = 'FRA' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548878176, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 2653612 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 = 21550451552, Ticker = 'RNO', ExchCode = 'SWX' WHERE SecCode = 2682171 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 2693648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551131019, ExchCode = 'DEU' WHERE SecCode = 2698369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551269259, ExchCode = 'TDG' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551965230, Ticker = 'CBKe', ExchCode = 'SIG', PermQuoteRetireDate = '2014-12-10' WHERE SecCode = 2706343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553011650, ExchCode = 'MUN' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994447, ExchCode = 'STU' WHERE SecCode = 2718429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552651936, ExchCode = 'BCO', PermQuoteRetireDate = '2021-09-13' WHERE SecCode = 2720682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557034612, ExchCode = 'DEU' WHERE SecCode = 2720693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704155, ExchCode = 'MXQ' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789017040, ExchCode = 'DUS' WHERE SecCode = 2747510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533309421, ExchCode = 'DEU' WHERE SecCode = 2747656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789940347, ExchCode = 'FRA' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588924110, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-01' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645802, ExchCode = 'BER' WHERE SecCode = 2796968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252575, ExchCode = 'MUN' WHERE SecCode = 2810887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557265708, ExchCode = 'FRA' WHERE SecCode = 2810889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381707, ExchCode = 'LAS' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568380128, ExchCode = 'STU' WHERE SecCode = 2821436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863187602, ExchCode = 'GTX' WHERE SecCode = 2821450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607316317, ExchCode = 'STU' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672243468, ExchCode = 'MUN' 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 = 21580961084, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 2864442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561660659, ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-16', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298274, ExchCode = 'DUS' WHERE SecCode = 2872658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595194710, ExchCode = 'STU' WHERE SecCode = 2887282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562944846, ExchCode = 'FRA' WHERE SecCode = 2887317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563671243, ExchCode = 'BER' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434298, ExchCode = 'BCO' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564309878, ExchCode = 'DEU' WHERE SecCode = 2902752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073579, ExchCode = 'FRA' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564887095, ExchCode = 'DEU' WHERE SecCode = 2909921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778584563, ExchCode = 'BER' WHERE SecCode = 2909922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565403130, ExchCode = 'DEU' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951032, ExchCode = 'FRA' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565229667, ExchCode = 'BER' WHERE SecCode = 2912969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292295, PermQuoteStatus = 'AC', Ticker = 'VZLB', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566817654, ExchCode = 'FRA' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568560621, ExchCode = 'DEU' WHERE SecCode = 2929653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608858954, Ticker = '34L', ExchCode = 'GER', PermQuoteRetireDate = '2017-07-25', PermSecMapEndDate = '2024-05-20' WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292298, PermQuoteStatus = 'AC', Ticker = 'VZLE', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2935960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077853, ExchCode = 'LAS' WHERE SecCode = 2935971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601542157, ExchCode = 'MUN' WHERE SecCode = 2944415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673461, ExchCode = 'BIV' WHERE SecCode = 2944451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568326330, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569050447, ExchCode = 'DEU' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641358562, ExchCode = 'DEU' WHERE SecCode = 2958533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570455715, ExchCode = 'DEU' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158658, ExchCode = 'DEU' WHERE SecCode = 2975172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706327513, ExchCode = 'TDG' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525595, ExchCode = 'TDG' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573379099, ExchCode = 'FRA' WHERE SecCode = 2998198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588216839, ExchCode = 'STU' WHERE SecCode = 2998199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608857928, ExchCode = 'FRA' WHERE SecCode = 3008027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573409540, ExchCode = 'STU' WHERE SecCode = 3015987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431770, ExchCode = 'DEU' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575706656, ExchCode = 'STU' WHERE SecCode = 3026615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864421, ExchCode = 'STU' WHERE SecCode = 3030075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575930919, ExchCode = 'FRA' WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576306371, ExchCode = 'FRA', PermQuoteRetireDate = '2024-08-16', PermSecMapEndDate = '2025-07-04' WHERE SecCode = 3033923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830306482, ExchCode = 'GTX' WHERE SecCode = 3038477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640538037, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-17' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788253475, ExchCode = 'MEX' WHERE SecCode = 3060652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611487584, ExchCode = 'DEU' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759241355, ExchCode = 'MUN' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627776801, ExchCode = 'STU' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580961071, ExchCode = 'BER' WHERE SecCode = 3090322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614152373, ExchCode = 'STU' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109486, ExchCode = 'FRA' WHERE SecCode = 3116969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489945, ExchCode = 'FRA' WHERE SecCode = 3120784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953916121, ExchCode = 'GTX' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432032, ExchCode = 'FRA' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304628, ExchCode = 'DEU' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674827, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3130990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632441048, Ticker = '0R9U', ExchCode = 'LSE' WHERE SecCode = 3156022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588032923, ExchCode = 'FRA' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077944, ExchCode = 'LAS' WHERE SecCode = 3166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749597787, ExchCode = 'FRA' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901754747, ExchCode = 'BCO' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589591761, ExchCode = 'DEU' WHERE SecCode = 3195464 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'C42', PermSecMapEndDate = '2025-09-27' WHERE SecCode = 3196346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782726133, ExchCode = 'AQX' WHERE SecCode = 3197040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629889076, ExchCode = 'STU' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590791188, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-11' WHERE SecCode = 3201372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781307000, ExchCode = 'FRA' WHERE SecCode = 3206355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936325129, ExchCode = 'TDG' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604452283, ExchCode = 'STU', PermQuoteRetireDate = '2023-06-12', PermSecMapEndDate = NULL WHERE SecCode = 3213267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'EUS0' WHERE SecCode = 3216437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592711298, ExchCode = 'DEU', PermQuoteRetireDate = '2025-08-20', PermSecMapEndDate = '2025-08-20' WHERE SecCode = 3219383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867040818, ExchCode = 'TDG' WHERE SecCode = 3222984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801065728, ExchCode = 'FRA' WHERE SecCode = 3223419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596193460, ExchCode = 'FRA' WHERE SecCode = 3230847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594892241, ExchCode = 'FRA' WHERE SecCode = 3236427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595466438, ExchCode = 'DEU', PermQuoteRetireDate = '2021-02-10' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595586249, ExchCode = 'MUN' WHERE SecCode = 3247292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334992, ExchCode = 'DEU' WHERE SecCode = 3247427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780423, ExchCode = 'DEU' WHERE SecCode = 3247560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597660311, ExchCode = 'CHA' WHERE SecCode = 3256336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598617553, ExchCode = 'AUX' WHERE SecCode = 3261247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599532242, ExchCode = 'DEU' WHERE SecCode = 3269645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675205, ExchCode = 'BIV' WHERE SecCode = 3275597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705848, ExchCode = 'MXQ' WHERE SecCode = 3275598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705218, Ticker = 'JEN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3275604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678970, ExchCode = 'BIV' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857170593, ExchCode = 'QTX', PermQuoteRetireDate = '2021-11-25' WHERE SecCode = 3280089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601775044, ExchCode = 'FRA' WHERE SecCode = 3282366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754774965, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-24' WHERE SecCode = 3282701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602510359, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-04' WHERE SecCode = 3283289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604352845, ExchCode = 'STU' WHERE SecCode = 3283650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631067602, Ticker = 'BORROs', ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-16' WHERE SecCode = 3283870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622863075, ExchCode = 'STU' WHERE SecCode = 3288205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606316228, ExchCode = 'FRA' WHERE SecCode = 3301693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606470915, ExchCode = 'FRA' WHERE SecCode = 3301863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833203, ExchCode = 'DEU' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028052308, ExchCode = 'DEU' WHERE SecCode = 3304225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606894640, ExchCode = 'BCO' WHERE SecCode = 3304228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607018070, PermQuoteStatus = 'AC', Ticker = 'KYH0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032714, ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-09' WHERE SecCode = 3305485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422089, ExchCode = 'DEU' WHERE SecCode = 3307824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288479, ExchCode = 'DEU' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607816573, Ticker = 'SGBX', ExchCode = 'LSE' WHERE SecCode = 3309467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, ExchCode = 'STU' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780692142, ExchCode = 'TDG' WHERE SecCode = 3317120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608856492, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2018-10-31', PermSecMapEndDate = '2018-10-31' WHERE SecCode = 3317174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609265100, ExchCode = 'BER' WHERE SecCode = 3317854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478734, ExchCode = 'QTX' WHERE SecCode = 3317857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739162126, ExchCode = 'MUN' WHERE SecCode = 3317931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827327570, ExchCode = 'DEU' WHERE SecCode = 3318810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645691, ExchCode = 'DEU' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GP80' WHERE SecCode = 3319532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722307, ExchCode = 'FRA' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042361, ExchCode = 'DEU' WHERE SecCode = 3322821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX', PermQuoteRetireDate = '2022-10-03' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321660, ExchCode = 'DEU' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598488, ExchCode = 'FRA' WHERE SecCode = 3342863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613993973, ExchCode = 'DEU' WHERE SecCode = 3352147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614671639, ExchCode = 'FRA' WHERE SecCode = 3357942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525574, ExchCode = 'DEU' WHERE SecCode = 3357972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050441, ExchCode = 'DEU' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615370656, ExchCode = 'MUN' WHERE SecCode = 3363519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815336911, ExchCode = 'DEU' WHERE SecCode = 3367998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186337, ExchCode = 'FRA' WHERE SecCode = 3371968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617808658, ExchCode = 'FRA' WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617889188, ExchCode = 'CHA' WHERE SecCode = 3378309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867512394, ExchCode = 'FRA' WHERE SecCode = 3378316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636815378, Ticker = '0Q1F', ExchCode = 'LSE' WHERE SecCode = 3378492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671840503, ExchCode = 'BER' WHERE SecCode = 3379253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618604186, ExchCode = 'FRA' WHERE SecCode = 3379346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702474572, PermQuoteStatus = 'DC', Ticker = '19U0', ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631611395, ExchCode = 'TDG' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620409821, ExchCode = 'BCO' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761306205, ExchCode = 'MUN' WHERE SecCode = 3386777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957123, PermQuoteStatus = 'DC', Ticker = 'C5B', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-19' WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796060148, ExchCode = 'CHI' WHERE SecCode = 3392282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624182570, ExchCode = 'DEU' WHERE SecCode = 3396912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111176656, ExchCode = 'DEU' WHERE SecCode = 3401720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622941, ExchCode = 'DEU' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790762, ExchCode = 'CHI' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676577, ExchCode = 'BIV' WHERE SecCode = 3404480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678617, ExchCode = 'BIV' WHERE SecCode = 3404905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679449, ExchCode = 'BIV' WHERE SecCode = 3404907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381768, ExchCode = 'LAS' WHERE SecCode = 3405606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835864, Ticker = 'DTSd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629252830, ExchCode = 'DEU' WHERE SecCode = 3407252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818277149, ExchCode = 'DEU' WHERE SecCode = 3409089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890509, ExchCode = 'DEU' WHERE SecCode = 3409161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835920, Ticker = 'CJCd', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3409167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839054723, ExchCode = 'FRA' WHERE SecCode = 3409178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21966768788, ExchCode = 'DEU' WHERE SecCode = 3409182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692729569, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-19', PermSecMapEndDate = '2023-01-19' WHERE SecCode = 3409186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664959898, ExchCode = 'BER' WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630922, ExchCode = 'FRA', PermQuoteRetireDate = '2025-02-26', PermSecMapEndDate = '2025-02-26' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368528, Ticker = 'PU9D', ExchCode = 'SES', PermQuoteRetireDate = '2018-01-18' WHERE SecCode = 3429985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704376, ExchCode = 'MXQ' WHERE SecCode = 3430658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644531036, PermQuoteStatus = 'AC', Ticker = '1GQd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3430801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644531032, Ticker = '1JFd', ExchCode = 'BCO', PermQuoteRetireDate = '2022-03-17' WHERE SecCode = 3430802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736358054, ExchCode = 'TDG' WHERE SecCode = 3432450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634298447, Ticker = '0R2Jl', ExchCode = 'BCO' WHERE SecCode = 3432940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640836018, ExchCode = 'DEU' WHERE SecCode = 3434745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705861, ExchCode = 'MXQ' WHERE SecCode = 3434746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997874, ExchCode = 'DEU' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793644583, ExchCode = 'TDG' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641139170, ExchCode = 'STU' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644789418, Ticker = 'CAS', ExchCode = 'LSE', PermQuoteRetireDate = '2019-03-08' WHERE SecCode = 3446120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645435116, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-02' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569555, ExchCode = 'BER' WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646696029, ExchCode = 'DEU' WHERE SecCode = 3473357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380072, ExchCode = 'LAS' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649268603, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647200533, ExchCode = 'DEU' WHERE SecCode = 3490823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647155015, ExchCode = 'DEU' WHERE SecCode = 3490825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388833, ExchCode = 'LAS' WHERE SecCode = 3490864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749465975, ExchCode = 'MUN' WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650965200, Ticker = 'NOKIA', ExchCode = 'PRA' WHERE SecCode = 3504673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791038866, ExchCode = 'BER' WHERE SecCode = 3509155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21728546239, ExchCode = 'MUN' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651518719, ExchCode = 'BER' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296414, ExchCode = 'GTX' WHERE SecCode = 3523385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796817098, ExchCode = 'FRA' WHERE SecCode = 3525431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665411073, ExchCode = 'DEU' WHERE SecCode = 3529091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758498, ExchCode = 'STU' WHERE SecCode = 3531554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350897, ExchCode = 'DEU' WHERE SecCode = 3532727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720013538, ExchCode = 'DEU' WHERE SecCode = 3533827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654296430, ExchCode = 'DEU' WHERE SecCode = 3534921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830287256, ExchCode = 'GTX' WHERE SecCode = 3535855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654538689, ExchCode = 'TDG' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422112, ExchCode = 'DEU' WHERE SecCode = 3539022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350885, ExchCode = 'FRA' WHERE SecCode = 3543305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654759184, ExchCode = 'DEU' WHERE SecCode = 3545291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822778897, PermQuoteStatus = 'DC', Ticker = '28S', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-26' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951296, ExchCode = 'BTE' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692715160, ExchCode = 'BTE' WHERE SecCode = 3551896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058784, ExchCode = 'DEU' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558102, ExchCode = 'GTX' WHERE SecCode = 3555055 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3560287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681761692, ExchCode = 'FRA' WHERE SecCode = 3569619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705499, ExchCode = 'MXQ' WHERE SecCode = 3573698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55866956065, ExchCode = 'BEC' WHERE SecCode = 3587010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867895880, ExchCode = 'BEC' WHERE SecCode = 3587014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562247, ExchCode = 'GTX' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609218, ExchCode = 'FRA' WHERE SecCode = 3588082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667846229, ExchCode = 'DEU' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 3593745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666113143, ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806537024, ExchCode = 'STU' WHERE SecCode = 3603358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123519, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3619536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636387547, Ticker = '2NFL.GB', ExchCode = 'AQS' WHERE SecCode = 3669927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918918, ExchCode = 'DEU' WHERE SecCode = 3675860 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 = 21674900559, ExchCode = 'DEU' WHERE SecCode = 3694159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114234, ExchCode = 'DEU' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736203589, ExchCode = 'TDG' WHERE SecCode = 3713252 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3716979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296345, ExchCode = 'GTX' WHERE SecCode = 3738159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453299, ExchCode = 'BER' WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682194724, ExchCode = 'DEU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527340, ExchCode = 'DEU' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520529, ExchCode = 'DEU' WHERE SecCode = 3784710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688529457, ExchCode = 'MUN' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376095, ExchCode = 'BIV' WHERE SecCode = 3799556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689566283, ExchCode = 'HAN' WHERE SecCode = 3807820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667361, ExchCode = 'FRA' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694235031, ExchCode = 'FRA' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918856, ExchCode = 'DEU' WHERE SecCode = 3832752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890002591, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-05-26', PermSecMapEndDate = '2025-05-26' WHERE SecCode = 3844919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696686140, ExchCode = 'DEU' WHERE SecCode = 3845904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767399333, ExchCode = 'MUN' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371516, ExchCode = 'MEX' WHERE SecCode = 3849233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858452393, ExchCode = 'BER' WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697694615, ExchCode = 'STU' WHERE SecCode = 3851567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 3858016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369830, ExchCode = 'BIV' WHERE SecCode = 3868466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245385, ExchCode = 'DEU' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704947306, ExchCode = 'QTX' WHERE SecCode = 3875223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153752, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-05' WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235704, ExchCode = 'DUS' WHERE SecCode = 3879165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895334, ExchCode = 'STU' WHERE SecCode = 3881153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702680698, ExchCode = 'FRA' WHERE SecCode = 3888265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368208, ExchCode = 'BIV' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703435769, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-10' WHERE SecCode = 3894967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855812467, ExchCode = 'GTX' WHERE SecCode = 3906532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957499828, ExchCode = 'DUS' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186483, ExchCode = 'DEU' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817666768, ExchCode = 'BER' WHERE SecCode = 4001066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012741, Ticker = '2MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723842234, ExchCode = 'DEU' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041763, ExchCode = 'TDG' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727358588, ExchCode = 'BIV' WHERE SecCode = 4058582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460845, ExchCode = 'FRA' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779527, ExchCode = 'DUS' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966439, ExchCode = 'FRA' WHERE SecCode = 4124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963671, ExchCode = 'STU' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21981535065, ExchCode = 'MXQ' WHERE SecCode = 4194640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766439763, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486435, ExchCode = 'QTX' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-08' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534178673, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282397 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 4286320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387283, ExchCode = 'LAS' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766378279, ExchCode = 'QTX' WHERE SecCode = 4333278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768173346, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-24', PermSecMapEndDate = '2024-04-24' WHERE SecCode = 4348280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768173473, ExchCode = 'DEU' WHERE SecCode = 4348282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771445002, ExchCode = 'QTX' 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 = 21773404609, ExchCode = 'FRA' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775812056, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 4385267 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'LE30', PermSecMapEndDate = '2025-09-27' WHERE SecCode = 4402242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680774 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439298, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879563641, ExchCode = 'MUN', PermQuoteRetireDate = '2024-03-05', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257865, ExchCode = 'FRA' WHERE SecCode = 4449676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854730428, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-31', PermSecMapEndDate = NULL WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299967, ExchCode = 'MEX' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306261, ExchCode = 'MEX' WHERE SecCode = 4456073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386726, ExchCode = 'LAS' WHERE SecCode = 4474387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897786131, ExchCode = 'MUN' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795226688, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-29', PermSecMapEndDate = '2023-06-29' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291863, ExchCode = 'MEX' WHERE SecCode = 4485970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141645, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4487640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, ExchCode = 'BER' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820607, ExchCode = 'FRA' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409263, ExchCode = 'FRA' WHERE SecCode = 4505803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801283028, ExchCode = 'MUN' WHERE SecCode = 4517641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781361764, ExchCode = 'STU' WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4519547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804415057, ExchCode = 'STU' WHERE SecCode = 4539323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143288, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097393503, ExchCode = 'FRA' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951033, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-27', PermSecMapEndDate = '2024-11-27' WHERE SecCode = 4568425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21964831485, ExchCode = 'DEU' WHERE SecCode = 4568460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809546926, ExchCode = 'FRA' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991962, ExchCode = 'DEU' WHERE SecCode = 4586561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812176052, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 4588258 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 = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294372, ExchCode = 'GTX' WHERE SecCode = 4609996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816905312, ExchCode = 'TDG' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288448, ExchCode = 'DEU' WHERE SecCode = 4609999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037649, ExchCode = 'MUN' WHERE SecCode = 4610043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818128449, Ticker = 'WWT0', ExchCode = 'FRA' WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091542, ExchCode = 'TQE' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888689541, ExchCode = 'STU' WHERE SecCode = 4620159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758913, ExchCode = 'STU' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22023908086, ExchCode = 'DEU' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073655, ExchCode = 'DEU' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780368954, ExchCode = 'TDG' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824701678, ExchCode = 'STU' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890147, ExchCode = 'DEU' WHERE SecCode = 4662619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831917952, ExchCode = 'DEU' WHERE SecCode = 4677594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833427693, ExchCode = 'FRA' WHERE SecCode = 4680380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795801694, ExchCode = 'FRA' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793314093, Ticker = '94Y0', ExchCode = 'STU' WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244578, ExchCode = 'BIV' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244579, ExchCode = 'MEX' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380604, ExchCode = 'LAS' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840593956, ExchCode = 'DEU' WHERE SecCode = 4707177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235607, ExchCode = 'MEX' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842026972, ExchCode = 'DEU' WHERE SecCode = 4713798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842026893, ExchCode = 'STU' WHERE SecCode = 4713800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919010713, ExchCode = 'MUN' WHERE SecCode = 4754868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387339, ExchCode = 'LAS' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856729893, ExchCode = 'DEU' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858471109, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859541948, ExchCode = 'GTX' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860077592, ExchCode = 'DUS' WHERE SecCode = 4800489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861533047, ExchCode = 'MUN' WHERE SecCode = 4802327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861206747, Ticker = 'KWE3', ExchCode = 'LSE' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627738, ExchCode = 'QTX' WHERE SecCode = 4813698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 4819878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156627, ExchCode = 'MUN' WHERE SecCode = 4827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381824, ExchCode = 'LAS' WHERE SecCode = 4845067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522588, ExchCode = 'STU' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881315859, ExchCode = 'QTX' WHERE SecCode = 4918607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21880177757, ExchCode = 'GER' WHERE SecCode = 4925631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881998635, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-25', PermSecMapEndDate = '2022-03-25' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882406240, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-04' WHERE SecCode = 4938296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478060, ExchCode = 'DEU' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321191, ExchCode = 'MUN', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380555, ExchCode = 'LAS' WHERE SecCode = 4950865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, PermQuoteStatus = 'DC', Ticker = 'VC91', ExchCode = 'QTX', PermQuoteRetireDate = '2024-09-03' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200980, ExchCode = 'BIV' WHERE SecCode = 4956738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727205517, ExchCode = 'MEX' WHERE SecCode = 4962789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279764, ExchCode = 'MUN' WHERE SecCode = 4972276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888705400, ExchCode = 'MUN' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577630, ExchCode = 'TDG' WHERE SecCode = 4991558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580276, ExchCode = 'FRA' WHERE SecCode = 4991678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777698929, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-08' WHERE SecCode = 4991682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, ExchCode = 'BER' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 5072231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905223535, ExchCode = 'FRA' WHERE SecCode = 5083963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908066901, ExchCode = 'DEU' WHERE SecCode = 5102905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910417781, ExchCode = 'DEU' WHERE SecCode = 5115641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535351, ExchCode = 'DEU' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561826, ExchCode = 'GTX' WHERE SecCode = 5166540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650249, ExchCode = 'DUS' WHERE SecCode = 5166568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783316559, ExchCode = 'STU' WHERE SecCode = 5168258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049597, ExchCode = 'MXQ' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132598, ExchCode = 'DEU' WHERE SecCode = 5218830 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 5223372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933629891, ExchCode = 'TDG' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397466, ExchCode = 'CHI' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956352320, ExchCode = 'TDG' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937504045, ExchCode = 'QTX' WHERE SecCode = 5310445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943095865, ExchCode = 'BER' WHERE SecCode = 5313552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948082062, ExchCode = 'FRA' WHERE SecCode = 5329497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732431, ExchCode = 'MEX' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957547161, ExchCode = 'FRA' WHERE SecCode = 5370902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581953, ExchCode = 'BIV' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223779, ExchCode = 'QTX' WHERE SecCode = 5395767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777698922, ExchCode = 'STU' WHERE SecCode = 5399892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21972116853, ExchCode = 'STU' WHERE SecCode = 5443505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778288801, ExchCode = 'FRA' WHERE SecCode = 5466221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778622366, ExchCode = 'HAM' WHERE SecCode = 5490578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151523, PermQuoteStatus = 'AC', Ticker = '3SVE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21695368158, ExchCode = 'TDG' 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 = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 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 = 236778926386, ExchCode = 'FRA' WHERE SecCode = 5509507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22002744025, Ticker = 'USFA', ExchCode = 'SWX' WHERE SecCode = 5516823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779059190, ExchCode = 'FRA' WHERE SecCode = 5516829 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 = 236779608955, ExchCode = 'BER' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780661116, ExchCode = 'DUS' WHERE SecCode = 5620203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781012608, ExchCode = 'STU' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781013274, ExchCode = 'FRA' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966434, PermQuoteStatus = 'DC', Ticker = 'N8I1', ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 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 = 22019369628, ExchCode = 'DEU' WHERE SecCode = 5674580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020600393, ExchCode = 'DEU' WHERE SecCode = 5679100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858189, ExchCode = 'FRA' WHERE SecCode = 5687957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784748617, PermQuoteStatus = 'DC', Ticker = 'ZK70', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 5697992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22024905249, Ticker = 'SOXL', ExchCode = 'LSE' WHERE SecCode = 5702908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078152, ExchCode = 'LAS' WHERE SecCode = 5703208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782376739, ExchCode = 'FRA' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994460, ExchCode = 'FRA' WHERE SecCode = 5758113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812185857, ExchCode = 'DEU' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329299, ExchCode = 'BER' WHERE SecCode = 5782814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040670142, ExchCode = 'GTX' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111477357, ExchCode = 'TDG' WHERE SecCode = 5785810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040671156, ExchCode = 'MUN' WHERE SecCode = 5785811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783309191, ExchCode = 'MEX' WHERE SecCode = 5801442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783847368, ExchCode = 'BER' WHERE SecCode = 5805681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040680991, ExchCode = 'DEU' WHERE SecCode = 5805700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040690920, ExchCode = 'DEU' WHERE SecCode = 5805706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377679, ExchCode = 'STU' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377678, ExchCode = 'FRA' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785533896, Ticker = '4WL', ExchCode = 'STU', PermQuoteRetireDate = '2024-12-02', PermSecMapEndDate = '2024-12-02' WHERE SecCode = 5894939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786957574, ExchCode = 'GTX' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791725086, ExchCode = 'BCO' WHERE SecCode = 5972437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 6097383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171969, ExchCode = 'MEX' WHERE SecCode = 6097384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784422711, ExchCode = 'MEX' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674562, ExchCode = 'BIV' WHERE SecCode = 6097401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689582, ExchCode = 'CHI' WHERE SecCode = 6097546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782305154, ExchCode = 'MEX' WHERE SecCode = 6097558 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 = 21782860079, Ticker = '3OIS', ExchCode = 'LSE' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789870076, ExchCode = 'HAN', PermQuoteRetireDate = '2025-01-31', PermSecMapEndDate = NULL WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 6190695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094064244, ExchCode = 'DEU' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838445, ExchCode = 'FRA' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147197, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116662449, ExchCode = 'QTX' WHERE SecCode = 6368869 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 = 236793934516, ExchCode = 'DUS' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 6429307 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 6429308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125348556, ExchCode = 'DEU' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6440008 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6448319 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6449334 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6457846 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6464963 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6467527 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'K8L0' WHERE SecCode = 6467530 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6472160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796404433, ValQuotePermID = 236796404433.0, IsPrimaryQuote = 1, Ticker = 'DELIAo', ExchCode = 'STO', OrgTypeCode = 'COM', PermOrgIPODate = '2025-09-29' WHERE SecCode = 6474420 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 10811170 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 11189762 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 11191438 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'BPAG', PermSecMapEndDate = '2025-09-27' WHERE SecCode = 11194108 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 11214225 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 11225542 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'THA' WHERE SecCode = 11238443 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'THA' WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'THA' WHERE SecCode = 11239814 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'BYRRF' WHERE SecCode = 11260456 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-27' WHERE SecCode = 11267719 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 11269314 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796369265, PriTrdQuotePermID = 236796369265.0, ValQuotePermID = 25727060193.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'ASE' WHERE SecCode = 11285876 AND Type_ = 1;
