UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 7504 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 9451 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 23221 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 31464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475800397, Ticker = 'ANFp', ExchCode = 'SIG', PermQuoteRetireDate = '2012-12-10' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384262, ExchCode = 'LAS' WHERE SecCode = 34055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475423921, ExchCode = 'GER', PermQuoteRetireDate = '2007-07-11' WHERE SecCode = 34147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848820360, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 34184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386343, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-31' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, ExchCode = 'DEU' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921478929, ExchCode = 'GTX' WHERE SecCode = 35017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525094145, ExchCode = 'BTE' WHERE SecCode = 35316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475405466, ExchCode = 'STU' WHERE SecCode = 35324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610381383, ExchCode = 'FRA' WHERE SecCode = 35393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475445913, ExchCode = 'MUN' WHERE SecCode = 35412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357436, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486226, ExchCode = 'QTX' WHERE SecCode = 35419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488307, ExchCode = 'QTX' WHERE SecCode = 35457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356497, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475509177, Ticker = 'CRH.I', ExchCode = 'CIR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 36926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516304827, ExchCode = 'STU', PermQuoteRetireDate = '2016-08-01', PermSecMapEndDate = '2016-08-02' WHERE SecCode = 36930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488971, ExchCode = 'QTX' WHERE SecCode = 36936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006577, ExchCode = 'STU' WHERE SecCode = 36943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478511620, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 37067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843452886, ExchCode = 'MUN' WHERE SecCode = 37118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394031, ExchCode = 'FRA' WHERE SecCode = 37133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325940, ExchCode = 'BER' WHERE SecCode = 37139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475437296, ExchCode = 'STU' WHERE SecCode = 37861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394062, ExchCode = 'FRA', PermQuoteRetireDate = '2008-08-29' WHERE SecCode = 38185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661362178, ExchCode = 'STU' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585187542, ExchCode = 'HAM' WHERE SecCode = 38248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339290, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 38887 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 43286 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 43441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853561637, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837360180, ExchCode = 'GER' WHERE SecCode = 46009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475275707, ExchCode = 'FRA' WHERE SecCode = 46026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838652164, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-16' WHERE SecCode = 46294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792268563, PermQuoteStatus = 'AC', Ticker = 'GVM0', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 46388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325490, ExchCode = 'BER', PermQuoteRetireDate = '2010-04-30' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836582583, ExchCode = 'FRA' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384265, ExchCode = 'LAS' WHERE SecCode = 48350 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CGNO' WHERE SecCode = 51276 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836337633, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-04-12', PermSecMapEndDate = '2019-04-12' WHERE SecCode = 51563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742530, ExchCode = 'HAN' WHERE SecCode = 51564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835783639, PermQuoteStatus = 'AC', Ticker = 'TPIG', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 53479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332265, ExchCode = 'BER', PermQuoteRetireDate = '2011-11-02' WHERE SecCode = 53520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417008, ExchCode = 'MUN', PermQuoteRetireDate = '2009-11-19' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034431, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 54890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487990, ExchCode = 'QTX' WHERE SecCode = 55581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491972, ExchCode = 'QTX' WHERE SecCode = 55585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501625448, ExchCode = 'TDG' WHERE SecCode = 55696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296112, ExchCode = 'GTX' WHERE SecCode = 55763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837361015, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 55770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837352642, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 59989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837365688, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196451, ExchCode = 'DUS' WHERE SecCode = 60024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838483366, ExchCode = 'STU', PermQuoteRetireDate = '2011-06-07' WHERE SecCode = 60061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390772, ExchCode = 'FRA', PermQuoteRetireDate = '2011-05-30' WHERE SecCode = 60117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358186, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238403, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 60133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354687, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842305273, ExchCode = 'STU' WHERE SecCode = 60190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836439407, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836401420, ExchCode = 'FRA' WHERE SecCode = 60236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382644, ExchCode = 'LAS' WHERE SecCode = 60247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837367153, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243010, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 60261 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 = 55836342032, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 60328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240620, ExchCode = 'MUN', PermQuoteRetireDate = '2012-07-03' WHERE SecCode = 60381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427368, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836409944, ExchCode = 'FRA' WHERE SecCode = 60398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243859, ExchCode = 'MUN', PermQuoteRetireDate = '2008-09-08' WHERE SecCode = 60559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836519545, ExchCode = 'FRA' WHERE SecCode = 60569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837362145, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475277730, ExchCode = 'BER', PermQuoteRetireDate = '2006-12-02' WHERE SecCode = 60644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790766, ExchCode = 'GTX' WHERE SecCode = 60683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359160, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936139, ExchCode = 'STU' WHERE SecCode = 60844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524419, ExchCode = 'FRA' WHERE SecCode = 60903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381445, ExchCode = 'LAS' WHERE SecCode = 61006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846063874, ExchCode = 'GER' WHERE SecCode = 61281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601556166, ExchCode = 'STU' WHERE SecCode = 61371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355003, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355176, ExchCode = 'GER' WHERE SecCode = 61599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518822, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 61867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339535, ExchCode = 'BER' WHERE SecCode = 62165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784543361, ExchCode = 'BER' WHERE SecCode = 62300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475607241, PermQuoteStatus = 'DC', Ticker = 'AKDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 62376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338868, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-26', PermSecMapEndDate = '2024-07-26' WHERE SecCode = 62386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797354122, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2021-02-18' WHERE SecCode = 62430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859357628, ExchCode = 'STU' WHERE SecCode = 62434 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 = 21856722233, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-05', PermSecMapEndDate = '2023-01-05' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035283, PermQuoteStatus = 'AC', Ticker = 'NEQ', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 62765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339751, PermQuoteStatus = 'DC', Ticker = 'YUI', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 63767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036125, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 63781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488554, ExchCode = 'QTX' WHERE SecCode = 63834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836559611, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2012-01-05' WHERE SecCode = 63854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620987437, ExchCode = 'MUN' WHERE SecCode = 63859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223856, ExchCode = 'QTX' WHERE SecCode = 63875 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 66382 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-26' WHERE SecCode = 70899 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 71866 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951443.0 WHERE SecCode = 74496 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 77512 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951444.0 WHERE SecCode = 77966 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483761938, ExchCode = 'CHA' WHERE SecCode = 80783 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 86007 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 89699 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 90236 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100312 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 104530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641631, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241914, ExchCode = 'MUN' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589493827, ExchCode = 'STU' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295813, ExchCode = 'GTX' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338263, ExchCode = 'BER' WHERE SecCode = 112049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334705, ExchCode = 'BER' WHERE SecCode = 112064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661189712, ExchCode = 'DEU' WHERE SecCode = 112078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786286858, ExchCode = 'QTX' WHERE SecCode = 112079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750431812, ExchCode = 'MUN' WHERE SecCode = 112129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557034633, ExchCode = 'FRA' WHERE SecCode = 112135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179805, ExchCode = 'FRA' WHERE SecCode = 112143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085576, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 115826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298313, ExchCode = 'DUS' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 121153 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 125674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123504, ExchCode = 'FRA' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173501, Ticker = 'ESL', ExchCode = 'BRN' WHERE SecCode = 126877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329157, ExchCode = 'BER' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909445, ExchCode = 'FRA' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525792698, ExchCode = 'DEU' WHERE SecCode = 131777 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 132273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488284, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 134041 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 140104 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 140452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475646219, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 140628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476850765, ExchCode = 'TDG', PermQuoteRetireDate = '2018-11-01' WHERE SecCode = 140635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634298080, Ticker = '0Y9Sl', ExchCode = 'BCO' WHERE SecCode = 143694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782711, ExchCode = 'DUS' WHERE SecCode = 144300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787407, ExchCode = 'DUS' WHERE SecCode = 144320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664445764, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302347, PermQuoteStatus = 'DC', Ticker = 'TMS.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 144414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330935, ExchCode = 'BER' WHERE SecCode = 144437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337718, ExchCode = 'BER' WHERE SecCode = 144438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327294, ExchCode = 'BER' WHERE SecCode = 144439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777643087, ExchCode = 'BER' WHERE SecCode = 144440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623456805, ExchCode = 'DEU' WHERE SecCode = 144526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532071663, ExchCode = 'MUN', PermQuoteRetireDate = '2014-12-15' WHERE SecCode = 144542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537703084, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 145644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332880, Ticker = 'MC2', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 147455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334527, PermQuoteStatus = 'DC', Ticker = 'NGQ', ExchCode = 'BER', PermQuoteRetireDate = '2012-11-05' WHERE SecCode = 150515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329583, ExchCode = 'BER' WHERE SecCode = 166414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288493, ExchCode = 'DEU' WHERE SecCode = 174875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538829900, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334831, ExchCode = 'BER' WHERE SecCode = 177257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, ExchCode = 'FRA' WHERE SecCode = 177280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335207, ExchCode = 'BER' WHERE SecCode = 177315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856949141, ExchCode = 'FRA' WHERE SecCode = 177328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357816, ExchCode = 'GER' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593612748, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 178303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330114, ExchCode = 'BER', PermQuoteRetireDate = '2022-05-26' WHERE SecCode = 179031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294096, ExchCode = 'GTX' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536548828, ExchCode = 'FRA' WHERE SecCode = 186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 249282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616062980, ExchCode = 'TDG' WHERE SecCode = 249355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396050, ExchCode = 'FRA' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957755807, ExchCode = 'STU' WHERE SecCode = 249438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754447, ExchCode = 'MUN' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474978890, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 249834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'QCLS' WHERE SecCode = 270236 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21749838939, ExchCode = 'FRA' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 289513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373387, ExchCode = 'FRA' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 292691 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21535831862, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 292973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897985709, ExchCode = 'FRA' WHERE SecCode = 292976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, ExchCode = 'BER' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-24', PermSecMapEndDate = NULL WHERE SecCode = 323913 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 324467 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MRRFF', PermQuoteRetireDate = NULL WHERE SecCode = 329345 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'HWNI' WHERE SecCode = 334898 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 336138 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 336183 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PTOPD' WHERE SecCode = 351030 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836348908, ExchCode = 'FRA' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 402824 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 521804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 545505 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 556904 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5052139680, PriInstrPermID = NULL, IsPrimaryInstr = 0, OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951322.0, PermOrgIPODate = NULL WHERE SecCode = 580355 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 624469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 654389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863005195, Ticker = 'BABC', ExchCode = 'LSE' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275427, ExchCode = 'GTX' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 935785 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 1194052 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 1202895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996312, ExchCode = 'MUN' WHERE SecCode = 1303639 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 1459433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828343336, ExchCode = 'QTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428233, ExchCode = 'GTX' WHERE SecCode = 2050473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544843699, ExchCode = 'FRA' WHERE SecCode = 2055322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22052571394, ExchCode = 'DEU' WHERE SecCode = 2087993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521253950, ExchCode = 'STU' WHERE SecCode = 2195784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369738, ExchCode = 'BEC' WHERE SecCode = 2232870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820384482, Ticker = 'XDN0l', ExchCode = 'BCO' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322146, ExchCode = 'DEU' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503527105, ExchCode = 'MEX' WHERE SecCode = 2812150 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2861758 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2880948 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 2885891 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2910685 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 2945266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991661, ExchCode = 'FRA' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916283660, ExchCode = 'BER' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 3144525 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096759409 WHERE SecCode = 3177770 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = NULL, IsPrimaryQuote = 0 WHERE SecCode = 3184000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3266303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' 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 PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 3276270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835371, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 3301728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616206400, ExchCode = 'DEU' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 3408950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884570, ExchCode = 'MUN' WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644441070, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2025-05-02' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 3434600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640834967, ExchCode = 'FRA' WHERE SecCode = 3434745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679819, ExchCode = 'BIV' WHERE SecCode = 3434746 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951428.0 WHERE SecCode = 3441679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 3526140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3716979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840047415, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 3736025 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'S5B0', PermSecMapEndDate = NULL WHERE SecCode = 3756335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388260, ExchCode = 'LAS' WHERE SecCode = 3851567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699218063, ExchCode = 'FRA' WHERE SecCode = 3862230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369830, ExchCode = 'BIV' WHERE SecCode = 3868466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016561, ExchCode = 'MUN' WHERE SecCode = 3881153 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 = 21705375051, ExchCode = 'BER', PermQuoteRetireDate = '2024-06-24' WHERE SecCode = 3894967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725178113, ExchCode = 'BER' WHERE SecCode = 3956835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924367856, ExchCode = 'GTX' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718457595, ExchCode = 'STU' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725610707, ExchCode = 'FRA' WHERE SecCode = 4043316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753896308, ExchCode = 'MUN' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738262837, Ticker = '5C8', ExchCode = 'FRA' WHERE SecCode = 4090028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966439, ExchCode = 'FRA' WHERE SecCode = 4124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966716, ExchCode = 'FRA' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963695, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4212247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486435, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388481, ExchCode = 'LAS' WHERE SecCode = 4248831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754193828, ExchCode = 'STU' WHERE SecCode = 4251502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518785, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 4282397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295374, ExchCode = 'GTX' WHERE SecCode = 4310575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580130, ExchCode = 'FRA' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '5J40', PermSecMapEndDate = NULL WHERE SecCode = 4319661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791872343, ExchCode = 'FRA' WHERE SecCode = 4341660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768600657, ExchCode = 'FRA' WHERE SecCode = 4346650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767996950, ExchCode = 'FRA' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768596580, ExchCode = 'TDG' WHERE SecCode = 4351435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775812436, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-09' WHERE SecCode = 4385267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776573519, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-30' WHERE SecCode = 4388204 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 4388410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991935, ExchCode = 'FRA' WHERE SecCode = 4391296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281522, ExchCode = 'STU', PermQuoteRetireDate = '2025-03-14' WHERE SecCode = 4394756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS', PermQuoteRetireDate = '2022-05-31', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782177869, ExchCode = 'DEU' WHERE SecCode = 4404026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307328, ExchCode = 'BIV' WHERE SecCode = 4422396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337110, ExchCode = 'DEU' WHERE SecCode = 4423907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779047734, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783641143, ExchCode = 'BER' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786088087, ExchCode = 'BER' WHERE SecCode = 4438384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384193, ExchCode = 'LAS' WHERE SecCode = 4456099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791932285, ExchCode = 'DUS' WHERE SecCode = 4462870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380479, ExchCode = 'LAS' WHERE SecCode = 4472911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388562, ExchCode = 'LAS' WHERE SecCode = 4472933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674438, ExchCode = 'DUS' WHERE SecCode = 4472940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386726, ExchCode = 'LAS' WHERE SecCode = 4474387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815902455, ExchCode = 'STU' WHERE SecCode = 4477048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794808195, ExchCode = 'STU' WHERE SecCode = 4479186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794654351, ExchCode = 'FRA' WHERE SecCode = 4479279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-30', PermSecMapEndDate = NULL WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264731, ExchCode = 'MUN' WHERE SecCode = 4485993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287355, ExchCode = 'BIV' WHERE SecCode = 4505578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794711480, ExchCode = 'LAS' WHERE SecCode = 4505788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409276, ExchCode = 'DEU' WHERE SecCode = 4505803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800437894, ExchCode = 'MUN' WHERE SecCode = 4511507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, ExchCode = 'GTX' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886801843, ExchCode = 'GTX' WHERE SecCode = 4557762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141787, ExchCode = 'STU' WHERE SecCode = 4557929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223513, ExchCode = 'FRA' WHERE SecCode = 4568460 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 4575118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854765, ExchCode = 'DEU' WHERE SecCode = 4579661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854709, ExchCode = 'FRA' WHERE SecCode = 4579663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991551, ExchCode = 'DEU' WHERE SecCode = 4579688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811992005, ExchCode = 'FRA' WHERE SecCode = 4586561 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = NULL WHERE SecCode = 4588275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145875, ExchCode = 'TDG' WHERE SecCode = 4592046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177254, ExchCode = 'DEU' WHERE SecCode = 4592047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515358, ExchCode = 'GTX' WHERE SecCode = 4593304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957273972, ExchCode = 'BER' WHERE SecCode = 4595746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850700597, ExchCode = 'STU' WHERE SecCode = 4595786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153723, ExchCode = 'FRA' WHERE SecCode = 4601827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385303, ExchCode = 'LAS' WHERE SecCode = 4601892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817233505, ExchCode = 'FRA' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849048208, PermQuoteStatus = 'DC', Ticker = '890', ExchCode = 'TDG', PermQuoteRetireDate = '2021-12-17' WHERE SecCode = 4610043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817039347, Ticker = 'ABTC', ExchCode = 'AEX' WHERE SecCode = 4613095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818256303, ExchCode = 'STU' WHERE SecCode = 4617716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888689541, ExchCode = 'STU' WHERE SecCode = 4620159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713411, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-21', PermSecMapEndDate = '2021-06-21' WHERE SecCode = 4631952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849497, ExchCode = 'FRA' WHERE SecCode = 4633101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849335, ExchCode = 'FRA' WHERE SecCode = 4633105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822562044, ExchCode = 'DEU' WHERE SecCode = 4636547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954590855, ExchCode = 'STU' WHERE SecCode = 4639567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823512839, ExchCode = 'FRA' WHERE SecCode = 4640286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823808235, ExchCode = 'DEU' WHERE SecCode = 4643066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380595, ExchCode = 'LAS' WHERE SecCode = 4650007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047430, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-01' WHERE SecCode = 4661400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890239, ExchCode = 'FRA' WHERE SecCode = 4662619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414736, ExchCode = 'LAS' WHERE SecCode = 4671288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727247063, ExchCode = 'MEX' WHERE SecCode = 4671296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911881123, ExchCode = 'DEU' WHERE SecCode = 4677626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833427447, ExchCode = 'DEU' WHERE SecCode = 4680380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795801694, ExchCode = 'FRA' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837529040, ExchCode = 'GER' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841739063, ExchCode = 'STU' WHERE SecCode = 4695820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037563, PermQuoteStatus = 'DC', Ticker = 'LUH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-12-13' WHERE SecCode = 4702654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581874, ExchCode = 'QTX' WHERE SecCode = 4707177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890563, ExchCode = 'DEU' WHERE SecCode = 4709614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329726, ExchCode = 'QTX' WHERE SecCode = 4709615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908294, ExchCode = 'DUS' WHERE SecCode = 4717140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846029349, ExchCode = 'BER' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777507077, ExchCode = 'STU' WHERE SecCode = 4722143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788449235, ExchCode = 'TDG' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847343480, ExchCode = 'GTX' WHERE SecCode = 4730169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893303439, ExchCode = 'MUN' WHERE SecCode = 4745390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345317, ExchCode = 'STU' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867533, ExchCode = 'DEU' WHERE SecCode = 4752212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851844389, ExchCode = 'DUS' WHERE SecCode = 4752241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727224773, ExchCode = 'BIV' WHERE SecCode = 4753728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381821, ExchCode = 'LAS' WHERE SecCode = 4754868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852738501, ExchCode = 'DEU' WHERE SecCode = 4756507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853429898, ExchCode = 'MUN' WHERE SecCode = 4756620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689585, ExchCode = 'DXE' WHERE SecCode = 4761548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518118, ExchCode = 'DEU' WHERE SecCode = 4775200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722496, ExchCode = 'MUN' WHERE SecCode = 4775201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615485, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4800489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860307416, ExchCode = 'TDG' WHERE SecCode = 4800673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862297960, ExchCode = 'FRA' WHERE SecCode = 4811143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628121, ExchCode = 'DUS' WHERE SecCode = 4813698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212163, ExchCode = 'BIV' WHERE SecCode = 4827941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861142799, ExchCode = 'FRA' WHERE SecCode = 4829216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858571, ExchCode = 'QTX' WHERE SecCode = 4830962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953884, ExchCode = 'MUN', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792865438, ExchCode = 'GTX' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398299, ExchCode = 'FRA', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580391, ExchCode = 'FRA' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778036716, ExchCode = 'MUN' WHERE SecCode = 4862983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003870, ExchCode = 'STU' WHERE SecCode = 4863020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783749213, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 4887111 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 4895650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878356554, ExchCode = 'DEU' WHERE SecCode = 4911199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881260859, ExchCode = 'STU' WHERE SecCode = 4925667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882166780, ExchCode = 'BER', PermQuoteRetireDate = '2022-03-28', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883533876, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4938296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875594, ExchCode = 'MUN' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951554681, ExchCode = 'STU' WHERE SecCode = 4958004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888704331, PermQuoteStatus = 'AC', Ticker = 'V6M1', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577630, ExchCode = 'TDG' WHERE SecCode = 4991558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-07' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198173, ExchCode = 'BIV' WHERE SecCode = 5002475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897338416, ExchCode = 'DEU' WHERE SecCode = 5025182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388828, ExchCode = 'LAS' WHERE SecCode = 5038683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907556432, ExchCode = 'GTX' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910168364, ExchCode = 'DUS' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821965, ExchCode = 'QTX' WHERE SecCode = 5102906 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 5119117 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-26' WHERE SecCode = 5144072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, ExchCode = 'BER' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380662, ExchCode = 'LAS' WHERE SecCode = 5168258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627704, ExchCode = 'QTX' WHERE SecCode = 5168260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920552457, ExchCode = 'DEU' WHERE SecCode = 5168261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945897707, ExchCode = 'STU' WHERE SecCode = 5174430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809874, ExchCode = 'GTX' WHERE SecCode = 5174469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950823656, ExchCode = 'FRA' WHERE SecCode = 5343552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776504667, ExchCode = 'BIV' WHERE SecCode = 5354969 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581953, ExchCode = 'BIV' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232809430185.0, IsPrimaryInstr = 1 WHERE SecCode = 5440515 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 5457224 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5463054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348315, ExchCode = 'QTX' WHERE SecCode = 5466221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778622366, ExchCode = 'HAM' WHERE SecCode = 5490578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791756610, ExchCode = 'TDG' WHERE SecCode = 5509507 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5513343 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 5527521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779412067, ExchCode = 'FRA' WHERE SecCode = 5541689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779412070, ExchCode = 'FRA' WHERE SecCode = 5541690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779412068, ExchCode = 'FRA' WHERE SecCode = 5541691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779442600, ExchCode = 'FRA' WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779442603, ExchCode = 'FRA' WHERE SecCode = 5541733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779461580, ExchCode = 'STU' WHERE SecCode = 5542014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21992551003, Ticker = 'SNV3', ExchCode = 'MIL' WHERE SecCode = 5550748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779655387, ExchCode = 'TDG' WHERE SecCode = 5550820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386728, ExchCode = 'LAS' WHERE SecCode = 5550822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790014899, ExchCode = 'TDG' WHERE SecCode = 5550823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, ExchCode = 'BER' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982665105, ExchCode = 'MXQ' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522671160, PermQuoteStatus = 'AC', Ticker = 'YE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5581588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792943339, ValQuotePermID = 236792943339.0, PermQuoteStatus = 'AC', Ticker = 'SBAR', ExchCode = 'LSE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-06-02' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781012608, ExchCode = 'STU' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236792943339.0 WHERE SecCode = 5633576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22077468957, Ticker = 'SOXLl', ExchCode = 'BCO' WHERE SecCode = 5702908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782376739, ExchCode = 'FRA' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078196, ExchCode = 'LAS' WHERE SecCode = 5726747 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 5754390 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 QuotePermID = 236783847363, ExchCode = 'STU' WHERE SecCode = 5805681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783878429, ExchCode = 'FRA' WHERE SecCode = 5805700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783879182, ExchCode = 'FRA' WHERE SecCode = 5805706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22052269961, ExchCode = 'DEU' WHERE SecCode = 5881402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587695, ExchCode = 'MUN' WHERE SecCode = 5881403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785642965, ExchCode = 'MUN' WHERE SecCode = 5886967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787828305, ExchCode = 'BER' WHERE SecCode = 5949087 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 5996599 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 6018397 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 6021476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078218, ExchCode = 'LAS' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22003906983, Ticker = 'XDGUz', ExchCode = 'SIG' WHERE SecCode = 6097276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799311189, ExchCode = 'QTX' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784422711, ExchCode = 'MEX' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21972857485, ExchCode = 'MXQ' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 6097473 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 6134771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6333961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 6436864 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796262668.0, PriInstrPermID = 232892869512.0, IsPrimaryInstr = 1, PermOrgIPODate = '2025-09-30' WHERE SecCode = 6443421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796310778, ExchCode = 'GTX' WHERE SecCode = 6448297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796310780, ExchCode = 'GTX' WHERE SecCode = 6448298 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6448817 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796258739.0 WHERE SecCode = 6450976 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6464960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796236953, IsPrimaryQuote = 1, Ticker = 'RIEN1', ExchCode = 'SWX' WHERE SecCode = 6467519 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096759409 WHERE SecCode = 10964830 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'GMI.H', ExchCode = 'NEX' WHERE SecCode = 11005365 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'CVE' WHERE SecCode = 11023364 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11056107 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11062344 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 11063280 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'LXM' WHERE SecCode = 11072382 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11107137 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951345.0 WHERE SecCode = 11201672 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11214335 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11221176 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11227644 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'JAHLF', PermQuoteRetireDate = NULL WHERE SecCode = 11248232 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25', PermOrgIPODate = NULL WHERE SecCode = 11252317 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'KDK', ExchCode = 'NMS', PermOrgIPODate = NULL WHERE SecCode = 11253494 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 236792943339.0 WHERE SecCode = 11264268 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11266862 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11269885 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11270656 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11276619 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11276706 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279674 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279773 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279838 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279909 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279910 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279911 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279912 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279913 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279914 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279915 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279916 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279918 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-24' WHERE SecCode = 11279922 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279972 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279973 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279974 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279975 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279976 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279977 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279978 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 11279979 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 47758940957.0, ValQuotePermID = 47758940967.0 WHERE SecCode = 11285172 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11285410 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'RITMP' WHERE SecCode = 11285480 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-25' WHERE SecCode = 11285503 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'UTF RT' WHERE SecCode = 11285516 AND Type_ = 1;
