UPDATE data_universe_permid SET QuotePermID = 55836050580, Ticker = 'IBM', ExchCode = 'LSE', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 479 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 7392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531136784, Ticker = 'ZHEHl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-08-29' WHERE SecCode = 9121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629381057, Ticker = '0Q1N', ExchCode = 'LSE' WHERE SecCode = 9338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475530716, Ticker = 'OAK', ExchCode = 'VTX', PermQuoteRetireDate = '2006-09-21' WHERE SecCode = 9856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475556855, Ticker = '31QX', ExchCode = 'LSE', PermQuoteRetireDate = '2008-04-25' WHERE SecCode = 9908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634297975, Ticker = '0KXAl', ExchCode = 'BCO' WHERE SecCode = 10268 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 10876 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 23750 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21742935323, Ticker = 'SKMDl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 27054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'PER' WHERE SecCode = 28346 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 28897 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 29065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390497, Ticker = 'EO5d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 35852 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 36902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475586089, PermQuoteStatus = 'DC', Ticker = 'CPAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475622710, PermQuoteStatus = 'DC', Ticker = 'DSEG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 38247 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 39205 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-06' WHERE SecCode = 39762 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'AIMN' WHERE SecCode = 41666 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 42032 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 43960 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 45727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474867436, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 45854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474913868, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853561637, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 45959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838502175, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 46907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 53991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489108, ExchCode = 'QTX' WHERE SecCode = 55696 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 57720 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 58831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492066, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-07' WHERE SecCode = 59963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324566, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475030486, ExchCode = 'FRA' WHERE SecCode = 60596 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 60862 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 60863 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 60864 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 60865 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 61624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 63858 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 64983 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 65087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390498, Ticker = 'EWLd', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 65541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341282, ExchCode = 'BER' WHERE SecCode = 65548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474862261, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 65643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525212599, ExchCode = 'DEU', PermQuoteRetireDate = '2020-03-20' WHERE SecCode = 65700 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PAK' WHERE SecCode = 67045 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 69231 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PAK' WHERE SecCode = 69349 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 74741 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 75052 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 75203 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SERDB', PermSecMapEndDate = '2026-04-06' WHERE SecCode = 78043 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'GNZ', QuoteClass = 'STAPLED', InstrClass = 'STAPLED' WHERE SecCode = 78081 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-06' WHERE SecCode = 81073 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 82549 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 83532 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 84040 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'PER' WHERE SecCode = 84070 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-06' WHERE SecCode = 87218 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 89094 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 91216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838815430, PriTrdQuotePermID = NULL, ValQuotePermID = 55838815430.0, Ticker = 'EFR', ExchCode = 'TOR', DomCntry = 'CAN', PermSecMapStartDate = '2001-07-07' WHERE SecCode = 93601 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 94218 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU' WHERE SecCode = 100032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667490953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-20' WHERE SecCode = 100052 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 101286 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609211565, ExchCode = 'TDG' WHERE SecCode = 103792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10; UPDATE data_universe_permid SET QuoteClass = 'STAPLED', InstrClass = 'STAPLED' WHERE SecCode = 112091 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 113835 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 127427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836321105, ExchCode = 'BER' WHERE SecCode = 129176 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887741955, ExchCode = 'GTX' WHERE SecCode = 129179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390492, Ticker = 'DC4d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 133246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475137348, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 133291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390499, Ticker = 'E3X1d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 139179 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 139219 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777652457, ExchCode = 'FRA' WHERE SecCode = 140677 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 141886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390489, Ticker = 'D2MNd', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 144767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569877, ExchCode = 'QTX' WHERE SecCode = 144797 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 146979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 177695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528679753, ExchCode = 'GER' WHERE SecCode = 178849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390501, Ticker = 'F3Ad', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 179549 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 55838815430.0, DomCntry = 'CAN' WHERE SecCode = 180255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 180684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838736391, Ticker = 'VLG', ExchCode = 'MCE', PermQuoteRetireDate = '2013-08-09' WHERE SecCode = 182166 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'PER' WHERE SecCode = 194187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835455673, Ticker = 'SOYBP', ExchCode = 'PAR', PermQuoteRetireDate = '2013-05-08' WHERE SecCode = 202732 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 248728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836386191, ExchCode = 'FRA' WHERE SecCode = 249361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563176056, ExchCode = 'STU' WHERE SecCode = 249364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390487, Ticker = 'DO2d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 249723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390500, Ticker = 'EQ6d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 249766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475127463, ExchCode = 'FRA' WHERE SecCode = 249782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21516948702, ExchCode = 'STU' WHERE SecCode = 249787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22052572098, ExchCode = 'DEU' WHERE SecCode = 249797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532691717, ExchCode = 'FRA' WHERE SecCode = 249801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538241626, ExchCode = 'DEU', PermQuoteRetireDate = '2016-01-05' WHERE SecCode = 249805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860308852, ExchCode = 'GTX' WHERE SecCode = 249812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530311, ExchCode = 'DEU' WHERE SecCode = 249816 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-05' WHERE SecCode = 255791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390488, Ticker = 'A58d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 261168 AND Type_ = 10; UPDATE data_universe_permid SET ExchCode = 'TOR' WHERE SecCode = 294232 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 295869 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 316452 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 324270 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 330105 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 334331 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 337126 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836348908, ExchCode = 'FRA' WHERE SecCode = 353324 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 353517 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 384508 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 411806 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 414984 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 417425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 519353 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 520277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805390491, Ticker = '7DGd', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 554690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520392600, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 556230 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 627565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22002746026, Ticker = 'XBEC', ExchCode = 'SWX' WHERE SecCode = 737768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 775711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287353, ExchCode = 'BIV' WHERE SecCode = 780513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475065654, ExchCode = 'FRA', PermQuoteRetireDate = '2012-10-24' WHERE SecCode = 782787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 838831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55866710248, PermQuoteStatus = 'AC', Ticker = 'XAD6', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 848018 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 869499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596702, ExchCode = 'FRA' WHERE SecCode = 878880 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 = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 894183 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545813177, ExchCode = 'FRA' WHERE SecCode = 931181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801717079, Ticker = 'CBBFFz', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 933460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838301302, Ticker = 'MBTGV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2013-02-22' WHERE SecCode = 961652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475769668, Ticker = 'TYM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 995830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804482265, ExchCode = 'MUN' WHERE SecCode = 1072550 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'PER' WHERE SecCode = 1104434 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521581557, ExchCode = 'FRA' WHERE SecCode = 1122776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 1204766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850366387, ExchCode = 'BER', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 1265152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583580938, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-16', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1455200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477469688, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-01' WHERE SecCode = 1457731 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558280851, ExchCode = 'CHI', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 1472753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21481623767, ExchCode = 'DEU' WHERE SecCode = 1482803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535950893, ExchCode = 'STU' WHERE SecCode = 1485685 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385946, ExchCode = 'LAS' WHERE SecCode = 1485688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55886089498, Ticker = 'SLHO', ExchCode = 'MIL', PermQuoteRetireDate = '2019-09-17' WHERE SecCode = 1503000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954642014, ExchCode = 'QTX' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857143091, ExchCode = 'DUS' WHERE SecCode = 1524543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536289597, ExchCode = 'FRA' WHERE SecCode = 1524628 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522741571, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-17' WHERE SecCode = 1527439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21489920274, ExchCode = 'FRA', PermQuoteRetireDate = '2012-08-22' WHERE SecCode = 1527466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21490773939, ExchCode = 'DEU' WHERE SecCode = 1529275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655926838, ExchCode = 'FRA' WHERE SecCode = 1534251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492895638, ExchCode = 'DEU', PermQuoteRetireDate = '2014-04-08' WHERE SecCode = 1537137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667493420, ExchCode = 'QTX' WHERE SecCode = 1538642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766661889, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1538644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494270024, ExchCode = 'DEU' WHERE SecCode = 1541369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478425, ExchCode = 'QTX', PermQuoteRetireDate = '2021-01-22' WHERE SecCode = 1552391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498532317, ExchCode = 'FRA' WHERE SecCode = 1556381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639604213, ExchCode = 'MUN' WHERE SecCode = 1568506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632884533, ExchCode = 'MUN' WHERE SecCode = 1571251 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 = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515927789, ExchCode = 'DEU' WHERE SecCode = 1601542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331619, Ticker = 'KJ7A', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1623980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' WHERE SecCode = 1655572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21504836182, Ticker = 'CHMT', ExchCode = 'PAR', PermQuoteRetireDate = '2017-04-25' WHERE SecCode = 1677246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 1699181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685426483, ExchCode = 'MUN' WHERE SecCode = 1707747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641955269, ExchCode = 'FRA' WHERE SecCode = 1707749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' WHERE SecCode = 1713829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1722300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22072144473, ExchCode = 'DEU' WHERE SecCode = 2042837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815142016, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2072760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779912896, ExchCode = 'STU' WHERE SecCode = 2222037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524108941, ExchCode = 'STU' WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525929139, ExchCode = 'FRA' WHERE SecCode = 2288360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515724218, ExchCode = 'BER', PermQuoteRetireDate = '2021-06-04' WHERE SecCode = 2289254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527854599, ExchCode = 'FRA' WHERE SecCode = 2326807 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21686715439, Ticker = 'CECD', ExchCode = 'LSE', PermQuoteRetireDate = '2021-12-20' WHERE SecCode = 2350989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2370529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371665, ExchCode = 'SGO' WHERE SecCode = 2377498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679407, ExchCode = 'BIV' WHERE SecCode = 2407194 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756688641, ExchCode = 'MUN' WHERE SecCode = 2421101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517626184, ExchCode = 'MUN' WHERE SecCode = 2448345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431271, ExchCode = 'FRA' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542003679, ExchCode = 'STU' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543102507, ExchCode = 'FRA' WHERE SecCode = 2579445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430409, ExchCode = 'DEU' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782012516, ExchCode = 'DEU' WHERE SecCode = 2585381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545105789, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-22', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2604391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651407157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2622293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371263, ExchCode = 'BEC' WHERE SecCode = 2625122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 2642467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704172, ExchCode = 'MXQ' WHERE SecCode = 2644179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589641130, ExchCode = 'STU' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2682197 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2697132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804841423, ExchCode = 'HAM' WHERE SecCode = 2725364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667706109, Ticker = 'WFTN', ExchCode = 'MXQ' WHERE SecCode = 2767178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704388, ExchCode = 'MXQ' WHERE SecCode = 2767208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479008, ExchCode = 'QTX' WHERE SecCode = 2807599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830289547, Ticker = '8PSG', ExchCode = 'GTX' WHERE SecCode = 2846585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478711, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2867587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531671070, ExchCode = 'AUX' WHERE SecCode = 2887121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479042, ExchCode = 'QTX' WHERE SecCode = 2905610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779690645, ExchCode = 'AQX' WHERE SecCode = 2906408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731661976, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2907244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478659, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2909243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731165568, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-04' WHERE SecCode = 3001106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3046332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585828975, Ticker = 'RYAA', ExchCode = 'STU', PermQuoteRetireDate = '2023-12-08' WHERE SecCode = 3072584 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460750, Ticker = 'OD7I', ExchCode = 'FRA' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582352174, ExchCode = 'FRA' WHERE SecCode = 3085564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787344, Ticker = '42P', ExchCode = 'DUS', PermQuoteRetireDate = '2021-03-16' WHERE SecCode = 3096965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953916121, ExchCode = 'GTX' WHERE SecCode = 3124235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320061, ExchCode = 'DEU' WHERE SecCode = 3124241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587931877, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599860501, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3169823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705812, Ticker = 'TLRDQ*', ExchCode = 'MXQ' WHERE SecCode = 3177778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798143359, ExchCode = 'FRA' WHERE SecCode = 3186751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU' WHERE SecCode = 3198718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388055, ExchCode = 'LAS' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962344738, Ticker = '1VOW3m', ExchCode = 'BTE' WHERE SecCode = 3212165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591801382, ExchCode = 'BER' WHERE SecCode = 3212190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801449069, ExchCode = 'DEU' WHERE SecCode = 3213266 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789234589, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3223076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747575641, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3233933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21683901733, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-11' WHERE SecCode = 3241570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788491422, Ticker = '0EFd', ExchCode = 'BCO' WHERE SecCode = 3246454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824694891, ExchCode = 'DUS' WHERE SecCode = 3247179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591485238, Ticker = '1CBK', ExchCode = 'MIL' WHERE SecCode = 3247531 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799025630, ExchCode = 'MUN', PermQuoteRetireDate = '2024-08-14', PermSecMapEndDate = NULL WHERE SecCode = 3260030 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 = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3277251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21603342349, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3283956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632738581, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-27' WHERE SecCode = 3297215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797988618, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-29' WHERE SecCode = 3309705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786651644, ExchCode = 'QTX' WHERE SecCode = 3317115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611220164, ExchCode = 'TDG' WHERE SecCode = 3317384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380068, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830286060, ExchCode = 'GTX' WHERE SecCode = 3320207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644443154, ExchCode = 'DEU' WHERE SecCode = 3320334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297854, ExchCode = 'DUS' WHERE SecCode = 3327824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793910667, ExchCode = 'QTX' WHERE SecCode = 3337223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773002549, ExchCode = 'FRA' WHERE SecCode = 3356351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22098742116, ExchCode = 'DXE' WHERE SecCode = 3359183 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704834, ExchCode = 'MXQ' WHERE SecCode = 3359195 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 3381924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727378638, ExchCode = 'BRN' WHERE SecCode = 3394011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575576966, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3394028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21637054002, ExchCode = 'BTE' WHERE SecCode = 3395249 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 3397168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21908261084, Ticker = '1FBm', ExchCode = 'EQD' WHERE SecCode = 3401441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704915, ExchCode = 'MXQ' WHERE SecCode = 3401905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469772, ExchCode = 'DEU' WHERE SecCode = 3401906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660711293, ExchCode = 'DEU' WHERE SecCode = 3403947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629355998, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-31', PermSecMapEndDate = '2024-08-30' WHERE SecCode = 3405438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624076661, ExchCode = 'BEC' WHERE SecCode = 3406544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797256368, ExchCode = 'QTX' WHERE SecCode = 3407867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800223463, ExchCode = 'LAS' WHERE SecCode = 3407871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801932291, ExchCode = 'FRA' WHERE SecCode = 3409373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801287178, Ticker = 'C0B', ExchCode = 'STU' WHERE SecCode = 3410283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100439, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 3429810 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'PER' WHERE SecCode = 3431594 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 55838815430.0, DomCntry = 'CAN' WHERE SecCode = 3432032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634766459, ExchCode = 'DEU' WHERE SecCode = 3432164 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 3432326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651603021, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-26' WHERE SecCode = 3434582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636066861, ExchCode = 'DEU' WHERE SecCode = 3435060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727356606, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2020-04-21' WHERE SecCode = 3435592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997874, ExchCode = 'DEU' WHERE SecCode = 3439465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793644583, ExchCode = 'TDG' WHERE SecCode = 3439533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643680223, ExchCode = 'BER' WHERE SecCode = 3439542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644011375, ExchCode = 'DEU' WHERE SecCode = 3445093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643807094, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782181250, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947481, ExchCode = 'FRA' WHERE SecCode = 3526199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789434494, ExchCode = 'LAS' WHERE SecCode = 3532734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653848411, Ticker = 'TGL', ExchCode = 'LSE', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3536053 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21994180608, ExchCode = 'BTE' WHERE SecCode = 3547843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953637183, ExchCode = 'STU' WHERE SecCode = 3549499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663166796, ExchCode = 'FRA' WHERE SecCode = 3550423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710951296, ExchCode = 'BTE' WHERE SecCode = 3550579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485132, Ticker = 'FT5', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 3562840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475624891, Ticker = 'CSC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 3586971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752247684, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 3588035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731983529, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3615233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759798879, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3615235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789515091, ExchCode = 'QTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 3623818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668783322, ExchCode = 'HAN' WHERE SecCode = 3642406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670450813, ExchCode = 'DEU' WHERE SecCode = 3657811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505131, ExchCode = 'MUN' WHERE SecCode = 3658775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681872326, ExchCode = 'DEU' WHERE SecCode = 3754712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21687635991, ExchCode = 'TDG' WHERE SecCode = 3793375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744453885, ExchCode = 'DEU' WHERE SecCode = 3809052 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383302, ExchCode = 'MEX' WHERE SecCode = 3809094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690462879, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3812238 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'G671' WHERE SecCode = 3818109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812350912, ExchCode = 'DEU' WHERE SecCode = 3863388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703900276, ExchCode = 'TDG' WHERE SecCode = 3898812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703664166, ExchCode = 'STU' WHERE SecCode = 3898813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711927625, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3955660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026962, Ticker = '1PM' WHERE SecCode = 4032067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 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 = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 4049121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727356458, ExchCode = 'MEX' WHERE SecCode = 4090018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738262837, Ticker = '5C8', ExchCode = 'FRA' WHERE SecCode = 4090028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799881746, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 4101126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976737, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951941315, Ticker = '49Y0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738226623, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4119578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727358595, ExchCode = 'MEX' WHERE SecCode = 4119581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778719260, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737966439, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4124713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858461751, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4124848 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789546043, ExchCode = 'STU' WHERE SecCode = 4139227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4139247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704289, ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789555719, ExchCode = 'QTX' WHERE SecCode = 4169152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746822092, ExchCode = 'STU' WHERE SecCode = 4201732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308365, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4204823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 4212367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727350455, ExchCode = 'MEX' WHERE SecCode = 4212368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026889, Ticker = '1HCA' WHERE SecCode = 4214370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026841, Ticker = '1NOW' WHERE SecCode = 4214371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026766, Ticker = '1AMT' WHERE SecCode = 4214372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026951, Ticker = '1AWK' WHERE SecCode = 4214377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026829, Ticker = '1GD' WHERE SecCode = 4214384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026900, Ticker = '1HLT' WHERE SecCode = 4214387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026939, Ticker = '1SPG' WHERE SecCode = 4214395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026966, Ticker = '1SYK' WHERE SecCode = 4214397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026844, Ticker = '1TROW' WHERE SecCode = 4214399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026809, Ticker = '1WEC' WHERE SecCode = 4214401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787665340, Ticker = '4APH', ExchCode = 'ETX' WHERE SecCode = 4214403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699193157, Ticker = 'BYND', ExchCode = 'SWX' WHERE SecCode = 4214409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600490, Ticker = '1PLUGm', ExchCode = 'BCO' WHERE SecCode = 4214415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349453, ExchCode = 'BIV' WHERE SecCode = 4228288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749843263, ExchCode = 'DEU' WHERE SecCode = 4228324 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750894848, ExchCode = 'FRA' WHERE SecCode = 4231470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388456, ExchCode = 'LAS' WHERE SecCode = 4248820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754200308, ExchCode = 'DEU' WHERE SecCode = 4253037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349640, ExchCode = 'MEX' WHERE SecCode = 4259231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757056950, ExchCode = 'DUS' WHERE SecCode = 4275166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487958, ExchCode = 'DUS' WHERE SecCode = 4278854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845530001, ExchCode = 'MUN' WHERE SecCode = 4282400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758727587, ExchCode = 'DUS' WHERE SecCode = 4288863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727356006, ExchCode = 'MEX' WHERE SecCode = 4291615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768111804, PermQuoteStatus = 'DC', Ticker = '9EG', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 4296979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761325018, Ticker = '4TKWY', ExchCode = 'ETX' WHERE SecCode = 4309036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026756, Ticker = '1NB' WHERE SecCode = 4309038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761324941, Ticker = '4RMS', ExchCode = 'ETX' WHERE SecCode = 4309039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026860, Ticker = '18TRA' WHERE SecCode = 4309041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761324824, Ticker = '4ASM', ExchCode = 'ETX' WHERE SecCode = 4309043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027111, Ticker = '1OXY' WHERE SecCode = 4309046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026929, Ticker = '1DOW' WHERE SecCode = 4309048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761647098, ExchCode = 'DUS' WHERE SecCode = 4309050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709367298, ExchCode = 'MXQ' WHERE SecCode = 4324371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727341343, ExchCode = 'MEX' WHERE SecCode = 4324380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4355007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770221779, ExchCode = 'FRA' WHERE SecCode = 4360099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773606711, ExchCode = 'FRA' WHERE SecCode = 4375237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781510749, ExchCode = 'DUS' WHERE SecCode = 4375238 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777644859, ExchCode = 'STU' WHERE SecCode = 4379791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783391809, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4380746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21826522500, ExchCode = 'QTX' WHERE SecCode = 4395464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307225, ExchCode = 'MEX' WHERE SecCode = 4426954 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782653687, ExchCode = 'MUN' WHERE SecCode = 4426955 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026948, Ticker = '1VTRS' WHERE SecCode = 4427826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779047769, ExchCode = 'TDG', PermQuoteRetireDate = '2024-03-01', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 4427929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991601, ExchCode = 'FRA' WHERE SecCode = 4429683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740545, ExchCode = 'LAS' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854730428, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-31', PermSecMapEndDate = NULL WHERE SecCode = 4449703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299967, ExchCode = 'MEX' WHERE SecCode = 4449704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790713764, ExchCode = 'STU' WHERE SecCode = 4458936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789562275, ExchCode = 'FRA' WHERE SecCode = 4458938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793689536, ExchCode = 'DEU' WHERE SecCode = 4463152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795956950, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793532320, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4470175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798225679, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-12', PermSecMapEndDate = '2025-02-12' WHERE SecCode = 4470353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796647312, ExchCode = 'STU' WHERE SecCode = 4472909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396601, ExchCode = 'FRA' WHERE SecCode = 4472926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727293388, PermQuoteStatus = 'AC', Ticker = 'MKR', ExchCode = 'JNB', PermQuoteRetireDate = NULL WHERE SecCode = 4477796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367255, ExchCode = 'DEU' WHERE SecCode = 4482517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555797, ExchCode = 'DEU' WHERE SecCode = 4496736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799006296, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4502468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287359, ExchCode = 'MEX' WHERE SecCode = 4505578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852456562, ExchCode = 'BRN' WHERE SecCode = 4506359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782181247, ExchCode = 'DUS' WHERE SecCode = 4517645 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 4521310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851345226, ExchCode = 'MUN' WHERE SecCode = 4526144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809121292, Ticker = '0RW', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-22' WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804817015, ExchCode = 'STU' WHERE SecCode = 4536450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301437, ExchCode = 'BIV' WHERE SecCode = 4547978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808950973, ExchCode = 'FRA' WHERE SecCode = 4568423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 4580740 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801723130, ExchCode = 'DEU' WHERE SecCode = 4593211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305820, ExchCode = 'BIV' WHERE SecCode = 4597223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138517605, ExchCode = 'CHI' WHERE SecCode = 4609997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818133763, ExchCode = 'DEU' WHERE SecCode = 4616836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818264918, ExchCode = 'FRA' WHERE SecCode = 4617743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820583662, ExchCode = 'STU', PermQuoteRetireDate = '2023-01-19' WHERE SecCode = 4625012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821283441, ExchCode = 'DEU' WHERE SecCode = 4630664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821849497, ExchCode = 'FRA' WHERE SecCode = 4633101 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5083586586, PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 4634350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822364738, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4634352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4637752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727284452, ExchCode = 'BIV' WHERE SecCode = 4657617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388763, ExchCode = 'LAS' WHERE SecCode = 4675215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244578, ExchCode = 'BIV' WHERE SecCode = 4684128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388765, ExchCode = 'LAS' WHERE SecCode = 4689999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244579, ExchCode = 'MEX' WHERE SecCode = 4695806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011348, Ticker = '2STX' WHERE SecCode = 4699232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842933521, ExchCode = 'FRA' WHERE SecCode = 4716089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842933962, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4716090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933381561, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097356, ExchCode = 'LAS' WHERE SecCode = 4720520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843597790, ExchCode = 'FRA' WHERE SecCode = 4722188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878863894, Ticker = 'VDOUz', ExchCode = 'BCO' WHERE SecCode = 4724692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954884, ExchCode = 'LAS' WHERE SecCode = 4726104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782726100, ExchCode = 'STU' WHERE SecCode = 4726105 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845567127, ExchCode = 'MUN', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850866652, ExchCode = 'TDG' WHERE SecCode = 4733055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439517, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-05-26' WHERE SecCode = 4748503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850719955, ExchCode = 'FRA' WHERE SecCode = 4748506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' WHERE SecCode = 4754869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852735329, ExchCode = 'FRA' WHERE SecCode = 4756369 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 4757848 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932244742, ExchCode = 'BCO' WHERE SecCode = 4761550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854742239, ExchCode = 'FRA' WHERE SecCode = 4761587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867733, ExchCode = 'FRA' WHERE SecCode = 4762975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307219, ExchCode = 'BIV' WHERE SecCode = 4768117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018892, ExchCode = 'STU' WHERE SecCode = 4773770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856722496, ExchCode = 'MUN' WHERE SecCode = 4775201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860831312, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4800552 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860615834, ExchCode = 'MUN' WHERE SecCode = 4800673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782645958, ExchCode = 'BER' WHERE SecCode = 4804834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907559014, ExchCode = 'MUN', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 4811141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886808179, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 4811144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860859987, ExchCode = 'FRA' WHERE SecCode = 4813526 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772241331, ExchCode = 'FRA' WHERE SecCode = 4815315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947043272, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4819881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777156627, ExchCode = 'MUN' WHERE SecCode = 4827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888021696, ExchCode = 'GTX' WHERE SecCode = 4846846 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 4846849 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'O8I' WHERE SecCode = 4848925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'PER' WHERE SecCode = 4854739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22144452987, ExchCode = 'LAS' WHERE SecCode = 4854867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871894898, ExchCode = 'DEU' WHERE SecCode = 4868662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872586858, ExchCode = 'DEU' WHERE SecCode = 4873679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929410708, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874656927, ExchCode = 'FRA' WHERE SecCode = 4889264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954949, ExchCode = 'LAS' WHERE SecCode = 4907129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882166752, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727210597, ExchCode = 'BIV' WHERE SecCode = 4938350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471210, ExchCode = 'TDG' WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884081519, PermQuoteStatus = 'AC', Ticker = 'K9N', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4949680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886412706, ExchCode = 'FRA' WHERE SecCode = 4965055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888036745, ExchCode = 'MUN' WHERE SecCode = 4969368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782629907, ExchCode = 'QTX' WHERE SecCode = 4969375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886193164, ExchCode = 'FRA' WHERE SecCode = 4969376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887686666, Ticker = 'WATT', ExchCode = 'MIL' WHERE SecCode = 4969407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887686217, Ticker = 'WENT', ExchCode = 'MIL' WHERE SecCode = 4969408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22066264784, ExchCode = 'CHI' WHERE SecCode = 4969409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823905, ExchCode = 'AQX' WHERE SecCode = 5038689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976743, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5042969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788890733, ExchCode = 'QTX' WHERE SecCode = 5047099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238786, ExchCode = 'LAS' WHERE SecCode = 5067500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729398003, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-31' WHERE SecCode = 5099028 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000083106, PriInstrPermID = NULL, DomCntry = NULL, IncCntry = 'USA', PermOrgIPODate = NULL WHERE SecCode = 5101460 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000083106, PriInstrPermID = NULL, DomCntry = NULL, IncCntry = 'USA', PermOrgIPODate = NULL WHERE SecCode = 5104592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026880, Ticker = '1KDP' WHERE SecCode = 5107765 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 5114180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913101536, ExchCode = 'QTX' WHERE SecCode = 5129748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915977241, ExchCode = 'DEU' WHERE SecCode = 5140247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727380482, Ticker = 'NAQ', ExchCode = 'BRN' WHERE SecCode = 5144089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21942737484, ExchCode = 'STU' WHERE SecCode = 5151167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430452, ExchCode = 'DEU' WHERE SecCode = 5153444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758567887, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793473649, ExchCode = 'BTE' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348309, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197642, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650379, ExchCode = 'QTX' WHERE SecCode = 5166812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954812, ExchCode = 'LAS' WHERE SecCode = 5166813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943651732, ExchCode = 'STU' WHERE SecCode = 5174473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932177240, ExchCode = 'MUN' WHERE SecCode = 5183106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953345, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904165, ExchCode = 'BCO' WHERE SecCode = 5203369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 47733359571, ExchCode = 'FRA' WHERE SecCode = 5209761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783782321, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5230330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21930005423, ExchCode = 'FRA' WHERE SecCode = 5230331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780478262, PermQuoteStatus = 'DC', Ticker = 'VJ3', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5230332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794004180, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5239813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397466, PermQuoteStatus = 'DC', ExchCode = 'CHI', PermQuoteRetireDate = '2026-03-12' WHERE SecCode = 5269462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937069015, ExchCode = 'STU' WHERE SecCode = 5272089 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 5276202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537961037, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 5283651 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 5292660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386763, ExchCode = 'LAS' WHERE SecCode = 5292727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943068314, ExchCode = 'DEU' WHERE SecCode = 5301896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943095865, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5313552 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-04' WHERE SecCode = 5344695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952265408, ExchCode = 'DEU' WHERE SecCode = 5347429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957771304, ExchCode = 'FRA' WHERE SecCode = 5374832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783749193, ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 5374833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487235, ExchCode = 'FRA' WHERE SecCode = 5374858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544723, ExchCode = 'QTX' WHERE SecCode = 5381858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781520284, ExchCode = 'QTX' WHERE SecCode = 5381859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960776852, ExchCode = 'GTX' WHERE SecCode = 5381860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380714, ExchCode = 'LAS' WHERE SecCode = 5381861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954882409, ExchCode = 'MXQ' WHERE SecCode = 5381916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785535434, ExchCode = 'DUS' WHERE SecCode = 5383599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782758791, ExchCode = 'MUN' WHERE SecCode = 5393777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777874410, ExchCode = 'GTX' WHERE SecCode = 5413669 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5430768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921820703, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-17', PermSecMapEndDate = '2024-12-17' WHERE SecCode = 5434319 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5446098 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 DomCntry = 'USA' WHERE SecCode = 5454700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21974975685, ExchCode = 'FRA' WHERE SecCode = 5457304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21986193019, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5457305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348315, ExchCode = 'QTX' WHERE SecCode = 5466221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779165176, ExchCode = 'STU' WHERE SecCode = 5476926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437243, ExchCode = 'MEX' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778659888, ExchCode = 'BIV' WHERE SecCode = 5496143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932421406, PermQuoteStatus = 'AC', Ticker = '3LFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5496168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982260691, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5496242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982274729, Ticker = '3BAS', ExchCode = 'MIL' WHERE SecCode = 5496244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727277713, ExchCode = 'MEX' WHERE SecCode = 5503675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793528245, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'STU', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823945, ExchCode = 'AQE' WHERE SecCode = 5503780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663720, ExchCode = 'AQE' WHERE SecCode = 5503782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010091546, Ticker = 'BTCCHz', ExchCode = 'TQE' WHERE SecCode = 5509588 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-05' WHERE SecCode = 5513352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805096669, ExchCode = 'HAM' WHERE SecCode = 5527547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535820, ExchCode = 'BIV' WHERE SecCode = 5539536 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782890677, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 5550739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21828704528, Ticker = 'FANG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5569236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917830166, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5569303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360205, ExchCode = 'BIV' WHERE SecCode = 5581641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22004617984, ExchCode = 'DEU' WHERE SecCode = 5607542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727210608, ExchCode = 'MEX' WHERE SecCode = 5629067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942898, ExchCode = 'MEX' WHERE SecCode = 5631516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780880115, ExchCode = 'HAM', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 5633493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781095333, ExchCode = 'STU' WHERE SecCode = 5633895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904157, Ticker = 'LCO3l', ExchCode = 'BCO' WHERE SecCode = 5638747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954864, ExchCode = 'LAS' WHERE SecCode = 5655040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 5657394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223838, ExchCode = 'QTX' WHERE SecCode = 5663968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028649127, ExchCode = 'DEU' WHERE SecCode = 5722406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028890988, ExchCode = 'DEU' WHERE SecCode = 5724940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097265, ExchCode = 'LAS' WHERE SecCode = 5745665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937290998, ExchCode = 'DEU' WHERE SecCode = 5749952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419156, ExchCode = 'LAS' WHERE SecCode = 5749956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22034763502, ExchCode = 'DEU' WHERE SecCode = 5764130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154585726, ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802153233, Ticker = 'RZ8Bd', ExchCode = 'BCO' WHERE SecCode = 5782810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5827321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21967216830, Ticker = 'CO3S', ExchCode = 'LSE' WHERE SecCode = 5839249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600489, ExchCode = 'STU' WHERE SecCode = 5839460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22046913642, ExchCode = 'DEU' WHERE SecCode = 5839461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804089043, ExchCode = 'QTX' WHERE SecCode = 5853173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22054245159, ExchCode = 'DEU' WHERE SecCode = 5888374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801352002, ExchCode = 'GTX' WHERE SecCode = 5894957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22086035577, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5897569 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802025933, ExchCode = 'LAS' WHERE SecCode = 5907872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784888214, ExchCode = 'BIV' WHERE SecCode = 5907884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788207224, ExchCode = 'FRA' WHERE SecCode = 6010807 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827614120, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380561, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 6097546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 6097549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22026330416, ExchCode = 'MXQ' WHERE SecCode = 6097558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354555, ExchCode = 'MEX' WHERE SecCode = 6097578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 6097580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791287038, ExchCode = 'FRA' WHERE SecCode = 6190705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791667911, ExchCode = 'MEX' WHERE SecCode = 6226138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792988748, ExchCode = 'MUN' WHERE SecCode = 6310651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787788319, ExchCode = 'MEX' WHERE SecCode = 6321016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793538068, ExchCode = 'TDG' WHERE SecCode = 6347432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793538657, ExchCode = 'FRA' WHERE SecCode = 6351557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823056707, ExchCode = 'STU' WHERE SecCode = 6364834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793789750, ExchCode = 'BIV' WHERE SecCode = 6366705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793828782, ExchCode = 'GTX' WHERE SecCode = 6366711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22118566912, ExchCode = 'DEU' WHERE SecCode = 6382149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792427653, ExchCode = 'LAS' WHERE SecCode = 6382150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794652101, ExchCode = 'DUS' WHERE SecCode = 6418488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799042091, ExchCode = 'FRA' WHERE SecCode = 6418489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22124484504, ExchCode = 'DEU' WHERE SecCode = 6431549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795182992, ExchCode = 'FRA' WHERE SecCode = 6443261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451435, ExchCode = 'CHI' WHERE SecCode = 6456368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142158030, ExchCode = 'CHI' WHERE SecCode = 6456369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154231077, ExchCode = 'BCO' WHERE SecCode = 6456371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142158021, ExchCode = 'CHI' WHERE SecCode = 6456372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141703201, ExchCode = 'CHI' WHERE SecCode = 6456373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451434, ExchCode = 'CHI' WHERE SecCode = 6456374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141447621, ExchCode = 'CHI' WHERE SecCode = 6456375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142158040, ExchCode = 'CHI' WHERE SecCode = 6456376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451424, ExchCode = 'CHI' WHERE SecCode = 6456377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141703193, ExchCode = 'CHI' WHERE SecCode = 6456420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128134015, ExchCode = 'DUS' WHERE SecCode = 6457998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796140986, ExchCode = 'MUN' WHERE SecCode = 6462849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136096482, ExchCode = 'MUN' WHERE SecCode = 6482759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22131851181, ExchCode = 'DEU' WHERE SecCode = 6482768 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IND' WHERE SecCode = 6507165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798269749, ExchCode = 'TDG' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138965870, ExchCode = 'MUN' WHERE SecCode = 6538893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6548134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798768097, ExchCode = 'DUS' WHERE SecCode = 6548155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142175791, ExchCode = 'DEU' WHERE SecCode = 6564772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141221366, ExchCode = 'DUS' WHERE SecCode = 6564781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142175888, ExchCode = 'DEU' WHERE SecCode = 6564784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142175677, ExchCode = 'DEU' WHERE SecCode = 6564786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799175964, ExchCode = 'FRA' WHERE SecCode = 6564787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143843399, ExchCode = 'DEU' WHERE SecCode = 6577960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-04' WHERE SecCode = 6590595 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800709239, ExchCode = 'QTX' WHERE SecCode = 6593801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800709234, ExchCode = 'QTX' WHERE SecCode = 6593803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145796714, ExchCode = 'DEU' WHERE SecCode = 6593805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800709233, ExchCode = 'QTX' WHERE SecCode = 6593806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238077, ExchCode = 'FRA' WHERE SecCode = 6593866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22147089246, ExchCode = 'DEU' WHERE SecCode = 6603604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22147089036, ExchCode = 'DEU' WHERE SecCode = 6603609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22147089281, ExchCode = 'DEU' WHERE SecCode = 6603626 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22147097785, ExchCode = 'DEU' WHERE SecCode = 6603628 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135607728, ExchCode = 'MUN' WHERE SecCode = 6617649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798361877, ExchCode = 'BIV' WHERE SecCode = 6625876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778200748, ExchCode = 'FRA' WHERE SecCode = 6626357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801541597, ExchCode = 'FRA' WHERE SecCode = 6627152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801541595, ExchCode = 'FRA' WHERE SecCode = 6627153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801541760, ExchCode = 'FRA' WHERE SecCode = 6627155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451421, ExchCode = 'CHI' WHERE SecCode = 6627463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22155220901, ExchCode = 'DEU' WHERE SecCode = 6629415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471032, ExchCode = 'FRA' WHERE SecCode = 6638341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 55838815430.0, DomCntry = 'CAN' WHERE SecCode = 6654715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798361886, ExchCode = 'BIV' WHERE SecCode = 6661586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165018416, ExchCode = 'DUS' WHERE SecCode = 6710093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804168964, ExchCode = 'FRA' WHERE SecCode = 6712364 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-06' WHERE SecCode = 6712641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239275, ExchCode = 'FRA' WHERE SecCode = 6716121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239931, ExchCode = 'FRA' WHERE SecCode = 6716122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239929, ExchCode = 'FRA' WHERE SecCode = 6716123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239978, ExchCode = 'FRA' WHERE SecCode = 6716124 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239905, ExchCode = 'FRA' WHERE SecCode = 6716125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239927, ExchCode = 'FRA' WHERE SecCode = 6716126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804239906, ExchCode = 'FRA' WHERE SecCode = 6716128 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 6719138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382055, ExchCode = 'LAS', OrgTypeCode = 'COM' WHERE SecCode = 6724297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804440807, ExchCode = 'QTX' WHERE SecCode = 6724318 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 PermSecMapEndDate = '2026-04-05' WHERE SecCode = 6728348 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-05' WHERE SecCode = 6731958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798106354, Ticker = '544735', ExchCode = 'BSE' WHERE SecCode = 6737814 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169227730, ExchCode = 'DEU' WHERE SecCode = 6748858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169220474, ExchCode = 'DEU' WHERE SecCode = 6748859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169220104, ExchCode = 'DEU' WHERE SecCode = 6748860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169220415, ExchCode = 'DEU' WHERE SecCode = 6748861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169227146, ExchCode = 'DEU' WHERE SecCode = 6748862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169220240, ExchCode = 'DEU' WHERE SecCode = 6748866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804838547, ExchCode = 'BIV' WHERE SecCode = 6748872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805095337, ExchCode = 'QTX' WHERE SecCode = 6753078 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10959780 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 11002306 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11036853 AND Type_ = 1; UPDATE data_universe_permid SET QuoteClass = 'STAPLED', InstrClass = 'STAPLED' WHERE SecCode = 11053619 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11108466 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11142289 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11147281 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11159510 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 11177059 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11182608 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-04' WHERE SecCode = 11198774 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11204469 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'DCOM PR', ExchCode = 'NYS' WHERE SecCode = 11204719 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727347685, PermQuoteStatus = 'AC', Ticker = 'QHUOY', ExchCode = 'PNK', PermQuoteRetireDate = NULL WHERE SecCode = 11209704 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11215761 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5083586586, PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 11226194 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727224453, PermQuoteStatus = 'AC', Ticker = 'SBDS', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = '2021-10-26' WHERE SecCode = 11232870 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 11233600 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11239161 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11239308 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 11245955 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11250809 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11263768 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11263871 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11263872 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11263873 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11276395 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11277167 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11286392 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11286456 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11286461 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11290230 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11290277 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11290367 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-06' WHERE SecCode = 11290370 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290393 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290394 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290396 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290401 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290402 AND Type_ = 1;