UPDATE data_universe_permid SET QuotePermID = 236796141212, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'SIG', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531115997, Ticker = '77GEl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-07-09' WHERE SecCode = 971 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 5705 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 9345 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 12664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475732357, Ticker = 'KTCD.I', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 29200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836051372, Ticker = 'DATA', ExchCode = 'LSE', PermQuoteRetireDate = '2010-10-22' WHERE SecCode = 31747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838693553, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-12' WHERE SecCode = 34018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837359994, Ticker = 'RI7', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332477, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034761, PermQuoteStatus = 'AC', Ticker = 'ALD', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475645962, ExchCode = 'CXE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 34346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836322896, ExchCode = 'BER', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 34403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 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 = 21475796042, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2013-08-15', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 35064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033945, PermQuoteStatus = 'AC', Ticker = 'BYG', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 35163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836326453, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-28' WHERE SecCode = 35663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492550, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 35746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475586089, PermQuoteStatus = 'DC', Ticker = 'CPAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034280, PermQuoteStatus = 'AC', Ticker = 'WDP', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 38154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522215185, ExchCode = 'MUN' WHERE SecCode = 38197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475622710, PermQuoteStatus = 'DC', Ticker = 'DSEG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 38247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838403123, ExchCode = 'STU' WHERE SecCode = 48327 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-14' WHERE SecCode = 49967 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837352812, ExchCode = 'GER' WHERE SecCode = 60008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323453, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 60059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836386338, ExchCode = 'FRA' WHERE SecCode = 60097 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384920, ExchCode = 'LAS' WHERE SecCode = 60111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296902, ExchCode = 'GTX' WHERE SecCode = 60119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790265006, ExchCode = 'TDG' WHERE SecCode = 60130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837358975, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485991, ExchCode = 'QTX' WHERE SecCode = 60403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293911, ExchCode = 'GTX' WHERE SecCode = 60416 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836340932, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 60564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852348972, ExchCode = 'FRA' WHERE SecCode = 60667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836555411, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 60831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489833, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 61651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836523649, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-22' WHERE SecCode = 62115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836325360, PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 62125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301685, ExchCode = 'GTX' WHERE SecCode = 62144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474862261, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 65643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525212599, ExchCode = 'DEU', PermQuoteRetireDate = '2020-03-20' WHERE SecCode = 65700 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 83994 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-05-12', PermSecMapEndDate = NULL WHERE SecCode = 85870 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-12' WHERE SecCode = 87204 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-14' WHERE SecCode = 88770 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 97949 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU' WHERE SecCode = 100032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667490953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-20' WHERE SecCode = 100052 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521652536, ExchCode = 'BER' WHERE SecCode = 103792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914302350, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 103840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520627613, ExchCode = 'DEU' WHERE SecCode = 103841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528804114, ExchCode = 'STU' WHERE SecCode = 103863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475499886, ExchCode = 'GER' WHERE SecCode = 103891 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569056620, ExchCode = 'MUN' WHERE SecCode = 103894 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 112217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298391, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL 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 = 55836390769, ExchCode = 'FRA' WHERE SecCode = 133773 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 = 21540736583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141439 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-12' WHERE SecCode = 143572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 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 = 236806952023, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 154111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'NI80' WHERE SecCode = 178085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 193829 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 200890 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 200964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825618068, ExchCode = 'DEU' WHERE SecCode = 249708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836435377, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 291628 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419441, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 300181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585032919, ExchCode = 'BCO' WHERE SecCode = 309897 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 316073 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 318002 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 334705 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21825607959, ExchCode = 'MUN' WHERE SecCode = 345429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538768103, Ticker = 'CAZAl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-08-24' WHERE SecCode = 345783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116848257, ExchCode = 'DEU' WHERE SecCode = 345843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895997542, ExchCode = 'DEU' WHERE SecCode = 345850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22159147457, ExchCode = 'DEU' WHERE SecCode = 345851 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419443, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 348130 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 353989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288726, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 363732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837351799, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837351233, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368808 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840949533, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 368820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836322712, ExchCode = 'BER' WHERE SecCode = 383000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840770489, ExchCode = 'BER', PermQuoteRetireDate = '2023-11-23', PermSecMapEndDate = '2023-11-23' WHERE SecCode = 384412 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685431734, ExchCode = 'DEU' WHERE SecCode = 401619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841617044, ExchCode = 'FRA' WHERE SecCode = 401621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842464917, Ticker = '1ENGI' WHERE SecCode = 408548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528679708, ExchCode = 'DEU' WHERE SecCode = 428335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396938, ExchCode = 'DEU' WHERE SecCode = 428966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21600289193, ExchCode = 'DUS', PermQuoteRetireDate = '2023-12-15', PermSecMapEndDate = NULL WHERE SecCode = 438364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22118826258, ExchCode = 'SIG' WHERE SecCode = 464174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847185526, Ticker = '0AO', ExchCode = 'BER', PermQuoteRetireDate = '2021-11-23' WHERE SecCode = 479615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847545159, ExchCode = 'BER', PermQuoteRetireDate = '2018-09-21', PermSecMapEndDate = '2018-09-21' WHERE SecCode = 484246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' WHERE SecCode = 508999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849615524, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 512041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849681521, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 514961 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492958, ExchCode = 'QTX' WHERE SecCode = 515043 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 518549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920961818, ExchCode = 'FRA' WHERE SecCode = 519511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805519519, ExchCode = 'MUN', PermQuoteRetireDate = '2025-10-24' WHERE SecCode = 527096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640210344, ExchCode = 'BCO', PermQuoteRetireDate = '2020-08-17' WHERE SecCode = 529911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476991388, ExchCode = 'TDG' WHERE SecCode = 538783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852995454, ExchCode = 'FRA' WHERE SecCode = 548626 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825883651, ExchCode = 'TDG' WHERE SecCode = 548782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853076828, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 549287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859092912, ExchCode = 'FRA' WHERE SecCode = 551262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850857947, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 553921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550981295, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 556230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474957849, ExchCode = 'DEU' WHERE SecCode = 557818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575565347, ExchCode = 'STU', PermQuoteRetireDate = '2018-04-26' WHERE SecCode = 560723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565562407, ExchCode = 'SGO' WHERE SecCode = 561528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254162, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 564417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475108946, ExchCode = 'STU' WHERE SecCode = 565316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857657672, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 565330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475805335, PermQuoteStatus = 'DC', Ticker = 'OAA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 565752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857579082, ExchCode = 'FRA' WHERE SecCode = 565861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857541012, ExchCode = 'FRA' WHERE SecCode = 565866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857958579, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 567636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475127703, ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-20' WHERE SecCode = 591764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293928, InstrPermID = 8591391476, OrgPermID = 5000663094, ValQuotePermID = 55858425773.0, PriInstrPermID = 8591391476.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ANK', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermOrgIPODate = '2010-04-01' WHERE SecCode = 601515 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22132756017, ExchCode = 'STO' WHERE SecCode = 602882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55863112368, Ticker = 'BABC.GB', ExchCode = 'PLU' WHERE SecCode = 703518 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 772343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475136959, ExchCode = 'DEU' WHERE SecCode = 858901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830275427, ExchCode = 'GTX' WHERE SecCode = 881802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22103473248, ExchCode = 'DEU' WHERE SecCode = 882870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 948508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475769668, Ticker = 'TYM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 995830 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 997772 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 1013085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625073340, ExchCode = 'FRA' WHERE SecCode = 1453709 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770742468, ExchCode = 'HAN' WHERE SecCode = 1472577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21481705363, ExchCode = 'DEU' WHERE SecCode = 1485688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704200, ExchCode = 'MXQ' WHERE SecCode = 1489564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514028112, ExchCode = 'TDG' WHERE SecCode = 1522268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152677, ExchCode = 'MUN' WHERE SecCode = 1527486 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480768, ExchCode = 'QTX' WHERE SecCode = 1532769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529849881, Ticker = 'RBT', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1533786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21499307444, Ticker = '5GQ', ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 1554222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502555109, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 1555433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-12' WHERE SecCode = 1571280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21503838088, ExchCode = 'BER', PermQuoteRetireDate = '2017-05-30' WHERE SecCode = 1587478 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21505184781, ExchCode = 'STO' WHERE SecCode = 1596529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667493518, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 1630461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100401, ExchCode = 'QTX' WHERE SecCode = 1651406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' WHERE SecCode = 1655572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633835904, Ticker = '7O2d', ExchCode = 'BCO' WHERE SecCode = 1656414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320060, ExchCode = 'DEU' WHERE SecCode = 1675781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522286896, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 1675785 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21504836182, Ticker = 'CHMT', ExchCode = 'PAR', PermQuoteRetireDate = '2017-04-25' WHERE SecCode = 1677246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799113029, ExchCode = 'LAS' WHERE SecCode = 1694101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795183066, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-18' WHERE SecCode = 1696044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512395856, ExchCode = 'DEU' WHERE SecCode = 1699181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685426483, ExchCode = 'MUN' WHERE SecCode = 1707747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641955269, ExchCode = 'FRA' WHERE SecCode = 1707749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' 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 = 21528495416, ExchCode = 'CHI', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1722300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513762821, ExchCode = 'DEU' WHERE SecCode = 1736071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514707492, ExchCode = 'DEU' 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 = 21538295458, ExchCode = 'DEU' WHERE SecCode = 1768937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681116521, ExchCode = 'DEU' WHERE SecCode = 1795399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585027678, ExchCode = 'CHI' WHERE SecCode = 1931297 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 1973328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517016445, ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 2018342 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2065783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781607386, ExchCode = 'QTX' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604521803, Ticker = '4BB', ExchCode = 'MUN', PermQuoteRetireDate = '2019-01-10' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530255542, ExchCode = 'DEU' WHERE SecCode = 2357967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529795323, ExchCode = 'STU' WHERE SecCode = 2357969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530042418, ExchCode = 'DEU' WHERE SecCode = 2357974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726959, ExchCode = 'GTX' WHERE SecCode = 2425600 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 = 21667704199, ExchCode = 'MXQ' WHERE SecCode = 2455541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798387416, ExchCode = 'HAM' WHERE SecCode = 2518731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696140082, ExchCode = 'QTX' WHERE SecCode = 2522906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792808948, ExchCode = 'FRA' WHERE SecCode = 2568912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542889448, ExchCode = 'MUN', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 2578855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662105437, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2604394 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 = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 2809881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589220365, ExchCode = 'DEU', PermQuoteRetireDate = '2019-04-05' WHERE SecCode = 2855771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21577065352, ExchCode = 'DEU' WHERE SecCode = 2887226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21567104630, InstrPermID = 21575328144, OrgPermID = 5093618813, ValQuotePermID = 21575328161.0, PriInstrPermID = 21575328144.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '1AL', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermOrgIPODate = '2015-07-06' WHERE SecCode = 2939990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460750, Ticker = 'OD7I', ExchCode = 'FRA' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581022607, ExchCode = 'DEU' WHERE SecCode = 3083484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582352174, ExchCode = 'FRA' WHERE SecCode = 3085564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22164689309, ExchCode = 'GTX' WHERE SecCode = 3121289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045077929, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2026-04-17' WHERE SecCode = 3121290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544712, ExchCode = 'QTX' WHERE SecCode = 3125957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901754747, ExchCode = 'BCO' WHERE SecCode = 3193718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796870260, ExchCode = 'DUS' WHERE SecCode = 3195401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460804, ExchCode = 'GER' WHERE SecCode = 3195424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460787, ExchCode = 'GER' WHERE SecCode = 3195425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460803, ExchCode = 'GER' WHERE SecCode = 3195426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608121119, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3196346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU', PermSecMapEndDate = NULL WHERE SecCode = 3198718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-01' WHERE SecCode = 3199703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962344738, Ticker = '1VOW3m', ExchCode = 'BTE' WHERE SecCode = 3212165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591801382, ExchCode = 'BER' WHERE SecCode = 3212190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801449069, ExchCode = 'DEU' WHERE SecCode = 3213266 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714016577, ExchCode = 'MUN' WHERE SecCode = 3215534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 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 = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788491422, Ticker = '0EFd', ExchCode = 'BCO' WHERE SecCode = 3246454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100768, ExchCode = 'DUS' WHERE SecCode = 3247170 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824694891, ExchCode = 'DUS' WHERE SecCode = 3247179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21995867781, ExchCode = 'TRQ' WHERE SecCode = 3275560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856729928, PermQuoteStatus = 'AC', Ticker = 'SLYG', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3280089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21603342349, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3283956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21638239121, ExchCode = 'BTE' WHERE SecCode = 3301720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152594, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3301805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606894640, ExchCode = 'BCO' WHERE SecCode = 3304228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798239844, ExchCode = 'TDG' WHERE SecCode = 3305420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705763, ExchCode = 'MXQ' WHERE SecCode = 3309397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786016615, ExchCode = 'FRA' WHERE SecCode = 3315780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786651644, ExchCode = 'QTX' WHERE SecCode = 3317115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609137333, ExchCode = 'DEU' WHERE SecCode = 3317384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766138099, ExchCode = 'STU' WHERE SecCode = 3317714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609619284, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 3318127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378734, ExchCode = 'GTX' WHERE SecCode = 3318532 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610682901, Ticker = 'VEONa', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830286060, ExchCode = 'GTX' WHERE SecCode = 3320207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644443154, ExchCode = 'DEU' WHERE SecCode = 3320334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610964345, ExchCode = 'STU' WHERE SecCode = 3322810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297854, ExchCode = 'DUS' WHERE SecCode = 3327824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643067252, ExchCode = 'TDG' WHERE SecCode = 3339668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781627693, ExchCode = 'QTX' WHERE SecCode = 3346903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011382, Ticker = '2PSM', ExchCode = 'MIL' WHERE SecCode = 3347660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678608, ExchCode = 'BIV' WHERE SecCode = 3357133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805177378, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3357940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791141188, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3357943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705302, ExchCode = 'MXQ' WHERE SecCode = 3358164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21635385247, PermQuoteStatus = 'DC', ExchCode = 'BTE', PermQuoteRetireDate = '2026-04-27' WHERE SecCode = 3358228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627369817, ExchCode = 'BCO' WHERE SecCode = 3358414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705783, ExchCode = 'MXQ' WHERE SecCode = 3358492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308435, ExchCode = 'GTX' WHERE SecCode = 3358543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761303085, ExchCode = 'STU' WHERE SecCode = 3358616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011585, Ticker = '2EVK', ExchCode = 'MIL' WHERE SecCode = 3358919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22098742116, ExchCode = 'DXE' WHERE SecCode = 3359183 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781627708, ExchCode = 'QTX' WHERE SecCode = 3367946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482433, ExchCode = 'QTX' WHERE SecCode = 3377762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301079, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3378582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647732131, ExchCode = 'STU' WHERE SecCode = 3378583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704293, ExchCode = 'MXQ' WHERE SecCode = 3379186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770742595, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2020-09-22' WHERE SecCode = 3382234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650357, ExchCode = 'QTX' WHERE SecCode = 3392279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727378644, ExchCode = 'BRN' WHERE SecCode = 3393999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805094957, ExchCode = 'FRA' WHERE SecCode = 3395352 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'LKFT' WHERE SecCode = 3395577 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 3396657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709687548, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-13' WHERE SecCode = 3396885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334945, ExchCode = 'FRA' WHERE SecCode = 3396923 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 3397915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21908261084, Ticker = '1FBm', ExchCode = 'EQD' WHERE SecCode = 3401441 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3403841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704264, ExchCode = 'MXQ' WHERE SecCode = 3403875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3404208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630627945, ExchCode = 'FRA' WHERE SecCode = 3405439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789234533, ExchCode = 'LAS' WHERE SecCode = 3406379 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629952756, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3406929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791216285, ExchCode = 'STU' WHERE SecCode = 3407871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659420, ExchCode = 'GTX' WHERE SecCode = 3409091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761306232, ExchCode = 'MUN' WHERE SecCode = 3409175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633835972, Ticker = 'NMBd', ExchCode = 'BCO' WHERE SecCode = 3409323 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801932188, ExchCode = 'DEU' WHERE SecCode = 3410277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801287178, Ticker = 'C0B', ExchCode = 'STU' WHERE SecCode = 3410283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632884570, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3418906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380013, ExchCode = 'LAS' WHERE SecCode = 3424652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644441070, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2025-05-02' WHERE SecCode = 3428077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633326859, Ticker = 'FREB', ExchCode = 'MUN', PermQuoteRetireDate = '2018-06-22' WHERE SecCode = 3429677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674444, ExchCode = 'BIV' WHERE SecCode = 3429874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787999342, Ticker = 'KTNv', ExchCode = 'BCO' WHERE SecCode = 3430622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704968, ExchCode = 'MXQ' WHERE SecCode = 3430824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761780026, ExchCode = 'DEU' WHERE SecCode = 3430952 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3431765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633620996, Ticker = '0R2J', ExchCode = 'LSE' WHERE SecCode = 3432940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381246, ExchCode = 'LAS' WHERE SecCode = 3438714 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-14' WHERE SecCode = 3439981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787711104, Ticker = '1PUMm', ExchCode = 'BCO' WHERE SecCode = 3441642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727350609, Ticker = '639', ExchCode = 'BRN' WHERE SecCode = 3444689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644149832, ExchCode = 'DEU' WHERE SecCode = 3445226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645063180, ExchCode = 'DEU' WHERE SecCode = 3446031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647640876, ExchCode = 'DEU' WHERE SecCode = 3490936 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-29' WHERE SecCode = 3508359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796817245, ExchCode = 'DEU' WHERE SecCode = 3525431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955513852, ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-29', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830041, ExchCode = 'QTX', PermQuoteRetireDate = '2026-01-21' WHERE SecCode = 3526199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811976566, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-04-23' WHERE SecCode = 3526200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652485962, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-04', PermSecMapEndDate = '2018-07-04' WHERE SecCode = 3529083 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3534921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653986688, Ticker = 'TGLl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-28' WHERE SecCode = 3536053 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21941040970, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3544433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598347922, ExchCode = 'CHA' WHERE SecCode = 3588027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21678364379, ExchCode = 'FRA' WHERE SecCode = 3603616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681018002, ExchCode = 'FRA' WHERE SecCode = 3654098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670450813, ExchCode = 'DEU' WHERE SecCode = 3657811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21689480150, ExchCode = 'BTE' WHERE SecCode = 3669924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099419588, Ticker = '2NFLl', ExchCode = 'BTE' WHERE SecCode = 3669927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672826743, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3673707 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672845691, ExchCode = 'DEU' WHERE SecCode = 3675648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801047807, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3754712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678493, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3761051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461787, ExchCode = 'FRA' WHERE SecCode = 3793374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801932282, ExchCode = 'DEU' WHERE SecCode = 3827962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607048, Ticker = 'NVAX', ExchCode = 'SWX' WHERE SecCode = 3831364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3858119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633180217, Ticker = '0JOQ', ExchCode = 'LSE' WHERE SecCode = 3885297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778220719, ExchCode = 'TDG' WHERE SecCode = 3906532 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755619, ExchCode = 'FRA' WHERE SecCode = 3913159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010201, Ticker = '2NEMX' WHERE SecCode = 3932654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679348107, ExchCode = 'BIV' WHERE SecCode = 3934323 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731812579, ExchCode = 'TDG' WHERE SecCode = 3977296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371515, ExchCode = 'MEX' WHERE SecCode = 3977379 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098633, ExchCode = 'STU' WHERE SecCode = 4004564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21721187938, PermQuoteStatus = 'DC', Ticker = '0XM0', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4007107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820365638, ExchCode = 'DUS', PermSecMapEndDate = '2022-03-12' WHERE SecCode = 4016771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026918, Ticker = '1ABBV' WHERE SecCode = 4031772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128315297, ExchCode = 'DEU' WHERE SecCode = 4046669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630041763, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727356458, ExchCode = 'MEX' WHERE SecCode = 4090018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738262837, Ticker = '5C8', ExchCode = 'FRA' WHERE SecCode = 4090028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799881746, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 4101126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976129, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737083639, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-01-03' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858461751, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4124848 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-12' WHERE SecCode = 4129530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704289, Ticker = 'AZULBN', ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807704293, Ticker = '4U1', ExchCode = 'MUN', PermQuoteRetireDate = '2025-04-01', PermSecMapEndDate = '2025-04-01' WHERE SecCode = 4212367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349453, ExchCode = 'BIV' WHERE SecCode = 4228288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749843263, ExchCode = 'DEU' WHERE SecCode = 4228324 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754377770, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4245389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754200308, ExchCode = 'DEU' WHERE SecCode = 4253037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349640, ExchCode = 'MEX' WHERE SecCode = 4259231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 4282405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699358937, ExchCode = 'STU' WHERE SecCode = 4298602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803110079, ExchCode = 'FRA' WHERE SecCode = 4298603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696686138, ExchCode = 'DEU' WHERE SecCode = 4298604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735310251, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 4298606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760875901, ExchCode = 'DUS' WHERE SecCode = 4303583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760875979, ExchCode = 'BER' WHERE SecCode = 4303589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760881359, ExchCode = 'DEU' WHERE SecCode = 4303635 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803067142, ExchCode = 'TDG' WHERE SecCode = 4310576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762312075, ExchCode = 'MUN' WHERE SecCode = 4312160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763901203, ExchCode = 'QTX' WHERE SecCode = 4324503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763901196, ExchCode = 'QTX' WHERE SecCode = 4324504 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777644859, ExchCode = 'STU' WHERE SecCode = 4379791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783391809, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4380746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21826522500, ExchCode = 'QTX' WHERE SecCode = 4395464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991740, ExchCode = 'FRA' WHERE SecCode = 4400153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 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 = 21786673386, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4422563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777025689, ExchCode = 'STU' WHERE SecCode = 4422567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312258, ExchCode = 'BIV' WHERE SecCode = 4424570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727303270, ExchCode = 'BIV' WHERE SecCode = 4426957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783670602, ExchCode = 'EQD' WHERE SecCode = 4426958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786584663, ExchCode = 'GER' WHERE SecCode = 4442712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786584662, ExchCode = 'GER' WHERE SecCode = 4442713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786584633, ExchCode = 'FRA' WHERE SecCode = 4442715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818250497, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4449683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854730428, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-31', PermSecMapEndDate = NULL WHERE SecCode = 4449703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299967, ExchCode = 'MEX' WHERE SecCode = 4449704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396601, ExchCode = 'FRA' WHERE SecCode = 4472926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781362966, ExchCode = 'DUS', PermQuoteRetireDate = '2024-02-20' WHERE SecCode = 4478078 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367255, ExchCode = 'DEU' WHERE SecCode = 4482517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799698913, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4502498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803436577, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801287200, ExchCode = 'STU' WHERE SecCode = 4517642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781458722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4517877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301440, ExchCode = 'MEX' WHERE SecCode = 4547978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4566919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812636752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-17' WHERE SecCode = 4589403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026913, Ticker = '1INVEB' WHERE SecCode = 4601877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782463495, ExchCode = 'QTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21944534852, ExchCode = 'STU' WHERE SecCode = 4607695 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 4613103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380579, ExchCode = 'LAS' WHERE SecCode = 4617716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816901027, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-10' WHERE SecCode = 4620951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852456480, Ticker = 'VETH', ExchCode = 'BRN' WHERE SecCode = 4620952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822771356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-08-16' WHERE SecCode = 4637752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824528422, ExchCode = 'STU' WHERE SecCode = 4645553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312261, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780368954, ExchCode = 'TDG' WHERE SecCode = 4648214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21839048901, Ticker = 'FWR0', ExchCode = 'MUN' WHERE SecCode = 4657695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381815, ExchCode = 'LAS' WHERE SecCode = 4658662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832260332, ExchCode = 'FRA' WHERE SecCode = 4658888 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831914397, ExchCode = 'STU' WHERE SecCode = 4671286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388767, ExchCode = 'LAS' WHERE SecCode = 4685514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837516556, ExchCode = 'MUN' WHERE SecCode = 4693646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802153605, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4697438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727293349, ExchCode = 'BIV' WHERE SecCode = 4699231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011348, Ticker = '2STX' WHERE SecCode = 4699232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793313807, ExchCode = 'GTX' WHERE SecCode = 4707177 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840890126, ExchCode = 'DEU' WHERE SecCode = 4709618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842933392, ExchCode = 'DEU' WHERE SecCode = 4716089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777568050, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-19' WHERE SecCode = 4716090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843915272, ExchCode = 'STU' WHERE SecCode = 4718902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843597916, ExchCode = 'STU' WHERE SecCode = 4720468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799043657, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21849048148, ExchCode = 'STU' WHERE SecCode = 4720520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843597933, ExchCode = 'DEU' WHERE SecCode = 4722188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388604, ExchCode = 'LAS' WHERE SecCode = 4724688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852456548, Ticker = 'VDOT', ExchCode = 'BRN' WHERE SecCode = 4724692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845076827, ExchCode = 'DEU' WHERE SecCode = 4724746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845535652, ExchCode = 'FRA' WHERE SecCode = 4726104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851163155, ExchCode = 'QTX' WHERE SecCode = 4726106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845567127, ExchCode = 'MUN', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954980, ExchCode = 'LAS' WHERE SecCode = 4727660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851841869, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4730173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726918, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4733053 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851345464, ExchCode = 'STU' WHERE SecCode = 4733055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799043648, ExchCode = 'LAS' WHERE SecCode = 4733108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098665, ExchCode = 'FRA' WHERE SecCode = 4745391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381562, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4748503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850878465, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 4748504 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850720081, ExchCode = 'DEU' WHERE SecCode = 4748506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867566, ExchCode = 'FRA', PermQuoteRetireDate = '2025-10-29', PermSecMapEndDate = NULL WHERE SecCode = 4748531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814076573, ExchCode = 'FRA' WHERE SecCode = 4752207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830015, ExchCode = 'QTX' WHERE SecCode = 4754742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853953632, ExchCode = 'QTX' WHERE SecCode = 4754869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853235597, ExchCode = 'STU' WHERE SecCode = 4756369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781829981, ExchCode = 'QTX' WHERE SecCode = 4756378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853467327, ExchCode = 'QTX' WHERE SecCode = 4756621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22133181621, Ticker = 'ETHW', ExchCode = 'SWX' WHERE SecCode = 4756631 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-13' WHERE SecCode = 4757856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788491385, Ticker = '7XUd', ExchCode = 'BCO' WHERE SecCode = 4761545 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21909689585, ExchCode = 'DXE' WHERE SecCode = 4761548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165249368, ExchCode = 'BTE' WHERE SecCode = 4761550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854186426, ExchCode = 'DEU' WHERE SecCode = 4761589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778220715, ExchCode = 'TDG' WHERE SecCode = 4762975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866534619, ExchCode = 'GTX' WHERE SecCode = 4766038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727231201, ExchCode = 'MEX' WHERE SecCode = 4766049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307226, ExchCode = 'MEX' WHERE SecCode = 4768117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854896512, ExchCode = 'QTX' WHERE SecCode = 4768286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21905909279, ExchCode = 'MUN' WHERE SecCode = 4771746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856500053, ExchCode = 'STU' WHERE SecCode = 4775072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795665928, ExchCode = 'FRA' WHERE SecCode = 4775075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830085, ExchCode = 'QTX' WHERE SecCode = 4775201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856518308, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4777235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857633448, ExchCode = 'QTX' WHERE SecCode = 4781733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097372, ExchCode = 'LAS' WHERE SecCode = 4786540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858705682, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4786544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860858330, ExchCode = 'FRA' WHERE SecCode = 4800558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860831449, ExchCode = 'STU' WHERE SecCode = 4802301 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '3B5' WHERE SecCode = 4804576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781570173, ExchCode = 'DUS' WHERE SecCode = 4804831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904161, Ticker = 'QQQ5l', ExchCode = 'BCO' WHERE SecCode = 4806672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861191996, Ticker = 'CON3', ExchCode = 'LSE' WHERE SecCode = 4806678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823813, ExchCode = 'AQX' WHERE SecCode = 4808966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861539819, ExchCode = 'SWX' WHERE SecCode = 4809017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380494, ExchCode = 'LAS', PermQuoteRetireDate = '2026-02-12' WHERE SecCode = 4811141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799418543, ExchCode = 'SIG' WHERE SecCode = 4815279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863182410, ExchCode = 'MUN' WHERE SecCode = 4815314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880186249, ExchCode = 'QTX', PermQuoteRetireDate = '2023-11-06' WHERE SecCode = 4815315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804716445, ExchCode = 'HAM' WHERE SecCode = 4815349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863513304, ExchCode = 'DEU' WHERE SecCode = 4818264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684876, ExchCode = 'QTX' WHERE SecCode = 4818275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4819878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865296250, ExchCode = 'TDG' WHERE SecCode = 4823664 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 4834760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580195, ExchCode = 'DUS' WHERE SecCode = 4834791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419008, ExchCode = 'LAS' WHERE SecCode = 4834795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866892386 WHERE SecCode = 4841211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783262067, ExchCode = 'FRA' WHERE SecCode = 4846846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783783667, ExchCode = 'QTX' WHERE SecCode = 4852142 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22144452985, ExchCode = 'LAS' WHERE SecCode = 4854866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089453110, ExchCode = 'BTE' WHERE SecCode = 4854872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876129773, Ticker = '9XK0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-21' WHERE SecCode = 4873803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873145829, ExchCode = 'QTX' WHERE SecCode = 4878702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959379953, ExchCode = 'TDG' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21828334184, ExchCode = 'STU' WHERE SecCode = 4890300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21875612276, ExchCode = 'QTX', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 4893294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882167707, PermQuoteStatus = 'AC', Ticker = 'Y232', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885447241, ExchCode = 'DUS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 4954564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884973298, ExchCode = 'MUN' WHERE SecCode = 4957875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21891723924, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4959596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689488, ExchCode = 'DEU' WHERE SecCode = 4959597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887686666, PermQuoteStatus = 'AC', Ticker = 'WATT', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4969407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419011, ExchCode = 'LAS' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21900329999, ExchCode = 'DEU' WHERE SecCode = 4970793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810200238, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-20', PermSecMapEndDate = NULL WHERE SecCode = 5002458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21897339624, ExchCode = 'FRA' WHERE SecCode = 5025182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740567, ExchCode = 'LAS' 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 = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860615655, ExchCode = 'STU' WHERE SecCode = 5153443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633621506, Ticker = '0M1K', ExchCode = 'LSE' WHERE SecCode = 5161267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758567887, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820365638, ExchCode = 'DUS' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755973706, ExchCode = 'DUS' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793473641, Ticker = 'WPMl', ExchCode = 'CHI' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348309, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX', PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 5162437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955191864, ExchCode = 'DUS' WHERE SecCode = 5174473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931108954, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 5220960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801543852, ExchCode = 'HAM' WHERE SecCode = 5230230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388873, ExchCode = 'LAS' WHERE SecCode = 5230333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787664879, ExchCode = 'QTX' WHERE SecCode = 5253719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782758789, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = NULL WHERE SecCode = 5283651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781180723, ExchCode = 'GTX' WHERE SecCode = 5290322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727202568, ExchCode = 'MEX' WHERE SecCode = 5411550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378859, ExchCode = 'FRA' WHERE SecCode = 5415164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779165176, ExchCode = 'STU' WHERE SecCode = 5476926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437243, ExchCode = 'MEX' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778704118, ExchCode = 'FRA' WHERE SecCode = 5493665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 5503898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807449510, ExchCode = 'BCO' WHERE SecCode = 5503900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663650, Ticker = 'ARK3l', ExchCode = 'AQX' WHERE SecCode = 5503901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010091546, Ticker = 'BTCCHz', ExchCode = 'TQE' WHERE SecCode = 5509588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779292324, ExchCode = 'FRA' WHERE SecCode = 5527560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831436884, Ticker = 'SFTG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5534997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22108933745, ExchCode = 'DUS' WHERE SecCode = 5540637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777584029, ExchCode = 'MEX' WHERE SecCode = 5558570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21995583895, ExchCode = 'DEU' WHERE SecCode = 5565485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932421397, PermQuoteStatus = 'AC', Ticker = '3LALm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835780, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151033, PermQuoteStatus = 'AC', Ticker = '3FNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5569246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360205, ExchCode = 'BIV' WHERE SecCode = 5581641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585131, ExchCode = 'BIV' WHERE SecCode = 5582137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212166, ExchCode = 'BIV' WHERE SecCode = 5604481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780605566, ExchCode = 'MEX' WHERE SecCode = 5620230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781012608, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5631688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780880115, ExchCode = 'HAM', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 5633493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 5638703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904157, Ticker = 'LCO3l', ExchCode = 'BCO' WHERE SecCode = 5638747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778500351, ExchCode = 'MEX' WHERE SecCode = 5671941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866504754, ExchCode = 'UAX' WHERE SecCode = 5674188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858108, ExchCode = 'STU' WHERE SecCode = 5678892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781814650, ExchCode = 'BIV' WHERE SecCode = 5678893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22020427741, ExchCode = 'DEU' WHERE SecCode = 5678983 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782145874, ExchCode = 'MEX' WHERE SecCode = 5701236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078152, ExchCode = 'LAS' WHERE SecCode = 5703208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22027362169, ExchCode = 'STU' WHERE SecCode = 5715993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782930891, ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-04', PermSecMapEndDate = NULL WHERE SecCode = 5753987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782872492, ExchCode = 'BIV' WHERE SecCode = 5754129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802914265, Ticker = 'RZ8B', ExchCode = 'STU' WHERE SecCode = 5782810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 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 = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596707, ExchCode = 'FRA' WHERE SecCode = 5839460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596711, ExchCode = 'FRA' WHERE SecCode = 5839461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596713, ExchCode = 'FRA' WHERE SecCode = 5839464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596706, ExchCode = 'FRA' WHERE SecCode = 5839466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596709, ExchCode = 'FRA' WHERE SecCode = 5839467 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 5842624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804089043, ExchCode = 'QTX' WHERE SecCode = 5853173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786494467, ExchCode = 'GTX' WHERE SecCode = 5871394 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5885543 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 5886924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802025933, ExchCode = 'LAS' WHERE SecCode = 5907872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784888214, ExchCode = 'BIV' WHERE SecCode = 5907884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786127339, ExchCode = 'GTX' WHERE SecCode = 5908830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802025931, ExchCode = 'LAS' WHERE SecCode = 5991096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-14', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 6050909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705800, ExchCode = 'MXQ' WHERE SecCode = 6097292 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970308382, ExchCode = 'BCO' WHERE SecCode = 6097325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784422712, ExchCode = 'BIV' WHERE SecCode = 6097386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917848455, ExchCode = 'QTX' WHERE SecCode = 6097430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777911612, ExchCode = 'BIV' WHERE SecCode = 6097467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791287038, ExchCode = 'FRA' WHERE SecCode = 6190705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173202, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6260557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806951546, ExchCode = 'LAS' WHERE SecCode = 6285590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794652095, ExchCode = 'STU' WHERE SecCode = 6308671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792988748, ExchCode = 'MUN' WHERE SecCode = 6310651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936571424, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6358857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125348556, ExchCode = 'DEU' WHERE SecCode = 6438418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141703193, ExchCode = 'CHI' WHERE SecCode = 6456420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799207727, ExchCode = 'MUN' WHERE SecCode = 6554915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21976165242, ExchCode = 'DEU' WHERE SecCode = 6626357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781821981, ExchCode = 'QTX' WHERE SecCode = 6626587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801541597, ExchCode = 'FRA' WHERE SecCode = 6627152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801541595, ExchCode = 'FRA' WHERE SecCode = 6627153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801541760, ExchCode = 'FRA' WHERE SecCode = 6627155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801973480, ExchCode = 'TDG' WHERE SecCode = 6628840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727378733, ExchCode = 'BRN' WHERE SecCode = 6629465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22157763898, ExchCode = 'DEU' WHERE SecCode = 6645675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802593215, ExchCode = 'QTX' WHERE SecCode = 6645688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803478723, ExchCode = 'DUS' WHERE SecCode = 6686044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165249157, ExchCode = 'DEU' WHERE SecCode = 6712516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167343880, ExchCode = 'DEU' WHERE SecCode = 6728367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339493, ExchCode = 'DEU' WHERE SecCode = 6728368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339476, ExchCode = 'DEU' WHERE SecCode = 6728370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340591, ExchCode = 'DEU' WHERE SecCode = 6728371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167341909, ExchCode = 'DEU' WHERE SecCode = 6728372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167342837, ExchCode = 'DEU' WHERE SecCode = 6728373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167342067, ExchCode = 'DEU' WHERE SecCode = 6728374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339591, ExchCode = 'DEU' WHERE SecCode = 6728375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340584, ExchCode = 'DEU' WHERE SecCode = 6728377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340486, ExchCode = 'DEU' WHERE SecCode = 6728378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799175959, ExchCode = 'BIV' WHERE SecCode = 6728383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167326401, ExchCode = 'GER' WHERE SecCode = 6728389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804483784, ExchCode = 'STU' WHERE SecCode = 6728400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804838547, ExchCode = 'BIV' WHERE SecCode = 6748872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805095337, ExchCode = 'QTX' WHERE SecCode = 6753078 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 6786373 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 6786585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-13' WHERE SecCode = 6797283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806019658, ExchCode = 'MEX' WHERE SecCode = 6797367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806018739, ExchCode = 'FRA' WHERE SecCode = 6797368 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 6813383 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 6820136 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 6832535 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-29' WHERE SecCode = 6836138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22178680049, ExchCode = 'DEU' WHERE SecCode = 6843132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22178680310, ExchCode = 'DEU' WHERE SecCode = 6843133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22178680209, ExchCode = 'DEU' WHERE SecCode = 6843134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22129776840, ExchCode = 'MUN' WHERE SecCode = 6843135 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22179032553.0 WHERE SecCode = 6843186 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22179032553.0 WHERE SecCode = 6843187 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22179032553.0 WHERE SecCode = 6843296 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'RTB' WHERE SecCode = 10925095 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 11037093 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'CROTD' WHERE SecCode = 11053050 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MRIIF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-12', PermSecMapEndDate = NULL WHERE SecCode = 11069915 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 11156315 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236781733928, IsPrimaryQuote = 0, PermQuoteStatus = 'AC', Ticker = 'AMRQF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2024-02-28', PermSecMapEndDate = NULL WHERE SecCode = 11174819 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11180158 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11180612 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11186429 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11197145 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'NNBXF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-12', PermSecMapEndDate = NULL WHERE SecCode = 11198808 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 11277962 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 11279604 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 11288106 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 11291828 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232922661803.0 WHERE SecCode = 11295154 AND Type_ = 1;