UPDATE data_universe_permid SET QuotePermID = 21531128468, Ticker = 'HONl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2343 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3968 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 12664 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 15281 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 20297 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 22164 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-22' WHERE SecCode = 43333 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295342, ExchCode = 'GTX' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589631, Ticker = 'L0992', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584354094, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 55789 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 59477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526399804, ExchCode = 'FRA' WHERE SecCode = 60669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910168159, ExchCode = 'TDG' WHERE SecCode = 60683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 61749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874654411, ExchCode = 'GTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917173961, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 63016 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000145979, PriInstrPermID = 8590935125.0, PermOrgIPODate = '1996-08-01' WHERE SecCode = 75029 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 76880 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 83942 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 84781 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 85815 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'JPN' WHERE SecCode = 98717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799606984, ExchCode = 'TDG' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 125243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645874, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790478897, ExchCode = 'FRA' WHERE SecCode = 147554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101968, ExchCode = 'DEU' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460310, ExchCode = 'FRA' WHERE SecCode = 147556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101908, ExchCode = 'DEU' WHERE SecCode = 147559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328928, ExchCode = 'BER', PermQuoteRetireDate = '2016-09-22' WHERE SecCode = 147560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336583, ExchCode = 'BER' WHERE SecCode = 147562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522077518, ExchCode = 'FRA' WHERE SecCode = 147569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336780, ExchCode = 'DEU' WHERE SecCode = 147570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5076368902, PriTRBCIndPermID = NULL WHERE SecCode = 203639 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5076368902, PriTRBCIndPermID = NULL WHERE SecCode = 203660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000145979, PriInstrPermID = 8590935125.0, PermOrgIPODate = '1996-08-01' WHERE SecCode = 248983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-22' WHERE SecCode = 296284 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 323572 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 324615 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 326429 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'M96' WHERE SecCode = 336664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997542, ExchCode = 'DEU' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159147457, ExchCode = 'DEU' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 522882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230063, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255778, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157401812, ExchCode = 'DEU' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475858943, ExchCode = 'BTE', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808392960, Ticker = 'XBLCm', ExchCode = 'BTE' WHERE SecCode = 737768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 1233487 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-22', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 1455224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109482, ExchCode = 'DEU' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646184463, PermQuoteStatus = 'AC', Ticker = '5EV0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491111760, ExchCode = 'FRA' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511700265, PermQuoteStatus = 'AC', Ticker = '7NU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786220381, ExchCode = 'STU' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156877250, ExchCode = 'DEU' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514434081, Ticker = '5GQA', ExchCode = 'BER', PermQuoteRetireDate = '2020-04-02' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479129, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-07', PermSecMapEndDate = '2025-11-07' WHERE SecCode = 1564475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615254983, ExchCode = 'DEU', PermQuoteRetireDate = '2018-10-05' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 1583282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503838088, ExchCode = 'BER', PermQuoteRetireDate = '2017-05-30' WHERE SecCode = 1587478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524608957, ExchCode = 'CHI' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308444, ExchCode = 'STU' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505421178, ExchCode = 'STU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507263281, ExchCode = 'DEU' WHERE SecCode = 1618200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507477237, ExchCode = 'DEU', PermQuoteRetireDate = '2023-10-09', PermSecMapEndDate = '2023-10-09' WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510896202, ExchCode = 'MUN', PermQuoteRetireDate = '2016-10-25' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510005786, ExchCode = 'FRA' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510053842, Ticker = '3N9', ExchCode = 'DEU', PermQuoteRetireDate = '2022-01-25' WHERE SecCode = 1656381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513064834, Ticker = 'RF2', PermQuoteRetireDate = '2012-11-22', PermSecMapEndDate = '2012-11-08' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511195278, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-25' WHERE SecCode = 1673210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828343336, ExchCode = 'QTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776251703, ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-13' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512394339, ExchCode = 'FRA' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431652, ExchCode = 'FRA' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955323, ExchCode = 'DEU' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515522117, ExchCode = 'DEU' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512769043, ExchCode = 'FRA' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517428536, ExchCode = 'TRQ', PermQuoteRetireDate = '2023-06-22' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811337244, ExchCode = 'STU' WHERE SecCode = 1723207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513144477, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 1735686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517582338, ExchCode = 'STU' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802866853, ExchCode = 'DEU' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195856, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431292, ExchCode = 'FRA' WHERE SecCode = 2213927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644782383, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-02-16' WHERE SecCode = 2222230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569830, ExchCode = 'QTX' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303284, ExchCode = 'TDG' WHERE SecCode = 2267521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525845974, ExchCode = 'TDG' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369453, ExchCode = 'BEC' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779363674, ExchCode = 'FRA' WHERE SecCode = 2379809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531721248, InstrPermID = 8590005814, OrgPermID = 4295915565, ValQuotePermID = 55838797234.0, PriInstrPermID = 8590005814.0, PermInstrStatus = 'DC', Ticker = '56A', ExchCode = 'BER', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2020-09-09' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536966570, ExchCode = 'STU' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538722817, ExchCode = 'STU' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620411353, ExchCode = 'STU' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705370, ExchCode = 'MXQ' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489670, ExchCode = 'QTX' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493842, ExchCode = 'QTX' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298337, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-04' WHERE SecCode = 2465278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780660022, ExchCode = 'TDG' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660442, ExchCode = 'DUS' WHERE SecCode = 2482710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134690, ExchCode = 'DEU' WHERE SecCode = 2513070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907918, ExchCode = 'FRA' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478404, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-24' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585062784, ExchCode = 'SGO' WHERE SecCode = 2539930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540108933, ExchCode = 'DEU' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478415, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731262060, ExchCode = 'BER' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768596, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2573038 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2582956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314867, ExchCode = 'OCE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374749, ExchCode = 'DEU' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548014433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789432566, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548204121, ExchCode = 'FRA' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742655, ExchCode = 'HAN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349288, PermQuoteStatus = 'AC', Ticker = 'VODI', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2682192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137710, ExchCode = 'MUN', PermQuoteRetireDate = '2021-07-05' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384079, ExchCode = 'LAS' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551920812, ExchCode = 'MUN' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552459618, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552380654, InstrPermID = 21550657515, OrgPermID = 5044031864, ValQuotePermID = 21551043677.0, PriInstrPermID = 21550657515.0, PermQuoteStatus = 'DC', Ticker = '3RM0', ExchCode = 'BER', OrgTypeCode = 'CINV', DomCntry = 'GGY', IncCntry = 'GGY', PriTRBCIndPermID = 4294951307.0, PermQuoteRetireDate = '2026-01-01', PermOrgIPODate = '2014-12-02' WHERE SecCode = 2718429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661562372, Ticker = 'SREn', ExchCode = 'BCO' WHERE SecCode = 2718458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552460326, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 2718461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534967, ExchCode = 'MUN' WHERE SecCode = 2718469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554995304, ExchCode = 'STU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322226, ExchCode = 'DEU' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274949, ExchCode = 'GTX' WHERE SecCode = 2855817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603343761, ExchCode = 'TDG' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561797862, ExchCode = 'FRA' WHERE SecCode = 2872657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732998267, Ticker = 'A2PL', ExchCode = 'QTX', PermQuoteRetireDate = '2021-06-09' WHERE SecCode = 2872658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562620362, ExchCode = 'MUN' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619609060, ExchCode = 'MUN' WHERE SecCode = 2887282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563177962, ExchCode = 'FRA' WHERE SecCode = 2887312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865170, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943057400, ExchCode = 'STU' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565633193, ExchCode = 'STU' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687444, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 2912882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890828, PermQuoteStatus = 'AC', Ticker = 'VZLBd', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568560697, ExchCode = 'FRA' WHERE SecCode = 2929653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370461, ExchCode = 'GTX' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2952375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573607460, ExchCode = 'DUS' WHERE SecCode = 2956411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628902471, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3018654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286312, ExchCode = 'GTX' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 3062337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386888, ExchCode = 'LAS' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855827347, ExchCode = 'GER', PermQuoteRetireDate = '2022-03-14', PermSecMapEndDate = '2022-03-14' WHERE SecCode = 3090272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794739726, ExchCode = 'FRA' WHERE SecCode = 3124127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588032923, ExchCode = 'FRA' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-01' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604352845, ExchCode = 'STU' WHERE SecCode = 3283650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793397049, ExchCode = 'FRA' WHERE SecCode = 3283696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419079, ExchCode = 'LAS' WHERE SecCode = 3337707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633333080, ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-02', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 3338477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614671639, ExchCode = 'FRA' WHERE SecCode = 3357942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761306205, ExchCode = 'MUN' WHERE SecCode = 3386777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957123, PermQuoteStatus = 'DC', Ticker = 'C5B', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-19' WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12', PermSecMapEndDate = '2022-10-05' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622941, ExchCode = 'DEU' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835864, Ticker = 'DTSd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381227, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-04' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633327894, ExchCode = 'STU' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3433413 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3435529 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3436907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644789418, Ticker = 'CAS', ExchCode = 'LSE', PermQuoteRetireDate = '2019-03-08' WHERE SecCode = 3446120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380072, ExchCode = 'LAS' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647633189, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3491217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947481, ExchCode = 'FRA' WHERE SecCode = 3526199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762721933, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3535859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166796, ExchCode = 'FRA' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872575770, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3553157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058784, ExchCode = 'DEU' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316444, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099419588, Ticker = '2NFLl', ExchCode = 'BTE' WHERE SecCode = 3669927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918858, ExchCode = 'FRA' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114251, ExchCode = 'FRA' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288603, ExchCode = 'GTX' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272950, ExchCode = 'GTX' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684229246, ExchCode = 'DEU' WHERE SecCode = 3771411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590408, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369830, ExchCode = 'BIV' WHERE SecCode = 3868466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705621141, ExchCode = 'QTX' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3894806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075201, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295405, ExchCode = 'GTX', PermQuoteRetireDate = '2024-10-01', PermSecMapEndDate = '2024-10-01' WHERE SecCode = 3949028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363718, ExchCode = 'MEX' WHERE SecCode = 3966586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363715, ExchCode = 'MEX' WHERE SecCode = 3966587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808198439, ExchCode = 'MUN' WHERE SecCode = 3972240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715682637, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3977923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712308399, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3977926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536123190, ExchCode = 'DEU' WHERE SecCode = 4030457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026845, Ticker = '1GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327741, Ticker = '1BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026937, Ticker = '1SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '3DA' WHERE SecCode = 4036738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301372, ExchCode = 'MUN' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388381, ExchCode = 'LAS' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730198054, Ticker = 'ZWIPE', ExchCode = 'STO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, ExchCode = 'STU' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815144829, ExchCode = 'TDG' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747988879, ExchCode = 'QTX' WHERE SecCode = 4212561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-08' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757456175, ExchCode = 'FRA' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551746655, ExchCode = 'RTB', PermQuoteRetireDate = NULL WHERE SecCode = 4298618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596387, ExchCode = 'MUN' WHERE SecCode = 4324622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766441949, ExchCode = 'STU' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765301520, ExchCode = 'DUS' WHERE SecCode = 4334568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765297153, ExchCode = 'DEU' WHERE SecCode = 4335866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771445002, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, ExchCode = 'MUN' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '2IU2' WHERE SecCode = 4413709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291861, ExchCode = 'BIV' WHERE SecCode = 4485970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '1TH0', PermSecMapEndDate = NULL WHERE SecCode = 4522945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808388561, PermQuoteStatus = 'DC', Ticker = '3K70', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-10' WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140274066, ExchCode = 'BTE' WHERE SecCode = 4563419 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'M96' WHERE SecCode = 4565158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800012350, ExchCode = 'LAS' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387260, PermQuoteStatus = 'DC', Ticker = 'WWT', ExchCode = 'LAS', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, Ticker = '9KK', ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793314093, PermQuoteStatus = 'DC', Ticker = '94Y0', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873118953, Ticker = 'CARBm', ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805163383, ExchCode = 'QTX' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845535652, ExchCode = 'FRA' WHERE SecCode = 4726104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845534968, ExchCode = 'MUN' WHERE SecCode = 4726105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845814031, ExchCode = 'HAM' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856710535, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789996081, ExchCode = 'LAS' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857898826, ExchCode = 'FRA' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043646, ExchCode = 'LAS' WHERE SecCode = 4790646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618957147, ExchCode = 'FRA', PermQuoteRetireDate = '2023-05-12' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000077, ExchCode = 'FRA' WHERE SecCode = 4823658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590398, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536829, ExchCode = 'STU' WHERE SecCode = 4823661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866160214, ExchCode = 'TDG' WHERE SecCode = 4823663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897370, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4823669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727258451, ExchCode = 'MEX' WHERE SecCode = 4827927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873923001, ExchCode = 'DUS' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580216, ExchCode = 'DUS' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419008, ExchCode = 'LAS' WHERE SecCode = 4834795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866892386 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-22' WHERE SecCode = 4854751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884081519, PermQuoteStatus = 'AC', Ticker = 'K9N', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891723924, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689488, ExchCode = 'DEU' WHERE SecCode = 4959597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179871224, Ticker = '2MUE', ExchCode = 'HAM' WHERE SecCode = 4965038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886412706, ExchCode = 'FRA' WHERE SecCode = 4965055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-22' WHERE SecCode = 4969554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 4977778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893285225, ExchCode = 'DUS' WHERE SecCode = 4992085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908059227, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5038681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902954507, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805605436, ExchCode = 'MUN' WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659492, ExchCode = 'LAS' WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 5134669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942349169, ExchCode = 'QTX' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956352320, ExchCode = 'TDG' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380709, ExchCode = 'LAS' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776104211, Ticker = 'ACAG', ExchCode = 'VIE' WHERE SecCode = 5372903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957797642, ExchCode = 'DEU' WHERE SecCode = 5374832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957768163, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07' WHERE SecCode = 5374833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028052111, ExchCode = 'DEU' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727195024, ExchCode = 'BIV' WHERE SecCode = 5381947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777272868, ExchCode = 'MUN' WHERE SecCode = 5402859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223422, ExchCode = 'STU' WHERE SecCode = 5407839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791141195, ExchCode = 'FRA' WHERE SecCode = 5407840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777248728, PermQuoteStatus = 'AC', Ticker = 'T2I1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5407846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21965213442, ExchCode = 'DEU' WHERE SecCode = 5407861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777745401, ExchCode = 'FRA' WHERE SecCode = 5436573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777745402, ExchCode = 'FRA' WHERE SecCode = 5436574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21974979681, ExchCode = 'QTX' WHERE SecCode = 5458313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777944763, Ticker = 'COXE', ExchCode = 'MCE' WHERE SecCode = 5458394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975266861, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778288799, ExchCode = 'FRA' WHERE SecCode = 5466447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299986, ExchCode = 'FRA' WHERE SecCode = 5468673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000148932, DomCntry = NULL, PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = NULL WHERE SecCode = 5516456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471181, ExchCode = 'MEX' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471183, ExchCode = 'BIV' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786101497, ExchCode = 'DEU' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530266, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781013274, ExchCode = 'FRA' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835007, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-22' WHERE SecCode = 5763884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783158225, ExchCode = 'FRA' WHERE SecCode = 5765005 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 5765694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666337, ExchCode = 'CHI' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001789, PermQuoteStatus = 'AC', Ticker = '83W', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799223625, ExchCode = 'TQE' WHERE SecCode = 5959461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22084496535, ExchCode = 'DEU' WHERE SecCode = 6026055 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 6065879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789380440, ExchCode = 'GTX' WHERE SecCode = 6065904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414416, ExchCode = 'STU' WHERE SecCode = 6065905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180991, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180917, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976518, ExchCode = 'SGO' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902796, ExchCode = 'FRA' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293346, ExchCode = 'MUN' WHERE SecCode = 6097356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580161, ExchCode = 'DEU' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892052934, ExchCode = 'DEU' WHERE SecCode = 6097368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089781512, PermQuoteStatus = 'AC', Ticker = 'A4AN9W', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128285, ExchCode = 'BCO' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779005194, PermQuoteStatus = 'AC', Ticker = '5VF', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512196, Ticker = 'NVDEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015578, ExchCode = 'FRA' WHERE SecCode = 6104635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22084430796, ExchCode = 'LAS' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902797, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30', PermSecMapEndDate = '2025-01-30' WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790713136, ExchCode = 'FRA' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790713137, ExchCode = 'FRA' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791039530, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6167090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791600284, ExchCode = 'BIV' WHERE SecCode = 6220139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823991, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173202, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6260557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173713, Ticker = '1TOST', ExchCode = 'MIL' WHERE SecCode = 6263917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105862270, ExchCode = 'GTX' WHERE SecCode = 6286094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105871912, ExchCode = 'DEU' WHERE SecCode = 6286099 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 6305206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740603, ExchCode = 'LAS' WHERE SecCode = 6324151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793538156, ExchCode = 'FRA' WHERE SecCode = 6351553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089866979, Ticker = 'SPUT', ExchCode = 'LSE' WHERE SecCode = 6351665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116192868, Ticker = 'USLF', QuoteClass = 'ETV' WHERE SecCode = 6366675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116187474, ExchCode = 'DEU' WHERE SecCode = 6366680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451435, ExchCode = 'CHI' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158030, ExchCode = 'CHI' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231077, ExchCode = 'BCO' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158021, ExchCode = 'CHI' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703201, ExchCode = 'CHI' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451434, ExchCode = 'CHI' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447621, ExchCode = 'CHI' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158040, ExchCode = 'CHI' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451424, ExchCode = 'CHI' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797169735, ExchCode = 'FRA' WHERE SecCode = 6497501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138965870, ExchCode = 'MUN' WHERE SecCode = 6538893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798464035, ExchCode = 'FRA' WHERE SecCode = 6538897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798464720, ExchCode = 'FRA' WHERE SecCode = 6538898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798745906, ExchCode = 'FRA' WHERE SecCode = 6546195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743822, ExchCode = 'HAM' WHERE SecCode = 6546196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798876397, ExchCode = 'FRA' WHERE SecCode = 6552442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798876385, ExchCode = 'FRA' WHERE SecCode = 6552449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799174470, ExchCode = 'FRA' WHERE SecCode = 6564772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140857331, ExchCode = 'FRA' WHERE SecCode = 6564781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096565, ExchCode = 'FRA' WHERE SecCode = 6590583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955090, ExchCode = 'BIV' WHERE SecCode = 6590630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660438, ExchCode = 'DUS' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541597, ExchCode = 'FRA' WHERE SecCode = 6627152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541595, ExchCode = 'FRA' WHERE SecCode = 6627153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801913112, ExchCode = 'GTX' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802807019, ExchCode = 'MEX' WHERE SecCode = 6664680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803716655, ExchCode = 'FRA' WHERE SecCode = 6694389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239276, ExchCode = 'FRA' WHERE SecCode = 6716119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239275, ExchCode = 'FRA' WHERE SecCode = 6716121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239931, ExchCode = 'FRA' WHERE SecCode = 6716122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239278, ExchCode = 'TDG' WHERE SecCode = 6727870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169227730, ExchCode = 'DEU' WHERE SecCode = 6748858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169220474, ExchCode = 'DEU' WHERE SecCode = 6748859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169220104, ExchCode = 'DEU' WHERE SecCode = 6748860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169220415, ExchCode = 'DEU' WHERE SecCode = 6748861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169227146, ExchCode = 'DEU' WHERE SecCode = 6748862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169220240, ExchCode = 'DEU' WHERE SecCode = 6748866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805997199, ExchCode = 'MEX' WHERE SecCode = 6802699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175714273, ExchCode = 'DEU' WHERE SecCode = 6813221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175714122, ExchCode = 'DEU' WHERE SecCode = 6813222 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6839686 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6849999 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 6880028 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 6887795 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 6908104 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 6911140 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927580 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927581 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927582 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927583 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927584 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927585 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808613401, IsPrimaryQuote = 1, Ticker = 'BOHUS', ExchCode = 'OSL' WHERE SecCode = 6927600 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6927604 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930573 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930574 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930575 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930576 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930577 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930578 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930579 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805390569.0 WHERE SecCode = 6930638 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6930640 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951210.0 WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 10987798 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 11038592 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727397016, Ticker = NULL, PermQuoteRetireDate = '2024-09-18', PermSecMapStartDate = '2018-09-04', PermSecMapEndDate = '2024-09-18' WHERE SecCode = 11052041 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 11129237 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11156631 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11160125 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000156910, PriInstrPermID = 25727305270.0, PermOrgIPODate = '2020-11-06' WHERE SecCode = 11214228 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000156910, PriInstrPermID = 25727305270.0, IsPrimaryInstr = 1, PermOrgIPODate = '2020-11-06' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000148932, DomCntry = NULL, PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = NULL WHERE SecCode = 11234647 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11245873 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11249600 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11250417 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11250418 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727132626, PermQuoteStatus = 'AC', Ticker = 'PMNT', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11262373 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-02-03' WHERE SecCode = 11272673 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-02-03' WHERE SecCode = 11274579 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000156910, PriInstrPermID = 25727305270.0, PermOrgIPODate = '2020-11-06' WHERE SecCode = 11275103 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5086637871, PriInstrPermID = 232883208784.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5086637871, PriInstrPermID = 232883208784.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11281416 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11285686 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289611 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289665 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289666 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289670 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289771 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289778 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289782 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289783 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11289785 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11292235 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293446 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293494 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293499 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293500 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293501 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293544 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293545 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293546 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293547 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293556 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293565 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293567 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293570 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293571 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11293605 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295151 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295152 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11296944 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11297605 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808551982, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297632 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808615202, IsPrimaryQuote = 1, ExchCode = 'TOR' WHERE SecCode = 11297634 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808624030, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297671 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808623911, IsPrimaryQuote = 1, ExchCode = 'NAS' WHERE SecCode = 11297686 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808551822, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297722 AND Type_ = 1;
