UPDATE data_universe_permid SET QuotePermID = 236807338493, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'OCU', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475374164, InstrPermID = 21475374163, ValQuotePermID = 21475374164.0 WHERE SecCode = 3582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475562628, Ticker = 'KFX', ExchCode = 'VTX', PermQuoteRetireDate = '2009-02-02' WHERE SecCode = 3735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475297975, InstrPermID = 21475297974, ValQuotePermID = 21475297975.0 WHERE SecCode = 4311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475504986, PermQuoteStatus = 'DC', Ticker = '50IT', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 4425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475530609, Ticker = 'PCI', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 4613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632440939, Ticker = '0R1M', ExchCode = 'LSE' WHERE SecCode = 4727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475442982, Ticker = 'XAN', ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475585602, Ticker = 'GEC.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 5363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836048431, Ticker = 'HTIA', ExchCode = 'LSE' WHERE SecCode = 5899 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6023 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21474862736, Ticker = 'COLTl', ExchCode = 'TRQ', PermQuoteRetireDate = '2015-09-11' WHERE SecCode = 6070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531128392, PermQuoteStatus = 'DC', Ticker = 'HKLBl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-03-13' WHERE SecCode = 6257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535939867, Ticker = 'H78l', ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 6260 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11689 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0, PermOrgIPODate = NULL WHERE SecCode = 12040 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 15282 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 28602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835814663, ExchCode = 'MEX' WHERE SecCode = 30131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835815676, ExchCode = 'MEX' WHERE SecCode = 30156 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 = 21475561654, PermQuoteStatus = 'DC', Ticker = 'ALDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475528814, Ticker = 'APC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 34584 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475625018, Ticker = 'BTLG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475526711, ExchCode = 'BTE', PermQuoteRetireDate = '2019-05-13' WHERE SecCode = 35062 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475201898, Ticker = 'EF1', ExchCode = 'GER', PermQuoteRetireDate = '2008-01-30' WHERE SecCode = 35078 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 35685 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034922, ExchCode = 'TDG' WHERE SecCode = 37437 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 37631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661362178, ExchCode = 'STU' WHERE SecCode = 38188 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 39239 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 39821 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 40255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836340086, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 40818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954104507, ExchCode = 'DUS', PermQuoteRetireDate = '2025-07-14' WHERE SecCode = 41008 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 41354 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 43006 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 43141 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 43408 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 PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 44975 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 44976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853561637, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 45959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341602, ExchCode = 'BER' WHERE SecCode = 46521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB' WHERE SecCode = 46535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836325490, ExchCode = 'BER', PermQuoteRetireDate = '2010-04-30' WHERE SecCode = 47291 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 47683 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 47699 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 48629 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 49407 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 49435 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 49442 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 49620 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 49698 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 50719 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 50788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035175, Ticker = '6MK', ExchCode = 'TDG' WHERE SecCode = 50904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667487924, ExchCode = 'QTX' WHERE SecCode = 51369 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 51474 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52016 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474992361, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 52116 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52286 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52487 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642496474, ExchCode = 'BTE' WHERE SecCode = 52632 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52734 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 52789 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 52790 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53104 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475622852, PermQuoteStatus = 'DC', Ticker = 'CPFG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53315 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53347 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53374 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475589631, Ticker = 'L0992', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53991 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 54226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584354094, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 54284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606631214, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 54449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475605291, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 54451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474895146, Ticker = 'QH9', ExchCode = 'DEU' WHERE SecCode = 54545 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475417017, ExchCode = 'STU', PermQuoteRetireDate = '2009-11-18' WHERE SecCode = 54686 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 55127 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 55128 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 55418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475704092, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 55631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581499119, ExchCode = 'STU' WHERE SecCode = 58724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475248718, ExchCode = 'BER', PermQuoteRetireDate = '2006-04-12' WHERE SecCode = 59993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475453786, Ticker = 'GT6', ExchCode = 'MUN', PermQuoteRetireDate = '2009-04-01' WHERE SecCode = 60026 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475457917, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2007-11-28' WHERE SecCode = 60090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034623, ExchCode = 'TDG' WHERE SecCode = 60224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475577390, PermQuoteStatus = 'DC', Ticker = 'ESHG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', PermSecMapEndDate = '2025-09-05' WHERE SecCode = 60348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667469915, ExchCode = 'QTX' WHERE SecCode = 60373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489174, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 60456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475572974, Ticker = 'NSUG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837359160, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339081, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 60939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323328, ExchCode = 'BER' WHERE SecCode = 61012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475360806, ExchCode = 'MUN' WHERE SecCode = 61743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475722169, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 61952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474899218, Ticker = 'ACOMA', ExchCode = 'BUR', PermQuoteRetireDate = '2013-02-01' WHERE SecCode = 61968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475442671, ExchCode = 'STU' WHERE SecCode = 62105 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 62323 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 62324 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033713, PermQuoteStatus = 'AC', Ticker = 'AK3', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 62376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582638261, ExchCode = 'TDG' WHERE SecCode = 63004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874654411, ExchCode = 'GTX' WHERE SecCode = 63011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917173961, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 63016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789215725, ExchCode = 'FRA' WHERE SecCode = 63138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475548758, Ticker = 'NCOD.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 63145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328756, Ticker = 'ESD', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63218 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475081839, PermQuoteStatus = 'DC', ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14' WHERE SecCode = 63223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851456817, ExchCode = 'FRA', PermQuoteRetireDate = '2016-04-05' WHERE SecCode = 63618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615370664, ExchCode = 'STU' WHERE SecCode = 63841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564888482, ExchCode = 'FRA' WHERE SecCode = 63846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531129138, Ticker = 'ISC1d', ExchCode = 'BCO', PermQuoteRetireDate = '2013-11-20' WHERE SecCode = 64275 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 64526 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 65132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836422897, ExchCode = 'FRA' WHERE SecCode = 65261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341183, Ticker = 'RDV', ExchCode = 'BER', PermQuoteRetireDate = '2012-06-07' WHERE SecCode = 65270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546164752, ExchCode = 'TDG' WHERE SecCode = 65298 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482532, ExchCode = 'QTX' WHERE SecCode = 65308 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 65462 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 65486 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 68280 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808161669, ExchCode = 'NAS', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 69221 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951691.0 WHERE SecCode = 77119 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 80356 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 80894 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'HLX', PermSecMapStartDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 82750 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 83839 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 85118 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951691.0 WHERE SecCode = 86474 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87258 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 87909 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 88260 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 100724 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 100725 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 100765 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 101033 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 101432 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102597 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102598 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102656 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102659 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102789 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 103608 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 103626 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 104502 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 104505 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 105646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 115719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298391, ExchCode = 'FRA' WHERE SecCode = 117723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475008736, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 117729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807026221, ExchCode = 'FRA' WHERE SecCode = 119132 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 121264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21556336781, ExchCode = 'STU' WHERE SecCode = 124617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997865, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-23' WHERE SecCode = 128755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526528181, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 133354 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 137931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997893, ExchCode = 'FRA' WHERE SecCode = 138040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855827479, ExchCode = 'GER', PermQuoteRetireDate = '2022-05-03' WHERE SecCode = 138261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780784306, ExchCode = 'FRA' WHERE SecCode = 138279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799955011, ExchCode = 'LAS' WHERE SecCode = 138280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324001, ExchCode = 'BER' WHERE SecCode = 138285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330438, Ticker = 'H1BN', ExchCode = 'BER', PermQuoteRetireDate = '2013-07-19' WHERE SecCode = 138286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843446932, ExchCode = 'FRA' WHERE SecCode = 138806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341772, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 139011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655828004, ExchCode = 'FRA', PermQuoteRetireDate = '2023-09-15' WHERE SecCode = 139013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681564795, ExchCode = 'MUN' WHERE SecCode = 139159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840759900, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 139165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335448, ExchCode = 'BER', PermQuoteRetireDate = '2014-12-23' WHERE SecCode = 139167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475829465, ExchCode = 'STU' WHERE SecCode = 139233 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 139991 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 140181 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 140777 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 140778 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 140779 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 140780 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 142405 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 142774 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 142868 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 142869 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 142911 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 142912 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 143418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 144655 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 144739 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 144798 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 145138 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 145498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527770884, ExchCode = 'DEU' WHERE SecCode = 145508 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146271 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146274 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146275 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146283 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146993 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 147051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798819754, ExchCode = 'MUN' WHERE SecCode = 147190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808268922, ExchCode = 'FRA', PermSecMapStartDate = '2026-06-10' WHERE SecCode = 147590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684961175, ExchCode = 'MUN' WHERE SecCode = 147900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782821783, ExchCode = 'MUN' WHERE SecCode = 147907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521106330, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-09' WHERE SecCode = 147913 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55846008505, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-31' WHERE SecCode = 147917 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152778, ExchCode = 'MUN' WHERE SecCode = 147929 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 152321 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 164342 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 174366 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 174379 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 174698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661437570, ExchCode = 'STU' WHERE SecCode = 190498 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 193572 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 193577 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 193584 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 195260 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 195261 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 196046 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 198963 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 198965 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 199366 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 201923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808270031, Ticker = 'TLM', ExchCode = 'LAS' WHERE SecCode = 202188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 239069 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 239119 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 240051 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241473 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241628 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241763 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241799 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241853 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241854 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241855 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 242961 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 243444 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 248903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 273592 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 273593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 289646 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 295229 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 296968 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 304137 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 304139 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 304910 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 304911 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 331012 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 335219 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 335229 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 336728 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 340529 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 364378 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 377777 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 387519 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 388195 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 388224 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 390108 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 395077 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 401891 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 404801 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 406738 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 411421 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 411422 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 418050 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 425032 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 451447 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 482402 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 507425 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 512421 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 519058 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 529509 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 529767 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 529771 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 530685 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 531911 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 534985 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 542968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672230145, ExchCode = 'DUS' WHERE SecCode = 548626 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 551009 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 553534 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 556414 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557708 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557833 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557841 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557873 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557883 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557887 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 557921 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 561090 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 561395 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 593104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 631360 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 649934 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 703334 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 703456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22002746026, Ticker = 'XBEC', ExchCode = 'SWX' WHERE SecCode = 737768 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 876010 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 903597 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236793424076.0 WHERE SecCode = 940796 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 946701 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 969081 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1012255 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1154894 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1184875 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1243626 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1246746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21504490118, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-02' WHERE SecCode = 1457731 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1467691 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951937.0 WHERE SecCode = 1531716 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1631826 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1631858 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1631933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512394267, Ticker = 'CTY1SN0112', ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685431652, ExchCode = 'FRA' WHERE SecCode = 1707747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641955323, ExchCode = 'DEU' WHERE SecCode = 1707749 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1773399 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 1929718 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 2083922 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2091178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 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 = 21521092450, ExchCode = 'STO', PermQuoteRetireDate = '2024-03-27' WHERE SecCode = 2195912 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 = 21644782383, ExchCode = 'FRA' WHERE SecCode = 2222230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569830, ExchCode = 'QTX' WHERE SecCode = 2239280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523563544, ExchCode = 'FRA' WHERE SecCode = 2239343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2251487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535950995, ExchCode = 'STU' WHERE SecCode = 2255684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524954693, ExchCode = 'FRA' WHERE SecCode = 2267521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528507836, ExchCode = 'DEU' WHERE SecCode = 2332152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662115406, ExchCode = 'FRA' WHERE SecCode = 2339259 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA' WHERE SecCode = 2356509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656676252, ExchCode = 'BIV' WHERE SecCode = 2359427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530094550, ExchCode = 'MUN' WHERE SecCode = 2362509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780887285, ExchCode = 'CHI' WHERE SecCode = 2365610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308547, ExchCode = 'GTX' WHERE SecCode = 2377960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381501, ExchCode = 'LAS' WHERE SecCode = 2379809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890421682, ExchCode = 'STU' WHERE SecCode = 2388898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531978999, ExchCode = 'FRA' WHERE SecCode = 2391351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921479660, ExchCode = 'GTX' WHERE SecCode = 2391353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071614, ExchCode = 'MUN' WHERE SecCode = 2394797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535834662, PermQuoteStatus = 'AC', Ticker = 'C68', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2397376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527246, ExchCode = 'FRA' WHERE SecCode = 2414149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824100155, ExchCode = 'TDG' WHERE SecCode = 2458822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724351602, ExchCode = 'QTX' WHERE SecCode = 2462633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451292, Ticker = 'MER', ExchCode = 'SWX' WHERE SecCode = 2465112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536037221, ExchCode = 'DEU' WHERE SecCode = 2467266 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2469444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537024389, ExchCode = 'DEU' WHERE SecCode = 2495669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999786358, ExchCode = 'BTE' WHERE SecCode = 2510129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21848757217, ExchCode = 'QTX', PermQuoteRetireDate = '2023-01-17', PermSecMapEndDate = NULL WHERE SecCode = 2519541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175073998, ExchCode = 'DEU' WHERE SecCode = 2524752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531428167, Ticker = NULL, ExchCode = 'BEC' WHERE SecCode = 2524756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521368272, ExchCode = 'SGO' WHERE SecCode = 2524779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2532922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430828, ExchCode = 'DEU' WHERE SecCode = 2542451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385094, ExchCode = 'LAS' WHERE SecCode = 2545058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562942131, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 2556599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550103570, ExchCode = 'DEU' WHERE SecCode = 2559800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543007213, ExchCode = 'MUN' WHERE SecCode = 2579447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430409, ExchCode = 'DEU' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067641916, ExchCode = 'BCO' WHERE SecCode = 2600378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662105437, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2604394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616206318, ExchCode = 'STU' WHERE SecCode = 2621782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21586820372, PermQuoteStatus = 'AC', Ticker = '14S0', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2625801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624665037, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2627627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548007507, ExchCode = 'FRA' WHERE SecCode = 2640373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561270622, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-12' WHERE SecCode = 2643269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659184279, ExchCode = 'MUN' WHERE SecCode = 2644157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789432566, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2644161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548207169, ExchCode = 'DEU' WHERE SecCode = 2644168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587934135, ExchCode = 'FRA' WHERE SecCode = 2649166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2650622 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2650623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624667850, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-28' WHERE SecCode = 2650642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589498059, ExchCode = 'TDG' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761648844, ExchCode = 'STU' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549116547, ExchCode = 'BER' WHERE SecCode = 2655948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550408230, ExchCode = 'DEU' WHERE SecCode = 2679857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550835484, ExchCode = 'STU' WHERE SecCode = 2682326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535197291, Ticker = NULL, ExchCode = 'BRN', PermQuoteRetireDate = '2019-05-29', PermSecMapEndDate = '2019-05-29' WHERE SecCode = 2682394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535197297, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2682397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658137710, ExchCode = 'MUN', PermQuoteRetireDate = '2021-07-05' WHERE SecCode = 2693639 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384079, ExchCode = 'LAS' WHERE SecCode = 2693643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119337, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 2700711 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2701549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552007726, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2019-09-13' WHERE SecCode = 2711155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552459618, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 2718428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552380654, InstrPermID = 21550657515, OrgPermID = 5044031864, ValQuotePermID = 21551043677.0, PriInstrPermID = 21550657515.0, PermQuoteStatus = 'DC', Ticker = '3RM0', ExchCode = 'BER', OrgTypeCode = 'CINV', DomCntry = 'GGY', IncCntry = 'GGY', PriTRBCIndPermID = 4294951307.0, PermQuoteRetireDate = '2026-01-01', PermOrgIPODate = '2014-12-02' WHERE SecCode = 2718429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661562372, Ticker = 'SREn', ExchCode = 'BCO' WHERE SecCode = 2718458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552460326, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 2718461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552534967, ExchCode = 'MUN' WHERE SecCode = 2718469 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584014278, ExchCode = 'BTE', PermQuoteRetireDate = '2021-06-01' WHERE SecCode = 2720682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561687496, PermQuoteStatus = 'DC', Ticker = '5WP', ExchCode = 'GER', PermQuoteRetireDate = '2017-01-03' WHERE SecCode = 2731233 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 2731234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784881963, ExchCode = 'QTX' WHERE SecCode = 2747510 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890060428, ExchCode = 'MXQ' WHERE SecCode = 2750976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554503916, ExchCode = 'DEU' WHERE SecCode = 2750981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273861, PermQuoteStatus = 'AC', Ticker = 'XV2', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2751767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789940347, ExchCode = 'FRA' WHERE SecCode = 2764598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367145, ExchCode = 'DEU' WHERE SecCode = 2770609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322186, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2809751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557589784, ExchCode = 'DEU' WHERE SecCode = 2810887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322226, ExchCode = 'DEU' WHERE SecCode = 2812146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558562157, ExchCode = 'FRA' WHERE SecCode = 2827908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566120165, Ticker = 'T051', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672243468, ExchCode = 'MUN' WHERE SecCode = 2855817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598465846, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 2857019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781486518, ExchCode = 'MEX' WHERE SecCode = 2870132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625073348, ExchCode = 'DEU' WHERE SecCode = 2880970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562620362, ExchCode = 'MUN' WHERE SecCode = 2880972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595194710, ExchCode = 'STU' WHERE SecCode = 2887282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562944695, ExchCode = 'DEU' WHERE SecCode = 2887317 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563671243, ExchCode = 'BER' WHERE SecCode = 2893040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564309877, ExchCode = 'FRA' WHERE SecCode = 2902752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564679404, ExchCode = 'FRA' WHERE SecCode = 2907243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564682992, ExchCode = 'FRA', PermQuoteRetireDate = '2025-10-22', PermSecMapEndDate = '2025-10-22' WHERE SecCode = 2907244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564680695, ExchCode = 'DEU' WHERE SecCode = 2909231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564679416, Ticker = 'V00', ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 2909232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564939099, ExchCode = 'FRA' WHERE SecCode = 2909242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565404048, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2912969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915623096, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 2921698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566817654, ExchCode = 'FRA' WHERE SecCode = 2924580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568990720, ExchCode = 'TDG' WHERE SecCode = 2947855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569900890, ExchCode = 'STU' WHERE SecCode = 2956411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641460082, ExchCode = 'BER' WHERE SecCode = 2958533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726926, ExchCode = 'MUN' WHERE SecCode = 2975172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21706327513, ExchCode = 'TDG' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608857928, ExchCode = 'FRA' WHERE SecCode = 3008027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743260230, ExchCode = 'FRA' WHERE SecCode = 3030075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576069516, ExchCode = 'DEU' WHERE SecCode = 3031579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576576313, PermQuoteStatus = 'DC', Ticker = 'IWI', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3031598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740543, ExchCode = 'LAS' WHERE SecCode = 3038477 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479850, ExchCode = 'QTX' WHERE SecCode = 3045201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21578813192, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 3056842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788253479, ExchCode = 'BIV' WHERE SecCode = 3060652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786322025, ExchCode = 'BER' WHERE SecCode = 3065856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861160325, ExchCode = 'QTX' WHERE SecCode = 3069354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587055379, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14', PermSecMapEndDate = '2020-06-16' WHERE SecCode = 3076717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763489945, ExchCode = 'FRA' WHERE SecCode = 3120784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22124025589, ExchCode = 'DEU' WHERE SecCode = 3124127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953916121, ExchCode = 'GTX' WHERE SecCode = 3124235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320061, ExchCode = 'DEU' WHERE SecCode = 3124241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 3167823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 3184368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 3220404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609921006, ExchCode = 'STU' WHERE SecCode = 3222698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595530115, ExchCode = 'STU', PermQuoteRetireDate = '2024-06-28' WHERE SecCode = 3237127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613476472, ExchCode = 'STU' WHERE SecCode = 3247179 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 3247536 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3289743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 3319626 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780007794, ExchCode = 'DUS' WHERE SecCode = 3337692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 3339539 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623820791, ExchCode = 'EQD' WHERE SecCode = 3358414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808268924, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 3367047 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763116669, PermQuoteStatus = 'DC', Ticker = '015', ExchCode = 'BER', PermQuoteRetireDate = '2023-02-15', PermSecMapEndDate = '2023-02-15' WHERE SecCode = 3375389 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 = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 3396072 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 = 236797256368, ExchCode = 'QTX' WHERE SecCode = 3407867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629966004, ExchCode = 'FRA', PermQuoteRetireDate = '2020-02-26' WHERE SecCode = 3408843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381227, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-04' WHERE SecCode = 3408942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3433491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651603021, ExchCode = 'STU' WHERE SecCode = 3434582 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 PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3437535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644782384, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3446081 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647637329, ExchCode = 'TDG' WHERE SecCode = 3490936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647732095, ExchCode = 'STU' WHERE SecCode = 3493723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679487, ExchCode = 'BIV' WHERE SecCode = 3495824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21648024977, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3495847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668985562, ExchCode = 'BCO', PermQuoteRetireDate = '2023-01-06' WHERE SecCode = 3499290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656680001, ExchCode = 'BIV' WHERE SecCode = 3510566 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21704670922, ExchCode = 'TDG' WHERE SecCode = 3518267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652137392, ExchCode = 'STU' WHERE SecCode = 3526149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947471, ExchCode = 'DEU' WHERE SecCode = 3526199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811976566, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-04-23' WHERE SecCode = 3526200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21877129252, InstrPermID = 21503498214, OrgPermID = 5037455731, ValQuotePermID = 21504208536.0, PriInstrPermID = 21503498214.0, Ticker = '7RC0', ExchCode = 'GTX', PriTRBCIndPermID = 4294951997.0, PermOrgIPODate = '2012-05-22' WHERE SecCode = 3529090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3540555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480112, ExchCode = 'QTX' WHERE SecCode = 3540682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757243010, ExchCode = 'STU' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655132827, ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-30' WHERE SecCode = 3545357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 3551957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656632105, Ticker = 'DNK', ExchCode = 'LSE', PermQuoteRetireDate = '2021-09-24' WHERE SecCode = 3557524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679090, ExchCode = 'BIV' WHERE SecCode = 3569558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21665285787, ExchCode = 'FRA' WHERE SecCode = 3569563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681761612, ExchCode = 'DEU' WHERE SecCode = 3569619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643038215, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 3578524 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 3586933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598347922, ExchCode = 'CHA' WHERE SecCode = 3588027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788724820, ExchCode = 'STU' WHERE SecCode = 3588063 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656676540, ExchCode = 'BIV' WHERE SecCode = 3588107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667846371, ExchCode = 'FRA' WHERE SecCode = 3589051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287361, PermQuoteStatus = 'AC', Ticker = 'TLRY', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3610775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664433940, ExchCode = 'MUN' WHERE SecCode = 3610818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678046, ExchCode = 'BIV' WHERE SecCode = 3629694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 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 = 21671049443, PermQuoteStatus = 'AC', Ticker = '1SS', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3663204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636387547, Ticker = '2NFL.GB', ExchCode = 'AQS' WHERE SecCode = 3669927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812606587, ExchCode = 'DUS', PermQuoteRetireDate = '2021-12-10' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674386, ExchCode = 'BIV' WHERE SecCode = 3756608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678493, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3761051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684103049, ExchCode = 'FRA' WHERE SecCode = 3771411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185827845, Ticker = 'DB51v', ExchCode = 'BCO' WHERE SecCode = 3779950 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782196448, ExchCode = 'DUS' WHERE SecCode = 3818674 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671394405, ExchCode = 'BIV' WHERE SecCode = 3822020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744918971, ExchCode = 'FRA' WHERE SecCode = 3832747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367137, PermQuoteStatus = 'AC', Ticker = '2ZT1', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3841485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703553579, ExchCode = 'FRA' WHERE SecCode = 3897396 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 3899669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794692533, Ticker = 'IVNN', ExchCode = 'MXQ', PermQuoteRetireDate = '2024-10-16' WHERE SecCode = 3952658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363718, ExchCode = 'MEX' WHERE SecCode = 3966586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363715, ExchCode = 'MEX' WHERE SecCode = 3966587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718474201, ExchCode = 'FRA' WHERE SecCode = 3998157 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 4010955 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536122160, ExchCode = 'FRA' WHERE SecCode = 4030457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4062031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788611412, ExchCode = 'DEU' WHERE SecCode = 4209753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838963, ExchCode = 'FRA' WHERE SecCode = 4225217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534208, PermQuoteStatus = 'AC', Ticker = '0YL0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759692047, ExchCode = 'FRA' WHERE SecCode = 4295731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 4298618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763901203, ExchCode = 'QTX' WHERE SecCode = 4324503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771445002, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4359837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774613209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4379791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960077472, ExchCode = 'GTX' WHERE SecCode = 4380746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778224467, ExchCode = 'TDG' WHERE SecCode = 4395458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790711166, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-01', PermSecMapEndDate = NULL WHERE SecCode = 4395464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307570, ExchCode = 'BIV' WHERE SecCode = 4403942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780909499, ExchCode = 'FRA' WHERE SecCode = 4413712 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 = 25727377503, ExchCode = 'MEX' WHERE SecCode = 4417298 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4419208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794257515, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796141645, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4487640 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857143288, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 4550761 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 4557729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874195189, ExchCode = 'PFT' WHERE SecCode = 4566923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135794225, Ticker = 'XLME', ExchCode = 'HAM' WHERE SecCode = 4579626 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312301, ExchCode = 'GTX' WHERE SecCode = 4590581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852758913, PermQuoteStatus = 'DC', Ticker = '4KL', ExchCode = 'STU', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 4629496 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4633110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831908634, ExchCode = 'GTX' WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792996699, ExchCode = 'LAS' WHERE SecCode = 4651892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832851078, ExchCode = 'DEU' WHERE SecCode = 4676228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21833145669, ExchCode = 'FRA' WHERE SecCode = 4677605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727235147, ExchCode = 'BIV' WHERE SecCode = 4692404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873118953, ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840890512, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4709616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851158672, ExchCode = 'FRA' WHERE SecCode = 4748566 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727216819, ExchCode = 'MEX' WHERE SecCode = 4802294 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 4806673 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 4807562 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 4810073 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 QuotePermID = 236804716445, ExchCode = 'HAM' WHERE SecCode = 4815349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792865438, ExchCode = 'GTX' WHERE SecCode = 4841234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869360768, ExchCode = 'QTX' WHERE SecCode = 4847005 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 4854770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872586858, ExchCode = 'DEU' WHERE SecCode = 4873679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872790634, ExchCode = 'DEU' WHERE SecCode = 4876061 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873061105, ExchCode = 'TDG' WHERE SecCode = 4878702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874645094, ExchCode = 'TDG' WHERE SecCode = 4885603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21877551047, ExchCode = 'DEU' WHERE SecCode = 4907129 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 = 25727234438, ExchCode = 'BIV' WHERE SecCode = 4938297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796694010, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778071457, PermQuoteStatus = 'AC', Ticker = '62U2', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893301199, ExchCode = 'GTX' WHERE SecCode = 4952512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884973234, ExchCode = 'GTX' WHERE SecCode = 4957875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885992034, ExchCode = 'FRA' WHERE SecCode = 4959596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727205517, ExchCode = 'MEX' WHERE SecCode = 4962789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179518902, Ticker = '2MUEd', ExchCode = 'BTE' WHERE SecCode = 4965038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21900329922, ExchCode = 'FRA' WHERE SecCode = 4970793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902148575, ExchCode = 'FRA' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 4975859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21894278989, ExchCode = 'STU' WHERE SecCode = 5009346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953328, ExchCode = 'STU' WHERE SecCode = 5011695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183909427, ExchCode = 'SWX' WHERE SecCode = 5013560 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 QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607201, Ticker = 'DXCM', ExchCode = 'SWX' WHERE SecCode = 5047087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777145391, ExchCode = 'STU' WHERE SecCode = 5082548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797935268, ExchCode = 'MUN' WHERE SecCode = 5140247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21942737484, ExchCode = 'STU' WHERE SecCode = 5151167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430452, ExchCode = 'DEU' WHERE SecCode = 5153444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916823, ExchCode = 'MUN' WHERE SecCode = 5161225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853640013, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 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 = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5162437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943643469, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5174473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931108954, ExchCode = 'HAM', PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 5220960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919819094, ExchCode = 'MXQ' WHERE SecCode = 5241334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933395774, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396208, ExchCode = 'DEU' WHERE SecCode = 5253711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396325, ExchCode = 'DEU' WHERE SecCode = 5253712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396592, ExchCode = 'DEU' WHERE SecCode = 5253715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938339192, ExchCode = 'MUN' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 5260510 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935263193, ExchCode = 'DEU' WHERE SecCode = 5265003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380702, ExchCode = 'LAS' WHERE SecCode = 5277530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 5315591 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397462, ExchCode = 'BTE' WHERE SecCode = 5320940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' WHERE SecCode = 5343623 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 5359611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487235, ExchCode = 'FRA' WHERE SecCode = 5374858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959716915, ExchCode = 'DEU' WHERE SecCode = 5383599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777223518, ExchCode = 'FRA' WHERE SecCode = 5403440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777195781, ExchCode = 'TDG' WHERE SecCode = 5407839 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22092544416, ExchCode = 'DEU' WHERE SecCode = 5407840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777239370, PermQuoteStatus = 'DC', Ticker = 'T2I0', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 5407846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777248729, ExchCode = 'FRA' WHERE SecCode = 5407861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812181526, ExchCode = 'FRA' WHERE SecCode = 5410114 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5438120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778299981, ExchCode = 'FRA' WHERE SecCode = 5468679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 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 PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 5509537 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 5515081 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 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 PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5565485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794060301, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-05', PermSecMapEndDate = NULL WHERE SecCode = 5577589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780192624, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 5601088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22027362169, ExchCode = 'STU' WHERE SecCode = 5715993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782536306, ExchCode = 'MEX' WHERE SecCode = 5822279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596707, ExchCode = 'FRA' WHERE SecCode = 5839460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596711, ExchCode = 'FRA' WHERE SecCode = 5839461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596713, ExchCode = 'FRA' WHERE SecCode = 5839464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596706, ExchCode = 'FRA' WHERE SecCode = 5839466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596709, ExchCode = 'FRA' WHERE SecCode = 5839467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JAM' WHERE SecCode = 5842637 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JAM' WHERE SecCode = 5846430 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5859846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786957574, ExchCode = 'GTX' WHERE SecCode = 5908829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786044119, ExchCode = 'GTX', PermQuoteRetireDate = '2025-05-09', PermSecMapEndDate = NULL WHERE SecCode = 5911970 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 5951020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951582651, ExchCode = 'MXQ' WHERE SecCode = 5958705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782630075, ExchCode = 'FRA' WHERE SecCode = 5969012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787590957, ExchCode = 'STU' WHERE SecCode = 5978470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787541533, ExchCode = 'TDG' WHERE SecCode = 5978474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782564339, ExchCode = 'MEX' WHERE SecCode = 6032854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792840838, Ticker = '1HUTm', ExchCode = 'BCO' WHERE SecCode = 6047903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571976518, ExchCode = 'SGO' WHERE SecCode = 6095641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789902796, ExchCode = 'FRA' WHERE SecCode = 6095673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827614120, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097328 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 = 22089781512, PermQuoteStatus = 'AC', Ticker = 'A4AN9W', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 6097447 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 = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22058291191, ExchCode = 'MXQ' WHERE SecCode = 6097612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791667937, ExchCode = 'BIV' WHERE SecCode = 6226138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792142922, ExchCode = 'FRA' WHERE SecCode = 6258508 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 6263937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658530124, ExchCode = 'FRA' WHERE SecCode = 6325196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185827846, Ticker = 'AN02v', ExchCode = 'BCO' WHERE SecCode = 6356485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185588018, Ticker = 'EX58v', ExchCode = 'BCO' WHERE SecCode = 6356488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655583, ExchCode = 'GER' WHERE SecCode = 6368868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794616561, ExchCode = 'FRA' WHERE SecCode = 6418487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794619095, ExchCode = 'QTX' WHERE SecCode = 6418488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794616600, ExchCode = 'STU' WHERE SecCode = 6418489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128134015, ExchCode = 'DUS' WHERE SecCode = 6457998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185827873, Ticker = 'AN03v', ExchCode = 'BCO' WHERE SecCode = 6469377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798269749, ExchCode = 'TDG' 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 = 236798269870, ExchCode = 'FRA' WHERE SecCode = 6528817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798269868, ExchCode = 'FRA' WHERE SecCode = 6528818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798142642, ExchCode = 'TDG' WHERE SecCode = 6528824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607052, Ticker = 'MRNA', ExchCode = 'SWX' WHERE SecCode = 6578363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806101771, ExchCode = 'BCO' WHERE SecCode = 6578406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799956966, ExchCode = 'QTX' WHERE SecCode = 6584681 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6587289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800095947, ExchCode = 'TDG' WHERE SecCode = 6590583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799955089, ExchCode = 'MEX' WHERE SecCode = 6590630 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 6599011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22134134351, ExchCode = 'STU' WHERE SecCode = 6617649 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6622164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 6627153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22153255398, ExchCode = 'DEU' WHERE SecCode = 6627853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802292831, ExchCode = 'FRA' WHERE SecCode = 6635297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802292829, ExchCode = 'FRA' WHERE SecCode = 6635298 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802292830, ExchCode = 'FRA' WHERE SecCode = 6635299 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802293399, ExchCode = 'FRA' WHERE SecCode = 6635300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802293189, ExchCode = 'FRA' WHERE SecCode = 6635301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471092, ExchCode = 'FRA' WHERE SecCode = 6642930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883771519, ExchCode = 'FRA' WHERE SecCode = 6667833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22011191250, ExchCode = 'SGO' WHERE SecCode = 6678589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804778696, ExchCode = 'MUN' WHERE SecCode = 6721535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755612, ExchCode = 'FRA' WHERE SecCode = 6737926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755696, ExchCode = 'FRA' WHERE SecCode = 6737927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755694, ExchCode = 'FRA' WHERE SecCode = 6737928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805095337, ExchCode = 'QTX' WHERE SecCode = 6753078 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805776179, ExchCode = 'MUN' WHERE SecCode = 6782676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791406431, ExchCode = 'MEX' WHERE SecCode = 6797364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806019658, ExchCode = 'MEX' WHERE SecCode = 6797367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806018739, ExchCode = 'FRA' WHERE SecCode = 6797368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806168116, ExchCode = 'FRA' WHERE SecCode = 6802859 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'HLX', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 6808989 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-10' WHERE SecCode = 6829241 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 6849658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835099, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6857276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141115, ExchCode = 'TDG' WHERE SecCode = 6857306 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 6881998 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 6885944 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 6890757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183954222, ExchCode = 'DEU' WHERE SecCode = 6893691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886146, ExchCode = 'BIV' WHERE SecCode = 6893698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807581063, ExchCode = 'MEX' WHERE SecCode = 6893701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807884625, ExchCode = 'LAS' WHERE SecCode = 6893703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22184239300, ExchCode = 'DEU' WHERE SecCode = 6896922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22184238320, ExchCode = 'DEU' WHERE SecCode = 6896923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22184495661, ExchCode = 'DEU' WHERE SecCode = 6901104 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 6901121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508698046, PermQuoteStatus = 'DC', Ticker = 'OXUMI', ExchCode = 'SWX', PermQuoteRetireDate = '2018-05-03' WHERE SecCode = 6901138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808159103, ExchCode = 'TDG' WHERE SecCode = 6902189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185056479, ExchCode = 'DEU' WHERE SecCode = 6902190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 47767101015, ExchCode = 'FRA' WHERE SecCode = 6902192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808191721, ExchCode = 'HAM' WHERE SecCode = 6902193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808061332, ExchCode = 'FRA' WHERE SecCode = 6902222 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 6902643 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 18068916530.0, IsPrimaryInstr = 1, PermOrgIPODate = '2026-06-10' WHERE SecCode = 6902729 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6902746 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236808176645.0 WHERE SecCode = 6902747 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236808176647.0 WHERE SecCode = 6902748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185377078, ExchCode = 'DEU' WHERE SecCode = 6902754 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 10960373 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11028391 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 11030021 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11055957 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11190437 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11198984 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11199570 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11257658 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11261977 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'ENRD', ExchCode = 'NMS', QuoteClass = 'ADR', InstrClass = 'ADR', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11263764 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11275347 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11275921 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11278422 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11285129 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11289275 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11289279 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11289280 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11289282 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293086 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293087 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293088 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293090 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293095 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293098 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293099 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293101 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293102 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293104 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293105 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293106 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293108 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11293109 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232906636152.0, PermOrgIPODate = '2026-06-10' WHERE SecCode = 11296309 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11297252 AND Type_ = 1;