UPDATE data_universe_permid SET QuotePermID = 55836047051, Ticker = 'ABBY', ExchCode = 'LSE', PermQuoteRetireDate = '2021-04-30' WHERE SecCode = 24 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838297624, Ticker = 'AMEAS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 297 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 = 21530530883, ExchCode = 'CHI' WHERE SecCode = 946 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10591 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000187321, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 23841 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21621817183, IsPrimaryQuote = 1, Ticker = 'COLO2', PermQuoteRetireDate = '2021-03-03', PermSecMapStartDate = '2024-05-29', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 28027 AND Type_ = 10; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 32013 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21531131865, Ticker = 'NMBAl', ExchCode = 'BCO', PermQuoteRetireDate = '2021-12-10' WHERE SecCode = 32063 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819123206, ExchCode = 'DUS' WHERE SecCode = 34189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921478652, ExchCode = 'MUN' WHERE SecCode = 35017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667491723, ExchCode = 'QTX', PermQuoteRetireDate = '2023-10-06' WHERE SecCode = 35165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836422557, ExchCode = 'FRA' WHERE SecCode = 35663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800269669, ExchCode = 'FRA' WHERE SecCode = 35680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475422364, ExchCode = 'HAN', PermQuoteRetireDate = '2004-04-23' WHERE SecCode = 36125 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 37569 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474890505, ExchCode = 'DEU' WHERE SecCode = 37677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645438282, PermQuoteStatus = 'AC', Ticker = 'MCY', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667486921, ExchCode = 'QTX' WHERE SecCode = 37856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475437296, ExchCode = 'STU' WHERE SecCode = 37861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835780862, PermQuoteStatus = 'AC', Ticker = 'BBVA', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 37875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474862297, ExchCode = 'DEU', PermQuoteRetireDate = '2016-03-30' WHERE SecCode = 37920 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837365008, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475625660, ExchCode = 'BER' WHERE SecCode = 37981 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 38652 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-23' WHERE SecCode = 38748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662115397, ExchCode = 'TDG', PermQuoteRetireDate = '2019-07-11' WHERE SecCode = 38789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475037143, ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 38963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331873, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 41641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329373, ExchCode = 'BER', PermQuoteRetireDate = '2015-03-31' WHERE SecCode = 41713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475037237, ExchCode = 'TDG', PermQuoteRetireDate = '2017-02-24' WHERE SecCode = 41724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55839725690, Ticker = 'CM3A', ExchCode = 'BER', PermQuoteRetireDate = '2008-02-18' WHERE SecCode = 42056 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856248871, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2021-08-02' WHERE SecCode = 43267 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 43350 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 = 55838512918, PermQuoteStatus = 'AC', Ticker = 'EGID', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 45916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838240996, ExchCode = 'MUN' WHERE SecCode = 46009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475624203, Ticker = 'SCXG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 46239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836531592, ExchCode = 'FRA' WHERE SecCode = 46521 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 46529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838489254, ExchCode = 'STU' WHERE SecCode = 47291 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 47454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033916, Ticker = 'BIL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-28' WHERE SecCode = 48081 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642496474, ExchCode = 'BTE' WHERE SecCode = 52632 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618315552, ExchCode = 'TDG' WHERE SecCode = 53240 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'IDXG' WHERE SecCode = 53403 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475555697, Ticker = 'MKE.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330157, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 54333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878335155, ExchCode = 'GTX' WHERE SecCode = 54337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475605514, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-07-14' WHERE SecCode = 54587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585102636, ExchCode = 'STU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 57475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587014930, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 57612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475745692, ExchCode = 'FRA' WHERE SecCode = 57701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850036777, Ticker = 'TRK1', ExchCode = 'BER', PermQuoteRetireDate = '2009-12-15' WHERE SecCode = 57706 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641483764, ExchCode = 'STU' WHERE SecCode = 57850 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 58043 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 58173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512093309, ExchCode = 'STU' WHERE SecCode = 59853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613489654, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-06' WHERE SecCode = 59963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835780234, ExchCode = 'DUS', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 60051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836418089, ExchCode = 'FRA' WHERE SecCode = 60122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778845387, ExchCode = 'QTX' WHERE SecCode = 60208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836462298, ExchCode = 'FRA', PermQuoteRetireDate = '2016-08-22' WHERE SecCode = 60351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339202, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 60697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812814321, ExchCode = 'FRA' WHERE SecCode = 60795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475090482, ExchCode = 'TDG', PermQuoteRetireDate = '2016-05-19' WHERE SecCode = 60955 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642934979, ExchCode = 'MUN' WHERE SecCode = 61355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857444158, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-15' WHERE SecCode = 61396 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836392107, ExchCode = 'FRA', PermQuoteRetireDate = '2014-06-02' WHERE SecCode = 61442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667491107, ExchCode = 'QTX', PermQuoteRetireDate = '2019-09-30' WHERE SecCode = 61463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293916, ExchCode = 'GTX' WHERE SecCode = 61992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830289150, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531428078, ExchCode = 'FRA' WHERE SecCode = 63188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842460200, ExchCode = 'HAN' WHERE SecCode = 63905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544483339, ExchCode = 'TDG' WHERE SecCode = 64549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522869226, Ticker = 'ST7', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-28' WHERE SecCode = 64555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474984046, ExchCode = 'HAM', PermQuoteRetireDate = '2012-07-11' WHERE SecCode = 64558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838614207, ExchCode = 'STU', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 65172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808191719, ExchCode = 'QTX' WHERE SecCode = 65173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22166292609, ExchCode = 'DEU' WHERE SecCode = 65372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525789034, ExchCode = 'FRA' WHERE SecCode = 65966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836394706, Ticker = 'CWU', ExchCode = 'FRA', PermQuoteRetireDate = '2008-07-01' WHERE SecCode = 65967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807782481, ExchCode = 'FRA' WHERE SecCode = 66040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482780, ExchCode = 'QTX' WHERE SecCode = 66061 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951724.0 WHERE SecCode = 75798 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 75995 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 79225 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 84599 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 88744 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8590005558.0 WHERE SecCode = 90404 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 8590005558.0, IsPrimaryInstr = 1 WHERE SecCode = 90405 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 91396 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1998-11-20' WHERE SecCode = 97778 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-28' WHERE SecCode = 99240 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000367607, PermOrgIPODate = NULL WHERE SecCode = 100518 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21748242454, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 102656 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951724.0 WHERE SecCode = 111658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513801692, Ticker = 'OFC', ExchCode = 'STU', PermQuoteRetireDate = '2015-07-03' WHERE SecCode = 111691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837359282, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 111866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838237040, ExchCode = 'MUN' WHERE SecCode = 111869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821641631, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-14' WHERE SecCode = 111938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475455139, ExchCode = 'GER' WHERE SecCode = 112016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585674848, ExchCode = 'FRA' WHERE SecCode = 112018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804440368, ExchCode = 'FRA' WHERE SecCode = 112091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419772, ExchCode = 'HAM' WHERE SecCode = 112135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803604100, ExchCode = 'FRA' WHERE SecCode = 112136 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850895861, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 112185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475775904, ExchCode = 'MUN' WHERE SecCode = 112468 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1998-11-20' WHERE SecCode = 112945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798248646, ExchCode = 'DEU' WHERE SecCode = 113665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560429607, ExchCode = 'DEU' WHERE SecCode = 114573 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550078870, ExchCode = 'HAM' WHERE SecCode = 114612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853086159, ExchCode = 'GER' WHERE SecCode = 114613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836414801, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-20', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836430625, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-20' WHERE SecCode = 114828 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337680, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' 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 = 55836330949, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 130530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836340722, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 131656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538295457, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 132852 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484045, PermQuoteStatus = 'DC', Ticker = 'DTI', ExchCode = 'QTX', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 132877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526528181, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 133354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806357780, ExchCode = 'STU' WHERE SecCode = 133363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807446056, ExchCode = 'DEU' WHERE SecCode = 138280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818729788, ExchCode = 'FRA' WHERE SecCode = 138787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523736019, ExchCode = 'STU' WHERE SecCode = 138789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789195679, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-22', PermSecMapEndDate = NULL WHERE SecCode = 138990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236814295119, ExchCode = 'FRA' WHERE SecCode = 141302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792995978, ExchCode = 'FRA' WHERE SecCode = 141307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323663, ExchCode = 'BER', PermQuoteRetireDate = '2016-03-04' WHERE SecCode = 141320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805701995, ExchCode = 'FRA' WHERE SecCode = 141365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168877672, ExchCode = 'DEU' WHERE SecCode = 141918 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834675828, PermQuoteStatus = 'AC', Ticker = '0O1R', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 143851 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634298469, Ticker = '0JPHl', ExchCode = 'BCO', PermQuoteRetireDate = '2026-03-17' WHERE SecCode = 144012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22144566191, ExchCode = 'DEU' WHERE SecCode = 144104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778285096, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536791830, ExchCode = 'TDG', PermQuoteRetireDate = '2019-06-12' WHERE SecCode = 144107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718787365, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565229404, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793968535, ExchCode = 'FRA' WHERE SecCode = 146440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641955238, ExchCode = 'DEU', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = NULL WHERE SecCode = 146856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492709376, ExchCode = 'STU' WHERE SecCode = 150485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21686828249, ExchCode = 'STU' WHERE SecCode = 150488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838240695, ExchCode = 'MUN' WHERE SecCode = 173076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475127433, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 177369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294340, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 177695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536791757, ExchCode = 'STU', PermQuoteRetireDate = '2024-02-28' WHERE SecCode = 177697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784472629, ExchCode = 'TDG' WHERE SecCode = 177698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830311950, ExchCode = 'GTX' WHERE SecCode = 177699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808726025, ExchCode = 'FRA' WHERE SecCode = 177715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538212, ExchCode = 'GTX' WHERE SecCode = 177724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836472269, ExchCode = 'FRA' WHERE SecCode = 177726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474891708, ExchCode = 'DEU', PermQuoteRetireDate = '2014-08-04' WHERE SecCode = 177732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21574154598, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177741 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803540018, ExchCode = 'FRA' WHERE SecCode = 177750 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798767854, ExchCode = 'FRA' WHERE SecCode = 177764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892047337, ExchCode = 'MUN' WHERE SecCode = 177779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475793826, ExchCode = 'STU' WHERE SecCode = 177783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22192131582, ExchCode = 'DEU' WHERE SecCode = 178133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337965, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178676 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 178694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913478289, Ticker = 'GG9B', ExchCode = 'TDG' WHERE SecCode = 178972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21926264548, ExchCode = 'DEU' WHERE SecCode = 192798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641955347, ExchCode = 'FRA' WHERE SecCode = 202264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782179201, ExchCode = 'GTX' WHERE SecCode = 203057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809269658, Ticker = 'HENIv', ExchCode = 'BCO' WHERE SecCode = 241262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779358971, ExchCode = 'GTX' WHERE SecCode = 249684 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 252333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331515, ExchCode = 'BER', PermQuoteRetireDate = '2014-09-15' WHERE SecCode = 261908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521982021, ExchCode = 'MUN' WHERE SecCode = 289897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 289915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168877482, ExchCode = 'DEU' WHERE SecCode = 291229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525845979, ExchCode = 'STU' WHERE SecCode = 313561 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 325774 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 332187 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 334072 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BRRND' WHERE SecCode = 334802 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000187321, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 347024 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641029223, ExchCode = 'TDG' WHERE SecCode = 347026 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474949418, ExchCode = 'DEU', PermQuoteRetireDate = '2013-09-17' WHERE SecCode = 375090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794060331, ExchCode = 'MUN', PermQuoteRetireDate = '2026-09-01' WHERE SecCode = 387911 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 391862 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951226.0 WHERE SecCode = 409378 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ELIT' WHERE SecCode = 492077 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 531769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606643390, ExchCode = 'STU' WHERE SecCode = 532384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851833844, InstrPermID = 8591342256, ValQuotePermID = 55851745818.0, Ticker = '000153971' WHERE SecCode = 538765 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 554603 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 559064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858255778, ExchCode = 'STU' WHERE SecCode = 566156 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22150892460, ExchCode = 'DEU' WHERE SecCode = 587958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883770140, ExchCode = 'DEU' WHERE SecCode = 587985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531115889, Ticker = '5OTZd', ExchCode = 'BCO', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 587990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910180906, ExchCode = 'DEU' WHERE SecCode = 588124 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22151702240, ExchCode = 'DEU' WHERE SecCode = 588158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236815023801, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-12-31', PermSecMapEndDate = NULL WHERE SecCode = 684792 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 787615 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 821671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554127327, Ticker = 'XSILz', ExchCode = 'CHI' WHERE SecCode = 880290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797836703, ExchCode = 'FRA' WHERE SecCode = 899770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783353634, ExchCode = 'FRA' WHERE SecCode = 909539 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 948742 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1230252 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapStartDate = '2016-10-20', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 1235249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513439709, PermQuoteStatus = 'AC', Ticker = '0ZG', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1256628 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514028129, ExchCode = 'FRA' WHERE SecCode = 1480701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067019121, ExchCode = 'BTE' WHERE SecCode = 1510139 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21496616544, ExchCode = 'GER' WHERE SecCode = 1547522 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21505907761, ExchCode = 'FRA' WHERE SecCode = 1555435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21496869382, ExchCode = 'DEU' WHERE SecCode = 1555473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21507263280, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1555489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1998-11-20' WHERE SecCode = 1576231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21503838088, ExchCode = 'BER', PermQuoteRetireDate = '2017-05-30' WHERE SecCode = 1587478 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22208467780, ExchCode = 'HAN', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 1596487 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1691482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827034760, ExchCode = 'TDG' WHERE SecCode = 1694101 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 1980641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477220689 WHERE SecCode = 1999338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448610, ExchCode = 'FRA' WHERE SecCode = 2194277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000380127, DomCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2013-08-12' WHERE SecCode = 2382350 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 = 21554847086, ExchCode = 'DEU' WHERE SecCode = 2453146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830302382, ExchCode = 'GTX' WHERE SecCode = 2497940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539906288, ExchCode = 'FRA' WHERE SecCode = 2540723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543675835, ExchCode = 'BER' WHERE SecCode = 2579449 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', DomCntry = 'USA', PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 2642465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678573, ExchCode = 'BIV' WHERE SecCode = 2644180 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2654777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604748574, ExchCode = 'MEX' WHERE SecCode = 2715222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915374305, ExchCode = 'FRA' WHERE SecCode = 2724348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555161043, ExchCode = 'STU' WHERE SecCode = 2796969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557245542, ExchCode = 'STU' WHERE SecCode = 2809752 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000380127, DomCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2013-08-12' WHERE SecCode = 2856999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679964, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3009148 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-23', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 3011184 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 3056834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21586352659, ExchCode = 'DEU' WHERE SecCode = 3145253 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3181677 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000400350, PriTRBCIndPermID = NULL WHERE SecCode = 3197040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22202786277, ExchCode = 'BCO' WHERE SecCode = 3198703 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000400350, PriTRBCIndPermID = NULL WHERE SecCode = 3199217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617014318, Ticker = '4FRE', ExchCode = 'ETX' WHERE SecCode = 3212155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621369123, ExchCode = 'TDG' WHERE SecCode = 3241011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597702989, ExchCode = 'DEU' WHERE SecCode = 3260047 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598617553, ExchCode = 'AUX' WHERE SecCode = 3261247 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951226.0 WHERE SecCode = 3282989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801289048, ExchCode = 'DEU' WHERE SecCode = 3285727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611446463, ExchCode = 'DEU' WHERE SecCode = 3337222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623456110, Ticker = 'UCG', ExchCode = 'VIE' WHERE SecCode = 3395516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727291640, Ticker = 'STLA', ExchCode = 'VIE' WHERE SecCode = 3395573 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623458879, Ticker = 'PC', ExchCode = 'VIE' WHERE SecCode = 3395653 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623599840, Ticker = 'MEO2', ExchCode = 'VIE' WHERE SecCode = 3395686 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 3402115 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3408356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629735247, InstrPermID = 21628797032, ValQuotePermID = 21629735247.0, Ticker = '750603', PermQuoteRetireDate = '2018-08-08', PermSecMapEndDate = '2017-12-27' WHERE SecCode = 3410233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830307297, ExchCode = 'GTX' WHERE SecCode = 3431060 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000187321, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 3431706 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3432500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3441651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704965, ExchCode = 'MXQ' WHERE SecCode = 3512964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21654424898, ExchCode = 'STU' WHERE SecCode = 3537039 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951226.0 WHERE SecCode = 3543179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750886845, ExchCode = 'DEU' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667706084, Ticker = 'WBC*', ExchCode = 'MXQ' WHERE SecCode = 3566723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478907, ExchCode = 'QTX', PermQuoteRetireDate = '2021-06-17', PermSecMapEndDate = '2025-11-27' WHERE SecCode = 3566804 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3635554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469777, ExchCode = 'FRA' WHERE SecCode = 3648237 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8590005558.0, IsPrimaryInstr = 1 WHERE SecCode = 3747813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813386737, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3819180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700880909, ExchCode = 'FRA' WHERE SecCode = 3875222 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3885281 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3949028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713340740, ExchCode = 'FRA' WHERE SecCode = 3965078 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731261056, Ticker = '0A2Zl', ExchCode = 'BCO' WHERE SecCode = 3986787 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000187321, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 3987742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027050, Ticker = '1PFE' WHERE SecCode = 4031737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026914, Ticker = '1MMM' WHERE SecCode = 4031743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027140, Ticker = '1VZ' WHERE SecCode = 4031747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026850, Ticker = '1WMT' WHERE SecCode = 4031748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828384, Ticker = '1OMVm', ExchCode = 'BCO' WHERE SecCode = 4031755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928205, Ticker = '1RRTLm', ExchCode = 'BCO' WHERE SecCode = 4031758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784327741, Ticker = '1BOD' WHERE SecCode = 4031822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026741, Ticker = '1WBD' WHERE SecCode = 4031843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027144, Ticker = '1DUE' WHERE SecCode = 4031852 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801289687, Ticker = '4FRVIA', ExchCode = 'ETX' WHERE SecCode = 4031858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026922, Ticker = '1EVT' WHERE SecCode = 4031864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026867, Ticker = '1F' WHERE SecCode = 4031866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026911, Ticker = '1MAP' WHERE SecCode = 4032116 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2019-12-06' WHERE SecCode = 4050838 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 4069934 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'USZ0' WHERE SecCode = 4087855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737966407, ExchCode = 'STU' WHERE SecCode = 4119578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756131001, ExchCode = 'STU' WHERE SecCode = 4237792 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', DomCntry = NULL, PermSecMapEndDate = '2026-09-23' WHERE SecCode = 4275853 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 4282408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099131111, ExchCode = 'CHI' WHERE SecCode = 4296947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580130, ExchCode = 'FRA' WHERE SecCode = 4315115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764112353, ExchCode = 'FRA' WHERE SecCode = 4324622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21765297153, ExchCode = 'DEU' WHERE SecCode = 4335866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773606581, ExchCode = 'FRA' WHERE SecCode = 4372742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307329, ExchCode = 'BIV' WHERE SecCode = 4415716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776858467, ExchCode = 'STU' WHERE SecCode = 4429684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236814994480, PermQuoteStatus = 'AC', ExchCode = 'HAN', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-12-31', PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798227414, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4443927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953035, ExchCode = 'DEU' WHERE SecCode = 4449787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299957, ExchCode = 'BIV' WHERE SecCode = 4451248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788443860, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4451256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798248761, PermQuoteStatus = 'AC', Ticker = 'OXI', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4500453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800722506, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4511455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800479515, ExchCode = 'DEU' WHERE SecCode = 4511502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800479400, ExchCode = 'DEU' WHERE SecCode = 4511503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800479439, ExchCode = 'DEU' WHERE SecCode = 4511504 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800479449, ExchCode = 'DEU' WHERE SecCode = 4511505 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800479386, ExchCode = 'DEU' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000276271 WHERE SecCode = 4513653 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000367607, PermOrgIPODate = NULL WHERE SecCode = 4530216 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000381669, PriTRBCIndPermID = NULL WHERE SecCode = 4534864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808977706, ExchCode = 'PFT' WHERE SecCode = 4566926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810198420, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4573513 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 4576450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813567780, ExchCode = 'FRA' WHERE SecCode = 4594427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813567101, ExchCode = 'FRA' WHERE SecCode = 4605986 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 4614959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822885474, ExchCode = 'MUN' WHERE SecCode = 4615934 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'UNK' WHERE SecCode = 4638781 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'UNK' WHERE SecCode = 4639596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726970, ExchCode = 'MUN' WHERE SecCode = 4655597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727246903, ExchCode = 'BIV' WHERE SecCode = 4662851 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000381669, PriTRBCIndPermID = NULL WHERE SecCode = 4675176 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873118953, Ticker = 'CARBm', ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244845, ExchCode = 'MEX' WHERE SecCode = 4695799 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 4712755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852386234, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4720518 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2021-08-13' WHERE SecCode = 4720519 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867671, ExchCode = 'DEU' WHERE SecCode = 4752179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867538, ExchCode = 'FRA' WHERE SecCode = 4752212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853461204, ExchCode = 'DEU' WHERE SecCode = 4757849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856518137, ExchCode = 'DEU' WHERE SecCode = 4777350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860097836, ExchCode = 'FRA', PermQuoteRetireDate = '2021-12-14', PermSecMapEndDate = '2021-12-14' WHERE SecCode = 4788710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861354817, ExchCode = 'FRA' WHERE SecCode = 4802327 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 4806550 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-23', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 4806670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861191374, Ticker = '3AIE', ExchCode = 'LSE' WHERE SecCode = 4807553 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'YT1' WHERE SecCode = 4810066 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886808179, ExchCode = 'MUN' WHERE SecCode = 4811144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881522588, ExchCode = 'STU' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22206812340, ExchCode = 'LAS' WHERE SecCode = 4850980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836229, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2023-03-27' WHERE SecCode = 4871212 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'UNK' WHERE SecCode = 4903982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880180491, Ticker = 'ET0Y', ExchCode = 'FRA' WHERE SecCode = 4921164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879829844, ExchCode = 'STU' WHERE SecCode = 4921189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881260821, PermQuoteStatus = 'DC', Ticker = '89E0', ExchCode = 'BER', PermQuoteRetireDate = '2024-06-03' WHERE SecCode = 4927414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884081519, ExchCode = 'MUN' WHERE SecCode = 4949680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885447302, ExchCode = 'DUS' WHERE SecCode = 4954565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727201433, ExchCode = 'BIV' WHERE SecCode = 4955623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887740667, ExchCode = 'STU' WHERE SecCode = 4965055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419171, ExchCode = 'LAS' WHERE SecCode = 4965075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784278069, ExchCode = 'FRA' WHERE SecCode = 4975850 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000381669, PriTRBCIndPermID = NULL WHERE SecCode = 4991559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895150761, ExchCode = 'STU', PermQuoteRetireDate = '2022-06-03', PermSecMapEndDate = '2022-06-03' WHERE SecCode = 5037318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906179470, ExchCode = 'MUN' WHERE SecCode = 5089527 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000381669, PriTRBCIndPermID = NULL WHERE SecCode = 5107764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21909714937, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5109039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21909895691, ExchCode = 'FRA' WHERE SecCode = 5120587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916930664, PermQuoteStatus = 'AC', Ticker = '0ABJ', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5147798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788969076, ExchCode = 'QTX' WHERE SecCode = 5147805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22192438164, ExchCode = 'STU' WHERE SecCode = 5152288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945897707, ExchCode = 'STU' WHERE SecCode = 5174430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836104, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5183026 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22076466678, ExchCode = 'BCO' WHERE SecCode = 5206290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 5209760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928854434, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5209798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21930247937, ExchCode = 'DEU' WHERE SecCode = 5238262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21930807218, ExchCode = 'DEU' WHERE SecCode = 5238285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929763302, ExchCode = 'FRA' WHERE SecCode = 5238296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933395774, ExchCode = 'DEU' WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396208, ExchCode = 'DEU' WHERE SecCode = 5253711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396592, ExchCode = 'DEU' WHERE SecCode = 5253715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396669, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5253716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933396231, ExchCode = 'DEU' WHERE SecCode = 5253717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787451122, ExchCode = 'FRA' WHERE SecCode = 5253719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775294003, ExchCode = 'MEX' WHERE SecCode = 5283359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650189, ExchCode = 'DUS' WHERE SecCode = 5301963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775732430, ExchCode = 'MEX' WHERE SecCode = 5308052 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943369902, ExchCode = 'FRA' WHERE SecCode = 5308057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775782162, ExchCode = 'MEX' WHERE SecCode = 5308058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957274281, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-11' WHERE SecCode = 5320940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059916, ExchCode = 'DEU' WHERE SecCode = 5354968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037286507, ExchCode = 'BCO' WHERE SecCode = 5363621 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 5379096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21964248992, ExchCode = 'DEU' WHERE SecCode = 5403084 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'UNK' WHERE SecCode = 5418879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777584189, ExchCode = 'GTX' WHERE SecCode = 5426676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360194, ExchCode = 'MEX' WHERE SecCode = 5449618 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5503680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780784307, ExchCode = 'FRA' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852456429, Ticker = 'VSOL', ExchCode = 'BRN' WHERE SecCode = 5645876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031122856, ExchCode = 'CHI' WHERE SecCode = 5645964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781782679, ExchCode = 'BIV' WHERE SecCode = 5679079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22020600393, ExchCode = 'DEU' WHERE SecCode = 5679100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858189, ExchCode = 'FRA' WHERE SecCode = 5687957 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5765177 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8590005558.0 WHERE SecCode = 5785679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136364062, ExchCode = 'CHI' WHERE SecCode = 5797044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786439225, PermQuoteStatus = 'AC', Ticker = '83W', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5928247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788328463, ExchCode = 'BIV' WHERE SecCode = 6020909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789022080, ExchCode = 'FRA' WHERE SecCode = 6056912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789022081, ExchCode = 'FRA' WHERE SecCode = 6056913 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789902797, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30', PermSecMapEndDate = '2025-01-30' WHERE SecCode = 6114320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791039883, ExchCode = 'DUS' WHERE SecCode = 6139932 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791266479, Ticker = 'SATG', ExchCode = 'VIE' WHERE SecCode = 6190664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792403445, ExchCode = 'FRA' WHERE SecCode = 6278572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22159901582, ExchCode = 'LAS' WHERE SecCode = 6291969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793674404, ExchCode = 'FRA' WHERE SecCode = 6360726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793675077, ExchCode = 'FRA' WHERE SecCode = 6360727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793674776, ExchCode = 'FRA' WHERE SecCode = 6360728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794616561, ExchCode = 'FRA' WHERE SecCode = 6418487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794619095, ExchCode = 'QTX' WHERE SecCode = 6418488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794616600, ExchCode = 'STU' WHERE SecCode = 6418489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125348509, ExchCode = 'DEU' WHERE SecCode = 6438419 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-09-22', PermSecMapEndDate = NULL WHERE SecCode = 6456382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796366873, ExchCode = 'FRA' WHERE SecCode = 6482843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22205689801, ExchCode = 'LAS' WHERE SecCode = 6520811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798383432, ExchCode = 'TDG' WHERE SecCode = 6533454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799016699, ExchCode = 'FRA' WHERE SecCode = 6556288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143843399, ExchCode = 'DEU' WHERE SecCode = 6577960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172912646, ExchCode = 'SWX' WHERE SecCode = 6627069 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804306518, ExchCode = 'FRA' WHERE SecCode = 6721472 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804306521, ExchCode = 'FRA' WHERE SecCode = 6721473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804306501, ExchCode = 'FRA' WHERE SecCode = 6721474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804306520, ExchCode = 'FRA' WHERE SecCode = 6721475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239278, ExchCode = 'TDG' WHERE SecCode = 6727870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806228771, ExchCode = 'FRA' WHERE SecCode = 6813221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806228774, ExchCode = 'FRA' WHERE SecCode = 6813222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175707121, ExchCode = 'DEU' WHERE SecCode = 6813223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257558, ExchCode = 'DEU' WHERE SecCode = 6813269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176596754, ExchCode = 'DEU' WHERE SecCode = 6820146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809000062, ExchCode = 'LAS' WHERE SecCode = 6820147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806410004, ExchCode = 'FRA' WHERE SecCode = 6820244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176932924, ExchCode = 'DEU' WHERE SecCode = 6826539 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176935089, ExchCode = 'DEU' WHERE SecCode = 6826548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179524835, ExchCode = 'STU' WHERE SecCode = 6843187 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '2L90' WHERE SecCode = 6843286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807168148, ExchCode = 'TDG' WHERE SecCode = 6862202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807109364, ExchCode = 'BIV' WHERE SecCode = 6862277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181887310, ExchCode = 'DEU' WHERE SecCode = 6873669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807481799, ExchCode = 'FRA' WHERE SecCode = 6876675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257847, ExchCode = 'FRA' WHERE SecCode = 6876677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257704, ExchCode = 'GER' WHERE SecCode = 6876680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257640, ExchCode = 'FRA' WHERE SecCode = 6876681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257712, ExchCode = 'GER' WHERE SecCode = 6876686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257778, ExchCode = 'FRA' WHERE SecCode = 6876691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183194321, ExchCode = 'DEU' WHERE SecCode = 6882001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807883959, ExchCode = 'FRA' WHERE SecCode = 6893691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886145, ExchCode = 'MEX' WHERE SecCode = 6893698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807581061, ExchCode = 'BIV' WHERE SecCode = 6893701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807612967, ExchCode = 'TDG', PermQuoteRetireDate = '2026-07-15', PermSecMapEndDate = '2026-07-15' WHERE SecCode = 6893703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808191721, ExchCode = 'HAM' WHERE SecCode = 6902193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187105161, Ticker = 'ST4Rd', ExchCode = 'BCO' WHERE SecCode = 6902754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188946903, ExchCode = 'SIU' WHERE SecCode = 6902755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186163208, ExchCode = 'DEU' WHERE SecCode = 6917381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808584207, ExchCode = 'GTX' WHERE SecCode = 6917382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186460513, ExchCode = 'DEU' WHERE SecCode = 6917417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186459587, ExchCode = 'DEU' WHERE SecCode = 6917418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186465067, ExchCode = 'DEU' WHERE SecCode = 6917419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808893306, ExchCode = 'QTX' WHERE SecCode = 6923754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808844130, ExchCode = 'MUN' WHERE SecCode = 6923755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22193020541, ExchCode = 'QTX' WHERE SecCode = 6930689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808923463, ExchCode = 'FRA' WHERE SecCode = 6941647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22191670629, ExchCode = 'MUN' WHERE SecCode = 6955204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22191108809, ExchCode = 'DUS' WHERE SecCode = 6955205 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809271129, ExchCode = 'BIV' WHERE SecCode = 6960515 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809517593, Ticker = '1LIME' WHERE SecCode = 6969125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809527309, ExchCode = 'FRA' WHERE SecCode = 6969185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809511918, ExchCode = 'BIV' WHERE SecCode = 6974573 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809727275, ExchCode = 'QTX' WHERE SecCode = 6982407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809732421, ExchCode = 'GTX' WHERE SecCode = 6982411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22192709006, ExchCode = 'DEU' WHERE SecCode = 6982412 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809845005, ExchCode = 'TDG' WHERE SecCode = 6986008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809845566, ExchCode = 'MEX' WHERE SecCode = 6986009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236810391927, ExchCode = 'BIV' WHERE SecCode = 7003908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812095404, ExchCode = 'QTX' WHERE SecCode = 7044310 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 7064203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812869056, ExchCode = 'FRA' WHERE SecCode = 7067560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812881081, ExchCode = 'MEX' WHERE SecCode = 7067561 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000381669, PriTRBCIndPermID = NULL WHERE SecCode = 7092745 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-23', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 7093152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22205374122, ExchCode = 'DEU' WHERE SecCode = 7098798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803099510, ExchCode = 'BIV' WHERE SecCode = 7101284 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 7107673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22206810104, ExchCode = 'STU' WHERE SecCode = 7107756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22206809832, ExchCode = 'DEU' WHERE SecCode = 7107760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21635390047, Ticker = '544937', ExchCode = 'BSE', PermOrgIPODate = '2026-09-24' WHERE SecCode = 7116171 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7116202 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7116203 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7116204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236814953971, ExchCode = 'FRA' WHERE SecCode = 7118725 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7118727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236814954110, ExchCode = 'FRA' WHERE SecCode = 7118747 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000400350, PriTRBCIndPermID = NULL, PermSecMapEndDate = '2026-09-23' WHERE SecCode = 10775188 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000276271 WHERE SecCode = 10898338 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000380127, DomCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2013-08-12' WHERE SecCode = 10968580 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'GRHK.X' WHERE SecCode = 11028598 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 11114106 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, DomCntry = 'USA', PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 11133654 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-09-23' WHERE SecCode = 11155739 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11156594 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11168246 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11171985 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'HUCK' WHERE SecCode = 11186618 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000187321, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 11189358 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232924351123.0, PermOrgIPODate = '2026-09-22' WHERE SecCode = 11195616 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000187321, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 11196046 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2019-12-06' WHERE SecCode = 11203049 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000381669, PriTRBCIndPermID = NULL WHERE SecCode = 11215942 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'GCRFF' WHERE SecCode = 11218243 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-23', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 11223225 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'UNK' WHERE SecCode = 11226945 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2021-08-13' WHERE SecCode = 11228666 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'UNK' WHERE SecCode = 11229735 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'VSEED' WHERE SecCode = 11236479 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236799613258, ExchCode = 'PSE' WHERE SecCode = 11241835 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-24' WHERE SecCode = 11243205 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11274084 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11274782 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5081494788, DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951176.0, PermOrgIPODate = '2026-09-22' WHERE SecCode = 11275439 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5081494788, DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951176.0, PermOrgIPODate = '2026-09-22' WHERE SecCode = 11277492 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-23', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 11285502 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-23' WHERE SecCode = 11285677 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285732 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285752 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285756 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232955557632.0 WHERE SecCode = 11300443 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5073989690, PriInstrPermID = 232942706497.0, IsPrimaryInstr = 0, DomCntry = 'CHN', IncCntry = 'CYM', PriTRBCIndPermID = 1004365444.0, PermOrgIPODate = '2026-07-08' WHERE SecCode = 11300608 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-23', PermSecMapEndDate = '2026-09-23' WHERE SecCode = 11301083 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096802040, PriTRBCIndPermID = NULL, PermOrgIPODate = '2026-09-18' WHERE SecCode = 11301893 AND Type_ = 1;