UPDATE data_universe_permid SET QuotePermID = 55836047499, Ticker = 'AAT', ExchCode = 'LSE', PermQuoteRetireDate = '2012-11-12' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 19809 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 30213 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 30235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808726031, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-19', PermSecMapEndDate = NULL WHERE SecCode = 35870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661362178, ExchCode = 'STU' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836523767, ExchCode = 'FRA' WHERE SecCode = 41385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624203, Ticker = 'SCXG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB', PermQuoteRetireDate = NULL WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449047, ExchCode = 'DEU' WHERE SecCode = 47312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589629, Ticker = NULL, ExchCode = 'HAM', PermQuoteRetireDate = '2006-05-17' WHERE SecCode = 53991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475576317, ExchCode = 'STU', PermQuoteRetireDate = '2008-01-07' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 56571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475628897, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2008-04-18', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 56895 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 QuotePermID = 21526392841, ExchCode = 'DEU' WHERE SecCode = 60669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 63150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836422897, ExchCode = 'FRA' WHERE SecCode = 65261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341183, Ticker = 'RDV', ExchCode = 'BER', PermQuoteRetireDate = '2012-06-07' WHERE SecCode = 65270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546164752, ExchCode = 'TDG' WHERE SecCode = 65298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482532, ExchCode = 'QTX' WHERE SecCode = 65308 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 65836 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365432.0 WHERE SecCode = 70097 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 74813 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 75029 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951206.0 WHERE SecCode = 76598 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 80275 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 84806 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 85675 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951206.0 WHERE SecCode = 86678 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 87558 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ROB', PermSecMapEndDate = '2026-06-20' WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-20' WHERE SecCode = 93731 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 104821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808726026, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-19', PermSecMapEndDate = NULL WHERE SecCode = 112763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807026221, ExchCode = 'FRA' WHERE SecCode = 119132 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 120312 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 123563 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 124169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780682738, PermQuoteStatus = 'DC', ExchCode = 'GTX', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 128769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472972, ExchCode = 'FRA' WHERE SecCode = 132940 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 134898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492299, ExchCode = 'QTX' WHERE SecCode = 137720 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 142149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519207, ExchCode = 'DUS', PermQuoteRetireDate = '2014-12-16' WHERE SecCode = 144542 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ETIHADENERGY' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101821, ExchCode = 'FRA' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460041, ExchCode = 'DEU' WHERE SecCode = 147556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101861, ExchCode = 'FRA' WHERE SecCode = 147559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506666662, ExchCode = 'STU', PermQuoteRetireDate = '2014-12-04' WHERE SecCode = 147560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491206370, ExchCode = 'STU' WHERE SecCode = 147562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522079315, ExchCode = 'DEU' WHERE SecCode = 147569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336744, ExchCode = 'FRA' WHERE SecCode = 147570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474940370, ExchCode = 'DEU' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 161568 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188304213, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-19', PermSecMapEndDate = NULL WHERE SecCode = 177715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474902041, ExchCode = 'DEU', PermQuoteRetireDate = '2020-12-28' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 248983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 323307 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951796.0 WHERE SecCode = 410955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 520063 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 520165 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 532221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 561082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230062, ExchCode = 'FRA', PermQuoteRetireDate = '2016-11-03' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22002746026, Ticker = 'XBEC', ExchCode = 'SWX' WHERE SecCode = 737768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476269368, ExchCode = 'FRA' WHERE SecCode = 1449196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' 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 = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480207, PermQuoteStatus = 'DC', Ticker = '7NU', ExchCode = 'QTX', PermQuoteRetireDate = '2023-08-03', PermSecMapEndDate = '2025-06-13' WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 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 = 21807437495, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-10', PermSecMapEndDate = '2025-11-10' WHERE SecCode = 1564475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502555560, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 1569478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503429462, ExchCode = 'FRA' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515927789, ExchCode = 'DEU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538181095, ExchCode = 'STU' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507269905, ExchCode = 'FRA' WHERE SecCode = 1618200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742592, Ticker = 'KJ7', ExchCode = 'HAN', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 1623980 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 = 21535814698, Ticker = 'BMZ.GB', ExchCode = 'ISD', PermQuoteRetireDate = '2015-04-20' WHERE SecCode = 1635481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882713778, ExchCode = 'GTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510008303, ExchCode = 'DEU' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514317171, Ticker = 'FOI', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-22' WHERE SecCode = 1656381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517357298, ExchCode = 'TDG', PermQuoteRetireDate = '2013-06-24' WHERE SecCode = 1673210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799113029, ExchCode = 'LAS' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387414, ExchCode = 'LAS' WHERE SecCode = 1723207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197687, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-10' WHERE SecCode = 1735686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948839, PermQuoteStatus = 'DC', Ticker = 'OD7L', ExchCode = 'HAN', PermQuoteRetireDate = '2024-03-05' WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1835921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814699253, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327198, ExchCode = 'DEU' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 2162009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644523837, ExchCode = 'STU' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626732, ExchCode = 'FRA' WHERE SecCode = 2220730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532444506, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563544, ExchCode = 'FRA' WHERE SecCode = 2239343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531603865, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' 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 = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 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 = 21525927737, ExchCode = 'FRA' WHERE SecCode = 2278244 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 = 21525929139, ExchCode = 'FRA' WHERE SecCode = 2288360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854585, ExchCode = 'BER', PermQuoteRetireDate = '2020-12-29' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515724218, ExchCode = 'BER', PermQuoteRetireDate = '2021-06-04' WHERE SecCode = 2289254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530042418, ExchCode = 'DEU' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181887127, ExchCode = 'DEU' WHERE SecCode = 2357975 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 = 21521371665, ExchCode = 'SGO' 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 = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531848797, ExchCode = 'FRA' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531978999, ExchCode = 'FRA' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532119904, ExchCode = 'DEU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336720, ExchCode = 'FRA' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679407, ExchCode = 'BIV' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517626184, ExchCode = 'MUN' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534457668, ExchCode = 'FRA' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443169, ExchCode = 'TDG' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724351602, ExchCode = 'QTX' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197362, Ticker = 'MRK', ExchCode = 'BRN' WHERE SecCode = 2465112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538229, ExchCode = 'GTX' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800269665, ExchCode = 'FRA' WHERE SecCode = 2482710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108940988, ExchCode = 'DEU' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551088215, ExchCode = 'DEU' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848757217, ExchCode = 'QTX', PermQuoteRetireDate = '2023-01-17', PermSecMapEndDate = NULL WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909440, ExchCode = 'DEU' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619324261, ExchCode = 'FRA', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585062789, ExchCode = 'BEC' WHERE SecCode = 2539930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230438, ExchCode = 'FRA' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378729, ExchCode = 'GTX' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637306664, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890729, ExchCode = 'DEU' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368221, ExchCode = 'FRA' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768595, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2573038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042368, ExchCode = 'DEU' WHERE SecCode = 2580935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616206318, ExchCode = 'STU' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662661878, ExchCode = 'MUN' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722349014, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547157215, ExchCode = 'DEU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548007507, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548037377, ExchCode = 'DEU', PermQuoteRetireDate = '2020-11-12' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548030533, ExchCode = 'DEU' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548030535, ExchCode = 'DEU' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414445, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548207169, ExchCode = 'DEU' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589641130, ExchCode = 'STU' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647223374, ExchCode = 'MUN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451580, PermQuoteStatus = 'DC', Ticker = 'VOD', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 2682192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551131018, ExchCode = 'DEU', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550836222, ExchCode = 'FRA' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551269259, ExchCode = 'TDG' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606359247, ExchCode = 'MUN' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704155, ExchCode = 'MXQ' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554451923, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-14' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555272551, ExchCode = 'DEU' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252740, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322234, Ticker = 'IDV1', ExchCode = 'FRA' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322223, ExchCode = 'FRA' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' 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 = 21672243468, ExchCode = 'MUN' WHERE SecCode = 2855817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580961084, ExchCode = 'STU' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561682172, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561798255, ExchCode = 'DEU' WHERE SecCode = 2872657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561799121, Ticker = 'A2P', ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2872658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385190, ExchCode = 'LAS' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180586, ExchCode = 'DEU' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595194710, ExchCode = 'STU' WHERE SecCode = 2887282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563177438, ExchCode = 'DEU' WHERE SecCode = 2887312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, Ticker = 'SX7EEz', ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864729, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077770, ExchCode = 'LAS' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073579, ExchCode = 'FRA' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564679404, ExchCode = 'FRA' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564682992, ExchCode = 'FRA', PermQuoteRetireDate = '2025-10-22', PermSecMapEndDate = '2025-10-22' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565403130, ExchCode = 'DEU' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623096, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568560621, ExchCode = 'DEU' WHERE SecCode = 2929653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985207, ExchCode = 'TDG' WHERE SecCode = 2935962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 2963470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706327513, ExchCode = 'TDG' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488199, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431770, ExchCode = 'DEU' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611487587, ExchCode = 'FRA' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235696, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264715, ExchCode = 'MUN', PermQuoteRetireDate = '2022-03-15', PermSecMapEndDate = NULL WHERE SecCode = 3090272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22124025589, ExchCode = 'DEU' WHERE SecCode = 3124127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587662536, ExchCode = 'STU' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056939, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3169823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028891006, ExchCode = 'STU' WHERE SecCode = 3200981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079754, ExchCode = 'TDG' WHERE SecCode = 3219367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641516, ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 3219383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496462, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 3232404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656608637, ExchCode = 'MUN' WHERE SecCode = 3263894 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 3271697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833203, ExchCode = 'DEU' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608276926, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645775, ExchCode = 'FRA' 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 = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443153, ExchCode = 'FRA' WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958313, ExchCode = 'DEU' WHERE SecCode = 3337707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620456907, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3338477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614671400, ExchCode = 'DEU' WHERE SecCode = 3357942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743475404, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3378582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765833817, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761306157, ExchCode = 'FRA' WHERE SecCode = 3386777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622425444, PermQuoteStatus = 'AC', Ticker = 'C5B0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670439400, ExchCode = 'BER', PermQuoteRetireDate = '2023-11-06', PermSecMapEndDate = NULL WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378638, ExchCode = 'BRN' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704915, ExchCode = 'MXQ' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469772, ExchCode = 'DEU' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228480, ExchCode = 'FRA' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380142, PermQuoteStatus = 'AC', Ticker = 'DV4', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641222426, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31', PermSecMapEndDate = NULL WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622936, ExchCode = 'FRA' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624076993, ExchCode = 'SGO' WHERE SecCode = 3406544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628602986, Ticker = 'DTS', ExchCode = 'MUN', PermQuoteRetireDate = '2020-10-02' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 3408346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704376, ExchCode = 'MXQ' WHERE SecCode = 3430658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678582, ExchCode = 'BIV' WHERE SecCode = 3430824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780224, ExchCode = 'FRA' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705439, ExchCode = 'MXQ' WHERE SecCode = 3430968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997874, ExchCode = 'DEU' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643680223, ExchCode = 'BER' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644992133, Ticker = 'CASl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3446120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21925498341, ExchCode = 'STU' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647042623, ExchCode = 'FRA' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647042502, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647200544, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100414, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3491217 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18' WHERE SecCode = 3501596 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 = 21653590215, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3535859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21994180608, ExchCode = 'BTE' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 3549452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238718, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3553157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 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 = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667846371, ExchCode = 'FRA' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748602400, ExchCode = 'FRA' WHERE SecCode = 3623818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144718982, ExchCode = 'HAM' WHERE SecCode = 3623819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801287191, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-06-17' WHERE SecCode = 3623822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505131, ExchCode = 'MUN' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671376807, ExchCode = 'DEU' WHERE SecCode = 3666895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636387547, Ticker = '2NFL.GB', ExchCode = 'AQS' WHERE SecCode = 3669927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114234, ExchCode = 'DEU' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220426, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674386, ExchCode = 'BIV' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678493, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684103049, ExchCode = 'FRA' WHERE SecCode = 3771411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367137, ExchCode = 'DEU' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830028, ExchCode = 'QTX' WHERE SecCode = 3841486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787247924, ExchCode = 'FRA' WHERE SecCode = 3841487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21698786104, ExchCode = 'CHI', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245385, ExchCode = 'DEU' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895290, ExchCode = 'DEU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' 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 = 21584837232, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710752190, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07', PermSecMapEndDate = NULL WHERE SecCode = 3949028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363709, ExchCode = 'BIV' WHERE SecCode = 3966586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363706, ExchCode = 'BIV' WHERE SecCode = 3966587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714765661, ExchCode = 'STU' WHERE SecCode = 3972240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715393197, ExchCode = 'DEU' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165572, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3977923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3977926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536122160, ExchCode = 'FRA' WHERE SecCode = 4030457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011956, Ticker = '2GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682767, Ticker = '2BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044966173, Ticker = '2BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042587, Ticker = '2SHA', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013792, Ticker = '2SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822947768, Ticker = '4DSY', ExchCode = 'ETX' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633857, ExchCode = 'STU' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723632161, ExchCode = 'DEU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 4046415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571646335, ExchCode = 'BEC' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725971281, ExchCode = 'TDG' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 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 = 21726460845, ExchCode = 'FRA' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995390, ExchCode = 'DEU' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776435514, Ticker = 'ZWIPEs', ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-21' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260229, ExchCode = 'DEU' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077946, ExchCode = 'LAS' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829986, ExchCode = 'QTX' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304635, ExchCode = 'DEU' WHERE SecCode = 4195320 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 = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611412, ExchCode = 'DEU' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692047, ExchCode = 'FRA' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489973, ExchCode = 'FRA' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763901203, ExchCode = 'QTX' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387283, ExchCode = 'LAS' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966496, ExchCode = 'DEU' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770634972, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909432, ExchCode = 'FRA' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307570, ExchCode = 'BIV' WHERE SecCode = 4403942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909499, ExchCode = 'FRA' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787491381, ExchCode = 'BER', PermQuoteRetireDate = '2021-01-05' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787035686, ExchCode = 'FRA' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817233574, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4449683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-02-11', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 4459949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291863, ExchCode = 'MEX' WHERE SecCode = 4485970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801059554, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4487598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817595, ExchCode = 'DEU' WHERE SecCode = 4487625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809367, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4499132 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 = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801053714, ExchCode = 'MUN' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 4517646 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-20' WHERE SecCode = 4522945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 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 = 22140273543, ExchCode = 'BCO' WHERE SecCode = 4563419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075404, ExchCode = 'LAS' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818128449, PermQuoteStatus = 'AC', Ticker = 'WWT0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821858169, ExchCode = 'DEU' WHERE SecCode = 4633105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852728821, ExchCode = 'MUN' WHERE SecCode = 4640323 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 = 21824104173, ExchCode = 'DEU' WHERE SecCode = 4645553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073655, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-22', PermSecMapEndDate = '2025-12-22' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727256655, ExchCode = 'BIV' WHERE SecCode = 4654595 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951206.0 WHERE SecCode = 4659795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954880, ExchCode = 'LAS', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, Ticker = '9KK0', ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835689, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4681691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793284943, PermQuoteStatus = 'AC', Ticker = '94Y', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4682737 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 = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388765, ExchCode = 'LAS' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915272, ExchCode = 'STU' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853430101, ExchCode = 'GTX' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844719378, ExchCode = 'DEU' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850720248, ExchCode = 'FRA' WHERE SecCode = 4745390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850878709, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-09' WHERE SecCode = 4748504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127893, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850721585, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-15', PermSecMapEndDate = '2025-08-15' WHERE SecCode = 4748530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851141782, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-27', PermSecMapEndDate = '2025-10-27' WHERE SecCode = 4748531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158795, ExchCode = 'FRA' WHERE SecCode = 4748563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814076491, ExchCode = 'DEU' WHERE SecCode = 4752207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867538, ExchCode = 'FRA' WHERE SecCode = 4752212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561792, ExchCode = 'GTX' WHERE SecCode = 4754742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136607450, ExchCode = 'BTE' WHERE SecCode = 4756631 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 = 21853953634, ExchCode = 'QTX' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887138, ExchCode = 'GTX' WHERE SecCode = 4761589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854744263, ExchCode = 'QTX' WHERE SecCode = 4766038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 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 = 21856019028, ExchCode = 'MUN', PermQuoteRetireDate = '2025-01-08' WHERE SecCode = 4775072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518118, ExchCode = 'DEU' WHERE SecCode = 4775200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518308, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 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 OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 4798367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859821791, ExchCode = 'STO' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954958, ExchCode = 'LAS' WHERE SecCode = 4802301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862298482, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-10' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815777446, ExchCode = 'FRA' WHERE SecCode = 4815314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861142851, ExchCode = 'DEU' WHERE SecCode = 4829216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874018782, ExchCode = 'QTX' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830057, ExchCode = 'QTX' WHERE SecCode = 4834795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866893816 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'A1GT34' WHERE SecCode = 4854751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089452780, ExchCode = 'DXE' WHERE SecCode = 4854872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873061105, ExchCode = 'TDG' WHERE SecCode = 4878702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829806151, ExchCode = 'DEU' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885726, ExchCode = 'FRA' WHERE SecCode = 4890300 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2025-02-11' WHERE SecCode = 4893289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727234438, ExchCode = 'BIV' WHERE SecCode = 4938297 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 = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883757511, PermQuoteStatus = 'DC', Ticker = '7U6', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893301199, ExchCode = 'GTX' WHERE SecCode = 4952512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884973234, ExchCode = 'GTX' WHERE SecCode = 4957875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381606, ExchCode = 'LAS' WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716228, ExchCode = 'DEU' WHERE SecCode = 4960863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885992168, ExchCode = 'FRA' WHERE SecCode = 4960864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886409923, ExchCode = 'DEU' WHERE SecCode = 4965055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887686666, PermQuoteStatus = 'AC', Ticker = 'WATT', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 4969554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893308828, ExchCode = 'DEU' WHERE SecCode = 4992085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894948499, ExchCode = 'PAR' WHERE SecCode = 5013560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898242757, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-03-19', PermSecMapEndDate = '2026-03-19' WHERE SecCode = 5038681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777145391, ExchCode = 'STU' WHERE SecCode = 5082548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217399, ExchCode = 'MEX' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907546209, ExchCode = 'DUS', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908088080, ExchCode = 'FRA' WHERE SecCode = 5105967 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 PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-02-11', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 5117007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913514545, ExchCode = 'DEU' WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 5134669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154587938, ExchCode = 'BCO' WHERE SecCode = 5152300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430452, ExchCode = 'DEU' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 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, Ticker = 'FT5', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943643469, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177240, ExchCode = 'MUN' WHERE SecCode = 5183106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923944044, ExchCode = 'DEU' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049597, Ticker = 'KRC*', ExchCode = 'MXQ' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783133624, ExchCode = 'TDG' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227057, ExchCode = 'BIV' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919819094, ExchCode = 'MXQ' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938339192, ExchCode = 'MUN' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935263193, ExchCode = 'DEU' WHERE SecCode = 5265003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935906810, ExchCode = 'DEU' WHERE SecCode = 5265006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935906348, ExchCode = 'DEU' WHERE SecCode = 5265007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388889, ExchCode = 'LAS' WHERE SecCode = 5296146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951358875, PermQuoteStatus = 'AC', Ticker = '3QP', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-02-11', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 5339057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950823856, ExchCode = 'FRA' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633841, ExchCode = 'FRA' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953963626, ExchCode = 'MUN' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954130974, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487235, ExchCode = 'FRA' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000139106, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5380631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156624, ExchCode = 'FRA' WHERE SecCode = 5402859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223518, ExchCode = 'FRA' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777195781, ExchCode = 'TDG' WHERE SecCode = 5407839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22092544416, ExchCode = 'DEU' WHERE SecCode = 5407840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777239370, PermQuoteStatus = 'DC', Ticker = 'T2I0', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 5407846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777248729, ExchCode = 'FRA' WHERE SecCode = 5407861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812181526, ExchCode = 'FRA' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874410, ExchCode = 'GTX' WHERE SecCode = 5413669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712126614, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-17' WHERE SecCode = 5430827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21991218437, ExchCode = 'BER' WHERE SecCode = 5434328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667447, ExchCode = 'STU' WHERE SecCode = 5436573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667355, ExchCode = 'STU' WHERE SecCode = 5436574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726336464, ExchCode = 'FRA' WHERE SecCode = 5466446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299981, ExchCode = 'FRA' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980729136, ExchCode = 'MXQ' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834825, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580217, ExchCode = 'GER' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471184, ExchCode = 'BIV' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471180, ExchCode = 'MEX' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060301, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-05', PermSecMapEndDate = NULL WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637484538, ExchCode = 'DEU' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010677492, ExchCode = 'DEU' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837511990, Ticker = '2STSa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795035307, ExchCode = 'GTX' WHERE SecCode = 5706779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782871477, InstrPermID = 232839630934, ValQuotePermID = 236782771608.0, IsPrimaryInstr = 0, PermQuoteStatus = 'DC', Ticker = '6SO', ExchCode = 'STU', PermQuoteRetireDate = '2026-05-20', PermSecMapStartDate = '2024-04-30', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22035457659, ExchCode = 'DEU' WHERE SecCode = 5765005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181310368, ExchCode = 'OCU' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785775547, ExchCode = 'FRA' WHERE SecCode = 5903135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785825527, ExchCode = 'FRA' WHERE SecCode = 5903170 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000161817, PriTRBCIndPermID = 4294951648.0, PermOrgIPODate = '2021-01-20' WHERE SecCode = 5907885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790682427, PermQuoteStatus = 'DC', Ticker = '83W0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066678467, ExchCode = 'DEU' WHERE SecCode = 5963924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-02-11', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 6024138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789143418, ExchCode = 'BIV' WHERE SecCode = 6064006 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-18', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 6067557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110995, Ticker = 'BITCl', ExchCode = 'BTE' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110997, Ticker = 'BITPl', ExchCode = 'BTE' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789803299, ExchCode = 'TDG' WHERE SecCode = 6078492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835874, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566204, ExchCode = 'DEU' WHERE SecCode = 6097356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836167, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779226797, PermQuoteStatus = 'DC', Ticker = '5VFC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835913, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834940, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789870076, ExchCode = 'HAN', PermQuoteRetireDate = '2025-01-31', PermSecMapEndDate = NULL WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 1, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 6147594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22092285949, ExchCode = 'DEU' WHERE SecCode = 6177691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838445, ExchCode = 'FRA' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147197, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811034765, ExchCode = 'MXQ' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071047025, ExchCode = 'DEU' WHERE SecCode = 6256447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792270095, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269534, ExchCode = 'FRA' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792340963, ExchCode = 'DUS' WHERE SecCode = 6270465 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 = 236792959792, ExchCode = 'FRA' WHERE SecCode = 6310331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959791, ExchCode = 'FRA' WHERE SecCode = 6310332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788319, ExchCode = 'MEX' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793173877, ExchCode = 'TDG' WHERE SecCode = 6324049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912563, ExchCode = 'SWX' WHERE SecCode = 6324051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794320484, ExchCode = 'FRA' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795166766, ExchCode = 'TDG' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451414, ExchCode = 'BTE' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157927, ExchCode = 'BTE' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157937, ExchCode = 'BTE' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703185, ExchCode = 'BTE' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451415, ExchCode = 'BTE' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447615, ExchCode = 'BTE' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157950, ExchCode = 'BTE' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451405, ExchCode = 'BTE' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128281486, ExchCode = 'QTX' WHERE SecCode = 6457998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140986, ExchCode = 'MUN' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798105812, ExchCode = 'QTX' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798598065, ExchCode = 'FRA' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462190, ExchCode = 'GTX' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743592, ExchCode = 'DUS' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607052, Ticker = 'MRNA', ExchCode = 'SWX' WHERE SecCode = 6578363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607123, Ticker = 'SNOW', ExchCode = 'SWX' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727215303, ExchCode = 'BRN' WHERE SecCode = 6580795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800095947, ExchCode = 'TDG' WHERE SecCode = 6590583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955089, ExchCode = 'MEX' WHERE SecCode = 6590630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800658724, ExchCode = 'QTX' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152236620, ExchCode = 'DEU' WHERE SecCode = 6627152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152237029, ExchCode = 'DEU' WHERE SecCode = 6627153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607867, ExchCode = 'TDG' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181887104, ExchCode = 'DEU' WHERE SecCode = 6705525 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 6724413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804998607, ExchCode = 'QTX' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805530357, ExchCode = 'MUN' WHERE SecCode = 6737927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168605391, ExchCode = 'DEU' WHERE SecCode = 6737928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095498, ExchCode = 'DUS' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808332134, ExchCode = 'LAS' WHERE SecCode = 6753080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901582, ExchCode = 'BTE' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672065, ExchCode = 'FRA' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236808685585.0 WHERE SecCode = 6839686 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-20' WHERE SecCode = 6849999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807255715, ExchCode = 'MUN' WHERE SecCode = 6862202 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000154178, PriInstrPermID = 232937212202.0, DomCntry = 'BMU', IncCntry = 'BMU', PermOrgIPODate = '2026-06-05' WHERE SecCode = 6885945 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 6897213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408711, ExchCode = 'MEX' WHERE SecCode = 6900891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782483, ExchCode = 'TDG' WHERE SecCode = 6900894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808269919, ExchCode = 'FRA' WHERE SecCode = 6902160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808190084, ExchCode = 'DUS' WHERE SecCode = 6902189 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 6902747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22186460513, ExchCode = 'DEU' WHERE SecCode = 6917417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22186459587, ExchCode = 'DEU' WHERE SecCode = 6917418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22186465067, ExchCode = 'DEU' WHERE SecCode = 6917419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185584083, ExchCode = 'DEU' WHERE SecCode = 6917506 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 6921021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808501774, ExchCode = 'STU' WHERE SecCode = 6921073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808715502, ExchCode = 'GTX' WHERE SecCode = 6921074 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6923746 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6923751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808715505, ExchCode = 'TDG' WHERE SecCode = 6923752 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236808613401.0 WHERE SecCode = 6927600 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-19' WHERE SecCode = 6930638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22187932547, ExchCode = 'DEU' WHERE SecCode = 6930657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22187911592, ExchCode = 'DEU' WHERE SecCode = 6930659 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000139106, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-20' WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 11133200 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11195032 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CATTD' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11214228 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000161817, PriTRBCIndPermID = 4294951648.0, PermOrgIPODate = '2021-01-20' WHERE SecCode = 11217741 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11262373 AND Type_ = 1;
UPDATE data_universe_permid SET InstrPermID = 18040307071 WHERE SecCode = 11263590 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 1, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 11267607 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 11270668 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11275103 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 11275270 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 11277033 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11281861 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2025-08-15', PermSecMapEndDate = NULL WHERE SecCode = 11282047 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 11286613 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11288492 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295027 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232925823392.0, IsPrimaryInstr = 0 WHERE SecCode = 11295063 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232916091000.0 WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232925299588.0 WHERE SecCode = 11295151 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232921381814.0 WHERE SecCode = 11295152 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232921151830.0 WHERE SecCode = 11296944 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 11297410 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11297531 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000150625, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 1, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 11297633 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236808624030.0, ValQuotePermID = 21967707292.0 WHERE SecCode = 11297671 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808551771, IsPrimaryQuote = 1, ExchCode = 'CVE' WHERE SecCode = 11297684 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236807885747, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297726 AND Type_ = 1;
