UPDATE data_universe_permid SET QuotePermID = 21474988450, PermQuoteStatus = 'AC', Ticker = '0M6S', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807338493, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'OCU', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 2430 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 19793 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 27270 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 31557 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30', PermSecMapEndDate = '2017-07-07' WHERE SecCode = 31850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 33894 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 35168 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 35958 AND Type_ = 1;
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 = 55836523767, ExchCode = 'FRA' WHERE SecCode = 41385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324683, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 45854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838652164, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-16' WHERE SecCode = 46294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792268563, PermQuoteStatus = 'AC', Ticker = 'GVM0', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 46388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474843390, ExchCode = 'DEU' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-29' WHERE SecCode = 49597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838424865, ExchCode = 'STU' WHERE SecCode = 53110 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 55839 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 57487 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836516282, ExchCode = 'FRA' WHERE SecCode = 60537 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 60886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348427, ExchCode = 'FRA' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018990, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-16', PermSecMapEndDate = '2023-08-16' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036172, ExchCode = 'TDG' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 69492 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 74536 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 76126 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 76185 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 78569 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-28' WHERE SecCode = 82584 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 86568 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 88471 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 88472 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-28' WHERE SecCode = 91476 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-28' WHERE SecCode = 93811 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2011-01-10' WHERE SecCode = 94266 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-28' WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 97007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799606984, ExchCode = 'TDG' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183753, ExchCode = 'MXQ' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 116129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807026221, ExchCode = 'FRA' WHERE SecCode = 119132 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000100330, DomCntry = NULL, IncCntry = 'CHE' WHERE SecCode = 120481 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000100288, DomCntry = NULL, IncCntry = 'CHE' WHERE SecCode = 120501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22189532373, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-26', PermSecMapEndDate = NULL WHERE SecCode = 138233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448701, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-08', PermSecMapEndDate = NULL WHERE SecCode = 138259 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 141830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550078982, ExchCode = 'HAM' WHERE SecCode = 141913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330236, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 141914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794246882, ExchCode = 'FRA' WHERE SecCode = 142321 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 142346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484203, ExchCode = 'QTX' WHERE SecCode = 142347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572615818, ExchCode = 'FRA' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 142476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858138027, ExchCode = 'GER', PermQuoteRetireDate = '2009-04-06' WHERE SecCode = 142609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333633, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 142617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817036561, ExchCode = 'TDG' WHERE SecCode = 142650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885909284, ExchCode = 'STU' WHERE SecCode = 142718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332511, PermQuoteStatus = 'DC', Ticker = 'P6U1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 142826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364732, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 143131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335753, ExchCode = 'BER' WHERE SecCode = 143365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336196, ExchCode = 'BER' WHERE SecCode = 143432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804415389, PermQuoteRetireDate = '2023-10-19' WHERE SecCode = 143636 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 143655 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951189.0 WHERE SecCode = 143708 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951189.0 WHERE SecCode = 143774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475527950, Ticker = 'EPC.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2009-12-15' WHERE SecCode = 143839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673942, ExchCode = 'LSE', PermQuoteRetireDate = '2023-02-15' WHERE SecCode = 143899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289044, ExchCode = 'GTX' WHERE SecCode = 143951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475537870, Ticker = '0HIT', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 143954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790727362, Ticker = 'IPCl', ExchCode = 'SIG' WHERE SecCode = 143961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144566191, ExchCode = 'DEU' WHERE SecCode = 144104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778285096, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536791830, ExchCode = 'TDG', PermQuoteRetireDate = '2019-06-12' WHERE SecCode = 144107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718787365, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565229404, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571165, Ticker = '0H6Q', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 144272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787407, ExchCode = 'DUS' WHERE SecCode = 144320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480998, ExchCode = 'FRA', PermQuoteRetireDate = '2020-08-19' WHERE SecCode = 144377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330934, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364286, Ticker = 'W8O', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 144540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951941273, ExchCode = 'QTX' WHERE SecCode = 144544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21966768812, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237696, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485183, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 144731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894937105, ExchCode = 'GTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611106182, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 144853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796527245, ExchCode = 'QTX' WHERE SecCode = 145117 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 145432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369548, ExchCode = 'FRA' WHERE SecCode = 145505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337535, ExchCode = 'BER' WHERE SecCode = 145506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530695, Ticker = 'BLK.I', ExchCode = 'CIR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 145528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492610, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-02-12' WHERE SecCode = 145530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910335, ExchCode = 'DUS' WHERE SecCode = 147602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532682354, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 147667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334789, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836483410, ExchCode = 'FRA' WHERE SecCode = 150496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460262, ExchCode = 'HAN' WHERE SecCode = 150502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334527, ExchCode = 'BER', PermQuoteRetireDate = '2012-11-05' WHERE SecCode = 150515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385935, ExchCode = 'LAS' WHERE SecCode = 151025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483629, ExchCode = 'QTX' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323148, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 165009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705740, ExchCode = 'MXQ' WHERE SecCode = 168676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520146054, ExchCode = 'STU' WHERE SecCode = 168960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336292, ExchCode = 'BER', PermQuoteRetireDate = '2017-02-09' WHERE SecCode = 168962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488639, ExchCode = 'QTX' WHERE SecCode = 172988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295314, ExchCode = 'STU' WHERE SecCode = 172989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642030, ExchCode = 'QTX' WHERE SecCode = 172996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332251, ExchCode = 'BER', PermQuoteRetireDate = '2023-08-01' WHERE SecCode = 172998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134573, ExchCode = 'TDG' WHERE SecCode = 173075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240695, ExchCode = 'MUN' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381452, ExchCode = 'LAS' WHERE SecCode = 177245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483158, ExchCode = 'QTX' WHERE SecCode = 177259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854903697, ExchCode = 'FRA' WHERE SecCode = 177382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865064, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434578, ExchCode = 'LAS' WHERE SecCode = 177477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859182653, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 177483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855345734, ExchCode = 'GTX' WHERE SecCode = 177491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333764, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 177502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474993163, ExchCode = 'DEU' WHERE SecCode = 177592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331775, ExchCode = 'BER' WHERE SecCode = 177594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798827533, ExchCode = 'FRA' WHERE SecCode = 177597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328975, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779461419, ExchCode = 'GTX' WHERE SecCode = 177624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380979, ExchCode = 'LAS' WHERE SecCode = 177640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808726025, ExchCode = 'FRA' WHERE SecCode = 177715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391762, ExchCode = 'FRA' WHERE SecCode = 177735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667035, ExchCode = 'BER' WHERE SecCode = 177739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820586403, ExchCode = 'TDG' WHERE SecCode = 177769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100379, ExchCode = 'QTX' WHERE SecCode = 177779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659447, ExchCode = 'GTX' WHERE SecCode = 177936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931186247, ExchCode = 'GTX' WHERE SecCode = 177960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312227, ExchCode = 'GTX' WHERE SecCode = 177972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660289166, ExchCode = 'MUN' WHERE SecCode = 178130 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 = 21789211055, ExchCode = 'DEU' WHERE SecCode = 178144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548652821, ExchCode = 'DEU' WHERE SecCode = 178159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058755, ExchCode = 'FRA' WHERE SecCode = 178186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141122, ExchCode = 'FRA' WHERE SecCode = 178338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284975, ExchCode = 'GTX' WHERE SecCode = 178350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732784776, ExchCode = 'DEU' WHERE SecCode = 178466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474865862, ExchCode = 'DEU' WHERE SecCode = 178486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641358574, ExchCode = 'FRA' WHERE SecCode = 178496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754922611, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 178507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836431170, ExchCode = 'FRA' WHERE SecCode = 178511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605132652, ExchCode = 'STU' WHERE SecCode = 178657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806599401, ExchCode = 'FRA' WHERE SecCode = 178667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324285, Ticker = 'BVT', ExchCode = 'BER', PermQuoteRetireDate = '2023-12-08', PermSecMapEndDate = '2023-12-08' WHERE SecCode = 178675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807704216, ExchCode = 'MUN' WHERE SecCode = 178679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847722078, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 178680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475148721, ExchCode = 'DEU' WHERE SecCode = 178724 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323831, ExchCode = 'BER', PermQuoteRetireDate = '2019-07-01' WHERE SecCode = 178727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289031, PermQuoteStatus = 'AC', Ticker = 'BOZA', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 179089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337360, ExchCode = 'BER' WHERE SecCode = 180695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492486, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 181917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336201, ExchCode = 'BER' WHERE SecCode = 184373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325351, Ticker = 'LRL', ExchCode = 'BER', PermQuoteRetireDate = '2020-11-10' WHERE SecCode = 185668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522594, ExchCode = 'MUN' WHERE SecCode = 186478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21900738127, ExchCode = 'GTX' WHERE SecCode = 186488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488602, Ticker = 'NCGB', ExchCode = 'QTX' WHERE SecCode = 186489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836415519, ExchCode = 'FRA' WHERE SecCode = 186493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792426806, ExchCode = 'FRA' WHERE SecCode = 186739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238725, ExchCode = 'LAS' WHERE SecCode = 186740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309238, ExchCode = 'MUN' WHERE SecCode = 186744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552365, ExchCode = 'LAS' WHERE SecCode = 187719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324515, ExchCode = 'BER' WHERE SecCode = 189024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323361, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 189025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624758, Ticker = NULL, ExchCode = 'BER', PermQuoteRetireDate = '2006-03-01' WHERE SecCode = 189574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435052, ExchCode = 'FRA' WHERE SecCode = 194599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165943, ExchCode = 'MUN' WHERE SecCode = 195545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296438, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15', PermSecMapEndDate = NULL WHERE SecCode = 196054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560967785, Ticker = 'BNF', ExchCode = 'STU' WHERE SecCode = 196120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819929691, ExchCode = 'DUS' WHERE SecCode = 196887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339737, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-09' WHERE SecCode = 197286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340690, ExchCode = 'BER', PermQuoteRetireDate = '2020-05-21' WHERE SecCode = 197287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338558, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 199022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196302, ExchCode = 'QTX' WHERE SecCode = 200581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475416897, ExchCode = 'GER' WHERE SecCode = 201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388635, ExchCode = 'FRA' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289175, ExchCode = 'GTX' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469559, ExchCode = 'QTX' WHERE SecCode = 201952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841903622, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 202787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874526, ExchCode = 'MUN' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480921, ExchCode = 'QTX' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373349, ExchCode = 'DEU' WHERE SecCode = 206769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544956008, ExchCode = 'DEU' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328659, ExchCode = 'BER' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228776, ExchCode = 'FRA' WHERE SecCode = 208948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819276162, ExchCode = 'MUN' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286375, ExchCode = 'GTX' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486342, ExchCode = 'QTX', PermQuoteRetireDate = '2022-11-29' WHERE SecCode = 210757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387856, ExchCode = 'LAS' WHERE SecCode = 215110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475595538, ExchCode = 'GER' WHERE SecCode = 246265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589808, Ticker = 'CMGG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 246441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275541, ExchCode = 'GTX' WHERE SecCode = 248506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475827221, PermQuoteStatus = 'AC', Ticker = 'TCS', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 248522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561267935, ExchCode = 'CHI' WHERE SecCode = 248524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492775, ExchCode = 'QTX' WHERE SecCode = 248738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594009397, ExchCode = 'TDG' WHERE SecCode = 248758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607942993, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2018-03-26', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 248987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228131, ExchCode = 'TDG' WHERE SecCode = 248989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2012-06-04' WHERE SecCode = 249049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991681, ExchCode = 'DEU' WHERE SecCode = 249177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379732, ExchCode = 'LAS' WHERE SecCode = 249186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622435163, ExchCode = 'TDG', PermQuoteRetireDate = '2018-06-08' WHERE SecCode = 249362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563176056, ExchCode = 'STU' WHERE SecCode = 249364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777943936, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791320620, ExchCode = 'QTX' WHERE SecCode = 249370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329840, ExchCode = 'BER', PermQuoteRetireDate = '2023-06-30', PermSecMapEndDate = '2023-06-30' WHERE SecCode = 249371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474844752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381774, ExchCode = 'TDG' WHERE SecCode = 249380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323728, ExchCode = 'BER', PermQuoteRetireDate = '2019-08-22', PermSecMapEndDate = '2019-08-22' WHERE SecCode = 249383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573397788, ExchCode = 'TDG' WHERE SecCode = 249398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782714, PermQuoteStatus = 'DC', Ticker = 'INO', ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 249400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528277070, ExchCode = 'FRA' WHERE SecCode = 249402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388640, ExchCode = 'FRA', PermQuoteRetireDate = '2008-08-08' WHERE SecCode = 249403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754447, ExchCode = 'MUN' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715933303, ExchCode = 'MUN' WHERE SecCode = 249589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562213698, ExchCode = 'TDG' WHERE SecCode = 249592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779461439, ExchCode = 'GTX' WHERE SecCode = 249597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808501771, ExchCode = 'TDG' WHERE SecCode = 249600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956712462, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 249601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870528, ExchCode = 'DEU' WHERE SecCode = 249606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256254, ExchCode = 'FRA' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589367501, ExchCode = 'STU', PermQuoteRetireDate = '2020-10-07' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324569, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326625, Ticker = 'CKI2', ExchCode = 'BER', PermQuoteRetireDate = '2020-11-06' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429068, ExchCode = 'FRA' WHERE SecCode = 249648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380223, ExchCode = 'LAS' WHERE SecCode = 249655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548014204, ExchCode = 'FRA' WHERE SecCode = 249656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521693961, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474855924, ExchCode = 'DEU' WHERE SecCode = 249683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779358971, ExchCode = 'GTX' WHERE SecCode = 249684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836526588, ExchCode = 'FRA' WHERE SecCode = 249685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856190, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-26' WHERE SecCode = 249688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475878501, Ticker = 'QPH', ExchCode = 'TDG', PermQuoteRetireDate = '2014-08-18' WHERE SecCode = 249694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325708, ExchCode = 'BER' WHERE SecCode = 249695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731413773, ExchCode = 'MUN' WHERE SecCode = 249701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904311, ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-09' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836409875, ExchCode = 'FRA' WHERE SecCode = 249712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799016537, ExchCode = 'TDG' WHERE SecCode = 249727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666131027, ExchCode = 'TDG', PermQuoteRetireDate = '2020-06-19' WHERE SecCode = 249728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327275, ExchCode = 'BER' WHERE SecCode = 249761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474837424, ExchCode = 'DEU' WHERE SecCode = 249765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332536, ExchCode = 'BER', PermQuoteRetireDate = '2022-05-26', PermSecMapEndDate = '2022-05-26' WHERE SecCode = 249777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463467, ExchCode = 'QTX' WHERE SecCode = 249786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111637, ExchCode = 'DEU' WHERE SecCode = 249791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823048947, ExchCode = 'DUS' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950976, PermQuoteStatus = 'AC', Ticker = '2DT', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390087, ExchCode = 'FRA' WHERE SecCode = 249844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325669, Ticker = 'CH7', ExchCode = 'BER', PermQuoteRetireDate = '2015-02-17' WHERE SecCode = 249849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755977745, ExchCode = 'DUS' WHERE SecCode = 249853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836419614, ExchCode = 'FRA' WHERE SecCode = 249861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608397232, ExchCode = 'TDG' WHERE SecCode = 250132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486563, ExchCode = 'QTX' WHERE SecCode = 254358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572141347, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 257977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858508, ExchCode = 'DUS' WHERE SecCode = 258042 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492384, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 259442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032863, Ticker = 'SVHHd', ExchCode = 'BCO' WHERE SecCode = 259443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520821754, ExchCode = 'MUN' WHERE SecCode = 259654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538345893, ExchCode = 'FRA' WHERE SecCode = 259657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003109, ExchCode = 'DEU' WHERE SecCode = 259830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836501707, Ticker = 'RQZB', ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 261502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589799, Ticker = 'COLI.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 261710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509894968, Ticker = 'THKU', ExchCode = 'LSE', PermQuoteRetireDate = '2008-10-01' WHERE SecCode = 279674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836522301, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-17' WHERE SecCode = 283842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324576, ExchCode = 'BER' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789870379, ExchCode = 'QTX' WHERE SecCode = 288662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836444919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 288837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330518, ExchCode = 'BER' WHERE SecCode = 288842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584775592, ExchCode = 'TDG' WHERE SecCode = 289154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341148, ExchCode = 'BER' WHERE SecCode = 289584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836520595, ExchCode = 'FRA' WHERE SecCode = 289617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489325, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-06', PermSecMapEndDate = '2023-03-06' WHERE SecCode = 289619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325363, Ticker = 'ECA1', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 291269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003127, ExchCode = 'DEU' WHERE SecCode = 291283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885821, ExchCode = 'TDG' WHERE SecCode = 292366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794249941, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 295285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392190, ExchCode = 'FRA', PermQuoteRetireDate = '2008-08-05' WHERE SecCode = 296278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836529482, ExchCode = 'FRA' WHERE SecCode = 296646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034221, ExchCode = 'TDG' WHERE SecCode = 300369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845318193, Ticker = 'SE..GB', ExchCode = 'PLU', PermQuoteRetireDate = '2010-11-08' WHERE SecCode = 300803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614932906, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 301718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790876936, ExchCode = 'FRA' WHERE SecCode = 302076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335365, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 303342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324730, ExchCode = 'BER' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007244, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835798822, ExchCode = 'MEX' WHERE SecCode = 303911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837349733, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 304083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035599, ExchCode = 'TDG' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612317653, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 304966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836356570, ExchCode = 'FRA' WHERE SecCode = 304967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350087, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 305001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032919, ExchCode = 'BCO' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320432, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 310396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320500, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-26', PermSecMapEndDate = '2024-07-26' WHERE SecCode = 313243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656613419, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-09' WHERE SecCode = 316458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837360995, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 318010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323723, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 318424 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 321555 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667479406, ExchCode = 'QTX' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344839, ExchCode = 'STU' WHERE SecCode = 325645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378775, ExchCode = 'STU' WHERE SecCode = 325661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312156, ExchCode = 'GTX' WHERE SecCode = 326261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320604, ExchCode = 'BER' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-26', PermSecMapEndDate = NULL WHERE SecCode = 326814 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21608397233, ExchCode = 'TDG' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 329315 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55863472363, Ticker = '3BH', ExchCode = 'HAM', PermQuoteRetireDate = '2017-06-07' WHERE SecCode = 331318 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 331729 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55848856141, Ticker = '0M6F', ExchCode = 'LSE', PermQuoteRetireDate = '2013-06-27' WHERE SecCode = 332203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303623, PermQuoteStatus = 'DC', Ticker = 'PFV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475558952, Ticker = 'PNZ.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2010-01-29' WHERE SecCode = 332227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565172549, Ticker = 'OLBPl', ExchCode = 'BTE', PermQuoteRetireDate = '2020-06-17' WHERE SecCode = 333091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302799, PermQuoteStatus = 'DC', Ticker = 'SZG.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 333102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350511, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 333180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320982, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 334170 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838302681, Ticker = 'SILP.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 334460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419413, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 334537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396433, ExchCode = 'QTX' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494293572, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 335658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803309265, ExchCode = 'FRA' WHERE SecCode = 336455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491256380, ExchCode = 'STU' WHERE SecCode = 336457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836359938, ExchCode = 'FRA' WHERE SecCode = 341102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320662, ExchCode = 'BER' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479339, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 342227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479638, ExchCode = 'QTX' WHERE SecCode = 343807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727114, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-02' WHERE SecCode = 344003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321374, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 344005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852880802, Ticker = '0OEU', ExchCode = 'LSE', PermQuoteRetireDate = '2017-11-09' WHERE SecCode = 344514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138744228, ExchCode = 'DEU' WHERE SecCode = 345431 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 345666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321391, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 348120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837445595, Ticker = '1RNO' WHERE SecCode = 348455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108673, Ticker = '0N06', ExchCode = 'LSE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 348630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419816, ExchCode = 'HAM' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303566, Ticker = 'MEGA.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 349090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835817375, ExchCode = 'MEX' WHERE SecCode = 349684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836347634, ExchCode = 'FRA', PermQuoteRetireDate = '2009-09-28' WHERE SecCode = 351311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509803171, Ticker = NULL, ExchCode = 'LSE' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475558897, Ticker = 'RAIN.GR', ExchCode = 'PLU', PermQuoteRetireDate = '2009-05-21' WHERE SecCode = 355329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321371, ExchCode = 'BER' WHERE SecCode = 356548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774055180, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2021-11-02', PermSecMapEndDate = '2021-11-02' WHERE SecCode = 359939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321328, Ticker = '45G1', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-06' WHERE SecCode = 360278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288726, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475489992, Ticker = 'BIOSP', ExchCode = 'PLU', PermQuoteRetireDate = '2009-01-27' WHERE SecCode = 363969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469822, ExchCode = 'FRA' WHERE SecCode = 377102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834676604, Ticker = '0ND5', ExchCode = 'LSE', PermQuoteRetireDate = '2022-06-09' WHERE SecCode = 378013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547002144, Ticker = 'D69d', ExchCode = 'BCO' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463487, ExchCode = 'QTX' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 387643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475961015, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-20' WHERE SecCode = 387911 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 389007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840857595, Ticker = '4QQN', ExchCode = 'BER', PermQuoteRetireDate = '2022-05-02' WHERE SecCode = 389019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085548, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 389475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960511452, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-15' WHERE SecCode = 389476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840913294, ExchCode = 'FRA' WHERE SecCode = 389775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760801, ExchCode = 'STU' WHERE SecCode = 392214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173814004, ExchCode = 'DEU' WHERE SecCode = 392352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513841, ExchCode = 'DUS' WHERE SecCode = 395256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841225077, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 395621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841648239, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 396297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799281035, ExchCode = 'FRA' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643564, ExchCode = 'FRA' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841814629, ExchCode = 'BER', PermQuoteRetireDate = '2018-03-26' WHERE SecCode = 404717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704362, ExchCode = 'MXQ' WHERE SecCode = 411789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842974618, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 421788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474878624, Ticker = '0KJT', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 425350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662509884, ExchCode = 'MUN' WHERE SecCode = 430239 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ABBEYBANK' WHERE SecCode = 433151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859809796, ExchCode = 'UAX', PermQuoteRetireDate = '2016-02-05' WHERE SecCode = 433812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477787209, ExchCode = 'TDG' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684650, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766995, ExchCode = 'FRA', PermQuoteRetireDate = '2019-08-19' WHERE SecCode = 446617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852879056, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-12' WHERE SecCode = 462475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475021715, ExchCode = 'FRA' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851569298, ExchCode = 'BER', PermQuoteRetireDate = '2012-11-13' WHERE SecCode = 499735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296759, ExchCode = 'GTX' WHERE SecCode = 504529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849477549, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 513474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115401, Ticker = '0GAd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-12' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749271, PermQuoteStatus = 'AC', Ticker = 'AU31', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 519515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569887, ExchCode = 'QTX' WHERE SecCode = 520411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783658859, ExchCode = 'TQE' WHERE SecCode = 521413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714460362, ExchCode = 'DXE' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714444925, ExchCode = 'DXE' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714445246, ExchCode = 'DXE' WHERE SecCode = 521423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314648, ExchCode = 'OCE' WHERE SecCode = 521425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714450310, ExchCode = 'DXE' WHERE SecCode = 521426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666607625, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2018-12-03' WHERE SecCode = 521434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835439836, PermQuoteStatus = 'AC', Ticker = 'CRUDP', ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 521464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856951179, PermQuoteStatus = 'AC', Ticker = 'PHPT', ExchCode = 'AEX', PermQuoteRetireDate = '2100-01-05' WHERE SecCode = 521843 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 1045861300.0, PermOrgIPODate = '2026-06-29' WHERE SecCode = 522715 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-28' WHERE SecCode = 522937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805519519, ExchCode = 'MUN', PermQuoteRetireDate = '2025-10-24' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214202, ExchCode = 'MEX' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523646821, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519097, ExchCode = 'DUS' WHERE SecCode = 535314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851203490, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 535316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851360620, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-21' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314564, ExchCode = 'OCE' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 536773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851785873, ExchCode = 'FRA' WHERE SecCode = 538090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852284014, ExchCode = 'BER' WHERE SecCode = 540241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335096, ExchCode = 'BER' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858727490, ExchCode = 'STU' WHERE SecCode = 541276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607765095, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522128043, ExchCode = 'MUN' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853712678, ExchCode = 'FRA' WHERE SecCode = 551455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640344252, ExchCode = 'BCO' WHERE SecCode = 553351 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'KMDDA' WHERE SecCode = 554355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853892984, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 554906 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ALUNI' WHERE SecCode = 555021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485192, ExchCode = 'QTX' WHERE SecCode = 558811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856395007, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856703002, PermQuoteStatus = 'DC', Ticker = 'DGF', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 560728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856859125, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704674, ExchCode = 'MXQ' WHERE SecCode = 561519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509911371, ExchCode = 'BEC' WHERE SecCode = 561537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512281634, ExchCode = 'TRQ' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874909, ExchCode = 'DEU' WHERE SecCode = 563938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858521801, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587932514, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03' WHERE SecCode = 564862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857657672, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857350143, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475805335, PermQuoteStatus = 'DC', Ticker = 'OAA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857857467, ExchCode = 'STU' WHERE SecCode = 566528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152662, PermQuoteStatus = 'AC', Ticker = 'GRU1', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858772933, Ticker = '6K1', ExchCode = 'GER', PermQuoteRetireDate = '2013-12-19' WHERE SecCode = 588681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475127703, ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-20' WHERE SecCode = 591764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859177674, ExchCode = 'STU' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859042396, ExchCode = 'FRA' WHERE SecCode = 593055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230062, ExchCode = 'FRA', PermQuoteRetireDate = '2016-11-03' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132756017, ExchCode = 'STO' WHERE SecCode = 602882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373202, ExchCode = 'DEU' WHERE SecCode = 607486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538883522, ExchCode = 'STU' WHERE SecCode = 623935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105425, ExchCode = 'QTX' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475813646, ExchCode = 'TDG', PermQuoteRetireDate = '2011-10-12' WHERE SecCode = 659633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391785, ExchCode = 'MUN' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779045, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-14' WHERE SecCode = 696379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 706545 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'EMTDB' WHERE SecCode = 797593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22160900575, ExchCode = 'STU' WHERE SecCode = 900548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769668, Ticker = 'TYM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 1025098 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 1154797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 1405004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476185193, ExchCode = 'STU' WHERE SecCode = 1449196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580938, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-16', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488285610, ExchCode = 'DEU' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = NULL WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704626, ExchCode = 'MXQ' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522741571, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-17' WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768731670, ExchCode = 'DEU' WHERE SecCode = 1534950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492895638, ExchCode = 'DEU', PermQuoteRetireDate = '2014-04-08' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273313, ExchCode = 'GTX' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775091189, ExchCode = 'DEU' WHERE SecCode = 1541396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779440, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498532317, ExchCode = 'FRA' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807437495, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-10', PermSecMapEndDate = '2025-11-10' WHERE SecCode = 1564475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639604213, ExchCode = 'MUN' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502579570, Ticker = 'T8U', ExchCode = 'FRA' WHERE SecCode = 1569478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503446729, ExchCode = 'BUR' WHERE SecCode = 1590302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 1595881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506129148, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068247, ExchCode = 'TDG' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 1610436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507269905, ExchCode = 'FRA' WHERE SecCode = 1618200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 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 = 21538768058, Ticker = 'BMZl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-07-31' WHERE SecCode = 1635481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100401, ExchCode = 'QTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510008303, ExchCode = 'DEU' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518462361, ExchCode = 'FRA' WHERE SecCode = 1658177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312304, ExchCode = 'GTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183066, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-18' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426483, ExchCode = 'MUN' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955269, ExchCode = 'FRA' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511181364, ExchCode = 'TDG' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514707492, ExchCode = 'DEU' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948839, PermQuoteStatus = 'DC', Ticker = 'OD7L', ExchCode = 'HAN', PermQuoteRetireDate = '2024-03-05' WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815142016, ExchCode = 'MUN' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607386, ExchCode = 'QTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589937926, ExchCode = 'DEU' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430949, ExchCode = 'DEU' WHERE SecCode = 2213927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626732, ExchCode = 'FRA' WHERE SecCode = 2220730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538154, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308485, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2222230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 2240518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478541, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869920397, ExchCode = 'MUN' WHERE SecCode = 2255684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303284, ExchCode = 'TDG' WHERE SecCode = 2267521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539606835, ExchCode = 'DUS' WHERE SecCode = 2278227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967852, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2278243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485240, ExchCode = 'QTX' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527321541, Ticker = 'GPA', ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723974163, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-10-17' WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704580, ExchCode = 'MXQ' WHERE SecCode = 2359427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807341682, ExchCode = 'OCE' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419067, ExchCode = 'LAS' WHERE SecCode = 2377960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531721248, InstrPermID = 8590005814, OrgPermID = 4295915565, ValQuotePermID = 55838797234.0, PriInstrPermID = 8590005814.0, PermInstrStatus = 'DC', Ticker = '56A', ExchCode = 'BER', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2020-09-09' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384853, ExchCode = 'LAS' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607391, ExchCode = 'QTX' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536966570, ExchCode = 'STU' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223768, ExchCode = 'QTX' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997786, ExchCode = 'FRA' WHERE SecCode = 2402414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386146, ExchCode = 'LAS' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2414127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197362, Ticker = 'MRK', ExchCode = 'BRN' WHERE SecCode = 2465112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387906, ExchCode = 'LAS' WHERE SecCode = 2470092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481714947, ExchCode = 'TDG' WHERE SecCode = 2487654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181315008, ExchCode = 'OCE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2515703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823953337, ExchCode = 'DUS' WHERE SecCode = 2515711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907918, ExchCode = 'FRA' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101512, ExchCode = 'FRA' WHERE SecCode = 2524752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475000070, Ticker = 'PREVIS-OSA', ExchCode = 'SGO' WHERE SecCode = 2524756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367747, ExchCode = 'BEC' WHERE SecCode = 2524779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478404, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-24' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385094, ExchCode = 'LAS' WHERE SecCode = 2545058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478415, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550101775, ExchCode = 'FRA' WHERE SecCode = 2559800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793909715, ExchCode = 'TDG' WHERE SecCode = 2568912 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 2576965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543086076, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-24' WHERE SecCode = 2578880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793501847, ExchCode = 'MUN' WHERE SecCode = 2578881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042368, ExchCode = 'DEU' WHERE SecCode = 2580935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543709073, ExchCode = 'FRA' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314867, ExchCode = 'OCE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544084288, ExchCode = 'STU', PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 2591696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958117, ExchCode = 'TDG' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548014433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789432566, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397387, ExchCode = 'GTX' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624667850, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-28' WHERE SecCode = 2650642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742655, ExchCode = 'HAN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197291, Ticker = NULL, ExchCode = 'BRN', PermQuoteRetireDate = '2019-05-29', PermSecMapEndDate = '2019-05-29' WHERE SecCode = 2682394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197297, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2682397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137710, ExchCode = 'MUN', PermQuoteRetireDate = '2021-07-05' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384079, ExchCode = 'LAS' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 2693646 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-28' WHERE SecCode = 2696581 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-28' WHERE SecCode = 2696962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727309229, ExchCode = 'MEX' WHERE SecCode = 2715641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554995304, ExchCode = 'STU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579730411, ExchCode = 'DEU' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734475861, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 2873688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865170, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858555, ExchCode = 'QTX' WHERE SecCode = 2900752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564231392, ExchCode = 'TRQ', PermQuoteRetireDate = '2015-05-28' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019447, ExchCode = 'DEU' WHERE SecCode = 2900878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943057400, ExchCode = 'STU' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565633193, ExchCode = 'STU' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687444, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890828, PermQuoteStatus = 'AC', Ticker = 'VZLBd', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951871.0 WHERE SecCode = 2924585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033693, InstrPermID = 8590942120, OrgPermID = 4295862624, ValQuotePermID = 55838794989.0, PriInstrPermID = 8590942120.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'A4L', ExchCode = 'TDG', PermQuoteRetireDate = '2015-07-06', PermOrgIPODate = NULL WHERE SecCode = 2939990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573607460, ExchCode = 'DUS' WHERE SecCode = 2956411 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628902471, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 3028496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 3038374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386888, ExchCode = 'LAS' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855827347, ExchCode = 'GER', PermQuoteRetireDate = '2022-03-14', PermSecMapEndDate = '2022-03-14' WHERE SecCode = 3090272 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 3136995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296679, ExchCode = 'GTX' WHERE SecCode = 3172332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999663, ExchCode = 'FRA' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599524546, ExchCode = 'STU' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621838, ExchCode = 'FRA' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597673887, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06', PermSecMapEndDate = '2023-11-06' WHERE SecCode = 3256376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634479982, ExchCode = 'MUN' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, ExchCode = 'STU' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739162126, ExchCode = 'MUN' WHERE SecCode = 3317931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237022, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3318127 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 = 236800238839, ExchCode = 'QTX' WHERE SecCode = 3320204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722337, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025937, ExchCode = 'LAS' WHERE SecCode = 3320213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419079, ExchCode = 'LAS' WHERE SecCode = 3337707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620456907, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3338477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614671639, ExchCode = 'FRA' WHERE SecCode = 3357942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 3365585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627708, ExchCode = 'QTX' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742595, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2020-09-22' WHERE SecCode = 3382234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761306205, ExchCode = 'MUN' WHERE SecCode = 3386777 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957123, PermQuoteStatus = 'DC', Ticker = 'C5B', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-19' WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21575576966, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622941, ExchCode = 'DEU' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779748, ExchCode = 'MUN' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256368, ExchCode = 'QTX' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809063689, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-26', PermSecMapEndDate = NULL WHERE SecCode = 3407872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629966004, ExchCode = 'FRA', PermQuoteRetireDate = '2020-02-26' WHERE SecCode = 3408843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368528, Ticker = 'PU9D', ExchCode = 'SES', PermQuoteRetireDate = '2018-01-18' WHERE SecCode = 3429985 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3432247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636049771, ExchCode = 'BER', PermQuoteRetireDate = '2018-06-28' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 3434705 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-29' WHERE SecCode = 3434928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809000735, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', Ticker = 'SCTEM', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-26', PermSecMapEndDate = NULL WHERE SecCode = 3445080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928541, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644789418, Ticker = 'CAS', ExchCode = 'LSE', PermQuoteRetireDate = '2019-03-08' WHERE SecCode = 3446120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380072, ExchCode = 'LAS' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784910654, Ticker = 'NOKIAk', ExchCode = 'BCO' WHERE SecCode = 3504673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750316958, ExchCode = 'MUN' WHERE SecCode = 3518267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165516, ExchCode = 'DEU' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856218033, ExchCode = 'SGO' WHERE SecCode = 3587010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856218034, ExchCode = 'SGO' WHERE SecCode = 3587014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619168949, ExchCode = 'STU' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598347922, ExchCode = 'CHA' WHERE SecCode = 3588027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'EMTDB' WHERE SecCode = 3610329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666021871, Ticker = 'ESRE', ExchCode = 'LSE', PermQuoteRetireDate = '2019-12-24' WHERE SecCode = 3619052 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '3774' WHERE SecCode = 3622412 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3629683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3634350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671376807, ExchCode = 'DEU' WHERE SecCode = 3666895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918918, ExchCode = 'DEU' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114234, ExchCode = 'DEU' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675532883, ExchCode = 'DEU' WHERE SecCode = 3703433 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 3707975 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 3707992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682194724, ExchCode = 'DEU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684103049, ExchCode = 'FRA' WHERE SecCode = 3771411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 3827939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918971, ExchCode = 'FRA' WHERE SecCode = 3832747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183768, Ticker = NULL WHERE SecCode = 3885182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 3906533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075201, ExchCode = 'LAS' WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000056630, PriInstrPermID = 21708349280.0, PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-26' WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363718, ExchCode = 'MEX' WHERE SecCode = 3966586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363715, ExchCode = 'MEX' WHERE SecCode = 3966587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790869620, ExchCode = 'TDG' WHERE SecCode = 3972240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731812579, ExchCode = 'TDG' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371515, ExchCode = 'MEX' WHERE SecCode = 3977379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715682637, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3977923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712308399, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3977926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371064, PermQuoteStatus = 'DC', Ticker = 'BFH*', ExchCode = 'MEX', PermQuoteRetireDate = '2026-05-07', PermSecMapEndDate = '2026-05-07' WHERE SecCode = 3997069 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294452, ExchCode = 'GTX' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536123190, ExchCode = 'DEU' WHERE SecCode = 4030457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064403, Ticker = '1MSIm', ExchCode = 'BCO' WHERE SecCode = 4031708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064438, Ticker = '1MSm', ExchCode = 'BCO' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC', ExchCode = 'MIL' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828455, Ticker = '1AIXAm', ExchCode = 'BCO' WHERE SecCode = 4031796 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 = 21999010479, Ticker = '2NDX' WHERE SecCode = 4031953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22069067178, Ticker = '2NXPI', ExchCode = 'MIL' WHERE SecCode = 4031960 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' 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 PermSecMapEndDate = '2026-06-26' WHERE SecCode = 4032063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064470, Ticker = '1VLOm', ExchCode = 'BCO' WHERE SecCode = 4032652 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 = 21733939843, ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-09', PermSecMapEndDate = '2023-11-17' WHERE SecCode = 4035670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134258, PermQuoteStatus = 'DC', ExchCode = 'AQE', PermQuoteRetireDate = '2026-06-29', PermSecMapEndDate = '2026-06-29' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729105331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4056300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301372, ExchCode = 'MUN' 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 = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958647, ExchCode = 'FRA' WHERE SecCode = 4209246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747487294, ExchCode = 'BER', PermQuoteRetireDate = '2022-09-27', PermSecMapEndDate = '2022-09-27' 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 = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750895314, Ticker = 'GLDA', ExchCode = 'LSE' WHERE SecCode = 4230722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942187, ExchCode = 'STU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 4277462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727345444, ExchCode = 'MEX' WHERE SecCode = 4282147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534178673, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692047, ExchCode = 'FRA' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 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 = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766441949, ExchCode = 'STU' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966496, ExchCode = 'DEU' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770634972, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650250, ExchCode = 'DUS' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, ExchCode = 'MUN' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294239, ExchCode = 'GTX' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381499, ExchCode = 'LAS' WHERE SecCode = 4402242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307570, ExchCode = 'BIV' WHERE SecCode = 4403942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787553936, ExchCode = 'DEU', PermQuoteRetireDate = '2021-01-07' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818102097, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' 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 = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291861, ExchCode = 'BIV' WHERE SecCode = 4485970 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 = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386713, ExchCode = 'LAS' WHERE SecCode = 4513650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781361764, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381380, ExchCode = 'LAS' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808388561, PermQuoteStatus = 'DC', Ticker = '3K70', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-10' WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140274066, ExchCode = 'BTE' WHERE SecCode = 4563419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144478, ExchCode = 'FRA' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025965, ExchCode = 'LAS' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 4593032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463495, ExchCode = 'QTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387260, PermQuoteStatus = 'DC', Ticker = 'WWT', ExchCode = 'LAS', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818264918, ExchCode = 'FRA' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 4633023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799608110, ExchCode = 'LAS' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL 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 = 236799954880, ExchCode = 'LAS', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, Ticker = '9KK', ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388765, ExchCode = 'LAS' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781822280, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-06-05' WHERE SecCode = 4709616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954835, ExchCode = 'LAS' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 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 = 21854716241, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4742663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098692, ExchCode = 'DEU' WHERE SecCode = 4753666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742271, ExchCode = 'DEU' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546343, ExchCode = 'GTX' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855838897, ExchCode = 'QTX' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-29' WHERE SecCode = 4784515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4806504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238765, ExchCode = 'LAS' WHERE SecCode = 4810002 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 = 21886808179, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000077, ExchCode = 'FRA' WHERE SecCode = 4823658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590398, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536829, ExchCode = 'STU' WHERE SecCode = 4823661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866160214, ExchCode = 'TDG' WHERE SecCode = 4823663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897370, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4823669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234885, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-09-25' WHERE SecCode = 4827911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000056630, PriInstrPermID = 21708349280.0, PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-26' WHERE SecCode = 4827936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874018782, ExchCode = 'QTX' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792865451, ExchCode = 'MUN' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 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 = 21877510550, ExchCode = 'STU' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954949, ExchCode = 'LAS' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204885, ExchCode = 'MEX' WHERE SecCode = 4911170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806835525, ExchCode = 'LAS' WHERE SecCode = 4940671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778071474, ExchCode = 'MUN' WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 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 = 21887686666, PermQuoteStatus = 'AC', Ticker = 'WATT', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892277237, ExchCode = 'FRA' WHERE SecCode = 4992088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892277331, ExchCode = 'FRA' WHERE SecCode = 4992089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198072, ExchCode = 'MEX' WHERE SecCode = 4992094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097175, ExchCode = 'LAS' WHERE SecCode = 5011695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909427, ExchCode = 'SWX' WHERE SecCode = 5013560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197369, ExchCode = 'BIV' WHERE SecCode = 5030308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902954507, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031229, ExchCode = 'STU' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902629320, ExchCode = 'QTX' WHERE SecCode = 5067289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727206686, ExchCode = 'BIV' WHERE SecCode = 5067670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663797, ExchCode = 'DEU' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380640, ExchCode = 'LAS' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217398, ExchCode = 'BIV' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805605436, ExchCode = 'MUN' WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204807, ExchCode = 'MEX' WHERE SecCode = 5099007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898584, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898202, PermQuoteStatus = 'AC', Ticker = '3SFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5115635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659492, ExchCode = 'LAS' WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314022, ExchCode = 'OCE' WHERE SecCode = 5152300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830485, ExchCode = 'DUS' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719609, ExchCode = 'TDG', PermQuoteRetireDate = '2014-12-05' WHERE SecCode = 5161223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755973706, ExchCode = 'DUS' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955191864, ExchCode = 'DUS' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922262943, ExchCode = 'DEU' WHERE SecCode = 5178622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922262866, ExchCode = 'DEU' WHERE SecCode = 5178623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782434294, ExchCode = 'QTX' WHERE SecCode = 5183106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397388, ExchCode = 'GTX' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421566, PermQuoteStatus = 'AC', Ticker = '3SZNm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181308541, ExchCode = 'OCU' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794004180, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100719, ExchCode = 'QTX' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077356, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08', PermSecMapEndDate = NULL WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943095863, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 5313552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794189399, ExchCode = 'TDG' WHERE SecCode = 5314256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397469, ExchCode = 'CHI' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-26', PermSecMapEndDate = NULL WHERE SecCode = 5323925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381675, ExchCode = 'LAS' WHERE SecCode = 5324084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380709, ExchCode = 'LAS' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626860, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 5347430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-28' WHERE SecCode = 5360607 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 5360793 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 5360819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785535434, ExchCode = 'DUS' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223422, ExchCode = 'STU' WHERE SecCode = 5407839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803099316, ExchCode = 'STU' WHERE SecCode = 5407840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777248728, PermQuoteStatus = 'AC', Ticker = 'T2I1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5407846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21965213442, ExchCode = 'DEU' WHERE SecCode = 5407861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942209, ExchCode = 'STU' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21967957484, ExchCode = 'DEU' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21976165300, ExchCode = 'DEU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 5463054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778288799, ExchCode = 'FRA' WHERE SecCode = 5466447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778372898, ExchCode = 'STU' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778704118, ExchCode = 'FRA' WHERE SecCode = 5493665 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 = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786101497, ExchCode = 'DEU' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 5565392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835651, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781012608, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780880115, ExchCode = 'HAM', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 5729710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111477357, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5785810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357765, ExchCode = 'BIV' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 5898964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386725, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-25', PermSecMapEndDate = '2025-04-25' WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666337, ExchCode = 'CHI' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001789, PermQuoteStatus = 'AC', Ticker = '83W', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736829339, ExchCode = 'FRA' WHERE SecCode = 5944851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110995, Ticker = 'BITCl', ExchCode = 'BTE' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110997, Ticker = 'BITPl', ExchCode = 'BTE' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864380, ExchCode = 'STU' WHERE SecCode = 6078492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421365, PermQuoteStatus = 'AC', Ticker = '3LNFm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663696, PermQuoteStatus = 'AC', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22030766405, ExchCode = 'CHI' WHERE SecCode = 6097336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151127, Ticker = '3SUE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580190, ExchCode = 'FRA' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799762, ExchCode = 'HAM' WHERE SecCode = 6097368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380561, ExchCode = 'LAS' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928860, Ticker = 'NVDSl', ExchCode = 'BCO' WHERE SecCode = 6097436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753429666, PermQuoteStatus = 'AC', Ticker = 'TSLS', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 6097440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779226797, PermQuoteStatus = 'DC', Ticker = '5VFC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791039841, ExchCode = 'QTX' WHERE SecCode = 6139932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791039842, ExchCode = 'QTX' WHERE SecCode = 6139934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833326, ExchCode = 'DUS' WHERE SecCode = 6139935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087852594, ExchCode = 'DEU' WHERE SecCode = 6139937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790609845, ExchCode = 'STU' WHERE SecCode = 6139938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087852513, ExchCode = 'DEU' WHERE SecCode = 6139939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788928244, ExchCode = 'MEX' WHERE SecCode = 6141564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089463033, ExchCode = 'DEU' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790959257, ExchCode = 'GTX' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111001, Ticker = 'BTCFl', ExchCode = 'BTE' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22082089941, ExchCode = 'QTX' WHERE SecCode = 6256447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789803304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-06', PermSecMapEndDate = '2026-03-06' WHERE SecCode = 6260557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064427, Ticker = '1PWRm', ExchCode = 'BCO' WHERE SecCode = 6263865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064406, Ticker = '1NUEm', ExchCode = 'BCO' WHERE SecCode = 6263894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064423, Ticker = '1NDAQm', ExchCode = 'BCO' WHERE SecCode = 6263907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064416, Ticker = '1NRGm', ExchCode = 'BCO' WHERE SecCode = 6263910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672325, Ticker = '1TOSTm', ExchCode = 'BCO' WHERE SecCode = 6263917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064400, Ticker = '1MELIm', ExchCode = 'BCO' WHERE SecCode = 6263929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064395, Ticker = '1MSCIm', ExchCode = 'BCO' WHERE SecCode = 6263958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064394, Ticker = '1LULm', ExchCode = 'BCO' WHERE SecCode = 6263963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064454, Ticker = '1TERm', ExchCode = 'BCO' WHERE SecCode = 6263965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064392, Ticker = '1LENm', ExchCode = 'BCO' WHERE SecCode = 6263977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064387, Ticker = '1KKRm', ExchCode = 'BCO' WHERE SecCode = 6263997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064377, Ticker = '1JBLm', ExchCode = 'BCO' WHERE SecCode = 6263998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064462, Ticker = '1ULTAm', ExchCode = 'BCO' WHERE SecCode = 6264192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064457, Ticker = '1TTDm', ExchCode = 'BCO' WHERE SecCode = 6264205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064452, Ticker = '1TPRm', ExchCode = 'BCO' WHERE SecCode = 6264223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064448, Ticker = '1TTWOm', ExchCode = 'BCO' WHERE SecCode = 6264225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064447, Ticker = '1SNPSm', ExchCode = 'BCO' WHERE SecCode = 6264228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064436, Ticker = '1SWKm', ExchCode = 'BCO' WHERE SecCode = 6264231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064418, Ticker = '1RMBSm', ExchCode = 'BCO' WHERE SecCode = 6264257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269530, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269527, ExchCode = 'HAM' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22101573233, ExchCode = 'DEU' WHERE SecCode = 6278719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792547775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 6278721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105871912, ExchCode = 'DEU' WHERE SecCode = 6286099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22107562678, ExchCode = 'DEU' WHERE SecCode = 6297519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801670227, ExchCode = 'GTX' WHERE SecCode = 6297520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22107562584, ExchCode = 'DEU' WHERE SecCode = 6297523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793198927, ExchCode = 'MUN' WHERE SecCode = 6324049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22110907760, ExchCode = 'STO' WHERE SecCode = 6324051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793829533, ExchCode = 'QTX' WHERE SecCode = 6324151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448738, ExchCode = 'FRA' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185588018, Ticker = 'EX58v', ExchCode = 'BCO' WHERE SecCode = 6356488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793829541, ExchCode = 'GTX' WHERE SecCode = 6373170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22120375079, ExchCode = 'DEU' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182771, ExchCode = 'FRA' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125760536, ExchCode = 'MIL' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451414, ExchCode = 'BTE' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157927, ExchCode = 'BTE' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157937, ExchCode = 'BTE' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703185, ExchCode = 'BTE' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451415, ExchCode = 'BTE' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447615, ExchCode = 'BTE' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157950, ExchCode = 'BTE' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451405, ExchCode = 'BTE' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796327907, ExchCode = 'TDG' WHERE SecCode = 6464981 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 6528705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462191, ExchCode = 'MUN' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462190, ExchCode = 'GTX' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790266026, ExchCode = 'TDG' WHERE SecCode = 6541042 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743814, ExchCode = 'QTX' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798597968, ExchCode = 'TDG' WHERE SecCode = 6552492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798876398, ExchCode = 'FRA' WHERE SecCode = 6552500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064460, Ticker = '1TDGm', ExchCode = 'BCO' WHERE SecCode = 6564706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064429, Ticker = '1PSTGm', ExchCode = 'BCO' WHERE SecCode = 6564712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141221366, ExchCode = 'DUS' WHERE SecCode = 6564781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142175888, ExchCode = 'DEU' WHERE SecCode = 6564784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142175677, ExchCode = 'DEU' WHERE SecCode = 6564786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799175964, ExchCode = 'FRA' WHERE SecCode = 6564787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346662, Ticker = '0QF', ExchCode = 'BRN' WHERE SecCode = 6578363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821981, ExchCode = 'QTX' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801974580, ExchCode = 'LAS' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806018926, ExchCode = 'LAS' WHERE SecCode = 6628800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806834215, ExchCode = 'TDG' WHERE SecCode = 6684031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161401475, ExchCode = 'DEU' WHERE SecCode = 6684032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161401538, ExchCode = 'DEU' WHERE SecCode = 6684033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807481804, ExchCode = 'FRA' WHERE SecCode = 6705525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171720566, ExchCode = 'DEU' WHERE SecCode = 6769184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805428147, ExchCode = 'FRA' WHERE SecCode = 6769258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705305, ExchCode = 'FRA' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805701903, ExchCode = 'FRA' WHERE SecCode = 6782677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406431, ExchCode = 'MEX' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22177707113, ExchCode = 'DEU' WHERE SecCode = 6829248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178680310, ExchCode = 'DEU' WHERE SecCode = 6843133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178680209, ExchCode = 'DEU' WHERE SecCode = 6843134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524402, ExchCode = 'STU' WHERE SecCode = 6843135 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6846679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807025948, ExchCode = 'FRA' WHERE SecCode = 6849999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807025946, ExchCode = 'FRA' WHERE SecCode = 6850000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807026222, ExchCode = 'FRA' WHERE SecCode = 6850002 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6862205 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 6870908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807481801, ExchCode = 'FRA' WHERE SecCode = 6873669 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 6890751 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 6890753 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 6890957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807900965, ExchCode = 'FRA' WHERE SecCode = 6896919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807900971, ExchCode = 'FRA' WHERE SecCode = 6896922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807900546, ExchCode = 'FRA' WHERE SecCode = 6896923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408712, ExchCode = 'BIV' WHERE SecCode = 6900891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807977903, ExchCode = 'FRA' WHERE SecCode = 6900894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807978130, ExchCode = 'FRA' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 6901923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808332135, ExchCode = 'LAS' WHERE SecCode = 6902160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808190084, ExchCode = 'DUS' WHERE SecCode = 6902189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808268919, ExchCode = 'FRA' WHERE SecCode = 6911172 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 6914521 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 6917401 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-29' WHERE SecCode = 6917420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185584083, ExchCode = 'DEU' WHERE SecCode = 6917506 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-28' WHERE SecCode = 6920998 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6921009 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6921028 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-28' WHERE SecCode = 6923698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808548554, ExchCode = 'FRA' WHERE SecCode = 6923756 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 6927579 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951871.0 WHERE SecCode = 6934749 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6937609 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6937623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791315735, ExchCode = 'TDG' 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 PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6939096 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 6941773 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 6945363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808988071, ExchCode = 'MUN' WHERE SecCode = 6945407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808993816, ExchCode = 'FRA' WHERE SecCode = 6945409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994978, ExchCode = 'FRA' WHERE SecCode = 6945413 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 11051180 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'SRKRF', PermQuoteRetireDate = NULL WHERE SecCode = 11052946 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 11060533 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 11111301 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11137709 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 11152008 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 11201544 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 11207144 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11218123 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809002159, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', Ticker = 'USDE', ExchCode = 'NAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-26' WHERE SecCode = 11237342 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 11240570 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 11256494 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000056630, PriInstrPermID = 21708349280.0, PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = NULL WHERE SecCode = 11261751 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 11262062 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-27' WHERE SecCode = 11264180 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5087154170, PriInstrPermID = 232842340134.0, IncCntry = 'USA', PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 11266820 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 11279273 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295628 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 22183412729, PriTrdQuotePermID = NULL, Ticker = 'LGLGR', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 11296912 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11296942 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11298205 AND Type_ = 1;
