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 QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 18690 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 OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, IsPrimaryInstr = 0, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermOrgIPODate = '2025-09-15' WHERE SecCode = 32562 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 32563 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, ExchCode = 'BER' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486043, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 35064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488307, ExchCode = 'QTX' WHERE SecCode = 35457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837366078, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384206, ExchCode = 'LAS' WHERE SecCode = 36613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521103746, ExchCode = 'STU' WHERE SecCode = 38625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483828644, Ticker = 'EIC', ExchCode = 'STU', PermQuoteRetireDate = '2013-09-17' WHERE SecCode = 38658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325494, ExchCode = 'BER' WHERE SecCode = 38731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950957, Ticker = 'MZN', ExchCode = 'STU', PermQuoteRetireDate = '2020-01-13' WHERE SecCode = 38771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489858, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-22' WHERE SecCode = 38789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838512918, ExchCode = 'STU' WHERE SecCode = 45916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 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 = 55838506971, ExchCode = 'STU' WHERE SecCode = 46390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742530, ExchCode = 'HAN' WHERE SecCode = 51564 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1990-01-01' WHERE SecCode = 54845 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 = 21538164352, ExchCode = 'DEU' WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393702, ExchCode = 'FRA' WHERE SecCode = 60123 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1990-01-01' WHERE SecCode = 60244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492943, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 60564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475030486, ExchCode = 'FRA' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339538, ExchCode = 'BER' WHERE SecCode = 60831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348427, ExchCode = 'FRA' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, IsPrimaryInstr = 0, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermOrgIPODate = '2025-09-15' WHERE SecCode = 61904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475428110, ExchCode = 'GER' WHERE SecCode = 64940 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1990-01-01' WHERE SecCode = 74992 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 74993 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21483761938, ExchCode = 'CHA' WHERE SecCode = 80783 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1990-01-01' WHERE SecCode = 100020 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21863182394, ExchCode = 'MUN' WHERE SecCode = 103666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, ExchCode = 'BER' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837360475, Ticker = 'SKG', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 104043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571420277, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486937555, ExchCode = 'STU' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335260, ExchCode = 'BER' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726152, ExchCode = 'DEU' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390660, ExchCode = 'FRA' WHERE SecCode = 112049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870865253, ExchCode = 'FRA' WHERE SecCode = 112064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661189444, ExchCode = 'FRA' WHERE SecCode = 112078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000480221, ExchCode = 'DEU' WHERE SecCode = 112079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295811, ExchCode = 'GTX' WHERE SecCode = 112129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419772, ExchCode = 'HAM' WHERE SecCode = 112135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332781, ExchCode = 'BER' WHERE SecCode = 112143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527717624, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624943988, ExchCode = 'FRA' WHERE SecCode = 114028 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-19' WHERE SecCode = 116794 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 119773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492299, ExchCode = 'QTX' WHERE SecCode = 137720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521224187, ExchCode = 'STU' WHERE SecCode = 137791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842886562, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 137794 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 = 21560377986, ExchCode = 'BTE' WHERE SecCode = 137860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516376146, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 137873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512264703, Ticker = 'WENo', ExchCode = 'STO', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 137904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789195679, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-22', PermSecMapEndDate = NULL WHERE SecCode = 138990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341772, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 139011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655828004, ExchCode = 'FRA', PermQuoteRetireDate = '2023-09-15' WHERE SecCode = 139013 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-19' WHERE SecCode = 140027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487476, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 140786 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 = 21830294365, ExchCode = 'GTX' WHERE SecCode = 140826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335868, ExchCode = 'BER' WHERE SecCode = 140843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591673619, ExchCode = 'STU' WHERE SecCode = 141004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475140561, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 141175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21875114022, ExchCode = 'TDG' WHERE SecCode = 141182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617741762, ExchCode = 'TDG' WHERE SecCode = 141184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484240, ExchCode = 'QTX' WHERE SecCode = 141232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296552, ExchCode = 'GTX' WHERE SecCode = 143197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295736, ExchCode = 'GTX' WHERE SecCode = 143198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497500363, ExchCode = 'STU' WHERE SecCode = 143201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519207, ExchCode = 'DUS', PermQuoteRetireDate = '2014-12-16' WHERE SecCode = 144542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894937105, ExchCode = 'GTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611106182, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 144853 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147678 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 = 21667485573, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 150289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770833011, ExchCode = 'DEU' WHERE SecCode = 150485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575646, ExchCode = 'QTX' WHERE SecCode = 150488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334527, ExchCode = 'BER', PermQuoteRetireDate = '2012-11-05' WHERE SecCode = 150515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, ExchCode = 'BER' 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 PermOrgIPODate = '1990-01-01' WHERE SecCode = 178496 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788425927, ExchCode = 'LAS' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849054916, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 203070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 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 QuotePermID = 21749838939, ExchCode = 'FRA' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373346, ExchCode = 'DEU' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 294471 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 310249 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 310250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531772020, ExchCode = 'STU' WHERE SecCode = 319526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629379964, Ticker = '0KAZ', ExchCode = 'LSE', PermQuoteRetireDate = '2025-09-19', PermSecMapStartDate = '2017-12-08', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 336186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320555, ExchCode = 'BER' WHERE SecCode = 336198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687455, ExchCode = 'TDG', PermQuoteRetireDate = '2022-12-08' WHERE SecCode = 336764 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-19' WHERE SecCode = 337161 AND Type_ = 1;
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 = 21502570914, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 345858 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 383684 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 383685 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 383686 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 383687 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 383688 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5057309462, PriInstrPermID = 21655495827.0, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 383689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843596535, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 427461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, PermQuoteStatus = 'DC', Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547316142, ExchCode = 'STU' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542942791, ExchCode = 'STU' WHERE SecCode = 548782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128988850, ExchCode = 'DEU', PermSecMapStartDate = '2025-09-19' WHERE SecCode = 558485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629379884, Ticker = '0EZ1', ExchCode = 'LSE', PermQuoteRetireDate = '2025-09-19', PermSecMapStartDate = '2017-12-08', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 1295970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477469688, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-01' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490163342, Ticker = 'GSD', ExchCode = 'STU', PermQuoteRetireDate = '2014-03-06' WHERE SecCode = 1489390 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 = 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 = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531118844, Ticker = 'BO4d', ExchCode = 'BCO' WHERE SecCode = 1740287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537425753, ExchCode = 'TDG' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585026984, ExchCode = 'BTE' WHERE SecCode = 1931297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985521, ExchCode = 'STU', PermQuoteRetireDate = '2015-05-27' WHERE SecCode = 2018342 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 = 236796184306, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-19', PermSecMapEndDate = NULL WHERE SecCode = 2085430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562213812, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-04' WHERE SecCode = 2085533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519264359, ExchCode = 'BER' WHERE SecCode = 2115211 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 = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548878301, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-03' WHERE SecCode = 2650629 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252740, ExchCode = 'BER' WHERE SecCode = 2809751 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 QuotePermID = 21561682172, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629379825, PermSecMapStartDate = '2017-12-08', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 2912889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985207, ExchCode = 'TDG' WHERE SecCode = 2935962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597186085, ExchCode = 'FRA' WHERE SecCode = 3090270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587055393, ExchCode = 'STU' WHERE SecCode = 3166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011949508, ExchCode = 'AQX' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334992, ExchCode = 'DEU' WHERE SecCode = 3247427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605105387, ExchCode = 'BER', PermQuoteRetireDate = '2019-02-08' WHERE SecCode = 3283717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885786, ExchCode = 'TDG' WHERE SecCode = 3317857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827328140, ExchCode = 'FRA' WHERE SecCode = 3318810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650199, ExchCode = 'DUS' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796060148, Ticker = 'PEYSl', ExchCode = 'CHI' WHERE SecCode = 3392282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706225, ExchCode = 'MXQ' WHERE SecCode = 3430477 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 3431819 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 3432953 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 QuotePermID = 236793644583, ExchCode = 'TDG' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679999, ExchCode = 'BIV' WHERE SecCode = 3440422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643807094, ExchCode = 'BER' WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, IsPrimaryInstr = 0, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermOrgIPODate = '2025-09-15' WHERE SecCode = 3586968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666356672, Ticker = 'NBPUl', ExchCode = 'TRQ' WHERE SecCode = 3616805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665390029, ExchCode = 'STU' WHERE SecCode = 3619112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692561684, ExchCode = 'DEU' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699218063, ExchCode = 'FRA' WHERE SecCode = 3862230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369832, ExchCode = 'MEX' WHERE SecCode = 3868466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705621141, ExchCode = 'QTX' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368210, ExchCode = 'MEX' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' 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 = 236779115555, ExchCode = 'STU' WHERE SecCode = 3959923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713324973, Ticker = '2TE', ExchCode = 'STU', PermQuoteRetireDate = '2024-07-01' WHERE SecCode = 3965202 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1990-01-01' WHERE SecCode = 3966593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924367856, ExchCode = 'GTX' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184457, Ticker = 'FARONh', ExchCode = 'SIU' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779527, ExchCode = 'DUS' WHERE SecCode = 4081943 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 = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 4101126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304629, ExchCode = 'DEU' WHERE SecCode = 4110883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352699, ExchCode = 'MEX' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780559871, ExchCode = 'STU' WHERE SecCode = 4134450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520230, ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-03' WHERE SecCode = 4134496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21868559772, ExchCode = 'QTX' WHERE SecCode = 4169151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918743, ExchCode = 'DEU' WHERE SecCode = 4193439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351142, ExchCode = 'BIV' WHERE SecCode = 4195318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745350479, ExchCode = 'FRA' WHERE SecCode = 4195339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749833486, ExchCode = 'STU' WHERE SecCode = 4203138 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 QuotePermID = 236781858560, ExchCode = 'QTX' WHERE SecCode = 4209247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 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 = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 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 = 25727345444, ExchCode = 'MEX' WHERE SecCode = 4282147 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 = 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 QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783589639, ExchCode = 'QTX' WHERE SecCode = 4328960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791872343, ExchCode = 'FRA' WHERE SecCode = 4341660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768726868, ExchCode = 'STU' WHERE SecCode = 4346650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' 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 = 21776573519, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-30' WHERE SecCode = 4388204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991935, ExchCode = 'FRA' WHERE SecCode = 4391296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782042601, ExchCode = 'MXQ' WHERE SecCode = 4391297 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 = 21786088093, ExchCode = 'BER' WHERE SecCode = 4394760 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 = 236780228924, ExchCode = 'GTX', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 4400159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782177869, ExchCode = 'DEU' WHERE SecCode = 4404026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991977, ExchCode = 'FRA' WHERE SecCode = 4410618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896376172, ExchCode = 'DEU' WHERE SecCode = 4410619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829123402, ExchCode = 'STU' WHERE SecCode = 4410622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337110, ExchCode = 'DEU' WHERE SecCode = 4423907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850052327, PermQuoteStatus = 'DC', ExchCode = 'EBT', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879563641, ExchCode = 'MUN' WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' 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 = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 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 = 21712131273, ExchCode = 'DEU' WHERE SecCode = 4474227 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 = 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 = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798385267, ExchCode = 'DEU' WHERE SecCode = 4502472 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 = 21830285167, ExchCode = 'GTX' WHERE SecCode = 4511507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836067, PermQuoteRetireDate = '2023-04-26' WHERE SecCode = 4536443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, ExchCode = 'GTX' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886801843, ExchCode = 'GTX' WHERE SecCode = 4557762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381354, ExchCode = 'LAS' WHERE SecCode = 4557929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385286, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-10', PermSecMapEndDate = NULL WHERE SecCode = 4568425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777449320, ExchCode = 'TDG' WHERE SecCode = 4568460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809547031, ExchCode = 'DEU' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991715, ExchCode = 'DEU' WHERE SecCode = 4573512 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 = 25727264760, ExchCode = 'BIV' WHERE SecCode = 4580740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812338173, ExchCode = 'MUN', PermQuoteRetireDate = '2023-08-09' WHERE SecCode = 4588258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812186314, ExchCode = 'FRA' WHERE SecCode = 4588263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785979680, ExchCode = 'FRA' WHERE SecCode = 4588269 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 = 236778820333, ExchCode = 'QTX' 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 = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 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 = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387236, ExchCode = 'LAS' WHERE SecCode = 4609996 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 = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818936644, Ticker = 'TGLD', ExchCode = 'SWX', PermQuoteRetireDate = '2023-01-11', PermSecMapEndDate = '2023-01-11' WHERE SecCode = 4620075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818936763, Ticker = 'TPLT', ExchCode = 'SWX', PermQuoteRetireDate = '2023-01-11' WHERE SecCode = 4620077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888689541, ExchCode = 'STU' WHERE SecCode = 4620159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293770, ExchCode = 'TDG' WHERE SecCode = 4620160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912799, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-14' WHERE SecCode = 4620951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778181553, ExchCode = 'STU' WHERE SecCode = 4623226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729626, ExchCode = 'FRA', PermQuoteRetireDate = '2021-06-22', PermSecMapEndDate = NULL WHERE SecCode = 4631952 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 = 25727246040, Ticker = 'BBARD', ExchCode = 'BUE' WHERE SecCode = 4639651 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 = 21911881123, ExchCode = 'DEU' WHERE SecCode = 4677626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' 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 = 21848717895, ExchCode = 'STU' 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 = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 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 = 21844719378, ExchCode = 'DEU' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845567127, ExchCode = 'MUN', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847343480, ExchCode = 'GTX' WHERE SecCode = 4730169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847351964, ExchCode = 'FRA' WHERE SecCode = 4733108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569865, ExchCode = 'QTX' WHERE SecCode = 4745386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345317, ExchCode = 'STU' WHERE SecCode = 4748505 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 = 21853439422, ExchCode = 'DUS' WHERE SecCode = 4756621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689585, ExchCode = 'DXE' WHERE SecCode = 4761548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856492172, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4771748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 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 = 21904412215, ExchCode = 'GTX' WHERE SecCode = 4810002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862297960, ExchCode = 'FRA' WHERE SecCode = 4811143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879552085, ExchCode = 'TDG' WHERE SecCode = 4827911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212163, ExchCode = 'BIV' WHERE SecCode = 4827941 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 = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 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 = 236784386324, ExchCode = 'LAS' WHERE SecCode = 4885536 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 QuotePermID = 21945198768, ExchCode = 'BER' WHERE SecCode = 4890357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878356554, ExchCode = 'DEU' WHERE SecCode = 4911199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727203536, ExchCode = 'BIV' WHERE SecCode = 4918915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881260859, ExchCode = 'STU' WHERE SecCode = 4925667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881998635, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-25', PermSecMapEndDate = '2022-03-25' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884030447, ExchCode = 'MUN' WHERE SecCode = 4949697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893301199, ExchCode = 'GTX' WHERE SecCode = 4952512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, PermQuoteStatus = 'DC', Ticker = 'VC91', ExchCode = 'DUS', PermQuoteRetireDate = '2024-09-03' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200980, ExchCode = 'BIV' WHERE SecCode = 4956738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951554681, ExchCode = 'STU' WHERE SecCode = 4958004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21926264784, ExchCode = 'DEU', PermQuoteRetireDate = '2022-11-07' 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 = 21896580276, ExchCode = 'FRA' WHERE SecCode = 4991678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777698929, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-08' WHERE SecCode = 4991682 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 = 21894278989, ExchCode = 'STU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897339624, ExchCode = 'FRA' 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 = 21863949618, ExchCode = 'PFT' WHERE SecCode = 5040232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209490, ExchCode = 'FRA' WHERE SecCode = 5059308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659538, ExchCode = 'LAS' WHERE SecCode = 5067501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569848, ExchCode = 'QTX' WHERE SecCode = 5067503 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 = 236781821965, ExchCode = 'QTX' WHERE SecCode = 5102906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910716265, ExchCode = 'FRA' WHERE SecCode = 5116970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914676115, ExchCode = 'STU' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387466, ExchCode = 'LAS' WHERE SecCode = 5140200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, ExchCode = 'BER' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380648, ExchCode = 'LAS' WHERE SecCode = 5156833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896005416, ExchCode = 'MXQ' WHERE SecCode = 5161445 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 = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 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 = 21920980941, Ticker = 'Z6M0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 5168340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809874, ExchCode = 'GTX' WHERE SecCode = 5174469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921486218, ExchCode = 'FRA' WHERE SecCode = 5174471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21926475881, ExchCode = 'QTX', PermQuoteRetireDate = '2022-11-03', PermSecMapEndDate = '2022-11-03' WHERE SecCode = 5206276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928666124, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-17' WHERE SecCode = 5209798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132598, ExchCode = 'DEU' WHERE SecCode = 5218830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395668, ExchCode = 'FRA' WHERE SecCode = 5253712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935904590, ExchCode = 'FRA' WHERE SecCode = 5265006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959379813, ExchCode = 'TDG' WHERE SecCode = 5265007 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5267077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397463, Ticker = 'PB7d', ExchCode = 'BTE' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5272114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587852, ExchCode = 'QTX' WHERE SecCode = 5277530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942349169, ExchCode = 'QTX' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659544, ExchCode = 'LAS' WHERE SecCode = 5315601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397462, Ticker = 'CQ0d', ExchCode = 'BTE', PermQuoteRetireDate = '2025-05-27' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777698959, ExchCode = 'TDG' WHERE SecCode = 5322460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381675, ExchCode = 'LAS' WHERE SecCode = 5324084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732431, ExchCode = 'MEX' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949435332, ExchCode = 'GTX' WHERE SecCode = 5332356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777252955, ExchCode = 'HAM' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950815916, ExchCode = 'DEU' WHERE SecCode = 5343552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626936, ExchCode = 'DEU' WHERE SecCode = 5349683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832380, ExchCode = 'FRA' WHERE SecCode = 5350576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891323, ExchCode = 'STU' WHERE SecCode = 5352019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107274, ExchCode = 'FRA' WHERE SecCode = 5353914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059910, ExchCode = 'FRA' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514234, ExchCode = 'DUS' WHERE SecCode = 5360992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581953, ExchCode = 'BIV' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201516, ExchCode = 'DEU' WHERE SecCode = 5388846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758791, ExchCode = 'MUN', PermSecMapEndDate = NULL WHERE SecCode = 5393777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921820703, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-17', PermSecMapEndDate = '2024-12-17' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777803100, ExchCode = 'MEX' WHERE SecCode = 5440528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911075, ExchCode = 'MUN' WHERE SecCode = 5444084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777892395, ExchCode = 'GTX' WHERE SecCode = 5444086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778820209, ExchCode = 'STU' WHERE SecCode = 5497202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787118150, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-08' WHERE SecCode = 5506510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223859, ExchCode = 'QTX' WHERE SecCode = 5506511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21984114239, ExchCode = 'DEU' WHERE SecCode = 5506512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911223, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 5509596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986201526, ExchCode = 'DEU' WHERE SecCode = 5516455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781906283, ExchCode = 'TDG' WHERE SecCode = 5527546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21991233126, ExchCode = 'DEU' WHERE SecCode = 5546677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796182522, ExchCode = 'TDG' WHERE SecCode = 5547972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, ExchCode = 'FRA' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779708089, ExchCode = 'STU' WHERE SecCode = 5558240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060456, ExchCode = 'TDG' WHERE SecCode = 5560522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781814020, ExchCode = 'GTX' WHERE SecCode = 5574897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985327, ExchCode = 'TDG' WHERE SecCode = 5674239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028891058, ExchCode = 'STU' WHERE SecCode = 5726747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782930891, ExchCode = 'MUN' WHERE SecCode = 5753987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078228, ExchCode = 'LAS' WHERE SecCode = 5754012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353275, ExchCode = 'STU' WHERE SecCode = 5779319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784516066, ExchCode = 'BIV' WHERE SecCode = 5835922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129520, ExchCode = 'FRA' WHERE SecCode = 5836009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786652154, ExchCode = 'LAS' WHERE SecCode = 5836010 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 = 22054245159, ExchCode = 'DEU' WHERE SecCode = 5888374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785605367, Ticker = '4WL0', ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-30', PermSecMapEndDate = '2025-04-30' WHERE SecCode = 5894939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22055647707, ExchCode = 'DEU' WHERE SecCode = 5897645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785946324, ExchCode = 'BIV' WHERE SecCode = 5908827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786584011, ExchCode = 'STU' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786016617, ExchCode = 'STU' WHERE SecCode = 5908830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22077468824, ExchCode = 'CHI' WHERE SecCode = 5951017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787002921, ExchCode = 'BIV' WHERE SecCode = 5957049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795035713, ExchCode = 'FRA' WHERE SecCode = 5969285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089208040, ExchCode = 'GTX' WHERE SecCode = 5999093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985343, ExchCode = 'TDG', PermSecMapStartDate = '2024-11-06' WHERE SecCode = 6002047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072613591, ExchCode = 'DEU' WHERE SecCode = 6010806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861720, ExchCode = 'FRA' WHERE SecCode = 6012971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759315, ExchCode = 'MUN' WHERE SecCode = 6041427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' 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 = 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 = 22089001084, ExchCode = 'DEU' WHERE SecCode = 6147595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942692, ExchCode = 'STU' WHERE SecCode = 6151861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096749101, ExchCode = 'QTX' WHERE SecCode = 6217549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791756612, ExchCode = 'TDG' WHERE SecCode = 6230491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838441, ExchCode = 'STU' WHERE SecCode = 6232187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22100216242, ExchCode = 'DEU' WHERE SecCode = 6250330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22100216428, ExchCode = 'DEU' WHERE SecCode = 6250332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406432, ExchCode = 'MEX' WHERE SecCode = 6272288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792386873, ExchCode = 'FRA' WHERE SecCode = 6272292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792389737, ExchCode = 'FRA' WHERE SecCode = 6272293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792386877, ExchCode = 'FRA' WHERE SecCode = 6272294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792386874, ExchCode = 'FRA' WHERE SecCode = 6272295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907994, ExchCode = 'FRA' WHERE SecCode = 6308566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793144047, ExchCode = 'FRA' WHERE SecCode = 6322250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793288635, ExchCode = 'FRA' WHERE SecCode = 6329454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793288726, ExchCode = 'FRA' WHERE SecCode = 6329455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793764215, ExchCode = 'FRA' WHERE SecCode = 6366680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793846140, ExchCode = 'MEX' WHERE SecCode = 6371576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118566912, ExchCode = 'DEU' WHERE SecCode = 6382149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792427653, ExchCode = 'LAS' WHERE SecCode = 6382150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794190134, ExchCode = 'FRA' WHERE SecCode = 6387729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794094894, ExchCode = 'QTX' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID' WHERE SecCode = 6411862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792777691, ExchCode = 'BIV' WHERE SecCode = 6414160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182992, ExchCode = 'FRA' WHERE SecCode = 6443261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796057730, ExchCode = 'GTX' WHERE SecCode = 6448294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795663595, ExchCode = 'TDG' WHERE SecCode = 6448295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796057759, ExchCode = 'MUN' WHERE SecCode = 6448296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126473178, ExchCode = 'DEU' WHERE SecCode = 6448297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126473223, ExchCode = 'DEU' WHERE SecCode = 6448298 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6448319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127941838, ExchCode = 'DEU' WHERE SecCode = 6456430 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6457846 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6457851 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6460635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059426, ExchCode = 'MUN' WHERE SecCode = 6460655 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 10933062 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 11033942 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'ORPOF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-19', PermSecMapEndDate = NULL WHERE SecCode = 11151837 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 11199506 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 11228127 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11229729 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236793806111, IsPrimaryQuote = 0, ExchCode = 'GTC', PermSecMapStartDate = '2025-02-20', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11234013 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727190737, IsPrimaryQuote = 1, ExchCode = 'NAS', PermSecMapStartDate = '2022-08-25' WHERE SecCode = 11244579 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 11250503 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11252776 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2024-09-17', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11256413 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2024-02-01' WHERE SecCode = 11262138 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232888096122.0 WHERE SecCode = 11284219 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = NULL WHERE SecCode = 11285503 AND Type_ = 1;