UPDATE data_universe_permid SET QuotePermID = 21520816071, ValQuotePermID = 21520816071.0, PermQuoteStatus = 'AC', Ticker = 'IDOX.GB', ExchCode = 'AQS', PermQuoteRetireDate = NULL WHERE SecCode = 4259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475585602, Ticker = 'GEC.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 5363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474862736, Ticker = 'COLTl', ExchCode = 'TRQ', PermQuoteRetireDate = '2015-09-11' WHERE SecCode = 6070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569164975, Ticker = 'FROl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-15' WHERE SecCode = 6369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852417171, PermQuoteStatus = 'DC', Ticker = 'TKA.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 7986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836028512, Ticker = 'IJF', ExchCode = 'ISE' WHERE SecCode = 8027 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 12512 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 19582 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 27772 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 30364 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 32929 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55837355911, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837361395, ExchCode = 'GER' WHERE SecCode = 34242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474865107, ExchCode = 'DEU', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 34391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475625018, Ticker = 'BTLG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474854502, ExchCode = 'DEU' WHERE SecCode = 35018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527756408, Ticker = 'GEO1Vh', ExchCode = 'BTE', PermQuoteRetireDate = '2013-09-02' WHERE SecCode = 36266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394031, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-03' WHERE SecCode = 37133 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 = 21635381919, ExchCode = 'TDG' WHERE SecCode = 37812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033428, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 37823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139058, ExchCode = 'TDG' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334909, ExchCode = 'BER' WHERE SecCode = 38209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478468860, ExchCode = 'TDG' WHERE SecCode = 38803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837366352, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 38887 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 39071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624625, PermQuoteStatus = 'DC', Ticker = 'ISMG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 41356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474987055, ExchCode = 'DEU' WHERE SecCode = 41736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652953776, ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-10' WHERE SecCode = 42067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197086, Ticker = 'RY', ExchCode = 'BRN', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 42490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474859691, ExchCode = 'DEU' WHERE SecCode = 44084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520650353, ExchCode = 'MUN' WHERE SecCode = 44086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836483306, ExchCode = 'FRA' WHERE SecCode = 44154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475132090, Ticker = 'PC6A', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-12', PermSecMapEndDate = NULL WHERE SecCode = 44172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561509662, Ticker = 'SI2A', ExchCode = 'STU', PermQuoteRetireDate = '2025-06-27', PermSecMapEndDate = NULL WHERE SecCode = 44174 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 44900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354839, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 45916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838652164, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-16' WHERE SecCode = 46294 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 47041 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55837356038, ExchCode = 'GER' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475622154, PermQuoteStatus = 'DC', Ticker = 'XMFG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 47703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243885, ExchCode = 'MUN' WHERE SecCode = 47823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363706, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 47966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475514446, Ticker = 'BLTG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 48081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838579509, ExchCode = 'STU', PermQuoteRetireDate = '2019-04-10' WHERE SecCode = 48122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781095764, Ticker = 'DYHd', ExchCode = 'AQX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485662, ExchCode = 'QTX' WHERE SecCode = 48468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722222291, ExchCode = 'GER' WHERE SecCode = 49173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130139, Ticker = 'WLGi', ExchCode = 'BCO', PermQuoteRetireDate = '2017-03-30' WHERE SecCode = 51130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337633, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-04-12', PermSecMapEndDate = '2019-04-12' WHERE SecCode = 51563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323999, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 51564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642496474, ExchCode = 'BTE' WHERE SecCode = 52632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836523121, ExchCode = 'FRA' WHERE SecCode = 52842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150007, Ticker = 'AD', ExchCode = 'SWX' WHERE SecCode = 52844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519006, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-10-15' WHERE SecCode = 53447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531120342, PermQuoteStatus = 'AC', Ticker = 'CBGBd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 53618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475786049, Ticker = 'HYU', ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-19' WHERE SecCode = 53627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475583576, PermQuoteStatus = 'DC', Ticker = 'SMYG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475482926, ExchCode = 'BER' WHERE SecCode = 53813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524268428, ExchCode = 'STU', PermQuoteRetireDate = '2023-06-08' WHERE SecCode = 53833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589631, PermQuoteStatus = 'DC', Ticker = 'L0992', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486471, ExchCode = 'QTX' WHERE SecCode = 54302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835781188, PermQuoteStatus = 'DC', Ticker = 'MGYA', ExchCode = 'DUS', PermQuoteRetireDate = '2025-12-23', PermSecMapEndDate = '2026-01-20' WHERE SecCode = 54416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035518, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 54422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486120, ExchCode = 'QTX' WHERE SecCode = 54435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336419, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 54552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836409452, ExchCode = 'FRA', PermQuoteRetireDate = '2008-07-02' WHERE SecCode = 54568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337383, Ticker = 'TCC', ExchCode = 'BER', PermQuoteRetireDate = '2010-04-14' WHERE SecCode = 54580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490422, ExchCode = 'QTX' WHERE SecCode = 54587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417017, ExchCode = 'STU', PermQuoteRetireDate = '2009-11-18' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338727, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 55213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538164352, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237210, ExchCode = 'MUN', PermQuoteRetireDate = '2008-10-06' WHERE SecCode = 56393 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 57351 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 57520 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 57675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237943, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 58289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916875, ExchCode = 'TDG' WHERE SecCode = 58298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571086, PermQuoteStatus = 'DC', Ticker = 'REPG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 58416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512169283, ExchCode = 'TDG' WHERE SecCode = 58663 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TRXOD' WHERE SecCode = 59007 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836386168, ExchCode = 'FRA' WHERE SecCode = 60008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363187, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330492, ExchCode = 'BER', PermQuoteRetireDate = '2016-10-07' WHERE SecCode = 60051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324566, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393702, ExchCode = 'FRA' WHERE SecCode = 60123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238403, ExchCode = 'MUN' WHERE SecCode = 60133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836396787, ExchCode = 'FRA', PermQuoteRetireDate = '2012-07-03' WHERE SecCode = 60135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237768, ExchCode = 'MUN' WHERE SecCode = 60186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364960, ExchCode = 'GER', PermQuoteRetireDate = '2010-06-07' WHERE SecCode = 60187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308590, ExchCode = 'GTX' WHERE SecCode = 60203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848657467, ExchCode = 'MUN' WHERE SecCode = 60210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474847720, ExchCode = 'DEU' WHERE SecCode = 60217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034623, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 60224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492108, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 60243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474883602, ExchCode = 'DEU' WHERE SecCode = 60286 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 = 21499629621, ExchCode = 'TDG' WHERE SecCode = 60330 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 60403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340868, ExchCode = 'BER', PermQuoteRetireDate = '2013-05-13' WHERE SecCode = 60523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836516282, ExchCode = 'FRA' WHERE SecCode = 60537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862793443, PermQuoteStatus = 'AC', ExchCode = 'HAN', PermQuoteRetireDate = NULL WHERE SecCode = 60560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475572974, Ticker = 'NSUG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807883958, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-02', PermSecMapEndDate = NULL WHERE SecCode = 61124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294103, ExchCode = 'GTX' WHERE SecCode = 61209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474859472, ExchCode = 'DEU' WHERE SecCode = 61338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374661, ExchCode = 'DEU' WHERE SecCode = 61355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836410302, ExchCode = 'FRA' WHERE SecCode = 61599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521413775, ExchCode = 'DEU' WHERE SecCode = 61608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802980106, ExchCode = 'STU' WHERE SecCode = 61631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481990, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 61644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489833, ExchCode = 'QTX' WHERE SecCode = 61651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624615, Ticker = 'IMGG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 61667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457482, ExchCode = 'STU', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 61676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913616, ExchCode = 'DEU' WHERE SecCode = 61685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290095, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 61691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033713, PermQuoteStatus = 'AC', Ticker = 'AK3', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 62376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323913, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 62531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 62752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474890590, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2017-12-29', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 62765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474892813, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 62845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394806, ExchCode = 'FRA' WHERE SecCode = 62872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874654411, ExchCode = 'GTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917173961, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 63016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474868408, ExchCode = 'DEU', PermQuoteRetireDate = '2013-05-27' WHERE SecCode = 63227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475765841, ExchCode = 'FRA' WHERE SecCode = 63292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503798483, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 63693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544483339, ExchCode = 'TDG' WHERE SecCode = 64549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522869226, Ticker = 'ST7', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-28' WHERE SecCode = 64555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474984046, ExchCode = 'HAM', PermQuoteRetireDate = '2012-07-11' WHERE SecCode = 64558 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 = 21871056052, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27', PermSecMapEndDate = NULL WHERE SecCode = 64727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532325019, ExchCode = 'BER' WHERE SecCode = 64907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535832346, ExchCode = 'STU' WHERE SecCode = 64908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324850, ExchCode = 'BER', PermQuoteRetireDate = '2010-05-26' WHERE SecCode = 64923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325516, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475428110, ExchCode = 'GER' WHERE SecCode = 64940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335265, Ticker = 'RD2C', ExchCode = 'BER', PermQuoteRetireDate = '2017-02-21' WHERE SecCode = 64945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475779150, ExchCode = 'TDG' WHERE SecCode = 64949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705260424, PermQuoteStatus = 'DC', Ticker = 'SS91', ExchCode = 'STU', PermQuoteRetireDate = '2024-04-11' WHERE SecCode = 65007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499810173, ExchCode = 'TDG' WHERE SecCode = 65014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512233295, ExchCode = 'TDG' WHERE SecCode = 65181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836422897, ExchCode = 'FRA' WHERE SecCode = 65261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341183, Ticker = 'RDV', ExchCode = 'BER', PermQuoteRetireDate = '2012-06-07' WHERE SecCode = 65270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546164752, ExchCode = 'TDG' WHERE SecCode = 65298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475732745, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2009-04-27', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 65300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836596296, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 65328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838450820, ExchCode = 'STU', PermQuoteRetireDate = '2014-02-11' WHERE SecCode = 65966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419375, ExchCode = 'HAM' WHERE SecCode = 66686 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 70099 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 70947 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 71904 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 79382 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'BLEGD' WHERE SecCode = 79606 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 80231 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 84347 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 84934 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 86334 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 96441 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 96476 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 99171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835683163, Ticker = 'HTCCO', ExchCode = 'LUX' WHERE SecCode = 102840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736422, PermQuoteRetireDate = '2011-02-11' WHERE SecCode = 103118 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 104488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656727011, ExchCode = 'STU' WHERE SecCode = 111811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836514917, Ticker = 'UAX1', ExchCode = 'FRA', PermQuoteRetireDate = '2008-06-04' WHERE SecCode = 111950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585674848, ExchCode = 'FRA' WHERE SecCode = 112018 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 QuotePermID = 22145600959, ExchCode = 'DEU' WHERE SecCode = 112636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298391, ExchCode = 'FRA' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525931704, ExchCode = 'STU' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008736, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590664983, ExchCode = 'STU' WHERE SecCode = 121215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705680, ExchCode = 'MXQ' WHERE SecCode = 121221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679715, ExchCode = 'BIV' WHERE SecCode = 121223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705696, ExchCode = 'MXQ' WHERE SecCode = 121226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835824045, ExchCode = 'MEX' WHERE SecCode = 121613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835815379, ExchCode = 'MEX' WHERE SecCode = 121614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329157, ExchCode = 'BER' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909445, ExchCode = 'FRA' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489506679, ExchCode = 'STU' WHERE SecCode = 130435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330949, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 130530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843597877, ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 131656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610381426, ExchCode = 'DEU' WHERE SecCode = 131683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332205, ExchCode = 'BER', PermQuoteRetireDate = '2015-09-14' WHERE SecCode = 132559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791248862, ExchCode = 'DEU' WHERE SecCode = 132592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485575397, ExchCode = 'STU', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = NULL WHERE SecCode = 132593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792941430, ExchCode = 'FRA' WHERE SecCode = 132606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008417, ExchCode = 'DEU', PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 132611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514186845, ExchCode = 'STU' WHERE SecCode = 132792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295457, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 132852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492896698, ExchCode = 'STU' WHERE SecCode = 132945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530674158, ExchCode = 'STU' WHERE SecCode = 132970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773000755, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 133025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355330, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 133203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340029, ExchCode = 'BER' WHERE SecCode = 133363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449019, ExchCode = 'DEU' WHERE SecCode = 133385 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21520816071.0 WHERE SecCode = 136909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787461, ExchCode = 'DUS', PermQuoteRetireDate = '2022-01-14', PermSecMapEndDate = NULL WHERE SecCode = 137285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838242583, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31', PermSecMapEndDate = '2021-12-31' WHERE SecCode = 137370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475873162, ExchCode = 'STU' WHERE SecCode = 137374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512264703, Ticker = 'WENo', ExchCode = 'STO', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 137904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651751886, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 138259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475092805, ExchCode = 'DEU', PermQuoteRetireDate = '2017-12-11' WHERE SecCode = 139946 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 141041 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 141228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574086997, PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 143248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799652656, ExchCode = 'FRA' WHERE SecCode = 144104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487452, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 144107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336716, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144108 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 QuotePermID = 236781569877, ExchCode = 'QTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335951, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 144853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481377161, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-22', PermSecMapEndDate = '2023-09-22' WHERE SecCode = 145350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384984, ExchCode = 'STU' WHERE SecCode = 145375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475009558, ExchCode = 'DEU' WHERE SecCode = 145380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498231140, ExchCode = 'FRA' WHERE SecCode = 145407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492485720, ExchCode = 'GER' WHERE SecCode = 145435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337535, ExchCode = 'BER' WHERE SecCode = 145506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533662651, ExchCode = 'TDG' WHERE SecCode = 145554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794070572, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 145558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481863, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 145685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036013, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 146280 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 146311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575204794, ExchCode = 'HAM' WHERE SecCode = 146333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333434, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 147005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623602687, ExchCode = 'TDG' WHERE SecCode = 147295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542522415, ExchCode = 'STU', PermQuoteRetireDate = '2026-03-27' WHERE SecCode = 147470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816891160, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 147598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334729, ExchCode = 'BER', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 147649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338871, ExchCode = 'BER' WHERE SecCode = 147655 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 147662 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-02' WHERE SecCode = 147705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281537, ExchCode = 'TDG' WHERE SecCode = 147869 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 = 21521106330, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-09' WHERE SecCode = 147913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 161398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524820302, ExchCode = 'STU' WHERE SecCode = 172988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545507629, ExchCode = 'DEU' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288188, ExchCode = 'FRA' WHERE SecCode = 174875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890527, ExchCode = 'FRA' WHERE SecCode = 177156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 177280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858577, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28', PermSecMapEndDate = '2024-03-28' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357816, ExchCode = 'GER' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475866191, ExchCode = 'DEU' WHERE SecCode = 177487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649328303, ExchCode = 'STU' WHERE SecCode = 177594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536791757, ExchCode = 'STU', PermQuoteRetireDate = '2024-02-28' WHERE SecCode = 177697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778285066, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327818, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820821, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 180248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611418, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 190124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521109986, PermQuoteStatus = 'AC', Ticker = 'HY7', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 190214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661437570, ExchCode = 'STU' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332170, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 192685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475796722, ExchCode = 'TDG', PermQuoteRetireDate = '2013-10-28' WHERE SecCode = 199065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474944386, ExchCode = 'DEU' WHERE SecCode = 199359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836586560, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2011-12-30', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 201295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836538132, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 201298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509902864, Ticker = 'SOYP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675875, ExchCode = 'BIV' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308695, ExchCode = 'GTX' WHERE SecCode = 249726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481198, Ticker = 'AHR', ExchCode = 'QTX', PermQuoteRetireDate = '2020-08-06' WHERE SecCode = 249735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325926, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 249738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264818, ExchCode = 'FRA' WHERE SecCode = 249797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532684873, ExchCode = 'DEU' WHERE SecCode = 249801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328481, ExchCode = 'BER', PermQuoteRetireDate = '2016-01-04' WHERE SecCode = 249805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309351, ExchCode = 'MUN' WHERE SecCode = 249812 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 249824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478898, ExchCode = 'QTX' WHERE SecCode = 254070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325014, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-16', PermSecMapEndDate = '2025-07-16' WHERE SecCode = 286042 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 QuotePermID = 21475536164, ValQuotePermID = 21629379834.0, PriInstrPermID = 21855801985.0, IsPrimaryQuote = 0, IsPrimaryInstr = 0, Ticker = 'ODDI.I', ExchCode = 'CST', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 291899 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 292614 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 301431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320454, ExchCode = 'BER' WHERE SecCode = 304579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320511, Ticker = '31ID', ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 304581 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 317489 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475010458, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 317772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294090, ExchCode = 'GTX' WHERE SecCode = 318425 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 320955 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PYBXD' WHERE SecCode = 321702 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55837350798, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 325339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041772, ExchCode = 'TDG' WHERE SecCode = 326261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 326282 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-01', PermSecMapEndDate = NULL WHERE SecCode = 327142 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667479301, ExchCode = 'QTX' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388051, Ticker = 'DNB.OL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303087, PermQuoteStatus = 'DC', Ticker = 'FIE.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296413, Ticker = 'AAGN.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673167, Ticker = '0MSM', ExchCode = 'LSE', PermQuoteRetireDate = '2011-09-09' WHERE SecCode = 332212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479486, ExchCode = 'QTX' WHERE SecCode = 332303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791287113, ExchCode = 'FRA' WHERE SecCode = 332315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836503011, ExchCode = 'FRA' WHERE SecCode = 332324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836370746, ExchCode = 'FRA', PermQuoteRetireDate = '2009-04-20' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503112746, ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885451397, ExchCode = 'MUN' WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350680, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 333806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177730, ExchCode = 'TRQ', PermQuoteRetireDate = '2019-06-19' WHERE SecCode = 333820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806834454, ExchCode = 'FRA' WHERE SecCode = 336756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914565, ExchCode = 'FRA' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334559, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 345858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838300398, Ticker = 'EXF.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 351265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299672, Ticker = 'OPT.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 351274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475565177, PermQuoteStatus = 'DC', Ticker = '0HHW', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 351284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834822694, Ticker = '1HLS01A.SK', ExchCode = 'PLU', PermQuoteRetireDate = '2010-05-05' WHERE SecCode = 353920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388978, Ticker = 'HLDX.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388341, Ticker = 'ORC.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388463, Ticker = 'WIHL.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380670, ExchCode = 'LAS' WHERE SecCode = 354063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388662, PermQuoteStatus = 'DC', Ticker = 'OPT.PL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 363982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553398912, ExchCode = 'TDG', PermQuoteRetireDate = '2016-04-26' WHERE SecCode = 377929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519125, ExchCode = 'DUS', PermQuoteRetireDate = '2024-06-03', PermSecMapEndDate = '2024-06-03' WHERE SecCode = 377931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331762, ExchCode = 'BER', PermQuoteRetireDate = '2018-10-30' WHERE SecCode = 378775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840701879, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 385016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664443549, ExchCode = 'DEU', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 395621 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 436006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845037622, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 440782 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 442788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766987, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 446617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846943053, ExchCode = 'FRA', PermQuoteRetireDate = '2014-01-06' WHERE SecCode = 464560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181310583, Ticker = 'XAXJl', ExchCode = 'OCU' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150825819, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847671835, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01' WHERE SecCode = 486270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21629379834.0, PriInstrPermID = 21855801985.0, IsPrimaryInstr = 0 WHERE SecCode = 512140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851190611, ExchCode = 'BER' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-02' WHERE SecCode = 542014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 546646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478506436, ExchCode = 'STU' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415257, ExchCode = 'MUN' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475771162, ExchCode = 'STU' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475779870, ExchCode = 'QMF', PermQuoteRetireDate = '2013-01-09' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 563130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580382275, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL WHERE SecCode = 564862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858255778, ExchCode = 'STU' WHERE SecCode = 566156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794980779, ExchCode = 'MUN', PermQuoteRetireDate = '2024-07-10' WHERE SecCode = 566221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857959487, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859132029, ExchCode = 'FRA' WHERE SecCode = 594191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935935, ExchCode = 'STU', PermQuoteRetireDate = '2020-10-19' WHERE SecCode = 601659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132756017, ExchCode = 'STO' WHERE SecCode = 602882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545854859, ExchCode = 'FRA' WHERE SecCode = 623935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859769368, Ticker = 'SVV1', ExchCode = 'FRA', PermQuoteRetireDate = '2013-04-04' WHERE SecCode = 637382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863402759, Ticker = 'OCSP', ExchCode = 'LSE' WHERE SecCode = 649936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525568986, ExchCode = 'DEU' WHERE SecCode = 692786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962484, ExchCode = 'DEU', PermQuoteRetireDate = '2022-07-22' WHERE SecCode = 696379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287357, ExchCode = 'MEX' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475105966, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532857661, ExchCode = 'TDG' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 862897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 877516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913525, ExchCode = 'DEU' WHERE SecCode = 878880 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 QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388797, ExchCode = 'LAS' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494357256, Ticker = '0HFW', ExchCode = 'LSE', PermQuoteRetireDate = '2013-01-14' WHERE SecCode = 961652 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 QuotePermID = 55860627521, Ticker = 'SEED.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1004402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786274, ExchCode = 'TRQ' WHERE SecCode = 1108496 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 1109069 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22177710975, ExchCode = 'DEU' WHERE SecCode = 1111460 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-02' WHERE SecCode = 1131662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475880904, Ticker = 'S7I', ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-24' WHERE SecCode = 1265673 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 1310375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734632074, ExchCode = 'DEU' WHERE SecCode = 1441088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480912846, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1447851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476159348, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1449053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073457, ExchCode = 'DEU' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478443280, ExchCode = 'FRA' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792391622, ExchCode = 'DUS' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480946905, ExchCode = 'BER', PermQuoteRetireDate = '2013-06-17' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530720649, ExchCode = 'STU' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511374004, ExchCode = 'STU' WHERE SecCode = 1480701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481643753, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673577, ExchCode = 'BIV' WHERE SecCode = 1489564 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 QuotePermID = 21512147101, Ticker = 'BRDG', ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678236, ExchCode = 'BIV' WHERE SecCode = 1518823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270474, ExchCode = 'FRA' WHERE SecCode = 1519143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629706417, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488654213, ExchCode = 'STU', PermQuoteRetireDate = '2022-12-19', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289548, ExchCode = 'DEU' WHERE SecCode = 1524628 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 = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071858, ExchCode = 'TDG' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285816, ExchCode = 'GTX' WHERE SecCode = 1527487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098667, ExchCode = 'FRA' WHERE SecCode = 1527502 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 = 21491111760, ExchCode = 'FRA' WHERE SecCode = 1532859 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 = 21655926838, ExchCode = 'FRA' WHERE SecCode = 1534251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768731396, ExchCode = 'FRA' WHERE SecCode = 1534950 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 = 21494270027, ExchCode = 'DEU' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630031903, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786220381, ExchCode = 'STU' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496860026, ExchCode = 'FRA' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954843, ExchCode = 'LAS' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496616544, ExchCode = 'GER' WHERE SecCode = 1547522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' 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 = 21498230074, ExchCode = 'FRA' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 1555167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498302420, ExchCode = 'DEU' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479129, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-07', PermSecMapEndDate = '2025-11-07' WHERE SecCode = 1564475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502555560, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 1569478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615254983, ExchCode = 'DEU' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503429462, ExchCode = 'FRA' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524608957, ExchCode = 'CHI' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503446729, ExchCode = 'BUR' WHERE SecCode = 1590302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308444, ExchCode = 'STU' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678108, ExchCode = 'BIV' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505186360, ExchCode = 'BUR' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674088, ExchCode = 'BIV' WHERE SecCode = 1597246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504851932, ExchCode = 'DEU' WHERE SecCode = 1597247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505421178, ExchCode = 'STU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505572951, Ticker = NULL, ExchCode = 'ISE', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 1603990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506697417, ExchCode = 'DEU' WHERE SecCode = 1613992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506709402, ExchCode = 'FRA' WHERE SecCode = 1613993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506938763, ExchCode = 'FRA' WHERE SecCode = 1618089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679673, ExchCode = 'BIV' WHERE SecCode = 1621273 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 = 21507477237, ExchCode = 'DEU', PermQuoteRetireDate = '2023-10-09', PermSecMapEndDate = '2023-10-09' WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510896202, ExchCode = 'MUN', PermQuoteRetireDate = '2016-10-25' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509749786, ExchCode = 'STU' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882713778, ExchCode = 'GTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510005786, ExchCode = 'FRA' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629962634, Ticker = '7O2', ExchCode = 'STU' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518456258, ExchCode = 'DEU' WHERE SecCode = 1658177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510433408, ExchCode = 'FRA' WHERE SecCode = 1660578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513064834, Ticker = 'RF2', PermQuoteRetireDate = '2012-11-22', PermSecMapEndDate = '2012-11-08' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828343336, ExchCode = 'QTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776251703, ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-13' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512394339, ExchCode = 'FRA' WHERE SecCode = 1699181 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 = 21515522117, ExchCode = 'DEU' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512769043, ExchCode = 'FRA' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517428536, ExchCode = 'TRQ', PermQuoteRetireDate = '2023-06-22' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513144477, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 1735686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513762717, ExchCode = 'FRA' WHERE SecCode = 1736071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513239137, Ticker = 'BO4', ExchCode = 'DEU' WHERE SecCode = 1740287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 1888517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985521, ExchCode = 'STU', PermQuoteRetireDate = '2015-05-27' WHERE SecCode = 2018342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517582338, ExchCode = 'STU' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517438203, ExchCode = 'DEU', PermQuoteRetireDate = '2021-03-04' WHERE SecCode = 2043507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813394986, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2022-05-09', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2043821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519686237, ExchCode = 'FRA' WHERE SecCode = 2056161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195856, ExchCode = 'FRA' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302126, ExchCode = 'STU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644523837, ExchCode = 'STU' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369367, ExchCode = 'SGO' WHERE SecCode = 2195863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 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 = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306937, ExchCode = 'BEC' WHERE SecCode = 2226896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569830, ExchCode = 'QTX' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563544, ExchCode = 'FRA' WHERE SecCode = 2239343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950995, ExchCode = 'STU' WHERE SecCode = 2255684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524954693, ExchCode = 'FRA' WHERE SecCode = 2267521 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 = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526080169, ExchCode = 'DEU' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854585, ExchCode = 'BER', PermQuoteRetireDate = '2020-12-29' WHERE SecCode = 2288362 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 = 21527944162, ExchCode = 'DEU' WHERE SecCode = 2328684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528038323, ExchCode = 'DEU' WHERE SecCode = 2328686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616157510, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2020-05-07', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2328709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528507836, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045908153, ExchCode = 'MXQ' WHERE SecCode = 2337158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670892655, ExchCode = 'QTX' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662115406, ExchCode = 'FRA' WHERE SecCode = 2339259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676252, ExchCode = 'BIV' WHERE SecCode = 2359427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704335, Ticker = 'BKIAN', ExchCode = 'MXQ' WHERE SecCode = 2361848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530094550, ExchCode = 'MUN' WHERE SecCode = 2362509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780887285, ExchCode = 'CHI' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530485265, ExchCode = 'DEU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308547, ExchCode = 'GTX' 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 = 21532071614, ExchCode = 'MUN' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834662, PermQuoteStatus = 'AC', Ticker = 'C68', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2397376 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 = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847717686, ExchCode = 'GTX' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047304, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2412432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527246, ExchCode = 'FRA' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488232, ExchCode = 'QTX' WHERE SecCode = 2438939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533895781, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-29', PermSecMapEndDate = '2023-12-29' WHERE SecCode = 2450650 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 = 21824100155, ExchCode = 'TDG' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724351602, ExchCode = 'QTX' WHERE SecCode = 2462633 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 = 21550780863, ExchCode = 'FRA' WHERE SecCode = 2470934 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 = 21536675650, ExchCode = 'STU' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536758187, ExchCode = 'DEU' WHERE SecCode = 2490811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535535779, ExchCode = 'BTE', PermQuoteRetireDate = '2014-01-28' WHERE SecCode = 2494242 AND Type_ = 10;
UPDATE data_universe_permid SET 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 = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 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 = 22175073998, ExchCode = 'DEU' WHERE SecCode = 2524752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390630, ExchCode = 'DEU' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531428167, Ticker = NULL, ExchCode = 'BEC' WHERE SecCode = 2524756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521368272, ExchCode = 'SGO' WHERE SecCode = 2524779 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 = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 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 = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909453, ExchCode = 'FRA' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619324261, ExchCode = 'FRA', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430828, ExchCode = 'DEU' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230438, ExchCode = 'FRA' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540108935, ExchCode = 'STU' WHERE SecCode = 2544431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684125, ExchCode = 'STU' WHERE SecCode = 2545058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 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 = 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 = 21562942131, ExchCode = 'TDG' 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 = 21550103570, ExchCode = 'DEU' WHERE SecCode = 2559800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542254187, ExchCode = 'DEU' WHERE SecCode = 2563203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543086077, ExchCode = 'DEU', PermQuoteRetireDate = '2015-06-08' WHERE SecCode = 2566812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660288674, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-13', PermSecMapEndDate = NULL WHERE SecCode = 2568193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542468969, ExchCode = 'MUN' WHERE SecCode = 2568208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542602134, ExchCode = 'DEU' WHERE SecCode = 2572311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679709, ExchCode = 'BIV' WHERE SecCode = 2572313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679650, ExchCode = 'BIV' WHERE SecCode = 2572314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679316, ExchCode = 'BIV' WHERE SecCode = 2572315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673451, ExchCode = 'BIV' WHERE SecCode = 2572318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679345, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2572322 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 = 21543007213, ExchCode = 'MUN' WHERE SecCode = 2579447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430409, ExchCode = 'DEU' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708914, ExchCode = 'DEU' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544213987, ExchCode = 'TDG', PermQuoteRetireDate = '2020-05-26' WHERE SecCode = 2593544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726151, ExchCode = 'DEU' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067641916, ExchCode = 'BCO' WHERE SecCode = 2600378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545105822, ExchCode = 'FRA' WHERE SecCode = 2604390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21662661878, ExchCode = 'MUN' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624665037, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547157215, ExchCode = 'DEU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548007507, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2640373 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 = 236777359766, ExchCode = 'STU' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561270622, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-12' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184279, ExchCode = 'MUN' WHERE SecCode = 2644157 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 = 21587934135, ExchCode = 'FRA' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 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 = 21761648844, ExchCode = 'STU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549921078, ExchCode = 'BTE' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550408230, ExchCode = 'DEU' 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 = 21667704217, ExchCode = 'MXQ' WHERE SecCode = 2682301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623807327, ExchCode = 'MUN' WHERE SecCode = 2682326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817233541, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-11-30' WHERE SecCode = 2685345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550999191, ExchCode = 'FRA' WHERE SecCode = 2688194 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 QuotePermID = 21550836222, ExchCode = 'FRA' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550906456, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2693655 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697251 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551797405, Ticker = 'CBKDe', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2706343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552459618, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552380654, InstrPermID = 21550657515, OrgPermID = 5044031864, ValQuotePermID = 21551043677.0, PriInstrPermID = 21550657515.0, PermQuoteStatus = 'DC', Ticker = '3RM0', ExchCode = 'BER', OrgTypeCode = 'CINV', DomCntry = 'GGY', IncCntry = 'GGY', PriTRBCIndPermID = 4294951307.0, PermQuoteRetireDate = '2026-01-01', PermOrgIPODate = '2014-12-02' WHERE SecCode = 2718429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661562372, Ticker = 'SREn', ExchCode = 'BCO' WHERE SecCode = 2718458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552460326, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 2718461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534967, ExchCode = 'MUN' WHERE SecCode = 2718469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802207749, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2720688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687496, PermQuoteStatus = 'DC', Ticker = '5WP', ExchCode = 'GER', PermQuoteRetireDate = '2017-01-03' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890060428, ExchCode = 'MXQ' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554503916, ExchCode = 'DEU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322234, Ticker = 'IDV1', ExchCode = 'FRA' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322223, ExchCode = 'FRA' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589734, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-25' WHERE SecCode = 2837420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598465846, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569832692, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-03' WHERE SecCode = 2880970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562688444, ExchCode = 'FRA' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563614493, ExchCode = 'STU' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679558, ExchCode = 'BIV' WHERE SecCode = 2884583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180586, ExchCode = 'DEU' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563120175, ExchCode = 'FRA' WHERE SecCode = 2887282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563723385, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-22', PermSecMapEndDate = '2026-03-16' WHERE SecCode = 2887311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, Ticker = 'SX7EEz', ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864729, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564237670, ExchCode = 'DEU' WHERE SecCode = 2902829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564236909, ExchCode = 'FRA' WHERE SecCode = 2904303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077770, ExchCode = 'LAS' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564679404, ExchCode = 'FRA' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564682992, ExchCode = 'FRA', PermQuoteRetireDate = '2025-10-22', PermSecMapEndDate = '2025-10-22' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520546, ExchCode = 'DUS' WHERE SecCode = 2920448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793397053, ExchCode = 'DEU', PermQuoteRetireDate = '2021-03-22' WHERE SecCode = 2920449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566250487, ExchCode = 'FRA' WHERE SecCode = 2920460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623096, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566885263, ExchCode = 'DEU' WHERE SecCode = 2921713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566817654, ExchCode = 'FRA' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891239, ExchCode = 'STU' 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 = 21569900890, ExchCode = 'STU' WHERE SecCode = 2956411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488199, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787393, ExchCode = 'DUS' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585829107, PermQuoteStatus = 'AC', Ticker = 'IWIA', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21577065557, ExchCode = 'DEU' WHERE SecCode = 3038439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578277706, ExchCode = 'DEU' WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478422, ExchCode = 'QTX' WHERE SecCode = 3053523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611487587, ExchCode = 'FRA' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264715, ExchCode = 'MUN', PermQuoteRetireDate = '2022-03-15', PermSecMapEndDate = NULL WHERE SecCode = 3090272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584407883, ExchCode = 'DEU' WHERE SecCode = 3119784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21629379834.0, PriInstrPermID = 21855801985.0, IsPrimaryQuote = 1, IsPrimaryInstr = 0 WHERE SecCode = 3145314 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 3145981 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 3145982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830304791, ExchCode = 'GTX' WHERE SecCode = 3145983 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 3151897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589578727, ExchCode = 'STU' WHERE SecCode = 3162853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705845, ExchCode = 'MXQ' WHERE SecCode = 3166848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860501, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3169823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492372, ExchCode = 'QTX' WHERE SecCode = 3184009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705596, ExchCode = 'MXQ' WHERE SecCode = 3184036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825337729, Ticker = '3EML.GB', ExchCode = 'AQS' WHERE SecCode = 3193773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 QuotePermID = 21590446182, ExchCode = 'DEU' WHERE SecCode = 3200605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028891006, ExchCode = 'STU' WHERE SecCode = 3200981 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 3211130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678205, ExchCode = 'BIV' WHERE SecCode = 3211298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591294643, ExchCode = 'MUN' WHERE SecCode = 3211299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485239, Ticker = '1DB1' WHERE SecCode = 3211322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485236, Ticker = '1CON' WHERE SecCode = 3211325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077242, ExchCode = 'LAS' WHERE SecCode = 3219367 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 = 21953914326, ExchCode = 'GTX' WHERE SecCode = 3221850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609921006, ExchCode = 'STU' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21686043794, Ticker = NULL, ExchCode = 'TRQ', PermQuoteRetireDate = '2019-07-01' WHERE SecCode = 3223354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3228617 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 = 21594293250, ExchCode = 'DEU' WHERE SecCode = 3232615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594293022, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-05' WHERE SecCode = 3232617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787711120, Ticker = '1CBKm', ExchCode = 'BCO' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597399146, ExchCode = 'FRA' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597335837, ExchCode = 'DEU' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597328149, ExchCode = 'MUN' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621641, ExchCode = 'DEU' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598615492, ExchCode = 'STU', PermQuoteRetireDate = '2016-11-08' WHERE SecCode = 3260094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800109, ExchCode = 'BTE' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640216643, ExchCode = 'TDG' WHERE SecCode = 3263894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647013837, ExchCode = 'BCO' WHERE SecCode = 3275560 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277163 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755977768, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3282701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119327, ExchCode = 'BER' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611219951, ExchCode = 'MUN', PermQuoteRetireDate = '2017-12-22' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598843081, ExchCode = 'MEX' WHERE SecCode = 3302683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379972, ExchCode = 'FRA' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645775, ExchCode = 'FRA' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912102337, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610964345, ExchCode = 'STU' WHERE SecCode = 3322810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 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 = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705783, ExchCode = 'MXQ' WHERE SecCode = 3358492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3372300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743475404, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3378582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765833817, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675034, ExchCode = 'BIV' WHERE SecCode = 3379627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029271, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-07-04' WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679320, ExchCode = 'BIV' WHERE SecCode = 3395773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623932334, ExchCode = 'TRQ', PermQuoteRetireDate = '2019-10-10' WHERE SecCode = 3395860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764861300, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01', PermSecMapEndDate = '2021-10-01' WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790762, ExchCode = 'CHI' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629642715, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3407252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 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 = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633327894, ExchCode = 'STU' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664959898, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2026-01-29' 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 = 21656674899, ExchCode = 'BIV' WHERE SecCode = 3430658 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 3431767 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3431812 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 3432892 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3433276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21741583893, ExchCode = 'TDG' WHERE SecCode = 3435445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679515, ExchCode = 'BIV' WHERE SecCode = 3439528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673859, ExchCode = 'BIV' WHERE SecCode = 3439529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640560144, ExchCode = 'DEU' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648039735, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647633189, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3491217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 3506637 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 3508356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650788270, Ticker = NULL, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651518719, ExchCode = 'BER' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 3519865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651601869, Ticker = '1Y1', ExchCode = 'BER', PermQuoteRetireDate = '2019-11-19' WHERE SecCode = 3520001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645825, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-01', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947471, ExchCode = 'DEU' WHERE SecCode = 3526199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757243010, ExchCode = 'STU' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753145831, ExchCode = 'BCO' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166737, ExchCode = 'DEU' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872575770, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3553157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624891, Ticker = 'CSC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609269239, ExchCode = 'DEU' WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665422440, Ticker = 'NBPU', ExchCode = 'LSE' WHERE SecCode = 3616805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 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 = 21675091688, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114234, ExchCode = 'DEU' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727384183, ExchCode = 'MEX' WHERE SecCode = 3717243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453299, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' 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 = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688529457, ExchCode = 'MUN' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3814100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196448, ExchCode = 'DUS' WHERE SecCode = 3818674 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 = 21694235031, ExchCode = 'FRA' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789360051, ExchCode = 'FRA' WHERE SecCode = 3837309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367137, PermQuoteStatus = 'AC', Ticker = '2ZT1', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 3845928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767399333, ExchCode = 'MUN' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 3862209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245385, ExchCode = 'DEU' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153752, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 3877686 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 = 25727368208, ExchCode = 'BIV' WHERE SecCode = 3890234 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 DomCntry = 'CHN' WHERE SecCode = 3956854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186483, ExchCode = 'DEU' WHERE SecCode = 3997065 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 = 22028682767, Ticker = '2BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044966173, Ticker = '2BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725610718, ExchCode = 'DEU' WHERE SecCode = 4043316 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4054210 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 = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766439763, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, Ticker = '4U1', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = '2025-04-01' WHERE SecCode = 4212367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350455, ExchCode = 'MEX' WHERE SecCode = 4212368 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 = 21754377772, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4243768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 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 QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580130, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489973, ExchCode = 'FRA' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765301520, ExchCode = 'DUS' WHERE SecCode = 4334568 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 4335842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773404609, ExchCode = 'FRA' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774624846, ExchCode = 'STU' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960077472, ExchCode = 'GTX' WHERE SecCode = 4380746 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 QuotePermID = 21778893562, ExchCode = 'FRA', PermQuoteRetireDate = '2020-11-17' WHERE SecCode = 4400157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779363671, ExchCode = 'FRA' WHERE SecCode = 4402245 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 QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 4425521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833140761, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-26' WHERE SecCode = 4434385 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 4437264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787491381, ExchCode = 'BER', PermQuoteRetireDate = '2021-01-05' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787035686, ExchCode = 'FRA' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791469822, ExchCode = 'DUS' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801059554, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4487598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781361764, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395163, ExchCode = 'FRA' WHERE SecCode = 4593306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815952112, ExchCode = 'FRA' WHERE SecCode = 4607713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842017348, ExchCode = 'BCO' WHERE SecCode = 4608547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037649, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4610043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800012350, ExchCode = 'LAS' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, Ticker = '4KL0', ExchCode = 'DEU' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799608110, ExchCode = 'LAS' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073655, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-22', PermSecMapEndDate = '2025-12-22' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824693646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831908634, ExchCode = 'GTX' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996699, ExchCode = 'LAS' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833145669, ExchCode = 'FRA' WHERE SecCode = 4677605 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '9KK0' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244578, ExchCode = 'BIV' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873118953, Ticker = 'CARBm', ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244579, ExchCode = 'MEX' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848717895, ExchCode = 'STU' 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 = 21840890512, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4709616 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 4713802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915272, ExchCode = 'STU' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845535652, ExchCode = 'FRA' WHERE SecCode = 4726104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845534968, ExchCode = 'MUN' WHERE SecCode = 4726105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845814031, ExchCode = 'HAM' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4726110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158672, ExchCode = 'FRA' WHERE SecCode = 4748566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854895784, ExchCode = 'FRA' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4770126 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0, IsPrimaryInstr = 1 WHERE SecCode = 4773624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789996081, ExchCode = 'LAS' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861532579, ExchCode = 'GTX' WHERE SecCode = 4802327 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4804576 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 = 21861539819, ExchCode = 'SWX' WHERE SecCode = 4809017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861540289, ExchCode = 'SWX' WHERE SecCode = 4809026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627738, ExchCode = 'QTX' WHERE SecCode = 4813698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380493, ExchCode = 'LAS' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873923001, ExchCode = 'DUS' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487241, ExchCode = 'FRA' WHERE SecCode = 4845067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869360768, ExchCode = 'QTX' WHERE SecCode = 4847005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 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 = 21907898654, ExchCode = 'FRA' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 4943229 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 4943230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 4960861 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 4960862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716228, ExchCode = 'DEU' WHERE SecCode = 4960863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885992168, ExchCode = 'FRA' WHERE SecCode = 4960864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727205517, ExchCode = 'MEX' WHERE SecCode = 4962789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888036745, ExchCode = 'MUN' WHERE SecCode = 4969368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907555781, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4969375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886193164, ExchCode = 'FRA' WHERE SecCode = 4969376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314817, ExchCode = 'OCE' WHERE SecCode = 4969408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066264784, ExchCode = 'CHI' WHERE SecCode = 4969409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 4975859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933953328, ExchCode = 'STU' 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 = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777464944, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951572.0 WHERE SecCode = 5067185 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-02' WHERE SecCode = 5067274 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 = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777145391, ExchCode = 'STU' WHERE SecCode = 5082548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171459490, ExchCode = 'DEU' WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292273, ExchCode = 'FRA' WHERE SecCode = 5129738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797935268, ExchCode = 'MUN' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 5161224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 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 = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 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 PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 5168259 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 = 22105049597, ExchCode = 'MXQ' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783133624, ExchCode = 'TDG' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919819094, ExchCode = 'MXQ' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 5272182 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 5272183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 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 = 236777397462, ExchCode = 'BTE' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948097719, ExchCode = 'DEU' WHERE SecCode = 5329497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950823856, ExchCode = 'FRA' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953963626, ExchCode = 'MUN' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776504665, ExchCode = 'MEX' WHERE SecCode = 5354969 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5360702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957797642, ExchCode = 'DEU' WHERE SecCode = 5374832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957768163, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07' WHERE SecCode = 5374833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028052111, ExchCode = 'DEU' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716915, ExchCode = 'DEU' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156624, ExchCode = 'FRA' WHERE SecCode = 5402859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359860, ExchCode = 'FRA' WHERE SecCode = 5413669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829302, ExchCode = 'TDG' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 5418807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299986, ExchCode = 'FRA' WHERE SecCode = 5468673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5488027 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 5507448 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 5507449 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 5509412 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0 WHERE SecCode = 5509413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779256326, ExchCode = 'MEX' WHERE SecCode = 5531898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 5569319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, PermQuoteStatus = 'DC', Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530266, ExchCode = 'DEU' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780192624, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781224681, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 5635820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637484538, ExchCode = 'DEU' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010677492, ExchCode = 'DEU' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476048637, PermQuoteStatus = 'AC', Ticker = 'N8I', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781580951, ExchCode = 'MUN' WHERE SecCode = 5663512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781981056, ExchCode = 'BIV' WHERE SecCode = 5701235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795035307, ExchCode = 'GTX' WHERE SecCode = 5706779 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000126069, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5717755 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000084183, PriInstrPermID = 232932732631.0, IsPrimaryInstr = 0, DomCntry = 'SWE', IncCntry = 'SWE', PriTRBCIndPermID = 4294951328.0, PermOrgIPODate = '2026-05-20' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782771597, ExchCode = 'FRA' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928831, Ticker = 'SOXLm', ExchCode = 'BCO' WHERE SecCode = 5740824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928832, Ticker = 'MAG7m', ExchCode = 'BCO' WHERE SecCode = 5740826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690921, ExchCode = 'BCO' WHERE SecCode = 5740827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 5740830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246014, ExchCode = 'BTE' WHERE SecCode = 5740832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5742856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810015, ExchCode = 'FRA' WHERE SecCode = 5745661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810012, ExchCode = 'FRA' WHERE SecCode = 5745662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810016, ExchCode = 'FRA' WHERE SecCode = 5745663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782810019, ExchCode = 'FRA' WHERE SecCode = 5745664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783009907, ExchCode = 'STU' WHERE SecCode = 5758113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812186220, ExchCode = 'FRA' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040671244, ExchCode = 'MUN' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783330017, ExchCode = 'FRA' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329733, ExchCode = 'FRA' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353647, ExchCode = 'FRA' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353632, ExchCode = 'FRA' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353639, ExchCode = 'FRA' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783933614, ExchCode = 'FRA' WHERE SecCode = 5807637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783933611, ExchCode = 'FRA' WHERE SecCode = 5807638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783934287, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 5807639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 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 = 21735452563, ExchCode = 'DEU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534037, ExchCode = 'FRA' WHERE SecCode = 5890417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786957574, ExchCode = 'GTX' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786091052, ExchCode = 'FRA' WHERE SecCode = 5914176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784315649, ExchCode = 'MEX' WHERE SecCode = 5917882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666337, ExchCode = 'CHI' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061296562, ExchCode = 'STU' WHERE SecCode = 5920851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790682427, PermQuoteStatus = 'DC', Ticker = '83W0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664145, ExchCode = 'BIV' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 6030695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682858978, ExchCode = 'FRA' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV' WHERE SecCode = 6097383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536624, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836167, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097408 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 = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21972857485, ExchCode = 'MXQ' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 6097473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 6097549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22026330416, ExchCode = 'MXQ' 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 = 236790015578, ExchCode = 'FRA' WHERE SecCode = 6104635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22084430796, ExchCode = 'LAS' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790713136, ExchCode = 'FRA' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790713137, ExchCode = 'FRA' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790758447, ExchCode = 'FRA' WHERE SecCode = 6153962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790761386, ExchCode = 'FRA' WHERE SecCode = 6153964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791108496, ExchCode = 'FRA' WHERE SecCode = 6177691 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'A7F0' WHERE SecCode = 6205894 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 6263971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22101573233, ExchCode = 'DEU' WHERE SecCode = 6278719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792547775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 6278721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801198790, ExchCode = 'MUN' WHERE SecCode = 6285590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792866696, ExchCode = 'FRA' WHERE SecCode = 6303058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796057730, ExchCode = 'GTX' WHERE SecCode = 6448294 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 21855801985.0, IsPrimaryInstr = 1 WHERE SecCode = 6448298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727129435, OrgPermID = 6000126069, Ticker = 'CCLD', IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = '2026-06-02' WHERE SecCode = 6451085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796026166, ExchCode = 'FRA' WHERE SecCode = 6457997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111163, ExchCode = 'DEU' WHERE SecCode = 6515942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743592, ExchCode = 'DUS' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 6552335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800220684, InstrPermID = 232937851337, ValQuotePermID = 236800220684.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-12-08', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6569505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800095947, ExchCode = 'TDG' WHERE SecCode = 6590583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800229527, ExchCode = 'DUS' WHERE SecCode = 6590619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955089, ExchCode = 'MEX' WHERE SecCode = 6590630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800658724, ExchCode = 'QTX' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134134351, ExchCode = 'STU' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778200748, ExchCode = 'FRA' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607867, ExchCode = 'TDG' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801914263, ExchCode = 'FRA' WHERE SecCode = 6628800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184177632, ExchCode = 'SWX' WHERE SecCode = 6649326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176660, ExchCode = 'SWX' WHERE SecCode = 6649337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176722, ExchCode = 'SWX' WHERE SecCode = 6649338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176771, ExchCode = 'SWX' WHERE SecCode = 6649358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176630, ExchCode = 'SWX' WHERE SecCode = 6649373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176616, ExchCode = 'SWX' WHERE SecCode = 6649374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176603, ExchCode = 'SWX' WHERE SecCode = 6649375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176820, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 6649456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176889, Ticker = 'ETHW', ExchCode = 'SWX' WHERE SecCode = 6649457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802807019, ExchCode = 'MEX' WHERE SecCode = 6664680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914563, ExchCode = 'FRA' WHERE SecCode = 6664705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47763436106, ExchCode = 'DEU' WHERE SecCode = 6664706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914867, ExchCode = 'FRA' WHERE SecCode = 6664707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771519, ExchCode = 'FRA' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803452374, ExchCode = 'FRA' WHERE SecCode = 6686515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803452375, ExchCode = 'FRA' WHERE SecCode = 6686516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184177594, ExchCode = 'SWX' WHERE SecCode = 6719144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804998607, ExchCode = 'QTX' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901582, ExchCode = 'BTE' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 6797301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806019660, ExchCode = 'BIV' WHERE SecCode = 6797367 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 6802647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524855, ExchCode = 'DEU' WHERE SecCode = 6808918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806640335, ExchCode = 'FRA' WHERE SecCode = 6829248 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 6849874 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-02' WHERE SecCode = 6854791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176694, ExchCode = 'SWX' WHERE SecCode = 6862192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181328620, ExchCode = 'DEU' WHERE SecCode = 6868227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181330577, ExchCode = 'DEU' WHERE SecCode = 6868229 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6873666 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6880256 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6882168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782487, ExchCode = 'FRA' WHERE SecCode = 6887871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782485, ExchCode = 'FRA' WHERE SecCode = 6887874 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6887878 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10814088 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11003221 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'KPEAD' WHERE SecCode = 11003802 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 11071267 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11131010 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-01', PermSecMapEndDate = NULL WHERE SecCode = 11136222 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 11158359 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 11158360 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 11158411 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-01', PermSecMapEndDate = NULL WHERE SecCode = 11211909 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11222147 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'VSXY' WHERE SecCode = 11227624 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FROG' WHERE SecCode = 11234647 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11236863 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 11244984 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 11254409 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 11256494 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 11256495 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11264398 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11265202 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11267533 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11268849 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11269037 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000127426, IncCntry = 'USA', PriTRBCIndPermID = 4294951176.0 WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02' WHERE SecCode = 11272450 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11275764 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11276055 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11276222 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11276223 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11276468 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11276469 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11276668 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11277467 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11277468 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11277560 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11277822 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11278112 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11278549 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11278632 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11278633 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11278634 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11279154 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11279661 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11279822 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11280056 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11280348 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11280558 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11281735 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11286187 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11286781 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11288403 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11288922 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11288923 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11288924 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11288925 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11288928 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11288938 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11289210 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11289271 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11289699 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11291296 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11294054 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11294715 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11295111 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-02', PermSecMapEndDate = '2026-06-02' WHERE SecCode = 11295273 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11295337 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11296310 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NVRI' WHERE SecCode = 11296509 AND Type_ = 1;
