UPDATE data_universe_permid SET QuotePermID = 21475442988, Ticker = NULL, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836040732, ValQuotePermID = 55836040732.0, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', Ticker = '91ID', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 10347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 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 = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334267, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-17' WHERE SecCode = 38580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475608783, ExchCode = 'GER', PermQuoteRetireDate = '2010-03-05' WHERE SecCode = 38608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331050, ExchCode = 'BER' WHERE SecCode = 38610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474870281, ExchCode = 'DEU' WHERE SecCode = 41385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475575870, Ticker = 'MACO.I', ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607810, ExchCode = 'GTX' WHERE SecCode = 53597 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 = 21478545911, Ticker = 'CTV', ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 55766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483123, ExchCode = 'QTX' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243527, ExchCode = 'MUN', PermQuoteRetireDate = '2008-10-06' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783641141, ExchCode = 'MUN' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474986024, ExchCode = 'DEU' WHERE SecCode = 64559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524268066, ExchCode = 'STU' WHERE SecCode = 64572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475349368, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-04' WHERE SecCode = 64581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036172, ExchCode = 'TDG' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475610158, Ticker = 'SPJG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64845 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CCAP' WHERE SecCode = 65128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839332944, PermQuoteStatus = 'AC', Ticker = 'SNBRQ', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2000-01-08', PermSecMapEndDate = NULL WHERE SecCode = 69064 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 74539 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835413367, ExchCode = 'PNK', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 89496 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 94266 AND Type_ = 1;
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 Ticker = 'AIMAX' WHERE SecCode = 112408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799606984, ExchCode = 'TDG' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 114528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920950402, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 114717 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 115380 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', IncCntry = 'CHE' WHERE SecCode = 120984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262929, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 128769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957798876, ExchCode = 'DEU' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 145432 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 = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294096, ExchCode = 'GTX' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536548828, ExchCode = 'FRA' WHERE SecCode = 186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381654, ExchCode = 'LAS' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650270, ExchCode = 'DUS' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672400458, Ticker = 'SEL', ExchCode = 'MIL' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652662, ExchCode = 'MUN', PermQuoteRetireDate = '2020-12-23' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 309272 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SWQGF' WHERE SecCode = 323567 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21629379954, PermSecMapStartDate = '2017-12-08', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 334454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533840381, ExchCode = 'MUN', PermQuoteRetireDate = '2019-06-04' WHERE SecCode = 334537 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 368238 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21629380009, Ticker = '0N16', ExchCode = 'LSE', PermQuoteRetireDate = '2026-06-25', PermSecMapStartDate = '2017-12-08', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 368624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181310583, Ticker = 'XAXJl', ExchCode = 'OCU' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150825819, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 549287 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 946145 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 948166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504490118, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-02' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 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 = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176932253, ExchCode = 'DEU' WHERE SecCode = 1622873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535814698, Ticker = 'BMZ.GB', ExchCode = 'ISD', PermQuoteRetireDate = '2015-04-20' WHERE SecCode = 1635481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822238, ExchCode = 'DEU' WHERE SecCode = 1655502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513064834, Ticker = 'RF2', PermQuoteRetireDate = '2012-11-22', PermSecMapEndDate = '2012-11-08' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811337244, ExchCode = 'STU' WHERE SecCode = 1723207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' 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 = 21625195856, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644523837, ExchCode = 'STU' WHERE SecCode = 2195754 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 = 21532444506, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 2221995 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 = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525274948, ExchCode = 'FRA' WHERE SecCode = 2278225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525339865, ExchCode = 'DEU' WHERE SecCode = 2278227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525273252, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2278243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525927737, ExchCode = 'FRA' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609618572, Ticker = 'GPAB', ExchCode = 'STU', PermQuoteRetireDate = '2018-05-23' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433951, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '22S1' WHERE SecCode = 2333013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670892655, ExchCode = 'QTX' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520237, ExchCode = 'QTX' WHERE SecCode = 2339259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530098344, ExchCode = 'FRA' WHERE SecCode = 2362509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780887285, ExchCode = 'CHI' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419067, ExchCode = 'LAS' WHERE SecCode = 2377960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531377278, ExchCode = 'FRA' WHERE SecCode = 2381665 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 = 21531848797, ExchCode = 'FRA' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921479660, ExchCode = 'GTX' WHERE SecCode = 2391353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615450, ExchCode = 'MUN' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336720, ExchCode = 'FRA' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169500042, ExchCode = 'DEU' WHERE SecCode = 2402414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847717686, ExchCode = 'GTX' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527246, ExchCode = 'FRA' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534457668, ExchCode = 'FRA' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443169, ExchCode = 'TDG' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724351602, ExchCode = 'QTX' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451292, Ticker = 'MER', ExchCode = 'SWX' WHERE SecCode = 2465112 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 = 21907546243, ExchCode = 'MUN' WHERE SecCode = 2470092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538229, ExchCode = 'GTX' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800269665, ExchCode = 'FRA' WHERE SecCode = 2482710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536675650, ExchCode = 'STU' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536674787, ExchCode = 'STU' WHERE SecCode = 2487654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537024389, ExchCode = 'DEU' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786358, ExchCode = 'BTE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720364225, ExchCode = 'TDG' WHERE SecCode = 2515711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538118516, ExchCode = 'DEU' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108940988, ExchCode = 'DEU' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848757217, ExchCode = 'QTX', PermQuoteRetireDate = '2023-01-17', PermSecMapEndDate = NULL WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390630, ExchCode = 'DEU' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539181248, ExchCode = 'FRA' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539859456, ExchCode = 'DEU' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909440, ExchCode = 'DEU' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585062789, ExchCode = 'BEC' WHERE SecCode = 2539930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430828, ExchCode = 'DEU' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230438, ExchCode = 'FRA' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684125, ExchCode = 'STU' WHERE SecCode = 2545058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378729, ExchCode = 'GTX' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562942131, ExchCode = 'TDG' WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890729, ExchCode = 'DEU' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534569059, ExchCode = 'FRA', PermQuoteRetireDate = '2023-03-06' WHERE SecCode = 2557503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368221, ExchCode = 'FRA' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542602134, ExchCode = 'DEU' WHERE SecCode = 2572311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679709, ExchCode = 'BIV' WHERE SecCode = 2572313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679650, ExchCode = 'BIV' WHERE SecCode = 2572314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679316, ExchCode = 'BIV' WHERE SecCode = 2572315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673451, ExchCode = 'BIV' WHERE SecCode = 2572318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679345, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2572322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768595, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2573038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543010837, ExchCode = 'BER', PermQuoteRetireDate = '2023-03-30' WHERE SecCode = 2578880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986686943, ExchCode = 'DEU' WHERE SecCode = 2578881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543010984, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430409, ExchCode = 'DEU' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708914, ExchCode = 'DEU' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708867, ExchCode = 'FRA' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726151, ExchCode = 'DEU' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662105437, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545617420, ExchCode = 'DEU' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616206318, ExchCode = 'STU' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662661878, ExchCode = 'MUN' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722349014, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547157215, ExchCode = 'DEU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547359827, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 2636990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548012753, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548037377, ExchCode = 'DEU', PermQuoteRetireDate = '2020-11-12' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548030533, ExchCode = 'DEU' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548030535, ExchCode = 'DEU' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359766, ExchCode = 'STU' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561270622, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-12' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184279, ExchCode = 'MUN' WHERE SecCode = 2644157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414445, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548207169, ExchCode = 'DEU' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830304824, ExchCode = 'GTX', PermQuoteRetireDate = '2025-05-02' WHERE SecCode = 2644169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587934135, ExchCode = 'FRA' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548686714, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-30' WHERE SecCode = 2650642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589498059, ExchCode = 'TDG' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549921078, ExchCode = 'BTE' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379555, Ticker = 'HCL', ExchCode = 'BRN' WHERE SecCode = 2682233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550835484, ExchCode = 'STU' WHERE SecCode = 2682326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551131018, ExchCode = 'DEU', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688016595, ExchCode = 'STU' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551131019, ExchCode = 'DEU' WHERE SecCode = 2698369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551797405, Ticker = 'CBKDe', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2706343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552463360, ExchCode = 'FRA' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606359247, ExchCode = 'MUN' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704488, ExchCode = 'MXQ' WHERE SecCode = 2747774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479008, ExchCode = 'QTX' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322234, Ticker = 'IDV1', ExchCode = 'FRA' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322223, ExchCode = 'FRA' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558477129, ExchCode = 'DEU' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155460, ExchCode = 'DEU' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623088, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560442240, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2849907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374532, ExchCode = 'FRA' WHERE SecCode = 2849922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599521455, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961571, ExchCode = 'BER', PermQuoteRetireDate = '2021-02-23' WHERE SecCode = 2870126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 2898744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864729, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483136, PermQuoteStatus = 'DC', Ticker = 'CM3', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654537658, ExchCode = 'MUN', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564933180, ExchCode = 'MUN' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823342, ExchCode = 'GTX' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605132678, ExchCode = 'STU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540992047, ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-24', PermSecMapEndDate = '2019-05-24' WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783066619, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706327513, ExchCode = 'TDG' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520298, ExchCode = 'QTX' WHERE SecCode = 3038439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496462, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595110980, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 3235105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597328149, ExchCode = 'MUN' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621641, ExchCode = 'DEU' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647013837, ExchCode = 'BCO' WHERE SecCode = 3275560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383457, ExchCode = 'FRA' WHERE SecCode = 3285135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632738581, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-27' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705487, ExchCode = 'STU' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551901, ExchCode = 'TDG' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645775, ExchCode = 'FRA' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627369817, ExchCode = 'BCO' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616067428, PermQuoteStatus = 'AC', Ticker = '90S0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743475404, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3378582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761306157, ExchCode = 'FRA' WHERE SecCode = 3386777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378638, ExchCode = 'BRN' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908261084, Ticker = '1FBm', ExchCode = 'EQD' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704915, ExchCode = 'MXQ' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469772, ExchCode = 'DEU' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228480, ExchCode = 'FRA' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380142, PermQuoteStatus = 'AC', Ticker = 'DV4', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622936, ExchCode = 'FRA' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628602986, Ticker = 'DTS', ExchCode = 'MUN', PermQuoteRetireDate = '2020-10-02' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630755583, ExchCode = 'STU', PermQuoteRetireDate = '2020-02-25' WHERE SecCode = 3408843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633327894, ExchCode = 'STU' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802788, Ticker = 'PU9D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 3429985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356606, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2020-04-21' WHERE SecCode = 3435592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640560144, ExchCode = 'DEU' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 3445080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645825, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-01', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590215, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3535859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21994180608, ExchCode = 'BTE' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953637183, ExchCode = 'STU' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786107959, ExchCode = 'FRA' WHERE SecCode = 3578207 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 = 21656673891, ExchCode = 'BIV' WHERE SecCode = 3604834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671049443, PermQuoteStatus = 'AC', Ticker = '1SS', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3663204 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 = 21675373923, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220426, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684229246, ExchCode = 'DEU' WHERE SecCode = 3771411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744254204, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694479665, ExchCode = 'TDG' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368561, ExchCode = 'MEX' WHERE SecCode = 3890289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' 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 = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371471, ExchCode = 'BIV' WHERE SecCode = 3913216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584837232, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710752190, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07', PermSecMapEndDate = NULL WHERE SecCode = 3949028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727293094, PermQuoteStatus = 'AC', ExchCode = 'MEX', PermQuoteRetireDate = NULL WHERE SecCode = 3952658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363709, ExchCode = 'BIV' WHERE SecCode = 3966586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363706, ExchCode = 'BIV' WHERE SecCode = 3966587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714765661, ExchCode = 'STU' WHERE SecCode = 3972240 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 3977925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21721187938, PermQuoteStatus = 'DC', Ticker = '0XM0', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4007107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377499, ExchCode = 'MEX' WHERE SecCode = 4022727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T', ExchCode = 'MIL' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011956, Ticker = '2GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC', ExchCode = 'MIL' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA', ExchCode = 'MIL' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682767, Ticker = '2BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044966173, Ticker = '2BOD', ExchCode = 'MIL' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011957, Ticker = '2COST' WHERE SecCode = 4031830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER', ExchCode = 'MIL' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999014017, Ticker = '2WBDA' WHERE SecCode = 4031843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ', ExchCode = 'MIL' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026782, Ticker = '1FRA' WHERE SecCode = 4031875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026737, Ticker = '1KHC' WHERE SecCode = 4031921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001531, Ticker = '1RDC', ExchCode = 'MIL' WHERE SecCode = 4031987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042587, Ticker = '2SHA', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013792, Ticker = '2SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011427, Ticker = '2VAR' WHERE SecCode = 4032036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011345, Ticker = '2WAF' WHERE SecCode = 4032047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011451, Ticker = '2WCH' WHERE SecCode = 4032048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013994, Ticker = '2CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026958, Ticker = '1BYND' WHERE SecCode = 4032087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571646335, ExchCode = 'BEC' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634821003, Ticker = 'OCPETb', ExchCode = 'BCO', PermQuoteRetireDate = '2024-01-31' WHERE SecCode = 4046600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128315297, ExchCode = 'DEU' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041763, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369676, ExchCode = 'BIV' WHERE SecCode = 4054118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412273, ExchCode = 'DEU' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412250, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-03', PermSecMapEndDate = '2025-09-03' WHERE SecCode = 4062000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460845, ExchCode = 'FRA' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995390, ExchCode = 'DEU' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776435514, Ticker = 'ZWIPEs', ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-21' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766464069, Ticker = '49Y', ExchCode = 'FRA', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778719260, PermQuoteStatus = 'DC', Ticker = '0XJ', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-17' WHERE SecCode = 4194828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958505, ExchCode = 'FRA' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772634388, ExchCode = 'DUS' WHERE SecCode = 4212482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752247650, ExchCode = 'FRA' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200308, ExchCode = 'DEU' WHERE SecCode = 4253037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679461, ExchCode = 'BIV' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679349994, ExchCode = 'BIV' WHERE SecCode = 4302371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027131, Ticker = '1SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761325018, Ticker = '4TKWY', ExchCode = 'ETX' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026769, Ticker = '1AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026756, Ticker = '1NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324941, Ticker = '4RMS', ExchCode = 'ETX' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324824, Ticker = '4ASM', ExchCode = 'ETX' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026753, Ticker = '1FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761647098, ExchCode = 'DUS' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342160, ExchCode = 'MEX' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690939, ExchCode = 'BTE' WHERE SecCode = 4315108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803438809, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709366460, ExchCode = 'BIV' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 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 = 21764112353, ExchCode = 'FRA' WHERE SecCode = 4324622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966496, ExchCode = 'DEU' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766378279, ExchCode = 'QTX' WHERE SecCode = 4333278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770110648, ExchCode = 'MXQ' WHERE SecCode = 4362644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380457, ExchCode = 'LAS' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782605835, ExchCode = 'QTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774613209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870599, ExchCode = 'FRA' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909432, ExchCode = 'FRA' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531963, ExchCode = 'GTX' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370420, ExchCode = 'AQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 4426889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785454242, ExchCode = 'STU' WHERE SecCode = 4434247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787491381, ExchCode = 'BER', PermQuoteRetireDate = '2021-01-05' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787035686, ExchCode = 'FRA' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817233574, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4449683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801282977, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4487598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817595, ExchCode = 'DEU' WHERE SecCode = 4487625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809367, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808984243, ExchCode = 'SEP' WHERE SecCode = 4566923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 4598801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814722256, ExchCode = 'DEU' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263610, ExchCode = 'BIV' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818128449, PermQuoteStatus = 'AC', Ticker = 'WWT0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4629496 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 = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 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, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, ExchCode = 'MUN' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954880, ExchCode = 'LAS', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727245113, ExchCode = 'BIV' WHERE SecCode = 4695826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579647, ExchCode = 'MUN' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954884, ExchCode = 'LAS' WHERE SecCode = 4726104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782726100, ExchCode = 'STU' WHERE SecCode = 4726105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' 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 = 21851867538, ExchCode = 'FRA' WHERE SecCode = 4752212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098679, ExchCode = 'FRA' WHERE SecCode = 4753666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546343, ExchCode = 'GTX' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907559014, ExchCode = 'MUN', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860858404, ExchCode = 'DEU' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861142851, ExchCode = 'DEU' WHERE SecCode = 4829216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792865451, ExchCode = 'MUN' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778036716, ExchCode = 'MUN' WHERE SecCode = 4862983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806835525, ExchCode = 'LAS' WHERE SecCode = 4940671 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 = 21913716262, ExchCode = 'FRA' WHERE SecCode = 4960863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889564320, ExchCode = 'STU' WHERE SecCode = 4960864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727205509, ExchCode = 'BIV' WHERE SecCode = 4962789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179871224, Ticker = '2MUE', ExchCode = 'HAM' WHERE SecCode = 4965038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 4975833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097175, ExchCode = 'LAS' WHERE SecCode = 5011695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'WTWN', PermQuoteRetireDate = NULL WHERE SecCode = 5117007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797935268, ExchCode = 'MUN' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942737484, ExchCode = 'STU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5161263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305815, ExchCode = 'BIV' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850513498, ExchCode = 'FRA' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650379, ExchCode = 'QTX' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198685, PermQuoteStatus = 'AC', ExchCode = 'BIV', PermQuoteRetireDate = NULL WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930806960, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' 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 = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832311, ExchCode = 'STU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849037685, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 5430827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667447, ExchCode = 'STU', PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 5436573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667355, ExchCode = 'STU' WHERE SecCode = 5436574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348315, ExchCode = 'QTX' WHERE SecCode = 5466221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380732, ExchCode = 'LAS' WHERE SecCode = 5466447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980729136, ExchCode = 'MXQ' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 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 QuotePermID = 21993262022, ExchCode = 'BER' WHERE SecCode = 5533517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566092, ExchCode = 'GER' WHERE SecCode = 5533518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993262024, ExchCode = 'BER', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 5533519 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 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 = 236784381500, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21992652034, ExchCode = 'DEU' WHERE SecCode = 5553225 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 = 21992894800, ExchCode = 'DEU' WHERE SecCode = 5553229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779626777, ExchCode = 'FRA' WHERE SecCode = 5553509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864463, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566250, ExchCode = 'GER' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982665105, ExchCode = 'MXQ' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522671160, PermQuoteStatus = 'AC', Ticker = 'YE20', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659489, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360205, ExchCode = 'BIV' WHERE SecCode = 5581641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585131, ExchCode = 'BIV' WHERE SecCode = 5582137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780408528, ExchCode = 'FRA' WHERE SecCode = 5603347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212166, ExchCode = 'BIV' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780978843, ExchCode = 'FRA' WHERE SecCode = 5620203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781013274, ExchCode = 'FRA' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830325, ExchCode = 'GER', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830322, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778712188, ExchCode = 'BIV' WHERE SecCode = 5644662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778500351, ExchCode = 'MEX' WHERE SecCode = 5671941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866504754, ExchCode = 'UAX' WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22026840053, ExchCode = 'STU' WHERE SecCode = 5703208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851321, ExchCode = 'LAS' WHERE SecCode = 5706779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890988, ExchCode = 'DEU' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032141800, ExchCode = 'DEU' WHERE SecCode = 5745661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032141718, ExchCode = 'DEU' WHERE SecCode = 5745662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032147629, ExchCode = 'DEU' WHERE SecCode = 5745663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994255, ExchCode = 'STU' WHERE SecCode = 5745664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22035457659, ExchCode = 'DEU' WHERE SecCode = 5765005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787198171, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264814, ExchCode = 'FRA' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044538463, ExchCode = 'DEU' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784419514, ExchCode = 'STU' WHERE SecCode = 5827173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21967216830, Ticker = 'CO3S', ExchCode = 'LSE' WHERE SecCode = 5839249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784890672, ExchCode = 'FRA' WHERE SecCode = 5857780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790682427, PermQuoteStatus = 'DC', Ticker = '83W0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5996667 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 PermQuoteStatus = 'AC', Ticker = 'FNF*', PermQuoteRetireDate = NULL WHERE SecCode = 6024138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789803299, ExchCode = 'TDG' WHERE SecCode = 6078492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171969, ExchCode = 'MEX' WHERE SecCode = 6097384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536624, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917827739, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086925583, ExchCode = 'MUN' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 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 = 21811034765, ExchCode = 'MXQ' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917827971, ExchCode = 'FRA' WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793449671, ExchCode = 'QTX' WHERE SecCode = 6329880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793578955, ExchCode = 'TDG' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745448, ExchCode = 'BIV' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866541, ExchCode = 'MEX' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934516, ExchCode = 'DUS' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130904343, ExchCode = 'GTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798271089, Ticker = 'S0N', ExchCode = 'QTX' WHERE SecCode = 6503395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256274, ExchCode = 'MEX' WHERE SecCode = 6524571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798383432, ExchCode = 'TDG' WHERE SecCode = 6533454 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 6541020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798598104, Ticker = 'X1Y1', ExchCode = 'FRA' WHERE SecCode = 6543873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794669390, ExchCode = 'MEX' WHERE SecCode = 6543895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743592, ExchCode = 'DUS' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799606980, ExchCode = 'TDG' WHERE SecCode = 6575446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238848, ExchCode = 'QTX' WHERE SecCode = 6593876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800566531, ExchCode = 'TDG' WHERE SecCode = 6593880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800566528, ExchCode = 'TDG' WHERE SecCode = 6593881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145988926, ExchCode = 'DEU' WHERE SecCode = 6593883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145984972, ExchCode = 'DEU' WHERE SecCode = 6593884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145984745, ExchCode = 'DEU' WHERE SecCode = 6593886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800658723, ExchCode = 'QTX' WHERE SecCode = 6593887 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 = 22134134351, ExchCode = 'STU' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801913112, ExchCode = 'GTX' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802136610, ExchCode = 'FRA' WHERE SecCode = 6629415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471092, ExchCode = 'FRA' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191253, ExchCode = 'BEC' WHERE SecCode = 6678589 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 = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901582, ExchCode = 'BTE' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705305, ExchCode = 'FRA' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524855, ExchCode = 'DEU' WHERE SecCode = 6808918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807618793, ExchCode = 'FRA' WHERE SecCode = 6882167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807639516, ExchCode = 'FRA' WHERE SecCode = 6882170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807668649, ExchCode = 'FRA' WHERE SecCode = 6882173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807668651, ExchCode = 'FRA' WHERE SecCode = 6882174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807668646, ExchCode = 'FRA' WHERE SecCode = 6882175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183962702, ExchCode = 'DEU' WHERE SecCode = 6890826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183970148, ExchCode = 'DEU' WHERE SecCode = 6890827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808391493, ExchCode = 'TDG' WHERE SecCode = 6890828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929724954, ExchCode = 'SGO' WHERE SecCode = 6890830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183954222, ExchCode = 'DEU' WHERE SecCode = 6893691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807886145, ExchCode = 'MEX' WHERE SecCode = 6893698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807978130, ExchCode = 'FRA' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6917394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22186460513, ExchCode = 'DEU' WHERE SecCode = 6917417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22186459587, ExchCode = 'DEU' WHERE SecCode = 6917418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22186465067, ExchCode = 'DEU' WHERE SecCode = 6917419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185584083, ExchCode = 'DEU' WHERE SecCode = 6917506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808548194, ExchCode = 'FRA' WHERE SecCode = 6923752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808548190, ExchCode = 'FRA' WHERE SecCode = 6923754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808548193, ExchCode = 'FRA' WHERE SecCode = 6923755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188304142, ExchCode = 'DEU' WHERE SecCode = 6934870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808829663, IsPrimaryQuote = 1, ExchCode = 'ASX' WHERE SecCode = 6937641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791346396, ExchCode = 'FRA' WHERE SecCode = 6937664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188728056, ExchCode = 'DEU' WHERE SecCode = 6937686 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6939101 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236808846115.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1 WHERE SecCode = 6939104 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6939105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808846419, Ticker = '544798', ExchCode = 'BSE', PermSecMapStartDate = '2026-06-24' WHERE SecCode = 6939106 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ASKED' WHERE SecCode = 10923507 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-24', PermSecMapEndDate = NULL WHERE SecCode = 11056230 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11146599 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SMWE' WHERE SecCode = 11178978 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 11228127 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 11230564 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 11234124 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 11234979 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727214610, PriTrdQuotePermID = NULL, PermQuoteStatus = 'AC', Ticker = 'DEVSF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2021-12-17' WHERE SecCode = 11235980 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'USDE', ExchCode = 'NAQ' WHERE SecCode = 11237342 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 11250503 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727137349, PriTrdQuotePermID = NULL, PermQuoteStatus = 'AC', Ticker = 'ORISF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11270668 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-24', PermSecMapEndDate = NULL WHERE SecCode = 11278633 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285817 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285818 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285833 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285841 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727053853, PriTrdQuotePermID = NULL, PermQuoteStatus = 'AC', Ticker = 'TCGLF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11286891 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11289678 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11289943 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11289944 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11289946 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808830362, IsPrimaryQuote = 1, ExchCode = 'TOR' WHERE SecCode = 11298170 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808831306, IsPrimaryQuote = 1, ExchCode = 'CVE' WHERE SecCode = 11298186 AND Type_ = 1;
