UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 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 = 21629381057, Ticker = '0Q1N', ExchCode = 'LSE' WHERE SecCode = 9338 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 13453 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 15281 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 16723 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 19506 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836462028, ExchCode = 'FRA' WHERE SecCode = 35017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836405672, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 35735 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 = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474911789, ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-29' WHERE SecCode = 38580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334221, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 38608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034862, ExchCode = 'TDG' WHERE SecCode = 38610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743260260, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 41641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535281401, ExchCode = 'STU' WHERE SecCode = 41659 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 43333 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 44332 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 44556 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 44557 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 45221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382874, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 45854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840929972, ExchCode = 'DUS' WHERE SecCode = 46009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837355425, PermQuoteStatus = 'DC', Ticker = 'GVM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 46388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334064, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 48122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 49484 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 51199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475604368, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2006-03-08' WHERE SecCode = 55766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520168469, ExchCode = 'STU' WHERE SecCode = 56520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475435128, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474874382, ExchCode = 'DEU' WHERE SecCode = 56529 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 56571 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541076311, ExchCode = 'DEU' WHERE SecCode = 57437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 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 = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474903931, ExchCode = 'DEU' WHERE SecCode = 60123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608399459, ExchCode = 'DEU' WHERE SecCode = 61371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560967752, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 61489 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 61605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341618, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 62845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006551, ExchCode = 'STU' WHERE SecCode = 64559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488610, ExchCode = 'QTX' WHERE SecCode = 64572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474889376, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 64581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331910, ExchCode = 'BER' WHERE SecCode = 64728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335540, Ticker = 'SPJ', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475428113, ExchCode = 'BER' WHERE SecCode = 64940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429918, ExchCode = 'GER' WHERE SecCode = 65261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475608426, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 65270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474994385, ExchCode = 'STU' WHERE SecCode = 65298 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474894114, ExchCode = 'DEU' WHERE SecCode = 65308 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 67906 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ONIDA' WHERE SecCode = 79725 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 83971 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-09' WHERE SecCode = 84806 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 86967 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 86968 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ONIDA' WHERE SecCode = 93697 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 95865 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', IncCntry = NULL WHERE SecCode = 98717 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 98901 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 99171 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799606984, ExchCode = 'TDG' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MLT0', PermQuoteRetireDate = NULL WHERE SecCode = 112907 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 113906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655821546, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-30', PermSecMapEndDate = NULL WHERE SecCode = 114758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787270, ExchCode = 'DUS' WHERE SecCode = 114759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288989, ExchCode = 'GTX' WHERE SecCode = 114833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838236737, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 114837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331367, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 114840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334482, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332480, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838242354, ExchCode = 'MUN' WHERE SecCode = 114852 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 123563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475472969, ExchCode = 'MUN' WHERE SecCode = 132940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560378012, ExchCode = 'CHI' WHERE SecCode = 137860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295736, ExchCode = 'GTX' WHERE SecCode = 143198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21497500363, ExchCode = 'STU' WHERE SecCode = 143201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071663, ExchCode = 'MUN', PermQuoteRetireDate = '2014-12-15' WHERE SecCode = 144542 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 144563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 161568 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808614974, ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 178149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21990443457, Ticker = 'GG9Bd', ExchCode = 'BCO' WHERE SecCode = 178972 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 182095 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 182657 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 184362 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 196556 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 197824 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 202482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 214165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528269166, ExchCode = 'DEU' WHERE SecCode = 249402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476850902, ExchCode = 'TDG' WHERE SecCode = 249426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2015-07-27', PermSecMapEndDate = '2024-09-03' WHERE SecCode = 264436 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836325722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 331585 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 340550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808614971, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-17', PermSecMapEndDate = NULL WHERE SecCode = 341790 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 346851 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 368199 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 371814 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 381010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 527752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536043310, ExchCode = 'STU' WHERE SecCode = 540563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21944002637, ExchCode = 'TDG' WHERE SecCode = 552856 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 553225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218481, ExchCode = 'BER', PermQuoteRetireDate = '2013-02-08' WHERE SecCode = 559256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589742988, ExchCode = 'STU' WHERE SecCode = 593055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599770084, ExchCode = 'STU' WHERE SecCode = 597462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545854859, ExchCode = 'FRA' WHERE SecCode = 623935 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287357, ExchCode = 'MEX' WHERE SecCode = 780513 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 972090 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-17' WHERE SecCode = 990921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999786274, ExchCode = 'TRQ' WHERE SecCode = 1108496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22177710975, ExchCode = 'DEU' WHERE SecCode = 1111460 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 1206288 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 1214173 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1399023 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 1425684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478443280, ExchCode = 'FRA' WHERE SecCode = 1460338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530720649, ExchCode = 'STU' WHERE SecCode = 1480257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479129, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-07', PermSecMapEndDate = '2025-11-07' WHERE SecCode = 1564475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512394339, ExchCode = 'FRA' WHERE SecCode = 1699181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514707492, ExchCode = 'DEU' WHERE SecCode = 1748432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 1980654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589938022, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2126923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430949, ExchCode = 'DEU' WHERE SecCode = 2213927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952626663, ExchCode = 'DEU' WHERE SecCode = 2220730 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538154, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2221995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308485, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2222230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782890682, ExchCode = 'STU' WHERE SecCode = 2239280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523563646, ExchCode = 'DEU' WHERE SecCode = 2239343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386834, ExchCode = 'LAS' WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789017062, ExchCode = 'DUS' WHERE SecCode = 2246863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371101, ExchCode = 'BEC' WHERE SecCode = 2272715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539606835, ExchCode = 'DUS' WHERE SecCode = 2278227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967852, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2278243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485240, ExchCode = 'QTX' WHERE SecCode = 2278251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527854591, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-06' WHERE SecCode = 2288362 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525927842, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-08' WHERE SecCode = 2289254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527321541, Ticker = 'GPA', ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 2319580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784383948, ExchCode = 'LAS' WHERE SecCode = 2324950 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670714959, ExchCode = 'TDG' WHERE SecCode = 2338094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807341682, ExchCode = 'OCE' 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 = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779363674, ExchCode = 'FRA' WHERE SecCode = 2379809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531721248, InstrPermID = 8590005814, OrgPermID = 4295915565, ValQuotePermID = 55838797234.0, PriInstrPermID = 8590005814.0, PermInstrStatus = 'DC', Ticker = '56A', ExchCode = 'BER', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2020-09-09' WHERE SecCode = 2387360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384853, ExchCode = 'LAS' WHERE SecCode = 2388898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781607391, ExchCode = 'QTX' WHERE SecCode = 2391333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536966570, ExchCode = 'STU' WHERE SecCode = 2391345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538722817, ExchCode = 'STU' WHERE SecCode = 2391351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803110077, ExchCode = 'FRA' WHERE SecCode = 2391353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223768, ExchCode = 'QTX' WHERE SecCode = 2394769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620411353, ExchCode = 'STU' WHERE SecCode = 2397377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804997786, ExchCode = 'FRA' WHERE SecCode = 2402414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386146, ExchCode = 'LAS' WHERE SecCode = 2404625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705370, ExchCode = 'MXQ' WHERE SecCode = 2407194 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777643090, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2412432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489670, ExchCode = 'QTX' WHERE SecCode = 2448345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535197362, Ticker = 'MRK', ExchCode = 'BRN' WHERE SecCode = 2465112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535492269, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 2466348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA', PermQuoteRetireDate = '2018-11-19' WHERE SecCode = 2467266 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387906, ExchCode = 'LAS' WHERE SecCode = 2470092 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780660022, ExchCode = 'TDG' WHERE SecCode = 2479012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800660442, ExchCode = 'DUS' WHERE SecCode = 2482710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21481714947, ExchCode = 'TDG' WHERE SecCode = 2487654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181315008, ExchCode = 'OCE' WHERE SecCode = 2510129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 2515703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823953337, ExchCode = 'DUS' WHERE SecCode = 2515711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792907918, ExchCode = 'FRA' WHERE SecCode = 2518703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585062784, ExchCode = 'SGO' WHERE SecCode = 2539930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385094, ExchCode = 'LAS' WHERE SecCode = 2545058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540108933, ExchCode = 'DEU' WHERE SecCode = 2554904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478415, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2556599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731262060, ExchCode = 'BER' WHERE SecCode = 2556600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542768596, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2573038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543086076, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-24' WHERE SecCode = 2578880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793501847, ExchCode = 'MUN' WHERE SecCode = 2578881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 2579445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543709073, ExchCode = 'FRA' WHERE SecCode = 2584743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181314867, ExchCode = 'OCE' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629958117, ExchCode = 'TDG' WHERE SecCode = 2599304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642374749, ExchCode = 'DEU' WHERE SecCode = 2621782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548014433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2640373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538237, ExchCode = 'GTX' WHERE SecCode = 2642455 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 = 21548204121, ExchCode = 'FRA' WHERE SecCode = 2644168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782535985, ExchCode = 'QTX', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 2644169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397387, ExchCode = 'GTX' WHERE SecCode = 2649166 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 = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549921085, ExchCode = 'CHI' WHERE SecCode = 2665921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770742655, ExchCode = 'HAN' WHERE SecCode = 2679857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607245, Ticker = 'HL', ExchCode = 'SWX' WHERE SecCode = 2682233 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2682348 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 PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2710429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617877526, Ticker = 'BWOv', ExchCode = 'EBT', PermQuoteRetireDate = '2021-06-01' WHERE SecCode = 2710438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552463360, ExchCode = 'FRA' WHERE SecCode = 2711203 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 2727836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675690, ExchCode = 'BIV' WHERE SecCode = 2747774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554451923, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-14' WHERE SecCode = 2750984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558476903, ExchCode = 'FRA' WHERE SecCode = 2813079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21678893048, ExchCode = 'FRA' WHERE SecCode = 2824459 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535496482, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 2827915 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CAP' WHERE SecCode = 2830908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763993243, Ticker = '8PSGd', ExchCode = 'BCO' WHERE SecCode = 2846585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21559845838, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2849907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560128262, ExchCode = 'STU' WHERE SecCode = 2849922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761414, ExchCode = 'DEU' WHERE SecCode = 2855773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650196, ExchCode = 'DUS' WHERE SecCode = 2858551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565633193, PermQuoteStatus = 'AC', Ticker = 'CM30', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2907243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026820, Ticker = '1EBAY' WHERE SecCode = 2925433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370461, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2947926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 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 = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21577065557, ExchCode = 'DEU' WHERE SecCode = 3038439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786322025, ExchCode = 'BER' WHERE SecCode = 3065856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581022534, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3083485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583410182, ExchCode = 'DEU' WHERE SecCode = 3105902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22124025589, ExchCode = 'DEU' WHERE SecCode = 3124127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 3162845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 3213357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951938.0 WHERE SecCode = 3225482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348303, ExchCode = 'QTX' WHERE SecCode = 3247427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678970, ExchCode = 'BIV' WHERE SecCode = 3275857 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475007430, ExchCode = 'DEU' WHERE SecCode = 3282311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611219951, ExchCode = 'MUN', PermQuoteRetireDate = '2017-12-22' WHERE SecCode = 3297215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611042371, ExchCode = 'DEU' WHERE SecCode = 3322810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705691, Ticker = 'SMIN', ExchCode = 'MXQ' WHERE SecCode = 3327117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598843083, ExchCode = 'MEX' WHERE SecCode = 3356365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761303085, ExchCode = 'STU' WHERE SecCode = 3358616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743475404, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3378582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647732131, ExchCode = 'STU' WHERE SecCode = 3378583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864390192, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3379451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766019517, ExchCode = 'FRA' WHERE SecCode = 3386374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663433249, ExchCode = 'TDG' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3392525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705253, ExchCode = 'MXQ' WHERE SecCode = 3395773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625753509, ExchCode = 'BTE', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 3395860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 3402106 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 3402815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 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 = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633327894, ExchCode = 'STU' WHERE SecCode = 3409091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 3432247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 3444697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645552908, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784910654, Ticker = 'NOKIAk', ExchCode = 'BCO' WHERE SecCode = 3504673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750146809, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3518267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652981190, ExchCode = 'ASX' WHERE SecCode = 3531560 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 3532691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097167, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3532727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736203569, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3532733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795072494, ExchCode = 'LAS' WHERE SecCode = 3549499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705145, ExchCode = 'MXQ' WHERE SecCode = 3569558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388326, ExchCode = 'LAS' WHERE SecCode = 3569563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681761692, ExchCode = 'FRA' WHERE SecCode = 3569619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808198553, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 3578524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55866956065, ExchCode = 'BEC' WHERE SecCode = 3587010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55867895880, ExchCode = 'BEC' WHERE SecCode = 3587014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879562247, ExchCode = 'GTX' WHERE SecCode = 3587019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21572528792, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21993741453, Ticker = 'AEJl', ExchCode = 'AQX' WHERE SecCode = 3587037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544783558, ExchCode = 'BER' WHERE SecCode = 3587041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3587074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757667031, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 3588020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598347923, ExchCode = 'AUX' WHERE SecCode = 3588027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609218, ExchCode = 'FRA' WHERE SecCode = 3588082 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609512, ExchCode = 'DEU' WHERE SecCode = 3588083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661040055, ExchCode = 'FRA' WHERE SecCode = 3599227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664171446, PermQuoteStatus = 'DC', Ticker = '2HQ', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 3610775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664433945, ExchCode = 'STU' WHERE SecCode = 3610818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731983529, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3615233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759798879, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3615235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779823334, ExchCode = 'GTX' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 3661135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690447593, ExchCode = 'STU' WHERE SecCode = 3666895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569892, ExchCode = 'QTX' WHERE SecCode = 3675861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750785399, ExchCode = 'DEU' WHERE SecCode = 3731132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383888, ExchCode = 'BIV' WHERE SecCode = 3732368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288603, ExchCode = 'GTX' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272950, ExchCode = 'GTX' WHERE SecCode = 3767864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684229246, ExchCode = 'DEU' WHERE SecCode = 3771411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650263, ExchCode = 'DUS' WHERE SecCode = 3832747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367133, ExchCode = 'FRA' WHERE SecCode = 3841485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21905915767, ExchCode = 'DEU' WHERE SecCode = 3841486 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22066678465, ExchCode = 'DEU' WHERE SecCode = 3841487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865590408, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 3847122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812350912, ExchCode = 'DEU' WHERE SecCode = 3863388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 3878939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785083485, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-26' WHERE SecCode = 3890307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045075201, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3919559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295405, ExchCode = 'GTX', PermQuoteRetireDate = '2024-10-01', PermSecMapEndDate = '2024-10-01' WHERE SecCode = 3949028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812338413, ExchCode = 'MUN' WHERE SecCode = 3951450 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 = 21830294452, ExchCode = 'GTX' WHERE SecCode = 3998157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026845, Ticker = '1GLW' WHERE SecCode = 4031714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4031803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128315297, ExchCode = 'DEU' WHERE SecCode = 4046669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630041763, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727358384, ExchCode = 'MEX' WHERE SecCode = 4049153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388381, ExchCode = 'LAS' WHERE SecCode = 4079321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21730198054, Ticker = 'ZWIPE', ExchCode = 'STO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 4079329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815144829, Ticker = '49Y', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727359625, ExchCode = 'BIV' WHERE SecCode = 4139229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674204, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781829986, ExchCode = 'QTX' WHERE SecCode = 4178603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745304635, ExchCode = 'DEU' WHERE SecCode = 4195320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745628089, PermQuoteStatus = 'AC', Ticker = 'Z62', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4196898 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-02-11' WHERE SecCode = 4201929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788611412, ExchCode = 'DEU' WHERE SecCode = 4209753 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-02-11' WHERE SecCode = 4212359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999014130, Ticker = '2NOW' WHERE SecCode = 4214371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011916, Ticker = '2AMT' WHERE SecCode = 4214372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011917, Ticker = '2AWK' WHERE SecCode = 4214377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012327, Ticker = '2GD' WHERE SecCode = 4214384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012556, Ticker = '2HLT' WHERE SecCode = 4214387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012669, Ticker = '2K' WHERE SecCode = 4214388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013434, Ticker = '2SPG' WHERE SecCode = 4214395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013297, Ticker = '2SYK' WHERE SecCode = 4214397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013876, Ticker = '2TROW' WHERE SecCode = 4214399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013596, Ticker = '2WEC' WHERE SecCode = 4214401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22069067182, Ticker = '2APH', ExchCode = 'MIL' WHERE SecCode = 4214403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371806, Ticker = '0Q3', ExchCode = 'BRN' WHERE SecCode = 4214409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013708, Ticker = '2PLUG', ExchCode = 'MIL' WHERE SecCode = 4214415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778023555, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-28' WHERE SecCode = 4228115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752139678, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4240637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752244343, ExchCode = 'TDG' WHERE SecCode = 4240638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 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 = 21754534080, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-07', PermSecMapEndDate = '2023-11-07' WHERE SecCode = 4259226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756809738, ExchCode = 'FRA' WHERE SecCode = 4275420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679461, ExchCode = 'BIV' WHERE SecCode = 4298620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932244786, ExchCode = 'BCO' WHERE SecCode = 4315108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580130, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4315115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763489973, ExchCode = 'FRA' WHERE SecCode = 4324465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796439340, ExchCode = 'LAS' WHERE SecCode = 4333278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771445002, ExchCode = 'QTX' WHERE SecCode = 4359837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774624846, ExchCode = 'STU' WHERE SecCode = 4379790 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779062122, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-26' WHERE SecCode = 4401406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784580416, ExchCode = 'TDG' WHERE SecCode = 4402242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 = 21816908115, ExchCode = 'TQE' WHERE SecCode = 4423997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787491381, ExchCode = 'BER', PermQuoteRetireDate = '2021-01-05' WHERE SecCode = 4446127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787035686, ExchCode = 'FRA' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818102097, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4449683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791469822, ExchCode = 'DUS' WHERE SecCode = 4451262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801059554, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4487598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809915701, ExchCode = 'STU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386713, ExchCode = 'LAS' WHERE SecCode = 4513650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781829998, ExchCode = 'QTX' WHERE SecCode = 4591965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812848146, ExchCode = 'DEU' WHERE SecCode = 4592022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816245393, ExchCode = 'MUN' WHERE SecCode = 4601736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800012350, ExchCode = 'LAS' WHERE SecCode = 4615939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380579, ExchCode = 'LAS' WHERE SecCode = 4617716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818266412, ExchCode = 'DEU' WHERE SecCode = 4617743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821283375, ExchCode = 'FRA' WHERE SecCode = 4630664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823512132, ExchCode = 'DEU' WHERE SecCode = 4641628 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' 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 = 21884954175, ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-04', PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4664716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873118953, Ticker = 'CARBm', ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098679, ExchCode = 'FRA' WHERE SecCode = 4753666 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' 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 = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795665928, ExchCode = 'FRA' WHERE SecCode = 4775075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858471109, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 4787454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933381631, ExchCode = 'STU' WHERE SecCode = 4790646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727216819, ExchCode = 'MEX' WHERE SecCode = 4802294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4808847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862298482, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-10' WHERE SecCode = 4811141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863999710, ExchCode = 'DEU' WHERE SecCode = 4823658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864899126, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4823660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864899514, ExchCode = 'DEU' WHERE SecCode = 4823661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864897333, ExchCode = 'DEU' WHERE SecCode = 4823663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865290174, ExchCode = 'GTX' WHERE SecCode = 4823664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864884560, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866536811, ExchCode = 'STU' WHERE SecCode = 4827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873923001, ExchCode = 'DUS' WHERE SecCode = 4830767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792865451, ExchCode = 'MUN' WHERE SecCode = 4841234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398427, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869360768, ExchCode = 'QTX' WHERE SecCode = 4847005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882167707, PermQuoteStatus = 'AC', Ticker = 'Y232', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471210, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-05-22' WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778071474, ExchCode = 'MUN' WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953965734, PermQuoteStatus = 'DC', Ticker = 'VC91', ExchCode = 'QTX', PermQuoteRetireDate = '2024-09-03' WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381606, ExchCode = 'LAS' 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 = 22179871224, Ticker = '2MUE', ExchCode = 'HAM' WHERE SecCode = 4965038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893308828, ExchCode = 'DEU' WHERE SecCode = 4992085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779058751, ExchCode = 'STU' WHERE SecCode = 5004799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183909427, ExchCode = 'SWX' WHERE SecCode = 5013560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777464944, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5063516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931483023, ExchCode = 'MUN' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740520, ExchCode = 'LAS' WHERE SecCode = 5082548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805401000, ExchCode = 'FRA' WHERE SecCode = 5089305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797935268, ExchCode = 'MUN' WHERE SecCode = 5140247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305815, ExchCode = 'BIV' WHERE SecCode = 5161409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727360442, ExchCode = 'MEX' WHERE SecCode = 5161415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850513498, ExchCode = 'FRA' WHERE SecCode = 5161417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 QuotePermID = 236781650379, ExchCode = 'QTX' WHERE SecCode = 5166812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21923930934, ExchCode = 'STU' WHERE SecCode = 5174471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778803327, ExchCode = 'DUS' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782434087, ExchCode = 'STU' WHERE SecCode = 5343608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952832311, ExchCode = 'STU' WHERE SecCode = 5347429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942209, ExchCode = 'STU' WHERE SecCode = 5422843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21967957484, ExchCode = 'DEU' WHERE SecCode = 5422844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777745401, ExchCode = 'FRA' WHERE SecCode = 5436573 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777745402, ExchCode = 'FRA' WHERE SecCode = 5436574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380732, ExchCode = 'LAS' WHERE SecCode = 5466447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977803258, ExchCode = 'DEU' WHERE SecCode = 5470870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834825, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580217, ExchCode = 'GER' WHERE SecCode = 5503779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953657244, ExchCode = 'MXQ' WHERE SecCode = 5503860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836119, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 5503898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807449510, ExchCode = 'BCO' WHERE SecCode = 5503900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663650, Ticker = 'ARK3l', ExchCode = 'AQX' WHERE SecCode = 5503901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789414734, ExchCode = 'LAS' WHERE SecCode = 5507430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110915, Ticker = '3MRNm', ExchCode = 'BCO' WHERE SecCode = 5569367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-17' WHERE SecCode = 5581593 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 = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942899, ExchCode = 'BIV' WHERE SecCode = 5631516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904157, Ticker = 'LCO3l', ExchCode = 'BCO' WHERE SecCode = 5638747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823715, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5638860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 5638862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837511990, Ticker = '2STSa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5638905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781607151, ExchCode = 'FRA' WHERE SecCode = 5663968 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 5693829 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '21GRd' WHERE SecCode = 5710735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028890941, ExchCode = 'FRA' WHERE SecCode = 5724940 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 5764161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181310368, ExchCode = 'OCU' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784890672, ExchCode = 'FRA' WHERE SecCode = 5857780 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 5881402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735452563, ExchCode = 'DEU' WHERE SecCode = 5886971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785943776, ExchCode = 'FRA' WHERE SecCode = 5907872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799240194, ExchCode = 'DUS' WHERE SecCode = 6097372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171968, ExchCode = 'BIV' WHERE SecCode = 6097384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814536624, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6097431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512196, Ticker = 'NVDEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10; UPDATE data_universe_permid SET QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6147594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22092285949, ExchCode = 'DEU' WHERE SecCode = 6177691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791667911, ExchCode = 'MEX' WHERE SecCode = 6226138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136111001, Ticker = 'BTCFl', ExchCode = 'BTE' WHERE SecCode = 6245909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792063904, ExchCode = 'TDG' WHERE SecCode = 6250300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759798861, ExchCode = 'TDG' WHERE SecCode = 6256412 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798226363, Ticker = '2IU1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6256420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105862270, ExchCode = 'GTX' WHERE SecCode = 6286094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105871912, ExchCode = 'DEU' WHERE SecCode = 6286099 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 6299130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793315748, ExchCode = 'LAS' WHERE SecCode = 6303058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792988435, ExchCode = 'GTX' WHERE SecCode = 6310651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808619523, ExchCode = 'LAS' WHERE SecCode = 6313528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655583, ExchCode = 'GER' WHERE SecCode = 6368868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116662449, ExchCode = 'QTX' WHERE SecCode = 6368869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806228183, ExchCode = 'TDG' WHERE SecCode = 6371577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793934079, ExchCode = 'TDG' WHERE SecCode = 6371578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789866542, ExchCode = 'BIV' WHERE SecCode = 6375353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793934516, ExchCode = 'DUS' WHERE SecCode = 6377085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794652101, ExchCode = 'DUS' WHERE SecCode = 6418488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799042091, ExchCode = 'FRA' WHERE SecCode = 6418489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796057757, ExchCode = 'MUN' WHERE SecCode = 6448294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798748957, ExchCode = 'HAM' WHERE SecCode = 6457997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796140986, ExchCode = 'MUN' WHERE SecCode = 6462849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797408686, Ticker = 'S0N0', ExchCode = 'FRA' WHERE SecCode = 6503395 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 PermOrgIPODate = NULL WHERE SecCode = 6551104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727346662, Ticker = '0QF', ExchCode = 'BRN' WHERE SecCode = 6578363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799956966, ExchCode = 'QTX' WHERE SecCode = 6584681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798598067, ExchCode = 'FRA' WHERE SecCode = 6587374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800096565, ExchCode = 'FRA' WHERE SecCode = 6590583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951938.0 WHERE SecCode = 6608284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451401, ExchCode = 'BTE' WHERE SecCode = 6627463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802136610, ExchCode = 'FRA' WHERE SecCode = 6629415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471092, ExchCode = 'FRA' WHERE SecCode = 6642930 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'B4R0' WHERE SecCode = 6661575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804483784, ExchCode = 'STU' WHERE SecCode = 6728400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804838547, ExchCode = 'BIV' WHERE SecCode = 6748872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169522181, ExchCode = 'DEU' WHERE SecCode = 6748898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169522316, ExchCode = 'DEU' WHERE SecCode = 6748899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805094212, ExchCode = 'MUN' WHERE SecCode = 6748900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808332134, ExchCode = 'LAS' WHERE SecCode = 6753080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187361173, Ticker = 'SND3l', ExchCode = 'BCO' WHERE SecCode = 6755769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187361175, Ticker = 'SND3a', ExchCode = 'BCO' WHERE SecCode = 6769165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805901586, ExchCode = 'CHI' WHERE SecCode = 6779523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806640335, ExchCode = 'FRA' WHERE SecCode = 6829248 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6854779 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6854843 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6876672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807703458, ExchCode = 'FRA' WHERE SecCode = 6887794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807703980, ExchCode = 'FRA' WHERE SecCode = 6887796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808159073, ExchCode = 'MUN' WHERE SecCode = 6887868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183633411, ExchCode = 'DEU' WHERE SecCode = 6887870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808329918, ExchCode = 'GTX' WHERE SecCode = 6887871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808187810, ExchCode = 'QTX' WHERE SecCode = 6887874 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-18' WHERE SecCode = 6893666 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886145, ExchCode = 'MEX' WHERE SecCode = 6893698 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 6901105 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6901107 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 6902652 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 6902654 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6902655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808584211, ExchCode = 'GTX' WHERE SecCode = 6908262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787823532, ExchCode = 'MEX' WHERE SecCode = 6914500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187105156, Ticker = 'CBR3l', ExchCode = 'BCO' WHERE SecCode = 6914502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187361177, Ticker = 'DRM3l', ExchCode = 'BCO' WHERE SecCode = 6914505 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808391954, ExchCode = 'FRA' WHERE SecCode = 6917417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808395024, ExchCode = 'FRA' WHERE SecCode = 6917418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808397274, ExchCode = 'FRA' WHERE SecCode = 6917419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187361170, Ticker = 'CBR3m', ExchCode = 'BCO' WHERE SecCode = 6917596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187361171, Ticker = 'SMG3m', ExchCode = 'BCO' WHERE SecCode = 6917597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187361172, Ticker = 'HNX3m', ExchCode = 'BCO' WHERE SecCode = 6917598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186464292, ExchCode = 'GER' WHERE SecCode = 6917599 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 6920998 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 6921023 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 6923698 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-17' WHERE SecCode = 6923746 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 6923751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187120128, ExchCode = 'DEU' WHERE SecCode = 6923752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187120406, ExchCode = 'DEU' WHERE SecCode = 6923754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187120270, ExchCode = 'DEU' WHERE SecCode = 6923755 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10781932 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 10906768 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10908159 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 11030038 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11050854 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 11133200 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 11142421 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'HAPN', ExchCode = 'NSM' WHERE SecCode = 11142751 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11156631 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11194215 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'FIRY' WHERE SecCode = 11207267 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 11209046 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727343971, PermQuoteStatus = 'AC', Ticker = 'GOCOQ', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11210042 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11233216 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11241243 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11247676 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 11254937 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 11262373 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 18040307071.0 WHERE SecCode = 11263590 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 11264060 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'ASE', QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11267607 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'KAZR' WHERE SecCode = 11274212 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727047711, PermQuoteStatus = 'AC', Ticker = 'MEHA', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11274658 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11274684 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-06' WHERE SecCode = 11274685 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11276346 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'ISHLF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-17', PermSecMapEndDate = NULL WHERE SecCode = 11276886 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11279159 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-17' WHERE SecCode = 11279370 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 11279466 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-08' WHERE SecCode = 11281412 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11293330 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11293331 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11293334 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11293336 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 11293380 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 11293383 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-18' WHERE SecCode = 11293385 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232927312177.0 WHERE SecCode = 11294499 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232926623209.0, IsPrimaryInstr = 0 WHERE SecCode = 11295026 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232931453854.0 WHERE SecCode = 11295027 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11296084 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LILAP' WHERE SecCode = 11296654 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11296748 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-17', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11296749 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808503555, ExchCode = 'NYS', PermSecMapStartDate = '2026-06-16' WHERE SecCode = 11297252 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 11297313 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 47767465140, ExchCode = 'NSM', PermSecMapStartDate = '2026-06-16' WHERE SecCode = 11297328 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11297513 AND Type_ = 1;