UPDATE data_universe_permid SET QuotePermID = 55836047499, Ticker = 'AAT', ExchCode = 'LSE', PermQuoteRetireDate = '2012-11-12' WHERE SecCode = 13 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718461404, Ticker = 'IBMl', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 479 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WEC', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 2105 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3833 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'JIGI' WHERE SecCode = 5037 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 7493 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 8465 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 8623 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 9228 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 9451 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 12961 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 17450 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 17729 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'BZDLF' WHERE SecCode = 18263 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 23221 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 24848 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 27115 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 29555 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30212 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30254 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 31546 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 ExchCode = 'NAS' WHERE SecCode = 32827 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 33116 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 33776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774942223, Ticker = 'AUY', ExchCode = 'LSE', PermQuoteRetireDate = '2023-04-03' WHERE SecCode = 33865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18' WHERE SecCode = 34018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034147, ExchCode = 'TDG' WHERE SecCode = 34311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475645962, ExchCode = 'CXE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 34346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836386343, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-31' WHERE SecCode = 34403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951972.0 WHERE SecCode = 34871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632622059, ExchCode = 'BER' WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782687024, ExchCode = 'QTX' WHERE SecCode = 35214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856147704, ExchCode = 'BER', PermQuoteRetireDate = '2017-02-24' WHERE SecCode = 35278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384206, ExchCode = 'LAS' WHERE SecCode = 36613 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 37229 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-30' WHERE SecCode = 37852 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836333718, ExchCode = 'BER' WHERE SecCode = 38095 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 38106 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 38316 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 38477 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 41632 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780105232, ExchCode = 'GTX', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 43244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335007, ExchCode = 'BER' WHERE SecCode = 43269 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 43286 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 44014 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 44087 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 44262 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21931186423, ExchCode = 'GTX' WHERE SecCode = 44296 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 44329 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 45454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842440800, Ticker = NULL, PermQuoteRetireDate = '2012-05-04' WHERE SecCode = 45820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836399652, ExchCode = 'FRA' WHERE SecCode = 45854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475575870, Ticker = 'MACO.I', ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840929972, ExchCode = 'DUS' WHERE SecCode = 46009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 49034 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 49323 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 49487 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'NAVBQ' WHERE SecCode = 49821 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 50558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642496474, ExchCode = 'BTE' WHERE SecCode = 52632 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 52711 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475482926, ExchCode = 'BER' WHERE SecCode = 53813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524268428, ExchCode = 'STU', PermQuoteRetireDate = '2023-06-08' WHERE SecCode = 53833 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 54468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475732767, PermQuoteStatus = 'DC', Ticker = 'RTLG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 54776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878341062, ExchCode = 'GTX' WHERE SecCode = 54793 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 54829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034431, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 54890 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 55088 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 55091 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21538164352, ExchCode = 'DEU' WHERE SecCode = 55286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489108, ExchCode = 'QTX' WHERE SecCode = 55696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808948021, ExchCode = 'TDG' WHERE SecCode = 55763 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836496151, ExchCode = 'FRA', PermQuoteRetireDate = '2011-07-01' WHERE SecCode = 55770 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 56011 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'DUNYH.E' WHERE SecCode = 56148 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 56468 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21667490087, ExchCode = 'QTX' WHERE SecCode = 56495 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475435128, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474874382, ExchCode = 'DEU' WHERE SecCode = 56529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475815371, ExchCode = 'STU' WHERE SecCode = 57072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850729381, ExchCode = 'FRA', PermQuoteRetireDate = '2013-06-11' WHERE SecCode = 57073 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 57921 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 57922 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952000.0 WHERE SecCode = 58361 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 58804 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475416805, Ticker = NULL, ExchCode = 'MUN', PermQuoteRetireDate = '2004-10-11' WHERE SecCode = 58925 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 58953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330754, ExchCode = 'BER' WHERE SecCode = 59806 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 59874 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'CR6', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 59904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842460107, ValQuotePermID = 21842460107.0, IsPrimaryQuote = 1, Ticker = 'NT5', ExchCode = 'HAN', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 59951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835793972, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-29' WHERE SecCode = 60007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787295, ExchCode = 'DUS' WHERE SecCode = 60111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684720068, ExchCode = 'STU', PermQuoteRetireDate = '2020-06-04' WHERE SecCode = 60258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836427368, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782415051, ExchCode = 'DUS' WHERE SecCode = 60608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21577586769, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04', PermSecMapEndDate = NULL WHERE SecCode = 60667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526399804, ExchCode = 'FRA' WHERE SecCode = 60669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779442508, ExchCode = 'GTX' WHERE SecCode = 60697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387143, ExchCode = 'LAS' WHERE SecCode = 60745 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774613254, ExchCode = 'BER' WHERE SecCode = 60844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536721411, ExchCode = 'STU' WHERE SecCode = 61079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518995420, ExchCode = 'DEU', PermQuoteRetireDate = '2025-07-23' WHERE SecCode = 61141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805754481, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759098635, ExchCode = 'STU', PermQuoteRetireDate = '2022-05-27', PermSecMapEndDate = NULL WHERE SecCode = 61355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836348427, ExchCode = 'FRA' WHERE SecCode = 61517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836410302, ExchCode = 'FRA' WHERE SecCode = 61599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521413775, ExchCode = 'DEU' WHERE SecCode = 61608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475380829, ExchCode = 'MUN', PermQuoteRetireDate = '2005-10-04' WHERE SecCode = 61623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474854572, ExchCode = 'DEU' WHERE SecCode = 62031 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 62285 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 62379 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035806, ExchCode = 'TDG' WHERE SecCode = 62536 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21499629939, ExchCode = 'TDG' WHERE SecCode = 63112 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 63154 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 63202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608276946, ExchCode = 'TDG' WHERE SecCode = 63251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475745514, ExchCode = 'GER' WHERE SecCode = 63460 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 63645 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'VCT0' WHERE SecCode = 63954 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 63995 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 64210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533326402, ExchCode = 'STU', PermQuoteRetireDate = '2021-09-23' WHERE SecCode = 64304 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 64384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388774, ExchCode = 'LAS' WHERE SecCode = 64431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328758, ExchCode = 'BER' WHERE SecCode = 64435 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ERC' WHERE SecCode = 64798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539181678, ExchCode = 'GER' WHERE SecCode = 64888 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 65357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21688418757, ExchCode = 'QTX' WHERE SecCode = 65783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324104, ExchCode = 'BER' WHERE SecCode = 65807 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 66304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860086540, ExchCode = 'GTX' WHERE SecCode = 66922 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 68125 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 68614 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 69984 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 70306 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 70899 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 70919 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21474875995, ValQuotePermID = 21842460107.0, IsPrimaryQuote = 0, ExchCode = 'IXJ', PermQuoteRetireDate = '2012-09-18' WHERE SecCode = 71468 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 71610 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 72234 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 73124 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 73630 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 74516 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 75258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796525250, InstrPermID = 232884903109, OrgPermID = 5095916694, PriTrdQuotePermID = 236796525250.0, ValQuotePermID = 25727059113.0, PriInstrPermID = 232884903109.0, Ticker = 'BTTC', DomCntry = 'CYM', IncCntry = 'CYM', PriTRBCIndPermID = 4294951349.0, PermOrgIPODate = '2025-10-02', PermSecMapStartDate = '2025-10-02' WHERE SecCode = 75851 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 78585 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 78748 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 79390 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 80168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795167535, InstrPermID = 232898609900, ValQuotePermID = 236795167535.0, PermSecMapStartDate = '2025-09-02', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 80309 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 80738 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21483761938, ExchCode = 'CHA' WHERE SecCode = 80783 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 81567 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 81567 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 82248 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 82489 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 82549 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 82838 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 83481 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 83665 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 83694 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 83801 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 84272 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 84951 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 85118 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 85710 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 85727 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-16' WHERE SecCode = 85934 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-03' WHERE SecCode = 86086 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86305 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 86545 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86753 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 86838 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87347 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 88710 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 89109 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 89706 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 90154 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951391.0 WHERE SecCode = 90610 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 91128 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-03' WHERE SecCode = 92379 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'TFM.H', ExchCode = 'NEX' WHERE SecCode = 92906 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'G1C', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 93734 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 93743 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 94005 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 94997 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 95092 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 95444 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'MIT.H', ExchCode = 'NEX' WHERE SecCode = 96779 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 97098 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 97202 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 97206 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 98362 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 98421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795167513, InstrPermID = 232898610030, ValQuotePermID = 236795167513.0, IsPrimaryInstr = 1, PermSecMapStartDate = '2025-09-02', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 99138 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 99943 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100097 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 100099 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951263.0 WHERE SecCode = 101000 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 101013 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'BLUME.E' WHERE SecCode = 103786 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ALPAS' WHERE SecCode = 103908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830277250, ExchCode = 'GTX' WHERE SecCode = 104127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518997232, ExchCode = 'STU' WHERE SecCode = 104129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21846702855, ExchCode = 'DEU' WHERE SecCode = 104136 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791479911, ExchCode = 'FRA' WHERE SecCode = 104270 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 105003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793848482, ValQuotePermID = 55851566138.0, IsPrimaryQuote = 0, PermQuoteStatus = 'AC', Ticker = 'AUGO', ExchCode = 'XMS', DomCntry = 'USA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-07-16', PermSecMapEndDate = NULL WHERE SecCode = 110311 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 111297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796466906, ExchCode = 'TDG', PermSecMapStartDate = '2025-09-17' WHERE SecCode = 112657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21487385191, ExchCode = 'FRA' WHERE SecCode = 112744 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853085558, ExchCode = 'FRA' WHERE SecCode = 112814 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960080107, ExchCode = 'MUN' WHERE SecCode = 112910 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 113331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273562, ExchCode = 'GTX' WHERE SecCode = 114028 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 114433 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 114602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21485225160, ExchCode = 'STU', PermQuoteRetireDate = '2024-06-27', PermSecMapEndDate = '2024-06-27' WHERE SecCode = 114758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626522639, ExchCode = 'STU' WHERE SecCode = 114759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809545193, ExchCode = 'TDG' WHERE SecCode = 114789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337680, ExchCode = 'BER' WHERE SecCode = 114831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288989, ExchCode = 'GTX' WHERE SecCode = 114833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838236737, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 114837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331367, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 114840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334482, ExchCode = 'BER' WHERE SecCode = 114845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332480, ExchCode = 'BER' WHERE SecCode = 114850 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 116034 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530619758, ExchCode = 'FRA' WHERE SecCode = 116139 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 116481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474927574, ExchCode = 'DEU' WHERE SecCode = 116528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732298313, ExchCode = 'DUS' WHERE SecCode = 119129 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 120700 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 124316 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21644782383, ExchCode = 'FRA' WHERE SecCode = 124828 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 128479 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 130409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525792698, ExchCode = 'DEU' WHERE SecCode = 131777 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 132645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22120685664, ExchCode = 'DEU' WHERE SecCode = 133401 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 135529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186346, ExchCode = 'DEU' WHERE SecCode = 136909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776858458, ExchCode = 'STU' WHERE SecCode = 136916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348335, ExchCode = 'QTX' WHERE SecCode = 136931 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 PermOrgIPODate = NULL WHERE SecCode = 137691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560378012, ExchCode = 'CHI' WHERE SecCode = 137860 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 138026 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22008268303, ExchCode = 'DEU' WHERE SecCode = 138279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807446056, ExchCode = 'DEU' WHERE SecCode = 138280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492707893, ExchCode = 'STU' WHERE SecCode = 138285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475524556, Ticker = 'H1B', ExchCode = 'STU', PermQuoteRetireDate = '2009-09-14' WHERE SecCode = 138286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633328002, ExchCode = 'STU' WHERE SecCode = 138476 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830275318, ExchCode = 'GTX' WHERE SecCode = 138787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760588700, ExchCode = 'STU' WHERE SecCode = 138788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836325808, ExchCode = 'BER' WHERE SecCode = 138789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620652758, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-11' WHERE SecCode = 139011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543203134, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-14' WHERE SecCode = 139013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681564795, ExchCode = 'MUN' WHERE SecCode = 139159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840759900, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 139165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335448, ExchCode = 'BER', PermQuoteRetireDate = '2014-12-23' WHERE SecCode = 139167 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 139992 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 140027 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 140273 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 140330 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 141293 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 141345 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 141885 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 141906 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 142063 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796519088, ValQuotePermID = 236796519088.0, Ticker = 'SYSTMTXC', ExchCode = 'NSI' WHERE SecCode = 142574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838235310, ExchCode = 'MUN' WHERE SecCode = 143197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474896727, ExchCode = 'DEU' WHERE SecCode = 143198 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-03' WHERE SecCode = 143390 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 143433 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 144125 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 144506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071663, ExchCode = 'MUN', PermQuoteRetireDate = '2014-12-15' WHERE SecCode = 144542 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 144755 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951840.0 WHERE SecCode = 145863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334976, ExchCode = 'DEU' WHERE SecCode = 145923 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapStartDate = '2012-12-18' WHERE SecCode = 146206 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785774721, ExchCode = 'DEU' 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 = 22118201160, ExchCode = 'DEU' WHERE SecCode = 146440 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'NNW' WHERE SecCode = 146530 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 147126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618954048, ExchCode = 'DEU', PermQuoteRetireDate = '2025-05-07' WHERE SecCode = 147295 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '2CC' WHERE SecCode = 147551 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522633023, ExchCode = 'MUN' WHERE SecCode = 160971 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 162474 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 163971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514316877, ExchCode = 'STU' WHERE SecCode = 164791 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 168907 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 169894 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 176523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856949141, ExchCode = 'FRA' WHERE SecCode = 177328 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 177403 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 177594 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 177671 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 178267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327136, ExchCode = 'BER' WHERE SecCode = 178451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650181, ExchCode = 'DUS' WHERE SecCode = 179171 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 180517 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 183337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22131851414, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 185777 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 189259 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 189772 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 194733 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 195067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21978643278, ExchCode = 'DEU' WHERE SecCode = 197083 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 197200 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 197415 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 206747 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796328454, ExchCode = 'LAS' WHERE SecCode = 206847 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 207649 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 210189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780730768, ExchCode = 'MEX' WHERE SecCode = 214388 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 221381 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 230089 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 240072 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 243287 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 248734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786998771, Ticker = 'TYP', ExchCode = 'BER' WHERE SecCode = 248961 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 249232 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 PermOrgIPODate = NULL WHERE SecCode = 249282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565082887, ExchCode = 'FRA' WHERE SecCode = 249293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856726590, ExchCode = 'STU' WHERE SecCode = 249354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474978939, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 249365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331035, ExchCode = 'BER' WHERE SecCode = 249367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528269166, ExchCode = 'DEU' WHERE SecCode = 249402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526396050, ExchCode = 'FRA' WHERE SecCode = 249427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957755807, ExchCode = 'STU' WHERE SecCode = 249438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805754447, ExchCode = 'MUN' WHERE SecCode = 249571 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 249828 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 252551 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 254067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960077493, ExchCode = 'GTX' WHERE SecCode = 259026 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-30' WHERE SecCode = 278022 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55851566138, ValQuotePermID = 55851566138.0, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', ExchCode = 'FRA', DomCntry = 'USA', PermQuoteRetireDate = NULL WHERE SecCode = 286286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838939, ExchCode = 'FRA' WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929157678, ExchCode = 'GTX' 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 = 'L1G' WHERE SecCode = 292778 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-02' WHERE SecCode = 293438 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 293915 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 294907 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 297498 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 298972 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 300646 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 300997 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 301073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550076999, ExchCode = 'HAM', PermQuoteRetireDate = '2018-09-24' WHERE SecCode = 302054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511206621, ExchCode = 'STU' WHERE SecCode = 302075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22131850953, ExchCode = 'DEU' WHERE SecCode = 303854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320454, ExchCode = 'BER' WHERE SecCode = 304579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320511, Ticker = '31ID', ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 304581 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 304979 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 304982 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 306178 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 306179 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 306952 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 312613 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 313778 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 316471 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 317424 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 317551 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 317618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531772020, ExchCode = 'STU' WHERE SecCode = 319526 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-03' WHERE SecCode = 321708 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 321821 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 322921 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836320787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02', PermSecMapStartDate = '2025-10-03' WHERE SecCode = 323301 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21842460107.0, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 323753 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 324696 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 325810 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 326385 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 326814 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 326891 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 326895 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 22131851187, InstrPermID = 21498107911, ValQuotePermID = 236795665850.0, IsPrimaryInstr = 1, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '8BZ', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 328509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479301, ExchCode = 'QTX' WHERE SecCode = 330665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950784269, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 330668 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 330857 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 331506 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 331740 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 334869 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 335725 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 336022 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 336160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595817, PermQuoteStatus = 'AC', Ticker = 'MLHLF', ExchCode = 'GTC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-03', PermSecMapEndDate = NULL WHERE SecCode = 337161 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 337239 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 337400 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 337875 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 341242 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 343539 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 344006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793845607, ExchCode = 'FRA' WHERE SecCode = 345843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334559, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 345858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130920528, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 348479 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474950915, ExchCode = 'DEU', PermQuoteRetireDate = '2017-12-15' WHERE SecCode = 351504 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388463, Ticker = 'WIHL.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353994 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 354680 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 367386 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 387473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796440421, ValQuotePermID = 236796440421.0, Ticker = 'FINKURVE', ExchCode = 'NSI' WHERE SecCode = 387505 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840906149, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-04' WHERE SecCode = 389776 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 397755 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 415027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842788413, ExchCode = 'FRA' WHERE SecCode = 415270 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 415865 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 415923 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 418561 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 439770 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 443161 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951391.0 WHERE SecCode = 443494 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 453857 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 453898 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 453971 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 454908 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 PriTRBCIndPermID = 4294951623.0 WHERE SecCode = 511704 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 520275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596919142, ExchCode = 'BTE' WHERE SecCode = 521415 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 522198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 534871 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 534958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720001342, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-06-24' WHERE SecCode = 538090 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 541391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 551335 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552210 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830289106, ExchCode = 'GTX' WHERE SecCode = 552621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475846461, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 556601 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 559560 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 560499 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951972.0 WHERE SecCode = 564797 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 586040 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 601148 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 698114 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 703142 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 PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 770039 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 773284 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 775003 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951741.0 WHERE SecCode = 790648 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 793380 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 810840 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 826255 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 841106 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 843180 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 873492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 908357 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 948082 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 989755 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 995585 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1019997 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 1026391 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1109305 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1130726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781996312, ExchCode = 'MUN' WHERE SecCode = 1303639 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 1372743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541294021, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 1389099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734632074, ExchCode = 'DEU' WHERE SecCode = 1441088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476159348, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1449053 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476429358, ExchCode = 'DEU' WHERE SecCode = 1451955 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459433 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 1472778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535814878, ValQuotePermID = 21788257886.0, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', Ticker = 'INSE.GB', ExchCode = 'AQS', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 1472965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21491998110, ExchCode = 'TDG', PermQuoteRetireDate = '2016-05-16' WHERE SecCode = 1528650 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 1534257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1544768 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1565181 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 = 22131159160, ExchCode = 'HAM', PermSecMapStartDate = '2024-09-23' WHERE SecCode = 1596488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953911750, ExchCode = 'GTX' WHERE SecCode = 1596489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916713839, ExchCode = 'MUN' WHERE SecCode = 1596490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21505186418, ExchCode = 'BUR' WHERE SecCode = 1596521 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 1678431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 1692689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21828343336, ExchCode = 'QTX' WHERE SecCode = 1694101 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 1699052 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 1699053 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 1699054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537425753, ExchCode = 'TDG' WHERE SecCode = 1778982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 1926065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585026984, ExchCode = 'BTE' WHERE SecCode = 1931297 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1973244 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1973550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521985521, ExchCode = 'STU', PermQuoteRetireDate = '2015-05-27' WHERE SecCode = 2018342 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546935312, ExchCode = 'STU' WHERE SecCode = 2055322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785264817, ExchCode = 'FRA' WHERE SecCode = 2087993 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2227874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781570154, ExchCode = 'DUS' WHERE SecCode = 2239280 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 2249250 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 2286304 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = '2025-10-10', PermOrgIPODate = NULL, PermSecMapStartDate = '2025-10-01', PermSecMapEndDate = NULL WHERE SecCode = 2298762 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC', PermOrgIPODate = NULL WHERE SecCode = 2315212 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2326807 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736168151, ExchCode = 'BCO' WHERE SecCode = 2346282 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2362562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780887293, Ticker = '1CNHIm', ExchCode = 'DXE' WHERE SecCode = 2365610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538829907, ExchCode = 'STU' WHERE SecCode = 2365611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130921495, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527246, ExchCode = 'FRA' WHERE SecCode = 2414149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21534157905, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 2453131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21534236849, ExchCode = 'FRA' WHERE SecCode = 2453132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644531039, Ticker = 'HM6Ad', ExchCode = 'BCO' WHERE SecCode = 2453144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554847086, ExchCode = 'DEU' WHERE SecCode = 2453146 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2495686 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2513095 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538073287, ExchCode = 'BER' WHERE SecCode = 2514690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538087609, ExchCode = 'FRA' WHERE SecCode = 2514694 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-29', PermSecMapEndDate = NULL WHERE SecCode = 2515727 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2515743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475000070, Ticker = 'PREVIS-OSA', ExchCode = 'SGO' WHERE SecCode = 2524756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521367747, ExchCode = 'BEC' WHERE SecCode = 2524779 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 2526047 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2529654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780909440, ExchCode = 'DEU' WHERE SecCode = 2536886 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2542444 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2544441 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2545795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2560601 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-17' WHERE SecCode = 2566806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793501847, ExchCode = 'MUN' WHERE SecCode = 2578881 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2582177 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2583470 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 2586429 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 2586521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067757998, ExchCode = 'BCO' WHERE SecCode = 2600076 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 PermInstrStatus = 'DC' WHERE SecCode = 2617119 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 2626282 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2630115 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2635746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779391120, ExchCode = 'GTX' WHERE SecCode = 2642446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548045877, ExchCode = 'DEU' WHERE SecCode = 2642451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534619, ExchCode = 'QTX' WHERE SecCode = 2642453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777359766, ExchCode = 'STU' WHERE SecCode = 2642455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478457, ExchCode = 'QTX' WHERE SecCode = 2642458 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2642467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561270622, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-12' WHERE SecCode = 2643269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548381098, ExchCode = 'FRA' WHERE SecCode = 2647456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2650531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761648844, ExchCode = 'STU' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2657417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549921078, ExchCode = 'BTE' WHERE SecCode = 2665921 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2679880 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2685337 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 2693648 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 2696584 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 2696739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551797405, Ticker = 'CBKDe', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2706343 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2707784 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 2711209 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552459618, ExchCode = 'STU' WHERE SecCode = 2718428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552380654, ExchCode = 'BER' WHERE SecCode = 2718429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784881963, ExchCode = 'QTX' WHERE SecCode = 2747510 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2747739 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2751766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555272551, ExchCode = 'DEU' WHERE SecCode = 2764597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21612598947, ExchCode = 'STU' WHERE SecCode = 2796968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21559577541, ExchCode = 'DEU' WHERE SecCode = 2821436 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558562157, ExchCode = 'FRA' WHERE SecCode = 2827908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21559812802, ExchCode = 'TDG' WHERE SecCode = 2841897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 2864442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'LKY', PermOrgIPODate = NULL WHERE SecCode = 2868637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562215255, ExchCode = 'DEU' WHERE SecCode = 2876219 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2880970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2885891 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615434084, ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779358960, ExchCode = 'GTX' WHERE SecCode = 2909922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565698268, ExchCode = 'DEU' WHERE SecCode = 2918012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2925389 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2926162 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604748300, ExchCode = 'STU', PermQuoteRetireDate = '2020-05-05' WHERE SecCode = 2936005 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2939975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568990720, ExchCode = 'TDG' WHERE SecCode = 2947855 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2956426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646062311, ExchCode = 'MUN' WHERE SecCode = 2963590 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 2975899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21573513525, Ticker = 'DML2', ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'AXX' WHERE SecCode = 3011222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21574510951, ExchCode = 'FRA' WHERE SecCode = 3024440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678613, ExchCode = 'BIV' WHERE SecCode = 3024446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576069516, ExchCode = 'DEU' WHERE SecCode = 3031579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479850, ExchCode = 'QTX' WHERE SecCode = 3045201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509907562, ExchCode = 'BEC' WHERE SecCode = 3054221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991661, ExchCode = 'FRA' WHERE SecCode = 3074354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22103473256, ExchCode = 'DEU' WHERE SecCode = 3074402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21586927375, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2020-07-09' WHERE SecCode = 3076717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916283660, ExchCode = 'BER' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581022607, ExchCode = 'DEU' WHERE SecCode = 3083484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583964281, ExchCode = 'DEU' WHERE SecCode = 3112921 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3119755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953914339, ExchCode = 'GTX' WHERE SecCode = 3120768 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3121084 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = NULL WHERE SecCode = 3128125 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3149671 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3155211 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3160187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587662536, ExchCode = 'STU' WHERE SecCode = 3165880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587055393, ExchCode = 'STU' WHERE SecCode = 3166812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599769591, ExchCode = 'TDG' WHERE SecCode = 3169823 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3172368 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3181302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21588626418, ExchCode = 'DEU' WHERE SecCode = 3181677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825337729, Ticker = '3EML.GB', ExchCode = 'AQS' WHERE SecCode = 3193773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591145177, ExchCode = 'STU', PermQuoteRetireDate = '2021-07-06' WHERE SecCode = 3196331 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3196346 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3198784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768454047, ExchCode = 'BER' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3200563 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3211361 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3213375 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 PermInstrStatus = 'DC' WHERE SecCode = 3219004 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3225985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614269130, ExchCode = 'MUN' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3244966 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3247673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21601432109, Ticker = 'DRG', ExchCode = 'STU', PermQuoteRetireDate = '2019-12-13' WHERE SecCode = 3247729 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3247805 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3248050 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3257140 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598110773, ExchCode = 'STU' WHERE SecCode = 3257553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598800618, ExchCode = 'FRA' WHERE SecCode = 3260792 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'S1K0' WHERE SecCode = 3261049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640216643, ExchCode = 'TDG' WHERE SecCode = 3263894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681587284, ExchCode = 'FRA' WHERE SecCode = 3266309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599774622, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 3271586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705332, Ticker = 'MBWSN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3273583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704158, ExchCode = 'MXQ' WHERE SecCode = 3273584 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 3276419 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3276432 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 3283637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396552, ExchCode = 'DEU' WHERE SecCode = 3283696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626019590, Ticker = 'BORRo', ExchCode = 'BTE', PermQuoteRetireDate = '2024-12-31' WHERE SecCode = 3283870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602981084, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 3283966 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3296408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820735920, ExchCode = 'TDG' WHERE SecCode = 3303268 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3304160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487242, ExchCode = 'FRA' WHERE SecCode = 3304225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782726136, ExchCode = 'AQX' WHERE SecCode = 3304228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658651750, ExchCode = 'TDG' WHERE SecCode = 3315888 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 3315890 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3317120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782181263, ExchCode = 'DUS' WHERE SecCode = 3317906 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 3318353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610381430, ExchCode = 'DEU', PermQuoteRetireDate = '2022-12-02', PermSecMapEndDate = '2022-12-02' WHERE SecCode = 3318355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21607304635, ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-26', PermSecMapEndDate = '2023-07-26' WHERE SecCode = 3319844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294455, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3322819 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3346900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890669874, ExchCode = 'MUN' WHERE SecCode = 3346903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646845928, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3347668 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3350464 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3350590 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 = 21614671400, ExchCode = 'DEU' WHERE SecCode = 3357942 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3366961 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3371542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647227301, ExchCode = 'FRA' WHERE SecCode = 3378582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617962088, ExchCode = 'DEU', PermQuoteRetireDate = '2020-10-14' WHERE SecCode = 3378583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678399, ExchCode = 'BIV' WHERE SecCode = 3378697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761306157, ExchCode = 'FRA' WHERE SecCode = 3386777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622425444, PermQuoteStatus = 'AC', Ticker = 'C5B0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3391113 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 3392097 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 3395685 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3396930 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3397190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641222426, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31', PermSecMapEndDate = NULL WHERE SecCode = 3402310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625622936, ExchCode = 'FRA' WHERE SecCode = 3402562 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3402702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22131277274, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3404342 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3404915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628935588, ExchCode = 'STU' WHERE SecCode = 3405606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628602986, Ticker = 'DTS', ExchCode = 'MUN', PermQuoteRetireDate = '2020-10-02' WHERE SecCode = 3406952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21867740085, ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-12' WHERE SecCode = 3408942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388179, PermQuoteStatus = 'AC', Ticker = 'SOG0', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3409010 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1' WHERE SecCode = 3409377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632884570, ExchCode = 'MUN' WHERE SecCode = 3418906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644441070, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2025-05-02' WHERE SecCode = 3428077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482802788, Ticker = 'PU9D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 3429985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22043721526, ExchCode = 'DEU' WHERE SecCode = 3430350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649740422, Ticker = 'LEMSEs', ExchCode = 'BCO' WHERE SecCode = 3430374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674899, ExchCode = 'BIV' WHERE SecCode = 3430658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796870307, PermQuoteStatus = 'DC', Ticker = '1GQ', ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-22' WHERE SecCode = 3430801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809128702, Ticker = '1JF', ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-22' WHERE SecCode = 3430802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847010295, ExchCode = 'BER' WHERE SecCode = 3431060 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3432019 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432027 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-03' WHERE SecCode = 3432039 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432396 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432426 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432509 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432529 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL WHERE SecCode = 3432634 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432845 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3432854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633620996, Ticker = '0R2J', ExchCode = 'LSE' WHERE SecCode = 3432940 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 3433208 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 3433235 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 3433318 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3433365 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 3433407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640834967, ExchCode = 'FRA' WHERE SecCode = 3434745 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679819, ExchCode = 'BIV' WHERE SecCode = 3434746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772839685, ExchCode = 'DEU' WHERE SecCode = 3436708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758527230, ExchCode = 'MUN' WHERE SecCode = 3436709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858705514, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21792709388, ExchCode = 'MUN' WHERE SecCode = 3445201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644992133, Ticker = 'CASl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3446120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781344052, ExchCode = 'QTX' WHERE SecCode = 3446483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21648039735, ExchCode = 'STU' WHERE SecCode = 3446753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21925498341, ExchCode = 'STU' WHERE SecCode = 3490818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647042623, ExchCode = 'FRA' WHERE SecCode = 3490819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647042502, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647200544, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647152171, ExchCode = 'FRA' WHERE SecCode = 3490823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647142964, ExchCode = 'DEU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647200545, ExchCode = 'FRA' WHERE SecCode = 3490825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784910654, Ticker = 'NOKIAk', ExchCode = 'BCO' WHERE SecCode = 3504673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775635085, ExchCode = 'DEU' WHERE SecCode = 3509155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3518313 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3525434 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3526140 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803757309, ExchCode = 'DUS' WHERE SecCode = 3531554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652953801, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3532701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653586182, ExchCode = 'BER' WHERE SecCode = 3534921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653590215, ExchCode = 'FRA' WHERE SecCode = 3535859 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3536039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766656811, ExchCode = 'BER' WHERE SecCode = 3539022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21654538571, ExchCode = 'FRA' WHERE SecCode = 3540682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21692715167, ExchCode = 'CHI' WHERE SecCode = 3551896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288448, ExchCode = 'GTX' WHERE SecCode = 3555035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656056664, ExchCode = 'FRA' WHERE SecCode = 3555038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681761612, ExchCode = 'DEU' WHERE SecCode = 3569619 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3571379 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21657694230, ExchCode = 'BIV' WHERE SecCode = 3573698 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3586984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218033, ExchCode = 'SGO' WHERE SecCode = 3587010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218034, ExchCode = 'SGO' WHERE SecCode = 3587014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21619168949, ExchCode = 'STU' WHERE SecCode = 3587019 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3588041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609512, ExchCode = 'DEU' WHERE SecCode = 3588083 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 3593745 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 3615201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667202587, ExchCode = 'MUN' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3634347 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3634457 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3644638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669468854, PermInstrStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672402059, ExchCode = 'TDG' WHERE SecCode = 3671113 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3691630 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21674884786, ExchCode = 'FRA' WHERE SecCode = 3694159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100413, ExchCode = 'QTX' WHERE SecCode = 3703405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21678589969, ExchCode = 'DEU' WHERE SecCode = 3713252 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 = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812338138, ExchCode = 'MUN' WHERE SecCode = 3738159 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3743387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681398176, ExchCode = 'DEU' WHERE SecCode = 3747813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818383625, ExchCode = 'MUN' WHERE SecCode = 3767864 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3775362 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520379, ExchCode = 'FRA' WHERE SecCode = 3784710 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3791521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21687527440, ExchCode = 'STU' WHERE SecCode = 3791543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806182117, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-30' WHERE SecCode = 3792582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727376097, ExchCode = 'MEX' WHERE SecCode = 3799556 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 3809957 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 3817741 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21694081395, ExchCode = 'BER' WHERE SecCode = 3818871 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3831351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735310231, ExchCode = 'STU' WHERE SecCode = 3832752 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3833796 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3835747 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3837276 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3837282 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3839004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373317, ExchCode = 'MEX' WHERE SecCode = 3843165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696961531, ExchCode = 'FRA' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854173220, ExchCode = 'DUS' WHERE SecCode = 3849234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3858016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696520891, PermQuoteStatus = 'AC', Ticker = '37V', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3858132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21697447373, ExchCode = 'TDG' WHERE SecCode = 3862230 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 3863409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727369832, ExchCode = 'MEX' WHERE SecCode = 3868466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702680664, ExchCode = 'FRA' WHERE SecCode = 3879165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702351600, ExchCode = 'FRA', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929161369, ExchCode = 'MUN', PermQuoteRetireDate = '2025-02-17', PermSecMapEndDate = NULL WHERE SecCode = 3888265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21849048102, ExchCode = 'STU' WHERE SecCode = 3894966 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 3896278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21726141289, ExchCode = 'DEU' WHERE SecCode = 3899638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21704921848, ExchCode = 'DEU' WHERE SecCode = 3906532 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21705388431, ExchCode = 'DEU' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727367064, ExchCode = 'BIV' WHERE SecCode = 3909638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21828052581, ExchCode = 'DEU' WHERE SecCode = 3919627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21706871202, ExchCode = 'BER' WHERE SecCode = 3921293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21706614756, ExchCode = 'FRA' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 3948975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711478411, ExchCode = 'DEU' WHERE SecCode = 3956835 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21712108670, ExchCode = 'STU' WHERE SecCode = 3959788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21849037685, ExchCode = 'MUN' WHERE SecCode = 3959923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713324971, Ticker = '1OD', ExchCode = 'MUN', PermQuoteRetireDate = '2024-07-02' WHERE SecCode = 3965202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732298322, ExchCode = 'DUS' WHERE SecCode = 3977808 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CE70' WHERE SecCode = 3977923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924367776, ExchCode = 'MUN' WHERE SecCode = 3987746 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3997063 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718910978, ExchCode = 'FRA' WHERE SecCode = 4001066 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718911035, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-07' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719060177, ExchCode = 'STU' WHERE SecCode = 4001204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720521406, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4010838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757864209, ExchCode = 'DEU' WHERE SecCode = 4018119 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4027450 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 = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026863, Ticker = '1ADE', ExchCode = 'MIL' WHERE SecCode = 4031783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4032045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727358924, ExchCode = 'BIV' WHERE SecCode = 4033123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723974167, ExchCode = 'FRA', PermQuoteRetireDate = '2025-03-26' WHERE SecCode = 4034218 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4036679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724715991, ExchCode = 'TDG' WHERE SecCode = 4038748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725610718, ExchCode = 'DEU' WHERE SecCode = 4043316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931185995, ExchCode = 'GTX' WHERE SecCode = 4080599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732569357, ExchCode = 'DEU' WHERE SecCode = 4081943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738253265, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 4090028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780356688, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2024-09-21' WHERE SecCode = 4101126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21867346156, ExchCode = 'STU' WHERE SecCode = 4103690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735310153, Ticker = '7M40', ExchCode = 'STU', PermQuoteRetireDate = '2024-02-02' WHERE SecCode = 4103711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745090551, ExchCode = 'FRA' WHERE SecCode = 4110883 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4113833 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4129817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298503, ExchCode = 'FRA' WHERE SecCode = 4134450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471110, ExchCode = 'GTX', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4134496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736829334, ExchCode = 'FRA' WHERE SecCode = 4169151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 4171586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744442992, ExchCode = 'TDG' WHERE SecCode = 4193439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778659890, ExchCode = 'BIV' WHERE SecCode = 4194640 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746436847, ExchCode = 'DEU' WHERE SecCode = 4203138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354881, ExchCode = 'BIV' WHERE SecCode = 4211745 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727351014, ExchCode = 'BIV' WHERE SecCode = 4211785 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772235078, PermQuoteStatus = 'DC', Ticker = '4U1', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = '2025-04-01' WHERE SecCode = 4212367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727350451, ExchCode = 'BIV' WHERE SecCode = 4212368 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4219597 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4228116 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4245391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754193828, ExchCode = 'STU' WHERE SecCode = 4251502 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4262434 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4286247 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4286320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863835542, ExchCode = 'MUN' WHERE SecCode = 4291629 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931482979, ExchCode = 'MUN' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4303589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21792091537, ExchCode = 'BER' WHERE SecCode = 4310575 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4312033 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888021179, ExchCode = 'GTX' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4333248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782629845, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-03', PermSecMapEndDate = NULL WHERE SecCode = 4348280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784368317, ExchCode = 'MUN' WHERE SecCode = 4348282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768485393, ExchCode = 'FRA' WHERE SecCode = 4351435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770634972, ExchCode = 'BER' WHERE SecCode = 4359837 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 PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4376007 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4380454 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4394717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790861937, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-01', PermSecMapEndDate = NULL WHERE SecCode = 4395464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778893562, ExchCode = 'FRA', PermQuoteRetireDate = '2020-11-17' WHERE SecCode = 4400157 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4402242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782177959, ExchCode = 'FRA' WHERE SecCode = 4404026 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4406340 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4410617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991683, ExchCode = 'DEU' WHERE SecCode = 4410618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896376059, ExchCode = 'FRA' WHERE SecCode = 4410619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21828844027, ExchCode = 'MUN' WHERE SecCode = 4410622 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4419247 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4419248 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4419249 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4419254 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 = 21815337125, ExchCode = 'FRA' WHERE SecCode = 4423907 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4426956 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 4429545 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4434395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847715481, ExchCode = 'MUN' WHERE SecCode = 4436993 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4438375 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4443955 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4443956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783749210, ExchCode = 'QTX' WHERE SecCode = 4449676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727306258, ExchCode = 'BIV' WHERE SecCode = 4456073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789216253, ExchCode = 'FRA' WHERE SecCode = 4456099 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21788257886.0, IsPrimaryQuote = 1 WHERE SecCode = 4459229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791248842, ExchCode = 'FRA' WHERE SecCode = 4462870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789568603, ExchCode = 'DEU' WHERE SecCode = 4463053 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ORTIN', PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4471741 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396721, ExchCode = 'DEU' WHERE SecCode = 4472911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530053, ExchCode = 'FRA' WHERE SecCode = 4472933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530360, ExchCode = 'DEU' WHERE SecCode = 4472940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793689591, ExchCode = 'FRA' WHERE SecCode = 4474387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794070449, ExchCode = 'FRA' WHERE SecCode = 4477048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794261382, ExchCode = 'FRA' WHERE SecCode = 4479186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802419072, ExchCode = 'TDG' 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 = 21796082418, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2021-10-13' WHERE SecCode = 4487640 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4489237 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 4491916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4494204 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494205 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4494206 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494207 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4494208 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494209 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4494210 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4494231 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494232 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494233 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4494234 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4494235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797809367, ExchCode = 'DUS' WHERE SecCode = 4499132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797820703, ExchCode = 'DEU' WHERE SecCode = 4499152 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4499286 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4500461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797409276, ExchCode = 'DEU' WHERE SecCode = 4505803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800437894, ExchCode = 'MUN' WHERE SecCode = 4511507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4511509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800727409, ExchCode = 'DEU' WHERE SecCode = 4513651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801066759, ExchCode = 'DEU' WHERE SecCode = 4517641 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4517648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799910326, ExchCode = 'DEU' WHERE SecCode = 4517877 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'UDE' WHERE SecCode = 4519547 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4519581 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4523023 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4524579 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ZE00' WHERE SecCode = 4526157 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4531983 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4536362 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804415050, ExchCode = 'MUN' WHERE SecCode = 4539323 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4546585 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 4550727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 4550805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796141787, ExchCode = 'STU' WHERE SecCode = 4557929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811337148, ExchCode = 'STU' WHERE SecCode = 4565422 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 = 236777223513, ExchCode = 'FRA' 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 PermQuoteStatus = 'AC', Ticker = 'LU51', PermQuoteRetireDate = NULL WHERE SecCode = 4579630 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4586555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812338173, ExchCode = 'MUN', PermQuoteRetireDate = '2023-08-09' WHERE SecCode = 4588258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781829998, ExchCode = 'QTX' WHERE SecCode = 4591965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812848146, ExchCode = 'DEU' WHERE SecCode = 4592022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813395163, ExchCode = 'FRA' WHERE SecCode = 4593306 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4593314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957273972, ExchCode = 'BER' WHERE SecCode = 4595746 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4601646 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4601729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4603543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817233505, ExchCode = 'FRA' WHERE SecCode = 4607695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815952112, ExchCode = 'FRA' WHERE SecCode = 4607713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387236, ExchCode = 'LAS' WHERE SecCode = 4609996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816477347, ExchCode = 'MUN' WHERE SecCode = 4609998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816288537, ExchCode = 'FRA' WHERE SecCode = 4609999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581928, ExchCode = 'QTX' WHERE SecCode = 4611004 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 4611019 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4616837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878863900, ExchCode = 'BCO' WHERE SecCode = 4617708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816901027, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-10' WHERE SecCode = 4620951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819774367, ExchCode = 'DEU' WHERE SecCode = 4623226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821041967, ExchCode = 'DEU' WHERE SecCode = 4629496 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4630675 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 4630676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818713411, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-21', PermSecMapEndDate = '2021-06-21' WHERE SecCode = 4631952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820739202, ExchCode = 'DEU' WHERE SecCode = 4631954 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4632082 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4634305 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4635265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822907542, ExchCode = 'DEU' WHERE SecCode = 4639567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100069, ExchCode = 'FRA' WHERE SecCode = 4639636 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 4640253 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21934228224, PermInstrStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824693646, ExchCode = 'BER' WHERE SecCode = 4649878 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4653101 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WDCN3' WHERE SecCode = 4655483 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4655498 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4658860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21833145669, ExchCode = 'FRA' WHERE SecCode = 4677605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793284943, Ticker = '94Y', ExchCode = 'TDG' WHERE SecCode = 4682737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837529040, ExchCode = 'GER' WHERE SecCode = 4693646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4702642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842579647, ExchCode = 'MUN' WHERE SecCode = 4705895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4711621 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4713788 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4716084 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 4724704 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'B40' WHERE SecCode = 4730067 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4738022 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4738157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850720114, ExchCode = 'FRA' WHERE SecCode = 4745386 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4746935 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4751021 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4751055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853258497, ExchCode = 'FRA' WHERE SecCode = 4756621 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4757848 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4766037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854895784, ExchCode = 'FRA' WHERE SecCode = 4767878 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30' WHERE SecCode = 4771748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789996081, ExchCode = 'LAS' WHERE SecCode = 4777352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4792252 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4792277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334827, ExchCode = 'DEU' WHERE SecCode = 4792475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860615485, ExchCode = 'STU' WHERE SecCode = 4800489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861532579, ExchCode = 'GTX' WHERE SecCode = 4802327 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4804556 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4804582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618957147, ExchCode = 'FRA', PermQuoteRetireDate = '2023-05-12' WHERE SecCode = 4804834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823813, Ticker = 'KWE3l', ExchCode = 'AQX' WHERE SecCode = 4808966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904412215, ExchCode = 'GTX' WHERE SecCode = 4810002 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ESTM' WHERE SecCode = 4811102 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4813556 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 4821625 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4824359 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'MBXDA', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 4826112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866536811, ExchCode = 'STU' WHERE SecCode = 4827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796521115, ExchCode = 'MUN' WHERE SecCode = 4827933 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 4829213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861142799, ExchCode = 'FRA' WHERE SecCode = 4829216 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 4834788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487241, ExchCode = 'FRA' WHERE SecCode = 4845067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4854813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872584687, ExchCode = 'FRA' WHERE SecCode = 4873679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872586664, ExchCode = 'DEU' WHERE SecCode = 4873682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882166699, ExchCode = 'GTX' WHERE SecCode = 4890357 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4895650 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'B0Y1' WHERE SecCode = 4903985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727204873, ExchCode = 'BIV' WHERE SecCode = 4911170 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4914393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880159462, ExchCode = 'DUS' WHERE SecCode = 4925631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882166780, PermInstrStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2022-03-28', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 4934327 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4934361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919010696, ExchCode = 'MUN' WHERE SecCode = 4950865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875594, PermQuoteStatus = 'AC', Ticker = 'VC9', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727200981, ExchCode = 'MEX' WHERE SecCode = 4956738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727205509, ExchCode = 'BIV' WHERE SecCode = 4962789 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4970754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4977670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21894951764, ExchCode = 'DUS' WHERE SecCode = 4991558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4992157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21894542420, ExchCode = 'DEU' WHERE SecCode = 5011663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5025355 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5031927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902367523, ExchCode = 'MUN' WHERE SecCode = 5041763 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5045333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380636, ExchCode = 'LAS' WHERE SecCode = 5047099 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5050791 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5054835 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5072231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777910905, ExchCode = 'GTX' WHERE SecCode = 5075859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5104499 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5107767 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5119165 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5123686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913292297, ExchCode = 'FRA' WHERE SecCode = 5129708 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5129748 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5130686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916561934, ExchCode = 'DUS' WHERE SecCode = 5140200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917841797, ExchCode = 'FRA' WHERE SecCode = 5152350 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5161308 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5161416 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921223663, ExchCode = 'STU' WHERE SecCode = 5166540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919946283, ExchCode = 'DEU' WHERE SecCode = 5166568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21922262959, ExchCode = 'DEU' WHERE SecCode = 5176822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 5189087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890060456, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2024-12-26' WHERE SecCode = 5206281 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5220960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5247250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935904590, ExchCode = 'FRA' WHERE SecCode = 5265006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959379813, ExchCode = 'TDG' WHERE SecCode = 5265007 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5269453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397463, ExchCode = 'BTE' WHERE SecCode = 5269462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937063470, ExchCode = 'DUS' WHERE SecCode = 5272089 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5277531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5281305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948484161, ExchCode = 'DUS' WHERE SecCode = 5292727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388892, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08' WHERE SecCode = 5299987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943095863, ExchCode = 'DUS' WHERE SecCode = 5313552 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5316694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948097719, ExchCode = 'DEU' WHERE SecCode = 5329497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777252955, ExchCode = 'HAM' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950823656, ExchCode = 'FRA' WHERE SecCode = 5343552 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776504665, ExchCode = 'MEX' WHERE SecCode = 5354969 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5356151 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5357352 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 5363439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776104211, Ticker = 'ACAG', ExchCode = 'VIE' WHERE SecCode = 5372903 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5380510 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5381930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5391446 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5391531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5403010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777195422, ExchCode = 'FRA' WHERE SecCode = 5403196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777223518, ExchCode = 'FRA' WHERE SecCode = 5403440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942209, ExchCode = 'STU' WHERE SecCode = 5422843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21967957484, ExchCode = 'DEU' WHERE SecCode = 5422844 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5427962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921513369, ExchCode = 'QTX', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5434325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078254, ExchCode = 'LAS' WHERE SecCode = 5443505 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5444000 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5447503 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5447556 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 5463054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778299986, ExchCode = 'FRA' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5474601 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5478193 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5488019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835792, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL 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 = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 5521949 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 5533520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779412067, ExchCode = 'FRA' WHERE SecCode = 5541689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779412070, ExchCode = 'FRA' WHERE SecCode = 5541690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779412068, ExchCode = 'FRA' WHERE SecCode = 5541691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779442600, ExchCode = 'FRA' WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779442603, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-26', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-26' WHERE SecCode = 5541733 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL 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 DomCntry = 'CYM' WHERE SecCode = 5561610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5597155 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5606946 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5610108 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 5611510 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5612375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5618184 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5620203 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5629234 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5631498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781224681, ExchCode = 'BER' WHERE SecCode = 5631688 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5631728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21637484538, ExchCode = 'DEU' WHERE SecCode = 5638703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010677492, ExchCode = 'DEU' WHERE SecCode = 5638751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476048637, PermQuoteStatus = 'AC', Ticker = 'N8I', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807449511, Ticker = 'TS2Sl', ExchCode = 'BCO' WHERE SecCode = 5638844 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096827291, IncCntry = 'USA', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2022-04-07' WHERE SecCode = 5648490 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 5656152 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 5656153 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 5656154 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 5656155 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 5656156 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-10-03' WHERE SecCode = 5656157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781757046, ExchCode = 'FRA' WHERE SecCode = 5674580 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5677544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858187, ExchCode = 'FRA' WHERE SecCode = 5679100 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5679588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22020600429, ExchCode = 'DEU' WHERE SecCode = 5687957 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 = 22077468957, Ticker = 'SOXLl', ExchCode = 'BCO' WHERE SecCode = 5702908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782381254, ExchCode = 'QTX' WHERE SecCode = 5712413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783009907, ExchCode = 'STU' WHERE SecCode = 5758113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812186220, ExchCode = 'FRA' WHERE SecCode = 5760234 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5772358 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783327713, ExchCode = 'GTX' WHERE SecCode = 5782814 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22040671244, ExchCode = 'MUN' WHERE SecCode = 5785805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037191743, ExchCode = 'BER' WHERE SecCode = 5785810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116802953, ExchCode = 'FRA' WHERE SecCode = 5785811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783330017, ExchCode = 'FRA' WHERE SecCode = 5786123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783329733, ExchCode = 'FRA' WHERE SecCode = 5786125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783353647, ExchCode = 'FRA' WHERE SecCode = 5786132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783353632, ExchCode = 'FRA' WHERE SecCode = 5786133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783353639, ExchCode = 'FRA' WHERE SecCode = 5786134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783847363, ExchCode = 'STU' WHERE SecCode = 5805681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783878429, ExchCode = 'FRA' WHERE SecCode = 5805700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783879182, ExchCode = 'FRA' WHERE SecCode = 5805706 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 5816808 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784438281, ExchCode = 'STU' WHERE SecCode = 5827593 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 5836309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22052269961, ExchCode = 'DEU' WHERE SecCode = 5881402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789587695, ExchCode = 'MUN' WHERE SecCode = 5881403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785642965, ExchCode = 'MUN' WHERE SecCode = 5886967 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5888342 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22054245159, ExchCode = 'DEU' WHERE SecCode = 5888374 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5898977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786584011, ExchCode = 'STU' WHERE SecCode = 5908829 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5911931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787828305, ExchCode = 'BER' WHERE SecCode = 5949087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787449425, ExchCode = 'SIG' WHERE SecCode = 5972437 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5978394 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6012791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787861720, ExchCode = 'FRA' WHERE SecCode = 6012971 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2024-10-18' WHERE SecCode = 6018397 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2024-12-20' WHERE SecCode = 6048000 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6092925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682858978, ExchCode = 'FRA' WHERE SecCode = 6097372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV', PermOrgIPODate = NULL WHERE SecCode = 6097383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171968, ExchCode = 'BIV' WHERE SecCode = 6097384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22085290988, ExchCode = 'MXQ' WHERE SecCode = 6097386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727345443, ExchCode = 'BIV' WHERE SecCode = 6097390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 6097546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22026330416, ExchCode = 'MXQ' WHERE SecCode = 6097558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999588395, Ticker = '3OISl', ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6101787 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6101943 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6109594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796521439, ExchCode = 'TDG' WHERE SecCode = 6112333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790416915, ExchCode = 'FRA' WHERE SecCode = 6128378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791216534, ExchCode = 'FRA' WHERE SecCode = 6186428 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6190695 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6196025 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6201045 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6201046 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6211075 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6245915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780909392, ExchCode = 'FRA' WHERE SecCode = 6256420 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6258193 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 6258199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792142922, ExchCode = 'FRA' WHERE SecCode = 6258508 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 6263912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595849, Ticker = '1RKLBm', ExchCode = 'BCO' WHERE SecCode = 6263925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595851, Ticker = '1ASTSm', ExchCode = 'BCO' WHERE SecCode = 6263938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595847, Ticker = '1LCIDm', ExchCode = 'BCO' WHERE SecCode = 6263964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595846, Ticker = '1IBKRm', ExchCode = 'BCO' WHERE SecCode = 6264009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595852, Ticker = '1MTCHm', ExchCode = 'BCO' WHERE SecCode = 6264036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595850, Ticker = '1EQTCm', ExchCode = 'BCO' WHERE SecCode = 6264133 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6264135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796595845, Ticker = '1VKTXm', ExchCode = 'BCO' WHERE SecCode = 6264167 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6264181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792206094, ExchCode = 'QTX' WHERE SecCode = 6264277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105365896, ExchCode = 'DEU' WHERE SecCode = 6285588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105365786, ExchCode = 'DEU' WHERE SecCode = 6285589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105365722, ExchCode = 'DEU' WHERE SecCode = 6285590 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 6302010 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6347354 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '6YF0' WHERE SecCode = 6360726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6378722 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6378723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121552149, ExchCode = 'DEU' WHERE SecCode = 6407334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794432868, ExchCode = 'TDG' WHERE SecCode = 6409726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915988514, ExchCode = 'MEX' WHERE SecCode = 6409757 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6411859 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6416433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6422988 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 6429291 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6429307 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6429308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795013278, ExchCode = 'FRA' WHERE SecCode = 6431549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6440008 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2025-10-02' WHERE SecCode = 6441634 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6441853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22131299417.0, IsPrimaryQuote = 1 WHERE SecCode = 6443422 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6448319 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6449023 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL, PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6449334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438804, ExchCode = 'TDG' WHERE SecCode = 6450885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795754736, ExchCode = 'FRA' WHERE SecCode = 6450941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438836, ExchCode = 'STU' WHERE SecCode = 6451088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795802495, ExchCode = 'QTX' WHERE SecCode = 6453946 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 6456244 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6457846 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 6457996 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6460615 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 6460616 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6460626 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6460627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796060166, ExchCode = 'FRA' WHERE SecCode = 6462842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128769340, ExchCode = 'DEU' WHERE SecCode = 6462856 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6464963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796327907, ExchCode = 'TDG' WHERE SecCode = 6464981 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6467510 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 6467519 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-28' WHERE SecCode = 6467527 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-25', PermSecMapEndDate = NULL WHERE SecCode = 6467530 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6469298 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6469299 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6469317 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6469318 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6469319 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6472010 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-25' WHERE SecCode = 6472014 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6472017 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6472018 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-29', PermSecMapEndDate = '2025-09-29' WHERE SecCode = 6472021 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6472022 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951779.0, PermOrgIPODate = '2025-09-26' WHERE SecCode = 6472088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796404842, ValQuotePermID = 236796404842.0, Ticker = 'DELIA', ExchCode = 'OSL' WHERE SecCode = 6474420 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6474497 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6474558 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6474622 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-01' WHERE SecCode = 6474623 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-29' WHERE SecCode = 6476446 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-29' WHERE SecCode = 6476449 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6476482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796405777, ValQuotePermID = 236796404842.0, ExchCode = 'GTX' WHERE SecCode = 6478318 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6478328 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 6478378 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0, PermOrgIPODate = '2025-09-30' WHERE SecCode = 6478380 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236796466991.0, IsPrimaryQuote = 1 WHERE SecCode = 6480217 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236796466609.0, IsPrimaryQuote = 1 WHERE SecCode = 6480218 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6480248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438835, ExchCode = 'ASX' WHERE SecCode = 6480251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438808, ExchCode = 'TDG' WHERE SecCode = 6480271 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22131538896, ExchCode = 'DEU' WHERE SecCode = 6480272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796439130, ExchCode = 'MEX' WHERE SecCode = 6480273 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438942, ExchCode = 'TDG' WHERE SecCode = 6480274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796467786, ExchCode = 'QTX' WHERE SecCode = 6480327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796521884, ExchCode = 'FRA' WHERE SecCode = 6480863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796521968, ExchCode = 'FRA' WHERE SecCode = 6480864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796521993, ExchCode = 'FRA' WHERE SecCode = 6480866 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6480868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796059933, ExchCode = 'MUN', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 6480954 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 10811170 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796559173, InstrPermID = 21498107911, ValQuotePermID = 236795665850.0, IsPrimaryInstr = 1, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'SFGRF', ExchCode = 'GTC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-02', PermSecMapEndDate = NULL WHERE SecCode = 10895231 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10896000 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10906505 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10911585 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10912451 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10912504 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-30' WHERE SecCode = 10913779 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10920501 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10922725 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 10922960 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10961514 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10965482 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 10965490 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 10966609 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10979153 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11001800 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11002228 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11009046 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11009381 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11010254 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11015634 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11021439 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11025091 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 11028815 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11033942 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11036969 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11047378 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11051207 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'DLMKF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-03', PermSecMapEndDate = NULL WHERE SecCode = 11055730 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11056359 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11057985 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11059176 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'RMXFF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-01', PermSecMapEndDate = NULL WHERE SecCode = 11061958 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11062344 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'AMUIF' WHERE SecCode = 11063828 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11068733 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11069704 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11104654 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11105333 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096839867 WHERE SecCode = 11107137 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11108135 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11123687 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11129840 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11134982 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11136830 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 11138678 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LNAI' WHERE SecCode = 11142344 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11142352 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'IMI' WHERE SecCode = 11149536 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'PRHI' WHERE SecCode = 11151122 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11152639 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11152648 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11158291 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11158402 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 11162745 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11167652 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11168013 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11169421 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'HLYK' WHERE SecCode = 11172213 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11173354 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11173701 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'CMHDF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-01', PermSecMapEndDate = NULL WHERE SecCode = 11174367 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02' WHERE SecCode = 11184890 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11185202 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11188391 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11189762 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11190675 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11191162 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11191438 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 11192150 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951929.0, PermSecMapEndDate = NULL WHERE SecCode = 11194108 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11202310 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'TOR' WHERE SecCode = 11202685 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'INNPF' WHERE SecCode = 11202712 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11203534 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11204383 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11204565 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11209365 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11209541 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11211846 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11213816 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11213869 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11213964 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11214225 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11214899 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11214936 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 11215120 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11216054 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11216106 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 11216608 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AYFIF', PermQuoteRetireDate = NULL WHERE SecCode = 11216856 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11217809 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11219689 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11219738 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11225118 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11225542 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11226120 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11226158 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11227627 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11227644 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11227879 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11230315 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11232072 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11232238 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapStartDate = '2023-11-22' WHERE SecCode = 11232941 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AVMLF', PermQuoteRetireDate = NULL WHERE SecCode = 11233270 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11240139 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = NULL, PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11240747 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'ALCE' WHERE SecCode = 11240997 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11241414 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11241585 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096827291, IncCntry = 'USA', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2022-04-07' WHERE SecCode = 11242359 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11242796 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11244761 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11244795 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11245695 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727172565, PriTrdQuotePermID = NULL, Ticker = 'DMYYU', ExchCode = 'PNK' WHERE SecCode = 11246265 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727169310, PriTrdQuotePermID = NULL, ExchCode = 'PNK' WHERE SecCode = 11247542 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096765318, OrgTypeCode = 'UNK', DomCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11248397 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SLMT' WHERE SecCode = 11249174 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11249579 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'AQLS' WHERE SecCode = 11249737 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096839985, IncCntry = 'USA', PriTRBCIndPermID = 1004365444.0, PermOrgIPODate = '2023-04-21' WHERE SecCode = 11252317 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096839985, IncCntry = 'USA', PriTRBCIndPermID = 1004365444.0, PermOrgIPODate = '2023-04-21' WHERE SecCode = 11253494 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11256248 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'PRHIZ', QuoteClass = 'SENIOR', InstrClass = 'SENIOR' WHERE SecCode = 11256281 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11257617 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11258408 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11259265 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PriTRBCIndPermID = 4294951430.0, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11260920 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11261678 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11262266 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11267719 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-29' WHERE SecCode = 11269314 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11269762 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11270088 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2024-10-18' WHERE SecCode = 11270656 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11273816 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'UCFI', ExchCode = 'NAS', PriTRBCIndPermID = 4294951430.0 WHERE SecCode = 11274801 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PriTRBCIndPermID = 4294951430.0, PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11274949 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'MXXNF' WHERE SecCode = 11275722 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276844 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276871 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276874 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276875 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276924 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276928 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11276933 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11276991 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-02', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11277168 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280126 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280128 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280129 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280130 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280131 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280132 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280210 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280211 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280212 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280214 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280217 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280218 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280220 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280222 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280223 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280224 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11280225 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280269 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280271 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280273 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-01', PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11280274 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11280299 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11280300 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11280302 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11280303 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11280305 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'PASW' WHERE SecCode = 11280999 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232887386361.0, IsPrimaryInstr = 0 WHERE SecCode = 11281417 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11281943 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-10-03', PermSecMapEndDate = '2025-10-03' WHERE SecCode = 11281949 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232894674548.0, IsPrimaryInstr = 0 WHERE SecCode = 11281954 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232896430265.0, IsPrimaryInstr = 0 WHERE SecCode = 11282047 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232885336450.0, IsPrimaryInstr = 0 WHERE SecCode = 11282049 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-01' WHERE SecCode = 11284221 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232898803122.0, IsPrimaryInstr = 0 WHERE SecCode = 11284441 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-06' WHERE SecCode = 11285120 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NSQ' WHERE SecCode = 11285207 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796441138, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11285376 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796441203, PriTrdQuotePermID = 236796441203.0, Ticker = 'RITM PR E', ExchCode = 'NYS', PermSecMapStartDate = '2025-09-30' WHERE SecCode = 11285480 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11285716 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-30', PermSecMapEndDate = '2025-09-30' WHERE SecCode = 11285769 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = '2025-09-25' WHERE SecCode = 11285809 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2025-10-02' WHERE SecCode = 11285914 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11285986 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796441172, PriTrdQuotePermID = 236796441172.0, ValQuotePermID = 25727059775.0, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11286102 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796470054, IsPrimaryQuote = 1, ExchCode = 'NAS' WHERE SecCode = 11286201 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796525124, PriTrdQuotePermID = 236796525124.0, ValQuotePermID = 25727059353.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NAS' WHERE SecCode = 11286246 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 236796525093.0, IsPrimaryQuote = 1 WHERE SecCode = 11286284 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796525178, PriTrdQuotePermID = 236796525178.0, ValQuotePermID = 25727059257.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NMS' WHERE SecCode = 11286286 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796525195, PriTrdQuotePermID = 236796525195.0, ValQuotePermID = 25727059237.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NMS' WHERE SecCode = 11286287 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796525214, PriTrdQuotePermID = 236796525214.0, ValQuotePermID = 25727059190.0, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11286288 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796525158, PriTrdQuotePermID = 236796525158.0, ValQuotePermID = 25727059313.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NAS' WHERE SecCode = 11286290 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796525232, PriTrdQuotePermID = 236796525232.0, ValQuotePermID = 25727059152.0, IsPrimaryQuote = 1, ExchCode = 'NAS' WHERE SecCode = 11286291 AND Type_ = 1;