UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 925 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 12513 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 13049 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-06' WHERE SecCode = 25455 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 27551 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 28992 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 32261 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 35214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475586089, PermQuoteStatus = 'DC', Ticker = 'CPAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951593.0 WHERE SecCode = 38675 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951436.0 WHERE SecCode = 41902 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 50734 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236794431033, ExchCode = 'GTX' WHERE SecCode = 52755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644530923, ExchCode = 'DEU', PermQuoteRetireDate = '2024-01-08', PermSecMapEndDate = '2024-01-09' WHERE SecCode = 58804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836412799, Ticker = 'DYS', ExchCode = 'FRA', PermQuoteRetireDate = '2009-08-12' WHERE SecCode = 58925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479924, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 58930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196283, ExchCode = 'QTX' WHERE SecCode = 60024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475030486, ExchCode = 'FRA' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 61958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 65671 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 66393 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 68588 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 72565 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-06' WHERE SecCode = 73402 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 74992 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 75720 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951593.0 WHERE SecCode = 77035 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 78903 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 79306 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 81636 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 82755 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 83735 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 84959 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 85955 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'JPN' WHERE SecCode = 86929 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 87623 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 87624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838797189, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 88613 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 89104 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ABC' WHERE SecCode = 90115 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 90678 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 91251 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 91973 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 91974 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'NP' WHERE SecCode = 92879 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 99233 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951536.0 WHERE SecCode = 99645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141120, ExchCode = 'FRA' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043704, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 100845 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 101281 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 111848 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 = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 112894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032621, ExchCode = 'STU' WHERE SecCode = 113151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921480430, ExchCode = 'MUN' WHERE SecCode = 115096 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 115826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474928478, ExchCode = 'DEU' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835800170, ExchCode = 'MEX' WHERE SecCode = 121616 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 122421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704391, ExchCode = 'MXQ' WHERE SecCode = 122927 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 127620 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 127855 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 129262 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 129546 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951879.0 WHERE SecCode = 131086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836475370, ExchCode = 'FRA', PermQuoteRetireDate = '2015-09-15' WHERE SecCode = 132559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475037380, ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 132562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337118, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 132593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552653, ExchCode = 'LAS' WHERE SecCode = 132606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981159, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 132611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340029, ExchCode = 'BER' WHERE SecCode = 133363 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 134084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801211984, ExchCode = 'HAM' WHERE SecCode = 137417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625198385, ExchCode = 'DEU' WHERE SecCode = 137437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954446, ExchCode = 'FRA' WHERE SecCode = 137616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860349, ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-09', PermSecMapEndDate = '2024-04-09' WHERE SecCode = 137668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 137669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359225, ExchCode = 'GER' WHERE SecCode = 137682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440376, ExchCode = 'FRA' WHERE SecCode = 137820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518681206, ExchCode = 'TDG' WHERE SecCode = 137851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535196609, Ticker = '8604', ExchCode = 'BRN', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 137856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448652, ExchCode = 'FRA' WHERE SecCode = 138104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645874, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926924, ExchCode = 'DEU' WHERE SecCode = 138123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843446933, ExchCode = 'GER' WHERE SecCode = 138806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652758, ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-11' WHERE SecCode = 139011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543203134, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-14' WHERE SecCode = 139013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481367141, ExchCode = 'STU' WHERE SecCode = 139159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840759896, ExchCode = 'BER', PermQuoteRetireDate = '2012-02-23' WHERE SecCode = 139165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834295, ExchCode = 'DEU', PermQuoteRetireDate = '2014-12-29' WHERE SecCode = 139167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475829465, ExchCode = 'STU' WHERE SecCode = 139233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953637391, ExchCode = 'BER', PermQuoteRetireDate = '2025-01-02' WHERE SecCode = 139418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836469769, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-23' WHERE SecCode = 140024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537960733, ExchCode = 'MUN' WHERE SecCode = 140048 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 140104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333917, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 140151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865296556, ExchCode = 'TDG' WHERE SecCode = 140291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783487519, ExchCode = 'QTX' WHERE SecCode = 140292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821654685, ExchCode = 'STU' WHERE SecCode = 140361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877872807, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 140365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295435, ExchCode = 'GTX' WHERE SecCode = 140478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490683, ExchCode = 'QTX' WHERE SecCode = 140707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836509860, ExchCode = 'FRA', PermQuoteRetireDate = '2008-01-05' WHERE SecCode = 140711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391250, ExchCode = 'FRA' WHERE SecCode = 140727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869021455, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 140824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075531, ExchCode = 'LAS' WHERE SecCode = 140853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296622, ExchCode = 'GTX' WHERE SecCode = 140877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503219544, ExchCode = 'STU' WHERE SecCode = 140881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340702, ExchCode = 'BER' WHERE SecCode = 140888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523702479, ExchCode = 'STU' WHERE SecCode = 140890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474933908, ExchCode = 'DEU' WHERE SecCode = 141031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623028569, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 141114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336931, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805701995, ExchCode = 'FRA' WHERE SecCode = 141365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792607162, ExchCode = 'FRA' WHERE SecCode = 141384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833046, ExchCode = 'FRA' WHERE SecCode = 141386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518925209, PermQuoteStatus = 'AC', Ticker = '0WP', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 141389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802227869, ExchCode = 'FRA' WHERE SecCode = 141394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541593, ExchCode = 'FRA' WHERE SecCode = 141403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847195, ExchCode = 'DUS' WHERE SecCode = 141410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540736583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566184266, ExchCode = 'DEU' WHERE SecCode = 141993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126935, ExchCode = 'DEU' WHERE SecCode = 141999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331156, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 142060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836451873, Ticker = 'LPB1', ExchCode = 'FRA' WHERE SecCode = 142115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554497078, ExchCode = 'BER' WHERE SecCode = 142150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485386, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 142481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037625, ExchCode = 'MUN' WHERE SecCode = 142650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387689, ExchCode = 'LAS' WHERE SecCode = 142718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475878362, ExchCode = 'STU' WHERE SecCode = 142742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625977903, ExchCode = 'DEU' WHERE SecCode = 142826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335753, ExchCode = 'BER' WHERE SecCode = 143365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829123449, ExchCode = 'STU' WHERE SecCode = 143427 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 = 21734475830, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 143908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327368, PermQuoteStatus = 'DC', Ticker = 'DME', ExchCode = 'BER', PermQuoteRetireDate = '2019-09-16' WHERE SecCode = 143937 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 = 55836323045, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-21' WHERE SecCode = 143966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337448, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 143968 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 = 236781650233, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951941273, ExchCode = 'QTX' WHERE SecCode = 144544 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 144789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475447517, Ticker = 'SSBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 144817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338891, ExchCode = 'BER' WHERE SecCode = 144819 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 = 55836339223, Ticker = 'YGF', ExchCode = 'BER', PermQuoteRetireDate = '2014-04-03' WHERE SecCode = 144907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329184, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564309288, ExchCode = 'FRA' WHERE SecCode = 145033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836342050, Ticker = 'XA3', ExchCode = 'BER', PermQuoteRetireDate = '2012-06-14' WHERE SecCode = 145282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808378819, ExchCode = 'MUN', PermQuoteRetireDate = '2023-09-25', PermSecMapEndDate = NULL WHERE SecCode = 145350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640507311, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 146103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340455, ExchCode = 'BER' WHERE SecCode = 146127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537004604, ExchCode = 'DEU' WHERE SecCode = 146151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542388498, ExchCode = 'STU' WHERE SecCode = 146155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169215035, ExchCode = 'DEU', DomCntry = 'HKG' WHERE SecCode = 146536 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 146587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334962, ExchCode = 'BER' WHERE SecCode = 146704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337886, ExchCode = 'BER', PermQuoteRetireDate = '2020-04-17' WHERE SecCode = 146705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324938, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 146781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475807562, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-16' WHERE SecCode = 146782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724824240, ExchCode = 'TDG' WHERE SecCode = 146832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509797897, Ticker = 'GEIG.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 146851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327609, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 147146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836882358, ExchCode = 'TDG', PermQuoteRetireDate = '2025-06-25' WHERE SecCode = 147266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836517997, ExchCode = 'FRA', PermQuoteRetireDate = '2010-10-19' WHERE SecCode = 147274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836469019, ExchCode = 'FRA' WHERE SecCode = 147369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492212, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 147405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329623, ExchCode = 'BER', PermQuoteRetireDate = '2020-03-27' WHERE SecCode = 147445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335269, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 147452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475612875, Ticker = 'MCZG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 147455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484697, ExchCode = 'QTX', PermQuoteRetireDate = '2026-03-25' WHERE SecCode = 147470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836529495, ExchCode = 'FRA', PermQuoteRetireDate = '2013-11-28' WHERE SecCode = 147529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641375851, Ticker = 'NXG', ExchCode = 'TDG' WHERE SecCode = 147539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905907784, ExchCode = 'GTX' WHERE SecCode = 147551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556336649, ExchCode = 'STU' WHERE SecCode = 147588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910335, ExchCode = 'DUS' WHERE SecCode = 147602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364390, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 147608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490582, ExchCode = 'QTX', PermQuoteRetireDate = '2021-12-01' WHERE SecCode = 147613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336338, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337179, ExchCode = 'BER' WHERE SecCode = 147615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490929, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 147619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308403, ExchCode = 'GTX' WHERE SecCode = 147621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534105, ExchCode = 'DUS' WHERE SecCode = 147623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836481557, ExchCode = 'FRA' WHERE SecCode = 147627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575204800, ExchCode = 'HAM' WHERE SecCode = 147630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419095, ExchCode = 'LAS' WHERE SecCode = 147632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836503758, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 147649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562942059, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 147667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528350962, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-19' WHERE SecCode = 147693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875734, ExchCode = 'MUN' WHERE SecCode = 147705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327751, PermQuoteStatus = 'DC', Ticker = 'HHK', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329906, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 147707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487460, ExchCode = 'QTX' WHERE SecCode = 147719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333892, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 147838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335618, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 147856 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 = 21830308280, ExchCode = 'GTX' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308439, ExchCode = 'GTX' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339056, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 147913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482084, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 148734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498233890, ExchCode = 'STU' WHERE SecCode = 150272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475807584, ExchCode = 'STU', PermQuoteRetireDate = '2015-07-17' WHERE SecCode = 150276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836551565, ExchCode = 'FRA', PermQuoteRetireDate = '2021-06-28' WHERE SecCode = 150689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684710661, ExchCode = 'QTX' WHERE SecCode = 161035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475632881, ExchCode = 'FRA' WHERE SecCode = 161036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298348, ExchCode = 'DUS' WHERE SecCode = 161452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836558172, ExchCode = 'FRA', PermQuoteRetireDate = '2021-10-27' WHERE SecCode = 161468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836558169, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 161469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521440, ExchCode = 'TDG' WHERE SecCode = 161948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475756843, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 162463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330932, ExchCode = 'BER', PermQuoteRetireDate = '2013-09-27' WHERE SecCode = 162529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273265, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-26', PermSecMapEndDate = '2025-11-10' WHERE SecCode = 164342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474902313, ExchCode = 'DEU' WHERE SecCode = 164349 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 164382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806640334, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-06', PermSecMapEndDate = NULL WHERE SecCode = 164924 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 = 21830296596, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 165818 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 166327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520146054, ExchCode = 'STU' WHERE SecCode = 168960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598956, ExchCode = 'FRA' WHERE SecCode = 170656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523518435, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 171308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419340, ExchCode = 'HAM' WHERE SecCode = 172969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617037034, ExchCode = 'FRA' WHERE SecCode = 172982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085574, ExchCode = 'HAM' WHERE SecCode = 174287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324693, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2015-12-17', PermSecMapEndDate = '2015-12-17' WHERE SecCode = 175239 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 177186 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 = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 177280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836463658, ExchCode = 'FRA' WHERE SecCode = 177293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384120, ExchCode = 'LAS' WHERE SecCode = 177301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803452376, ExchCode = 'FRA' WHERE SecCode = 177314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335207, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781814018, ExchCode = 'GTX' WHERE SecCode = 177357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517511603, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-04', PermSecMapEndDate = '2024-04-04' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836489072, ExchCode = 'FRA' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329926, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486893, PermQuoteStatus = 'DC', Ticker = 'JEG', ExchCode = 'QTX', PermQuoteRetireDate = '2022-11-08', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680653259, ExchCode = 'STU' WHERE SecCode = 177491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649328303, ExchCode = 'STU' WHERE SecCode = 177594 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 177617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733576076, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177640 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 177669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485767, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 177697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836420637, ExchCode = 'FRA' WHERE SecCode = 177707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845359789, ExchCode = 'FRA' WHERE SecCode = 177732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391762, ExchCode = 'FRA' WHERE SecCode = 177735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474853300, ExchCode = 'DEU' WHERE SecCode = 177955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475003620, ExchCode = 'FRA' WHERE SecCode = 177972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333074, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592567060, ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-01' WHERE SecCode = 178014 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 = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475680077, ExchCode = 'MUN', PermQuoteRetireDate = '2008-02-18' WHERE SecCode = 178190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340077, ExchCode = 'BER' WHERE SecCode = 178369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830299272, ExchCode = 'GTX' WHERE SecCode = 178420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838505143, ExchCode = 'STU' WHERE SecCode = 178488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474896334, ExchCode = 'DEU' WHERE SecCode = 178511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475666675, Ticker = 'HYZ', ExchCode = 'MUN', PermQuoteRetireDate = '2007-11-30' WHERE SecCode = 178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531978942, ExchCode = 'FRA' WHERE SecCode = 178657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285876, ExchCode = 'GTX' WHERE SecCode = 178720 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 178843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475623674, PermQuoteStatus = 'DC', Ticker = 'BOZA.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 179089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553012388, ExchCode = 'STU' WHERE SecCode = 181992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736391, Ticker = 'VLG', ExchCode = 'MCE', PermQuoteRetireDate = '2013-08-09' WHERE SecCode = 182166 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 182779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926943, ExchCode = 'DEU' WHERE SecCode = 183471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782672, ExchCode = 'DUS' WHERE SecCode = 185500 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 185632 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 185826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21577684951, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 186433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798248748, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381654, ExchCode = 'LAS' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650270, ExchCode = 'DUS' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547304362, Ticker = 'NCGBd', ExchCode = 'BCO' WHERE SecCode = 186489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387181, ExchCode = 'FRA' WHERE SecCode = 186810 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 = 21550981535, Ticker = 'P8H', ExchCode = 'HAM', PermQuoteRetireDate = '2016-05-17' WHERE SecCode = 191863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954293455, ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-06' WHERE SecCode = 192940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337399, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 195530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165943, ExchCode = 'MUN' WHERE SecCode = 195545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805177406, ExchCode = 'MUN', PermQuoteRetireDate = '2025-01-15', PermSecMapEndDate = NULL WHERE SecCode = 196054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359914, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 196619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489393, ExchCode = 'QTX' WHERE SecCode = 196829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900660, ExchCode = 'STU' WHERE SecCode = 197762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331715, ExchCode = 'BER' WHERE SecCode = 199016 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 = 21537702696, ExchCode = 'DEU' WHERE SecCode = 201372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791481822, ExchCode = 'FRA' WHERE SecCode = 201937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055593, ExchCode = 'GTX' 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 = 21619083430, ExchCode = 'TDG' WHERE SecCode = 201951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328930, ExchCode = 'BER', PermQuoteRetireDate = '2021-02-18' WHERE SecCode = 202787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498931242, ExchCode = 'FRA' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985590, ExchCode = 'STU', PermQuoteRetireDate = '2017-04-04' WHERE SecCode = 203925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517579838, ExchCode = 'STU', PermQuoteRetireDate = '2014-10-07' WHERE SecCode = 204876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373349, ExchCode = 'DEU' WHERE SecCode = 206769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385261, ExchCode = 'MUN' WHERE SecCode = 206847 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 = 21475780721, ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-18' WHERE SecCode = 210736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184307, ExchCode = 'MUN' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835817048, ExchCode = 'MEX' WHERE SecCode = 214378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387856, ExchCode = 'LAS' WHERE SecCode = 215110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533828740, Ticker = 'GJ9', ExchCode = 'TDG', PermQuoteRetireDate = '2014-03-17' WHERE SecCode = 216218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 216383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475038582, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 245886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837362315, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 246361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715102, PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 246616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475519731, Ticker = NULL, ExchCode = 'MUN', PermQuoteRetireDate = '2004-07-16' WHERE SecCode = 246694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147785188, ExchCode = 'DEU' WHERE SecCode = 248095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275541, ExchCode = 'GTX' WHERE SecCode = 248506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866795118, ExchCode = 'STU', PermQuoteRetireDate = '2022-04-27' WHERE SecCode = 248740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374981, ExchCode = 'FRA' WHERE SecCode = 248742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594009397, ExchCode = 'TDG' WHERE SecCode = 248758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567623104, ExchCode = 'MUN' WHERE SecCode = 248901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589742994, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-15' WHERE SecCode = 248903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802775549, ExchCode = 'FRA' WHERE SecCode = 248904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624182407, ExchCode = 'STU' WHERE SecCode = 248925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939235, ExchCode = 'FRA' WHERE SecCode = 248942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718474167, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-21' WHERE SecCode = 248943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529738420, ExchCode = 'DEU' WHERE SecCode = 248951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645543016, ExchCode = 'FRA' WHERE SecCode = 248959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228131, ExchCode = 'TDG' WHERE SecCode = 248989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341284, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 249048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333593, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561563, Ticker = 'BHQ2', ExchCode = 'DUS', PermQuoteRetireDate = '2026-03-23', PermSecMapEndDate = NULL WHERE SecCode = 249168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991681, ExchCode = 'DEU' WHERE SecCode = 249177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489182, ExchCode = 'QTX' WHERE SecCode = 249196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475018588, Ticker = 'RBQP', ExchCode = 'BER', PermQuoteRetireDate = '2016-12-13' WHERE SecCode = 249199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436628, ExchCode = 'STU' WHERE SecCode = 249208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192827, ExchCode = 'STU' WHERE SecCode = 249211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847010273, ExchCode = 'BER' WHERE SecCode = 249232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147089280, ExchCode = 'DEU' WHERE SecCode = 249236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394740, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-11' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787268, ExchCode = 'DUS' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168124, ExchCode = 'FRA' WHERE SecCode = 249305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328104, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-04' WHERE SecCode = 249315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858768862, ExchCode = 'FRA', PermQuoteRetireDate = '2013-02-19' WHERE SecCode = 249351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573397788, ExchCode = 'TDG' WHERE SecCode = 249398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528277070, ExchCode = 'FRA' WHERE SecCode = 249402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476850902, ExchCode = 'TDG' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526392840, ExchCode = 'DEU' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298682, ExchCode = 'STU' WHERE SecCode = 249565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715933303, ExchCode = 'MUN' WHERE SecCode = 249589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109803, ExchCode = 'DUS' WHERE SecCode = 249624 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 = 21475429068, ExchCode = 'FRA' WHERE SecCode = 249648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474854296, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-04' WHERE SecCode = 249654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754406, ExchCode = 'MUN' WHERE SecCode = 249668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344683, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 249703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858768435, ExchCode = 'FRA' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836450817, ExchCode = 'FRA' WHERE SecCode = 249713 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 = 21618954050, ExchCode = 'STU' WHERE SecCode = 249782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632741548, ExchCode = 'TDG' WHERE SecCode = 249787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264818, ExchCode = 'FRA' WHERE SecCode = 249797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532684873, ExchCode = 'DEU' WHERE SecCode = 249801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328481, ExchCode = 'BER', PermQuoteRetireDate = '2016-01-04' WHERE SecCode = 249805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309351, ExchCode = 'MUN' WHERE SecCode = 249812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060447, ExchCode = 'STU' WHERE SecCode = 249816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823048947, ExchCode = 'DUS' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354134, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836400888, ExchCode = 'FRA' WHERE SecCode = 249855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341364, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29' WHERE SecCode = 250100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486563, ExchCode = 'QTX' WHERE SecCode = 254358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333525, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 255144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475573655, PermQuoteStatus = 'DC', Ticker = 'BUNG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 255769 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 258859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384470, ExchCode = 'LAS' WHERE SecCode = 259026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002550, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 259830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327852, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 277248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474900132, ExchCode = 'DEU' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340809, ExchCode = 'BER', PermQuoteRetireDate = '2011-10-25' WHERE SecCode = 283842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515133, ExchCode = 'FRA' WHERE SecCode = 284038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325014, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-16', PermSecMapEndDate = '2025-07-16' WHERE SecCode = 286042 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035344, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2020-02-07' WHERE SecCode = 286286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760841, Ticker = 'TSU', ExchCode = 'BUR', PermQuoteRetireDate = '2013-06-03' WHERE SecCode = 286474 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 = 236799369556, ExchCode = 'FRA' WHERE SecCode = 288353 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 289513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836491800, ExchCode = 'FRA', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 289899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474940801, Ticker = 'A8M2', ExchCode = 'DEU', PermQuoteRetireDate = '2017-04-19' WHERE SecCode = 290850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598997799, ExchCode = 'TDG' WHERE SecCode = 291259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323505, ExchCode = 'BER', PermQuoteRetireDate = '2009-01-08' WHERE SecCode = 291270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357981, ExchCode = 'STU' WHERE SecCode = 291585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435377, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 291628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475802522, ExchCode = 'TDG', PermQuoteRetireDate = '2013-09-27' WHERE SecCode = 291865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885821, ExchCode = 'TDG' WHERE SecCode = 292366 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 292702 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667493070, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 292973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782413605, ExchCode = 'STU' WHERE SecCode = 292976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625977418, ExchCode = 'TDG' WHERE SecCode = 293916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411739, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794249903, ExchCode = 'MUN', PermQuoteRetireDate = '2026-04-28', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 296276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332529, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01', PermSecMapEndDate = '2018-02-01' WHERE SecCode = 296279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935884276, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836502666, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532933634, ExchCode = 'STU' WHERE SecCode = 296606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393948, Ticker = 'CVE', ExchCode = 'FRA', PermQuoteRetireDate = '2020-09-15' WHERE SecCode = 296645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475588932, ExchCode = 'STU', PermQuoteRetireDate = '2008-10-08' WHERE SecCode = 297228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533706424, ExchCode = 'DEU' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330753, ExchCode = 'BER' WHERE SecCode = 297742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394794, ExchCode = 'FRA' WHERE SecCode = 298579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335814, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704246, Ticker = 'APC*', ExchCode = 'MXQ' WHERE SecCode = 299537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212162, ExchCode = 'BIV' WHERE SecCode = 299539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704473, ExchCode = 'MXQ' WHERE SecCode = 299540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034221, ExchCode = 'TDG' WHERE SecCode = 300369 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 301125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484161, ExchCode = 'QTX' WHERE SecCode = 301739 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 = 55836328354, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 303854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836356570, ExchCode = 'FRA' WHERE SecCode = 304967 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 306436 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475790476, ExchCode = 'TDG', PermQuoteRetireDate = '2015-06-17' WHERE SecCode = 309349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032968, ExchCode = 'BCO' WHERE SecCode = 309898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530720855, ExchCode = 'STU', PermQuoteRetireDate = '2015-09-07' WHERE SecCode = 310710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792573068, ExchCode = 'BIV' WHERE SecCode = 311169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320613, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 312700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349150, ExchCode = 'FRA' WHERE SecCode = 312932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321117, ExchCode = 'BER', PermQuoteRetireDate = '2012-02-28' WHERE SecCode = 312933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571962567, ExchCode = 'BCO' WHERE SecCode = 313522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789408066, ExchCode = 'FRA' WHERE SecCode = 313535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841091589, ExchCode = 'STU' WHERE SecCode = 313545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503219931, ExchCode = 'FRA' WHERE SecCode = 314183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822221, ExchCode = 'FRA' WHERE SecCode = 316458 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'MANU' WHERE SecCode = 316714 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21770742612, ExchCode = 'HAN' WHERE SecCode = 317794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460519, ExchCode = 'HAN' WHERE SecCode = 317810 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 = 21475503818, ExchCode = 'SGO', PermQuoteRetireDate = '2020-09-11' WHERE SecCode = 319996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320974, Ticker = '45CN', ExchCode = 'BER', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 323043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809675, ExchCode = 'DEU' WHERE SecCode = 323298 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 323487 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'JPN' WHERE SecCode = 324538 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21817233545, ExchCode = 'DEU' WHERE SecCode = 324562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320881, ExchCode = 'BER', PermQuoteRetireDate = '2016-06-17' WHERE SecCode = 325342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321191, ExchCode = 'BER' WHERE SecCode = 325648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378775, ExchCode = 'STU' WHERE SecCode = 325661 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 325872 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836321155, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-19' WHERE SecCode = 326659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724928455, ExchCode = 'TDG' WHERE SecCode = 327143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817679438, ExchCode = 'TDG' WHERE SecCode = 327723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852373347, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-20' WHERE SecCode = 328871 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 328877 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 329656 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667479301, ExchCode = 'QTX' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843042843, ExchCode = 'FRA' WHERE SecCode = 331281 AND Type_ = 10;
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 QuotePermID = 55834677617, PermQuoteStatus = 'AC', Ticker = '0NYZ', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834671476, PermQuoteStatus = 'AC', Ticker = '0RPV', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673409, Ticker = '0E6Z', ExchCode = 'LSE', PermQuoteRetireDate = '2015-07-31' WHERE SecCode = 332176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475510699, Ticker = '0E5X', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 332179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834678223, PermQuoteStatus = 'AC', Ticker = '0EDB', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838298656, Ticker = 'FR.IT', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303087, PermQuoteStatus = 'DC', Ticker = 'FIE.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296413, Ticker = 'AAGN.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673167, Ticker = '0MSM', ExchCode = 'LSE', PermQuoteRetireDate = '2011-09-09' WHERE SecCode = 332212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834674934, PermQuoteStatus = 'AC', Ticker = '0MEF', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838300942, PermQuoteStatus = 'DC', Ticker = 'WRTBV.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836040818, Ticker = 'AGGP', ExchCode = 'LSE' WHERE SecCode = 333085 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 = 55836370746, ExchCode = 'FRA', PermQuoteRetireDate = '2009-04-20' WHERE SecCode = 333158 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 = 55838303459, PermQuoteStatus = 'DC', Ticker = 'HEIO.NL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 333386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289068, ExchCode = 'GTX' WHERE SecCode = 333421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830307503, PermQuoteStatus = 'AC', Ticker = 'B9P1', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 333423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885451397, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704226, ExchCode = 'MXQ' WHERE SecCode = 333869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320912, ExchCode = 'BER' WHERE SecCode = 334857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837447989, Ticker = 'XGLE', ExchCode = 'MIL' WHERE SecCode = 335234 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 = 22145600985, ExchCode = 'DEU' WHERE SecCode = 335659 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 336138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320581, ExchCode = 'BER' WHERE SecCode = 336460 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 336739 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836340169, ExchCode = 'BER', PermQuoteRetireDate = '2014-01-08' WHERE SecCode = 336766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834671877, Ticker = '0OQO', ExchCode = 'LSE', PermQuoteRetireDate = '2014-07-14' WHERE SecCode = 340071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320662, ExchCode = 'BER' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296529, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 341129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538721081, ExchCode = 'STU' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911870720, ExchCode = 'GTX' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543784117, ExchCode = 'STU' WHERE SecCode = 341963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524267752, ExchCode = 'STU', PermQuoteRetireDate = '2017-03-29' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566536425, ExchCode = 'STU' WHERE SecCode = 343026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387674, Ticker = '3U9.BG', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 344514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168118, ExchCode = 'FRA' WHERE SecCode = 344774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564885326, ExchCode = 'FRA' WHERE SecCode = 344777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321245, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 345092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550076203, ExchCode = 'HAM', PermQuoteRetireDate = '2018-07-12' WHERE SecCode = 345094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957529769, ExchCode = 'QTX' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475550034, Ticker = 'CAZA', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 345783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116848257, ExchCode = 'DEU' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997542, ExchCode = 'DEU' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159147457, ExchCode = 'DEU' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502570914, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 345858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783662836, Ticker = 'VGPk', ExchCode = 'TQE' WHERE SecCode = 346537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321533, ExchCode = 'BER' WHERE SecCode = 348107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419443, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836352305, ExchCode = 'FRA', PermQuoteRetireDate = '2015-09-21' WHERE SecCode = 348453 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 = 21707243674, ExchCode = 'TDG' WHERE SecCode = 348709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419816, ExchCode = 'HAM' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838234536, ExchCode = 'MUN', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 350269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299763, PermQuoteStatus = 'DC', Ticker = 'POST.AT', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509807554, Ticker = '0D39', ExchCode = 'POS' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387991, PermQuoteStatus = 'DC', Ticker = 'VOLV_A.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388341, Ticker = 'ORC.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321371, ExchCode = 'BER' WHERE SecCode = 356548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474939810, ExchCode = 'DEU' WHERE SecCode = 357185 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 359624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543203134, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-14', PermSecMapEndDate = '2023-09-14' WHERE SecCode = 359919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609514, PermQuoteStatus = 'AC', ExchCode = 'DUS', DomCntry = 'CHN', 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 = 55837351799, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041770, ExchCode = 'TDG' WHERE SecCode = 370294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294185, ExchCode = 'GTX' WHERE SecCode = 376283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469684, ExchCode = 'DEU' WHERE SecCode = 377102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910119, PermQuoteStatus = 'AC', Ticker = '4LT1', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 377460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779690632, Ticker = 'TFGl', ExchCode = 'AQX' WHERE SecCode = 379856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322712, ExchCode = 'BER' WHERE SecCode = 383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463487, ExchCode = 'QTX' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 386577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852345883, ExchCode = 'GER' WHERE SecCode = 387914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475476680, ExchCode = 'GER' WHERE SecCode = 389009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475009411, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-05' WHERE SecCode = 389475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840913920, ExchCode = 'BER', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 389476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840901357, ExchCode = 'BER', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 389776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841550664, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 401619 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 = 21521224477, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 408562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674808, ExchCode = 'BIV' WHERE SecCode = 411789 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 = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 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 = 55859809796, ExchCode = 'UAX', PermQuoteRetireDate = '2016-02-05' WHERE SecCode = 433812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308332, ExchCode = 'GTX' WHERE SecCode = 434993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536204619, ExchCode = 'STU' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684650, ExchCode = 'DUS' WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951536.0 WHERE SecCode = 441473 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 450705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118826258, ExchCode = 'SIG' WHERE SecCode = 464174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 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 = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608722355, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 512041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681520, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388527, Ticker = 'PAXA.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 515577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851531713, ExchCode = 'GER' WHERE SecCode = 515658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837441656, Ticker = 'HOGS', ExchCode = 'MIL' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846578496, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 521901 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 = 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 = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852284014, ExchCode = 'BER' WHERE SecCode = 540241 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 = 21475529491, ExchCode = 'NGM', PermQuoteRetireDate = '2010-03-27' WHERE SecCode = 547513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853076828, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 549287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427744, ExchCode = 'STU' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853456463, ExchCode = 'STU' WHERE SecCode = 551262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503219887, ExchCode = 'STU' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480465, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 553799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858811523, ExchCode = 'FRA' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534813444, ExchCode = 'DUS' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 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 = 236804090704, ExchCode = 'HAM' WHERE SecCode = 559903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856811283, PermQuoteStatus = 'DC', Ticker = '7TM', ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 560717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856428988, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 564417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474958339, ExchCode = 'DEU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857579082, ExchCode = 'FRA' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962557, ExchCode = 'DEU' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126940, ExchCode = 'DEU' WHERE SecCode = 566528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036180, PermQuoteStatus = 'DC', Ticker = 'XLE', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 568823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704164, ExchCode = 'MXQ' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475793862, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 593104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954835919, ExchCode = 'DUS' WHERE SecCode = 597462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475660385, InstrPermID = 8590922012, OrgPermID = 4295880615, ValQuotePermID = 55837430854.0, PriInstrPermID = 8590922012.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'YFM', ExchCode = 'GER', PermQuoteRetireDate = '2010-03-29', PermOrgIPODate = NULL WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373202, ExchCode = 'DEU' WHERE SecCode = 607486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847342799, ExchCode = 'MUN' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863402759, Ticker = 'OCSP', ExchCode = 'LSE' WHERE SecCode = 649936 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 674803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 702439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 767311 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 806589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473248, ExchCode = 'DEU' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223887, ExchCode = 'QTX' WHERE SecCode = 909718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 934968 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-06' WHERE SecCode = 948508 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 956146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494701828, ExchCode = 'DEU' WHERE SecCode = 982229 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 = 22177710975, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-05', PermSecMapEndDate = NULL WHERE SecCode = 1111460 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 1211489 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 1226285 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 1254621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333716, ExchCode = 'FRA' WHERE SecCode = 1447581 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 PermOrgIPODate = NULL WHERE SecCode = 1459309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780007783, ExchCode = 'DUS' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 1464838 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951684.0 WHERE SecCode = 1471745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951684.0 WHERE SecCode = 1480991 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 1500817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642014, ExchCode = 'QTX' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705750, ExchCode = 'MXQ' WHERE SecCode = 1503061 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 = 55886089472, Ticker = 'LIME', ExchCode = 'MIL', PermQuoteRetireDate = '2019-09-17' WHERE SecCode = 1517254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032692, ExchCode = 'BCO', PermQuoteRetireDate = '2016-12-30' WHERE SecCode = 1518822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704850, ExchCode = 'MXQ' WHERE SecCode = 1518823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822168, ExchCode = 'FRA' WHERE SecCode = 1524540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489294362, ExchCode = 'STU', PermQuoteRetireDate = '2013-04-17' WHERE SecCode = 1525783 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 PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 1532756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768731670, ExchCode = 'DEU' WHERE SecCode = 1534950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492716295, ExchCode = 'STU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493901015, ExchCode = 'DEU' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766661889, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1538644 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 = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761654684, ExchCode = 'TDG' WHERE SecCode = 1544731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305592, ExchCode = 'GTX' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 1548451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583635015, ExchCode = 'DEU' WHERE SecCode = 1552943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508750705, ExchCode = 'STU' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498305313, ExchCode = 'FRA' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501629600, ExchCode = 'DEU' WHERE SecCode = 1572752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 1595946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529361618, ExchCode = 'STU' WHERE SecCode = 1618089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514317171, Ticker = 'FOI', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-22' WHERE SecCode = 1656381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504836182, Ticker = 'CHMT', ExchCode = 'PAR', PermQuoteRetireDate = '2017-04-25' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431677, ExchCode = 'DEU' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955323, ExchCode = 'DEU' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811337244, ExchCode = 'STU' WHERE SecCode = 1723207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513762717, ExchCode = 'FRA' WHERE SecCode = 1736071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295288, ExchCode = 'FRA' WHERE SecCode = 1768937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 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 = 21513751840, ExchCode = 'STU' WHERE SecCode = 1795399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860800, ExchCode = 'FRA' WHERE SecCode = 1905111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423685, ExchCode = 'FRA' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673265, ExchCode = 'BIV' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302126, ExchCode = 'STU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658940658, ExchCode = 'MUN' 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 = 236781581835, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-05' WHERE SecCode = 2162009 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 2204733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386834, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132401693, ExchCode = 'DEU' WHERE SecCode = 2333017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045908023, ExchCode = 'MEX' WHERE SecCode = 2337158 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951373.0 WHERE SecCode = 2357968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843587991, ExchCode = 'GTX' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 2380623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480719, ExchCode = 'QTX' WHERE SecCode = 2381585 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 PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 2391341 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 2396439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676625, ExchCode = 'BIV' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726959, ExchCode = 'GTX' WHERE SecCode = 2425600 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-05' WHERE SecCode = 2458784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753896162, ExchCode = 'DUS', PermQuoteRetireDate = '2020-10-27' WHERE SecCode = 2484919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536385132, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2487616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536651649, ExchCode = 'DEU' WHERE SecCode = 2487630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893352, ExchCode = 'TDG' WHERE SecCode = 2518731 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 = 21587574216, ExchCode = 'DEU' WHERE SecCode = 2536084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629786303, ExchCode = 'DEU' WHERE SecCode = 2539933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730461583, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-05' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541883360, ExchCode = 'MUN', PermQuoteRetireDate = '2015-05-22' WHERE SecCode = 2560597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368983, ExchCode = 'DEU', PermQuoteRetireDate = '2023-02-08', PermSecMapEndDate = '2023-02-08' WHERE SecCode = 2560601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541451510, ExchCode = 'FRA' WHERE SecCode = 2560605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821998, ExchCode = 'QTX' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782012631, ExchCode = 'FRA' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143048, ExchCode = 'DUS' WHERE SecCode = 2604393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651407157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369113, ExchCode = 'SGO' WHERE SecCode = 2625122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846693416, PermQuoteStatus = 'DC', Ticker = '14S', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-04' WHERE SecCode = 2625801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673317, ExchCode = 'BIV' WHERE SecCode = 2644179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840146, ExchCode = 'FRA' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 2682254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576623478, ExchCode = 'TDG' WHERE SecCode = 2694712 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697178 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697267 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697331 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 2697372 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2715169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553634480, Ticker = 'TUINl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-05-20' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 2755820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706109, Ticker = 'WFTN', ExchCode = 'MXQ' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 2770567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556863883, ExchCode = 'DEU' WHERE SecCode = 2784999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2846549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374532, ExchCode = 'FRA' WHERE SecCode = 2849922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428180, ExchCode = 'GTX' WHERE SecCode = 2887226 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2904316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957529794, ExchCode = 'QTX' WHERE SecCode = 2909909 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 2911861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493096, ExchCode = 'QTX' WHERE SecCode = 2919727 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2926784 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 2928725 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 2930937 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2936042 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2945266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165568, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2963479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570455715, ExchCode = 'DEU' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 2974275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 2988163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573048228, ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-12' WHERE SecCode = 2993543 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2998985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576175357, ExchCode = 'DEU' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 3032260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704230, ExchCode = 'MXQ' WHERE SecCode = 3040676 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 3043688 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3103524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679777, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 3199640 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 3201344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 3211362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235612, ExchCode = 'STU' WHERE SecCode = 3213268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748306921, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593186078, ExchCode = 'FRA' WHERE SecCode = 3223011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789234589, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3223076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999663, ExchCode = 'FRA' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3230844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594292935, ExchCode = 'FRA' WHERE SecCode = 3232615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806156912, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 3232617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749168, ExchCode = 'MUN' WHERE SecCode = 3236427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597232597, ExchCode = 'STU' WHERE SecCode = 3244393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589227699, ExchCode = 'FRA' WHERE SecCode = 3247556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758732894, ExchCode = 'STU' WHERE SecCode = 3254976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872298112, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-07', PermSecMapEndDate = NULL WHERE SecCode = 3256376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730025311, Ticker = '3660', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598163180, ExchCode = 'STU' WHERE SecCode = 3257550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645063133, ExchCode = 'FRA' WHERE SecCode = 3257551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684609, ExchCode = 'DUS' WHERE SecCode = 3259344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598409289, ExchCode = 'FRA', PermQuoteRetireDate = '2016-11-11' WHERE SecCode = 3260094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800110, ExchCode = 'CHI' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663194058, ExchCode = 'MEX' WHERE SecCode = 3271811 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 3275683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678970, ExchCode = 'BIV' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606771073, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3275862 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277076 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277195 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277232 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277316 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3281900 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3285945 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3287543 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3288678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 3295399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638239090, ExchCode = 'BCO' WHERE SecCode = 3301720 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 = 21688591127, ExchCode = 'STU' WHERE SecCode = 3305420 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 3316565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234907, ExchCode = 'BER' WHERE SecCode = 3317120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596834668, ExchCode = 'FRA' WHERE SecCode = 3317168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480017, ExchCode = 'QTX' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 3317674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211563, ExchCode = 'FRA' WHERE SecCode = 3317714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334888, ExchCode = 'DEU' WHERE SecCode = 3320079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632742048, ExchCode = 'MUN' WHERE SecCode = 3320375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704191, ExchCode = 'MXQ' WHERE SecCode = 3338588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643067252, ExchCode = 'TDG' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951389.0 WHERE SecCode = 3339794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621961481, Ticker = '4PSM', ExchCode = 'ETX' WHERE SecCode = 3347660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613758643, Ticker = 'BIOS', ExchCode = 'STO', PermQuoteRetireDate = '2024-01-12' WHERE SecCode = 3350742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220383, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3352147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761303085, ExchCode = 'STU' WHERE SecCode = 3358616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617014521, Ticker = '4EVK', ExchCode = 'ETX' WHERE SecCode = 3358919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22098741670, ExchCode = 'CHI' WHERE SecCode = 3359183 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 3366975 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3370814 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 = 21656674480, ExchCode = 'BIV' WHERE SecCode = 3385617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650199, ExchCode = 'DUS' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100894, ExchCode = 'DUS' WHERE SecCode = 3394481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169958746, ExchCode = 'DEU' WHERE SecCode = 3395352 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 3396227 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 3401656 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3403841 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3404208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720364251, ExchCode = 'STU' WHERE SecCode = 3404546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714657389, ExchCode = 'DEU' WHERE SecCode = 3405059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630627945, ExchCode = 'FRA' WHERE SecCode = 3405439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709687546, PermQuoteStatus = 'AC', Ticker = 'S060', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3406028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629642715, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3407252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800223463, ExchCode = 'LAS' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07', PermOrgIPODate = NULL WHERE SecCode = 3408851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662910528, ExchCode = 'FRA' WHERE SecCode = 3409176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839054723, ExchCode = 'FRA' WHERE SecCode = 3409178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21966768788, ExchCode = 'DEU' WHERE SecCode = 3409182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692729547, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-19', PermSecMapEndDate = '2023-01-19' WHERE SecCode = 3409186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156172163, ExchCode = 'DEU' WHERE SecCode = 3409193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801287178, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905907543, ExchCode = 'GTX' WHERE SecCode = 3424652 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 3429803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100439, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780224, ExchCode = 'FRA' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3432050 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3432656 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3436953 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 3438134 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3438326 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3438600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374586, ExchCode = 'FRA' WHERE SecCode = 3438919 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3438944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997874, ExchCode = 'DEU' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796441340, ExchCode = 'HAM' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643680223, ExchCode = 'BER' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 3440355 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951807.0 WHERE SecCode = 3440406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 3441675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643703119, ExchCode = 'DEU' WHERE SecCode = 3444720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645193054, ExchCode = 'DEU' WHERE SecCode = 3446352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137715, Ticker = 'REL0', ExchCode = 'BER', PermQuoteRetireDate = '2023-06-01' WHERE SecCode = 3510596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308229, ExchCode = 'GTX' WHERE SecCode = 3513998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645825, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-01', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3534901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953341540, ExchCode = 'MUN' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 3562840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997896, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-08', PermSecMapEndDate = '2023-06-08' WHERE SecCode = 3565802 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3566698 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3576742 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 = 21559909557, ExchCode = 'TDG' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609218, ExchCode = 'FRA' WHERE SecCode = 3588082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609512, ExchCode = 'DEU' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666113143, ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515091, ExchCode = 'QTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 3623818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783311, ExchCode = 'HAM' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3665631 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2018-11-21' WHERE SecCode = 3668408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878191304, ExchCode = 'SIU' WHERE SecCode = 3669924 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 3716811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727384183, ExchCode = 'MEX' WHERE SecCode = 3717243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680901263, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 3738158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431622, ExchCode = 'FRA' WHERE SecCode = 3749056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 3776472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782434084, ExchCode = 'STU' WHERE SecCode = 3784223 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3787382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3793438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376479, ExchCode = 'MEX' WHERE SecCode = 3793509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196448, ExchCode = 'DUS' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700747267, ExchCode = 'TDG' WHERE SecCode = 3873935 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 = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806467, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3894966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773918983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3899638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 3929432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679348107, ExchCode = 'BIV' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595121619, ExchCode = 'MUN' WHERE SecCode = 3936141 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3941092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711927625, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3980851 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4003426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4029441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951786.0 WHERE SecCode = 4043054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727357679, ExchCode = 'MEX' WHERE SecCode = 4049099 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4066178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733749402, ExchCode = 'DEU' WHERE SecCode = 4094236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019485, ExchCode = 'FRA' WHERE SecCode = 4101141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976129, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815144829, Ticker = '49Y', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097198, ExchCode = 'LAS' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958505, ExchCode = 'FRA' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727384184, ExchCode = 'BIV' WHERE SecCode = 4201830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747487294, ExchCode = 'BER', PermQuoteRetireDate = '2022-09-27', PermSecMapEndDate = '2022-09-27' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4212247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350455, ExchCode = 'MEX' WHERE SecCode = 4212368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349453, ExchCode = 'BIV' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749843263, ExchCode = 'DEU' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752247650, ExchCode = 'FRA' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4261223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056950, ExchCode = 'DUS' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487599, ExchCode = 'QTX' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4278879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, PermQuoteStatus = 'AC', Ticker = '9EG0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011157, Ticker = '2SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143914, Ticker = '2TKWY', ExchCode = 'MIL' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010963, Ticker = '2AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011282, Ticker = '2NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143959, Ticker = '2RMS', ExchCode = 'MIL' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143858, Ticker = '2ASM', ExchCode = 'MIL' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012280, Ticker = '2FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432057, ExchCode = 'DEU' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4319483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763722641, ExchCode = 'DUS' WHERE SecCode = 4324504 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4335841 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 4339225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799675, ExchCode = 'HAM' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606711, ExchCode = 'FRA' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510749, ExchCode = 'DUS' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122676110, ExchCode = 'DEU' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 4382911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 4423831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 4424438 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4429633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 4436942 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4443939 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4444652 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 PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4451140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689536, ExchCode = 'DEU' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4463165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060560, ExchCode = 'STU' WHERE SecCode = 4472910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334890, ExchCode = 'FRA', PermQuoteRetireDate = '2024-06-27' WHERE SecCode = 4472931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781158026, ExchCode = 'STU' WHERE SecCode = 4474245 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4474391 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4474394 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 4476768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794808262, ExchCode = 'STU' WHERE SecCode = 4479188 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4479287 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4482723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780165906, ExchCode = 'MXQ' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285966, ExchCode = 'GTX' WHERE SecCode = 4505789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066618, ExchCode = 'DEU' WHERE SecCode = 4517642 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 4517656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829968, ExchCode = 'QTX' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, Ticker = '0RW0', ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-06' WHERE SecCode = 4565429 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4566919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22076466680, Ticker = 'XLMEd', ExchCode = 'BCO' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4586547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379572, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4598716 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4601734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138518181, ExchCode = 'BCO' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778677427, ExchCode = 'QTX' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782629839, ExchCode = 'STU' WHERE SecCode = 4633100 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 4633108 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4636576 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4648185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825617109, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2018-11-21' WHERE SecCode = 4654456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848696115, ExchCode = 'GTX' WHERE SecCode = 4658662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388759, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4658881 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 4659834 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4677475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727293350, ExchCode = 'MEX' WHERE SecCode = 4699231 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4705695 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '7IB' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890430, ExchCode = 'FRA' WHERE SecCode = 4709618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842933521, ExchCode = 'FRA' WHERE SecCode = 4716089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842933962, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4716090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954835, ExchCode = 'LAS' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381561, ExchCode = 'STU' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843597790, ExchCode = 'FRA' WHERE SecCode = 4722188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844719378, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531907, ExchCode = 'MUN' WHERE SecCode = 4724688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076876, ExchCode = 'FRA' WHERE SecCode = 4724746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845567605, ExchCode = 'GTX' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846049961, ExchCode = 'DEU' WHERE SecCode = 4727660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850866652, ExchCode = 'TDG' WHERE SecCode = 4733055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852735329, ExchCode = 'FRA' WHERE SecCode = 4756369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853886915, ExchCode = 'DUS' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 4761548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932244742, ExchCode = 'BCO' WHERE SecCode = 4761550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887138, ExchCode = 'GTX' WHERE SecCode = 4761589 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ESP' WHERE SecCode = 4767842 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ESP' WHERE SecCode = 4767843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795665928, ExchCode = 'FRA' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722496, ExchCode = 'MUN' WHERE SecCode = 4775201 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ESP' WHERE SecCode = 4777234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 4792275 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 4794547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546869, ExchCode = 'DEU' WHERE SecCode = 4794550 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 4808862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231064, ExchCode = 'BCO' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241331, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-03' WHERE SecCode = 4815315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684618, ExchCode = 'DUS' WHERE SecCode = 4818275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684866, ExchCode = 'QTX' WHERE SecCode = 4819649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 4819878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874018782, ExchCode = 'QTX' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869325911, ExchCode = 'STU' WHERE SecCode = 4848926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876833037, PermQuoteStatus = 'DC', Ticker = '57Z0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-01' WHERE SecCode = 4848927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871894898, ExchCode = 'DEU' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380531, ExchCode = 'LAS' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656927, ExchCode = 'FRA' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388746, ExchCode = 'LAS' WHERE SecCode = 4927268 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 4929225 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 4938311 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 4938797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953078, ExchCode = 'FRA' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897338416, ExchCode = 'DEU' WHERE SecCode = 5025182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 5045192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778559109, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-05', PermSecMapEndDate = NULL WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031229, ExchCode = 'STU' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238786, ExchCode = 'LAS' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729398003, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-31' WHERE SecCode = 5099028 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 = 236784388850, ExchCode = 'LAS' WHERE SecCode = 5119165 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 = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755973706, ExchCode = 'DUS' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634298479, Ticker = '0IL1l', ExchCode = 'BCO' WHERE SecCode = 5161361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 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 = 236781569896, ExchCode = 'QTX' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, ExchCode = 'DUS' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5168302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234849, ExchCode = 'QTX' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397388, ExchCode = 'GTX' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904165, ExchCode = 'BCO' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 5215832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035916, PermQuoteStatus = 'AC', Ticker = '5KBA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5223426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388873, ExchCode = 'LAS' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227059, ExchCode = 'MEX' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132645, ExchCode = 'FRA' WHERE SecCode = 5258611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 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 = 22105049596, ExchCode = 'MXQ' WHERE SecCode = 5323925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054509, ExchCode = 'FRA' WHERE SecCode = 5324085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732426, ExchCode = 'BIV' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777670944, ExchCode = 'FRA' WHERE SecCode = 5354973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5360835 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2023-03-17' WHERE SecCode = 5366265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960776871, ExchCode = 'STU' WHERE SecCode = 5387257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996696, ExchCode = 'LAS' WHERE SecCode = 5403242 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2023-06-22' WHERE SecCode = 5449616 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2023-06-23' WHERE SecCode = 5450886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729656, ExchCode = 'DEU' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951167.0 WHERE SecCode = 5495252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449510, ExchCode = 'BCO' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951167.0 WHERE SecCode = 5526257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5527521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309034, ExchCode = 'MUN' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988984185, ExchCode = 'DEU' WHERE SecCode = 5527561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836259, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471184, ExchCode = 'BIV' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 5544127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471180, ExchCode = 'MEX' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NGA' WHERE SecCode = 5556262 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5565405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834791, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512254, Ticker = '3SQEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5569214 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 = 21970566091, ExchCode = 'FRA' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951768.0 WHERE SecCode = 5597635 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5610077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781224681, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951768.0 WHERE SecCode = 5632224 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5635837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521787, ExchCode = 'MUN', PermQuoteRetireDate = '2023-09-11' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830325, ExchCode = 'GER', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' 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 = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381254, ExchCode = 'QTX' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379581, ExchCode = 'LAS' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419156, ExchCode = 'LAS' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783112234, ExchCode = 'FRA' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181433, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153233, Ticker = 'RZ8Bd', ExchCode = 'BCO' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040671244, ExchCode = 'MUN' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783330017, ExchCode = 'FRA' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329733, ExchCode = 'FRA' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353647, ExchCode = 'FRA' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353632, ExchCode = 'FRA' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353639, ExchCode = 'FRA' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5807801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207229, ExchCode = 'FRA' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784278056, ExchCode = 'STU' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784326338, ExchCode = 'STU' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327232, ExchCode = 'FRA' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786494467, ExchCode = 'GTX' WHERE SecCode = 5871394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735452563, ExchCode = 'DEU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801352002, ExchCode = 'GTX' WHERE SecCode = 5894957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386725, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-25', PermSecMapEndDate = '2025-04-25' WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22058332105, ExchCode = 'DEU' WHERE SecCode = 5914176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784960655, ExchCode = 'BIV' WHERE SecCode = 5917759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784315655, ExchCode = 'BIV' WHERE SecCode = 5917882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061495886, ExchCode = 'GTX' WHERE SecCode = 5920851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786490279, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 5931956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788145983, Ticker = '7YGd', ExchCode = 'BCO' WHERE SecCode = 5949087 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5950388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071312228, ExchCode = 'DEU' WHERE SecCode = 6001792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 6006779 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 6006780 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2024-12-13' WHERE SecCode = 6039879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789141811, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6050973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789380440, ExchCode = 'GTX' WHERE SecCode = 6065904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414416, ExchCode = 'STU' WHERE SecCode = 6065905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111007, Ticker = 'BITCl', ExchCode = 'CHI' 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 = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110948, Ticker = '3GFMm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 6097282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835874, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679771, ExchCode = 'BIV' WHERE SecCode = 6097292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827614120, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421443, PermQuoteStatus = 'AC', Ticker = '3LAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6097345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784422711, ExchCode = 'MEX' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866394208, Ticker = '3SAM', ExchCode = 'MIL', PermQuoteRetireDate = '2025-10-07' WHERE SecCode = 6097566 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 6128384 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 6134755 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6134771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790414815, ExchCode = 'TDG' WHERE SecCode = 6141518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089000964, ExchCode = 'DEU' WHERE SecCode = 6147594 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 = 21896580182, ExchCode = 'DUS' WHERE SecCode = 6256405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181397, ExchCode = 'BIV' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801123684, ExchCode = 'FRA' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760171626, PermQuoteStatus = 'DC', Ticker = '0BF1', ExchCode = 'STU', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 6256419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798226363, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6256420 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 = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988435, ExchCode = 'GTX' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '0TO0', PermSecMapEndDate = NULL WHERE SecCode = 6315242 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 6322268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 6342569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745448, ExchCode = 'BIV' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515593, ExchCode = 'BIV' WHERE SecCode = 6394335 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 6429300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125348556, ExchCode = 'DEU' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182771, ExchCode = 'FRA' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 6450942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451435, ExchCode = 'CHI' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158030, ExchCode = 'CHI' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231077, ExchCode = 'BCO' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158021, ExchCode = 'CHI' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703201, ExchCode = 'CHI' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451434, ExchCode = 'CHI' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447621, ExchCode = 'CHI' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158040, ExchCode = 'CHI' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451424, ExchCode = 'CHI' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703193, ExchCode = 'CHI' WHERE SecCode = 6456420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128988769, ExchCode = 'DEU' WHERE SecCode = 6464979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 6564729 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 6567895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799222850, ExchCode = 'FRA' WHERE SecCode = 6567972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799223233, ExchCode = 'FRA' WHERE SecCode = 6567975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379501, Ticker = 'KOG', ExchCode = 'BRN' WHERE SecCode = 6578370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800600234, ExchCode = 'FRA' WHERE SecCode = 6603604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800600235, ExchCode = 'FRA' WHERE SecCode = 6603609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800600233, ExchCode = 'FRA' WHERE SecCode = 6603626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541597, ExchCode = 'FRA' WHERE SecCode = 6627152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541595, ExchCode = 'FRA' WHERE SecCode = 6627153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541760, ExchCode = 'FRA' WHERE SecCode = 6627155 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951330.0 WHERE SecCode = 6628822 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6708236 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6708237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804168529, ExchCode = 'STU' WHERE SecCode = 6712480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805777614, ExchCode = 'GTX' WHERE SecCode = 6716126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165601283, ExchCode = 'DEU' WHERE SecCode = 6716128 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6721469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162501, ExchCode = 'STU' WHERE SecCode = 6756491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805232354, ExchCode = 'FRA' WHERE SecCode = 6756496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805232359, ExchCode = 'FRA' WHERE SecCode = 6756497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237572, ExchCode = 'FRA' WHERE SecCode = 6756501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237865, ExchCode = 'FRA' WHERE SecCode = 6756502 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-06', PermSecMapEndDate = '2026-05-06' WHERE SecCode = 6762055 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-06', PermSecMapEndDate = '2026-05-06' WHERE SecCode = 6762076 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6765361 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6786554 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'KAO', QuoteClass = 'FULLPAID', PermOrgIPODate = '2026-05-07' WHERE SecCode = 6789483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6796817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805997199, ExchCode = 'MEX' WHERE SecCode = 6802699 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-06', PermSecMapEndDate = '2026-05-06' WHERE SecCode = 6808801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176033356, Ticker = 'EASD', ExchCode = 'LSE' WHERE SecCode = 6813403 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6813824 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6813825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806641027, ExchCode = 'QTX' WHERE SecCode = 6813912 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10784521 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10813302 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10870569 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10892565 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10901062 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10985477 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG', IncCntry = 'MHL' WHERE SecCode = 10987202 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11000594 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 11009432 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11028207 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11041243 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 11056107 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 11060284 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951684.0 WHERE SecCode = 11060528 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 11060614 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11064300 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CWLK' WHERE SecCode = 11075935 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11129287 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 11129748 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG', IncCntry = 'MHL' WHERE SecCode = 11132846 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'MANU' WHERE SecCode = 11135477 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 11149752 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 11160239 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 11160913 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 11172359 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG', IncCntry = 'MHL' WHERE SecCode = 11177762 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 11177774 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11180158 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11180612 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11205402 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11209450 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11211046 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951786.0 WHERE SecCode = 11211391 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-06' WHERE SecCode = 11218773 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11219078 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11222174 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 11222398 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11222469 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 11226872 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11232101 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11246642 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951389.0 WHERE SecCode = 11254376 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 11259811 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11261898 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11261939 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 11262594 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 11270393 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MSWXS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-05', PermSecMapEndDate = NULL WHERE SecCode = 11276578 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 11279687 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 11286425 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-06', PermSecMapEndDate = '2026-05-06' WHERE SecCode = 11287890 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290009 AND Type_ = 1;
