UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-12', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779690608, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115997, Ticker = '77GEl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-07-09' WHERE SecCode = 971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484676855, ExchCode = 'EQD' WHERE SecCode = 2503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852139947, PermQuoteStatus = 'AC', Ticker = '0O1C', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 7986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475107301, Ticker = 'IJFi', ExchCode = 'BTE' WHERE SecCode = 8027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705000, ExchCode = 'MXQ' WHERE SecCode = 30139 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'NMS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 32562 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034761, PermQuoteStatus = 'AC', Ticker = 'ALD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322896, ExchCode = 'BER', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, ExchCode = 'DEU' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836462028, ExchCode = 'FRA' WHERE SecCode = 35017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033945, PermQuoteStatus = 'AC', Ticker = 'BYG', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 35163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830297965, ExchCode = 'GTX' WHERE SecCode = 35214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451616, Ticker = 'PHI', ExchCode = 'SWX' WHERE SecCode = 37235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744262672, ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-22' WHERE SecCode = 37400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486615, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 37401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661362178, ExchCode = 'STU' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 43244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852201118, ExchCode = 'GTX' WHERE SecCode = 44260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627424, Ticker = 'CPZ1', ExchCode = 'DEU' WHERE SecCode = 44270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869550648, ExchCode = 'GTX' WHERE SecCode = 44312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599532241, ExchCode = 'DEU', PermQuoteRetireDate = '2025-07-24' WHERE SecCode = 44313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947043286, ExchCode = 'GTX' WHERE SecCode = 44320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489580, ExchCode = 'QTX' WHERE SecCode = 45029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475541914, ExchCode = 'MUN', PermQuoteRetireDate = '2010-01-13' WHERE SecCode = 45085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247713, ExchCode = 'STU' WHERE SecCode = 45088 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 45120 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21532854931, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324683, ExchCode = 'BER' WHERE SecCode = 45854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354839, Ticker = 'EGID', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 45916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328604, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795166785, ExchCode = 'FRA' WHERE SecCode = 53688 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 59308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474924570, Ticker = 'BTBB', ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06' WHERE SecCode = 59414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837365688, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474903504, ExchCode = 'DEU' WHERE SecCode = 60025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457917, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2007-11-28' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386338, ExchCode = 'FRA' WHERE SecCode = 60097 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302241, ExchCode = 'GTX' WHERE SecCode = 60111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474961910, ExchCode = 'DEU', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 60202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358975, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485991, ExchCode = 'QTX' WHERE SecCode = 60403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374661, ExchCode = 'DEU' WHERE SecCode = 61355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608399459, ExchCode = 'DEU' WHERE SecCode = 61371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838349451, ExchCode = 'STU' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836451985, ExchCode = 'FRA', PermQuoteRetireDate = '2017-07-12' WHERE SecCode = 61724 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486851, ExchCode = 'QTX' WHERE SecCode = 62204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605378795, ExchCode = 'STU' WHERE SecCode = 62253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427817, ExchCode = 'DEU' WHERE SecCode = 62547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488554, ExchCode = 'QTX' WHERE SecCode = 63834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487584, ExchCode = 'QTX' WHERE SecCode = 65586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794054785, ExchCode = 'FRA' WHERE SecCode = 66737 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GA8' WHERE SecCode = 74740 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 82729 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 86411 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 90297 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 90958 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-15' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SOLDA', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CEMPRO' WHERE SecCode = 97785 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 99982 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 100102 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 100312 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 103573 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 111747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647854778, ExchCode = 'DEU' WHERE SecCode = 111810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571420277, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486937555, ExchCode = 'STU' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335260, ExchCode = 'BER' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726152, ExchCode = 'DEU' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390660, ExchCode = 'FRA' WHERE SecCode = 112049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870865253, ExchCode = 'FRA' WHERE SecCode = 112064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661189444, ExchCode = 'FRA' WHERE SecCode = 112078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000480221, ExchCode = 'DEU' WHERE SecCode = 112079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295811, ExchCode = 'GTX' WHERE SecCode = 112129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419772, ExchCode = 'HAM' WHERE SecCode = 112135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332781, ExchCode = 'BER' WHERE SecCode = 112143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527717624, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384599, ExchCode = 'LAS' WHERE SecCode = 113578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043361, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-08', PermSecMapEndDate = NULL WHERE SecCode = 113979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624604806, ExchCode = 'STU' WHERE SecCode = 114028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488397, ExchCode = 'QTX' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123504, ExchCode = 'FRA' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173501, Ticker = 'ESL', ExchCode = 'BRN' WHERE SecCode = 126877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329157, ExchCode = 'BER' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909445, ExchCode = 'FRA' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 132068 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795104269, ExchCode = 'QTX' WHERE SecCode = 133778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330072, ExchCode = 'BER' WHERE SecCode = 136933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781307318, ExchCode = 'QTX' WHERE SecCode = 136934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058705, ExchCode = 'DEU' WHERE SecCode = 136936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822360, ExchCode = 'DEU' WHERE SecCode = 136946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452946, ExchCode = 'DEU' WHERE SecCode = 137236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492614, ExchCode = 'QTX' WHERE SecCode = 137300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195836, ExchCode = 'FRA' WHERE SecCode = 137437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474930012, ExchCode = 'DEU' WHERE SecCode = 137480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860349, ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-09', PermSecMapEndDate = '2024-04-09' WHERE SecCode = 137668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334039, ExchCode = 'BER' WHERE SecCode = 137669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359225, ExchCode = 'GER' WHERE SecCode = 137682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469794, ExchCode = 'QTX' WHERE SecCode = 137691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492299, ExchCode = 'QTX' WHERE SecCode = 137720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521224187, ExchCode = 'STU' WHERE SecCode = 137791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842886562, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 137794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518681206, ExchCode = 'TDG' WHERE SecCode = 137851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535196609, Ticker = '8604', ExchCode = 'BRN', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 137856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516376146, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 137873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512264703, Ticker = 'WENo', ExchCode = 'STO', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 137904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341772, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 139011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655828004, ExchCode = 'FRA', PermQuoteRetireDate = '2023-09-15' WHERE SecCode = 139013 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 141788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507475103, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-10', PermSecMapEndDate = NULL WHERE SecCode = 143069 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574086997, PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 143248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519207, ExchCode = 'DUS', PermQuoteRetireDate = '2014-12-16' WHERE SecCode = 144542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520583826, ExchCode = 'TDG' WHERE SecCode = 144735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569877, ExchCode = 'QTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611106182, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 144853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775812261, ExchCode = 'DEU' WHERE SecCode = 144858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396053, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2017-04-24' WHERE SecCode = 145644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323754, ExchCode = 'BER' WHERE SecCode = 146221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460836, ExchCode = 'HAN' WHERE SecCode = 146223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773000733, ExchCode = 'MUN' WHERE SecCode = 146257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793968535, ExchCode = 'FRA' WHERE SecCode = 146440 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 146978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793690706, ExchCode = 'FRA' WHERE SecCode = 147011 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'A98' WHERE SecCode = 147190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484697, ExchCode = 'QTX' WHERE SecCode = 147470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308280, ExchCode = 'GTX' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308439, ExchCode = 'GTX' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491141379, ExchCode = 'STU' WHERE SecCode = 150697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484065, ExchCode = 'QTX' WHERE SecCode = 161315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740430, ExchCode = 'DEU' WHERE SecCode = 175561 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 177307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622517895, ExchCode = 'DEU' WHERE SecCode = 177315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856949142, ExchCode = 'GER' WHERE SecCode = 177328 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 178267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU' WHERE SecCode = 180684 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 = 21539524265, Ticker = 'GHNd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-08-12' WHERE SecCode = 185771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569833, ExchCode = 'QTX' WHERE SecCode = 186811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835821866, ExchCode = 'MEX' WHERE SecCode = 196404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509902864, Ticker = 'SOYP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850634826, PermQuoteStatus = 'DC', Ticker = 'IY3', ExchCode = 'STU', PermQuoteRetireDate = '2014-08-08' WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419395, ExchCode = 'HAM' WHERE SecCode = 210711 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 214104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610591242, ExchCode = 'TDG' WHERE SecCode = 248924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474917055, ExchCode = 'DEU' WHERE SecCode = 248925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587576, Ticker = 'TYPd', ExchCode = 'BCO' WHERE SecCode = 248961 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 252477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784278058, ExchCode = 'STU' WHERE SecCode = 255607 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 286050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323052, ExchCode = 'BER', PermQuoteRetireDate = '2014-01-22' WHERE SecCode = 288474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700198266, ExchCode = 'FRA' WHERE SecCode = 289461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373346, ExchCode = 'DEU' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SBM.H', ExchCode = 'NEX' WHERE SecCode = 306578 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236792995980, ExchCode = 'FRA' WHERE SecCode = 320838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836054231, Ticker = 'XMAD', ExchCode = 'LSE' WHERE SecCode = 321193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506942102, ExchCode = 'STU' WHERE SecCode = 326261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320619, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29' WHERE SecCode = 326282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521104135, ExchCode = 'STU' WHERE SecCode = 326285 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 331648 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838302829, PermQuoteStatus = 'DC', Ticker = 'BRE.IT', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838297513, Ticker = 'DRN.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388051, Ticker = 'DNB.OL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838298380, PermQuoteStatus = 'DC', Ticker = 'ESY.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 332181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474988453, PermQuoteStatus = 'AC', Ticker = '0MG1', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672362, Ticker = '0DFR', ExchCode = 'LSE', PermQuoteRetireDate = '2014-05-01' WHERE SecCode = 332205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838301423, Ticker = 'KQIP.NL', ExchCode = 'PLU', PermQuoteRetireDate = '2010-06-15' WHERE SecCode = 332212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475510397, PermQuoteStatus = 'DC', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 335172 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365381.0 WHERE SecCode = 336707 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21620411337, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-17' WHERE SecCode = 336764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 347970 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55834672212, Ticker = '0OA8', ExchCode = 'LSE', PermQuoteRetireDate = '2012-07-02' WHERE SecCode = 351265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673143, Ticker = '0NY0', ExchCode = 'LSE', PermQuoteRetireDate = '2015-09-30' WHERE SecCode = 351274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673962, PermQuoteStatus = 'AC', Ticker = '0OGK', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 351284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348908, ExchCode = 'FRA' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509803171, Ticker = NULL, ExchCode = 'LSE' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834676941, Ticker = '0O93', ExchCode = 'LSE', PermQuoteRetireDate = '2022-09-20' WHERE SecCode = 353956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561786, ExchCode = 'GTX' WHERE SecCode = 360956 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 381015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, PermQuoteStatus = 'AC', Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55879740079, Ticker = 'COM.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 523414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 558354 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 559630 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 1122444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958575, ExchCode = 'FRA' WHERE SecCode = 1447807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480912846, ExchCode = 'DEU' WHERE SecCode = 1447851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481777624, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 1453952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228292, Ticker = 'BLIT', ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477469688, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-01' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478824473, ExchCode = 'TDG' WHERE SecCode = 1480701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480791079, ExchCode = 'STO' WHERE SecCode = 1481237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490163342, Ticker = 'GSD', ExchCode = 'STU', PermQuoteRetireDate = '2014-03-06' WHERE SecCode = 1489390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, ExchCode = 'FRA' WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484181633, ExchCode = 'FRA' WHERE SecCode = 1525503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129370, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2015-02-10' WHERE SecCode = 1555489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517016445, ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 2018342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168579, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 2043507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522907490, Ticker = 'EEE', ExchCode = 'ATH' WHERE SecCode = 2226945 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GA8' WHERE SecCode = 2255680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530485265, ExchCode = 'DEU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-14' WHERE SecCode = 2483617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327643, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-22' WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908261047, Ticker = '1AAPLm', ExchCode = 'EQD' WHERE SecCode = 2571666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545105822, ExchCode = 'FRA' WHERE SecCode = 2604390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549116547, ExchCode = 'BER' WHERE SecCode = 2655948 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GA8' WHERE SecCode = 2800403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557245542, ExchCode = 'STU' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544170, ExchCode = 'MUN', PermQuoteRetireDate = '2018-07-05' WHERE SecCode = 2837420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761799, ExchCode = 'DEU' WHERE SecCode = 2856999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563177438, ExchCode = 'DEU' WHERE SecCode = 2887312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621432674, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621432527, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 3121290 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3195638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720719093, ExchCode = 'BER', PermQuoteRetireDate = '2023-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3215568 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 3234677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605105387, ExchCode = 'BER', PermQuoteRetireDate = '2019-02-08' WHERE SecCode = 3283717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22112085792, PermQuoteStatus = 'AC', Ticker = 'SGLDa', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3301728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 3338654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617889188, ExchCode = 'CHA' WHERE SecCode = 3378309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867512394, ExchCode = 'FRA' WHERE SecCode = 3378316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636815378, Ticker = '0Q1F', ExchCode = 'LSE' WHERE SecCode = 3378492 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 3408516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640834967, ExchCode = 'FRA' WHERE SecCode = 3434745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679819, ExchCode = 'BIV' WHERE SecCode = 3434746 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3441196 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3441322 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3491875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3555905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 3586968 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3599726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665390029, ExchCode = 'STU' WHERE SecCode = 3619112 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3625877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703807976, PermQuoteStatus = 'AC', Ticker = 'VUSAm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3736025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461787, ExchCode = 'FRA' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785774618, ExchCode = 'FRA' WHERE SecCode = 3793376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704497, ExchCode = 'MXQ' WHERE SecCode = 3793437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704296, ExchCode = 'MXQ' WHERE SecCode = 3793438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376097, ExchCode = 'MEX' WHERE SecCode = 3799556 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3813284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692561684, ExchCode = 'DEU' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371514, ExchCode = 'BIV' WHERE SecCode = 3849233 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3852818 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3858018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245385, ExchCode = 'DEU' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704921848, ExchCode = 'DEU' WHERE SecCode = 3906532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725178113, ExchCode = 'BER' WHERE SecCode = 3956835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731261056, Ticker = '0A2Zl', ExchCode = 'BCO' WHERE SecCode = 3986787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924367856, ExchCode = 'GTX' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727361952, ExchCode = 'MEX' WHERE SecCode = 4001279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720521413, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-12' WHERE SecCode = 4010838 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4018434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727358583, ExchCode = 'BIV' WHERE SecCode = 4038260 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4046425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412273, ExchCode = 'DEU', PermQuoteRetireDate = '2020-01-22', PermSecMapEndDate = '2020-01-22' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779527, ExchCode = 'DUS' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733309946, ExchCode = 'FRA' WHERE SecCode = 4087855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738262837, Ticker = '5C8', ExchCode = 'FRA' WHERE SecCode = 4090028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 4101126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304629, ExchCode = 'DEU' WHERE SecCode = 4110883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966716, ExchCode = 'FRA' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739310110, ExchCode = 'DEU' WHERE SecCode = 4134386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780559871, ExchCode = 'STU' WHERE SecCode = 4134450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21868559772, ExchCode = 'QTX' WHERE SecCode = 4169151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918743, ExchCode = 'DEU' WHERE SecCode = 4193439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351142, ExchCode = 'BIV' WHERE SecCode = 4195318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749833486, ExchCode = 'STU' WHERE SecCode = 4203138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858560, ExchCode = 'QTX' WHERE SecCode = 4209247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350451, ExchCode = 'BIV' WHERE SecCode = 4212368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486435, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388481, ExchCode = 'LAS' WHERE SecCode = 4248831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295374, ExchCode = 'GTX' WHERE SecCode = 4310575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580130, ExchCode = 'FRA' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783589639, ExchCode = 'QTX' WHERE SecCode = 4328960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768600657, ExchCode = 'FRA' WHERE SecCode = 4346650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767996950, ExchCode = 'FRA' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768596580, ExchCode = 'TDG' WHERE SecCode = 4351435 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4371536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776573519, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-30' WHERE SecCode = 4388204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991935, ExchCode = 'FRA' WHERE SecCode = 4391296 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4394733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281522, ExchCode = 'STU', PermQuoteRetireDate = '2025-03-14' WHERE SecCode = 4394756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786088093, ExchCode = 'BER' WHERE SecCode = 4394760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS', PermQuoteRetireDate = '2022-05-31', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780228924, ExchCode = 'GTX', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 4400159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782177869, ExchCode = 'DEU' WHERE SecCode = 4404026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991977, ExchCode = 'FRA' WHERE SecCode = 4410618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896376172, ExchCode = 'DEU' WHERE SecCode = 4410619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829123402, ExchCode = 'STU' WHERE SecCode = 4410622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, ExchCode = 'BER' 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 = 21815337110, ExchCode = 'DEU' WHERE SecCode = 4423907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879563641, ExchCode = 'MUN' WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786088087, ExchCode = 'BER' WHERE SecCode = 4438384 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL WHERE SecCode = 4443925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384193, ExchCode = 'LAS' WHERE SecCode = 4456099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791932285, ExchCode = 'DUS' WHERE SecCode = 4462870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789562372, ExchCode = 'FRA' WHERE SecCode = 4463053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727302048, ExchCode = 'BIV' WHERE SecCode = 4463160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388562, ExchCode = 'LAS' WHERE SecCode = 4472933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674438, ExchCode = 'DUS' WHERE SecCode = 4472940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712131273, ExchCode = 'DEU' WHERE SecCode = 4474227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815902455, ExchCode = 'STU' WHERE SecCode = 4477048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794808195, ExchCode = 'STU' WHERE SecCode = 4479186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794654351, ExchCode = 'FRA' WHERE SecCode = 4479279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264731, ExchCode = 'MUN' WHERE SecCode = 4485993 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 4499280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798385267, ExchCode = 'DEU' WHERE SecCode = 4502472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794711480, ExchCode = 'LAS' WHERE SecCode = 4505788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285167, ExchCode = 'GTX' WHERE SecCode = 4511507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, ExchCode = 'GTX' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886801843, ExchCode = 'GTX' WHERE SecCode = 4557762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381354, ExchCode = 'LAS' WHERE SecCode = 4557929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385286, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-10', PermSecMapEndDate = NULL WHERE SecCode = 4568425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777449320, ExchCode = 'TDG' WHERE SecCode = 4568460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809547031, ExchCode = 'DEU' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991715, ExchCode = 'DEU' WHERE SecCode = 4573512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854765, ExchCode = 'DEU' WHERE SecCode = 4579661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854709, ExchCode = 'FRA' WHERE SecCode = 4579663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991551, ExchCode = 'DEU' WHERE SecCode = 4579688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 4580740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785979680, ExchCode = 'FRA' WHERE SecCode = 4588269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145875, ExchCode = 'TDG' WHERE SecCode = 4592046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177254, ExchCode = 'DEU' WHERE SecCode = 4592047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515358, ExchCode = 'GTX' WHERE SecCode = 4593304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196422, ExchCode = 'DUS' WHERE SecCode = 4593306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778820333, ExchCode = 'QTX' WHERE SecCode = 4595746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850700597, ExchCode = 'STU' WHERE SecCode = 4595786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153723, ExchCode = 'FRA' WHERE SecCode = 4601827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385303, ExchCode = 'LAS' WHERE SecCode = 4601892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815921838, ExchCode = 'DEU' WHERE SecCode = 4607713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22107546462, Ticker = 'ABTCa', ExchCode = 'BCO' WHERE SecCode = 4613095 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4613936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818256303, ExchCode = 'STU' WHERE SecCode = 4617716 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4618015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818936644, Ticker = 'TGLD', ExchCode = 'SWX', PermQuoteRetireDate = '2023-01-11', PermSecMapEndDate = '2023-01-11' WHERE SecCode = 4620075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818936763, Ticker = 'TPLT', ExchCode = 'SWX', PermQuoteRetireDate = '2023-01-11' WHERE SecCode = 4620077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293770, ExchCode = 'TDG' WHERE SecCode = 4620160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912799, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-14' WHERE SecCode = 4620951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778181553, ExchCode = 'STU' WHERE SecCode = 4623226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729626, ExchCode = 'FRA', PermQuoteRetireDate = '2021-06-22', PermSecMapEndDate = NULL WHERE SecCode = 4631952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822562044, ExchCode = 'DEU' WHERE SecCode = 4636547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954590855, ExchCode = 'STU' WHERE SecCode = 4639567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823512839, ExchCode = 'FRA' WHERE SecCode = 4640286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823808235, ExchCode = 'DEU' WHERE SecCode = 4643066 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4646622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380595, ExchCode = 'LAS' WHERE SecCode = 4650007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047430, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-01' WHERE SecCode = 4661400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829125937, ExchCode = 'FRA' WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829398967, ExchCode = 'STU' WHERE SecCode = 4664721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831917952, ExchCode = 'DEU' WHERE SecCode = 4677594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911881123, ExchCode = 'DEU' WHERE SecCode = 4677626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835618383, ExchCode = 'FRA' WHERE SecCode = 4682735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793284943, ExchCode = 'TDG' WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841739063, ExchCode = 'STU' WHERE SecCode = 4695820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832282236, ExchCode = 'MXQ' WHERE SecCode = 4695826 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037563, PermQuoteStatus = 'DC', Ticker = 'LUH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-12-13' WHERE SecCode = 4702654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235607, ExchCode = 'MEX' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890563, ExchCode = 'DEU' WHERE SecCode = 4709614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329726, ExchCode = 'QTX' WHERE SecCode = 4709615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908294, ExchCode = 'DUS' WHERE SecCode = 4717140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846029349, ExchCode = 'BER' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777507077, ExchCode = 'STU' WHERE SecCode = 4722143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788449235, ExchCode = 'TDG' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847343480, ExchCode = 'GTX' WHERE SecCode = 4730169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847351964, ExchCode = 'FRA' WHERE SecCode = 4733108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569865, ExchCode = 'QTX' WHERE SecCode = 4745386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345317, ExchCode = 'STU' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851844389, ExchCode = 'DUS' WHERE SecCode = 4752241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727224773, ExchCode = 'BIV' WHERE SecCode = 4753728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852738501, ExchCode = 'DEU' WHERE SecCode = 4756507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853429898, ExchCode = 'MUN' WHERE SecCode = 4756620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439422, ExchCode = 'DUS' WHERE SecCode = 4756621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689585, ExchCode = 'DXE' WHERE SecCode = 4761548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518308, ExchCode = 'FRA' WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615485, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4800489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860307416, ExchCode = 'TDG' WHERE SecCode = 4800673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904412215, ExchCode = 'GTX' WHERE SecCode = 4810002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862297960, ExchCode = 'FRA' WHERE SecCode = 4811143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879552085, ExchCode = 'TDG' WHERE SecCode = 4827911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212163, ExchCode = 'BIV' WHERE SecCode = 4827941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858571, ExchCode = 'QTX' WHERE SecCode = 4830962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792865438, ExchCode = 'GTX' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4846938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778036716, ExchCode = 'MUN' WHERE SecCode = 4862983 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4873686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386324, ExchCode = 'LAS' WHERE SecCode = 4885536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783749213, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 4887111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945198768, ExchCode = 'BER' WHERE SecCode = 4890357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21875131252, ExchCode = 'FRA' WHERE SecCode = 4893235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878356554, ExchCode = 'DEU' WHERE SecCode = 4911199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727203536, ExchCode = 'BIV' WHERE SecCode = 4918915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881260859, ExchCode = 'STU' WHERE SecCode = 4925667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881998635, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-25', PermSecMapEndDate = '2022-03-25' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884030447, ExchCode = 'MUN' WHERE SecCode = 4949697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893301199, ExchCode = 'GTX' WHERE SecCode = 4952512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875594, ExchCode = 'MUN' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951554681, ExchCode = 'STU' WHERE SecCode = 4958004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279764, ExchCode = 'MUN' WHERE SecCode = 4972276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888704331, PermQuoteStatus = 'AC', Ticker = 'V6M1', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577630, ExchCode = 'TDG' WHERE SecCode = 4991558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-07' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198173, ExchCode = 'BIV' WHERE SecCode = 5002475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897339624, ExchCode = 'FRA' WHERE SecCode = 5025182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388828, ExchCode = 'LAS' WHERE SecCode = 5038683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949618, ExchCode = 'PFT' WHERE SecCode = 5040232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209599, ExchCode = 'DEU' WHERE SecCode = 5059306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659538, ExchCode = 'LAS' WHERE SecCode = 5067501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569848, ExchCode = 'QTX' WHERE SecCode = 5067503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821965, ExchCode = 'QTX' WHERE SecCode = 5102906 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5104594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910716265, ExchCode = 'FRA' WHERE SecCode = 5116970 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, ExchCode = 'BER' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380648, ExchCode = 'LAS' WHERE SecCode = 5156833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627704, ExchCode = 'QTX' WHERE SecCode = 5168260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920552457, ExchCode = 'DEU' WHERE SecCode = 5168261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920980941, Ticker = 'Z6M0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 5168340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809874, ExchCode = 'GTX' WHERE SecCode = 5174469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928854434, ExchCode = 'GTX' WHERE SecCode = 5209798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132598, ExchCode = 'DEU' WHERE SecCode = 5218830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930806960, ExchCode = 'DEU' WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395668, ExchCode = 'FRA' WHERE SecCode = 5253712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009367, ExchCode = 'CHA' WHERE SecCode = 5261340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397463, Ticker = 'PB7d', ExchCode = 'BTE' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942349169, ExchCode = 'QTX' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937480514, ExchCode = 'BER' WHERE SecCode = 5310445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659544, ExchCode = 'LAS' WHERE SecCode = 5315601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397462, Ticker = 'CQ0d', ExchCode = 'BTE', PermQuoteRetireDate = '2025-05-27' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777698959, ExchCode = 'TDG' WHERE SecCode = 5322460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381675, ExchCode = 'LAS' WHERE SecCode = 5324084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949435332, ExchCode = 'GTX' WHERE SecCode = 5332356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950815916, ExchCode = 'DEU' WHERE SecCode = 5343552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626936, ExchCode = 'DEU' WHERE SecCode = 5349683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832380, ExchCode = 'FRA' WHERE SecCode = 5350576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891323, ExchCode = 'STU' WHERE SecCode = 5352019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107274, ExchCode = 'FRA' WHERE SecCode = 5353914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514234, ExchCode = 'DUS' WHERE SecCode = 5360992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581953, ExchCode = 'BIV' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201516, ExchCode = 'DEU' WHERE SecCode = 5388846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758791, ExchCode = 'MUN' WHERE SecCode = 5393777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829302, ExchCode = 'TDG' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777803100, ExchCode = 'MEX' WHERE SecCode = 5440528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778265393, ExchCode = 'STU' WHERE SecCode = 5466184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778500352, ExchCode = 'MEX' WHERE SecCode = 5481081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778820209, ExchCode = 'STU' WHERE SecCode = 5497202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787118150, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-08' WHERE SecCode = 5506510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223859, ExchCode = 'QTX' WHERE SecCode = 5506511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21984114239, ExchCode = 'DEU' WHERE SecCode = 5506512 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5509433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911223, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 5509596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986201526, ExchCode = 'DEU' WHERE SecCode = 5516455 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5527283 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5527520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781906283, ExchCode = 'TDG' WHERE SecCode = 5527546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779256326, ExchCode = 'MEX' WHERE SecCode = 5531898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471181, ExchCode = 'MEX' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21991233126, ExchCode = 'DEU' WHERE SecCode = 5546677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471183, ExchCode = 'BIV' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, ExchCode = 'FRA' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779708089, ExchCode = 'STU' WHERE SecCode = 5558240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060456, ExchCode = 'TDG' WHERE SecCode = 5560522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487159, ExchCode = 'MUN' WHERE SecCode = 5603349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781012608, ExchCode = 'STU' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780990202, ExchCode = 'FRA' WHERE SecCode = 5631726 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5658381 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5658401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100058, PermQuoteStatus = 'AC', Ticker = 'ZK7', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 5697992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028891058, ExchCode = 'STU' WHERE SecCode = 5726747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782930891, ExchCode = 'MUN' WHERE SecCode = 5753987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078228, ExchCode = 'LAS' WHERE SecCode = 5754012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353275, ExchCode = 'STU' WHERE SecCode = 5779319 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 5807735 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5808176 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5814580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107268, ExchCode = 'FRA' WHERE SecCode = 5814835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785660798, ExchCode = 'STU' WHERE SecCode = 5886967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785605367, Ticker = '4WL0', ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-30', PermSecMapEndDate = '2025-04-30' WHERE SecCode = 5894939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785946324, ExchCode = 'BIV' WHERE SecCode = 5908827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786584011, ExchCode = 'STU' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786016617, ExchCode = 'STU' WHERE SecCode = 5908830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22077468824, ExchCode = 'CHI' WHERE SecCode = 5951017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795035713, ExchCode = 'FRA' WHERE SecCode = 5969285 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5981830 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6006778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759315, ExchCode = 'MUN' WHERE SecCode = 6041427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22003906983, Ticker = 'XDGUz', ExchCode = 'SIG' WHERE SecCode = 6097276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782305154, ExchCode = 'MEX' WHERE SecCode = 6097558 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 6264204 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 6278721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907994, ExchCode = 'FRA' WHERE SecCode = 6308566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22110667359, ExchCode = 'DEU' WHERE SecCode = 6322250 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 6351573 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ZP9' WHERE SecCode = 6361963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793846140, ExchCode = 'MEX' WHERE SecCode = 6371576 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6423141 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6423142 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6441630 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '9648', PermOrgIPODate = '2025-09-16' WHERE SecCode = 6441631 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-14' WHERE SecCode = 6443239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6445465 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6445471 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-22' WHERE SecCode = 6448293 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 6448561 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-10' WHERE SecCode = 6449021 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 6449065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795918128, ExchCode = 'MUN' WHERE SecCode = 6451087 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'NASC' WHERE SecCode = 10990101 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11020243 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11035950 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11037266 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 11052288 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11060595 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'GTRIF' WHERE SecCode = 11063828 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SPP.H', ExchCode = 'NEX' WHERE SecCode = 11069199 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 11107128 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 11183359 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11199637 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11208299 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11208879 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11209772 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 11218488 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240711 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240712 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240851 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240854 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11242806 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11242850 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11243196 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11243210 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11244440 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11244594 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'LUXHQ' WHERE SecCode = 11244678 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11244901 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 11244902 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11245025 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11245067 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11245168 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11246541 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11246542 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 11247807 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11248246 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11249437 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11251288 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FDXTF' WHERE SecCode = 11251873 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11252397 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11252443 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11256004 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11257898 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11257900 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'LUXPQ' WHERE SecCode = 11258091 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11259684 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11260050 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11260258 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11260451 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11261515 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11261847 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11268521 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'HPUMF' WHERE SecCode = 11269670 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 11270043 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276240 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276241 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276249 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276290 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276292 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 11278193 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11278441 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279508 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279509 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279510 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279511 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279512 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279513 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11284582 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'WSBCL' WHERE SecCode = 11285207 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365573.0 WHERE SecCode = 11285222 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285256 AND Type_ = 1;
