UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531125576, PermQuoteStatus = 'DC', Ticker = 'CTAl', ExchCode = 'BCO', PermQuoteRetireDate = '2018-08-22' WHERE SecCode = 2447 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SLEC' WHERE SecCode = 7151 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 10938 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 12484 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 23211 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 30005 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 30013 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30213 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30235 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 31792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 33326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837358466, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 37378 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 PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 38644 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 38645 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 44329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 49854 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 53497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475589629, Ticker = NULL, ExchCode = 'HAM', PermQuoteRetireDate = '2006-05-17' WHERE SecCode = 53991 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 54469 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951418.0, PermOrgIPODate = NULL WHERE SecCode = 54593 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 55789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816288234, ExchCode = 'DEU' WHERE SecCode = 56992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512066065, Ticker = 'AIV', ExchCode = 'TDG' WHERE SecCode = 57101 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 58466 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 58755 AND Type_ = 1; 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 = 236779790766, ExchCode = 'GTX' WHERE SecCode = 60683 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'GLTH' WHERE SecCode = 61432 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 61599 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 = 21475607241, PermQuoteStatus = 'DC', Ticker = 'AKDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 62376 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 QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 62781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838450820, ExchCode = 'STU', PermQuoteRetireDate = '2014-02-11' WHERE SecCode = 65966 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SGMOQ' WHERE SecCode = 68111 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 69064 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 69402 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 69638 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 76880 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 78159 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 78460 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BXNDA' WHERE SecCode = 78713 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 79087 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WNBD' WHERE SecCode = 82248 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 82584 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 82957 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 85031 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-23' WHERE SecCode = 85815 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 86898 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 89948 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 92482 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 93731 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 95877 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 96476 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000133454, PriInstrPermID = 8590028042.0, PermOrgIPODate = NULL WHERE SecCode = 97949 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100279 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100294 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100299 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100330 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100336 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100771 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 105593 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 113724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179548619, ExchCode = 'DEU' WHERE SecCode = 119132 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CHE' WHERE SecCode = 120473 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 128028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682712570, ExchCode = 'STU', PermQuoteRetireDate = '2022-04-05' WHERE SecCode = 128755 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'TERA' WHERE SecCode = 131838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478753829, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 132785 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474851270, ExchCode = 'DEU' WHERE SecCode = 132787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610036121, PermQuoteStatus = 'DC', Ticker = 'UH4', ExchCode = 'TDG', PermQuoteRetireDate = '2019-03-18', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 132790 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475472969, ExchCode = 'MUN' WHERE SecCode = 132940 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 136156 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 137731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997854, ExchCode = 'DEU' WHERE SecCode = 138040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 139442 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0 WHERE SecCode = 140765 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 141774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528679617, ExchCode = 'DEU' WHERE SecCode = 144317 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629957951, ExchCode = 'TDG' WHERE SecCode = 144320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517582535, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-13' WHERE SecCode = 144377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804419087, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144392 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 144724 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 145059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632622184, Ticker = '0QZOl', ExchCode = 'BCO' WHERE SecCode = 145533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533743848, ExchCode = 'STU' WHERE SecCode = 145554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341949, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 145558 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 148058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 178376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566116516, ExchCode = 'STU' WHERE SecCode = 186400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536544263, ExchCode = 'DEU' WHERE SecCode = 186428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838540118, ExchCode = 'STU' WHERE SecCode = 186457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798383425, ExchCode = 'FRA' WHERE SecCode = 186462 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 190299 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 206733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 256687 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 288991 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 291973 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 295082 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-23' WHERE SecCode = 323572 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'JSFNF', PermQuoteRetireDate = NULL WHERE SecCode = 326286 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 331004 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 331348 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 331382 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 332099 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'ECHO' WHERE SecCode = 335216 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808828598, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-22', PermSecMapEndDate = NULL WHERE SecCode = 345099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802914565, ExchCode = 'FRA' WHERE SecCode = 345851 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 389373 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CONDES-OSA', PermQuoteRetireDate = '2026-07-21' WHERE SecCode = 433895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000133454, PriInstrPermID = 8590028042.0, PermOrgIPODate = NULL WHERE SecCode = 518549 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-22' WHERE SecCode = 522882 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 529977 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 545930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704213, Ticker = 'AKS*', ExchCode = 'MXQ' WHERE SecCode = 549537 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 556253 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 558540 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 562896 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '0LW1' WHERE SecCode = 611816 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 641265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 726370 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 774842 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 798142 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 968951 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1158940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1262441 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1287442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797408685, ExchCode = 'FRA' WHERE SecCode = 1425621 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 1459417 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 1480259 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CONDES-OSA', PermQuoteRetireDate = '2026-07-21' WHERE SecCode = 1495597 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BXNDA' WHERE SecCode = 1522818 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1549890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188725782, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-22', PermSecMapEndDate = NULL WHERE SecCode = 1553671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21499307444, Ticker = '5GQ', ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 1554222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21504025590, ExchCode = 'DEU', PermQuoteRetireDate = '2017-05-16' WHERE SecCode = 1587478 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1678431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514707492, ExchCode = 'DEU' WHERE SecCode = 1748432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' 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 = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518083315, ExchCode = 'FRA' WHERE SecCode = 2055361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517928782, ExchCode = 'DEU' WHERE SecCode = 2055381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' 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 = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430949, ExchCode = 'DEU' WHERE SecCode = 2213927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538154, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2221995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308485, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2222230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 2229176 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0 WHERE SecCode = 2229304 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0 WHERE SecCode = 2229305 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0 WHERE SecCode = 2229306 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750324218, ExchCode = 'DEU' WHERE SecCode = 2232877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523563646, ExchCode = 'DEU' WHERE SecCode = 2239343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2264287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524954693, ExchCode = 'FRA' WHERE SecCode = 2267521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539606835, ExchCode = 'DUS' WHERE SecCode = 2278227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967852, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2278243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 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 = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 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 = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371665, ExchCode = 'SGO' WHERE SecCode = 2377498 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2377953 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 = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679407, ExchCode = 'BIV' WHERE SecCode = 2407194 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 = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774613413, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2465278 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2469427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537960715, ExchCode = 'BER' WHERE SecCode = 2513070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431271, ExchCode = 'FRA' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792808948, ExchCode = 'FRA' WHERE SecCode = 2568912 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ALFER' WHERE SecCode = 2571188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542768595, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2573038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549840146, ExchCode = 'FRA' WHERE SecCode = 2649167 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', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 2696962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21553011650, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2718428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954950, InstrPermID = 8590932786, OrgPermID = 4295893865, ValQuotePermID = 55836043261.0, PriInstrPermID = 8590932786.0, PermQuoteStatus = 'AC', Ticker = 'FVQ1', ExchCode = 'LAS', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951361.0, PermQuoteRetireDate = NULL, PermOrgIPODate = '2000-12-06' WHERE SecCode = 2718429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552507986, Ticker = 'SRE', ExchCode = 'JNB' WHERE SecCode = 2718458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552464621, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2718461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21553012298, ExchCode = 'FRA' WHERE SecCode = 2718469 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554451923, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-14' WHERE SecCode = 2750984 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2782865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322234, Ticker = 'IDV1', ExchCode = 'FRA' WHERE SecCode = 2812145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322223, ExchCode = 'FRA' WHERE SecCode = 2812146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381707, ExchCode = 'LAS' WHERE SecCode = 2817416 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2836275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2866617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734475861, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 2873688 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 2881062 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615434084, Ticker = 'SX7EEz', ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2954425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21570455715, ExchCode = 'DEU' WHERE SecCode = 2963590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787393, ExchCode = 'DUS' WHERE SecCode = 2985309 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3015899 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CONDES-OSA', PermQuoteRetireDate = '2026-07-21' WHERE SecCode = 3017155 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-22' WHERE SecCode = 3062337 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 = 22124025589, ExchCode = 'DEU' WHERE SecCode = 3124127 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3183968 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3200923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828428, Ticker = '1HEN3m', ExchCode = 'BCO' WHERE SecCode = 3212157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21665887580, Ticker = '2ASML', ExchCode = 'MIL' WHERE SecCode = 3212161 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 PermOrgIPODate = NULL WHERE SecCode = 3259339 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3263898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396552, ExchCode = 'DEU' WHERE SecCode = 3283696 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3284006 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3285979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3297033 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606833203, ExchCode = 'DEU' WHERE SecCode = 3304184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610682901, Ticker = 'VEONa', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705691, Ticker = 'SMIN', ExchCode = 'MXQ' WHERE SecCode = 3327117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780007794, ExchCode = 'DUS' WHERE SecCode = 3337692 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 = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301079, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3378582 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951319.0 WHERE SecCode = 3380814 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3387586 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'TIT2' WHERE SecCode = 3395637 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 = 236800228480, ExchCode = 'FRA' WHERE SecCode = 3401911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380142, PermQuoteStatus = 'AC', Ticker = 'DV4', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3401914 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232935240329.0 WHERE SecCode = 3405230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 3408184 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 3408287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655828146, ExchCode = 'FRA' WHERE SecCode = 3409091 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3430952 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3431704 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 3432046 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 = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647430161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100414, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3491217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784910654, Ticker = 'NOKIAk', ExchCode = 'BCO' WHERE SecCode = 3504673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238718, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3553157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3615170 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21665885520, ExchCode = 'FRA' WHERE SecCode = 3619191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667202587, ExchCode = 'MUN' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 3703402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674386, ExchCode = 'BIV' WHERE SecCode = 3756608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678493, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3761051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684103049, ExchCode = 'FRA' WHERE SecCode = 3771411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 3851567 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3852663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21698786104, ExchCode = 'CHI', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 3856714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584837232, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 3919559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828441, Ticker = '1NEMXm', ExchCode = 'BCO' WHERE SecCode = 3932654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710752190, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07', PermSecMapEndDate = NULL WHERE SecCode = 3949028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363709, ExchCode = 'BIV' WHERE SecCode = 3966586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363706, ExchCode = 'BIV' WHERE SecCode = 3966587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714765661, ExchCode = 'STU' WHERE SecCode = 3972240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536122160, ExchCode = 'FRA' WHERE SecCode = 4030457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012741, Ticker = '2MS' WHERE SecCode = 4031717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828384, Ticker = '1OMVm', ExchCode = 'BCO' WHERE SecCode = 4031755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828404, Ticker = '1BODm', ExchCode = 'BCO' WHERE SecCode = 4031822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010479, Ticker = '2NDX' WHERE SecCode = 4031953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22069067178, Ticker = '2NXPI' WHERE SecCode = 4031960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999042587, Ticker = '2SHA', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 4031994 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013792, Ticker = '2SNAP' WHERE SecCode = 4032002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026960, Ticker = '1VAR' WHERE SecCode = 4032036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026965, Ticker = '1WAF' WHERE SecCode = 4032047 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 = 21822947768, Ticker = '4DSY', ExchCode = 'ETX' WHERE SecCode = 4032132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723633857, ExchCode = 'STU' WHERE SecCode = 4032148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723632161, ExchCode = 'DEU' WHERE SecCode = 4032154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766464069, ExchCode = 'FRA' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745304635, ExchCode = 'DEU' WHERE SecCode = 4195320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745628089, PermQuoteStatus = 'AC', Ticker = 'Z62', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4196898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958647, ExchCode = 'FRA' WHERE SecCode = 4209246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788611412, ExchCode = 'DEU' WHERE SecCode = 4209753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838963, ExchCode = 'FRA' WHERE SecCode = 4225217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750154407, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 4228115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534208, PermQuoteStatus = 'AC', Ticker = '0YL0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727345444, ExchCode = 'MEX' WHERE SecCode = 4282147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616156845, ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 4298618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764112353, ExchCode = 'FRA' WHERE SecCode = 4324622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764864768, ExchCode = 'DEU' WHERE SecCode = 4334568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840883847, ExchCode = 'STU' WHERE SecCode = 4335866 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4371502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960077472, ExchCode = 'GTX' WHERE SecCode = 4380746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307581, ExchCode = 'MEX' WHERE SecCode = 4403942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780909499, ExchCode = 'FRA' WHERE SecCode = 4413712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 4434255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794257515, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'FIRY*' WHERE SecCode = 4474399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809915701, ExchCode = 'STU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781361764, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4517877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4570378 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4570463 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4570464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727263610, ExchCode = 'BIV' WHERE SecCode = 4610049 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951843.0 WHERE SecCode = 4617794 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 PermSecMapEndDate = '2026-06-23' WHERE SecCode = 4629496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4666054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244578, ExchCode = 'BIV' WHERE SecCode = 4684128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388765, ExchCode = 'LAS' WHERE SecCode = 4689999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244579, ExchCode = 'MEX' WHERE SecCode = 4695806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853430101, ExchCode = 'GTX' WHERE SecCode = 4720518 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 4749905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856729893, ExchCode = 'DEU' WHERE SecCode = 4777352 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4784313 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4796286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859821791, ExchCode = 'STO' WHERE SecCode = 4802290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804716445, ExchCode = 'HAM' WHERE SecCode = 4815349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727258450, ExchCode = 'BIV' WHERE SecCode = 4827927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874018782, ExchCode = 'QTX' WHERE SecCode = 4830767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830057, ExchCode = 'QTX' WHERE SecCode = 4834795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866893816 WHERE SecCode = 4841211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792865451, ExchCode = 'MUN' WHERE SecCode = 4841234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 4911169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471210, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-05-22' WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885992034, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4959596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689378, ExchCode = 'FRA' WHERE SecCode = 4959597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716262, ExchCode = 'FRA' WHERE SecCode = 4960863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21889564320, ExchCode = 'STU' WHERE SecCode = 4960864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179518902, Ticker = '2MUEd', ExchCode = 'BTE' WHERE SecCode = 4965038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 5041696 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 = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777464944, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5063516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805401000, ExchCode = 'FRA' WHERE SecCode = 5089305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026880, Ticker = '1KDP' WHERE SecCode = 5107765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913101536, ExchCode = 'QTX' WHERE SecCode = 5129748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913514545, ExchCode = 'DEU' WHERE SecCode = 5130678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853640013, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21657632265, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-04' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305815, ExchCode = 'BIV' WHERE SecCode = 5161409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850513498, ExchCode = 'FRA' WHERE SecCode = 5161417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5183017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198685, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5206281 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938339192, ExchCode = 'MUN' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5277535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775962839, ExchCode = 'MEX' WHERE SecCode = 5328418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775962846, ExchCode = 'MEX' WHERE SecCode = 5328421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782434087, ExchCode = 'STU' WHERE SecCode = 5343608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059910, ExchCode = 'FRA' WHERE SecCode = 5354968 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 5360607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958061854, Ticker = 'ACAGv', ExchCode = 'BCO' WHERE SecCode = 5372903 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 PermOrgIPODate = NULL WHERE SecCode = 5374930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727195025, ExchCode = 'MEX' WHERE SecCode = 5381947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777223518, ExchCode = 'FRA' WHERE SecCode = 5403440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777195781, ExchCode = 'TDG' WHERE SecCode = 5407839 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22092544416, ExchCode = 'DEU' WHERE SecCode = 5407840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777239370, PermQuoteStatus = 'DC', Ticker = 'T2I0', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 5407846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777248729, ExchCode = 'FRA' WHERE SecCode = 5407861 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5417660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21849037685, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 5430827 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 5436573 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5452262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078258, ExchCode = 'LAS' WHERE SecCode = 5458313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787906111, Ticker = 'COXEe', ExchCode = 'BCO' WHERE SecCode = 5458394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778108786, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380732, ExchCode = 'LAS' WHERE SecCode = 5466447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5474595 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5500276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 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 = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 5507451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786107921, ExchCode = 'FRA' WHERE SecCode = 5553189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794060301, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-05', PermSecMapEndDate = NULL WHERE SecCode = 5577589 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5584483 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5633491 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 = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5658310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801851321, ExchCode = 'LAS' WHERE SecCode = 5706779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 5760053 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 8589953249.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 5760054 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5760140 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5859841 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5888371 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5898712 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6008861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790104292, ExchCode = 'FRA' WHERE SecCode = 6026055 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6058661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381827, ExchCode = 'LAS' WHERE SecCode = 6065904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386194, ExchCode = 'FRA' WHERE SecCode = 6065905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779191364, ExchCode = 'QTX' WHERE SecCode = 6097397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 6097447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22083971913, ExchCode = 'DEU' WHERE SecCode = 6104635 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22086925583, ExchCode = 'MUN' WHERE SecCode = 6104636 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6119898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089463033, ExchCode = 'DEU' WHERE SecCode = 6151862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790959257, ExchCode = 'GTX' WHERE SecCode = 6151863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828392, Ticker = '1ABBm', ExchCode = 'BCO' WHERE SecCode = 6164274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828461, Ticker = '1SXPm', ExchCode = 'BCO' WHERE SecCode = 6167178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828459, Ticker = '1AG1m', ExchCode = 'BCO' WHERE SecCode = 6167179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828389, Ticker = '1SBOm', ExchCode = 'BCO' WHERE SecCode = 6167183 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828395, Ticker = '1VIGm', ExchCode = 'BCO' WHERE SecCode = 6167185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828403, Ticker = '1WIEm', ExchCode = 'BCO' WHERE SecCode = 6167186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828386, Ticker = '1LNZm', ExchCode = 'BCO' WHERE SecCode = 6167190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828387, Ticker = '1TEAm', ExchCode = 'BCO' WHERE SecCode = 6167193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828463, Ticker = '1FPEm', ExchCode = 'BCO' WHERE SecCode = 6167195 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6176232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791600283, ExchCode = 'MEX' WHERE SecCode = 6220139 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 6258195 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6258209 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6258211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789803304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-06', PermSecMapEndDate = '2026-03-06' WHERE SecCode = 6260557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805672325, Ticker = '1TOSTm', ExchCode = 'BCO' WHERE SecCode = 6263917 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828400, Ticker = '1GRMNm', ExchCode = 'BCO' WHERE SecCode = 6264153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828397, Ticker = '1CBm', ExchCode = 'BCO' WHERE SecCode = 6264155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828385, Ticker = '1SLBm', ExchCode = 'BCO' WHERE SecCode = 6264162 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828416, Ticker = '1LOGNm', ExchCode = 'BCO' WHERE SecCode = 6268994 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828393, Ticker = '1SIKAm', ExchCode = 'BCO' WHERE SecCode = 6268995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828391, Ticker = '1BAERm', ExchCode = 'BCO' WHERE SecCode = 6269008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22101573233, ExchCode = 'DEU' WHERE SecCode = 6278719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792547775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 6278721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105867713, ExchCode = 'MUN' WHERE SecCode = 6286094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792558886, ExchCode = 'FRA' WHERE SecCode = 6286099 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6305206 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793107258, ExchCode = 'MUN' WHERE SecCode = 6310331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797747578, ExchCode = 'TDG' WHERE SecCode = 6310332 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 6322269 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6322315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793829533, ExchCode = 'QTX' WHERE SecCode = 6324151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793317692, ExchCode = 'FRA' WHERE SecCode = 6329880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22114348084, ExchCode = 'DEU' WHERE SecCode = 6351553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22171710454, Ticker = 'SPUTl', ExchCode = 'BCO' WHERE SecCode = 6351665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 6361972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116013136, Ticker = NULL, QuoteClass = 'ETN' WHERE SecCode = 6366675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793764215, ExchCode = 'FRA' WHERE SecCode = 6366680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6396598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125348556, ExchCode = 'DEU' WHERE SecCode = 6438418 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 = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22133533820, ExchCode = 'DEU' WHERE SecCode = 6497501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 6533610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138963810, ExchCode = 'GTX' WHERE SecCode = 6538893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138976427, ExchCode = 'DEU' WHERE SecCode = 6538897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138986522, ExchCode = 'DEU' WHERE SecCode = 6538898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798464029, ExchCode = 'TDG' WHERE SecCode = 6546195 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798464033, ExchCode = 'TDG' WHERE SecCode = 6546196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798865406, ExchCode = 'TDG' WHERE SecCode = 6552442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381935, ExchCode = 'LAS' WHERE SecCode = 6552449 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 PermInstrStatus = 'DC' WHERE SecCode = 6599011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828458, Ticker = '1AUMOm', ExchCode = 'BCO' WHERE SecCode = 6599016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6601486 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6601499 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6601500 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6626390 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6626617 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 6626814 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 6628117 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951210.0 WHERE SecCode = 6635229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6638314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802807020, ExchCode = 'BIV' WHERE SecCode = 6664680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403434, ExchCode = 'FRA' WHERE SecCode = 6686045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403851, ExchCode = 'FRA' WHERE SecCode = 6686046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403608, ExchCode = 'FRA' WHERE SecCode = 6686051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403609, ExchCode = 'FRA' WHERE SecCode = 6686052 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803385260, ExchCode = 'TDG' WHERE SecCode = 6694389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804483806, ExchCode = 'QTX' WHERE SecCode = 6716119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165589156, ExchCode = 'DEU' WHERE SecCode = 6716121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165599099, ExchCode = 'DEU' WHERE SecCode = 6716122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808183783, ExchCode = 'TDG' WHERE SecCode = 6721467 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6721473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804483809, ExchCode = 'QTX' WHERE SecCode = 6727870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912033, ExchCode = 'FRA' WHERE SecCode = 6748858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912039, ExchCode = 'FRA' WHERE SecCode = 6748859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912036, ExchCode = 'FRA' WHERE SecCode = 6748860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912041, ExchCode = 'FRA' WHERE SecCode = 6748861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912299, ExchCode = 'FRA' WHERE SecCode = 6748862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912040, ExchCode = 'FRA' WHERE SecCode = 6748866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805997201, ExchCode = 'BIV' WHERE SecCode = 6802699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806228771, ExchCode = 'FRA' WHERE SecCode = 6813221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806228774, ExchCode = 'FRA' WHERE SecCode = 6813222 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6820239 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 6829242 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 6836140 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 6836141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807168148, ExchCode = 'TDG' WHERE SecCode = 6862202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797408712, ExchCode = 'BIV' WHERE SecCode = 6900891 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807977903, ExchCode = 'FRA' WHERE SecCode = 6900894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808059081, ExchCode = 'MUN' WHERE SecCode = 6902160 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6902651 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6902652 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232935240329.0 WHERE SecCode = 6908263 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6911140 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 6914470 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 6914471 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6914473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808826779, ExchCode = 'TDG' WHERE SecCode = 6923756 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2026-06-23' WHERE SecCode = 6930668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188701873, ExchCode = 'MUN' WHERE SecCode = 6930689 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'NBIAY' WHERE SecCode = 10899884 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 10902674 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 10923248 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10924429 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'AEFI' WHERE SecCode = 10925098 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11004399 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232935240329.0 WHERE SecCode = 11014419 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'TOR' WHERE SecCode = 11015873 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11055063 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11106007 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11112456 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11130053 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 11147394 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11148710 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11151885 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11161639 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 11192670 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11196572 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 11203287 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11214004 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'CLNMF', PermQuoteRetireDate = NULL WHERE SecCode = 11219196 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'TRKLF', PermQuoteRetireDate = NULL WHERE SecCode = 11225957 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365405.0 WHERE SecCode = 11226938 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-24' WHERE SecCode = 11235980 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11239433 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11248583 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11248948 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11248949 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'NMB' WHERE SecCode = 11266759 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'ARLYF' WHERE SecCode = 11267641 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11269016 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11269017 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11269018 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11270668 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2025-02-05' WHERE SecCode = 11271694 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11273417 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2025-02-05' WHERE SecCode = 11274684 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11275270 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11275438 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11276885 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11277033 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'TMS', ExchCode = 'NAS' WHERE SecCode = 11277550 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 47767671086.0 WHERE SecCode = 11281874 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 47767671252.0 WHERE SecCode = 11284554 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11285746 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11285749 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11285760 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 47767671214.0 WHERE SecCode = 11286438 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11286613 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 47767671201.0 WHERE SecCode = 11292053 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11294834 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232917713569.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11295230 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808686462, IsPrimaryQuote = 1, ExchCode = 'TOR' WHERE SecCode = 11297816 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808687047, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297838 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808687092, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297839 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808687143, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11297841 AND Type_ = 1;