UPDATE data_universe_permid SET QuotePermID = 21538767932, Ticker = 'ABBYl', ExchCode = 'BCO', PermQuoteRetireDate = '2021-08-11' WHERE SecCode = 24 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 1541 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'PAM' WHERE SecCode = 3294 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 10214 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 11791 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 11793 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 11794 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 11796 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 11798 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 19712 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'ENZN' WHERE SecCode = 24143 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAQ' WHERE SecCode = 27234 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 33673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 34150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836322896, ExchCode = 'BER', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 34403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 34986 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 35141 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 35503 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 36029 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 36033 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 36586 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 36731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BEL' WHERE SecCode = 38345 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 40124 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 40675 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 40676 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 41399 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 42292 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 42538 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 42539 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 44838 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 45126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532854931, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838652164, ExchCode = 'STU' WHERE SecCode = 46294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341602, ExchCode = 'BER' WHERE SecCode = 46521 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 46691 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 46848 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328604, Ticker = 'FRZS', ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295342, ExchCode = 'GTX' WHERE SecCode = 48327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 49333 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 49773 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 50109 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 50225 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 51645 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 51946 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 52389 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 52507 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'EFOR' WHERE SecCode = 52592 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 53796 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 54024 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 54065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475576317, ExchCode = 'STU', PermQuoteRetireDate = '2008-01-07' WHERE SecCode = 54284 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 54663 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 55380 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 55385 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 55408 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LVA' WHERE SecCode = 55769 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 55944 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 56148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590786433, ExchCode = 'TDG' WHERE SecCode = 56615 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 57118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560955141, PermQuoteStatus = 'AC', Ticker = 'CUW', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 57884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419027, ExchCode = 'LAS' WHERE SecCode = 57889 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621680880, ExchCode = 'TDG' WHERE SecCode = 58060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475745795, ExchCode = 'BER' WHERE SecCode = 58064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838502924, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-07' WHERE SecCode = 58140 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585226757, ExchCode = 'STU' WHERE SecCode = 58245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034886, ExchCode = 'TDG' WHERE SecCode = 58367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690205956, ExchCode = 'STU' WHERE SecCode = 58368 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 58825 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 59674 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134747, ExchCode = 'DEU' WHERE SecCode = 60316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856728229, ExchCode = 'TDG' WHERE SecCode = 60667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21601556166, ExchCode = 'STU' WHERE SecCode = 61371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 63207 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 64572 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 66864 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 66922 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 67581 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 69936 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 70015 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 70258 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 70619 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 70620 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 72799 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 75857 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 78996 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 79000 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 81091 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 82383 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-23' WHERE SecCode = 83347 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 83464 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 83611 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 83660 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 83668 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 85011 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 85473 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 86573 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 86821 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 87726 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 87844 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727196678, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 88642 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 89116 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 89624 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 89801 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 90521 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 91065 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92006 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 92027 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92408 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92409 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92410 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92416 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92429 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92430 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92431 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92432 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92433 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92434 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92435 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92436 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92437 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92438 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92439 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92440 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92441 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92442 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92443 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92444 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92460 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92462 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 92476 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CIV', IncCntry = 'CIV' WHERE SecCode = 94972 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 95941 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 96014 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-23' WHERE SecCode = 96185 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 96970 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 97193 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 97928 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 99240 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 99642 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 99726 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVN' WHERE SecCode = 99762 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 99778 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 100014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU' WHERE SecCode = 100032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667490953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-20' WHERE SecCode = 100052 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 100110 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 100509 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 100818 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 101170 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 101176 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 101193 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 101480 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 102111 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 102495 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 103658 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 111707 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 111784 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 111810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656727011, ExchCode = 'STU' WHERE SecCode = 111811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 112618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 113797 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 113962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 121177 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 121186 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 125765 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BEL' WHERE SecCode = 130665 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 131182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957798876, ExchCode = 'DEU' WHERE SecCode = 131976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475473389, ExchCode = 'GER' WHERE SecCode = 133773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997854, ExchCode = 'DEU' WHERE SecCode = 138040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724373360, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-26' WHERE SecCode = 138113 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 139003 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'YAJ1', PermSecMapEndDate = NULL WHERE SecCode = 140068 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 140643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777652457, ExchCode = 'FRA' WHERE SecCode = 140677 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 140871 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 141118 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 141283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509916679, ExchCode = 'TDG' WHERE SecCode = 141439 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 141833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 144048 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 144214 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 144235 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 144337 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 144418 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 145445 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 146597 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 146653 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 147357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 172982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 178548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 180684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777874419, ExchCode = 'GTX' WHERE SecCode = 202935 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332121, ExchCode = 'BER', PermQuoteRetireDate = '2017-04-05' WHERE SecCode = 203925 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'HRV' WHERE SecCode = 212062 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 214643 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 216554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528269166, ExchCode = 'DEU' WHERE SecCode = 249402 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 IncCntry = 'FRA' WHERE SecCode = 257513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138696948, ExchCode = 'HAM' WHERE SecCode = 278881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836388950, ExchCode = 'FRA' WHERE SecCode = 283709 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 285287 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 285291 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 285603 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 289853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 296243 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'PEXXF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-22', PermSecMapEndDate = NULL WHERE SecCode = 300854 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21571572383, ExchCode = 'TDG' WHERE SecCode = 309339 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 311131 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 314398 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 315778 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 325740 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 326998 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 327369 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 328182 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836320770, ExchCode = 'BER', PermQuoteRetireDate = '2017-07-31' WHERE SecCode = 333182 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 336196 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 345340 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838799125, Ticker = NULL, ExchCode = 'PRA' WHERE SecCode = 346537 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 348022 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 352645 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LUX', PermOrgIPODate = '1753-01-01' WHERE SecCode = 362350 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LUX', PermOrgIPODate = '1753-01-01' WHERE SecCode = 362751 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LUX', PermOrgIPODate = '1753-01-01' WHERE SecCode = 372400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475432895, Ticker = 'MULT.GR', ExchCode = 'PLU', PermQuoteRetireDate = '2009-08-27' WHERE SecCode = 374930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514709829, Ticker = 'D69', ExchCode = 'STU' WHERE SecCode = 379671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835813469, ExchCode = 'MEX' WHERE SecCode = 383039 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 384435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621501713, Ticker = '4QQ', ExchCode = 'STU', PermQuoteRetireDate = '2022-05-19' WHERE SecCode = 389019 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 389440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840905043, ExchCode = 'BER' WHERE SecCode = 389775 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 391296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451829, Ticker = 'NEM', ExchCode = 'SWX' WHERE SecCode = 392615 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JPN' WHERE SecCode = 393864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841643563, ExchCode = 'BER' WHERE SecCode = 401624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704362, ExchCode = 'MXQ' WHERE SecCode = 411789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598800488, ExchCode = 'STU' WHERE SecCode = 412853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843102675, ExchCode = 'BER' WHERE SecCode = 424779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294126, ExchCode = 'GTX' WHERE SecCode = 425031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511427254, ExchCode = 'STU', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 425411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520096838, ExchCode = 'STU' WHERE SecCode = 428332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517622815, ExchCode = 'STU' WHERE SecCode = 428335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830302889, ExchCode = 'GTX' WHERE SecCode = 432012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536204619, ExchCode = 'STU' WHERE SecCode = 435796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55845312524, ExchCode = 'GER' WHERE SecCode = 436499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599934396, ExchCode = 'TDG', PermQuoteRetireDate = '2023-12-14', PermSecMapEndDate = '2023-12-14' WHERE SecCode = 438364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475766995, ExchCode = 'FRA', PermQuoteRetireDate = '2019-08-19' WHERE SecCode = 446617 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 453923 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 453979 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 454044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704501, ExchCode = 'MXQ' WHERE SecCode = 462658 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 463676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 479615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847283502, Ticker = 'XAXJ', ExchCode = 'LSE' WHERE SecCode = 481041 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 485083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474993358, ExchCode = 'STU' WHERE SecCode = 486276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605425984, ExchCode = 'RTB' WHERE SecCode = 500487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848865464, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 503830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725613667, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 503842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' WHERE SecCode = 508999 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 510241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662223441, ExchCode = 'TDG' WHERE SecCode = 512041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914681044, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 513278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531115401, Ticker = '0GAd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-12' WHERE SecCode = 513937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849681521, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 514961 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492958, ExchCode = 'QTX' WHERE SecCode = 515043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761780375, ExchCode = 'DEU' WHERE SecCode = 519427 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 519484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920980932, ExchCode = 'DEU' WHERE SecCode = 519511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634749271, PermQuoteStatus = 'AC', Ticker = 'AU31', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 519515 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837441656, Ticker = 'HOGS', ExchCode = 'MIL' WHERE SecCode = 521415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837446990, Ticker = 'WEAT', ExchCode = 'MIL' WHERE SecCode = 521420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805519519, ExchCode = 'MUN', PermQuoteRetireDate = '2025-10-24' WHERE SecCode = 527096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033612, Ticker = '9EA', PermQuoteRetireDate = '2015-10-22' WHERE SecCode = 531956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474893887, Ticker = '8EC0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 533384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523646821, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 533522 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071708, ExchCode = 'MUN' WHERE SecCode = 535314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851203489, ExchCode = 'FRA', PermQuoteRetireDate = '2014-04-01' WHERE SecCode = 535316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475135974, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 539801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475134742, ExchCode = 'MUN' WHERE SecCode = 541276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852219705, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' WHERE SecCode = 541495 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21607765095, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 541523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856846840, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-25' WHERE SecCode = 541974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474938108, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 542320 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 542613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916878, ExchCode = 'TDG' WHERE SecCode = 542943 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 546002 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 546058 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 546621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852420890, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-29' WHERE SecCode = 547537 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478506436, ExchCode = 'STU' WHERE SecCode = 548067 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 549151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636054188, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-24' WHERE SecCode = 549287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859092912, ExchCode = 'FRA' WHERE SecCode = 551262 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 551365 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 552322 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21499583580, ExchCode = 'TDG' WHERE SecCode = 552948 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 553419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850857947, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 553921 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 554222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852277935, ExchCode = 'MEX' WHERE SecCode = 554302 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'MMIDA' WHERE SecCode = 555050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727200539, ExchCode = 'BIV' WHERE SecCode = 557690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475119976, ExchCode = 'FRA' WHERE SecCode = 557816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475771162, ExchCode = 'STU' WHERE SecCode = 557995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856214005, ExchCode = 'FRA' WHERE SecCode = 558032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128988850, ExchCode = 'DEU' WHERE SecCode = 558485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218481, ExchCode = 'BER', PermQuoteRetireDate = '2013-02-08' WHERE SecCode = 559256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856606624, ExchCode = 'GER' WHERE SecCode = 559437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801833319, ExchCode = 'LAS' WHERE SecCode = 559903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575579847, PermQuoteStatus = 'AC', Ticker = '7TM0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 560717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814307220, PermQuoteStatus = 'AC', Ticker = 'OA5', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 560728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856859125, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 561328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857450136, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 564035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487603, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 564417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492892892, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475822753, ExchCode = 'DEU', PermQuoteRetireDate = '2013-10-01' WHERE SecCode = 565586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475805271, ExchCode = 'STU' WHERE SecCode = 565752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857579082, ExchCode = 'FRA' WHERE SecCode = 565861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474962557, ExchCode = 'DEU' WHERE SecCode = 565866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794980779, ExchCode = 'MUN', PermQuoteRetireDate = '2024-07-10' WHERE SecCode = 566221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174126940, ExchCode = 'DEU' WHERE SecCode = 566528 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 566671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152662, ExchCode = 'MUN' WHERE SecCode = 568338 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 570257 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 574260 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511793851, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 583151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475127469, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 591764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858902712, ExchCode = 'BER' WHERE SecCode = 592307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589742988, ExchCode = 'STU' WHERE SecCode = 593055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474967930, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 593104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599770084, ExchCode = 'STU' WHERE SecCode = 597462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859254285, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 599978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859255778, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 602090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22157401812, ExchCode = 'DEU' WHERE SecCode = 602147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475858943, ExchCode = 'BTE', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 602656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859257109, ExchCode = 'FRA' WHERE SecCode = 604212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651373202, ExchCode = 'DEU' WHERE SecCode = 607486 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 609134 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2020-11-15' WHERE SecCode = 610640 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55868335680, Ticker = 'OCS.GB', ExchCode = 'PLU' WHERE SecCode = 649936 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 657721 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 657964 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 669682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540229905, ExchCode = 'STU' WHERE SecCode = 701753 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 706296 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 751186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475105966, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 826159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532857661, ExchCode = 'TDG' WHERE SecCode = 837909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915623112, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 848018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22046913525, ExchCode = 'DEU' WHERE SecCode = 878880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554127327, Ticker = 'XSILz', ExchCode = 'CHI' WHERE SecCode = 880290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830275427, ExchCode = 'GTX' WHERE SecCode = 881802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655396700, ExchCode = 'FRA' WHERE SecCode = 882427 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 882622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681038408, Ticker = 'IPHS*', ExchCode = 'MXQ' WHERE SecCode = 885999 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-29' WHERE SecCode = 887451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704694, ExchCode = 'MXQ' WHERE SecCode = 888213 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LUX', PermOrgIPODate = '1753-01-01' WHERE SecCode = 894330 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LVA' WHERE SecCode = 898264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545813896, ExchCode = 'DEU' WHERE SecCode = 931181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388797, ExchCode = 'LAS' WHERE SecCode = 943158 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 943777 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 943781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494357256, Ticker = '0HFW', ExchCode = 'LSE', PermQuoteRetireDate = '2013-01-14' WHERE SecCode = 961652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475769605, Ticker = 'TYMA', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 995830 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 997867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145600723, ExchCode = 'DEU' WHERE SecCode = 1017380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22166504395, ExchCode = 'DEU' WHERE SecCode = 1072550 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 1107030 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21592709737, ExchCode = 'STU' WHERE SecCode = 1113268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521578326, ExchCode = 'DEU' WHERE SecCode = 1122776 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 1123757 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 1125543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704160, ExchCode = 'MXQ' WHERE SecCode = 1162639 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2023-01-24' WHERE SecCode = 1260133 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 1320988 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797800257, ExchCode = 'DUS' WHERE SecCode = 1425621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 1455404 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BIH', IncCntry = 'BIH' WHERE SecCode = 1458934 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BIH', IncCntry = 'BIH' WHERE SecCode = 1459200 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BIH', IncCntry = 'BIH' WHERE SecCode = 1459362 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BIH' WHERE SecCode = 1464822 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 1465035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 1485661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482228346, ExchCode = 'DEU' WHERE SecCode = 1485685 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 1485736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596919147, Ticker = 'SLHOm', ExchCode = 'BTE', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1503000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512147101, Ticker = 'BRDG', ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678236, ExchCode = 'BIV' WHERE SecCode = 1518823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21488288403, ExchCode = 'FRA' WHERE SecCode = 1524542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN' WHERE SecCode = 1524543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794818026, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1527439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21489507452, ExchCode = 'STU', PermQuoteRetireDate = '2012-02-14' WHERE SecCode = 1527466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21491111760, ExchCode = 'FRA' WHERE SecCode = 1532859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630031903, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1538644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775091198, ExchCode = 'FRA' WHERE SecCode = 1541396 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492779438, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 1554184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498230074, ExchCode = 'FRA' WHERE SecCode = 1554784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498302420, ExchCode = 'DEU' WHERE SecCode = 1555173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498521053, ExchCode = 'DEU' WHERE SecCode = 1556381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 1584582 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 DomCntry = 'PHL' WHERE SecCode = 1591057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678108, ExchCode = 'BIV' WHERE SecCode = 1595975 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 1597261 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 1623753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527481178, PermQuoteStatus = 'DC', Ticker = 'PJSB', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1660702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511222796, ExchCode = 'DEU' WHERE SecCode = 1675772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513074351, ExchCode = 'FRA' WHERE SecCode = 1720504 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 1725134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513762821, ExchCode = 'DEU' WHERE SecCode = 1736071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 1752296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 1992885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2050614 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2060403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531536875, ExchCode = 'BTE' WHERE SecCode = 2073367 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 2087901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589938022, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2126923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2216584 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478541, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535950995, ExchCode = 'STU' WHERE SecCode = 2255684 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2270000 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2023-01-24' WHERE SecCode = 2270008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525348690, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 2279777 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVK' WHERE SecCode = 2333785 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21687380736, Ticker = 'CECDl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-07-06' WHERE SecCode = 2350989 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2360090 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2368760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369453, ExchCode = 'BEC' WHERE SecCode = 2377498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2421096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2438954 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LVA' WHERE SecCode = 2441692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489670, ExchCode = 'QTX' WHERE SecCode = 2448345 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2452340 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2453125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381214, ExchCode = 'LAS' WHERE SecCode = 2466343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537746016, ExchCode = 'BER', PermQuoteRetireDate = '2015-04-03' WHERE SecCode = 2466346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535492269, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 2466348 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 2467280 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 2467281 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 2467282 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HRV', IncCntry = 'HRV' WHERE SecCode = 2467283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 2514700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792893352, ExchCode = 'TDG' WHERE SecCode = 2518731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379477, ExchCode = 'LAS' WHERE SecCode = 2524755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2531731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539181649, ExchCode = 'FRA' WHERE SecCode = 2532821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539323912, ExchCode = 'DEU' WHERE SecCode = 2534073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591864432, ExchCode = 'STU' WHERE SecCode = 2539933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2544442 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2545660 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2547391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540108933, ExchCode = 'DEU' WHERE SecCode = 2554904 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2560602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 2568210 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2572290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673451, ExchCode = 'BIV' WHERE SecCode = 2572318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542813327, ExchCode = 'TDG' WHERE SecCode = 2573038 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2580218 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 2582180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782012631, ExchCode = 'FRA' WHERE SecCode = 2585381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121993910, ExchCode = 'BCO' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21712051521, Ticker = '3HCS', ExchCode = 'MIL' WHERE SecCode = 2600076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067641956, ExchCode = 'BTE' WHERE SecCode = 2600378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566715663, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2604391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545617420, ExchCode = 'DEU' WHERE SecCode = 2617118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606224224, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-01' WHERE SecCode = 2622293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704623, ExchCode = 'MXQ' WHERE SecCode = 2623720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371263, ExchCode = 'BEC' WHERE SecCode = 2625122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546332345, PermQuoteStatus = 'AC', Ticker = '14S0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2625801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546889760, ExchCode = 'DEU' WHERE SecCode = 2628627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830284768, ExchCode = 'GTX' WHERE SecCode = 2628651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2633145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547192238, ExchCode = 'FRA' WHERE SecCode = 2635770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547457190, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2636990 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2642445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587109508, ExchCode = 'DEU' WHERE SecCode = 2643269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781362990, ExchCode = 'DUS' WHERE SecCode = 2644157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789587913, ExchCode = 'LAS' WHERE SecCode = 2644161 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2644171 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704172, ExchCode = 'MXQ' WHERE SecCode = 2644179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478452, ExchCode = 'QTX' WHERE SecCode = 2649155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2668929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 2677991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596919175, ExchCode = 'BTE' WHERE SecCode = 2679866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535196406, PermQuoteStatus = 'AC', Ticker = 'B1C', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2679897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535197344, Ticker = '7HP', ExchCode = 'BRN' WHERE SecCode = 2679919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451855, Ticker = 'QCOM', ExchCode = 'SWX' WHERE SecCode = 2679937 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2682277 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 2695647 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534589, ExchCode = 'QTX', PermQuoteRetireDate = '2025-06-26', PermSecMapEndDate = NULL WHERE SecCode = 2706346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837147070, ExchCode = 'DUS' WHERE SecCode = 2708937 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2710417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540948191, Ticker = '0QTP', ExchCode = 'LSE', PermQuoteRetireDate = '2020-03-10' WHERE SecCode = 2710438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727309229, ExchCode = 'MEX' WHERE SecCode = 2715641 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 2718434 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552934405, ExchCode = 'MEX' WHERE SecCode = 2724356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807264997, ExchCode = 'DEU' WHERE SecCode = 2732754 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2739720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 2765911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679952, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2767178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674963, ExchCode = 'BIV' WHERE SecCode = 2767208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755558882, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2774739 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2784985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704598, ExchCode = 'MXQ' WHERE SecCode = 2812158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381707, ExchCode = 'LAS' WHERE SecCode = 2817416 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558155460, ExchCode = 'DEU' WHERE SecCode = 2823565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 2833838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915623088, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 2846585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589220365, ExchCode = 'DEU', PermQuoteRetireDate = '2019-04-05' WHERE SecCode = 2855771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560976557, ExchCode = 'DEU' WHERE SecCode = 2857038 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2858543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661952426, ExchCode = 'DEU' WHERE SecCode = 2858567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599521455, PermQuoteStatus = 'DC', ExchCode = 'BER', DomCntry = 'CHN', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2861791 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 2864431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704263, ExchCode = 'MXQ' WHERE SecCode = 2889050 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 2891291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647736991, ExchCode = 'FRA' WHERE SecCode = 2893040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2900880 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2906389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585209876, ExchCode = 'BCO' WHERE SecCode = 2906408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731661976, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2907244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21654537658, ExchCode = 'MUN', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 2907245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564680695, ExchCode = 'DEU' WHERE SecCode = 2909231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564679416, Ticker = 'V00', ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 2909232 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 2909239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564846532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 2909243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564939130, ExchCode = 'FRA' WHERE SecCode = 2909928 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 2911291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386051, ExchCode = 'LAS' WHERE SecCode = 2911859 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-28' WHERE SecCode = 2912792 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 QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605132678, ExchCode = 'STU' WHERE SecCode = 2930976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540992047, ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-24', PermSecMapEndDate = '2019-05-24' WHERE SecCode = 2932394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704428, ExchCode = 'MXQ' WHERE SecCode = 2944454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381763, ExchCode = 'LAS' WHERE SecCode = 2947926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569333990, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2952372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675024, ExchCode = 'BIV' WHERE SecCode = 2963604 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 2980488 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2982480 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461895, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3008027 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 3010265 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3015974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 3029311 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3049340 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3050440 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3062276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582997825, Ticker = 'RYA', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3072584 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460747, Ticker = 'OD7F', ExchCode = 'FRA' WHERE SecCode = 3076722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916285720, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 3088079 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3096046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641139161, Ticker = 'J75', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 3096965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308552, ExchCode = 'GTX' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22164689174, ExchCode = 'MUN' WHERE SecCode = 3121289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621432527, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3121290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3129541 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 3143960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 3155283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22137202074, ExchCode = 'DEU' WHERE SecCode = 3186751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786090215, Ticker = 'PCFH', ExchCode = 'TDG' WHERE SecCode = 3198718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-01' WHERE SecCode = 3199703 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 3200611 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3206339 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388055, ExchCode = 'LAS' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21966235983, ExchCode = 'DEU' WHERE SecCode = 3215818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865877693, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-23' WHERE SecCode = 3223076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747575641, ExchCode = 'QTX' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21839306386, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-12' WHERE SecCode = 3242031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100768, ExchCode = 'DUS' WHERE SecCode = 3247170 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 3247398 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21716782408, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21' WHERE SecCode = 3255119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598341840, ExchCode = 'FRA', PermQuoteRetireDate = '2024-08-13', PermSecMapEndDate = '2024-08-13' WHERE SecCode = 3260030 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277217 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3281887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602970799, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3283956 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3285910 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'URY' WHERE SecCode = 3297215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690196182, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3301805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608659181, ExchCode = 'STU' WHERE SecCode = 3316586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786551901, ExchCode = 'TDG' WHERE SecCode = 3317115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609137328, ExchCode = 'FRA' WHERE SecCode = 3317384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 3320389 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 3322264 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 3324226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649841825, ExchCode = 'BER' WHERE SecCode = 3327824 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 3327966 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3328153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788762034, ExchCode = 'FRA' WHERE SecCode = 3337223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887549117, ExchCode = 'GTX' WHERE SecCode = 3347599 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JPN' WHERE SecCode = 3352133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705783, ExchCode = 'MXQ' WHERE SecCode = 3358492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22098742116, ExchCode = 'DXE' WHERE SecCode = 3359183 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3365656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749591716, Ticker = '90S1', ExchCode = 'STU', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 3371094 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 3371491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763116669, ExchCode = 'BER', PermQuoteRetireDate = '2023-02-15' WHERE SecCode = 3375389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100519, ExchCode = 'QTX' WHERE SecCode = 3378195 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'EGY' WHERE SecCode = 3378963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620409821, ExchCode = 'BCO' WHERE SecCode = 3385974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3394113 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3395570 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3395604 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 3395615 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'AVATAR' WHERE SecCode = 3396344 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3397182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624541573, ExchCode = 'FRA' WHERE SecCode = 3400265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810204931, ExchCode = 'DEU' WHERE SecCode = 3401365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780428164, ExchCode = 'GTX' WHERE SecCode = 3401402 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 QuotePermID = 21660711293, ExchCode = 'DEU' WHERE SecCode = 3403947 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3404447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628652762, ExchCode = 'STU', PermQuoteRetireDate = '2024-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3405438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624076993, ExchCode = 'SGO' WHERE SecCode = 3406544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 3408247 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'SVN' WHERE SecCode = 3408473 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 3408864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384246, ExchCode = 'LAS' WHERE SecCode = 3409373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801066696, Ticker = 'C0B1', ExchCode = 'DEU' WHERE SecCode = 3410283 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 3429811 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3430800 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3431921 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 3434986 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636066861, ExchCode = 'DEU' WHERE SecCode = 3435060 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 3435084 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 = 21834281133, ExchCode = 'TDG' WHERE SecCode = 3438714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793644583, ExchCode = 'TDG' WHERE SecCode = 3439533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644011375, ExchCode = 'DEU' WHERE SecCode = 3445093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643807094, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LUX', PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446009 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3446754 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3474381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3518267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830284691, ExchCode = 'GTX' WHERE SecCode = 3531554 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 3533848 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3546511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663166796, ExchCode = 'FRA' WHERE SecCode = 3550423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710951296, ExchCode = 'BTE' WHERE SecCode = 3550579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 3578207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 3587132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761303077, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3588035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673826, ExchCode = 'BIV' WHERE SecCode = 3588038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609218, ExchCode = 'FRA' WHERE SecCode = 3588082 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609512, ExchCode = 'DEU' WHERE SecCode = 3588083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731994491, ExchCode = 'FRA' WHERE SecCode = 3588110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661952421, ExchCode = 'DEU' WHERE SecCode = 3591601 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 3597832 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3597945 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3597946 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3599690 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3599725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878957446, ExchCode = 'SIG', PermQuoteRetireDate = '2023-09-23' WHERE SecCode = 3601109 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3615187 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 3629690 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 3631179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 3641048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668783311, ExchCode = 'HAM' WHERE SecCode = 3642406 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 3644463 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3644464 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3650260 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3653975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673848109, ExchCode = 'BIV' WHERE SecCode = 3717229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840047415, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 3736025 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3747811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681872326, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3754712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 3809093 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3809725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544674, ExchCode = 'DUS' WHERE SecCode = 3817679 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3818672 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 3818842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297937, Ticker = 'BM5', ExchCode = 'DUS', PermQuoteRetireDate = '2020-02-03' WHERE SecCode = 3830044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858452393, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3849234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858543, ExchCode = 'QTX' WHERE SecCode = 3852867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703900276, ExchCode = 'TDG' WHERE SecCode = 3898812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703664166, ExchCode = 'STU' WHERE SecCode = 3898813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679348107, ExchCode = 'BIV' WHERE SecCode = 3934323 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272890, ExchCode = 'GTX' WHERE SecCode = 3951450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711927625, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3955660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731983514, ExchCode = 'DUS' WHERE SecCode = 3977296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817960149, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4001066 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 4001074 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4001148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098633, ExchCode = 'STU' WHERE SecCode = 4004564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21721187938, PermQuoteStatus = 'DC', Ticker = '0XM0', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4007107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22043076029, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4008980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727377499, ExchCode = 'MEX' WHERE SecCode = 4022727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' 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 = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784327741, Ticker = '1BOD' WHERE SecCode = 4031822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026782, Ticker = '1FRA' WHERE SecCode = 4031875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 4032114 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026796, Ticker = '1IAG' WHERE SecCode = 4032120 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 4032130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184449, ExchCode = 'SIG' WHERE SecCode = 4033113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838220597, Ticker = 'OCPET', ExchCode = 'BRU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 4046600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778538494, ExchCode = 'FRA' WHERE SecCode = 4046667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729412447, ExchCode = 'FRA' WHERE SecCode = 4059429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729887692, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = NULL WHERE SecCode = 4062000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732154086, ExchCode = 'DEU' WHERE SecCode = 4080678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799881746, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 4101126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735310141, ExchCode = 'TDG' WHERE SecCode = 4103595 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735976737, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951908303, ExchCode = 'DUS' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778719260, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571646335, ExchCode = 'BEC' WHERE SecCode = 4139247 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 4153255 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4168432 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4168433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388438, ExchCode = 'LAS' WHERE SecCode = 4169152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4187863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745348418, ExchCode = 'TDG' WHERE SecCode = 4188130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232921508558.0, IsPrimaryInstr = 0 WHERE SecCode = 4194745 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958505, ExchCode = 'FRA' WHERE SecCode = 4201669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746262892, ExchCode = 'DEU' WHERE SecCode = 4201732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823963695, PermQuoteStatus = 'DC', Ticker = '4R80', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 4204823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958582, ExchCode = 'FRA' WHERE SecCode = 4209245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958647, ExchCode = 'FRA' WHERE SecCode = 4209246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958373, ExchCode = 'FRA' WHERE SecCode = 4209247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012792, Ticker = '2HCA' WHERE SecCode = 4214370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999014130, Ticker = '2NOW' WHERE SecCode = 4214371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011916, Ticker = '2AMT' WHERE SecCode = 4214372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011917, Ticker = '2AWK' WHERE SecCode = 4214377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012327, Ticker = '2GD' WHERE SecCode = 4214384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012556, Ticker = '2HLT' WHERE SecCode = 4214387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013434, Ticker = '2SPG' WHERE SecCode = 4214395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013297, Ticker = '2SYK' WHERE SecCode = 4214397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013876, Ticker = '2TROW' WHERE SecCode = 4214399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013596, Ticker = '2WEC' WHERE SecCode = 4214401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22069067182, Ticker = '2APH', ExchCode = 'MIL' WHERE SecCode = 4214403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371806, Ticker = '0Q3', ExchCode = 'BRN' WHERE SecCode = 4214409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013708, Ticker = '2PLUG', ExchCode = 'MIL' WHERE SecCode = 4214415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750887012, ExchCode = 'TDG' WHERE SecCode = 4231470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752408872, ExchCode = 'FRA' WHERE SecCode = 4248820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU' WHERE SecCode = 4274159 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 4277554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767996853, ExchCode = 'DEU' WHERE SecCode = 4278854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757260470, ExchCode = 'DEU' WHERE SecCode = 4278855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757506160, ExchCode = 'FRA' WHERE SecCode = 4278857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757668911, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758703400, ExchCode = 'DEU' WHERE SecCode = 4288863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759098748, ExchCode = 'FRA' WHERE SecCode = 4291265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727356005, ExchCode = 'BIV' WHERE SecCode = 4291615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699218038, ExchCode = 'FRA' WHERE SecCode = 4298602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22159899270, ExchCode = 'DEU' WHERE SecCode = 4298603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696686071, ExchCode = 'STU' WHERE SecCode = 4298604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720132349, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4298606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679461, ExchCode = 'BIV' WHERE SecCode = 4298620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759524962, ExchCode = 'FRA' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027131, Ticker = '1SPOT' WHERE SecCode = 4309035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026769, Ticker = '1AMS' WHERE SecCode = 4309037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010863, Ticker = '28TRA' WHERE SecCode = 4309041 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 4309043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026753, Ticker = '1FSLR' WHERE SecCode = 4309045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012751, Ticker = '2OXY' WHERE SecCode = 4309046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011966, Ticker = '2DOW' WHERE SecCode = 4309048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295374, ExchCode = 'GTX' WHERE SecCode = 4310575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 4349874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770221758, ExchCode = 'DEU' WHERE SecCode = 4360099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700183761, ExchCode = 'MEX' WHERE SecCode = 4362644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782583016, ExchCode = 'DUS' WHERE SecCode = 4365804 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388599, ExchCode = 'LAS' WHERE SecCode = 4365921 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 4385213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740524, ExchCode = 'LAS' WHERE SecCode = 4388200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991740, ExchCode = 'FRA' WHERE SecCode = 4400153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779062122, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-26' WHERE SecCode = 4401406 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 4402285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781439298, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782664057, ExchCode = 'DEU', PermQuoteRetireDate = '2024-10-31', PermSecMapEndDate = '2024-10-31' WHERE SecCode = 4422563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775216637, ExchCode = 'TDG' WHERE SecCode = 4422567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307218, ExchCode = 'BIV' WHERE SecCode = 4426954 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783652671, ExchCode = 'DEU' WHERE SecCode = 4426955 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727303270, ExchCode = 'BIV' WHERE SecCode = 4426957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783670602, ExchCode = 'EQD' WHERE SecCode = 4426958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013269, Ticker = '2VTRS' WHERE SecCode = 4427826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 4440270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786685967, ExchCode = 'FRA' WHERE SecCode = 4444002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 4458835 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789567035, ExchCode = 'DEU' WHERE SecCode = 4458936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789568350, ExchCode = 'DEU' WHERE SecCode = 4458938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367131, ExchCode = 'FRA' WHERE SecCode = 4463145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793689543, ExchCode = 'FRA' WHERE SecCode = 4463152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396762, ExchCode = 'DEU' WHERE SecCode = 4472909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 4476802 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 4479290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 4484496 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 = 21797555598, ExchCode = 'FRA' WHERE SecCode = 4496736 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 4496802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287355, ExchCode = 'BIV' WHERE SecCode = 4505578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21813169859, ExchCode = 'TDG' WHERE SecCode = 4511506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780960627, ExchCode = 'STU' WHERE SecCode = 4517645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381380, ExchCode = 'LAS' WHERE SecCode = 4526143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890670000, PermQuoteStatus = 'DC', ExchCode = 'GTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 4527883 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 4536341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808935929, Ticker = '0RW0', ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806550607, ExchCode = 'FRA' WHERE SecCode = 4553829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806896934, ExchCode = 'DEU' WHERE SecCode = 4557761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795577073, ExchCode = 'FRA' WHERE SecCode = 4557929 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4558223 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4558224 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4558225 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4558226 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4563452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808951005, ExchCode = 'DEU' WHERE SecCode = 4568423 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 4576454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 4580740 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812636752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-17' WHERE SecCode = 4589403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 4597226 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 4597228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011220, Ticker = '2INVEB' WHERE SecCode = 4601877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817036435, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 4607686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816241209, ExchCode = 'STU' WHERE SecCode = 4607717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138517569, ExchCode = 'BTE' WHERE SecCode = 4609997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045075404, ExchCode = 'LAS', DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4613099 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4613100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4634351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822771356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-08-16' WHERE SecCode = 4637752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4639598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312261, ExchCode = 'GTX' WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831908634, ExchCode = 'GTX' WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4651897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21839048901, ExchCode = 'MUN' WHERE SecCode = 4657695 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 4658861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829398967, ExchCode = 'STU' WHERE SecCode = 4664721 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4667228 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 4685304 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 4693645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837529343, ExchCode = 'FRA' WHERE SecCode = 4693647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933374646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2023-01-02' WHERE SecCode = 4697438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852728632, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720518 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 4741101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851840071, Ticker = 'NVIQ', ExchCode = 'LSE' WHERE SecCode = 4752180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098692, ExchCode = 'DEU' WHERE SecCode = 4753666 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 4759522 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854742239, ExchCode = 'FRA' WHERE SecCode = 4761587 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 4765915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855838898, ExchCode = 'QTX' WHERE SecCode = 4773770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439467, ExchCode = 'BER', IncCntry = 'ESP', PermQuoteRetireDate = '2021-11-18' WHERE SecCode = 4774934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856518308, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4777235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921513349, Ticker = 'A6I', ExchCode = 'QTX' WHERE SecCode = 4792475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860598008, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4800552 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 4804572 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4804602 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4806671 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4810005 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'JEY' WHERE SecCode = 4810064 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'DEU' WHERE SecCode = 4812300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4823660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865902197, ExchCode = 'FRA' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781510714, ExchCode = 'DUS' WHERE SecCode = 4845006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21868292645, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4845007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871056172, ExchCode = 'MUN' WHERE SecCode = 4845045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783262067, ExchCode = 'FRA' WHERE SecCode = 4846846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387395, ExchCode = 'LAS' WHERE SecCode = 4852140 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 4854840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22111478365, ExchCode = 'TDG' WHERE SecCode = 4854867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874645094, ExchCode = 'TDG' WHERE SecCode = 4885603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874654366, ExchCode = 'MUN' WHERE SecCode = 4887144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21877510550, ExchCode = 'STU' WHERE SecCode = 4887246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829806151, ExchCode = 'DEU' WHERE SecCode = 4890295 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881260859, ExchCode = 'STU' WHERE SecCode = 4925667 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778071457, PermQuoteStatus = 'AC', Ticker = '62U2', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893303383, ExchCode = 'MUN' WHERE SecCode = 4952512 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4957874 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 4957875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650257, ExchCode = 'DUS' WHERE SecCode = 4960868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21900329999, ExchCode = 'DEU' WHERE SecCode = 4970793 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '3JD0' WHERE SecCode = 4972282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779515510, ExchCode = 'FRA' WHERE SecCode = 4973342 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'LUX', PermOrgIPODate = '1753-01-01' WHERE SecCode = 4991847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953078, ExchCode = 'FRA' WHERE SecCode = 5002372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195445, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5042969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607201, Ticker = 'DXCM', ExchCode = 'SWX' WHERE SecCode = 5047087 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5054935 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5054937 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5054938 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5054939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902573195, ExchCode = 'DUS' WHERE SecCode = 5067269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21903663797, ExchCode = 'DEU' WHERE SecCode = 5072164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380640, ExchCode = 'LAS' WHERE SecCode = 5072166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910168364, ExchCode = 'DUS' WHERE SecCode = 5094355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816912714, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2023-01-12' WHERE SecCode = 5112411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910867434, ExchCode = 'STU' WHERE SecCode = 5119165 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 DomCntry = 'USA' WHERE SecCode = 5131691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607033, Ticker = 'NDAQ', ExchCode = 'SWX' WHERE SecCode = 5144089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860615655, ExchCode = 'STU' WHERE SecCode = 5153443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5161236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508526620, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 5161345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727308116, ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348309, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197643, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 5161449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947358613, ExchCode = 'STU' WHERE SecCode = 5162435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948058908, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5162437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924152322, ExchCode = 'FRA' WHERE SecCode = 5194304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924155635, ExchCode = 'DEU' WHERE SecCode = 5194305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904165, ExchCode = 'BCO' WHERE SecCode = 5203369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872761574, Ticker = 'AFTT', ExchCode = 'PAR' WHERE SecCode = 5206274 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5206345 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5206346 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5206347 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5206348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21833306231, Ticker = '3LNI', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5208067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 47733359571, ExchCode = 'FRA' WHERE SecCode = 5209761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933629891, ExchCode = 'TDG' WHERE SecCode = 5229902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012312, Ticker = '2FEY2' WHERE SecCode = 5258602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012261, Ticker = '2FDO' WHERE SecCode = 5258603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011947, Ticker = '2CVA' WHERE SecCode = 5258605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012745, Ticker = '2CYTH' WHERE SecCode = 5258609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013468, Ticker = '2USX1' WHERE SecCode = 5258612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936334478, ExchCode = 'QTX' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 5264927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775222348, ExchCode = 'MEX' WHERE SecCode = 5267090 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 5281344 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 5283711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935872312, Ticker = NULL, ExchCode = 'INC' WHERE SecCode = 5290241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780979385, ExchCode = 'DUS' WHERE SecCode = 5290322 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 5292499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5357733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007472, ExchCode = 'DEU' WHERE SecCode = 5381858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007494, ExchCode = 'DEU' WHERE SecCode = 5381859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007540, ExchCode = 'FRA' WHERE SecCode = 5381860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959007249, ExchCode = 'FRA' WHERE SecCode = 5381861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776581931, ExchCode = 'MEX' WHERE SecCode = 5381916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727195024, ExchCode = 'BIV' WHERE SecCode = 5381947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782758792, ExchCode = 'GTX' WHERE SecCode = 5393777 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 5403012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535797, ExchCode = 'MEX' WHERE SecCode = 5416155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416446, ExchCode = 'BIV' WHERE SecCode = 5417748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775107109, ExchCode = 'BIV' WHERE SecCode = 5430834 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5433631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921820703, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-17', PermSecMapEndDate = '2024-12-17' WHERE SecCode = 5434319 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 5436331 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5446095 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727169122, Ticker = 'CAMBIo', ExchCode = 'SIG' WHERE SecCode = 5448761 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5448867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360194, ExchCode = 'MEX' WHERE SecCode = 5449618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776268320, ExchCode = 'MEX' WHERE SecCode = 5455239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380730, PermQuoteStatus = 'DC', ExchCode = 'LAS', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 5457242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790015169, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5463054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727193596, ExchCode = 'MEX' WHERE SecCode = 5474598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778416291, ExchCode = 'FRA' WHERE SecCode = 5476926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818729828, ExchCode = 'FRA' WHERE SecCode = 5478214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778456487, ExchCode = 'FRA' WHERE SecCode = 5479512 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5482767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776850449, ExchCode = 'MEX' WHERE SecCode = 5482838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437243, ExchCode = 'MEX' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778704112, ExchCode = 'FRA' WHERE SecCode = 5493663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778704118, ExchCode = 'FRA' WHERE SecCode = 5493665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778659884, ExchCode = 'MEX' WHERE SecCode = 5496143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834799, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5496168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982253324, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5496242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21983506605, Ticker = '3BASm', ExchCode = 'BCO' WHERE SecCode = 5496244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394120, ExchCode = 'TDG' WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580217, ExchCode = 'GER' WHERE SecCode = 5503779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823777, ExchCode = 'AQX' WHERE SecCode = 5503780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663656, ExchCode = 'AQX' WHERE SecCode = 5503782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953657244, ExchCode = 'MXQ' WHERE SecCode = 5503860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 5503898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807449510, ExchCode = 'BCO' WHERE SecCode = 5503900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663650, Ticker = 'ARK3l', ExchCode = 'AQX' WHERE SecCode = 5503901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789414734, ExchCode = 'LAS' WHERE SecCode = 5507430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 5517616 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5521892 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5521893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779309033, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 5521928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787393619, ExchCode = 'TDG' WHERE SecCode = 5523278 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 5534928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836259, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535806, ExchCode = 'MEX' WHERE SecCode = 5539536 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777360183, ExchCode = 'MEX' WHERE SecCode = 5541703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471348, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779561935, ExchCode = 'FRA' WHERE SecCode = 5550738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776857965, ExchCode = 'MEX' WHERE SecCode = 5551974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 5558239 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 5558534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777584027, ExchCode = 'BIV' WHERE SecCode = 5558570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779771107, ExchCode = 'FRA' WHERE SecCode = 5563110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836233, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580185, ExchCode = 'DEU' WHERE SecCode = 5569302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823771, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5569303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110915, Ticker = '3MRNm', ExchCode = 'BCO' WHERE SecCode = 5569367 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IND' WHERE SecCode = 5581589 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 5584724 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 5584725 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 5594901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22004617984, ExchCode = 'DEU' WHERE SecCode = 5607542 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 5623178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793574816, ExchCode = 'TDG' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942898, ExchCode = 'MEX' WHERE SecCode = 5631516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781060493, ExchCode = 'FRA' WHERE SecCode = 5633895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031904157, Ticker = 'LCO3l', ExchCode = 'BCO' WHERE SecCode = 5638747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509910595, ExchCode = 'KAB', PermQuoteRetireDate = '2011-11-01' WHERE SecCode = 5638831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460738, ExchCode = 'FRA' WHERE SecCode = 5638838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460751, ExchCode = 'FRA' WHERE SecCode = 5638843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807449511, Ticker = 'TS2Sl', ExchCode = 'BCO' WHERE SecCode = 5638844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX' WHERE SecCode = 5638860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22065452994, ExchCode = 'BRN' WHERE SecCode = 5645885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781543275, ExchCode = 'STU' WHERE SecCode = 5655040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781343894, ExchCode = 'TDG' WHERE SecCode = 5663580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782381254, ExchCode = 'QTX' WHERE SecCode = 5712413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22072896303, ExchCode = 'TDG' WHERE SecCode = 5715993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028682766, Ticker = '2HENS' WHERE SecCode = 5720895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028890941, ExchCode = 'FRA' WHERE SecCode = 5724940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782653830, ExchCode = 'FRA' WHERE SecCode = 5731414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802025956, ExchCode = 'LAS' WHERE SecCode = 5764717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802153233, Ticker = 'RZ8Bd', ExchCode = 'BCO' WHERE SecCode = 5782810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22107546467, ExchCode = 'BCO' WHERE SecCode = 5782854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 5814866 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 5821084 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596707, ExchCode = 'FRA' WHERE SecCode = 5839460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596711, ExchCode = 'FRA' WHERE SecCode = 5839461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596713, ExchCode = 'FRA' WHERE SecCode = 5839464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596706, ExchCode = 'FRA' WHERE SecCode = 5839466 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5842997 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 5853171 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 5889754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800227924, ExchCode = 'TDG' WHERE SecCode = 5894957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785978750, ExchCode = 'STU' WHERE SecCode = 5907872 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5974244 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 5991185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386190, ExchCode = 'TDG' WHERE SecCode = 6010807 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 6012971 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 6063944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6097315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 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 = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790170885, ExchCode = 'QTX' WHERE SecCode = 6109630 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6120044 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6151857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089872374, ExchCode = 'DEU' WHERE SecCode = 6153962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089867315, ExchCode = 'DEU' WHERE SecCode = 6153964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22090148575, ExchCode = 'DEU' WHERE SecCode = 6155958 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 6167151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013414, Ticker = '2PLTR' WHERE SecCode = 6185541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791216534, ExchCode = 'FRA' WHERE SecCode = 6186428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6190877 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6201126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6232441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792270095, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 6269028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792269534, ExchCode = 'FRA' WHERE SecCode = 6269033 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808950961, ExchCode = 'DEU' WHERE SecCode = 6364834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794094894, ExchCode = 'QTX' WHERE SecCode = 6392491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 6409744 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 6450901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128281486, ExchCode = 'QTX' WHERE SecCode = 6457998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796140986, ExchCode = 'MUN' WHERE SecCode = 6462849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22132054140, ExchCode = 'QTX' WHERE SecCode = 6482759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796557202, ExchCode = 'FRA' WHERE SecCode = 6482768 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 QuotePermID = 236798269749, ExchCode = 'TDG' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 6526490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794669390, ExchCode = 'MEX' WHERE SecCode = 6543895 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 6548154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797797392, ExchCode = 'TDG' WHERE SecCode = 6548155 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ESP' WHERE SecCode = 6568139 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799474943, ExchCode = 'FRA' WHERE SecCode = 6577960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792098121, ExchCode = 'BRN' WHERE SecCode = 6578451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799956966, ExchCode = 'QTX' WHERE SecCode = 6584681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799955916, ExchCode = 'FRA' WHERE SecCode = 6587160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799957446, ExchCode = 'FRA' WHERE SecCode = 6587161 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 6587166 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 6589128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22134134351, ExchCode = 'STU' WHERE SecCode = 6617649 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 6622353 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6626331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451401, ExchCode = 'BTE' WHERE SecCode = 6627463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794616564, ExchCode = 'TDG' WHERE SecCode = 6628842 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 6629299 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802136610, ExchCode = 'FRA' WHERE SecCode = 6629415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802456204, ExchCode = 'DUS' WHERE SecCode = 6638341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471092, ExchCode = 'FRA' WHERE SecCode = 6642930 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6661570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883771519, ExchCode = 'FRA' WHERE SecCode = 6667833 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6680998 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6680999 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 6681000 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 6712504 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804778696, ExchCode = 'MUN' WHERE SecCode = 6721535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167343880, ExchCode = 'DEU' WHERE SecCode = 6728367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339493, ExchCode = 'DEU' WHERE SecCode = 6728368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339476, ExchCode = 'DEU' WHERE SecCode = 6728370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340591, ExchCode = 'DEU' WHERE SecCode = 6728371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167341909, ExchCode = 'DEU' WHERE SecCode = 6728372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167342837, ExchCode = 'DEU' WHERE SecCode = 6728373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167342067, ExchCode = 'DEU' WHERE SecCode = 6728374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339591, ExchCode = 'DEU' WHERE SecCode = 6728375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340584, ExchCode = 'DEU' WHERE SecCode = 6728377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340486, ExchCode = 'DEU' WHERE SecCode = 6728378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799175959, ExchCode = 'BIV' WHERE SecCode = 6728383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167326401, ExchCode = 'GER' WHERE SecCode = 6728389 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6737976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6748867 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6748910 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6773060 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 6779510 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805672065, ExchCode = 'FRA' WHERE SecCode = 6779525 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6782578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805776179, ExchCode = 'MUN' WHERE SecCode = 6782676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806017727.0, IsPrimaryQuote = 1 WHERE SecCode = 6796817 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806017473.0, IsPrimaryQuote = 1 WHERE SecCode = 6796818 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806018559.0, IsPrimaryQuote = 1 WHERE SecCode = 6796824 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1, IsPrimaryInstr = 1 WHERE SecCode = 6796825 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806017771.0, IsPrimaryQuote = 1 WHERE SecCode = 6796828 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806017493.0, IsPrimaryQuote = 1 WHERE SecCode = 6797271 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791406435, ExchCode = 'BIV' WHERE SecCode = 6797364 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'EGGRF', PermQuoteRetireDate = NULL WHERE SecCode = 10776770 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10811185 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 10812719 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 10823840 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 10898081 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'SVN' WHERE SecCode = 10899762 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10960962 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 10961044 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475110262, ExchCode = 'NSQ' WHERE SecCode = 10965319 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 10970708 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11002308 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'NLD', IncCntry = 'NLD' WHERE SecCode = 11003614 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'TUR' WHERE SecCode = 11008454 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11014866 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'UVC', ExchCode = 'CVE' WHERE SecCode = 11016720 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11016760 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 11021549 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 11035422 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11037026 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11041243 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 11051526 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11051841 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 11068150 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'URY' WHERE SecCode = 11079734 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 11105027 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 11108277 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 11133802 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11136104 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11147258 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11149008 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11150874 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11153443 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11154666 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21594564370, PermQuoteStatus = 'AC', Ticker = 'SOHOB', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2016-08-27', PermSecMapEndDate = NULL WHERE SecCode = 11161916 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11166994 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 11171809 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 11173529 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11175196 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 11178268 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 11178969 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11183916 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11185279 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11185629 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727318670, ExchCode = 'MPM' WHERE SecCode = 11191702 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11191932 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 11200719 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 11202674 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232921508558.0, IsPrimaryInstr = 0 WHERE SecCode = 11203030 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232921508558.0 WHERE SecCode = 11206549 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 11207626 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'DEU' WHERE SecCode = 11210726 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'DEU' WHERE SecCode = 11212886 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 11214933 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11224358 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'CYM' WHERE SecCode = 11225543 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232921508558.0 WHERE SecCode = 11231710 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11236613 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11239698 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11250473 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 11255170 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11256581 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 11257062 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11277554 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11281164 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 11288485 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 11290249 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11290974 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11290975 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11290976 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 11290977 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 11292168 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232913707193.0 WHERE SecCode = 11292169 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236806021295, PriTrdQuotePermID = 236806021295.0, ValQuotePermID = 22175032787.0, IsPrimaryQuote = 1, ExchCode = 'NSM' WHERE SecCode = 11294800 AND Type_ = 1;