UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475562628, Ticker = 'KFX', ExchCode = 'VTX', PermQuoteRetireDate = '2009-02-02' WHERE SecCode = 3735 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 10938 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 12512 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 28993 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55835798996, ExchCode = 'MEX' WHERE SecCode = 30124 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835818209, ExchCode = 'MEX' WHERE SecCode = 30144 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 32631 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836574233, ExchCode = 'FRA' WHERE SecCode = 33922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384262, ExchCode = 'LAS' WHERE SecCode = 34055 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 = 55848820360, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 34184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 = 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 = 21851139058, ExchCode = 'TDG' WHERE SecCode = 38188 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'KYOAY' WHERE SecCode = 40016 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21474870281, ExchCode = 'DEU' WHERE SecCode = 41385 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584688833, ExchCode = 'TDG' WHERE SecCode = 43710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474913868, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386756, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 46451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836531592, ExchCode = 'FRA' WHERE SecCode = 46521 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1980-03-17' WHERE SecCode = 49041 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 49234 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475589631, Ticker = 'L0992', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584354094, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 54284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838418766, ExchCode = 'STU' WHERE SecCode = 56992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735443347, Ticker = 'AIVd', ExchCode = 'BCO' WHERE SecCode = 57101 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 57675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836489836, ExchCode = 'FRA' WHERE SecCode = 60025 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 60083 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848657467, ExchCode = 'MUN' WHERE SecCode = 60210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382644, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 60247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838243010, ExchCode = 'MUN' WHERE SecCode = 60261 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 = 55836340932, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 60564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526392841, ExchCode = 'DEU' WHERE SecCode = 60669 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 = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874654411, ExchCode = 'GTX' WHERE SecCode = 63011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917173961, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 63016 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1980-03-17' WHERE SecCode = 64706 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 64854 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-05' WHERE SecCode = 65836 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 68823 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 73192 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 73402 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'AGGID' WHERE SecCode = 74667 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 78159 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 79087 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 80836 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727195244, IsPrimaryQuote = 0, ExchCode = 'PTX' WHERE SecCode = 90703 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'VREOD', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 95324 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 95865 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 118606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997865, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-23' WHERE SecCode = 128755 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'AKN' WHERE SecCode = 132696 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IND' WHERE SecCode = 135522 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997893, ExchCode = 'FRA' WHERE SecCode = 138040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536674900, ExchCode = 'STU' WHERE SecCode = 141145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512040838, ExchCode = 'TDG' WHERE SecCode = 141149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836539796, ExchCode = 'FRA' WHERE SecCode = 141172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323345, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485683, ExchCode = 'QTX' WHERE SecCode = 141184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485331, ExchCode = 'QTX' WHERE SecCode = 144317 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787407, ExchCode = 'DUS' WHERE SecCode = 144320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836480998, ExchCode = 'FRA', PermQuoteRetireDate = '2020-08-19' WHERE SecCode = 144377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330934, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633145097, Ticker = 'TUI1l', ExchCode = 'EBT', PermQuoteRetireDate = '2019-06-18' WHERE SecCode = 144410 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 144789 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 145059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527770884, ExchCode = 'DEU' WHERE SecCode = 145508 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21629642716.0 WHERE SecCode = 146206 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 147705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21534005004, ExchCode = 'MUN', PermQuoteRetireDate = '2025-12-04' WHERE SecCode = 147805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684961175, ExchCode = 'MUN' WHERE SecCode = 147900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782821783, ExchCode = 'MUN' WHERE SecCode = 147907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521106330, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-09' WHERE SecCode = 147913 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55846008505, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-31' WHERE SecCode = 147917 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152778, ExchCode = 'MUN' WHERE SecCode = 147929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830284975, ExchCode = 'GTX' WHERE SecCode = 178350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22061302940, ExchCode = 'DEU' WHERE SecCode = 180215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659841755, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 202265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856949520, ExchCode = 'FRA', PermQuoteRetireDate = '2012-10-22' WHERE SecCode = 206842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544954898, ExchCode = 'FRA' WHERE SecCode = 208922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527643731, ExchCode = 'STU' WHERE SecCode = 208947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175714363, ExchCode = 'DEU' WHERE SecCode = 208948 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 214292 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 215357 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SHUAIBA' WHERE SecCode = 243506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617119543, Ticker = 'CKI', ExchCode = 'STU', PermQuoteRetireDate = '2019-08-14' WHERE SecCode = 249643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838777196, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 301431 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 318407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320947, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 335658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836321226, ExchCode = 'BER', PermQuoteRetireDate = '2024-03-27' WHERE SecCode = 337012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806168118, ExchCode = 'FRA' WHERE SecCode = 344774 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 391407 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 404901 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 406383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 519578 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 519586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851510082, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 549537 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21964831449, ExchCode = 'DEU' WHERE SecCode = 549886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859230063, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 598098 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951254.0 WHERE SecCode = 726788 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 847847 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 918892 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 946722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475770142, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', Ticker = 'HMSG', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 1004429 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1193809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514433429, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1447851 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477469688, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-01' WHERE SecCode = 1457731 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 1485605 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 1485606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529849881, Ticker = 'RBT', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1533786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21499307444, Ticker = '5GQ', ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 1554222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 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 PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 1632056 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655822238, ExchCode = 'DEU' WHERE SecCode = 1655502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513064834, Ticker = 'RF2', PermQuoteRetireDate = '2012-11-22', PermSecMapEndDate = '2012-11-08' WHERE SecCode = 1668708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312304, ExchCode = 'GTX' WHERE SecCode = 1694101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776251703, ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-13' WHERE SecCode = 1696044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517428536, ExchCode = 'TRQ', PermQuoteRetireDate = '2023-06-22' WHERE SecCode = 1722300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715233, ExchCode = 'BER', PermQuoteRetireDate = '2022-09-26' WHERE SecCode = 2006213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21516696149, Ticker = 'ECX', ExchCode = 'LSE', PermQuoteRetireDate = '2014-08-27' WHERE SecCode = 2013070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673265, ExchCode = 'BIV' WHERE SecCode = 2014210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625195856, ExchCode = 'FRA' WHERE SecCode = 2072760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519302126, ExchCode = 'STU' WHERE SecCode = 2115211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658940658, ExchCode = 'MUN' WHERE SecCode = 2142278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 2189779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644523837, ExchCode = 'STU' WHERE SecCode = 2195754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521092450, ExchCode = 'STO', PermQuoteRetireDate = '2024-03-27' WHERE SecCode = 2195912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644782383, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-02-16' WHERE SecCode = 2222230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524954693, ExchCode = 'FRA' WHERE SecCode = 2267521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525339865, ExchCode = 'DEU' WHERE SecCode = 2278227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525273252, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2278243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527318087, ExchCode = 'FRA' WHERE SecCode = 2319580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303445, ExchCode = 'FRA' WHERE SecCode = 2324950 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369453, ExchCode = 'BEC' WHERE SecCode = 2377498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381501, ExchCode = 'LAS' WHERE SecCode = 2379809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532119904, ExchCode = 'DEU' WHERE SecCode = 2394797 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21495995528.0 WHERE SecCode = 2394803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892047304, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2412432 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 2421090 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 = 21521368602, ExchCode = 'BEC' WHERE SecCode = 2452538 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774613413, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2465278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521368374, ExchCode = 'SGO' WHERE SecCode = 2515766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591563754, ExchCode = 'BCO', PermQuoteRetireDate = '2026-03-18' WHERE SecCode = 2527880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370135, ExchCode = 'SGO' WHERE SecCode = 2545788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550103570, ExchCode = 'DEU' WHERE SecCode = 2559800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' 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 = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371263, ExchCode = 'BEC' WHERE SecCode = 2625122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546596463, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2627627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704172, ExchCode = 'MXQ' WHERE SecCode = 2644179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685431659, ExchCode = 'FRA' WHERE SecCode = 2671254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550408230, ExchCode = 'DEU' WHERE SecCode = 2679857 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2763334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322226, ExchCode = 'DEU' WHERE SecCode = 2812146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830275235, ExchCode = 'GTX' WHERE SecCode = 2830909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21579730411, ExchCode = 'DEU' WHERE SecCode = 2857019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561901515, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2873688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569832692, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-03' WHERE SecCode = 2880970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562688444, ExchCode = 'FRA' WHERE SecCode = 2880971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563614493, ExchCode = 'STU' WHERE SecCode = 2880972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563177438, ExchCode = 'DEU' WHERE SecCode = 2887312 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564939099, ExchCode = 'FRA' WHERE SecCode = 2909242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 2920445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565562515, ExchCode = 'BEC' WHERE SecCode = 2936007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033693, InstrPermID = 8590942120, OrgPermID = 4295862624, ValQuotePermID = 55838794989.0, PriInstrPermID = 8590942120.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'A4L', ExchCode = 'TDG', PermQuoteRetireDate = '2015-07-06', PermOrgIPODate = NULL WHERE SecCode = 2939990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822024397, ExchCode = 'TDG' WHERE SecCode = 3051795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700996629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3083484 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 = 21597183902, ExchCode = 'DEU' WHERE SecCode = 3090270 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-04' WHERE SecCode = 3101370 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3114312 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599769591, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3169823 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3174272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'C421' WHERE SecCode = 3196346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589835342, ExchCode = 'DEU' WHERE SecCode = 3196992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169497784, ExchCode = 'DEU' WHERE SecCode = 3196993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 3207291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937063404, ExchCode = 'DUS' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595530115, ExchCode = 'STU', PermQuoteRetireDate = '2024-06-28' WHERE SecCode = 3237127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613476472, ExchCode = 'STU' WHERE SecCode = 3247179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597399146, ExchCode = 'FRA' WHERE SecCode = 3255012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597335837, ExchCode = 'DEU' WHERE SecCode = 3255028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597458276, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599524546, ExchCode = 'STU' WHERE SecCode = 3255527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597621838, ExchCode = 'FRA' WHERE SecCode = 3255528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640216643, ExchCode = 'TDG' WHERE SecCode = 3263894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21995867781, ExchCode = 'TRQ' WHERE SecCode = 3275560 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 3275668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 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 = 21607100433, ExchCode = 'MUN' WHERE SecCode = 3305420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 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 PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3318319 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610682901, Ticker = 'VEONa', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-05' WHERE SecCode = 3347756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22098742116, ExchCode = 'DXE' WHERE SecCode = 3359183 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615050419, ExchCode = 'DEU' WHERE SecCode = 3359272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301079, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3378582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645193083, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-03', PermSecMapEndDate = NULL WHERE SecCode = 3393655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951698.0 WHERE SecCode = 3396703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764861300, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01', PermSecMapEndDate = '2021-10-01' WHERE SecCode = 3402310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818264981, ExchCode = 'FRA' WHERE SecCode = 3409089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655828146, ExchCode = 'FRA' WHERE SecCode = 3409091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3432046 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 3432535 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 3433276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21635518756, ExchCode = 'FRA' WHERE SecCode = 3434582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3435659 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705492, ExchCode = 'MXQ' WHERE SecCode = 3439528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704240, ExchCode = 'MXQ' WHERE SecCode = 3439529 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3441172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656676153, ExchCode = 'BIV' WHERE SecCode = 3445716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644530905, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3445747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644530943, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-29', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 3445749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569555, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647430161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3497959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651518719, ExchCode = 'BER' WHERE SecCode = 3518265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652137392, ExchCode = 'STU' WHERE SecCode = 3526149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651645825, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-01', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652485962, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-04', PermSecMapEndDate = '2018-07-04' WHERE SecCode = 3529083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951698.0 WHERE SecCode = 3540531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757243010, ExchCode = 'STU' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949649601, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-12-12' WHERE SecCode = 3545357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753145831, ExchCode = 'BCO' WHERE SecCode = 3547843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663166737, ExchCode = 'DEU' WHERE SecCode = 3550423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656632105, Ticker = 'DNK', ExchCode = 'LSE', PermQuoteRetireDate = '2021-09-24' WHERE SecCode = 3557524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475624891, Ticker = 'CSC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 3586971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609269239, ExchCode = 'DEU' WHERE SecCode = 3586984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218033, ExchCode = 'SGO' WHERE SecCode = 3587010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218034, ExchCode = 'SGO' WHERE SecCode = 3587014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21619168949, ExchCode = 'STU' WHERE SecCode = 3587019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21559909557, ExchCode = 'TDG', PermQuoteRetireDate = '2021-04-06' WHERE SecCode = 3587027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684118505, Ticker = 'AEJ', ExchCode = 'LSE' WHERE SecCode = 3587037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752247684, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 3588035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664433940, ExchCode = 'MUN' WHERE SecCode = 3610818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664984725, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3615233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664987336, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3615235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '0OQ' WHERE SecCode = 3652072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 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 QuotePermID = 21670450813, ExchCode = 'DEU' WHERE SecCode = 3657811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671376807, ExchCode = 'DEU' 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 = 21675091688, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3690817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673848109, ExchCode = 'BIV' WHERE SecCode = 3717229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807025755, ExchCode = 'FRA' WHERE SecCode = 3739134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749597748, ExchCode = 'FRA' WHERE SecCode = 3800553 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'K95' WHERE SecCode = 3806449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 3814100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679917567, Ticker = 'WUBAN', ExchCode = 'MXQ' WHERE SecCode = 3814192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789617001, ExchCode = 'BIV' WHERE SecCode = 3827965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650319, ExchCode = 'QTX' WHERE SecCode = 3829975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650263, ExchCode = 'DUS' WHERE SecCode = 3832747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757864191, ExchCode = 'DEU' WHERE SecCode = 3832750 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 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 = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789792374, ExchCode = 'DUS' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21495995528.0 WHERE SecCode = 3936147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272890, ExchCode = 'GTX' WHERE SecCode = 3951450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363718, ExchCode = 'MEX' WHERE SecCode = 3966586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363715, ExchCode = 'MEX' WHERE SecCode = 3966587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808198439, ExchCode = 'MUN' WHERE SecCode = 3972240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718474201, ExchCode = 'FRA' WHERE SecCode = 3998157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026785, Ticker = '1NDX' WHERE SecCode = 4031953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026937, Ticker = '1SNAP' WHERE SecCode = 4032002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184449, ExchCode = 'SIG' WHERE SecCode = 4033113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 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 PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 4054210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21728977320, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4056300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729412447, ExchCode = 'FRA' WHERE SecCode = 4059429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729887692, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = NULL WHERE SecCode = 4062000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 = 21732154086, ExchCode = 'DEU' WHERE SecCode = 4080678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976737, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772634388, ExchCode = 'DUS' WHERE SecCode = 4212482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750154407, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 4228115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751968233, Ticker = 'GLDAl', ExchCode = 'TRQ' WHERE SecCode = 4230722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-08' WHERE SecCode = 4274159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757456175, ExchCode = 'FRA' WHERE SecCode = 4277594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 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 = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21765297153, ExchCode = 'DEU' WHERE SecCode = 4335866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX', PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774613209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4379791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'PPLI*' WHERE SecCode = 4390353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307581, ExchCode = 'MEX' WHERE SecCode = 4403942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785622125, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370420, ExchCode = 'AQE' 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 = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791469822, ExchCode = 'DUS' WHERE SecCode = 4451262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796141645, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4487640 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797820607, ExchCode = 'FRA' WHERE SecCode = 4499152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 4510031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386713, ExchCode = 'LAS' WHERE SecCode = 4513650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857143288, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 4550761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4579789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4588483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312301, ExchCode = 'GTX' WHERE SecCode = 4590581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380574, ExchCode = 'LAS' WHERE SecCode = 4593303 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 4605984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21934986349, ExchCode = 'BTE' WHERE SecCode = 4608547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816905312, ExchCode = 'TDG' WHERE SecCode = 4609998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581928, ExchCode = 'QTX' WHERE SecCode = 4611004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010091542, ExchCode = 'TQE' WHERE SecCode = 4617708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 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 = 21821283441, ExchCode = 'DEU' WHERE SecCode = 4630664 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 4636301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822771356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-08-16' WHERE SecCode = 4637752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312261, ExchCode = 'GTX' WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831914249, ExchCode = 'MUN' WHERE SecCode = 4651786 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 = 21837529040, ExchCode = 'GER' WHERE SecCode = 4693646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840890512, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4709616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21841738796, IsPrimaryQuote = 1, ExchCode = 'FRA' WHERE SecCode = 4712681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843915272, ExchCode = 'STU' WHERE SecCode = 4718902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954884, ExchCode = 'LAS' WHERE SecCode = 4726104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782726100, ExchCode = 'STU' WHERE SecCode = 4726105 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 4726110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851127841, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4742663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893303439, ExchCode = 'MUN' WHERE SecCode = 4745390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851158672, ExchCode = 'FRA' WHERE SecCode = 4748566 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867533, ExchCode = 'DEU' WHERE SecCode = 4752212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727225967, ExchCode = 'BIV' WHERE SecCode = 4753688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387339, ExchCode = 'LAS' WHERE SecCode = 4767878 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 = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860097727, ExchCode = 'FRA' WHERE SecCode = 4794547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860598463, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 4804576 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 = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861142799, ExchCode = 'FRA' WHERE SecCode = 4829216 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4841196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869360768, ExchCode = 'QTX' WHERE SecCode = 4847005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874656954, ExchCode = 'FRA' WHERE SecCode = 4887246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727229220, ExchCode = 'BIV' WHERE SecCode = 4890352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000028354, IncCntry = 'JEY', PriTRBCIndPermID = 4294951197.0, PermOrgIPODate = '2026-05-11' WHERE SecCode = 4903982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882166752, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778071474, PermQuoteStatus = 'AC', Ticker = '62U2', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885992034, ExchCode = 'FRA' WHERE SecCode = 4959596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727205517, ExchCode = 'MEX' WHERE SecCode = 4962789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902148575, ExchCode = 'FRA' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782434304, ExchCode = 'QTX' WHERE SecCode = 4996978 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4999841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809757585, ExchCode = 'FRA' WHERE SecCode = 5002458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607201, Ticker = 'DXCM', ExchCode = 'SWX' WHERE SecCode = 5047087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 5067274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777145391, ExchCode = 'STU' WHERE SecCode = 5082548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834841, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5115635 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797935268, ExchCode = 'MUN' WHERE SecCode = 5140247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529719645, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5161223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916823, ExchCode = 'MUN' WHERE SecCode = 5161225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634297955, Ticker = '0M1Kl', ExchCode = 'BCO' WHERE SecCode = 5161267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034611, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 5161351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485132, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21922889048, ExchCode = 'DEU' WHERE SecCode = 5174469 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778838011, ExchCode = 'DUS', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 5182664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181308541, ExchCode = 'OCU' WHERE SecCode = 5203369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872761574, Ticker = 'AFTT', ExchCode = 'PAR' WHERE SecCode = 5206274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881193903, ExchCode = 'PAR' WHERE SecCode = 5206345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21833306231, Ticker = '3LNI', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5208067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21939720495, ExchCode = 'FRA' WHERE SecCode = 5281346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386763, ExchCode = 'LAS' WHERE SecCode = 5292727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798387449, ExchCode = 'HAM' WHERE SecCode = 5296146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943067733, ExchCode = 'FRA' WHERE SecCode = 5301896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951908505, PermQuoteStatus = 'DC', Ticker = '3QP0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5324087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957797642, ExchCode = 'DEU' WHERE SecCode = 5374832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957768163, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07' WHERE SecCode = 5374833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028052111, ExchCode = 'DEU' WHERE SecCode = 5374858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959716915, ExchCode = 'DEU' WHERE SecCode = 5383599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520780621, ExchCode = 'FRA' WHERE SecCode = 5383600 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5398958 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5399888 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777874410, ExchCode = 'GTX' WHERE SecCode = 5413669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921513369, ExchCode = 'QTX', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 5443586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348315, ExchCode = 'QTX' WHERE SecCode = 5466221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380732, ExchCode = 'LAS' WHERE SecCode = 5466447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151033, PermQuoteStatus = 'AC', Ticker = '3FNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5569246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781012608, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5631688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835007, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5638905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ZK7d' WHERE SecCode = 5697992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781981055, ExchCode = 'MEX' WHERE SecCode = 5701235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078152, ExchCode = 'LAS' WHERE SecCode = 5703208 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 5717755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028890792, ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-30' WHERE SecCode = 5724941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793731712, ExchCode = 'TDG' WHERE SecCode = 5731414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799652775, ExchCode = 'LAS' WHERE SecCode = 5740795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799474968, ExchCode = 'LAS' WHERE SecCode = 5758113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22035457659, ExchCode = 'DEU' WHERE SecCode = 5765005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5787360 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5787368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784377679, ExchCode = 'STU' WHERE SecCode = 5827592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784377678, ExchCode = 'FRA' WHERE SecCode = 5827593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784890672, ExchCode = 'FRA' WHERE SecCode = 5857780 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21495995528.0 WHERE SecCode = 5885543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174666337, ExchCode = 'CHI' WHERE SecCode = 5920812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6043253 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789864380, ExchCode = 'STU' WHERE SecCode = 6078492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475007845, PermQuoteStatus = 'AC', Ticker = 'ECQ0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 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 QuotePermID = 236790492416, ExchCode = 'QTX' WHERE SecCode = 6119927 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6149547 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6149548 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6149549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790713136, ExchCode = 'FRA' WHERE SecCode = 6151862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790713137, ExchCode = 'FRA' WHERE SecCode = 6151863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791667937, ExchCode = 'BIV' WHERE SecCode = 6226138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791954187, ExchCode = 'STU' WHERE SecCode = 6250300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823991, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22101568655, ExchCode = 'DEU' WHERE SecCode = 6258497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789803304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-06', PermSecMapEndDate = '2026-03-06' WHERE SecCode = 6260557 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '1PPLI' WHERE SecCode = 6264032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105867713, ExchCode = 'MUN' WHERE SecCode = 6286094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792558886, ExchCode = 'FRA' WHERE SecCode = 6286099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793934107, ExchCode = 'FRA' WHERE SecCode = 6377054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130904343, ExchCode = 'GTX' WHERE SecCode = 6421142 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788837447, ExchCode = 'BIV' WHERE SecCode = 6448789 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 6451085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798109710, ExchCode = 'QTX' WHERE SecCode = 6501107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798202984, ExchCode = 'MUN' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143843399, ExchCode = 'DEU' WHERE SecCode = 6577960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806168734, ExchCode = 'SIG' WHERE SecCode = 6578406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800709238, ExchCode = 'QTX' WHERE SecCode = 6596130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800660438, ExchCode = 'DUS' WHERE SecCode = 6596132 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 6622164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802150029, Ticker = 'UPST', ExchCode = 'SWX' WHERE SecCode = 6629463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645653 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 6672572 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 6686517 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 6721473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804168533, ExchCode = 'STU' WHERE SecCode = 6724297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 6796828 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 6802659 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 6832521 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 6846710 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 6868103 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 6870909 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-04' WHERE SecCode = 6880026 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6885945 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6890853 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6890856 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6890957 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6890958 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6893666 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807883959, ExchCode = 'FRA' WHERE SecCode = 6893691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886145, ExchCode = 'MEX' WHERE SecCode = 6893698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807581061, ExchCode = 'BIV' WHERE SecCode = 6893701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807612967, ExchCode = 'TDG' WHERE SecCode = 6893703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807884296, ExchCode = 'MEX' WHERE SecCode = 6897215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886741, ExchCode = 'FRA' WHERE SecCode = 6897216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886743, ExchCode = 'FRA' WHERE SecCode = 6897217 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6897222 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 236807984009.0, ValQuotePermID = 22184682176.0, PermOrgIPODate = '2026-06-04' WHERE SecCode = 6897245 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 6900861 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 10920345 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MDAHF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 11009311 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'CSX', ExchCode = 'CVE' WHERE SecCode = 11012454 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 21495995528.0 WHERE SecCode = 11024402 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-07' WHERE SecCode = 11027686 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11052177 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'CRRLF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 11065833 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 11067235 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MGRSF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 11070154 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'KRXBF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 11113901 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11143993 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'HLIGF', PermQuoteRetireDate = NULL WHERE SecCode = 11151927 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11157118 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11158630 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11181696 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11182015 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11183460 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 11203252 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 21629642716.0 WHERE SecCode = 11208737 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11211469 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 11213191 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 11213783 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 11226938 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000028354, IncCntry = 'JEY', PriTRBCIndPermID = 4294951197.0, PermOrgIPODate = '2026-05-11' WHERE SecCode = 11229735 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11240856 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236776474518, IsPrimaryQuote = 0, ExchCode = 'CES', PermSecMapStartDate = '2022-06-24', PermSecMapEndDate = '2026-06-03' WHERE SecCode = 11245859 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11252380 AND Type_ = 1; UPDATE data_universe_permid SET QuoteClass = 'CEF', InstrClass = 'CEF' WHERE SecCode = 11263590 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11268806 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11272352 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11272357 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'HLIGF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 11274352 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11277617 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 11277958 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11278986 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11285851 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11289161 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11289162 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11289163 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11289165 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11289169 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'TOR' WHERE SecCode = 11289698 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11292909 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11292910 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295229 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951281.0 WHERE SecCode = 11295817 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232933217084.0 WHERE SecCode = 11296313 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11296373 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11296848 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236807976833, IsPrimaryQuote = 1, ExchCode = 'PNK' WHERE SecCode = 11296849 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236807976832, IsPrimaryQuote = 1, ExchCode = 'PNK' WHERE SecCode = 11296850 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236807983773, IsPrimaryQuote = 1, Ticker = 'THARY', ExchCode = 'PNK' WHERE SecCode = 11297037 AND Type_ = 1;