UPDATE data_universe_permid SET QuotePermID = 21538767932, Ticker = 'ABBYl', ExchCode = 'BCO', PermQuoteRetireDate = '2021-08-11' WHERE SecCode = 24 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3948 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN', IncCntry = 'CAN' WHERE SecCode = 24565 AND Type_ = 1;
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 IncCntry = 'USA' WHERE SecCode = 35004 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 DomCntry = 'DEU' WHERE SecCode = 38164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661362178, ExchCode = 'STU' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 39109 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 40950 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 44565 AND Type_ = 1;
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 = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399711, ExchCode = 'FRA' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 55063 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 55742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 58710 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 58851 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 59311 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 59629 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196451, ExchCode = 'DUS' WHERE SecCode = 60024 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 DomCntry = 'DNK' WHERE SecCode = 61061 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 61350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341706, ExchCode = 'BER' WHERE SecCode = 62126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329646, ExchCode = 'BER' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 66177 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 68937 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 71190 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 76619 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 76950 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'EGY' WHERE SecCode = 82786 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 87124 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 87191 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 88811 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'DNK' WHERE SecCode = 100680 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 102088 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 115276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337704, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CHE' WHERE SecCode = 117943 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 123508 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 130700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957764680, ExchCode = 'FRA' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 139429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591385, ExchCode = 'DEU' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 141097 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 141232 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 143284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660711237, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 143730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836482057, ExchCode = 'FRA' WHERE SecCode = 172822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474983741, ExchCode = 'DEU' WHERE SecCode = 172989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495338652, ExchCode = 'STU', PermQuoteRetireDate = '2020-10-27' WHERE SecCode = 172998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513801720, ExchCode = 'STU' WHERE SecCode = 173075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545507629, ExchCode = 'DEU' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806332212, ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 177372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475098888, ExchCode = 'TDG' WHERE SecCode = 184373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327294, ExchCode = 'STU' WHERE SecCode = 184376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607100268, ExchCode = 'STU' WHERE SecCode = 184941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330738, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 185675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546270621, ExchCode = 'MUN' WHERE SecCode = 185677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848349308, ExchCode = 'FRA' WHERE SecCode = 185678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521411407, ExchCode = 'TDG' WHERE SecCode = 185684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803077496, ExchCode = 'DEU' WHERE SecCode = 185686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531428016, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 185816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475817421, ExchCode = 'STU' WHERE SecCode = 192638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474934533, ExchCode = 'DEU' WHERE SecCode = 192797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793968457, ExchCode = 'TDG' WHERE SecCode = 192957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555732, ExchCode = 'DEU' WHERE SecCode = 193691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624462713, ExchCode = 'DEU' WHERE SecCode = 194030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098230, ExchCode = 'DEU' WHERE SecCode = 194347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486309684, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 194847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473860, ExchCode = 'FRA' WHERE SecCode = 196149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628831642, ExchCode = 'STU' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836432030, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-15' WHERE SecCode = 196619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186351, ExchCode = 'DEU' WHERE SecCode = 196887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593347163, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-10' WHERE SecCode = 197286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555567886, ExchCode = 'STU', PermQuoteRetireDate = '2019-10-18' WHERE SecCode = 197287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900660, ExchCode = 'STU' WHERE SecCode = 197762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474883585, ExchCode = 'DEU' WHERE SecCode = 198997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025972, ExchCode = 'LAS' WHERE SecCode = 199010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474912303, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 199022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704190, ExchCode = 'MXQ' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539471086, ExchCode = 'TDG', PermQuoteRetireDate = '2025-11-27' WHERE SecCode = 204682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332519, ExchCode = 'BER' WHERE SecCode = 204683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625620888, ExchCode = 'TDG' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511544127, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 206830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474902041, ExchCode = 'DEU', PermQuoteRetireDate = '2020-12-28' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520146057, ExchCode = 'STU', PermQuoteRetireDate = '2017-03-14', PermSecMapEndDate = '2017-03-14' WHERE SecCode = 208564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513441154, PermQuoteStatus = 'AC', Ticker = 'X9C', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 208904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544954898, ExchCode = 'FRA' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527643731, ExchCode = 'STU' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175714363, ExchCode = 'DEU' WHERE SecCode = 208948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111640, ExchCode = 'DEU' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184307, ExchCode = 'MUN' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475592408, ExchCode = 'MUN', PermQuoteRetireDate = '2009-12-17' WHERE SecCode = 210757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475807561, ExchCode = 'STU', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 214105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419404, ExchCode = 'HAM' WHERE SecCode = 214142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475869483, ExchCode = 'STU' WHERE SecCode = 214143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475038582, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 245886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836454824, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 246361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474867329, ExchCode = 'DEU' WHERE SecCode = 247651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147785188, ExchCode = 'DEU' WHERE SecCode = 248095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660812887, ExchCode = 'MUN', PermQuoteRetireDate = '2019-03-13' WHERE SecCode = 248318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21995876064, ExchCode = 'DEU' WHERE SecCode = 248504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609207, ExchCode = 'FRA' WHERE SecCode = 248506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621824, ExchCode = 'TDG' WHERE SecCode = 248569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830311778, ExchCode = 'GTX' WHERE SecCode = 248574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522214211, ExchCode = 'STU' WHERE SecCode = 248621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399723, ExchCode = 'FRA' WHERE SecCode = 248622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520009844, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 248734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475050981, ExchCode = 'TDG' WHERE SecCode = 248738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991994, ExchCode = 'DEU', PermQuoteRetireDate = '2022-04-27' WHERE SecCode = 248740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374981, ExchCode = 'FRA' WHERE SecCode = 248742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669871254, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 248746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375292, ExchCode = 'STU' WHERE SecCode = 248748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521856858, ExchCode = 'STU', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 248749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839726, ExchCode = 'DEU' WHERE SecCode = 248754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692069, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30' WHERE SecCode = 248756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517229259, ExchCode = 'STU' WHERE SecCode = 248758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332085, ExchCode = 'BER', PermQuoteRetireDate = '2009-06-08' WHERE SecCode = 248760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816901040, ExchCode = 'STU' WHERE SecCode = 248767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533629755, ExchCode = 'DEU', PermQuoteRetireDate = '2023-07-19' WHERE SecCode = 248769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566184392, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 248773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411753, ExchCode = 'FRA' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609681550, ExchCode = 'STU' WHERE SecCode = 248777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474922265, ExchCode = 'DEU' WHERE SecCode = 248895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495338828, ExchCode = 'STU' WHERE SecCode = 248901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575579850, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 248903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22158416975, ExchCode = 'DEU' WHERE SecCode = 248904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518531775, ExchCode = 'STU' WHERE SecCode = 248908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621124789, ExchCode = 'STU', PermQuoteRetireDate = '2018-03-02' WHERE SecCode = 248917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475611279, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2006-04-11' WHERE SecCode = 248919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197790, ExchCode = 'STU' WHERE SecCode = 248920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604352837, ExchCode = 'STU' WHERE SecCode = 248924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034167, ExchCode = 'TDG' WHERE SecCode = 248927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475363282, ExchCode = 'FRA' WHERE SecCode = 248928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474917330, ExchCode = 'DEU' WHERE SecCode = 248929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905420487, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-08' WHERE SecCode = 248943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605379119, ExchCode = 'FRA' WHERE SecCode = 248952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475130447, ExchCode = 'STU' WHERE SecCode = 248967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484680882, ExchCode = 'DEU' WHERE SecCode = 248987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614269979, ExchCode = 'STU' WHERE SecCode = 248989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776247454, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 248992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779580616, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 249048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474846109, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 249049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475568611, ExchCode = 'MUN', PermQuoteRetireDate = '2010-02-12' WHERE SecCode = 249054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585104019, ExchCode = 'FRA', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = NULL WHERE SecCode = 249164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624944007, Ticker = 'BHQ', ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-26', PermSecMapEndDate = '2025-11-26' WHERE SecCode = 249168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035354, PermQuoteStatus = 'DC', Ticker = 'OSI', ExchCode = 'TDG', PermQuoteRetireDate = '2015-01-09' WHERE SecCode = 249172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991446, ExchCode = 'FRA' WHERE SecCode = 249177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748620, ExchCode = 'DEU' WHERE SecCode = 249189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633600339, ExchCode = 'FRA' WHERE SecCode = 249190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589809274, ExchCode = 'STU' WHERE SecCode = 249196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475018588, Ticker = 'RBQP', ExchCode = 'BER', PermQuoteRetireDate = '2016-12-13' WHERE SecCode = 249199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436627, ExchCode = 'FRA' WHERE SecCode = 249208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512042331, ExchCode = 'TDG' WHERE SecCode = 249211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523702466, ExchCode = 'STU' WHERE SecCode = 249217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147089280, ExchCode = 'DEU' WHERE SecCode = 249236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477154080, ExchCode = 'FRA', PermQuoteRetireDate = '2017-03-01' WHERE SecCode = 249264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475835886, ExchCode = 'BER', PermQuoteRetireDate = '2012-09-21' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547083257, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 249276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565082887, ExchCode = 'FRA' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400014, ExchCode = 'DEU' WHERE SecCode = 249305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475631730, ExchCode = 'GER', PermQuoteRetireDate = '2006-09-18' WHERE SecCode = 249314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475782841, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-03' WHERE SecCode = 249315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474875634, ExchCode = 'DEU' WHERE SecCode = 249318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532123028, ExchCode = 'FRA' WHERE SecCode = 249342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858765745, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856726590, ExchCode = 'STU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611365799, ExchCode = 'STU' WHERE SecCode = 249355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474842918, ExchCode = 'DEU' WHERE SecCode = 249361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536721623, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-20' WHERE SecCode = 249362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536896590, ExchCode = 'TDG' WHERE SecCode = 249364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535831521, ExchCode = 'STU', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847021469, ExchCode = 'FRA' WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791319568, ExchCode = 'DUS' WHERE SecCode = 249370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324467, ExchCode = 'BER', PermQuoteRetireDate = '2011-10-06' WHERE SecCode = 249379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587383849, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-14', PermSecMapEndDate = '2023-06-14' WHERE SecCode = 249387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524268362, ExchCode = 'STU' WHERE SecCode = 249398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599530590, PermQuoteStatus = 'AC', Ticker = 'INO0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 249400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324507, ExchCode = 'BER', PermQuoteRetireDate = '2008-09-05' WHERE SecCode = 249403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475094788, ExchCode = 'TDG' WHERE SecCode = 249419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684969064, ExchCode = 'DEU' WHERE SecCode = 249420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476850902, ExchCode = 'TDG' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520009642, ExchCode = 'FRA' WHERE SecCode = 249445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615253053, ExchCode = 'TDG' WHERE SecCode = 249565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237021, ExchCode = 'STU' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562942019, ExchCode = 'TDG' WHERE SecCode = 249573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642375165, ExchCode = 'FRA' WHERE SecCode = 249589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337490, ExchCode = 'BER' WHERE SecCode = 249592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474892286, ExchCode = 'DEU' WHERE SecCode = 249597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610023483, ExchCode = 'STU', PermQuoteRetireDate = '2021-05-03' WHERE SecCode = 249598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474851129, ExchCode = 'DEU' WHERE SecCode = 249599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956712462, ExchCode = 'DUS' WHERE SecCode = 249601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870528, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-02' WHERE SecCode = 249606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568175738, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-05' WHERE SecCode = 249609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474925222, ExchCode = 'DEU', PermQuoteRetireDate = '2025-08-11' WHERE SecCode = 249614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281554, Ticker = 'SFW', ExchCode = 'DEU' WHERE SecCode = 249619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475452550, ExchCode = 'MUN' WHERE SecCode = 249622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133899880, ExchCode = 'DEU' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581860194, ExchCode = 'BER', PermQuoteRetireDate = '2020-10-08' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215797, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617119543, Ticker = 'CKI', ExchCode = 'STU', PermQuoteRetireDate = '2019-08-14' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429067, ExchCode = 'GER' WHERE SecCode = 249648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474854296, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-04' WHERE SecCode = 249654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054465, ExchCode = 'TDG' WHERE SecCode = 249656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495336695, ExchCode = 'STU' WHERE SecCode = 249668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916531978, PermQuoteStatus = 'AC', Ticker = '62C', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 249677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527005240, ExchCode = 'STU' WHERE SecCode = 249683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790403565, ExchCode = 'FRA' WHERE SecCode = 249684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524376, ExchCode = 'BER' WHERE SecCode = 249685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475577403, Ticker = 'QSC.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 249694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602144530, ExchCode = 'STU' WHERE SecCode = 249701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344683, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 249703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904311, ExchCode = 'DEU' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607709988, ExchCode = 'STU' WHERE SecCode = 249713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636632018, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-26' WHERE SecCode = 249728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706893721, ExchCode = 'FRA' WHERE SecCode = 249759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548019744, ExchCode = 'FRA' WHERE SecCode = 249761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507269971, ExchCode = 'TDG' WHERE SecCode = 249765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593287072, ExchCode = 'STU', PermQuoteRetireDate = '2022-05-27', PermSecMapEndDate = NULL WHERE SecCode = 249777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475127463, ExchCode = 'FRA' WHERE SecCode = 249782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474997548, ExchCode = 'FRA' WHERE SecCode = 249786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516948702, ExchCode = 'STU' WHERE SecCode = 249787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111648, ExchCode = 'FRA' WHERE SecCode = 249791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179587, ExchCode = 'DEU' WHERE SecCode = 249796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22052572098, ExchCode = 'DEU' WHERE SecCode = 249797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532691717, ExchCode = 'FRA' WHERE SecCode = 249801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538241626, ExchCode = 'DEU', PermQuoteRetireDate = '2016-01-05' WHERE SecCode = 249805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860308852, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530311, ExchCode = 'DEU' WHERE SecCode = 249816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525576964, ExchCode = 'TDG' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891803, PermQuoteStatus = 'DC', Ticker = 'ILR', ExchCode = 'DEU', PermQuoteRetireDate = '2018-06-22', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396790, ExchCode = 'DEU' WHERE SecCode = 249845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228081, ExchCode = 'TDG' WHERE SecCode = 249853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475454256, ExchCode = 'GER' WHERE SecCode = 249855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329232, ExchCode = 'BER' WHERE SecCode = 249861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830278708, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 250100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592924027, ExchCode = 'HAM' WHERE SecCode = 250132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289008, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 254873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035809, PermQuoteStatus = 'AC', Ticker = 'DNQ', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 255059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475538245, ExchCode = 'MUN', PermQuoteRetireDate = '2009-03-04' WHERE SecCode = 255061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645193106, ExchCode = 'DEU' WHERE SecCode = 255144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22043721486, ExchCode = 'DEU' WHERE SecCode = 255607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033971, PermQuoteStatus = 'AC', Ticker = 'Q23', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 255769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034768, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 257977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960080108, ExchCode = 'MUN' WHERE SecCode = 259026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336055, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 259181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475077443, ExchCode = 'STU', PermQuoteRetireDate = '2015-11-09' WHERE SecCode = 259601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346460, ExchCode = 'DEU' WHERE SecCode = 259657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474926380, ExchCode = 'HAM' WHERE SecCode = 259753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002550, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 259830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475050997, ExchCode = 'TDG' WHERE SecCode = 259936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536791766, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 260490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033439, Ticker = 'SMI', ExchCode = 'TDG', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 261710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21686567933, PermQuoteStatus = 'DC', Ticker = 'LEER', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 272752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22166504439, ExchCode = 'DEU' WHERE SecCode = 273208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509902698, ExchCode = 'GER', PermQuoteRetireDate = '2008-12-17' WHERE SecCode = 277248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138696948, Ticker = 'LYQ3', ExchCode = 'HAM' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509896504, Ticker = 'L2800', ExchCode = 'CLO', PermQuoteRetireDate = '2008-10-02' WHERE SecCode = 279674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537280965, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 282761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474900132, ExchCode = 'DEU' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 283718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340809, ExchCode = 'BER', PermQuoteRetireDate = '2011-10-25' WHERE SecCode = 283842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654537857, ExchCode = 'STU' WHERE SecCode = 284038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474937749, ExchCode = 'EQD', PermQuoteRetireDate = '2013-11-13' WHERE SecCode = 284278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579894372, ExchCode = 'FRA' WHERE SecCode = 284280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646845918, ExchCode = 'FRA' WHERE SecCode = 284282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681761697, ExchCode = 'DEU' WHERE SecCode = 284283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469768, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 284304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22074279257, ExchCode = 'DEU' WHERE SecCode = 285188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326928, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 285190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491265, ExchCode = 'QTX' WHERE SecCode = 285538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22079582435, ExchCode = 'DEU' WHERE SecCode = 285541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035344, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2020-02-07' WHERE SecCode = 286286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557105454, ExchCode = 'TDG' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760841, Ticker = 'TSU', ExchCode = 'BUR', PermQuoteRetireDate = '2013-06-03' WHERE SecCode = 286474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808531461, ExchCode = 'FRA' WHERE SecCode = 286479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332301, ExchCode = 'BER' WHERE SecCode = 287044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474927810, ExchCode = 'DEU' WHERE SecCode = 287047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475770303, PermQuoteStatus = 'AC', Ticker = 'UTE0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 287574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518802606, ExchCode = 'SIG', PermQuoteRetireDate = '2013-08-12' WHERE SecCode = 288059 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 288062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624376888, ExchCode = 'DEU' WHERE SecCode = 288083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661437748, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 288243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475570497, PermQuoteStatus = 'DC', Ticker = 'ORKG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 288296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369556, ExchCode = 'FRA' WHERE SecCode = 288353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645063254, ExchCode = 'TDG' WHERE SecCode = 288836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330854, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 288837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560506984, ExchCode = 'STU' WHERE SecCode = 288842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554647750, ExchCode = 'DEU' WHERE SecCode = 288843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341030, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 289025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592647195, ExchCode = 'STU' WHERE SecCode = 289053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530950056, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 289154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700198266, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 289461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652595015, ExchCode = 'TDG' WHERE SecCode = 289584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475096421, ExchCode = 'TDG' WHERE SecCode = 289606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340706, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 289607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334074, ExchCode = 'BER' WHERE SecCode = 289617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550946088, ExchCode = 'STU', PermQuoteRetireDate = '2023-03-07', PermSecMapEndDate = NULL WHERE SecCode = 289619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338884, ExchCode = 'BER', PermQuoteRetireDate = '2008-01-05' WHERE SecCode = 289899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG' WHERE SecCode = 289915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474943267, ExchCode = 'DEU' WHERE SecCode = 290309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373346, ExchCode = 'DEU' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533840130, PermQuoteStatus = 'DC', Ticker = 'SFY', ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05' WHERE SecCode = 290848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474940801, Ticker = 'A8M2', ExchCode = 'DEU', PermQuoteRetireDate = '2017-04-19' WHERE SecCode = 290850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838842390, ExchCode = 'RTS', PermQuoteRetireDate = '2011-12-19' WHERE SecCode = 291017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323366, ExchCode = 'BER', PermQuoteRetireDate = '2014-12-30' WHERE SecCode = 291257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597700156, ExchCode = 'STU' WHERE SecCode = 291259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475563481, Ticker = 'ECA', ExchCode = 'STU', PermQuoteRetireDate = '2009-11-19' WHERE SecCode = 291269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323505, ExchCode = 'BER', PermQuoteRetireDate = '2009-01-08' WHERE SecCode = 291270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323533, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 291271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002465, ExchCode = 'FRA' WHERE SecCode = 291283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530095670, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 291583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357981, ExchCode = 'STU' WHERE SecCode = 291585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329948, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 291628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585320834, ExchCode = 'TDG' WHERE SecCode = 291840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266532, ExchCode = 'FRA' WHERE SecCode = 291850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571725, ExchCode = 'STU' WHERE SecCode = 291854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475781081, ExchCode = 'STU', PermQuoteRetireDate = '2014-06-30' WHERE SecCode = 291865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911881288, ExchCode = 'FRA' WHERE SecCode = 292113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475046880, ExchCode = 'MUN' WHERE SecCode = 292683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524955420, Ticker = 'FB9A', ExchCode = 'FRA' WHERE SecCode = 292694 AND Type_ = 10;
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 = 21513927491 WHERE SecCode = 293118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 293916 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 294527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782012555, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 295269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625833576, ExchCode = 'STU' WHERE SecCode = 295285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475471596, ExchCode = 'FRA' WHERE SecCode = 296127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617347241, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-04-28', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 296276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324213, ExchCode = 'BER', PermQuoteRetireDate = '2008-08-06' WHERE SecCode = 296278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935884276, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330602, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336620, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529362164, ExchCode = 'TDG' WHERE SecCode = 296606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326636, Ticker = 'CVE1', ExchCode = 'BER', PermQuoteRetireDate = '2016-01-29' WHERE SecCode = 296645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335229, ExchCode = 'BER' WHERE SecCode = 296646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475588932, ExchCode = 'STU', PermQuoteRetireDate = '2008-10-08' WHERE SecCode = 297228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533706424, ExchCode = 'DEU' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140766, ExchCode = 'STU', PermQuoteRetireDate = '2025-03-04' WHERE SecCode = 297491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786321993, ExchCode = 'DUS' WHERE SecCode = 297732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640834970, ExchCode = 'FRA' WHERE SecCode = 297742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326180, ExchCode = 'BER' WHERE SecCode = 298579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654538579, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850354099, ExchCode = 'BER', PermQuoteRetireDate = '2013-02-12' WHERE SecCode = 298815 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 300121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419441, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 300181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474946646, ExchCode = 'HAM' WHERE SecCode = 300369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504951501, Ticker = 'TCG', ExchCode = 'GER', PermQuoteRetireDate = '2018-04-23' WHERE SecCode = 300395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850895857, ExchCode = 'QTX', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 300831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293789, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 301717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475587010, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2008-07-07' WHERE SecCode = 301718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513072831, ExchCode = 'STU' WHERE SecCode = 301739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790876548, ExchCode = 'DEU' WHERE SecCode = 302076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475721017, Ticker = 'GFH.I', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 302658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474945399, ExchCode = 'DEU' WHERE SecCode = 302671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475010316, ExchCode = 'DEU' WHERE SecCode = 302687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571352237, PermQuoteStatus = 'DC', Ticker = 'C2U1', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 302708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051166, ExchCode = 'TDG' WHERE SecCode = 303015 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 303056 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21607765089, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 303342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483815345, ExchCode = 'TDG' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336531, ExchCode = 'BER' WHERE SecCode = 303353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496861528, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 303354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801722954, ExchCode = 'FRA' WHERE SecCode = 303358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492893704, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131850953, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 303854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474989966, ExchCode = 'STU' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486670855, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2015-09-21' WHERE SecCode = 304966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474901442, ExchCode = 'DEU' WHERE SecCode = 304967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836354173, ExchCode = 'FRA', PermQuoteRetireDate = '2013-06-26' WHERE SecCode = 304998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475147361, ExchCode = 'STU' WHERE SecCode = 305002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050033, ExchCode = 'TDG' WHERE SecCode = 305279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322266, ExchCode = 'MUN' WHERE SecCode = 305282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801443013, ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-16' WHERE SecCode = 305536 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 306284 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667704760, ExchCode = 'MXQ' WHERE SecCode = 308939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273240, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 309089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485013, ExchCode = 'QTX' WHERE SecCode = 309339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475140563, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-22' WHERE SecCode = 309349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836528295, ExchCode = 'FRA', PermQuoteRetireDate = '2011-05-30' WHERE SecCode = 309537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585027886, ExchCode = 'CHI' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585029092, ExchCode = 'CHI' WHERE SecCode = 309898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820365559, ExchCode = 'MUN' WHERE SecCode = 310396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328807, ExchCode = 'BER', PermQuoteRetireDate = '2015-09-04' WHERE SecCode = 310710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792573020, ExchCode = 'MEX' WHERE SecCode = 311169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666345448, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 311970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320726, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-11' WHERE SecCode = 312346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787724436, ExchCode = 'STU' WHERE SecCode = 312460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550980601, ExchCode = 'HAM' WHERE SecCode = 312673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320613, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 312700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320719, ExchCode = 'BER' WHERE SecCode = 312932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321117, ExchCode = 'BER', PermQuoteRetireDate = '2012-02-28' WHERE SecCode = 312933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349692, ExchCode = 'FRA', PermQuoteRetireDate = '2011-04-01' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755613, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 313243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533364806, ExchCode = 'BTE' WHERE SecCode = 313522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514317546, Ticker = 'TP21', ExchCode = 'STU' WHERE SecCode = 313535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321093, ExchCode = 'BER' WHERE SecCode = 313545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034449, Ticker = 'EV7', ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-17' WHERE SecCode = 313560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576306511, ExchCode = 'STU' WHERE SecCode = 314186 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 314748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508030921, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 315711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522737971, PermQuoteStatus = 'DC', Ticker = '3EO', ExchCode = 'TDG', PermQuoteRetireDate = '2015-02-03' WHERE SecCode = 316264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860086807, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 316450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793968534, ExchCode = 'FRA' WHERE SecCode = 316451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655821590, ExchCode = 'DEU' WHERE SecCode = 316458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349476, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 316472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474886569, ExchCode = 'DEU' WHERE SecCode = 317225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320634, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29' WHERE SecCode = 317228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475010458, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 317772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836457294, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-24' WHERE SecCode = 318010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820587345, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 318406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691427118, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 318424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320798, ExchCode = 'BER' WHERE SecCode = 319524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559053793, Ticker = 'L93', ExchCode = 'STU', PermQuoteRetireDate = '2024-02-15' WHERE SecCode = 320392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475849649, ExchCode = 'DEU' WHERE SecCode = 323037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797995305, Ticker = '3D7', ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 323043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350798, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 325339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320881, ExchCode = 'BER', PermQuoteRetireDate = '2016-06-17' WHERE SecCode = 325342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836355025, ExchCode = 'FRA' WHERE SecCode = 325343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585875044, ExchCode = 'STU' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520752473, ExchCode = 'HAN' WHERE SecCode = 325645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321191, ExchCode = 'BER' WHERE SecCode = 325648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999290, ExchCode = 'DEU' WHERE SecCode = 325661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041772, ExchCode = 'TDG' WHERE SecCode = 326261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350120, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 326282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556336682, ExchCode = 'TDG' WHERE SecCode = 326285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514658513, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-23' WHERE SecCode = 326659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459988, ExchCode = 'STU' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554752099, ExchCode = 'DEU' WHERE SecCode = 327143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192969, ExchCode = 'STU' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817679438, ExchCode = 'TDG' WHERE SecCode = 327723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457131, ExchCode = 'STU' WHERE SecCode = 328153 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 328255 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 22131851187, ExchCode = 'DEU' WHERE SecCode = 328509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434502, ExchCode = 'QTX' WHERE SecCode = 328511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475451582, ExchCode = 'GER' WHERE SecCode = 328870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828053305, ExchCode = 'TDG' WHERE SecCode = 329370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497463778, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 330634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479301, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340709, ExchCode = 'BER' WHERE SecCode = 331281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848717422, Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 331318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834680290, Ticker = '0M8G', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 332227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302703, PermQuoteStatus = 'DC', Ticker = 'RAP1V.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509904480, PermQuoteStatus = 'DC', Ticker = 'AGAP.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 333083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21635896884, Ticker = 'AGGP.GB', ExchCode = 'AQS' WHERE SecCode = 333085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532305080, Ticker = 'OILBl', ExchCode = 'SIG', PermQuoteRetireDate = '2017-12-21' WHERE SecCode = 333091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673708, PermQuoteStatus = 'AC', Ticker = '0G77', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 333102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321769, ExchCode = 'BER', PermQuoteRetireDate = '2009-04-22' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576789997, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 333180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503112746, ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859903, Ticker = '0P51', ExchCode = 'LSE', PermQuoteRetireDate = '2014-06-25' WHERE SecCode = 333383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830307503, PermQuoteStatus = 'AC', Ticker = 'B9P1', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 333423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885451397, ExchCode = 'MUN' WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704226, ExchCode = 'MXQ' WHERE SecCode = 333869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675963, PermQuoteStatus = 'AC', Ticker = '0IT3', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 334467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475545759, Ticker = 'IMAKO', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 334816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523039680, ExchCode = 'TDG' WHERE SecCode = 334857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230649, ExchCode = 'TDG' WHERE SecCode = 334888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564526997, Ticker = 'XGLEm', ExchCode = 'CHI' WHERE SecCode = 335234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494293572, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 335658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145600985, ExchCode = 'DEU' WHERE SecCode = 335659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590527444, ExchCode = 'DEU' WHERE SecCode = 335661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585026950, ExchCode = 'BTE' WHERE SecCode = 335975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520390384, ExchCode = 'STU' WHERE SecCode = 336198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475790470, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-17' WHERE SecCode = 336200 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 QuotePermID = 55836340169, ExchCode = 'BER', PermQuoteRetireDate = '2014-01-08' WHERE SecCode = 336766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321522, ExchCode = 'BER', PermQuoteRetireDate = '2020-04-17' WHERE SecCode = 336790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707863866, Ticker = '3PJ', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 337013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838297515, Ticker = 'DOL.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 340071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321476, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 340167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704306, ExchCode = 'MXQ' WHERE SecCode = 340246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475001862, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 340488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515929419, ExchCode = 'DEU', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 340533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320712, ExchCode = 'BER' WHERE SecCode = 341102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540228781, ExchCode = 'STU' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503508780, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 341129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927758, ExchCode = 'BER' WHERE SecCode = 341781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538829897, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 341785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034940, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-11', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 341790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778456358, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 341926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325363, ExchCode = 'MUN', PermQuoteRetireDate = '2021-08-03', PermSecMapEndDate = '2021-08-03' WHERE SecCode = 341956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538721081, ExchCode = 'STU' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911870720, ExchCode = 'GTX' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543784117, ExchCode = 'STU' WHERE SecCode = 341963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524267752, ExchCode = 'STU', PermQuoteRetireDate = '2017-03-29' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524822343, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2020-05-26' WHERE SecCode = 342227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566536425, ExchCode = 'STU' WHERE SecCode = 343026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321347, ExchCode = 'BER' WHERE SecCode = 343073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281403, ExchCode = 'STU' WHERE SecCode = 343807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387674, Ticker = '3U9.BG', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 344514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549046992, ExchCode = 'STU' WHERE SecCode = 344771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175399989, ExchCode = 'DEU' WHERE SecCode = 344774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564886824, ExchCode = 'DEU' WHERE SecCode = 344777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900497, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 345092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538771200, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-20' WHERE SecCode = 345094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966420, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 345099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839294318, ExchCode = 'GTX' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476459275, Ticker = '1893.H', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849074, ExchCode = 'TDG' WHERE SecCode = 345429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475550034, Ticker = 'CAZA', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 345783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772723, Ticker = '47E', ExchCode = 'STU', PermQuoteRetireDate = '2013-11-25' WHERE SecCode = 345857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783662836, Ticker = 'VGPk', ExchCode = 'TQE' WHERE SecCode = 346537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321075, ExchCode = 'BER', PermQuoteRetireDate = '2016-02-24' WHERE SecCode = 348104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591801384, ExchCode = 'STU' WHERE SecCode = 348107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790869646, ExchCode = 'TDG', PermQuoteRetireDate = '2025-10-20' WHERE SecCode = 348120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589227637, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321488, ExchCode = 'BER', PermQuoteRetireDate = '2015-09-24' WHERE SecCode = 348453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927540, Ticker = '2RNO' WHERE SecCode = 348455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130920528, ExchCode = 'DEU' WHERE SecCode = 348479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296862, Ticker = 'FAIF.LU', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 348630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559584715, ExchCode = 'STU' WHERE SecCode = 348709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571558397, ExchCode = 'MUN' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475073719, Ticker = '0MIG', ExchCode = 'LSE', PermQuoteRetireDate = '2017-08-31' WHERE SecCode = 349090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699639312, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 350278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675545, Ticker = '0NZE', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 351261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838300398, Ticker = 'EXF.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 351265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299672, Ticker = 'OPT.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 351274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475565177, PermQuoteStatus = 'DC', Ticker = '0HHW', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 351284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473202, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321209, ExchCode = 'BER', PermQuoteRetireDate = '2009-09-29' WHERE SecCode = 351311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651753006, ExchCode = 'STU' WHERE SecCode = 352543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321278, ExchCode = 'BER' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474937476, PermQuoteStatus = 'AC', Ticker = '0NTM', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 353931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388978, Ticker = 'HLDX.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387991, PermQuoteStatus = 'DC', Ticker = 'VOLV_A.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475570565, PermQuoteStatus = 'DC', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 353978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388341, Ticker = 'ORC.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353982 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 355015 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21761303038, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 355184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761900692, ExchCode = 'STU' WHERE SecCode = 356548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474939810, ExchCode = 'DEU' WHERE SecCode = 357185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350095, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 357657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474943366, ExchCode = 'DEU' WHERE SecCode = 357672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561673, ExchCode = 'DUS' WHERE SecCode = 357673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034683, Ticker = '45G', ExchCode = 'TDG', PermQuoteRetireDate = '2012-10-23' WHERE SecCode = 360278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510526, ExchCode = 'STU' WHERE SecCode = 360956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613752133, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 362789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509521711, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-01-20' WHERE SecCode = 362801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799029787, ExchCode = 'TDG' WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475450750, ExchCode = 'GER' WHERE SecCode = 363753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475489994, Ticker = '0JJ7', ExchCode = 'LSE', PermQuoteRetireDate = '2009-05-20' WHERE SecCode = 363969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388662, PermQuoteStatus = 'DC', Ticker = 'OPT.PL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 363982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836354261, ExchCode = 'FRA' WHERE SecCode = 364966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590250751, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 368723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350834, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 368806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350583, ExchCode = 'FRA', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 368808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836455801, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 368812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349702, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 368818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475566805, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2009-08-03' WHERE SecCode = 368820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350578, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 368836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474940642, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 369106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472865, ExchCode = 'FRA' WHERE SecCode = 369281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704326, ExchCode = 'MXQ' WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475432906, Ticker = '0FCC', ExchCode = 'LSE', PermQuoteRetireDate = '2009-12-10' WHERE SecCode = 374930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474952194, ExchCode = 'DEU' WHERE SecCode = 376072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750780627, ExchCode = 'STU' WHERE SecCode = 376283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469684, ExchCode = 'DEU' WHERE SecCode = 377102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628050068, PermQuoteStatus = 'AC', Ticker = '4LT1', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 377460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514709829, Ticker = 'D69', ExchCode = 'STU' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033616, ExchCode = 'TDG' WHERE SecCode = 383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704399, ExchCode = 'MXQ' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631772204, ExchCode = 'TDG', PermQuoteRetireDate = '2022-11-02', PermSecMapEndDate = '2023-09-12' WHERE SecCode = 384412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916561972, ExchCode = 'MUN' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529169381, Ticker = 'HOGABs', ExchCode = 'SIG', PermQuoteRetireDate = '2013-10-21' WHERE SecCode = 385742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060331, ExchCode = 'MUN' WHERE SecCode = 387911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475476680, ExchCode = 'GER' WHERE SecCode = 389009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621501713, Ticker = '4QQ', ExchCode = 'STU', PermQuoteRetireDate = '2022-05-19' WHERE SecCode = 389019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840856895, ExchCode = 'BER' WHERE SecCode = 389023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475009411, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-05' WHERE SecCode = 389475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840913920, ExchCode = 'BER', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 389476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840905043, ExchCode = 'BER' WHERE SecCode = 389775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814454509, ExchCode = 'MUN' WHERE SecCode = 390369 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 391296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219000, ExchCode = 'TDG' WHERE SecCode = 395256 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 395621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21918242411, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 396297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799280763, ExchCode = 'DEU' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907732, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431650, ExchCode = 'FRA', PermQuoteRetireDate = '2019-06-03' WHERE SecCode = 401619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841565726, ExchCode = 'FRA' WHERE SecCode = 401620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475806545, ExchCode = 'STU' WHERE SecCode = 401621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643563, ExchCode = 'BER' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505934502, ExchCode = 'DEU', PermQuoteRetireDate = '2018-04-04' WHERE SecCode = 404717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539533292, ExchCode = 'MUN', DomCntry = 'USA', PermQuoteRetireDate = '2019-11-07' WHERE SecCode = 404833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478492476, Ticker = '0GKZ', ExchCode = 'LSE', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848856283, ExchCode = 'LSE', PermQuoteRetireDate = '2009-05-26' WHERE SecCode = 408478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927526, Ticker = '2ENGI' WHERE SecCode = 408548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521224477, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 408562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482293, ExchCode = 'QTX' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036216, PermQuoteStatus = 'DC', Ticker = 'ZCT1', ExchCode = 'TDG', PermQuoteRetireDate = '2025-05-12' WHERE SecCode = 416445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843102675, ExchCode = 'BER' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384961, ExchCode = 'STU' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294126, ExchCode = 'GTX' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511427254, ExchCode = 'STU', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520096838, ExchCode = 'STU' WHERE SecCode = 428332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517622815, ExchCode = 'STU' WHERE SecCode = 428335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396870, ExchCode = 'FRA' WHERE SecCode = 428966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302889, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 432012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840380352, ExchCode = 'PFT', PermQuoteRetireDate = '2017-01-23' WHERE SecCode = 433812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840380357, ExchCode = 'PFT', PermQuoteRetireDate = '2017-01-23' WHERE SecCode = 433814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536204619, ExchCode = 'STU' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599934396, ExchCode = 'TDG', PermQuoteRetireDate = '2023-12-14', PermSecMapEndDate = '2023-12-14' WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842916429, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 440283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853026615, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 442574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766987, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 446617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704501, ExchCode = 'MXQ' WHERE SecCode = 462658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575865316, ExchCode = 'BCO' WHERE SecCode = 464174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789408416, Ticker = '0AO0', ExchCode = 'FRA', PermQuoteRetireDate = '2022-09-06' WHERE SecCode = 479615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847283502, Ticker = 'XAXJ', ExchCode = 'LSE' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035525, ExchCode = 'TDG', PermQuoteRetireDate = '2014-12-09', PermSecMapEndDate = '2018-09-19' WHERE SecCode = 484246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474993358, ExchCode = 'STU' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605425984, ExchCode = 'RTB' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865464, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725613667, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521104455, ExchCode = 'STU' WHERE SecCode = 504529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704447, ExchCode = 'MXQ' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608722355, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 512041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914681044, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555806, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-30' WHERE SecCode = 513375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346323, ExchCode = 'TDG', PermQuoteRetireDate = '2017-10-05' WHERE SecCode = 513850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475860102, Ticker = '0GA', ExchCode = 'BER', PermQuoteRetireDate = '2017-04-28' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681520, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541088571, ExchCode = 'STU' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615370661, ExchCode = 'STU' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332969, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 519509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714460362, Ticker = 'HOGSm', ExchCode = 'DXE' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714444925, Ticker = 'WEATm', ExchCode = 'DXE' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487385092, ExchCode = 'FRA' WHERE SecCode = 522710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781435219, ExchCode = 'MUN' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 524466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308348, ExchCode = 'STU' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640208051, ExchCode = 'CHI', PermQuoteRetireDate = '2018-10-29' WHERE SecCode = 529911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033612, Ticker = '9EA', PermQuoteRetireDate = '2015-10-22' WHERE SecCode = 531956 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 532384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521104643, ExchCode = 'STU' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475845507, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851203489, ExchCode = 'FRA', PermQuoteRetireDate = '2014-04-01' WHERE SecCode = 535316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475082592, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-25' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714450686, Ticker = 'SBULm', ExchCode = 'DXE' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422418, Ticker = '0B3F', ExchCode = 'LSE', PermQuoteRetireDate = '2009-09-18' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475867481, ExchCode = 'FRA' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478626, ExchCode = 'QTX' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043310, ExchCode = 'STU' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852219705, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514772172, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846840, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-25' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474938108, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799025517, ExchCode = 'MUN' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852831256, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-11' WHERE SecCode = 547537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478506436, ExchCode = 'STU' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797390906, ExchCode = 'MUN' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21964831449, ExchCode = 'DEU' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415257, ExchCode = 'MUN' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853456463, ExchCode = 'STU', PermQuoteRetireDate = '2014-08-08' WHERE SecCode = 551262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660975, ExchCode = 'FRA' WHERE SecCode = 552722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499583580, Ticker = '6CMB', ExchCode = 'TDG' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518455932, ExchCode = 'DEU', PermQuoteRetireDate = '2023-03-23', PermSecMapEndDate = NULL WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480465, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 553799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790387228, ExchCode = 'STU', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 553921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706181, ExchCode = 'MXQ' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55854012972, ExchCode = 'STU' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55854015367, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-08' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475119976, ExchCode = 'FRA' WHERE SecCode = 557816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534813444, ExchCode = 'DUS' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 558221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128988850, ExchCode = 'DEU' WHERE SecCode = 558485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856218481, ExchCode = 'BER', PermQuoteRetireDate = '2013-02-08' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 559363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606624, ExchCode = 'GER' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856721464, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-27' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814307220, ExchCode = 'TDG' WHERE SecCode = 560728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850811719, ExchCode = 'BER', PermQuoteRetireDate = '2015-05-06' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565562489, ExchCode = 'BEC' WHERE SecCode = 561528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525342898, ExchCode = 'STU' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610776904, ExchCode = 'STU' WHERE SecCode = 563028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475779870, ExchCode = 'QMF' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529362096, ExchCode = 'STU' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857450136, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856428988, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 564417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474958339, ExchCode = 'DEU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492892892, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475822753, ExchCode = 'DEU', PermQuoteRetireDate = '2013-10-01' WHERE SecCode = 565586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578358, ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-16' WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864886870, ExchCode = 'MUN' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962557, ExchCode = 'DEU' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126940, ExchCode = 'DEU' WHERE SecCode = 566528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857959487, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957126, ExchCode = 'DUS' WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704751, Ticker = 'FBRN', ExchCode = 'MXQ' WHERE SecCode = 572386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679699, ExchCode = 'BIV' WHERE SecCode = 573267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704164, ExchCode = 'MXQ' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511793851, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 583151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858902712, ExchCode = 'BER' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859005911, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 593132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254286, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475660385, InstrPermID = 8590922012, OrgPermID = 4295880615, ValQuotePermID = 55837430854.0, PriInstrPermID = 8590922012.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'YFM', ExchCode = 'GER', PermQuoteRetireDate = '2010-03-29', PermOrgIPODate = NULL WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255778, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157401812, ExchCode = 'DEU' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 602651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475858943, ExchCode = 'BTE', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531671030, ExchCode = 'STU' WHERE SecCode = 604212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521225328, ExchCode = 'STU' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962484, ExchCode = 'DEU', PermQuoteRetireDate = '2022-07-22' WHERE SecCode = 696379 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 = 21865088683, ExchCode = 'TDG' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532857661, ExchCode = 'TDG' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 883102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 890755 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 903675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545813896, ExchCode = 'DEU' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388797, ExchCode = 'LAS' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769605, Ticker = 'TYMA', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333716, ExchCode = 'FRA' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1465035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615946, ExchCode = 'STO' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481623767, ExchCode = 'DEU' WHERE SecCode = 1482803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488285610, ExchCode = 'DEU' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143091, ExchCode = 'DUS' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704626, ExchCode = 'MXQ' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448735, ExchCode = 'TDG' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289597, ExchCode = 'FRA' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659841732, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495550098, ExchCode = 'DEU' WHERE SecCode = 1544731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704832, ExchCode = 'MXQ' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515927789, ExchCode = 'DEU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513858, ExchCode = 'STU' WHERE SecCode = 1606861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569032952, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1655498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822238, ExchCode = 'DEU' WHERE SecCode = 1655502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512394267, Ticker = 'CTY1SN0112', ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'INRETC1' WHERE SecCode = 1689195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799113029, ExchCode = 'LAS' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511181364, ExchCode = 'TDG' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274145, ExchCode = 'GTX' WHERE SecCode = 1732252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513144477, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 1735686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423685, ExchCode = 'FRA' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2014147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564394907, ExchCode = 'FRA' WHERE SecCode = 2036502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815142016, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607386, ExchCode = 'QTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523039361, ExchCode = 'FRA' WHERE SecCode = 2195966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682304295, ExchCode = 'FRA' WHERE SecCode = 2204916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2211959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2260564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487236, ExchCode = 'FRA' WHERE SecCode = 2328709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723974163, Ticker = '0T20', ExchCode = 'TDG', PermQuoteRetireDate = '2024-10-17' WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132401693, ExchCode = 'DEU' WHERE SecCode = 2333017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647013835, ExchCode = 'BCO' WHERE SecCode = 2346276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647013834, ExchCode = 'BCO' WHERE SecCode = 2346281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736168151, ExchCode = 'BCO' WHERE SecCode = 2346282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176033347, PermQuoteStatus = 'AC', Ticker = 'EAST', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-27', PermSecMapEndDate = NULL WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675065, ExchCode = 'BIV' WHERE SecCode = 2362819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538829907, ExchCode = 'STU' WHERE SecCode = 2365611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298199, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2366514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2381660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563665296, ExchCode = 'BCO' WHERE SecCode = 2382328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457314, ExchCode = 'DEU' WHERE SecCode = 2382351 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-27' WHERE SecCode = 2382443 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2386507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536966570, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2396434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589743018, ExchCode = 'FRA' WHERE SecCode = 2407193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999262, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2412422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2433071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544238122, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2015-02-23' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704199, ExchCode = 'MXQ' WHERE SecCode = 2455541 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754508239, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 2484919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599934397, Ticker = '9ORN', ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-07' WHERE SecCode = 2511582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537960715, ExchCode = 'BER' WHERE SecCode = 2513070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864432, ExchCode = 'STU' WHERE SecCode = 2539933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539947084, ExchCode = 'DEU', PermQuoteRetireDate = '2015-07-07' WHERE SecCode = 2541461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542252926, ExchCode = 'MUN' WHERE SecCode = 2568910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908261047, ExchCode = 'EQD' WHERE SecCode = 2571666 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2579462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793244, ExchCode = 'DEU' WHERE SecCode = 2593543 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'EGY' WHERE SecCode = 2595777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067757998, Ticker = '3HCSm', ExchCode = 'BCO' WHERE SecCode = 2600076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830307817, ExchCode = 'GTX' WHERE SecCode = 2604393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806536954, ExchCode = 'STU' WHERE SecCode = 2616472 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2617098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606224224, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-01' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624665037, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312212, ExchCode = 'GTX' WHERE SecCode = 2630989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549052746, ExchCode = 'FRA' WHERE SecCode = 2655940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714636898, ExchCode = 'STU' WHERE SecCode = 2659980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197344, Ticker = '7HP', ExchCode = 'BRN' WHERE SecCode = 2679919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451855, Ticker = 'QCOM', ExchCode = 'SWX' WHERE SecCode = 2679937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576623478, ExchCode = 'TDG' WHERE SecCode = 2694712 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697214 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697220 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697321 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2700315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534589, ExchCode = 'QTX', PermQuoteRetireDate = '2025-06-26', PermSecMapEndDate = NULL WHERE SecCode = 2706346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540948191, Ticker = '0QTP', ExchCode = 'LSE', PermQuoteRetireDate = '2020-03-10' WHERE SecCode = 2710438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553011784, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553466682, Ticker = 'TUIN', ExchCode = 'LSE', PermQuoteRetireDate = '2015-02-11' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264997, ExchCode = 'DEU' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675690, ExchCode = 'BIV' WHERE SecCode = 2747774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2767067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706109, Ticker = 'WFTN', ExchCode = 'MXQ' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674963, ExchCode = 'BIV' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367198, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755558882, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2774739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704598, ExchCode = 'MXQ' WHERE SecCode = 2812158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21678893048, ExchCode = 'FRA' WHERE SecCode = 2824459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713340769, ExchCode = 'DEU' WHERE SecCode = 2835193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559722974, ExchCode = 'CHA' WHERE SecCode = 2846578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623088, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374532, ExchCode = 'FRA' WHERE SecCode = 2849922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684294108, ExchCode = 'TDG', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599521455, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA', IncCntry = 'USA' WHERE SecCode = 2872657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673107, ExchCode = 'BIV' WHERE SecCode = 2876284 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 2884548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625833574, ExchCode = 'STU' WHERE SecCode = 2887325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654291757, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564846532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 2909243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957499681, ExchCode = 'DUS' WHERE SecCode = 2909909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599934308, PermQuoteStatus = 'AC', Ticker = '0NF1', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2911305 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-27' WHERE SecCode = 2912792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565820495, ExchCode = 'MUN' WHERE SecCode = 2919727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2929627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605132678, ExchCode = 'STU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567025378, ExchCode = 'DEU' WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211564, ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-21', PermSecMapEndDate = NULL WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2939969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609269063, ExchCode = 'FRA' WHERE SecCode = 2940839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100044, ExchCode = 'MUN' WHERE SecCode = 2946497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569380542, ExchCode = 'TDG' WHERE SecCode = 2956427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598532919, ExchCode = 'DEU' WHERE SecCode = 2963564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706327513, ExchCode = 'TDG' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573047978, ExchCode = 'BTE', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 2993543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573379099, ExchCode = 'FRA' WHERE SecCode = 2998198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792943751, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-11' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480218, ExchCode = 'QTX' WHERE SecCode = 3018530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589498072, ExchCode = 'DEU' WHERE SecCode = 3030770 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 3032204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805177404, ExchCode = 'MUN' WHERE SecCode = 3035953 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3037826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778874756, ExchCode = 'DUS' WHERE SecCode = 3043858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048899, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097097, ExchCode = 'LAS' WHERE SecCode = 3055016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991744, ExchCode = 'DEU' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022789, ExchCode = 'STU' WHERE SecCode = 3076712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077885, ExchCode = 'LAS' WHERE SecCode = 3076723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460750, Ticker = 'OD7I', ExchCode = 'FRA' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611367248, ExchCode = 'DEU' WHERE SecCode = 3077466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100417, ExchCode = 'QTX' WHERE SecCode = 3080538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597186085, ExchCode = 'FRA' WHERE SecCode = 3090270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641139161, Ticker = 'J75', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 3096965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097185, ExchCode = 'LAS' WHERE SecCode = 3099734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569839, ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-08' WHERE SecCode = 3102662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637999826, ExchCode = 'BER', PermQuoteRetireDate = '2020-10-29' WHERE SecCode = 3102663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586629555, Ticker = 'W47', ExchCode = 'TDG', PermQuoteRetireDate = '2025-05-02' WHERE SecCode = 3104810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386091, ExchCode = 'LAS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 3119166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704245, ExchCode = 'MXQ' WHERE SecCode = 3120787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584924434, ExchCode = 'MUN' WHERE SecCode = 3121331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679484, ExchCode = 'BIV' WHERE SecCode = 3123787 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 3124064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544712, ExchCode = 'QTX' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808531375, ExchCode = 'DEU' WHERE SecCode = 3130985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931857, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285715, ExchCode = 'DUS' WHERE SecCode = 3160205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077947, ExchCode = 'LAS' WHERE SecCode = 3160206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587574219, ExchCode = 'DEU', PermQuoteRetireDate = '2021-02-04' WHERE SecCode = 3162853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077944, ExchCode = 'LAS' WHERE SecCode = 3166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705845, ExchCode = 'MXQ' WHERE SecCode = 3166848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808198507, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3169823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429840, ExchCode = 'DUS' WHERE SecCode = 3169964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655511396, ExchCode = 'FRA' WHERE SecCode = 3172338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865085103, ExchCode = 'GTX' WHERE SecCode = 3172340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887524816, ExchCode = 'BCO' WHERE SecCode = 3174320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548007992, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 3177608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588924118, ExchCode = 'DEU' WHERE SecCode = 3177801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492372, ExchCode = 'QTX' WHERE SecCode = 3184009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919968405, Ticker = '3EMS.GB', ExchCode = 'AQS' WHERE SecCode = 3193774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862038094, ExchCode = 'DUS' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997785, ExchCode = 'FRA' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969218484, Ticker = '3DESd', ExchCode = 'BTE' WHERE SecCode = 3198702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786584619, ExchCode = 'FRA' WHERE SecCode = 3198703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821257511, ExchCode = 'DUS' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274001, ExchCode = 'GTX' WHERE SecCode = 3200605 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 3210064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783209095, ExchCode = 'FRA' WHERE SecCode = 3213268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016577, ExchCode = 'MUN' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748306921, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797026891, Ticker = 'GLWUSD', ExchCode = 'BRN' WHERE SecCode = 3222694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593186078, ExchCode = 'FRA' WHERE SecCode = 3223011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865877693, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-23' WHERE SecCode = 3223076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575641, ExchCode = 'QTX' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963315, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-11' WHERE SecCode = 3228677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999663, ExchCode = 'FRA' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594292935, ExchCode = 'FRA' WHERE SecCode = 3232615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806156912, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 3232617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749168, ExchCode = 'MUN' WHERE SecCode = 3236427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623994531, ExchCode = 'DEU' WHERE SecCode = 3244403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638022635, ExchCode = 'EBT', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 3247374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684286324, Ticker = '3660', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-02' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651750989, ExchCode = 'DEU' WHERE SecCode = 3257170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598110773, ExchCode = 'STU' WHERE SecCode = 3257553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656613417, ExchCode = 'STU' WHERE SecCode = 3259342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684609, ExchCode = 'DUS' WHERE SecCode = 3259344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598409316, ExchCode = 'DEU', PermQuoteRetireDate = '2016-11-11' WHERE SecCode = 3260094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100486, ExchCode = 'QTX' WHERE SecCode = 3260103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663194058, ExchCode = 'MEX' WHERE SecCode = 3271811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704422, Ticker = 'CERN*', ExchCode = 'MXQ' WHERE SecCode = 3275597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794048702, ExchCode = 'TDG' WHERE SecCode = 3275739 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277066 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277077 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277306 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277318 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601268298, ExchCode = 'DEU' WHERE SecCode = 3277475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588308, ExchCode = 'STU' WHERE SecCode = 3281992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755977768, ExchCode = 'DUS' WHERE SecCode = 3282701 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3282943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954945, ExchCode = 'LAS' WHERE SecCode = 3283696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771948, ExchCode = 'DEU' WHERE SecCode = 3284992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383543, ExchCode = 'DEU' WHERE SecCode = 3285135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634479982, ExchCode = 'MUN' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604270433, ExchCode = 'FRA' WHERE SecCode = 3285952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604647155, ExchCode = 'DEU' WHERE SecCode = 3288677 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3299486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278641, ExchCode = 'STU' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131153720, ExchCode = 'HAM' WHERE SecCode = 3315799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750316962, ExchCode = 'MUN' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379972, ExchCode = 'FRA' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137328, ExchCode = 'FRA' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237022, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3318127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380068, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679671, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3327117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611314238, ExchCode = 'DEU' WHERE SecCode = 3327999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673494, ExchCode = 'BIV' WHERE SecCode = 3338588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612487102, ExchCode = 'DEU' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631068545, Ticker = 'BIOSs', ExchCode = 'BCO', PermQuoteRetireDate = '2024-05-21' WHERE SecCode = 3350742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3358966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050504, ExchCode = 'FRA' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3359406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3367918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805023784, ExchCode = 'DEU' WHERE SecCode = 3368562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749591716, PermQuoteStatus = 'DC', Ticker = '90S1', ExchCode = 'STU', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100723, ExchCode = 'DUS' WHERE SecCode = 3378195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864390192, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704322, ExchCode = 'MXQ' WHERE SecCode = 3385617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019517, ExchCode = 'FRA' WHERE SecCode = 3386374 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3394116 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3394117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100390, ExchCode = 'QTX' WHERE SecCode = 3394481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289554, ExchCode = 'STU' WHERE SecCode = 3394497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624942707, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-10' WHERE SecCode = 3396885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22146561121, ExchCode = 'DEU' WHERE SecCode = 3397198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624462689, ExchCode = 'FRA' WHERE SecCode = 3398637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630627945, ExchCode = 'FRA' WHERE SecCode = 3405439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624076661, ExchCode = 'BEC' WHERE SecCode = 3406544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629252830, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3407252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788075109, ExchCode = 'FRA' WHERE SecCode = 3407870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630898, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-02-21', PermSecMapEndDate = '2026-01-29' WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630922, ExchCode = 'FRA', PermQuoteRetireDate = '2025-02-26', PermSecMapEndDate = '2025-02-26' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060476, ExchCode = 'FRA', PermQuoteRetireDate = '2024-03-25' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879249284, ExchCode = 'QTX', PermQuoteRetireDate = '2026-02-04', PermSecMapEndDate = '2026-03-13' WHERE SecCode = 3431060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380031, ExchCode = 'LAS' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374586, ExchCode = 'FRA' WHERE SecCode = 3438919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997874, ExchCode = 'DEU' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643680223, ExchCode = 'BER' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3439563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643223584, ExchCode = 'STU' WHERE SecCode = 3441711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687554, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646838408, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3445749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298408, ExchCode = 'GTX' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305949, ExchCode = 'FRA' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 3446637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645435116, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-02' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569555, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648544895, ExchCode = 'MUN' WHERE SecCode = 3501226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749468782, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137715, Ticker = 'REL0', ExchCode = 'BER', PermQuoteRetireDate = '2023-06-01' WHERE SecCode = 3510596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687527384, ExchCode = 'STU' WHERE SecCode = 3511810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676092, ExchCode = 'BIV' WHERE SecCode = 3511839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3524259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645825, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-01', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305699, ExchCode = 'GTX' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3547398 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3547827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692715167, ExchCode = 'CHI' WHERE SecCode = 3551896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655827943, ExchCode = 'DEU', PermQuoteRetireDate = '2025-03-31' WHERE SecCode = 3551904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997896, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-08', PermSecMapEndDate = '2023-06-08' WHERE SecCode = 3565802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562247, ExchCode = 'GTX' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474893887, Ticker = '8EC0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 3587066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952421, ExchCode = 'DEU' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3597944 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3599060 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3601080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 3610164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664984725, ExchCode = 'DEU' WHERE SecCode = 3615233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664987336, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3615235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665411081, ExchCode = 'DEU' WHERE SecCode = 3616264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3634405 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3634410 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3635531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689480150, ExchCode = 'BTE' WHERE SecCode = 3669924 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 3675449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569892, ExchCode = 'QTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3690670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675532883, ExchCode = 'DEU' WHERE SecCode = 3703433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21676006277, ExchCode = 'DEU' WHERE SecCode = 3708151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794979494, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3719703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535488, ExchCode = 'MUN' WHERE SecCode = 3735815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680538261, ExchCode = 'DEU', PermQuoteRetireDate = '2022-12-15' WHERE SecCode = 3738158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681016508, ExchCode = 'STU' WHERE SecCode = 3746657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682585487, ExchCode = 'DEU' WHERE SecCode = 3769372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687636010, ExchCode = 'TDG', PermQuoteRetireDate = '2022-08-18' WHERE SecCode = 3775420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713593778, ExchCode = 'MUN' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665283113, ExchCode = 'TDG' WHERE SecCode = 3793435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673847667, ExchCode = 'BIV' WHERE SecCode = 3796484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383887, ExchCode = 'MEX' WHERE SecCode = 3799616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690334717, ExchCode = 'DUS' WHERE SecCode = 3809861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690462879, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3812238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690638190, ExchCode = 'DEU' WHERE SecCode = 3812451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383295, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 3814192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690997691, ExchCode = 'DUS' WHERE SecCode = 3817314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690997703, ExchCode = 'DUS' WHERE SecCode = 3817316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527274, ExchCode = 'DEU' WHERE SecCode = 3818167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581865, ExchCode = 'QTX', PermQuoteRetireDate = '2026-04-02' WHERE SecCode = 3819180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693541214, ExchCode = 'FRA' WHERE SecCode = 3821863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789617000, ExchCode = 'MEX' WHERE SecCode = 3827965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673985167, ExchCode = 'MEX' WHERE SecCode = 3827997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650229, ExchCode = 'DUS' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694479665, Ticker = 'UT8', ExchCode = 'TDG' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164003350, ExchCode = 'DEU' WHERE SecCode = 3831366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21695367988, ExchCode = 'STU' WHERE SecCode = 3832750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373317, ExchCode = 'MEX' WHERE SecCode = 3843165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694925393, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-27' WHERE SecCode = 3848226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888036799, ExchCode = 'MUN' WHERE SecCode = 3852867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21698786104, ExchCode = 'CHI', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3857957 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3862212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350912, ExchCode = 'DEU' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727370524, ExchCode = 'MEX' WHERE SecCode = 3869732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673984282, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 3875230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895290, ExchCode = 'DEU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21635089488, Ticker = '0JOQl', ExchCode = 'BCO' WHERE SecCode = 3885297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377500, ExchCode = 'MEX' WHERE SecCode = 3890362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806468, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3894966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900276, ExchCode = 'TDG' WHERE SecCode = 3898812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664166, ExchCode = 'STU' WHERE SecCode = 3898813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896834972, ExchCode = 'GTX' WHERE SecCode = 3899637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383362, ExchCode = 'MEX' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710752788, ExchCode = 'FRA' WHERE SecCode = 3951385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812338413, ExchCode = 'MUN' WHERE SecCode = 3951450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711927625, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725178113, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3956835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715393197, ExchCode = 'DEU' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715726562, ExchCode = 'FRA' WHERE SecCode = 3980005 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3987717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819929880, ExchCode = 'DUS' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294452, ExchCode = 'GTX' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817666768, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4001066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298922, ExchCode = 'GTX' WHERE SecCode = 4004564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377491, ExchCode = 'BIV' WHERE SecCode = 4022727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624691044, Ticker = '2INTC', ExchCode = 'MIL' WHERE SecCode = 4031712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011943, Ticker = '2CVX' WHERE SecCode = 4031716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026865, Ticker = '11COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143843, Ticker = '2HEIA', ExchCode = 'MIL' WHERE SecCode = 4031893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011235, Ticker = '2IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822947768, Ticker = '4DSY', ExchCode = 'ETX' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633857, ExchCode = 'STU' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723632161, ExchCode = 'DEU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184457, ExchCode = 'SIU' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725971281, ExchCode = 'TDG' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634821003, Ticker = 'OCPETb', ExchCode = 'BCO', PermQuoteRetireDate = '2024-01-31' WHERE SecCode = 4046600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997868, ExchCode = 'DEU' WHERE SecCode = 4046659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059848, ExchCode = 'FRA' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727357678, ExchCode = 'BIV' WHERE SecCode = 4049099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412273, ExchCode = 'DEU' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412250, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-03', PermSecMapEndDate = '2025-09-03' WHERE SecCode = 4062000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262486, ExchCode = 'TDG', PermQuoteRetireDate = '2024-03-01' WHERE SecCode = 4080675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732154152, ExchCode = 'FRA' WHERE SecCode = 4080678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779663, ExchCode = 'MUN' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388406, ExchCode = 'LAS' WHERE SecCode = 4081944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782582943, ExchCode = 'QTX' WHERE SecCode = 4101141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735442278, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, ExchCode = 'DUS' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787721995, ExchCode = 'MUN' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966439, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21740303517, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349456, ExchCode = 'MEX' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749841407, ExchCode = 'FRA' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754379229, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942187, ExchCode = 'STU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809669, ExchCode = 'DEU' WHERE SecCode = 4275421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767996853, ExchCode = 'DEU' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260470, ExchCode = 'DEU' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757506160, ExchCode = 'FRA' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599450, ExchCode = 'FRA' WHERE SecCode = 4303583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760292838, ExchCode = 'MUN' WHERE SecCode = 4303589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488721, ExchCode = 'STU' WHERE SecCode = 4303635 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4320782 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4321394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763901196, ExchCode = 'QTX' WHERE SecCode = 4324504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763728326, ExchCode = 'DEU' WHERE SecCode = 4324620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112353, ExchCode = 'FRA' WHERE SecCode = 4324622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910570378, PermQuoteStatus = 'DC', ExchCode = 'CHJ', PermQuoteRetireDate = '2025-09-04' WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388599, ExchCode = 'LAS' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4369835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 4382172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531963, ExchCode = 'GTX' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786088252, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4394760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778285116, ExchCode = 'DEU' WHERE SecCode = 4396578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 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 = 21780891475, ExchCode = 'STU' WHERE SecCode = 4406352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997001052, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4409981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786584641, ExchCode = 'GER' WHERE SecCode = 4409982 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4413673 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4415704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4417450 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4417451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, ExchCode = 'DUS' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786673386, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777025689, ExchCode = 'STU' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337125, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4423907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312258, ExchCode = 'BIV' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790192047, ExchCode = 'FRA' WHERE SecCode = 4425728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307225, ExchCode = 'MEX' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653687, ExchCode = 'MUN' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026948, Ticker = '1VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810219, ExchCode = 'BTE' WHERE SecCode = 4429632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991601, ExchCode = 'FRA' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785083437, ExchCode = 'TDG' WHERE SecCode = 4434247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784912245, ExchCode = 'FRA' WHERE SecCode = 4434248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777464435, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-21', PermSecMapEndDate = '2022-06-21' WHERE SecCode = 4434404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786106016, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4438384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685950, ExchCode = 'DEU' WHERE SecCode = 4444002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740545, ExchCode = 'LAS' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562192, ExchCode = 'GTX' WHERE SecCode = 4449679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818102097, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4449683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727302435, ExchCode = 'MEX' WHERE SecCode = 4451140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4452346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306258, ExchCode = 'BIV' WHERE SecCode = 4456073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789191252, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4456112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539605199, ExchCode = 'BEC' WHERE SecCode = 4456118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790713764, ExchCode = 'STU' WHERE SecCode = 4458936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789562275, ExchCode = 'FRA' WHERE SecCode = 4458938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727314620, ExchCode = 'MEX' WHERE SecCode = 4458998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954828, ExchCode = 'LAS' WHERE SecCode = 4459009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264695, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4462869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954874, ExchCode = 'LAS' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312130, ExchCode = 'GTX' WHERE SecCode = 4463148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791933842, ExchCode = 'DUS' WHERE SecCode = 4463150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689543, ExchCode = 'FRA' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727302040, ExchCode = 'MEX' WHERE SecCode = 4463164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306964, ExchCode = 'BEC' WHERE SecCode = 4464699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835452, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4466437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956950, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793532320, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798225679, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-12', PermSecMapEndDate = '2025-02-12' WHERE SecCode = 4470353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396931, ExchCode = 'FRA' WHERE SecCode = 4472910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789408355, ExchCode = 'DEU' WHERE SecCode = 4474245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794070559, ExchCode = 'FRA' WHERE SecCode = 4476795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815902455, ExchCode = 'STU' WHERE SecCode = 4477048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727293388, PermQuoteStatus = 'AC', Ticker = 'MKR', ExchCode = 'JNB', PermQuoteRetireDate = NULL WHERE SecCode = 4477796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896842819, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794808195, ExchCode = 'STU' WHERE SecCode = 4479186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794261338, ExchCode = 'FRA' WHERE SecCode = 4479188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843587047, ExchCode = 'GTX' WHERE SecCode = 4479279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817586, ExchCode = 'DEU' WHERE SecCode = 4481115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795576815, ExchCode = 'FRA' WHERE SecCode = 4484497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835966, PermQuoteRetireDate = '2023-09-27' WHERE SecCode = 4487664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342536, ExchCode = 'MEX' WHERE SecCode = 4492131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797233154, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4494217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555797, ExchCode = 'DEU' WHERE SecCode = 4496736 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-28', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 4499164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798248666, ExchCode = 'DEU', PermQuoteRetireDate = '2023-04-21', PermSecMapEndDate = '2023-04-21' WHERE SecCode = 4499277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799115765, ExchCode = 'LAS' WHERE SecCode = 4502474 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4502482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799698913, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4502498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287359, ExchCode = 'MEX' WHERE SecCode = 4505578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805179555, ExchCode = 'STU' WHERE SecCode = 4505789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830278747, ExchCode = 'GTX' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801289756, ExchCode = 'FRA' WHERE SecCode = 4517834 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4517838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799910326, ExchCode = 'DEU' WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801722942, ExchCode = 'DEU' WHERE SecCode = 4521258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312337, ExchCode = 'GTX' WHERE SecCode = 4522869 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 4524459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387389, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4527883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804817015, ExchCode = 'STU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301440, ExchCode = 'MEX' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349196, ExchCode = 'BIV' WHERE SecCode = 4550708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893554092, ExchCode = 'DEU' WHERE SecCode = 4554184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143000521, ExchCode = 'DEU' WHERE SecCode = 4557948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872251161, ExchCode = 'MUN', DomCntry = 'CHN' WHERE SecCode = 4568422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950973, ExchCode = 'FRA' WHERE SecCode = 4568423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025965, ExchCode = 'LAS' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991586, ExchCode = 'FRA' WHERE SecCode = 4579689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811570272, ExchCode = 'MUN' WHERE SecCode = 4585453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812636752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-17' WHERE SecCode = 4589403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305820, ExchCode = 'BIV' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026913, Ticker = '1INVEB' WHERE SecCode = 4601877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549166, ExchCode = 'GTX' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581925, ExchCode = 'QTX' WHERE SecCode = 4603537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21944534852, ExchCode = 'STU' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138518181, ExchCode = 'BCO' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4612232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818254739, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-13' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821857998, ExchCode = 'DEU' WHERE SecCode = 4633100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843201120, ExchCode = 'DEU' WHERE SecCode = 4634352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799779, ExchCode = 'HAM' WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334921, ExchCode = 'DEU' WHERE SecCode = 4643318 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4645355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780368954, ExchCode = 'TDG' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048901, ExchCode = 'MUN' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381815, ExchCode = 'LAS' WHERE SecCode = 4658662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952621466, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4658881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914397, ExchCode = 'STU' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388764, ExchCode = 'LAS' WHERE SecCode = 4676228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837528978, ExchCode = 'DEU' WHERE SecCode = 4693647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, Ticker = 'CARBm', ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153605, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043657, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852728632, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846693634, ExchCode = 'TDG' WHERE SecCode = 4727664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846049880, ExchCode = 'DEU' WHERE SecCode = 4729059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853953634, ExchCode = 'QTX' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689585, ExchCode = 'DXE' WHERE SecCode = 4761548 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 4773751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439467, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-18' WHERE SecCode = 4774934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309449, ExchCode = 'MUN' WHERE SecCode = 4800557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823813, ExchCode = 'AQX' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808179, ExchCode = 'MUN' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866365601, ExchCode = 'DEU' WHERE SecCode = 4813578 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 4815196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865900341, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4819644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4819878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301751, ExchCode = 'FRA' WHERE SecCode = 4852142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874654366, ExchCode = 'MUN' WHERE SecCode = 4887144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177205, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878357041, ExchCode = 'FRA' WHERE SecCode = 4911198 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4913069 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388746, ExchCode = 'LAS' WHERE SecCode = 4927268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882167707, PermQuoteStatus = 'AC', Ticker = 'Y232', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4934325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890421877, ExchCode = 'MUN' WHERE SecCode = 4950864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886412706, ExchCode = 'FRA' WHERE SecCode = 4965055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888956134, ExchCode = 'STU' WHERE SecCode = 4973326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21926247930, PermQuoteStatus = 'DC', Ticker = 'V6M', ExchCode = 'FRA', PermQuoteRetireDate = '2022-10-31' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779058751, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = '2025-07-01' WHERE SecCode = 5004799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198471, ExchCode = 'FRA' WHERE SecCode = 5011656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195445, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430452, ExchCode = 'DEU' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634297955, Ticker = '0M1Kl', ExchCode = 'BCO' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589470, Ticker = 'RPGG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 5161292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955191864, ExchCode = 'DUS' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947744427, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 5182664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923425218, ExchCode = 'DEU' WHERE SecCode = 5183106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933953345, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923944044, ExchCode = 'DEU' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924152322, ExchCode = 'FRA' WHERE SecCode = 5194304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924155635, ExchCode = 'DEU' WHERE SecCode = 5194305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834872, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836196, Ticker = 'AFTTp', ExchCode = 'EQD' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093287267, Ticker = 'ALINKa', ExchCode = 'BCO' WHERE SecCode = 5206286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836113, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5208067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47733359573, ExchCode = 'DEU' WHERE SecCode = 5209761 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5220908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930758973, ExchCode = 'DUS' WHERE SecCode = 5234294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227057, ExchCode = 'BIV' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794004180, ExchCode = 'QTX' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222348, ExchCode = 'MEX' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397466, PermQuoteStatus = 'DC', ExchCode = 'CHI', PermQuoteRetireDate = '2026-03-12' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939720495, ExchCode = 'FRA' WHERE SecCode = 5281346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537961037, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979385, ExchCode = 'DUS' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953922612, ExchCode = 'GTX', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = '2025-08-06' WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943095863, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 5313552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159093914, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2026-02-25' WHERE SecCode = 5315560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951358875, ExchCode = 'STU' WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732431, ExchCode = 'MEX' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777252955, ExchCode = 'HAM' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633841, ExchCode = 'FRA' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891323, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-14', PermSecMapEndDate = '2025-01-14' WHERE SecCode = 5352019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910298, ExchCode = 'MUN' WHERE SecCode = 5354973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954130974, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 5359525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486479, ExchCode = 'DUS' WHERE SecCode = 5366367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388899, ExchCode = 'LAS' WHERE SecCode = 5366368 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951705.0 WHERE SecCode = 5369080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803603455, ExchCode = 'TDG' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951826.0 WHERE SecCode = 5380504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520770967, ExchCode = 'DEU' WHERE SecCode = 5383600 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 5384542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960349374, ExchCode = 'QTX' WHERE SecCode = 5387257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812181526, ExchCode = 'FRA' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202565, ExchCode = 'BIV' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951705.0 WHERE SecCode = 5420928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528228, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-10-11' WHERE SecCode = 5442477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777892395, ExchCode = 'GTX' WHERE SecCode = 5444086 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 5447475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727169122, Ticker = 'CAMBIo', ExchCode = 'SIG' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 5454654 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 5460506 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 5468579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299986, ExchCode = 'FRA' WHERE SecCode = 5468673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 5482523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659888, ExchCode = 'BIV' WHERE SecCode = 5496143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982260691, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5496242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982274729, Ticker = '3BAS', ExchCode = 'MIL' WHERE SecCode = 5496244 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 5499422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245046, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528245, ExchCode = 'STU' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834825, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779282458, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5527546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779282595, ExchCode = 'FRA' WHERE SecCode = 5527547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779292324, ExchCode = 'FRA' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779292327, ExchCode = 'FRA' WHERE SecCode = 5527561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471348, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223818, ExchCode = 'QTX' WHERE SecCode = 5544209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796182522, ExchCode = 'TDG' WHERE SecCode = 5547972 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5550770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786101497, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993578810, ExchCode = 'DEU' WHERE SecCode = 5556440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993578726, ExchCode = 'DEU' WHERE SecCode = 5556443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544649, ExchCode = 'DUS' WHERE SecCode = 5556444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835651, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580185, ExchCode = 'DEU' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835728, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110915, Ticker = '3MRNm', ExchCode = 'BCO' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 5579584 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 5581947 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5584706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212166, ExchCode = 'BIV' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309552, ExchCode = 'BIV' WHERE SecCode = 5626507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942899, ExchCode = 'BIV' WHERE SecCode = 5631516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714446430, ExchCode = 'DXE' WHERE SecCode = 5638833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460790, ExchCode = 'GER' WHERE SecCode = 5638838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835007, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22065452994, ExchCode = 'BRN' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954864, ExchCode = 'LAS' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5663500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781580967, ExchCode = 'STU' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781701952, ExchCode = 'STU' WHERE SecCode = 5669593 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5677491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22027362169, ExchCode = 'STU' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489860, Ticker = '1HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 5726745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097265, ExchCode = 'LAS' WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5760417 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5761979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783112234, ExchCode = 'FRA' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783529905, ExchCode = 'FRA' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154585726, ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914265, Ticker = 'RZ8B', ExchCode = 'STU' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22042870510, ExchCode = 'DEU' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784326338, ExchCode = 'STU' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327232, ExchCode = 'FRA' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377679, ExchCode = 'STU' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377678, ExchCode = 'FRA' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357765, ExchCode = 'BIV' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784713326, ExchCode = 'MUN' WHERE SecCode = 5839259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600489, ExchCode = 'STU' WHERE SecCode = 5839460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913642, ExchCode = 'DEU' WHERE SecCode = 5839461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864886453, ExchCode = 'GTX' WHERE SecCode = 5908811 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 5947041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798426612, ExchCode = 'GTX' WHERE SecCode = 5947065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22070354815, ExchCode = 'DEU' WHERE SecCode = 6012971 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6043593 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN', IncCntry = 'CAN' WHERE SecCode = 6082589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293346, ExchCode = 'MUN' WHERE SecCode = 6097356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580161, ExchCode = 'DEU' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892052934, ExchCode = 'DEU' WHERE SecCode = 6097368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993578569, ExchCode = 'CHI' WHERE SecCode = 6097606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794707885, ExchCode = 'STU' WHERE SecCode = 6130384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408472, ExchCode = 'STU' WHERE SecCode = 6147594 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6160888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789803304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-06', PermSecMapEndDate = '2026-03-06' WHERE SecCode = 6260557 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 6264136 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6291847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855803, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 6347434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954979, ExchCode = 'LAS' WHERE SecCode = 6364834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228183, ExchCode = 'TDG' WHERE SecCode = 6371577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745447, ExchCode = 'MEX' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866542, ExchCode = 'BIV' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794030741, ExchCode = 'DUS' WHERE SecCode = 6383874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794048993, ExchCode = 'FRA' WHERE SecCode = 6383880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794320484, ExchCode = 'FRA' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799304965, ExchCode = 'CHA' WHERE SecCode = 6421140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083975572, ExchCode = 'QTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793789294, ExchCode = 'TDG' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795166766, ExchCode = 'TDG' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 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 = 236796057757, ExchCode = 'MUN' WHERE SecCode = 6448294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140986, ExchCode = 'MUN' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109710, ExchCode = 'QTX' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269870, ExchCode = 'FRA' WHERE SecCode = 6528817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269868, ExchCode = 'FRA' WHERE SecCode = 6528818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798142642, ExchCode = 'TDG' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474943, ExchCode = 'FRA' WHERE SecCode = 6577960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607052, Ticker = 'MRNA', ExchCode = 'SWX' WHERE SecCode = 6578363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727300993, Ticker = '724', ExchCode = 'BRN' WHERE SecCode = 6578367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955916, ExchCode = 'FRA' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957446, ExchCode = 'FRA' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228281, ExchCode = 'FRA' WHERE SecCode = 6593800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-27' WHERE SecCode = 6614117 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 6622352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541597, ExchCode = 'FRA' WHERE SecCode = 6627152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541595, ExchCode = 'FRA' WHERE SecCode = 6627153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801541760, ExchCode = 'FRA' WHERE SecCode = 6627155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833039, ExchCode = 'MEX' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 6631786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806317305, ExchCode = 'GTX' WHERE SecCode = 6672565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755612, ExchCode = 'FRA' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755696, ExchCode = 'FRA' WHERE SecCode = 6737927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755694, ExchCode = 'FRA' WHERE SecCode = 6737928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805232356, ExchCode = 'FRA' WHERE SecCode = 6756491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170639813, ExchCode = 'DEU' WHERE SecCode = 6756496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170639977, ExchCode = 'DEU' WHERE SecCode = 6756497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170653580, ExchCode = 'DEU' WHERE SecCode = 6756501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805699078, ExchCode = 'TDG' WHERE SecCode = 6756502 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 6765403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171720886, ExchCode = 'DEU' WHERE SecCode = 6769258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429842, ExchCode = 'DUS' WHERE SecCode = 6769259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901586, ExchCode = 'CHI' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 6782592 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 6786366 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 6786367 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-27' WHERE SecCode = 6786378 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 6789477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126941, ExchCode = 'DEU' WHERE SecCode = 6793389 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 6793565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140087946, ExchCode = 'HAM' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-28', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 6797277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176021538, ExchCode = 'DEU' WHERE SecCode = 6797339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806019658, ExchCode = 'MEX' WHERE SecCode = 6797367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806018739, ExchCode = 'FRA' WHERE SecCode = 6797368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806166493, ExchCode = 'TDG' WHERE SecCode = 6802839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175080525, ExchCode = 'DEU' WHERE SecCode = 6802840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102104, ExchCode = 'BIV' WHERE SecCode = 6802842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175082466, ExchCode = 'DEU' WHERE SecCode = 6802844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175082544, ExchCode = 'DEU' WHERE SecCode = 6802846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175087788, ExchCode = 'DEU' WHERE SecCode = 6802847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175082295, ExchCode = 'DEU' WHERE SecCode = 6802848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175399896, ExchCode = 'DEU' WHERE SecCode = 6802854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175399826, ExchCode = 'DEU' WHERE SecCode = 6802859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175402128, ExchCode = 'DEU' WHERE SecCode = 6802860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175399920, ExchCode = 'DEU' WHERE SecCode = 6802861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228771, ExchCode = 'FRA' WHERE SecCode = 6813221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228774, ExchCode = 'FRA' WHERE SecCode = 6813222 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10913588 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10973822 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11003299 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11035304 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11036659 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11046498 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 11047368 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-27', PermSecMapEndDate = NULL WHERE SecCode = 11051676 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11059253 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11072235 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11109486 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11113926 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11138578 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11140503 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11140504 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11141357 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11150269 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11153361 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-27' WHERE SecCode = 11163274 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'THA' WHERE SecCode = 11172169 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 11172678 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11175524 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11177629 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11184214 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 11192522 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 11192685 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11195366 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11197962 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11198876 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11206893 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 11213942 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11214755 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11215252 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11216254 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11216358 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 11217524 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 11220338 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-28', PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11221441 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11221687 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11224790 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11238402 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11244158 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11245064 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11253723 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 11262296 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11272365 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11275630 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11277669 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11277717 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11287378 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11287380 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11287388 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11287389 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11287390 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11287391 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-28', PermSecMapEndDate = NULL WHERE SecCode = 11290681 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11291127 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11291128 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11292609 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-28' WHERE SecCode = 11292611 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 11294022 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-28' WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-21' WHERE SecCode = 11294716 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951816.0 WHERE SecCode = 11294934 AND Type_ = 1;