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 PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-18' WHERE SecCode = 1677 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 = 21475034761, PermQuoteStatus = 'AC', Ticker = 'ALD', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34314 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 = 55836322896, ExchCode = 'BER', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BHS' WHERE SecCode = 35004 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 35131 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 39884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624203, Ticker = 'SCXG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295342, ExchCode = 'GTX' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 53223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630231241, Ticker = 'STF', ExchCode = 'STU' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325590, ExchCode = 'BER' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 59013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811593365, ExchCode = 'QTX' WHERE SecCode = 59023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836421596, ExchCode = 'FRA', PermQuoteRetireDate = '2009-10-27' WHERE SecCode = 59024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842911827, ExchCode = 'FRA' WHERE SecCode = 59028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238912, ExchCode = 'MUN' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961975860, ExchCode = 'DEU' WHERE SecCode = 59936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492066, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-07' WHERE SecCode = 59963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386338, ExchCode = 'FRA' WHERE SecCode = 60097 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 = 55837358975, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514188341, ExchCode = 'STU' WHERE SecCode = 60537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608399459, ExchCode = 'DEU' WHERE SecCode = 61371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 63996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329646, ExchCode = 'BER' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 69402 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-18' WHERE SecCode = 74544 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 79181 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 79775 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BHS' WHERE SecCode = 87124 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 87641 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 101411 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 104537 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 = 21475775904, ExchCode = 'MUN' WHERE SecCode = 112468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704311, ExchCode = 'MXQ' WHERE SecCode = 125073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390769, ExchCode = 'FRA' WHERE SecCode = 133773 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 146469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679753, ExchCode = 'GER' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951578.0, PermOrgIPODate = '2026-05-17' WHERE SecCode = 243252 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232935764985.0 WHERE SecCode = 243253 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 294085 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-18' WHERE SecCode = 309092 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 325343 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 327979 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 329828 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 332777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806834454, ExchCode = 'FRA' WHERE SecCode = 336756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116848257, ExchCode = 'DEU' WHERE SecCode = 345843 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 DomCntry = 'GGY' WHERE SecCode = 387264 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 387856 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-17' WHERE SecCode = 406383 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 425030 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'FMN' WHERE SecCode = 521651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565562407, ExchCode = 'SGO' WHERE SecCode = 561528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 1109069 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511374004, ExchCode = 'STU' WHERE SecCode = 1480701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 1535750 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 1535765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503429462, ExchCode = 'FRA' WHERE SecCode = 1584599 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 = 21656678108, ExchCode = 'BIV' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538181095, ExchCode = 'STU' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679673, ExchCode = 'BIV' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176932253, ExchCode = 'DEU' WHERE SecCode = 1622873 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 = 21537280920, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-15' WHERE SecCode = 1630461 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 = 21509749786, ExchCode = 'STU' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882713778, ExchCode = 'GTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544218182, Ticker = 'IJPEz', ExchCode = 'BCO' WHERE SecCode = 1652279 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 = 21513064834, Ticker = 'RF2', PermQuoteRetireDate = '2012-11-22', PermSecMapEndDate = '2012-11-08' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511217511, ExchCode = 'STU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511202969, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 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 = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 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 = 236792484745, ExchCode = 'FRA' 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 = 21599860965, ExchCode = 'DEU' WHERE SecCode = 1905111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521747, ExchCode = 'MUN' WHERE SecCode = 1905903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423659, ExchCode = 'DEU' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704166, ExchCode = 'MXQ' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604266609, ExchCode = 'STU' WHERE SecCode = 2021774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815142016, ExchCode = 'MUN' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589937926, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521581559, ExchCode = 'FRA' WHERE SecCode = 2200210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538154, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782890682, ExchCode = 'STU' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478541, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-04-14' 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 = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526080169, ExchCode = 'DEU' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525348690, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 2279777 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2287200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609618572, Ticker = 'GPAB', ExchCode = 'STU', PermQuoteRetireDate = '2018-05-23' WHERE SecCode = 2319580 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 = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 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 Ticker = 'FMN', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890421682, ExchCode = 'STU' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656977, ExchCode = 'GTX' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615450, ExchCode = 'MUN' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847717686, ExchCode = 'GTX' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756688641, ExchCode = 'MUN' WHERE SecCode = 2421101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370397, ExchCode = 'SGO' WHERE SecCode = 2452538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536385132, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2487616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536651649, ExchCode = 'DEU' WHERE SecCode = 2487630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369392, ExchCode = 'BEC' WHERE SecCode = 2515766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625753531, ExchCode = 'CHI', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 2527880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539181649, ExchCode = 'FRA' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103119, ExchCode = 'FRA' WHERE SecCode = 2543647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540098774, ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-12' WHERE SecCode = 2543648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371134, ExchCode = 'BEC' WHERE SecCode = 2545788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708867, ExchCode = 'FRA' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369113, ExchCode = 'SGO' WHERE SecCode = 2625122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673317, ExchCode = 'BIV' WHERE SecCode = 2644179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479008, ExchCode = 'QTX' WHERE SecCode = 2807599 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, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567104630, InstrPermID = 21575328144, OrgPermID = 5093618813, ValQuotePermID = 21575328161.0, PriInstrPermID = 21575328144.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '1AL', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermOrgIPODate = '2015-07-06' WHERE SecCode = 2939990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570455715, ExchCode = 'DEU' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' 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 = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578812986, ExchCode = 'DEU' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582352174, ExchCode = 'FRA' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164689309, ExchCode = 'GTX' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077929, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2026-04-17' WHERE SecCode = 3121290 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 3140639 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 3142227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679805, ExchCode = 'BIV' WHERE SecCode = 3166848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655814, Ticker = '4VOW3', ExchCode = 'ETX' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591798940, ExchCode = 'TDG' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006481, ExchCode = 'DEU' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748078950, ExchCode = 'DEU', PermQuoteRetireDate = '2023-02-17', PermSecMapEndDate = '2023-02-17' WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535194629, Ticker = 'AHOG', ExchCode = 'BRN' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496462, ExchCode = 'DUS' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788491422, Ticker = '0EFd', ExchCode = 'BCO' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100410, ExchCode = 'QTX' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613476472, ExchCode = 'STU' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597702395, ExchCode = 'FRA' WHERE SecCode = 3260047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3276700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196182, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3301805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743775985, ExchCode = 'DEU', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 3309705 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 = 21710324067, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608659181, ExchCode = 'STU' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380068, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443153, ExchCode = 'FRA' WHERE SecCode = 3320334 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 = 21643067252, ExchCode = 'TDG' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549117, ExchCode = 'GTX' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002549, ExchCode = 'FRA' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620409821, ExchCode = 'BCO' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645193083, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-03', PermSecMapEndDate = NULL WHERE SecCode = 3393655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575576966, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704264, ExchCode = 'MXQ' WHERE SecCode = 3403875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779748, ExchCode = 'MUN' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714640544, ExchCode = 'FRA' WHERE SecCode = 3405059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355998, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-31', PermSecMapEndDate = '2024-08-30' WHERE SecCode = 3405438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834674754, PermSecMapStartDate = '2016-09-23', PermSecMapEndDate = '2017-12-08' WHERE SecCode = 3408227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901491943, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 3408973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932188, ExchCode = 'DEU' WHERE SecCode = 3410277 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3431044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380031, ExchCode = 'LAS' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636049771, ExchCode = 'BER', PermQuoteRetireDate = '2018-06-28' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381246, ExchCode = 'LAS' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480054, ExchCode = 'QTX' WHERE SecCode = 3441171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687554, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646838408, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3445749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928541, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181250, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434494, ExchCode = 'LAS' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653848411, Ticker = 'TGL', ExchCode = 'LSE', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485132, Ticker = 'FT5', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 3562840 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 3562846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 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 = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872326, ExchCode = 'DEU' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932243, ExchCode = 'FRA' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727370153, Ticker = 'IMGN', ExchCode = 'MEX' WHERE SecCode = 3864446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778220719, ExchCode = 'TDG' WHERE SecCode = 3906532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755619, ExchCode = 'FRA' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711927625, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 3968255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294452, ExchCode = 'GTX' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359395, ExchCode = 'SIG' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-18' WHERE SecCode = 4056195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858461751, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4197945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422310, ExchCode = 'DEU' WHERE SecCode = 4210918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350455, ExchCode = 'MEX' WHERE SecCode = 4212368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772634388, ExchCode = 'DUS' WHERE SecCode = 4212482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750154407, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 4228115 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 4236130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754377772, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4243768 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 4245389 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 4246331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942187, ExchCode = 'STU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343768, ExchCode = 'BIV' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801716826, ExchCode = 'TDG' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765301520, ExchCode = 'DUS' WHERE SecCode = 4334568 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 4337002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, ExchCode = 'FRA' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294239, ExchCode = 'GTX' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4385253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '8BS' WHERE SecCode = 4417130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803077161, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 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 PermSecMapEndDate = NULL WHERE SecCode = 4443371 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4443375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896842819, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479537, ExchCode = 'DEU' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727419, ExchCode = 'DEU' WHERE SecCode = 4513650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301440, ExchCode = 'MEX' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 4598708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836865415, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4598716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814722256, ExchCode = 'DEU' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153830, ExchCode = 'FRA' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4614771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816901027, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-10' WHERE SecCode = 4620951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456480, Ticker = 'VETH', ExchCode = 'BRN' WHERE SecCode = 4620952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822364738, ExchCode = 'TDG' WHERE SecCode = 4634352 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 4636324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823512132, ExchCode = 'DEU' WHERE SecCode = 4641628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334865, ExchCode = 'FRA' WHERE SecCode = 4643318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848696115, ExchCode = 'GTX' WHERE SecCode = 4658662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244578, ExchCode = 'BIV' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244579, ExchCode = 'MEX' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933374646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2023-01-02' WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954835, ExchCode = 'LAS' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843909546, ExchCode = 'TDG' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853429925, ExchCode = 'MUN' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127841, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4742663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850708573, ExchCode = 'MUN' WHERE SecCode = 4745391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853886915, ExchCode = 'DUS' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 4761548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742239, ExchCode = 'FRA' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307226, ExchCode = 'MEX' WHERE SecCode = 4768117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855838897, ExchCode = 'QTX' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830085, ExchCode = 'QTX' WHERE SecCode = 4775201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633448, ExchCode = 'QTX' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097372, ExchCode = 'LAS' WHERE SecCode = 4786540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705682, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4786544 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4802445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861191996, Ticker = 'CON3', ExchCode = 'LSE' WHERE SecCode = 4806678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380494, ExchCode = 'LAS', PermQuoteRetireDate = '2026-02-12' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799418543, ExchCode = 'SIG' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241331, ExchCode = 'FRA' WHERE SecCode = 4815315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865296250, ExchCode = 'TDG' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4827909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879552085, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4827911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727258451, ExchCode = 'MEX' WHERE SecCode = 4827927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865902197, ExchCode = 'FRA' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866892386 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398427, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783262067, ExchCode = 'FRA' WHERE SecCode = 4846846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783783667, ExchCode = 'QTX' WHERE SecCode = 4852142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144452985, ExchCode = 'LAS' WHERE SecCode = 4854866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 4882385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656954, ExchCode = 'FRA' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959379953, ExchCode = 'TDG' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21926264784, PermQuoteStatus = 'DC', Ticker = 'V6M', ExchCode = 'DEU', PermQuoteRetireDate = '2022-11-07' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 5041685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910867434, ExchCode = 'STU' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615655, ExchCode = 'STU' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347143, ExchCode = 'MEX' WHERE SecCode = 5161305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344850, ExchCode = 'MEX' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5176773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227057, ExchCode = 'BIV' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794004180, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727192009, ExchCode = 'MEX' WHERE SecCode = 5251003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222348, ExchCode = 'MEX' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937069015, ExchCode = 'STU' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 5281331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943067733, ExchCode = 'FRA' WHERE SecCode = 5301896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077356, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08', PermSecMapEndDate = NULL WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908505, PermQuoteStatus = 'DC', Ticker = '3QP0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5353917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5359418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874420, ExchCode = 'GTX' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202568, ExchCode = 'MEX' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942209, ExchCode = 'STU' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21967957484, ExchCode = 'DEU' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416291, ExchCode = 'FRA' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729656, ExchCode = 'DEU' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091546, Ticker = 'BTCCHz', ExchCode = 'TQE' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5516472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309034, ExchCode = 'MUN' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 5563558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151033, PermQuoteStatus = 'AC', Ticker = '3FNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771506, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682766, Ticker = '2HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653830, ExchCode = 'FRA' WHERE SecCode = 5731414 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783112206, ExchCode = 'STU' WHERE SecCode = 5764020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783674147, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5803178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22042870510, ExchCode = 'DEU' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236560, ExchCode = 'STU' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236496, ExchCode = 'FRA' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784326338, ExchCode = 'STU' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327232, ExchCode = 'FRA' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357764, ExchCode = 'MEX' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786957975, ExchCode = 'MUN' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386725, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-25', PermSecMapEndDate = '2025-04-25' WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22058332105, ExchCode = 'DEU' WHERE SecCode = 5914176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784960655, ExchCode = 'BIV' WHERE SecCode = 5917759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666337, ExchCode = 'CHI' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061495886, ExchCode = 'GTX' WHERE SecCode = 5920851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786490279, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 5931956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788145983, Ticker = '7YGd', ExchCode = 'BCO' WHERE SecCode = 5949087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448736, ExchCode = 'TDG' WHERE SecCode = 5969012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788075088, ExchCode = 'FRA' WHERE SecCode = 5978470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787589834, ExchCode = 'MUN' WHERE SecCode = 5978474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071312228, ExchCode = 'DEU' WHERE SecCode = 6001792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386190, ExchCode = 'TDG' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782564342, ExchCode = 'BIV' WHERE SecCode = 6032854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759413, ExchCode = 'STU' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788962501, Ticker = '1HUT', ExchCode = 'MIL' WHERE SecCode = 6047903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789141811, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6050973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110995, Ticker = 'BITCl', ExchCode = 'BTE' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110997, Ticker = 'BITPl', ExchCode = 'BTE' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110948, Ticker = '3GFMm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 6097282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151005, Ticker = 'FTNE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110935, Ticker = 'FTNGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-01' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421365, PermQuoteStatus = 'AC', Ticker = '3LNFm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663696, PermQuoteStatus = 'AC', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22030766405, ExchCode = 'CHI' WHERE SecCode = 6097336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151127, Ticker = '3SUE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380561, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942692, ExchCode = 'STU' WHERE SecCode = 6151861 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 = 236782181395, ExchCode = 'MEX' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811034765, ExchCode = 'MXQ' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071047025, ExchCode = 'DEU' WHERE SecCode = 6256447 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 6264073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792270095, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'RET' WHERE SecCode = 6269030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269534, ExchCode = 'FRA' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788319, ExchCode = 'MEX' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803099318, ExchCode = 'STU' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794499501, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 6347434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794002816, ExchCode = 'BCO' WHERE SecCode = 6361844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745448, ExchCode = 'BIV' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794739725, ExchCode = 'FRA' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795166766, ExchCode = 'TDG' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788837447, ExchCode = 'BIV' WHERE SecCode = 6448789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695821, ExchCode = 'MUN' WHERE SecCode = 6451070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128134015, ExchCode = 'DUS' WHERE SecCode = 6457998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142175791, ExchCode = 'DEU' WHERE SecCode = 6564772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141221366, ExchCode = 'DUS' WHERE SecCode = 6564781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142175888, ExchCode = 'DEU' WHERE SecCode = 6564784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379501, Ticker = 'KOG', ExchCode = 'BRN' WHERE SecCode = 6578370 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 6578424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800709238, ExchCode = 'QTX' WHERE SecCode = 6596130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660438, ExchCode = 'DUS' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803478723, ExchCode = 'DUS' WHERE SecCode = 6686044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804998607, ExchCode = 'QTX' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805530357, ExchCode = 'MUN' WHERE SecCode = 6737927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168605391, ExchCode = 'DEU' WHERE SecCode = 6737928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095498, ExchCode = 'DUS' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237572, ExchCode = 'FRA' WHERE SecCode = 6756501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237865, ExchCode = 'FRA' WHERE SecCode = 6756502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901582, ExchCode = 'BTE' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 6796824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168116, ExchCode = 'FRA' WHERE SecCode = 6802859 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951907.0 WHERE SecCode = 6806345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22180069245, ExchCode = 'QTX' WHERE SecCode = 6808918 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-17' WHERE SecCode = 6809149 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 6826515 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 6826558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806769135, ExchCode = 'FRA' WHERE SecCode = 6836184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806769207, ExchCode = 'FRA' WHERE SecCode = 6836185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806951232, ExchCode = 'MEX' WHERE SecCode = 6843275 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 10897981 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 10973798 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11030383 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 11076755 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-16' WHERE SecCode = 11108815 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11159001 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236807111662, ExchCode = 'NAS', PermSecMapStartDate = '2026-05-15' WHERE SecCode = 11163329 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11165504 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951502.0 WHERE SecCode = 11188015 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727393933, PermQuoteStatus = 'AC', Ticker = 'RVPH', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11191215 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11198689 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 11200314 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2021-03-30', PermSecMapEndDate = '2021-06-01' WHERE SecCode = 11221896 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'ISR' WHERE SecCode = 11222088 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11233976 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11236616 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11238736 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11240840 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11241882 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11251612 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727167715, PermQuoteStatus = 'AC', Ticker = 'ALCUF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11252685 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727153242, PermQuoteStatus = 'AC', Ticker = 'ALCYF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11254323 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11279854 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-16' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288034 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288035 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288036 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288037 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288047 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293016 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293017 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293018 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293019 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293020 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293021 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293022 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293023 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293024 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293025 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293026 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293027 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293028 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293029 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293030 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293031 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293032 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293033 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293034 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293035 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293036 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293037 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293038 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293039 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293040 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293041 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293042 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293043 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293044 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293045 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293046 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-18' WHERE SecCode = 11294579 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 47766310878, ExchCode = 'NYS', PermSecMapStartDate = '2026-05-15' WHERE SecCode = 11295357 AND Type_ = 1;
