UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 5055 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 11377 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509917171, ExchCode = 'TDG' WHERE SecCode = 37853 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 = 21667493393, PermQuoteStatus = 'DC', Ticker = 'XPG', ExchCode = 'QTX', PermQuoteRetireDate = '2025-10-28' WHERE SecCode = 39443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475595678, ExchCode = 'MUN', PermQuoteRetireDate = '2009-07-01' WHERE SecCode = 41201 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL, PermOrgIPODate = NULL WHERE SecCode = 42667 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836565430, ExchCode = 'FRA' WHERE SecCode = 44050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517229667, ExchCode = 'STU' WHERE SecCode = 44084 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475759882, ExchCode = 'STU' WHERE SecCode = 44086 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381432, ExchCode = 'LAS' WHERE SecCode = 44254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852201118, ExchCode = 'GTX' WHERE SecCode = 44260 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520627424, Ticker = 'CPZ1', ExchCode = 'DEU' WHERE SecCode = 44270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836544492, ExchCode = 'FRA' WHERE SecCode = 44612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475541914, ExchCode = 'MUN', PermQuoteRetireDate = '2010-01-13' WHERE SecCode = 45085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576247713, ExchCode = 'STU' WHERE SecCode = 45088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528040354, PermQuoteStatus = 'DC', Ticker = 'PBCB', ExchCode = 'TDG', PermQuoteRetireDate = '2019-07-11' WHERE SecCode = 45367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323447, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 45459 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341602, ExchCode = 'BER' WHERE SecCode = 46521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836582583, ExchCode = 'FRA' WHERE SecCode = 48131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816288136, ExchCode = 'FRA' WHERE SecCode = 56992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474961352, ExchCode = 'DEU' WHERE SecCode = 57072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840728137, ExchCode = 'MUN', PermQuoteRetireDate = '2013-05-21' WHERE SecCode = 57073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735443347, Ticker = 'AIVd', ExchCode = 'BCO' WHERE SecCode = 57101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327029, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 57439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608949117, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 58289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649420924, ExchCode = 'STU' WHERE SecCode = 58298 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034182, ExchCode = 'TDG' WHERE SecCode = 58346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621219277, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 58930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475610306, Ticker = 'CMYG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 59127 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 59856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836516282, ExchCode = 'FRA' WHERE SecCode = 60537 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663166850, ExchCode = 'FRA' WHERE SecCode = 65358 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 65368 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 65530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837364346, ExchCode = 'GER', PermQuoteRetireDate = '2010-07-27' WHERE SecCode = 65714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838240446, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 65716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830311947, ExchCode = 'GTX' WHERE SecCode = 65732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838450820, ExchCode = 'STU', PermQuoteRetireDate = '2014-02-11' WHERE SecCode = 65966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475847203, ExchCode = 'DEU', PermQuoteRetireDate = '2025-10-20' WHERE SecCode = 66107 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 66179 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 68111 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 77383 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951820.0 WHERE SecCode = 78038 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 79926 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 81636 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000119948, PriInstrPermID = 8589991944.0 WHERE SecCode = 82755 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 83949 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 85441 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 85593 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 86891 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 87258 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 88572 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 89166 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 90764 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 91288 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 91604 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951244.0 WHERE SecCode = 95289 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365459.0 WHERE SecCode = 95877 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 97751 AND Type_ = 10; 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 = 55838736430, Ticker = 'XPBR', ExchCode = 'LAT' WHERE SecCode = 102966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382991, ExchCode = 'LAS' WHERE SecCode = 104387 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 111511 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 111512 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951828.0 WHERE SecCode = 114294 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 114773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785486228, ExchCode = 'FRA' WHERE SecCode = 115623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587383841, ExchCode = 'FRA' WHERE SecCode = 115779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134818, ExchCode = 'DEU' WHERE SecCode = 116972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789434487, ExchCode = 'LAS' WHERE SecCode = 122073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704311, ExchCode = 'MXQ' WHERE SecCode = 125073 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 133035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947053569, ExchCode = 'DEU' WHERE SecCode = 133153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954131052, ExchCode = 'DEU' WHERE SecCode = 133163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320084, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 136933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639492709, ExchCode = 'MUN' WHERE SecCode = 137615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714765728, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 137944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034965, ExchCode = 'TDG' WHERE SecCode = 138046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806835566, ExchCode = 'QTX', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 138122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448701, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-08', PermSecMapEndDate = NULL WHERE SecCode = 138259 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855827479, ExchCode = 'GER', PermQuoteRetireDate = '2022-05-03' WHERE SecCode = 138261 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 139768 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 139991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825607984, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-19' WHERE SecCode = 143730 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'HCD' WHERE SecCode = 144424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641228432, ExchCode = 'TDG' WHERE SecCode = 145745 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475593565, PermQuoteStatus = 'DC', Ticker = 'MAST.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 145782 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 146379 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 146536 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 146587 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 147559 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 147690 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 = 21475756822, ExchCode = 'FRA' WHERE SecCode = 162463 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 174727 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 177649 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 = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 178579 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21850192870.0 WHERE SecCode = 197405 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21506132846, ExchCode = 'DEU' WHERE SecCode = 200713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531927275, ExchCode = 'MEX' WHERE SecCode = 201875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675875, ExchCode = 'BIV' WHERE SecCode = 214889 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 249545 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 310425 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 316458 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 323167 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 323829 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'FLIVD', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 324369 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 325683 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 327133 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL WHERE SecCode = 327239 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 328153 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 329301 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LKFT' WHERE SecCode = 331528 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 334504 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 334744 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 336307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22178668432, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-08', PermSecMapEndDate = NULL WHERE SecCode = 336756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620411337, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-17' WHERE SecCode = 336764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 340697 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 340882 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 347790 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55837445595, Ticker = '1RNO' WHERE SecCode = 348455 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 353950 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 354332 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55837351596, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 369463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837363589, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 370287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835814252, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 371435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585032804, ExchCode = 'BCO' WHERE SecCode = 372403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837351393, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 372834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835814728, ExchCode = 'MEX' WHERE SecCode = 372859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840407170, ExchCode = 'MEX' WHERE SecCode = 372861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475571448, PermQuoteStatus = 'DC', Ticker = 'VISF.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 373242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834671865, Ticker = '0NNH', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 374927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475432895, Ticker = 'MULT.GR', ExchCode = 'PLU', PermQuoteRetireDate = '2009-08-27' WHERE SecCode = 374930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518812, ExchCode = 'DUS' WHERE SecCode = 375279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533496124, ExchCode = 'STU', PermQuoteRetireDate = '2021-02-10' WHERE SecCode = 375327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779690632, Ticker = 'TFGl', ExchCode = 'AQX' WHERE SecCode = 379856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21961970277, ExchCode = 'STU' WHERE SecCode = 380084 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837351293, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 381809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651373210, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-30', PermSecMapEndDate = NULL WHERE SecCode = 381896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840699485, ExchCode = 'BER', PermQuoteRetireDate = '2013-12-19' WHERE SecCode = 384210 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 = 236782463487, ExchCode = 'QTX' WHERE SecCode = 385281 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623028609, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 385283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704911, ExchCode = 'MXQ' WHERE SecCode = 385655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522128006, ExchCode = 'MUN' WHERE SecCode = 387326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840731652, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 387856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834672388, PermQuoteStatus = 'AC', Ticker = '0DQP', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 389366 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840869960, Ticker = 'TRME', ExchCode = 'LSE' WHERE SecCode = 389399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616156678, ExchCode = 'MCX' WHERE SecCode = 389411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962595022, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-15' WHERE SecCode = 389476 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21956727902, ExchCode = 'QTX' WHERE SecCode = 390369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841055122, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 391527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388055, Ticker = 'GTB.NO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 391965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522213529, ExchCode = 'MUN', PermQuoteRetireDate = '2015-06-15' WHERE SecCode = 392196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727380416, Ticker = 'NMM', ExchCode = 'BRN' WHERE SecCode = 392615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955513841, ExchCode = 'DUS' WHERE SecCode = 395256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841460330, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-30' WHERE SecCode = 395621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388131, Ticker = 'NORD.NO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 396143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841648239, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 396297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799281035, ExchCode = 'FRA' WHERE SecCode = 396303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798948725, ExchCode = 'DUS' WHERE SecCode = 396306 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 400321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388949, Ticker = 'EMS.NO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 401544 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 401620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841643564, ExchCode = 'FRA' WHERE SecCode = 401624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821641664, ExchCode = 'DUS' WHERE SecCode = 403552 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834674152, Ticker = '0EBK', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 404675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841814629, ExchCode = 'BER', PermQuoteRetireDate = '2018-03-26' WHERE SecCode = 404717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841826963, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-01' WHERE SecCode = 404833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842464917, Ticker = '1ENGI' WHERE SecCode = 408548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479309, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 408562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582412675, ExchCode = 'DEU' WHERE SecCode = 409650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841613018, ExchCode = 'MEX' WHERE SecCode = 409684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512064319, ExchCode = 'DUS' WHERE SecCode = 412084 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492119, PermQuoteStatus = 'DC', Ticker = 'TRC1', ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-03' WHERE SecCode = 415856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475108927, PermQuoteStatus = 'AC', Ticker = 'ZCT', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 416445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842974618, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 421788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843288027, ExchCode = 'FRA' WHERE SecCode = 424919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474878624, Ticker = '0KJT', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 425350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843427223, ExchCode = 'MUN' WHERE SecCode = 425691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488504, ExchCode = 'QTX' WHERE SecCode = 428332 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 = 55836330574, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 432012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474924381 WHERE SecCode = 433675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859809796, ExchCode = 'UAX', PermQuoteRetireDate = '2016-02-05' WHERE SecCode = 433812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859809742, ExchCode = 'UAX', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 433814 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308332, ExchCode = 'GTX' WHERE SecCode = 434993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518877, ExchCode = 'DUS' WHERE SecCode = 435796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55845312524, ExchCode = 'GER' WHERE SecCode = 436499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530872359, ExchCode = 'BTE' WHERE SecCode = 437391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474947767 WHERE SecCode = 437916 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 = 236781684824, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 439455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545451863, ExchCode = 'DEU' WHERE SecCode = 440283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474954858, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 440782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55845459608, ExchCode = 'BER', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 442574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734028388, ExchCode = 'DUS' WHERE SecCode = 443141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475766995, ExchCode = 'FRA', PermQuoteRetireDate = '2019-08-19' WHERE SecCode = 446617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834675441, Ticker = '0JS9', ExchCode = 'LSE', PermQuoteRetireDate = '2017-10-27' WHERE SecCode = 450252 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21717056548, Ticker = 'K900', ExchCode = 'TDG' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841619375, ExchCode = 'MEX' WHERE SecCode = 462658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714450361, ExchCode = 'DXE' WHERE SecCode = 464174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518886, ExchCode = 'DUS', PermQuoteRetireDate = '2020-12-15' WHERE SecCode = 471738 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 = 55853458925, ExchCode = 'STU', PermQuoteRetireDate = '2013-02-28' WHERE SecCode = 479915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847283501, ExchCode = 'LSE' WHERE SecCode = 481044 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 = 21952832290, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 484491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629381909, Ticker = '0MO8', ExchCode = 'LSE' WHERE SecCode = 485330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21484166997, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 486270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475107600, ExchCode = 'MUN' WHERE SecCode = 486276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475073605, Ticker = '0OE0', ExchCode = 'LSE', PermQuoteRetireDate = '2011-02-04' WHERE SecCode = 501839 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296759, ExchCode = 'GTX' WHERE SecCode = 504529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834673840, Ticker = '0GP3', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-09' WHERE SecCode = 505602 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 = 55849266247, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 507407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' WHERE SecCode = 508999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476991409, ExchCode = 'MUN', PermQuoteRetireDate = '2013-03-12' WHERE SecCode = 510380 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 = 55849477549, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 513278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849902700, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 513850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531115401, Ticker = '0GAd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-12' WHERE SecCode = 513937 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 = 55849660297, ExchCode = 'BER' WHERE SecCode = 515043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849370148, ExchCode = 'BER', PermQuoteRetireDate = '2016-02-10' WHERE SecCode = 515819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 519126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836423986, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 519509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837446990, Ticker = 'WEAT', ExchCode = 'MIL' WHERE SecCode = 521420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837436792, Ticker = 'AIGI', ExchCode = 'MIL' WHERE SecCode = 521425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714446430, ExchCode = 'DXE' WHERE SecCode = 521436 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509905078, Ticker = 'COFF.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 521460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835439836, PermQuoteStatus = 'AC', Ticker = 'CRUDP', ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 521464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856951179, PermQuoteStatus = 'AC', Ticker = 'PHPT', ExchCode = 'AEX', PermQuoteRetireDate = '2100-01-05' WHERE SecCode = 521843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045077517, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 521905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55879740079, Ticker = 'COM.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 523414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843592964, Ticker = '0NJF', ExchCode = 'LSE', PermQuoteRetireDate = '2012-02-23' WHERE SecCode = 526379 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850150954, Ticker = 'GOK', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 527096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705317, ExchCode = 'MXQ' WHERE SecCode = 528977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529683427, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 529878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859265616, Ticker = '0MFT', ExchCode = 'LSE', PermQuoteRetireDate = '2023-01-05' WHERE SecCode = 531909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784580341, Ticker = '9EAA', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 531956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842864127, ExchCode = 'SGO' WHERE SecCode = 532209 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850896054, ExchCode = 'FRA', PermQuoteRetireDate = '2020-05-22' WHERE SecCode = 532767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480578, ExchCode = 'QTX', PermQuoteRetireDate = '2020-09-01' WHERE SecCode = 532772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850905260, ExchCode = 'FRA' WHERE SecCode = 533384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850870170, ExchCode = 'FRA', PermQuoteRetireDate = '2014-08-19' WHERE SecCode = 533487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646062340, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 533522 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851188666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 534433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850975029, ExchCode = 'FRA' WHERE SecCode = 534603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55879711383, Ticker = 'USEB.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 535214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518940, ExchCode = 'DUS' WHERE SecCode = 535313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552519097, ExchCode = 'DUS' WHERE SecCode = 535314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851203490, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 535316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475082592, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-25' WHERE SecCode = 535417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478699, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-09', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 535506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849997680, Ticker = 'SBUL', ExchCode = 'MIL' WHERE SecCode = 536401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474917069, ExchCode = 'DEU' WHERE SecCode = 538090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851223600, ExchCode = 'BER' WHERE SecCode = 538783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851838576, PermQuoteStatus = 'DC', Ticker = 'XGLE.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 539253 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799115741, ExchCode = 'LAS' WHERE SecCode = 539801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852284014, ExchCode = 'BER' WHERE SecCode = 540241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851907674, ExchCode = 'FRA' WHERE SecCode = 540531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335096, ExchCode = 'BER' WHERE SecCode = 540563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858727490, ExchCode = 'STU' WHERE SecCode = 541276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851865348, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852220203, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 541456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035999, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-14' WHERE SecCode = 542320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916878, ExchCode = 'TDG' WHERE SecCode = 542943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521105518, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2014-12-29' WHERE SecCode = 543609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835813082, ExchCode = 'MEX', PermSecMapEndDate = NULL WHERE SecCode = 544311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475529491, ExchCode = 'NGM', PermQuoteRetireDate = '2010-03-27' WHERE SecCode = 547513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547316142, ExchCode = 'STU' WHERE SecCode = 548626 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852985293, ExchCode = 'FRA', PermQuoteRetireDate = '2019-04-19' WHERE SecCode = 548655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542942791, ExchCode = 'STU' 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 = 236789555706, ExchCode = 'QTX' WHERE SecCode = 549886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531427744, ExchCode = 'STU' WHERE SecCode = 550860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859092913, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 551262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538768084, IsPrimaryQuote = 0, Ticker = 'BURl', ExchCode = 'BCO' WHERE SecCode = 551365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033537, ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-12', PermSecMapEndDate = '2024-12-12' WHERE SecCode = 551472 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853660976, ExchCode = 'GER' WHERE SecCode = 552722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853580515, ExchCode = 'FRA' WHERE SecCode = 552856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479915, ExchCode = 'QTX' WHERE SecCode = 552948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853693620, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-01', PermSecMapEndDate = '2022-11-01' WHERE SecCode = 553231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640344252, ExchCode = 'BCO' WHERE SecCode = 553351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823049000, ExchCode = 'DUS' WHERE SecCode = 553799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850895884, ExchCode = 'QTX', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 553921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531126587, ExchCode = 'BCO', PermQuoteRetireDate = '2020-07-16' WHERE SecCode = 554481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857244295, ExchCode = 'FRA' WHERE SecCode = 554534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853892984, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 554906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475387812, PermQuoteStatus = 'DC', Ticker = 'RBREW.DK', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 554925 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 = 55836327989, ExchCode = 'BER' WHERE SecCode = 556234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471152, ExchCode = 'GTX' WHERE SecCode = 556254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859197737, ExchCode = 'BER' WHERE SecCode = 557816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474957849, ExchCode = 'DEU' WHERE SecCode = 557818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475855781, ExchCode = 'TDG' WHERE SecCode = 557995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857265244, ExchCode = 'FRA' WHERE SecCode = 558044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184301, ExchCode = 'FRA' WHERE SecCode = 558485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538720984, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 558809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475036088, ExchCode = 'TDG' WHERE SecCode = 558811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856395007, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 559256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804090704, ExchCode = 'HAM' WHERE SecCode = 559903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802229172, PermQuoteStatus = 'DC', Ticker = '7TM', ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 560717 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 = 55856711423, ExchCode = 'FRA' WHERE SecCode = 560728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856859125, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 561328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550980921, ExchCode = 'HAM' WHERE SecCode = 562914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633740802, ExchCode = 'TDG' WHERE SecCode = 563028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518788, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 563096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474874909, ExchCode = 'DEU' WHERE SecCode = 563938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858521801, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 564035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487603, PermQuoteStatus = 'AC', ExchCode = 'QTX', 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 = 55857726268, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-27' WHERE SecCode = 565586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475791842, ExchCode = 'STU', PermQuoteRetireDate = '2015-02-24' WHERE SecCode = 565706 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857740936, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 565707 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489086, ExchCode = 'QTX' 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 = 55857857467, ExchCode = 'STU' WHERE SecCode = 566528 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 = 21475388955, Ticker = 'IGNIS.NO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 568280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152662, ExchCode = 'MUN' WHERE SecCode = 568338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475036180, PermQuoteStatus = 'DC', Ticker = 'XLE', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 568823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858319818, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-26' WHERE SecCode = 568829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705724, ExchCode = 'MXQ' WHERE SecCode = 573267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787219, ExchCode = 'DUS' WHERE SecCode = 575072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858527370, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-23' WHERE SecCode = 577333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704164, ExchCode = 'MXQ' WHERE SecCode = 580373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858761330, ExchCode = 'FRA', PermQuoteRetireDate = '2015-07-21' WHERE SecCode = 580444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550981529, ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 583151 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 = 236784379754, ExchCode = 'LAS' WHERE SecCode = 593055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475793862, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 593104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859005912, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 593132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521814018, ExchCode = 'STU', PermQuoteRetireDate = '2014-04-25' WHERE SecCode = 594093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475141963, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 594099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859132030, ExchCode = 'GER' WHERE SecCode = 594191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068266, ExchCode = 'DEU' WHERE SecCode = 596843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859255888, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-17' WHERE SecCode = 600391 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 = 55859257109, ExchCode = 'FRA' WHERE SecCode = 604212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859760619, ExchCode = 'FRA' WHERE SecCode = 627565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55868335680, Ticker = 'OCS.GB', ExchCode = 'PLU' WHERE SecCode = 649936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838302922, Ticker = 'UMS.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 693688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 701753 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 QuotePermID = 25727287353, ExchCode = 'BIV' WHERE SecCode = 780513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895641350, ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 827254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610380111, ExchCode = 'DEU' WHERE SecCode = 862925 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 = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55868604668, Ticker = 'CBBFDS', ExchCode = 'SWX', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 933460 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 948508 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 1032147 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1043297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604819910, ExchCode = 'STU' WHERE SecCode = 1062623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483841831, ExchCode = 'QMF', PermQuoteRetireDate = '2013-05-13' WHERE SecCode = 1107433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824094970, ExchCode = 'BTE' WHERE SecCode = 1108481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816272819, ExchCode = 'BTE' WHERE SecCode = 1108490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636233532, Ticker = 'ISLN.GB', ExchCode = 'AQS' WHERE SecCode = 1108496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777489980, ExchCode = 'DEU' WHERE SecCode = 1109308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803110081, ExchCode = 'FRA' WHERE SecCode = 1128437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704648, ExchCode = 'MXQ' WHERE SecCode = 1149852 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 1188402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475998643, Ticker = 'B5M', ExchCode = 'STU', PermQuoteRetireDate = '2015-08-14' WHERE SecCode = 1205007 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 1210482 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 1241033 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1254621 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 1262951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475892461, ExchCode = 'GER', PermQuoteRetireDate = '2012-04-10' WHERE SecCode = 1265152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747333716, ExchCode = 'FRA' WHERE SecCode = 1447581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476159348, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1449053 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1464838 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1464912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478615947, ExchCode = 'BUR' WHERE SecCode = 1465275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21480921413, ExchCode = 'FRA' WHERE SecCode = 1481937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482228346, ExchCode = 'DEU' WHERE SecCode = 1485685 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596919147, Ticker = 'SLHOm', ExchCode = 'BTE', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1503000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067019121, Ticker = 'FCRUm', ExchCode = 'BTE' WHERE SecCode = 1510139 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 = 21584924792, Ticker = 'LIMEm', ExchCode = 'CHI', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1517254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678236, ExchCode = 'BIV' WHERE SecCode = 1518823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655821531, ExchCode = 'DEU' WHERE SecCode = 1524540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21488288403, ExchCode = 'FRA' WHERE SecCode = 1524542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN' WHERE SecCode = 1524543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 1524617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21489294561, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-23' WHERE SecCode = 1525783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794818026, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1527439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21489507452, ExchCode = 'STU', PermQuoteRetireDate = '2012-02-14' WHERE SecCode = 1527466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806834457, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-08', PermSecMapEndDate = NULL WHERE SecCode = 1527503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630031903, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1538644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21495307631, ExchCode = 'DEU' WHERE SecCode = 1544114 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583635011, ExchCode = 'FRA' WHERE SecCode = 1552943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498230074, ExchCode = 'FRA' WHERE SecCode = 1554784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498302420, ExchCode = 'DEU' WHERE SecCode = 1555173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498521053, ExchCode = 'DEU' WHERE SecCode = 1556381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502335108, ExchCode = 'FRA' WHERE SecCode = 1568506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502130153, ExchCode = 'BUR' WHERE SecCode = 1570494 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563046128, ExchCode = 'FRA' WHERE SecCode = 1570622 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 1578094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806710929, Ticker = 'GRADIENTE', ExchCode = 'NSI' WHERE SecCode = 1611823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21510005786, ExchCode = 'FRA' WHERE SecCode = 1653506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629962634, Ticker = '7O2', ExchCode = 'STU' WHERE SecCode = 1656414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515522117, ExchCode = 'DEU' WHERE SecCode = 1713829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE' WHERE SecCode = 1722300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513762717, ExchCode = 'FRA' WHERE SecCode = 1736071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 1973328 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 1996255 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 1999648 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 2005737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21516696149, Ticker = 'ECX', ExchCode = 'LSE', PermQuoteRetireDate = '2014-08-27' WHERE SecCode = 2013070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 2072760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 2178812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 2205946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371101, ExchCode = 'BEC' WHERE SecCode = 2272715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 2346276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704400, ExchCode = 'MXQ' WHERE SecCode = 2362819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381501, ExchCode = 'LAS' WHERE SecCode = 2379809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531457314, ExchCode = 'DEU' WHERE SecCode = 2382351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532119904, ExchCode = 'DEU' WHERE SecCode = 2394797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892047304, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2412432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521327155, ExchCode = 'STU' WHERE SecCode = 2429992 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 2433009 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 2433073 AND Type_ = 10; UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 2439906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381214, ExchCode = 'LAS' WHERE SecCode = 2466343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537746016, ExchCode = 'BER', PermQuoteRetireDate = '2015-04-03' WHERE SecCode = 2466346 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 2496924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999786358, ExchCode = 'BTE' WHERE SecCode = 2510129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21848757217, ExchCode = 'QTX', PermQuoteRetireDate = '2023-01-17', PermSecMapEndDate = NULL WHERE SecCode = 2519541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21833140716, ExchCode = 'TDG', PermQuoteRetireDate = '2022-10-31' WHERE SecCode = 2529650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539181649, ExchCode = 'FRA' WHERE SecCode = 2532821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539323912, ExchCode = 'DEU' WHERE SecCode = 2534073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371134, ExchCode = 'BEC' WHERE SecCode = 2545788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633835976, Ticker = '53S1d', ExchCode = 'BCO', PermQuoteRetireDate = '2021-09-27' WHERE SecCode = 2550286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541115296, ExchCode = 'DEU' WHERE SecCode = 2556581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677206, ExchCode = 'BIV' WHERE SecCode = 2572316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830369, ExchCode = 'DUS' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782012516, ExchCode = 'DEU' WHERE SecCode = 2585381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121993910, ExchCode = 'BCO' WHERE SecCode = 2586441 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 = 21544949718, Ticker = 'XDWD', ExchCode = 'LSE' WHERE SecCode = 2602038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369113, ExchCode = 'SGO' WHERE SecCode = 2625122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384982, ExchCode = 'LAS' WHERE SecCode = 2630989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673317, ExchCode = 'BIV' WHERE SecCode = 2644179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674340, ExchCode = 'BIV' WHERE SecCode = 2655873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549840232, ExchCode = 'FRA' WHERE SecCode = 2655948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842460842, ExchCode = 'HAN' WHERE SecCode = 2659980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596919175, ExchCode = 'BTE' WHERE SecCode = 2679866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535197344, Ticker = '7HP', ExchCode = 'BRN' WHERE SecCode = 2679919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451855, Ticker = 'QCOM', ExchCode = 'SWX' WHERE SecCode = 2679937 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 2679938 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 2682195 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 2682254 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365459.0 WHERE SecCode = 2696962 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 2697114 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 2697340 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335786, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2770609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755558882, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2774739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558477129, ExchCode = 'DEU' WHERE SecCode = 2813079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381707, ExchCode = 'LAS' WHERE SecCode = 2817416 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761799, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2856999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21579730411, ExchCode = 'DEU' WHERE SecCode = 2857019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599521455, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2861791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478711, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2867587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 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 ValQuotePermID = 236781124630.0 WHERE SecCode = 2900868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564572205, ExchCode = 'TDG' WHERE SecCode = 2905610 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 2907002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667483136, PermQuoteStatus = 'DC', Ticker = 'CM3', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 2907243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296735, ExchCode = 'GTX' WHERE SecCode = 2907244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478659, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2909243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770742659, Ticker = 'H3D0', ExchCode = 'HAN', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 2909900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595116297, ExchCode = 'STU' WHERE SecCode = 2909901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386051, ExchCode = 'LAS' WHERE SecCode = 2911859 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PriTRBCIndPermID = 4294951546.0 WHERE SecCode = 2911861 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'VAF', ExchCode = 'UPC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-08', PermSecMapEndDate = NULL WHERE SecCode = 2912792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667493096, ExchCode = 'QTX' WHERE SecCode = 2919727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779823342, ExchCode = 'GTX' WHERE SecCode = 2924580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605132678, ExchCode = 'STU' WHERE SecCode = 2930976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568851024, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2947959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569333990, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2952372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787459, ExchCode = 'DUS', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 2963590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675024, ExchCode = 'BIV' WHERE SecCode = 2963604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21573048228, ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-12' WHERE SecCode = 2993543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786322025, ExchCode = 'BER' WHERE SecCode = 3065856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582997825, Ticker = 'RYA', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3072584 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460747, Ticker = 'OD7F', ExchCode = 'FRA' WHERE SecCode = 3076722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787344, Ticker = '42P', ExchCode = 'DUS', PermQuoteRetireDate = '2021-03-16' WHERE SecCode = 3096965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584836885, ExchCode = 'STU' WHERE SecCode = 3121331 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 3125027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587662536, ExchCode = 'STU' WHERE SecCode = 3165880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782414421, ExchCode = 'STU' WHERE SecCode = 3172340 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 PermSecMapEndDate = '2026-05-08' WHERE SecCode = 3198705 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 3198708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786090215, Ticker = 'PCFH', ExchCode = 'TDG', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 3198718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821257511, ExchCode = 'DUS' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3208816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783235612, ExchCode = 'STU' WHERE SecCode = 3213268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789234589, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3223076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747575641, ExchCode = 'QTX' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864000075, ExchCode = 'DEU' WHERE SecCode = 3229528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21683901733, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-11' WHERE SecCode = 3241570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301751, Ticker = '0EF', ExchCode = 'GTX' WHERE SecCode = 3246454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100410, ExchCode = 'QTX' WHERE SecCode = 3247170 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 3247550 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3247786 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3247789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597702791, ExchCode = 'DEU' WHERE SecCode = 3257180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684752, ExchCode = 'QTX' WHERE SecCode = 3259344 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598341840, ExchCode = 'FRA', PermQuoteRetireDate = '2024-08-13', PermSecMapEndDate = '2024-08-13' WHERE SecCode = 3260030 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951828.0 WHERE SecCode = 3276316 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951244.0 WHERE SecCode = 3276805 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 3277044 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 3277180 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 3277236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781520286, ExchCode = 'QTX' WHERE SecCode = 3281992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836545363, ExchCode = 'FRA' WHERE SecCode = 3282311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602047609, ExchCode = 'MUN' WHERE SecCode = 3282881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119327, ExchCode = 'BER' WHERE SecCode = 3285184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 3296840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611220164, ExchCode = 'TDG' WHERE SecCode = 3317384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912102337, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3319868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669843042, ExchCode = 'TDG', PermQuoteRetireDate = '2023-05-29', PermSecMapEndDate = '2025-05-19' WHERE SecCode = 3320334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632742048, ExchCode = 'MUN' WHERE SecCode = 3320375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744276970, ExchCode = 'DEU' WHERE SecCode = 3337716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704191, ExchCode = 'MXQ' WHERE SecCode = 3338588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705783, ExchCode = 'MXQ' WHERE SecCode = 3358492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875267, ExchCode = 'TDG' WHERE SecCode = 3368562 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 3379024 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21765833817, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3379451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766019467, ExchCode = 'DEU' WHERE SecCode = 3386374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650199, ExchCode = 'DUS' WHERE SecCode = 3392279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141211, Ticker = 'PEYSl', ExchCode = 'SIG' WHERE SecCode = 3392282 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 3392497 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3393973 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659667, ExchCode = 'LAS' WHERE SecCode = 3394497 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3396000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461914, ExchCode = 'STU', PermQuoteRetireDate = '2017-10-26', PermSecMapEndDate = '2017-10-26' WHERE SecCode = 3402759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141123, ExchCode = 'FRA' WHERE SecCode = 3405304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628652762, ExchCode = 'STU', PermQuoteRetireDate = '2024-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3405438 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3405693 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624076993, ExchCode = 'SGO' WHERE SecCode = 3406544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388177, ExchCode = 'LAS' WHERE SecCode = 3409178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397561, ExchCode = 'FRA' WHERE SecCode = 3409182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752240759, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-23', PermSecMapEndDate = NULL WHERE SecCode = 3409186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802292832, ExchCode = 'FRA' WHERE SecCode = 3409193 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3409644 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3429657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100439, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 3429810 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 3433023 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3433491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636056227, ExchCode = 'FRA' WHERE SecCode = 3435060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21834281133, ExchCode = 'TDG' WHERE SecCode = 3438714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640693423, ExchCode = 'MUN' WHERE SecCode = 3439465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643223177, ExchCode = 'FRA' WHERE SecCode = 3444252 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 3444694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' 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 = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705539, ExchCode = 'MXQ' WHERE SecCode = 3501496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387110, ExchCode = 'LAS' WHERE SecCode = 3501595 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776247331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3503523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3514007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652333996, ExchCode = 'DEU' WHERE SecCode = 3526149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272845, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3526200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830311889, ExchCode = 'GTX' WHERE SecCode = 3532733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 3543178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21657050427, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3555045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21688418703, ExchCode = 'QTX', PermQuoteRetireDate = '2023-02-07', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 3565802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747333186, ExchCode = 'FRA' WHERE SecCode = 3584556 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879563449, ExchCode = 'MUN' WHERE SecCode = 3587019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584408989, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-06' WHERE SecCode = 3587027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21686828257, Ticker = '8EC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-18' WHERE SecCode = 3587066 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598347922, ExchCode = 'CHA' WHERE SecCode = 3588027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752247684, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 3588035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836427906, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-05' WHERE SecCode = 3588045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789515091, ExchCode = 'QTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 3623818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3635502 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 3635510 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3635527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818102039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3658775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672845691, ExchCode = 'DEU' WHERE SecCode = 3675648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21838659590, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3719703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681872326, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3754712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744254204, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3809860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690815100, ExchCode = 'DEU' WHERE SecCode = 3817679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801932282, ExchCode = 'DEU' WHERE SecCode = 3827962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'DADC' WHERE SecCode = 3845903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858543, ExchCode = 'QTX' WHERE SecCode = 3852867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' WHERE SecCode = 3883708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702763885, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3890307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703900276, ExchCode = 'TDG' WHERE SecCode = 3898812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703664166, ExchCode = 'STU' WHERE SecCode = 3898813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363513, ExchCode = 'BIV' WHERE SecCode = 3980893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21717475126, ExchCode = 'LSE' WHERE SecCode = 3991555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 4005353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 4031978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725824212, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4043042 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838220597, Ticker = 'OCPET', ExchCode = 'BRU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 4046600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997890, ExchCode = 'FRA' WHERE SecCode = 4046659 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796330824, ExchCode = 'HAM' WHERE SecCode = 4046669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700183747, Ticker = NULL, ExchCode = 'MXQ' WHERE SecCode = 4054118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729412447, ExchCode = 'FRA' WHERE SecCode = 4059429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729887692, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = NULL WHERE SecCode = 4062000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781158017, ExchCode = 'STU' WHERE SecCode = 4080599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732154086, ExchCode = 'DEU' WHERE SecCode = 4080678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21769039392, ExchCode = 'MXQ' WHERE SecCode = 4087443 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 = 236799881746, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 4101126 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4103442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976737, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951941315, ExchCode = 'QTX' 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 = 21778719260, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737966439, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4124713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746822092, ExchCode = 'STU' WHERE SecCode = 4201732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 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 = 236781486447, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752247732, ExchCode = 'DEU' WHERE SecCode = 4240638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388456, ExchCode = 'LAS' WHERE SecCode = 4248820 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 = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760588255, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-16', PermSecMapEndDate = NULL WHERE SecCode = 4259226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767996853, ExchCode = 'DEU' WHERE SecCode = 4278854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757260470, ExchCode = 'DEU' WHERE SecCode = 4278855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757506160, ExchCode = 'FRA' WHERE SecCode = 4278857 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4288890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759098760, ExchCode = 'DEU' WHERE SecCode = 4291265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768111804, PermQuoteStatus = 'DC', Ticker = '9EG', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 4296979 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 = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709367298, ExchCode = 'MXQ' WHERE SecCode = 4324371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727341343, ExchCode = 'MEX' WHERE SecCode = 4324380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764731671, ExchCode = 'FRA' WHERE SecCode = 4333278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764731715, ExchCode = 'FRA' WHERE SecCode = 4333279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767182082, ExchCode = 'FRA' WHERE SecCode = 4344344 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753445621, Ticker = 'NFL3', ExchCode = 'LSE' WHERE SecCode = 4346685 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766464017, ExchCode = 'DEU' WHERE SecCode = 4357523 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000112927, PriInstrPermID = 21625648120.0, IsPrimaryInstr = 1, PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 4359904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770221758, ExchCode = 'DEU' WHERE SecCode = 4360099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787724495, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-07-02' WHERE SecCode = 4362679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782583016, ExchCode = 'DUS' WHERE SecCode = 4365804 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791494702, PermQuoteStatus = 'AC', ExchCode = 'JAX', PermQuoteRetireDate = NULL WHERE SecCode = 4365821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388599, ExchCode = 'LAS' WHERE SecCode = 4365921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772643207, ExchCode = 'FRA' WHERE SecCode = 4369871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650381, ExchCode = 'QTX' WHERE SecCode = 4379790 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960079950, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4380746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349092, ExchCode = 'BIV' WHERE SecCode = 4382991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773601121, ExchCode = 'BTE', PermQuoteRetireDate = '2020-10-16' WHERE SecCode = 4385232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775811751, ExchCode = 'DEU' WHERE SecCode = 4385268 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 4388110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776453009, ExchCode = 'FRA' WHERE SecCode = 4388208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778023548, ExchCode = 'FRA' WHERE SecCode = 4394781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777507955, ExchCode = 'MUN' WHERE SecCode = 4394782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780150286, ExchCode = 'MUN' WHERE SecCode = 4400153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778893656, ExchCode = 'DEU', PermQuoteRetireDate = '2020-11-23', PermSecMapEndDate = '2020-11-17' WHERE SecCode = 4400157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779363624, ExchCode = 'DEU' WHERE SecCode = 4402242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791222495, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-17', PermSecMapEndDate = '2026-02-17' WHERE SecCode = 4402244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779363671, ExchCode = 'FRA' WHERE SecCode = 4402245 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 = 21780353097, ExchCode = 'DUS' WHERE SecCode = 4420922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22085311658, ExchCode = 'DEU' WHERE SecCode = 4425728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013269, Ticker = '2VTRS' WHERE SecCode = 4427826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 4429632 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777464439, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4429684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21765297146, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-20', PermSecMapEndDate = '2022-06-20' WHERE SecCode = 4434404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 4442678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786685967, ExchCode = 'FRA' WHERE SecCode = 4444002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740612, ExchCode = 'LAS' WHERE SecCode = 4449679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727302427, ExchCode = 'BIV' WHERE SecCode = 4451140 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789567035, ExchCode = 'DEU' WHERE SecCode = 4458936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789568350, ExchCode = 'DEU' WHERE SecCode = 4458938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805024436, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4462869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367131, ExchCode = 'FRA' WHERE SecCode = 4463145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791480096, ExchCode = 'DEU' WHERE SecCode = 4463148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21792050282, ExchCode = 'QTX' WHERE SecCode = 4463150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307029, ExchCode = 'SGO' WHERE SecCode = 4464699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888293855, PermQuoteStatus = 'AC', Ticker = 'STSLa', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 4466437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796647312, ExchCode = 'STU' WHERE SecCode = 4472909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794060560, ExchCode = 'STU' WHERE SecCode = 4472910 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396601, ExchCode = 'FRA' WHERE SecCode = 4472926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942173, ExchCode = 'STU' WHERE SecCode = 4472927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781158026, ExchCode = 'STU' WHERE SecCode = 4474245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817566, ExchCode = 'FRA' WHERE SecCode = 4481115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367409, ExchCode = 'FRA' WHERE SecCode = 4482720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512118, PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 4487664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727342533, ExchCode = 'BIV' WHERE SecCode = 4492131 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555598, ExchCode = 'FRA' WHERE SecCode = 4496736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798383377, ExchCode = 'TDG' WHERE SecCode = 4500475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798383553, ExchCode = 'DEU' WHERE SecCode = 4502474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798577575, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4502498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287355, ExchCode = 'BIV' WHERE SecCode = 4505578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285966, ExchCode = 'GTX' WHERE SecCode = 4505789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813169859, ExchCode = 'TDG' WHERE SecCode = 4511506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801932254, ExchCode = 'FRA' WHERE SecCode = 4522869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781829968, ExchCode = 'QTX' WHERE SecCode = 4526144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387389, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4527883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 4531613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803771947, ExchCode = 'DEU' WHERE SecCode = 4536359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809121292, Ticker = '0RW', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-22', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804415050, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4539323 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349197, ExchCode = 'MEX' WHERE SecCode = 4550708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893554100, ExchCode = 'FRA' WHERE SecCode = 4554184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799305062, ExchCode = 'FRA' WHERE SecCode = 4557948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808950993, ExchCode = 'FRA' WHERE SecCode = 4568422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808951005, ExchCode = 'DEU' WHERE SecCode = 4568423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809547031, ExchCode = 'DEU' WHERE SecCode = 4568462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991582, ExchCode = 'DEU' WHERE SecCode = 4579689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860615572, ExchCode = 'STU' WHERE SecCode = 4585453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836865415, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4598716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782463495, ExchCode = 'QTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815153830, ExchCode = 'FRA' WHERE SecCode = 4603534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888036736, ExchCode = 'STU' WHERE SecCode = 4603537 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4607553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817036435, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 4607686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816241209, ExchCode = 'STU' WHERE SecCode = 4607717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138517569, ExchCode = 'BTE' WHERE SecCode = 4609997 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4611003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045075404, ExchCode = 'LAS' WHERE SecCode = 4613099 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4616759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821642083, ExchCode = 'BTE', PermQuoteRetireDate = '2025-08-05' WHERE SecCode = 4617741 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4633110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822364738, ExchCode = 'TDG' WHERE SecCode = 4634352 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 PermSecMapEndDate = '2026-05-09' WHERE SecCode = 4638781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823073593, ExchCode = 'FRA' WHERE SecCode = 4639568 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 4639596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334865, ExchCode = 'FRA' WHERE SecCode = 4643318 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 4646583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312261, ExchCode = 'GTX' WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4650985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825617109, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827621995, Ticker = 'FWR', ExchCode = 'FRA' WHERE SecCode = 4657695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21848696115, ExchCode = 'GTX' WHERE SecCode = 4658662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388759, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4658881 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 55835372179.0, ValQuotePermID = 55839301037.0 WHERE SecCode = 4661372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832851078, ExchCode = 'DEU', DomCntry = 'CHN' WHERE SecCode = 4676228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837157058, Ticker = 'ANORAo', ExchCode = 'STO' WHERE SecCode = 4692322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 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 PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4712596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531721142, Ticker = 'B8D', ExchCode = 'DUS', PermQuoteRetireDate = '2014-10-03' WHERE SecCode = 4717099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854409786, PermQuoteStatus = 'AC', Ticker = 'GSPl', ExchCode = 'TRQ', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4761540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439459, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4774934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921513349, Ticker = 'A6I', ExchCode = 'QTX' WHERE SecCode = 4792475 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 25727217499.0 WHERE SecCode = 4802265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161390154, Ticker = 'CON3l', ExchCode = 'CHI' WHERE SecCode = 4806678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886807336, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15' WHERE SecCode = 4811144 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951541.0 WHERE SecCode = 4816837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862998607, ExchCode = 'QTX' WHERE SecCode = 4818264 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4818274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684618, ExchCode = 'DUS' WHERE SecCode = 4818275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874648333, Ticker = '9XK', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4873803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880715135, ExchCode = 'QTX' WHERE SecCode = 4927268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882166752, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806835525, ExchCode = 'LAS' WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 4969534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5013431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 25727217499.0 WHERE SecCode = 5037220 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951541.0 WHERE SecCode = 5042937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607201, Ticker = 'DXCM', ExchCode = 'SWX' WHERE SecCode = 5047087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL WHERE SecCode = 5085786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729398003, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-31' WHERE SecCode = 5099028 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5128568 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5128569 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5128570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950535489, ExchCode = 'FRA' WHERE SecCode = 5134589 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'DOTL' WHERE SecCode = 5155320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916823, ExchCode = 'MUN' WHERE SecCode = 5161225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341320, Ticker = 'RPG', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 5161292 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727308116, ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21657632265, Ticker = 'FT5', ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-04' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948058908, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5162437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 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 = 236794004180, ExchCode = 'QTX' WHERE SecCode = 5239813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173435, ExchCode = 'MEX' WHERE SecCode = 5241334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937069015, ExchCode = 'STU' WHERE SecCode = 5272089 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 5272169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775732426, ExchCode = 'BIV' WHERE SecCode = 5329511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' WHERE SecCode = 5343623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059910, ExchCode = 'FRA' WHERE SecCode = 5354968 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5357356 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 5360724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007472, ExchCode = 'DEU' WHERE SecCode = 5381858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007494, ExchCode = 'DEU' WHERE SecCode = 5381859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007540, ExchCode = 'FRA' WHERE SecCode = 5381860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007249, ExchCode = 'FRA' WHERE SecCode = 5381861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776581931, ExchCode = 'MEX' WHERE SecCode = 5381916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727195024, ExchCode = 'BIV' WHERE SecCode = 5381947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223779, ExchCode = 'QTX' WHERE SecCode = 5395767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378859, ExchCode = 'FRA' WHERE SecCode = 5415164 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 5418879 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 5430794 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5443547 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 5446096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 5453396 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776268320, ExchCode = 'MEX' WHERE SecCode = 5455239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779165176, ExchCode = 'STU' WHERE SecCode = 5476926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818729656, ExchCode = 'DEU' WHERE SecCode = 5478214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778456487, ExchCode = 'FRA' WHERE SecCode = 5479512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778659888, ExchCode = 'BIV' WHERE SecCode = 5496143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932421406, PermQuoteStatus = 'AC', Ticker = '3LFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5496168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982260691, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5496242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982274729, Ticker = '3BAS', ExchCode = 'MIL' WHERE SecCode = 5496244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727277713, ExchCode = 'MEX' WHERE SecCode = 5503675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904150, ExchCode = 'CHI' WHERE SecCode = 5503692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823945, ExchCode = 'AQE' WHERE SecCode = 5503780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663720, ExchCode = 'AQE' WHERE SecCode = 5503782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776471889, ExchCode = 'BIV' WHERE SecCode = 5503860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836309751, Ticker = '3LPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5503872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010091546, Ticker = 'BTCCHz', ExchCode = 'TQE' WHERE SecCode = 5509588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776850450, ExchCode = 'BIV' WHERE SecCode = 5516778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777795274, ExchCode = 'MEX' WHERE SecCode = 5516779 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 5526351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779309034, ExchCode = 'MUN' WHERE SecCode = 5527560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21988984185, ExchCode = 'DEU' WHERE SecCode = 5527561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21988688380, ExchCode = 'MXQ' WHERE SecCode = 5531898 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 = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535820, ExchCode = 'BIV' WHERE SecCode = 5539536 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360208, ExchCode = 'BIV' WHERE SecCode = 5541703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5544127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782890677, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 5550739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776857975, ExchCode = 'BIV' WHERE SecCode = 5551974 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 = 21995078680, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 5563110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834791, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 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 = 21917835613, Ticker = '3AKWl', ExchCode = 'EQD', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 5569299 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917830166, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5569303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970566165, ExchCode = 'DEU' WHERE SecCode = 5569313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591864463, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970566180, ExchCode = 'FRA' WHERE SecCode = 5569354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970566250, ExchCode = 'GER' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360205, ExchCode = 'BIV' WHERE SecCode = 5581641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152999678, Ticker = 'NGLSl', ExchCode = 'AQX' WHERE SecCode = 5584733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 5626284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 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 = 236781095333, ExchCode = 'STU' WHERE SecCode = 5633895 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 5635825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714446430, ExchCode = 'DXE' WHERE SecCode = 5638833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460790, ExchCode = 'GER' WHERE SecCode = 5638838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835007, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5638905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954864, ExchCode = 'LAS' WHERE SecCode = 5655040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089214794, Ticker = '3TSEd', ExchCode = 'BTE' WHERE SecCode = 5663514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781343894, ExchCode = 'TDG' WHERE SecCode = 5663580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028682766, Ticker = '2HENS' WHERE SecCode = 5720895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028890988, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-30' WHERE SecCode = 5724940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22029843866, ExchCode = 'DEU' WHERE SecCode = 5731414 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 5738387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772643122, Ticker = '4U1', ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-31' WHERE SecCode = 5740839 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783112234, ExchCode = 'FRA' WHERE SecCode = 5764130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154585726, Ticker = 'WXBTl', ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802153233, Ticker = 'RZ8Bd', ExchCode = 'BCO' WHERE SecCode = 5782810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783674147, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5803178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784236560, ExchCode = 'STU' WHERE SecCode = 5822326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784236496, ExchCode = 'FRA' WHERE SecCode = 5822327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357764, ExchCode = 'MEX' WHERE SecCode = 5836309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784711460, ExchCode = 'GTX' WHERE SecCode = 5839259 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386888, ExchCode = 'LAS' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5848777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786494467, ExchCode = 'GTX' WHERE SecCode = 5871394 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 5885543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 5900249 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 = 21772839701, ExchCode = 'DEU' WHERE SecCode = 5908811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 5944557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798309817, ExchCode = 'FRA' WHERE SecCode = 5947065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786800651, ExchCode = 'FRA' WHERE SecCode = 5947076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799223625, ExchCode = 'TQE' WHERE SecCode = 5959461 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 6006787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788967709, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6050973 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381827, ExchCode = 'LAS' WHERE SecCode = 6065904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386194, ExchCode = 'FRA' WHERE SecCode = 6065905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 6097355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970293346, ExchCode = 'MUN' WHERE SecCode = 6097356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580161, ExchCode = 'DEU' WHERE SecCode = 6097360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892052934, ExchCode = 'DEU' WHERE SecCode = 6097368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674562, ExchCode = 'BIV' WHERE SecCode = 6097401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779005194, PermQuoteStatus = 'AC', Ticker = '5VF', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782305154, ExchCode = 'MEX' WHERE SecCode = 6097558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354555, ExchCode = 'MEX' WHERE SecCode = 6097578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 6097580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6100251 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 25727351915.0 WHERE SecCode = 6119488 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ALPG', ExchCode = 'PAR' WHERE SecCode = 6123552 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 6139857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791216534, ExchCode = 'FRA' WHERE SecCode = 6186428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 6305192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806766676, ExchCode = 'GER' WHERE SecCode = 6318935 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 6324026 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808950961, ExchCode = 'DEU' WHERE SecCode = 6364834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794188795, ExchCode = 'DUS' WHERE SecCode = 6392491 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 6433104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125760536, ExchCode = 'MIL' WHERE SecCode = 6453964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141447621, ExchCode = 'CHI' WHERE SecCode = 6456375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184300, ExchCode = 'FRA' WHERE SecCode = 6464981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184668, ExchCode = 'FRA' WHERE SecCode = 6464987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6569458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607163, Ticker = 'AI', ExchCode = 'SWX' WHERE SecCode = 6578367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22147097785, ExchCode = 'DEU' WHERE SecCode = 6603628 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 6622165 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6622347 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6622348 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 6626331 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 = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806018926, ExchCode = 'LAS' WHERE SecCode = 6628800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802455738, ExchCode = 'QTX' WHERE SecCode = 6638341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 6654548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798361886, ExchCode = 'BIV' WHERE SecCode = 6661586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806834215, ExchCode = 'TDG' WHERE SecCode = 6684031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803478723, ExchCode = 'DUS' WHERE SecCode = 6686044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804778699, ExchCode = 'GTX' WHERE SecCode = 6721535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804484008, ExchCode = 'DUS' WHERE SecCode = 6727870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 6756271 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6762055 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6765361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22144789874, ExchCode = 'DEU' WHERE SecCode = 6773256 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6786554 AND Type_ = 10; UPDATE data_universe_permid SET InstrClass = 'FULLPAID' WHERE SecCode = 6789483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22140087946, ExchCode = 'HAM' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6796817 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6796818 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6797278 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 6802646 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6802656 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21928321732.0, IsPrimaryInstr = 1 WHERE SecCode = 6806346 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6808801 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6813230 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6813249 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 6813273 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6813824 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6813825 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6813860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176578988, ExchCode = 'DEU' WHERE SecCode = 6820242 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6826511 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 6829239 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806598704.0, IsPrimaryInstr = 1, PermInstrStatus = 'AC' WHERE SecCode = 6829246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22177707113, ExchCode = 'DEU' WHERE SecCode = 6829248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806834221, ExchCode = 'MUN' WHERE SecCode = 6832574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806834214, ExchCode = 'GTX' WHERE SecCode = 6832575 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2026-05-08' WHERE SecCode = 6836129 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 10870569 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 10934601 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 10965563 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LMED' WHERE SecCode = 10971474 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'AGNT' WHERE SecCode = 10985859 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11004045 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 11007560 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11049340 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11051526 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11051804 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11055957 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'WMWWF' WHERE SecCode = 11058430 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11061263 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11074248 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 236781124630.0 WHERE SecCode = 11079898 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11133802 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'NXTBF' WHERE SecCode = 11143934 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11163321 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11174616 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000112927, PriInstrPermID = 21625648120.0, IsPrimaryInstr = 1, PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11182728 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11185026 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11185713 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11186317 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11195314 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 25727351915.0 WHERE SecCode = 11206349 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11210863 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11211909 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11213629 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11215176 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11219879 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11221464 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000113076, PriInstrPermID = 25727262629.0, IsPrimaryInstr = 1, PermOrgIPODate = NULL WHERE SecCode = 11224790 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11226193 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236793812717, ExchCode = 'GTC', PermQuoteRetireDate = '2026-05-11', PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11226945 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11228341 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11229735 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11240840 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SPODD', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11242346 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11250292 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11250462 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000051984, PriInstrPermID = 25727171616.0, IncCntry = 'VGB', PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 11256200 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11265135 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11268752 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11268849 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11269370 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11271538 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'BRUN', PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11273589 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11277237 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 11281412 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11281937 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11281950 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-09' WHERE SecCode = 11281952 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'ENHA', ExchCode = 'NYS' WHERE SecCode = 11284217 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11284218 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287719 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287721 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287723 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287726 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287890 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11287988 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11287992 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11287993 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11287994 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11287995 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11287996 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291473 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291474 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291477 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291520 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291524 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291526 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 25727217499.0 WHERE SecCode = 11291834 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11292705 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11293243 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232896022139.0 WHERE SecCode = 11293509 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11293982 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11294294 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11294535 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = 236806601937.0, ValQuotePermID = 25727024155.0, PermInstrStatus = 'AC' WHERE SecCode = 11295445 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 11295462 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2026-05-08' WHERE SecCode = 11295603 AND Type_ = 1;