UPDATE data_universe_permid SET QuotePermID = 21475562090, Ticker = 'AAT.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 13 AND Type_ = 10; 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 PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-12', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141212, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'SIG', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 1413 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21484676855, ExchCode = 'EQD' WHERE SecCode = 2503 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3726 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3727 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3758 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3883 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4798 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5828 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6319 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 6737 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 7493 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836052415, Ticker = 'ZHEH', ExchCode = 'LSE', PermQuoteRetireDate = '2023-05-19' WHERE SecCode = 9121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718461399, Ticker = '0Q1Nl', ExchCode = 'BCO' WHERE SecCode = 9338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836049459, Ticker = 'PACC', ExchCode = 'LSE', PermQuoteRetireDate = '2016-03-07' WHERE SecCode = 9856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475556856, Ticker = 'KPN', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 9908 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 10228 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 10551 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 16592 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'QDMID' WHERE SecCode = 18690 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 22244 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 23685 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951370.0 WHERE SecCode = 24355 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 27115 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 27315 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 27316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 27831 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 28123 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 28670 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 29232 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 29237 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 30447 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 31464 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 OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, IsPrimaryInstr = 0, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'NMS', OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermQuoteRetireDate = '2025-09-15', PermOrgIPODate = '2025-09-15' WHERE SecCode = 32562 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermOrgIPODate = '2025-09-15' WHERE SecCode = 32563 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 33148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475586638, Ticker = 'ANFP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 33925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836326039, ExchCode = 'BER' WHERE SecCode = 34055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475423914, ExchCode = 'MUN', PermQuoteRetireDate = '2007-07-10' WHERE SecCode = 34147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836509909, PermQuoteStatus = 'AC', Ticker = 'RI7', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 34184 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 = 55836462028, ExchCode = 'FRA' WHERE SecCode = 35017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525093864, ExchCode = 'CHI' WHERE SecCode = 35316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475405461, ExchCode = 'MUN' WHERE SecCode = 35324 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610381382, ExchCode = 'DEU' WHERE SecCode = 35393 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 35401 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475445911, ExchCode = 'GER' WHERE SecCode = 35412 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474912364, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 35414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475050944, ExchCode = 'TDG' WHERE SecCode = 35419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475051127, ExchCode = 'TDG' WHERE SecCode = 35457 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951430.0 WHERE SecCode = 35585 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836326453, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-28' WHERE SecCode = 35663 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096765227 WHERE SecCode = 35958 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 36443 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 36479 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474892656, Ticker = 'CRGi', ExchCode = 'TRQ', PermQuoteRetireDate = '2023-09-11' WHERE SecCode = 36926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474854531, ExchCode = 'DEU', PermQuoteRetireDate = '2016-07-29', PermSecMapEndDate = '2016-07-29' WHERE SecCode = 36930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475902741, ExchCode = 'MUN' WHERE SecCode = 36936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474898884, ExchCode = 'DEU' WHERE SecCode = 36943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034226, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2011-05-04' WHERE SecCode = 37067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513072773, ExchCode = 'STU' WHERE SecCode = 37118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474877435, ExchCode = 'DEU' WHERE SecCode = 37133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887741273, ExchCode = 'GTX' WHERE SecCode = 37139 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 37542 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 37558 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2000-06-15' WHERE SecCode = 37609 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475437280, ExchCode = 'GER' WHERE SecCode = 37861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836326328, ExchCode = 'BER', PermQuoteRetireDate = '2008-08-28' WHERE SecCode = 38185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613993964, ExchCode = 'FRA' WHERE SecCode = 38188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035350, ExchCode = 'TDG' WHERE SecCode = 38248 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 39088 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 39089 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 42507 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2014-01-10' WHERE SecCode = 42536 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 43244 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 43289 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 43290 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 43390 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 44617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489580, ExchCode = 'QTX' WHERE SecCode = 45029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475541914, ExchCode = 'MUN', PermQuoteRetireDate = '2010-01-13' WHERE SecCode = 45085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576247713, ExchCode = 'STU' WHERE SecCode = 45088 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096762193, PermOrgIPODate = '1993-10-27' WHERE SecCode = 45120 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836324683, ExchCode = 'BER' WHERE SecCode = 45854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838512918, PermQuoteStatus = 'AC', Ticker = 'EGID', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 45916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838240996, ExchCode = 'MUN' WHERE SecCode = 46009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475275701, ExchCode = 'MUN' WHERE SecCode = 46026 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492791, ExchCode = 'QTX', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 46294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329172, PermQuoteStatus = 'DC', Ticker = 'GVM', ExchCode = 'BER', PermQuoteRetireDate = '2022-07-06' WHERE SecCode = 46388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838506971, ExchCode = 'STU' WHERE SecCode = 46390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328604, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801449047, ExchCode = 'DEU' WHERE SecCode = 47312 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474843390, ExchCode = 'DEU' WHERE SecCode = 48131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836326162, ExchCode = 'BER' WHERE SecCode = 48350 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 48805 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 49481 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 49482 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 49768 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951805.0 WHERE SecCode = 50090 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 50144 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WHLMD' WHERE SecCode = 50157 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 51257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690644536, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 51563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475047482, ExchCode = 'DUS' WHERE SecCode = 51564 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 52306 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 53012 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 53235 AND Type_ = 10; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 53360 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475644098, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'BER', PermQuoteRetireDate = '2005-04-12' WHERE SecCode = 53479 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836455246, ExchCode = 'FRA', PermQuoteRetireDate = '2011-10-31' WHERE SecCode = 53520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795166785, ExchCode = 'FRA' WHERE SecCode = 53688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667483439, ExchCode = 'QTX' WHERE SecCode = 53702 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 53984 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 54101 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096776198 WHERE SecCode = 54845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475606794, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 54890 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 55002 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 55003 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 55088 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 55173 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 55579 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 55680 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 55887 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 55923 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 57778 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 59033 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 59263 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 59270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836397121, ValQuotePermID = 55836397121.0, ExchCode = 'FRA' WHERE SecCode = 59308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474924570, Ticker = 'BTBB', ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06' WHERE SecCode = 59414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323690, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 59989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341349, ExchCode = 'BER', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 60007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659647, ExchCode = 'LAS' WHERE SecCode = 60024 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837354811, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60061 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830302241, ExchCode = 'GTX' WHERE SecCode = 60111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837354133, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838241304, ExchCode = 'MUN', PermQuoteRetireDate = '2011-08-24' WHERE SecCode = 60122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837356678, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836391248, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-27' WHERE SecCode = 60168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382500, ExchCode = 'LAS' WHERE SecCode = 60190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474961910, ExchCode = 'DEU', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 60202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328139, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 60233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327473, ExchCode = 'BER' WHERE SecCode = 60236 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096776198 WHERE SecCode = 60244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856975539, ExchCode = 'FRA' WHERE SecCode = 60247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836487337, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-03' WHERE SecCode = 60248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330718, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 60261 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 60302 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 60303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838243903, ExchCode = 'MUN', PermQuoteRetireDate = '2015-02-06' WHERE SecCode = 60328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836333544, ExchCode = 'BER', PermQuoteRetireDate = '2012-06-27' WHERE SecCode = 60381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334364, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 60392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327078, ExchCode = 'BER' WHERE SecCode = 60398 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475448597, ExchCode = 'STU', PermQuoteRetireDate = '2008-09-09' WHERE SecCode = 60559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337411, ExchCode = 'BER' WHERE SecCode = 60569 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836340385, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 60630 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475277731, ExchCode = 'MUN', PermQuoteRetireDate = '2007-01-03' WHERE SecCode = 60644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475572974, Ticker = 'NSUG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386106, ExchCode = 'LAS' WHERE SecCode = 60683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836467814, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-08' WHERE SecCode = 60772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518999038, ExchCode = 'FRA' WHERE SecCode = 60844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475524418, ExchCode = 'GER' WHERE SecCode = 60903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197237, ExchCode = 'DEU' WHERE SecCode = 61006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55846063873, ExchCode = 'FRA' WHERE SecCode = 61281 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608399459, ExchCode = 'DEU' WHERE SecCode = 61371 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 61428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836392107, ExchCode = 'FRA', PermQuoteRetireDate = '2014-06-02' WHERE SecCode = 61442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838349451, ExchCode = 'STU' WHERE SecCode = 61517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836410302, ExchCode = 'FRA' WHERE SecCode = 61599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836451985, ExchCode = 'FRA', PermQuoteRetireDate = '2017-07-12' WHERE SecCode = 61724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837366059, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 61867 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, IsPrimaryInstr = 0, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermOrgIPODate = '2025-09-15' WHERE SecCode = 61904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 62101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475458426, ExchCode = 'STU' WHERE SecCode = 62165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605378795, ExchCode = 'STU' WHERE SecCode = 62253 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830311549, ExchCode = 'GTX' WHERE SecCode = 62300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033713, PermQuoteStatus = 'AC', Ticker = 'AK3', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 62376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550981064, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757240136, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 62430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836429999, ExchCode = 'FRA' WHERE SecCode = 62434 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018990, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-16', PermSecMapEndDate = '2023-08-16' WHERE SecCode = 62512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341618, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 62845 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 63361 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 63729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474888905, PermQuoteStatus = 'AC', Ticker = 'YUIA', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 63767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475007260, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 63781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478545875, ExchCode = 'TDG' WHERE SecCode = 63834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339604, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 63854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620987433, ExchCode = 'GER' WHERE SecCode = 63859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620457863, ExchCode = 'STU' WHERE SecCode = 63875 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 63995 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 64077 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 64316 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 64418 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 64798 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 64853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667487584, ExchCode = 'QTX' WHERE SecCode = 65586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794054785, ExchCode = 'FRA' WHERE SecCode = 66737 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 67561 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 67732 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 67740 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 68182 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 68629 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 69973 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 69984 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 70919 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 71866 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 72106 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 72964 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951610.0 WHERE SecCode = 73557 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951989.0 WHERE SecCode = 73818 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 74273 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 74556 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'GA8', PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 74740 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 74899 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096776198 WHERE SecCode = 74992 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 74993 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-21', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 75258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838787463, InstrPermID = 8590012870, ValQuotePermID = 55838787463.0, PermSecMapStartDate = '2000-02-22' WHERE SecCode = 75416 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951274.0 WHERE SecCode = 75919 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 76313 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 76836 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 76948 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 76949 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 77942 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758315, PermOrgIPODate = '1997-02-10' WHERE SecCode = 78176 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 78834 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 78901 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ANTELOPUS' WHERE SecCode = 79139 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = NULL WHERE SecCode = 80309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524860585, ExchCode = 'AUX' WHERE SecCode = 80783 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 81533 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 82035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838792474, InstrPermID = 8590011819, ValQuotePermID = 55838792474.0, PermSecMapStartDate = '2001-09-13' WHERE SecCode = 82146 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 82468 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 82610 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 82729 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 83038 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 83172 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 55836397121.0 WHERE SecCode = 83306 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 83863 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 84313 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 84791 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 85191 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 85727 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 85951 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 86007 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 86411 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87027 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5095369017, PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 87602 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'PMXSF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-17', PermSecMapEndDate = NULL WHERE SecCode = 87643 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 87767 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 88223 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 88335 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 88336 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 88378 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 88557 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 90297 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 90372 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 90958 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-15' WHERE SecCode = 90983 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'NEXGBINA' WHERE SecCode = 91350 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 92234 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 92955 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 93359 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 93473 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 93474 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5095369017, PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 95997 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'MNX.H', ExchCode = 'NEX' WHERE SecCode = 96381 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 96922 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951889.0 WHERE SecCode = 97070 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 97211 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951616.0 WHERE SecCode = 97291 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951616.0 WHERE SecCode = 97292 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 97387 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951889.0 WHERE SecCode = 97418 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-17' WHERE SecCode = 97479 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55834997382, InstrPermID = 8590928464, ValQuotePermID = 55834997382.0, PermSecMapStartDate = '1990-03-23' WHERE SecCode = 97525 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SAF.H', ExchCode = 'NEX' WHERE SecCode = 97729 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'CEMPRO' WHERE SecCode = 97785 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 98900 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 99011 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WAGR.H', ExchCode = 'NEX' WHERE SecCode = 99087 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = NULL WHERE SecCode = 99138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834788915, InstrPermID = 8589984984, ValQuotePermID = 55834788915.0, PermSecMapStartDate = '1995-01-19' WHERE SecCode = 99172 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 99535 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 99982 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096776198 WHERE SecCode = 100020 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU', PermSecMapStartDate = '2025-09-18' WHERE SecCode = 100032 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 100097 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 100102 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 100312 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558535028, ExchCode = 'BCO', PermQuoteRetireDate = '2023-12-22' WHERE SecCode = 100614 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17' WHERE SecCode = 100742 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 102103 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ALXIL' WHERE SecCode = 102258 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 103573 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 103597 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 103899 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 105011 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SYA', PermSecMapEndDate = NULL WHERE SecCode = 111747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571420277, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 111938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21486937555, ExchCode = 'STU' WHERE SecCode = 112025 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335260, ExchCode = 'BER' WHERE SecCode = 112035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544726152, ExchCode = 'DEU' WHERE SecCode = 112043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808390660, ExchCode = 'FRA' WHERE SecCode = 112049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21870865253, ExchCode = 'FRA' WHERE SecCode = 112064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661189444, ExchCode = 'FRA' WHERE SecCode = 112078 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000480221, ExchCode = 'DEU' WHERE SecCode = 112079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295811, ExchCode = 'GTX' WHERE SecCode = 112129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419772, ExchCode = 'HAM' WHERE SecCode = 112135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332781, ExchCode = 'BER' WHERE SecCode = 112143 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527717624, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475134932, Ticker = 'DFK0', ExchCode = 'FRA', PermSecMapStartDate = '2012-01-19' WHERE SecCode = 112657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384599, ExchCode = 'LAS' WHERE SecCode = 113578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624943988, ExchCode = 'FRA' WHERE SecCode = 114028 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 114636 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 114658 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 115074 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 116316 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 116794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298391, ExchCode = 'FRA' WHERE SecCode = 117723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525931704, ExchCode = 'STU' WHERE SecCode = 117727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488397, ExchCode = 'QTX' WHERE SecCode = 119129 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 119773 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 120434 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 121155 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 122629 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784383101, ExchCode = 'LAS' WHERE SecCode = 123718 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 126933 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 127415 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 128710 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'FRA' WHERE SecCode = 128719 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5095369017, PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 128769 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'BEL' WHERE SecCode = 128885 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525789042, ExchCode = 'FRA' WHERE SecCode = 131777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957764680, ExchCode = 'FRA' WHERE SecCode = 131976 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 132068 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 132725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836390769, ExchCode = 'FRA' WHERE SecCode = 133773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795104269, ExchCode = 'QTX' WHERE SecCode = 133778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789865785, InstrPermID = 232870988381, OrgPermID = 5086485920, ValQuotePermID = 236789865785.0, PriInstrPermID = 232870988381.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, Ticker = 'EUROPRATIK', ExchCode = 'NSI', OrgTypeCode = 'COM', IncCntry = 'IND', PriTRBCIndPermID = 4294951519.0, PermOrgIPODate = '2025-09-23', PermSecMapStartDate = '2025-09-22' WHERE SecCode = 134942 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951677.0 WHERE SecCode = 135463 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096765227 WHERE SecCode = 137384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474961867, ExchCode = 'DEU' WHERE SecCode = 137691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521224187, ExchCode = 'STU' WHERE SecCode = 137791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842886562, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 137794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560378012, PermQuoteStatus = 'DC', Ticker = 'JNJz', ExchCode = 'CHI', PermQuoteRetireDate = '2019-10-02', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 137860 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 137869 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 138787 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 138997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796059845, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-17', PermSecMapEndDate = NULL WHERE SecCode = 139758 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1DD', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 140027 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 140041 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 140167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667487476, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 140786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869021455, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 140824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294365, ExchCode = 'GTX' WHERE SecCode = 140826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335868, ExchCode = 'BER' WHERE SecCode = 140843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591673619, ExchCode = 'STU' WHERE SecCode = 141004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475140561, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 141175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21875114022, ExchCode = 'TDG' WHERE SecCode = 141182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617741762, ExchCode = 'TDG' WHERE SecCode = 141184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484240, ExchCode = 'QTX' WHERE SecCode = 141232 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 141446 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 141593 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CQT' WHERE SecCode = 141616 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 141788 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 142191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21507475103, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-10', PermSecMapEndDate = NULL WHERE SecCode = 143069 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296552, ExchCode = 'GTX' WHERE SecCode = 143197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295736, ExchCode = 'GTX' WHERE SecCode = 143198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21497500363, ExchCode = 'STU' WHERE SecCode = 143201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21574086997, PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 143248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 144012 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 144500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552519207, ExchCode = 'DUS', PermQuoteRetireDate = '2014-12-16' WHERE SecCode = 144542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520583826, ExchCode = 'TDG' WHERE SecCode = 144735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611106182, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 144853 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 145409 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 145496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526396053, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2017-04-24' WHERE SecCode = 145644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793968535, ExchCode = 'FRA' WHERE SecCode = 146440 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 146978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793690706, ExchCode = 'FRA' WHERE SecCode = 147011 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'A98' WHERE SecCode = 147190 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485573, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 150289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770833011, ExchCode = 'DEU', PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 150485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747575646, ExchCode = 'QTX' WHERE SecCode = 150488 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875315, PermQuoteStatus = 'AC', Ticker = 'NGQ1', PermQuoteRetireDate = NULL WHERE SecCode = 150515 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 150711 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 152731 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21667484065, ExchCode = 'QTX' WHERE SecCode = 161315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23' WHERE SecCode = 169894 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 175341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540740430, ExchCode = 'DEU' WHERE SecCode = 175561 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 175849 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 177307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622517895, ExchCode = 'DEU' WHERE SecCode = 177315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856949142, ExchCode = 'GER' WHERE SecCode = 177328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836489072, ExchCode = 'FRA' WHERE SecCode = 177415 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 178039 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 178267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128769282, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-18', PermSecMapEndDate = NULL WHERE SecCode = 178338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380371, ExchCode = 'LAS' WHERE SecCode = 178391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523649406, ExchCode = 'FRA' WHERE SecCode = 178451 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096776198 WHERE SecCode = 178496 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 178497 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'DPU0', PermSecMapEndDate = NULL WHERE SecCode = 180252 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566116516, ExchCode = 'STU' WHERE SecCode = 186400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536544263, ExchCode = 'DEU' WHERE SecCode = 186428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569833, ExchCode = 'QTX' WHERE SecCode = 186811 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 190206 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'VESTD' WHERE SecCode = 193821 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 194198 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 201959 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 202318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509902864, Ticker = 'SOYP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 202732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850634826, PermQuoteStatus = 'DC', Ticker = 'IY3', ExchCode = 'STU', PermQuoteRetireDate = '2014-08-08' WHERE SecCode = 206847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419395, ExchCode = 'HAM' WHERE SecCode = 210711 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 214378 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 248615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610591242, ExchCode = 'TDG' WHERE SecCode = 248924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474917055, ExchCode = 'DEU' WHERE SecCode = 248925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789587576, Ticker = 'TYPd', ExchCode = 'BCO' WHERE SecCode = 248961 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 252477 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 261188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512264643, PriTrdQuotePermID = 25727370253.0, ValQuotePermID = 21475535100.0, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', Ticker = 'FLNGo', ExchCode = 'STO', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 286050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836325722, ExchCode = 'BER' WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323052, ExchCode = 'BER', PermQuoteRetireDate = '2014-01-22' WHERE SecCode = 288474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724373346, ExchCode = 'DEU' WHERE SecCode = 290846 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-21' WHERE SecCode = 294471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794261329, ExchCode = 'DEU' WHERE SecCode = 296129 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 298296 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 298972 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-16' WHERE SecCode = 301073 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 301508 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 302126 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'MBRF3' WHERE SecCode = 302757 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SBM.H', ExchCode = 'NEX' WHERE SecCode = 306578 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 310249 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 310250 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 310251 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 312877 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 314726 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CALCHA-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 319996 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'OROBCO-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 319998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792995980, ExchCode = 'FRA' WHERE SecCode = 320838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836054231, Ticker = 'XMAD', ExchCode = 'LSE' WHERE SecCode = 321193 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'SHMLF', PermQuoteRetireDate = NULL WHERE SecCode = 323913 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 324814 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 325062 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'ARLCF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 326045 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 326718 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 326763 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19' WHERE SecCode = 328229 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'HNYKF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 328575 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 329205 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 330608 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'YDKG' WHERE SecCode = 331506 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096760835, PermOrgIPODate = '2007-11-19' WHERE SecCode = 331648 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727370253, PriTrdQuotePermID = 25727370253.0, ValQuotePermID = 21475535100.0, IsPrimaryQuote = 1, ExchCode = 'NYS' WHERE SecCode = 334255 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL WHERE SecCode = 334399 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 334411 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 336186 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'TLSMF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 336207 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365381.0 WHERE SecCode = 336707 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 337020 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, PermQuoteStatus = 'DC', Ticker = NULL, DomCntry = 'CYM', IncCntry = 'CYM', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = '2007-07-20', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 337161 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 340814 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 346209 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 347970 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 348558 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'RBLK' WHERE SecCode = 358137 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951202.0 WHERE SecCode = 358625 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 367737 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 369126 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 381015 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 383684 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 383685 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 383686 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 383687 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 383688 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 383689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841145046, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 392215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843596535, ValQuotePermID = 55843596535.0, ExchCode = 'FRA' WHERE SecCode = 427461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847269156, PermQuoteStatus = 'AC', Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 502602 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CALCHA-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 502603 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 502605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 516109 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 521487 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 521905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55879740079, Ticker = 'COM.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 523414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 537213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2000-06-15' WHERE SecCode = 546634 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 546636 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 558354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128988850, ExchCode = 'DEU', PermSecMapStartDate = '2025-09-19' WHERE SecCode = 558485 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 559630 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 560461 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 561528 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 561537 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 586040 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 594167 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 595308 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 607528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 690423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55863112368, Ticker = 'BABC.GB', ExchCode = 'PLU' WHERE SecCode = 703518 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'NORTE-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 710333 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 793739 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 820819 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 847318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951908.0 WHERE SecCode = 913819 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2000-06-15' WHERE SecCode = 943759 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CALCHA-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 977206 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 982550 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'NOVKAN' WHERE SecCode = 1030653 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 1092978 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 1111996 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951443.0 WHERE SecCode = 1112008 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 1122444 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1122529 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CALCHA-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 1124186 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 PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 1286597 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 1290571 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 1295970 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 1310480 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1DD' WHERE SecCode = 1372743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21481777624, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 1453952 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 1459005 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 1459134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478824473, ExchCode = 'TDG' WHERE SecCode = 1480701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21480791079, ExchCode = 'STO' WHERE SecCode = 1481237 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 1488264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21490163342, Ticker = 'GSD', ExchCode = 'STU', PermQuoteRetireDate = '2014-03-06' WHERE SecCode = 1489390 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 1494199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653590213, ExchCode = 'FRA' WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21484181633, ExchCode = 'FRA' WHERE SecCode = 1525503 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'R9G0' WHERE SecCode = 1533545 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537129370, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2015-02-10' WHERE SecCode = 1555489 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 1622683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 1712339 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 1712382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-22' WHERE SecCode = 1997923 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 1998237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184306, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-19', PermSecMapEndDate = NULL WHERE SecCode = 2085430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562213812, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-04' WHERE SecCode = 2085533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785264817, ExchCode = 'FRA' WHERE SecCode = 2087993 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2191538 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 2193119 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 2217733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522907490, Ticker = 'EEE', ExchCode = 'ATH' WHERE SecCode = 2226945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370247, ExchCode = 'SGO' WHERE SecCode = 2232870 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'GA8', PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 2255680 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'POTAA-OSA', PermQuoteRetireDate = '2025-10-14', PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 2326949 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2024-12-02', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 2338207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796022220, ValQuotePermID = 236796022220.0, Ticker = 'TIGERLOGS', ExchCode = 'NSI' WHERE SecCode = 2349750 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2382439 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2383371 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SYA' WHERE SecCode = 2384507 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2453146 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-14' WHERE SecCode = 2483617 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 2490826 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 2505948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609327643, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-22' WHERE SecCode = 2522906 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'NORTE-OSA', PermQuoteRetireDate = '2025-10-14', PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 2531736 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 2533439 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2014-01-10' WHERE SecCode = 2537377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21908261047, Ticker = '1AAPLm', ExchCode = 'EQD' WHERE SecCode = 2571666 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2586430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2600077 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2623925 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 2623937 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2678895 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2014-01-10' WHERE SecCode = 2679900 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2014-01-10' WHERE SecCode = 2679907 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2014-01-10' WHERE SecCode = 2679929 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2682275 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1DD' WHERE SecCode = 2711209 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2752930 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'GA8', PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 2800403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322234, ExchCode = 'FRA' WHERE SecCode = 2812145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791214983, ExchCode = 'BIV' WHERE SecCode = 2812150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557544170, ExchCode = 'MUN', PermQuoteRetireDate = '2018-07-05' WHERE SecCode = 2837420 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2846557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761799, ExchCode = 'DEU' WHERE SecCode = 2856999 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 2860623 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 2861758 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 2880948 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 2883520 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2909909 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 2912889 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2915044 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 2915745 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 2919785 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128985207, ExchCode = 'TDG' WHERE SecCode = 2935962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 2960913 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 3015754 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 3028492 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3032215 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 3059403 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 3072619 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 3076182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916285720, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 3101373 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2000-06-15' WHERE SecCode = 3118911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621432674, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 3121289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621432527, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 3121290 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-17', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 3124290 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 3150892 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '1N5' WHERE SecCode = 3177608 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3181360 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 3184000 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3195638 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 3201363 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3201372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 3211361 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-21' WHERE SecCode = 3213375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720719093, ExchCode = 'BER', PermQuoteRetireDate = '2023-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3215568 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 3225989 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 25727370253.0, ValQuotePermID = 21475535100.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 3234677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596019988, ExchCode = 'DEU' WHERE SecCode = 3245391 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951315.0 WHERE SecCode = 3245596 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3260117 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3260793 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 3266303 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2000-06-15' WHERE SecCode = 3275885 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 3276222 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3276422 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3276488 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 3276918 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604352845, ExchCode = 'STU' WHERE SecCode = 3283650 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 3285597 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 3288947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22112085792, PermQuoteStatus = 'AC', Ticker = 'SGLDa', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3301728 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 3307821 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3309732 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3316489 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3318951 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3319137 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3320068 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'XRA' WHERE SecCode = 3320330 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 3338654 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3344725 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3345831 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3371092 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617889188, ExchCode = 'CHA' WHERE SecCode = 3378309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21867512394, ExchCode = 'FRA' WHERE SecCode = 3378316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636815378, Ticker = '0Q1F', ExchCode = 'LSE' WHERE SecCode = 3378492 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796060148, ExchCode = 'CHI' WHERE SecCode = 3392282 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3395245 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3400262 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3401450 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3401708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718790762, ExchCode = 'CHI' WHERE SecCode = 3404188 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3404549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141123, ExchCode = 'FRA' WHERE SecCode = 3405304 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3407672 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 3408516 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'OB1DD' WHERE SecCode = 3409377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664959898, ExchCode = 'BER' WHERE SecCode = 3418906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632630922, ExchCode = 'FRA', PermQuoteRetireDate = '2025-02-26', PermSecMapEndDate = '2025-02-26' WHERE SecCode = 3428077 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 3429657 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 3431747 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-22' WHERE SecCode = 3431819 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 3431846 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 3432727 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 3432953 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3433101 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3441196 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3441322 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 3446354 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 3446889 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3491811 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3491875 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3503563 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 3513949 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3513998 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 3526140 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3555905 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 3560287 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 3571379 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5091621193, PriInstrPermID = 232900571591.0, IsPrimaryInstr = 0, PermQuoteStatus = 'DC', OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951361.0, PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = '2025-09-15' WHERE SecCode = 3586968 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 3587013 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3599726 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3625877 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 3634457 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3635529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = 25727370253.0, ValQuotePermID = 21475535100.0 WHERE SecCode = 3671114 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 3716979 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3717226 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951697.0 WHERE SecCode = 3731082 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703807976, PermQuoteStatus = 'AC', Ticker = 'VUSAm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3736025 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3741443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383019, ExchCode = 'MEX' WHERE SecCode = 3746656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681016508, ExchCode = 'STU' WHERE SecCode = 3746657 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 3756335 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 3779974 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3780016 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19' WHERE SecCode = 3792582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461787, ExchCode = 'FRA' WHERE SecCode = 3793374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785774618, ExchCode = 'FRA' WHERE SecCode = 3793376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704497, ExchCode = 'MXQ' WHERE SecCode = 3793437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704296, ExchCode = 'MXQ' WHERE SecCode = 3793438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830302072, ExchCode = 'GTX' WHERE SecCode = 3798050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727376337, ExchCode = 'MEX' WHERE SecCode = 3798054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727376097, ExchCode = 'MEX' WHERE SecCode = 3799556 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3809957 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3813284 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3818507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21692561684, ExchCode = 'DEU' WHERE SecCode = 3818674 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371514, ExchCode = 'BIV' WHERE SecCode = 3849233 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3852818 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 3858018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727369832, ExchCode = 'MEX' WHERE SecCode = 3868466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700245385, ExchCode = 'DEU' WHERE SecCode = 3871754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21704921848, ExchCode = 'DEU' WHERE SecCode = 3906532 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096776198 WHERE SecCode = 3966593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731261056, Ticker = '0A2Zl', ExchCode = 'BCO' WHERE SecCode = 3986787 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CPAY*' WHERE SecCode = 3999455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720521406, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4010838 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4018434 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4018527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 4031760 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4032036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184457, Ticker = 'FARONh', ExchCode = 'SIU' WHERE SecCode = 4033113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727358583, ExchCode = 'BIV' WHERE SecCode = 4038260 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '3UN0' WHERE SecCode = 4043173 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4046425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796059848, ExchCode = 'FRA', PermSecMapStartDate = '2025-09-17' WHERE SecCode = 4046669 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 4066232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21733309946, ExchCode = 'FRA' WHERE SecCode = 4087855 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 4101078 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4109363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738226580, ExchCode = 'BER' WHERE SecCode = 4124713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727352699, ExchCode = 'MEX' WHERE SecCode = 4134210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739310110, ExchCode = 'DEU' WHERE SecCode = 4134386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471110, ExchCode = 'GTX', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4134496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744918743, ExchCode = 'DEU' WHERE SecCode = 4193439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727351142, ExchCode = 'BIV' WHERE SecCode = 4195318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727350451, ExchCode = 'BIV' WHERE SecCode = 4212368 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4225963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534038, ExchCode = 'DUS' WHERE SecCode = 4251502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 4275425 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4286247 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 4291243 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 4303829 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4319661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099428300, ExchCode = 'DEU' WHERE SecCode = 4341660 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4348080 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4371536 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4388104 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 4388410 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4394733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786088093, ExchCode = 'BER' WHERE SecCode = 4394760 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780228924, ExchCode = 'GTX', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 4400159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991977, ExchCode = 'FRA' WHERE SecCode = 4410618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896376172, ExchCode = 'DEU' WHERE SecCode = 4410619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829123402, ExchCode = 'STU' WHERE SecCode = 4410622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4419213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780353097, ExchCode = 'DUS' WHERE SecCode = 4420922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779091516, ExchCode = 'MXQ' WHERE SecCode = 4422396 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 4427846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951908.0 WHERE SecCode = 4441555 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 4443925 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 4447189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783749210, ExchCode = 'QTX' WHERE SecCode = 4449676 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 4456219 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096759636, OrgTypeCode = 'COM', PermOrgIPODate = '2013-01-05' WHERE SecCode = 4456241 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4470358 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17' WHERE SecCode = 4472905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21712131273, ExchCode = 'DEU' WHERE SecCode = 4474227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 4499280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798385267, ExchCode = 'DEU' WHERE SecCode = 4502472 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798564611, ExchCode = 'DEU' WHERE SecCode = 4502501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727287359, ExchCode = 'MEX' WHERE SecCode = 4505578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285167, ExchCode = 'GTX' WHERE SecCode = 4511507 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 4515752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836067, PermQuoteRetireDate = '2023-04-26' WHERE SecCode = 4536443 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 4548098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811320414, ExchCode = 'BER' WHERE SecCode = 4550761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381354, ExchCode = 'LAS' WHERE SecCode = 4557929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385286, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-10', PermSecMapEndDate = NULL WHERE SecCode = 4568425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777449320, ExchCode = 'TDG' WHERE SecCode = 4568460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809547031, ExchCode = 'DEU' WHERE SecCode = 4568462 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 4570291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991715, ExchCode = 'DEU' WHERE SecCode = 4573512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 4580740 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4586596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 4588248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812338173, ExchCode = 'MUN', PermQuoteRetireDate = '2023-08-09' WHERE SecCode = 4588258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785979680, ExchCode = 'FRA' WHERE SecCode = 4588269 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4588275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778820333, ExchCode = 'QTX' WHERE SecCode = 4595746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387236, ExchCode = 'LAS' WHERE SecCode = 4609996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22107546462, Ticker = 'ABTCa', ExchCode = 'BCO' WHERE SecCode = 4613095 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4613936 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4618015 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818936644, Ticker = 'TGLD', ExchCode = 'SWX', PermQuoteRetireDate = '2023-01-11', PermSecMapEndDate = '2023-01-11' WHERE SecCode = 4620075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818936763, Ticker = 'TPLT', ExchCode = 'SWX', PermQuoteRetireDate = '2023-01-11' WHERE SecCode = 4620077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819293770, ExchCode = 'TDG' WHERE SecCode = 4620160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816912799, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-14' WHERE SecCode = 4620951 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4622039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778181553, ExchCode = 'STU' WHERE SecCode = 4623226 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4624288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818729626, ExchCode = 'FRA', PermQuoteRetireDate = '2021-06-22', PermSecMapEndDate = NULL WHERE SecCode = 4631952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727246040, Ticker = 'BBARD', ExchCode = 'BUE' WHERE SecCode = 4639651 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 4639746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823512265, ExchCode = 'DEU' WHERE SecCode = 4640286 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4646622 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 4655498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829125937, ExchCode = 'FRA' WHERE SecCode = 4664716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21829398967, ExchCode = 'STU' WHERE SecCode = 4664721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831537244, ExchCode = 'MUN' WHERE SecCode = 4671286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831570623, ExchCode = 'DEU' WHERE SecCode = 4671288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727247060, ExchCode = 'BIV' WHERE SecCode = 4671296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835618383, ExchCode = 'FRA' WHERE SecCode = 4682735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793284943, ExchCode = 'TDG' WHERE SecCode = 4682737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 4697293 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4699239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794769101, ExchCode = 'LAS' WHERE SecCode = 4724684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727232949, ExchCode = 'BIV' WHERE SecCode = 4730036 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 4731829 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 4731830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847351964, ExchCode = 'FRA' WHERE SecCode = 4733108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569865, ExchCode = 'QTX' WHERE SecCode = 4745386 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4751051 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4754825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439422, ExchCode = 'DUS' WHERE SecCode = 4756621 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 4767877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856492172, ValQuotePermID = 21856492172.0, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4771748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 4787314 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4804560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904412215, ExchCode = 'GTX' WHERE SecCode = 4810002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 4821625 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'PSKY' WHERE SecCode = 4824357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879552085, ExchCode = 'TDG' WHERE SecCode = 4827911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796263483, Ticker = '544522', ExchCode = 'BSE' WHERE SecCode = 4829189 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4846938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4871146 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4873686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386324, ExchCode = 'LAS' WHERE SecCode = 4885536 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4890295 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945198768, ExchCode = 'BER' WHERE SecCode = 4890357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21875131252, ExchCode = 'FRA' WHERE SecCode = 4893235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21875612276, ExchCode = 'QTX', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 4893294 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 4895650 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CQT' WHERE SecCode = 4897799 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 4906501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727203536, ExchCode = 'BIV' WHERE SecCode = 4918915 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22127917741.0 WHERE SecCode = 4920696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881998635, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-25', PermSecMapEndDate = '2022-03-25' WHERE SecCode = 4934327 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4940670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 4949547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884030447, ExchCode = 'MUN' WHERE SecCode = 4949697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893301199, ExchCode = 'GTX' WHERE SecCode = 4952512 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 4952520 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22127917741.0 WHERE SecCode = 4956700 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 4970757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888279764, ExchCode = 'MUN' WHERE SecCode = 4972276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4991495 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895997562, ExchCode = 'STU' WHERE SecCode = 4991558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892046990, ExchCode = 'GTX' WHERE SecCode = 4991559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 5037215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863949618, ExchCode = 'PFT' WHERE SecCode = 5040232 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 5054835 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901209599, ExchCode = 'DEU' WHERE SecCode = 5059306 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901209490, ExchCode = 'FRA' WHERE SecCode = 5059308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659538, ExchCode = 'LAS' WHERE SecCode = 5067501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569848, ExchCode = 'QTX' WHERE SecCode = 5067503 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'PRM*' WHERE SecCode = 5072154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2017-12-01' WHERE SecCode = 5101402 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5104594 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951989.0 WHERE SecCode = 5112408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910716265, ExchCode = 'FRA' WHERE SecCode = 5116970 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5121859 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5126196 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5130678 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 5132732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950535489, ExchCode = 'FRA' WHERE SecCode = 5134589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387466, ExchCode = 'LAS' WHERE SecCode = 5140200 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2002-07-24' WHERE SecCode = 5147886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380648, ExchCode = 'LAS' WHERE SecCode = 5156833 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'OROBCO-OSA', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 5161273 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CALCHA-OSA', PermQuoteRetireDate = '2025-10-14', PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 5161290 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 5161291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896005416, ExchCode = 'MXQ' WHERE SecCode = 5161445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920980941, Ticker = 'Z6M0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 5168340 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388864, ExchCode = 'LAS' WHERE SecCode = 5174430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21922253632, ExchCode = 'FRA' WHERE SecCode = 5176822 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 22127917741.0 WHERE SecCode = 5206286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928854434, ExchCode = 'GTX' WHERE SecCode = 5209798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936132598, ExchCode = 'DEU' WHERE SecCode = 5218830 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5057309462, DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2007-07-20' WHERE SecCode = 5223372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'W1N0' WHERE SecCode = 5249285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933395668, ExchCode = 'FRA' WHERE SecCode = 5253712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935009367, ExchCode = 'CHA' WHERE SecCode = 5261340 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'G7I0' WHERE SecCode = 5265003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397463, Ticker = 'PB7d', ExchCode = 'BTE' WHERE SecCode = 5269462 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5269477 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937069015, ExchCode = 'STU' WHERE SecCode = 5272089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789587852, ExchCode = 'QTX' WHERE SecCode = 5277530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21942349169, ExchCode = 'QTX' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659544, ExchCode = 'LAS' WHERE SecCode = 5315601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397462, Ticker = 'CQ0d', ExchCode = 'BTE', PermQuoteRetireDate = '2025-05-27' WHERE SecCode = 5320940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777698959, ExchCode = 'TDG' WHERE SecCode = 5322460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381675, ExchCode = 'LAS' WHERE SecCode = 5324084 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949435332, ExchCode = 'GTX' WHERE SecCode = 5332356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777252955, ExchCode = 'HAM' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950815916, ExchCode = 'DEU' WHERE SecCode = 5343552 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5095369017, PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5349578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952626936, ExchCode = 'DEU' WHERE SecCode = 5349683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952832380, ExchCode = 'FRA' WHERE SecCode = 5350576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891323, ExchCode = 'STU' WHERE SecCode = 5352019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784107274, ExchCode = 'FRA' WHERE SecCode = 5353914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059910, ExchCode = 'FRA' WHERE SecCode = 5354968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955514234, ExchCode = 'DUS' WHERE SecCode = 5360992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21961201516, ExchCode = 'DEU' WHERE SecCode = 5388846 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2000-06-15' WHERE SecCode = 5391463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782758791, Ticker = 'A340', ExchCode = 'MUN' WHERE SecCode = 5393777 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5394904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777698922, ExchCode = 'STU' WHERE SecCode = 5399892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958000083, InstrPermID = 21671971988, ValQuotePermID = 21958000083.0, PermSecMapStartDate = '2023-03-23' WHERE SecCode = 5401708 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'RYN*' WHERE SecCode = 5411549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781829302, ExchCode = 'TDG' WHERE SecCode = 5415164 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 QuotePermID = 236777803100, ExchCode = 'MEX' WHERE SecCode = 5440528 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5463054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778265393, ExchCode = 'STU' WHERE SecCode = 5466184 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 5474601 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 5478193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778500352, ExchCode = 'MEX' WHERE SecCode = 5481081 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982253324, ExchCode = 'BER' 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 = 236778820209, ExchCode = 'STU' WHERE SecCode = 5497202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787118150, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-08' WHERE SecCode = 5506510 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223859, ExchCode = 'QTX' WHERE SecCode = 5506511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21984114239, ExchCode = 'DEU' WHERE SecCode = 5506512 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5509433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780911223, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 5509596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21986201526, ExchCode = 'DEU' WHERE SecCode = 5516455 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5527283 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5527520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781906283, ExchCode = 'TDG' WHERE SecCode = 5527546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779256326, ExchCode = 'MEX' WHERE SecCode = 5531898 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'XX10', PermQuoteRetireDate = NULL, PermOrgIPODate = '2025-09-19' WHERE SecCode = 5536057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780228916, ExchCode = 'MUN' WHERE SecCode = 5541689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223803, ExchCode = 'QTX' WHERE SecCode = 5541690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21990415641, ExchCode = 'DEU' WHERE SecCode = 5541691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471348, ExchCode = 'STU' WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471351, ExchCode = 'STU' WHERE SecCode = 5541733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779461582, ExchCode = 'FRA' WHERE SecCode = 5542014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471181, ExchCode = 'MEX' WHERE SecCode = 5542023 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21991233126, ExchCode = 'DEU' WHERE SecCode = 5546677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796182522, ExchCode = 'TDG' WHERE SecCode = 5547972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471183, ExchCode = 'BIV' WHERE SecCode = 5549613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22001313946, Ticker = 'SNV3m', ExchCode = 'BCO' WHERE SecCode = 5550748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779584150, ExchCode = 'FRA' WHERE SecCode = 5550820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779584152, ExchCode = 'FRA' WHERE SecCode = 5550822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779584154, ExchCode = 'FRA' WHERE SecCode = 5550823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779771106, ExchCode = 'FRA' WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779708089, ExchCode = 'STU' WHERE SecCode = 5558240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781060456, ExchCode = 'TDG' WHERE SecCode = 5560522 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541308584, PermQuoteStatus = 'DC', Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 5600665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487159, ExchCode = 'MUN' WHERE SecCode = 5603349 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23' WHERE SecCode = 5616087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780990202, ExchCode = 'FRA' WHERE SecCode = 5631726 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5648490 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5658381 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5658401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128985327, Ticker = 'AAT1', ExchCode = 'TDG' WHERE SecCode = 5674239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100058, PermQuoteStatus = 'AC', Ticker = 'ZK7', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 5697992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22024905249, Ticker = 'SOXL', ExchCode = 'LSE' WHERE SecCode = 5702908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028891058, ExchCode = 'STU' WHERE SecCode = 5726747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782930891, ExchCode = 'MUN' WHERE SecCode = 5753987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078228, ExchCode = 'LAS' WHERE SecCode = 5754012 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 5779224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783353275, ExchCode = 'STU' WHERE SecCode = 5779319 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037308993, ExchCode = 'DEU' WHERE SecCode = 5786123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037302983, ExchCode = 'DEU' WHERE SecCode = 5786125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783782319, ExchCode = 'STU' WHERE SecCode = 5786132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783963980, ExchCode = 'STU' WHERE SecCode = 5786133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534609, ExchCode = 'QTX' WHERE SecCode = 5786134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783847368, ExchCode = 'BER' WHERE SecCode = 5805681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22040680991, ExchCode = 'DEU' WHERE SecCode = 5805700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22040690920, ExchCode = 'DEU' WHERE SecCode = 5805706 AND Type_ = 10; UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 5807735 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5808176 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5814580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784107268, ExchCode = 'FRA' WHERE SecCode = 5814835 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5814965 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'H0T1' WHERE SecCode = 5817023 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 5842637 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 5846430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785660798, ExchCode = 'STU' WHERE SecCode = 5886967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22054245159, ExchCode = 'DEU' WHERE SecCode = 5888374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785946324, ExchCode = 'BIV' WHERE SecCode = 5908827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786584011, ExchCode = 'STU' WHERE SecCode = 5908829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786016617, ExchCode = 'STU' WHERE SecCode = 5908830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784598307, ExchCode = 'MEX' WHERE SecCode = 5923150 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5931769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787906828, ExchCode = 'STU' WHERE SecCode = 5949087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22077468824, ExchCode = 'CHI' WHERE SecCode = 5951017 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BAC', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954213 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BACA', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954214 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BACB', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954215 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BACC', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787324258, ExchCode = 'QTX' WHERE SecCode = 5969063 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795035713, ExchCode = 'FRA' WHERE SecCode = 5969285 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5981830 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758343, PermOrgIPODate = '2025-05-30' WHERE SecCode = 5987975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128985343, ExchCode = 'TDG', PermSecMapStartDate = '2024-11-06' WHERE SecCode = 6002047 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6006778 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 6025993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788759315, ExchCode = 'MUN' WHERE SecCode = 6041427 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 6043635 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6047847 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6047914 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6069623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CPAY*' WHERE SecCode = 6097418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 6097473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789902797, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30', PermSecMapEndDate = '2025-01-30' WHERE SecCode = 6114320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22086669341, ExchCode = 'DEU' WHERE SecCode = 6128378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22090148575, ExchCode = 'DEU' WHERE SecCode = 6155958 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2018-08-15' WHERE SecCode = 6176234 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951831.0 WHERE SecCode = 6196011 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 6215207 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 6264204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 6278721 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 6289714 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758343, PermOrgIPODate = '2025-05-30' WHERE SecCode = 6289726 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1996-03-18' WHERE SecCode = 6289739 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951831.0 WHERE SecCode = 6295456 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 6295461 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758343, PermOrgIPODate = '2025-05-30' WHERE SecCode = 6302045 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5096758343, PermOrgIPODate = '2025-05-30' WHERE SecCode = 6305239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792907994, ExchCode = 'FRA' WHERE SecCode = 6308566 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22110667359, ExchCode = 'DEU' WHERE SecCode = 6322250 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 6351573 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ZP9', PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6361963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116662449, ExchCode = 'QTX' WHERE SecCode = 6368869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793846140, ExchCode = 'MEX' WHERE SecCode = 6371576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22118566912, ExchCode = 'DEU' WHERE SecCode = 6382149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792427653, ExchCode = 'LAS' WHERE SecCode = 6382150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794190134, ExchCode = 'FRA' WHERE SecCode = 6387729 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 6389725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794188795, ExchCode = 'DUS' WHERE SecCode = 6392491 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 6403360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121019794, ExchCode = 'DEU' WHERE SecCode = 6405354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794459344, ExchCode = 'FRA' WHERE SecCode = 6409726 AND Type_ = 10; UPDATE data_universe_permid SET QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', PermOrgIPODate = '2025-09-23' WHERE SecCode = 6411862 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-09-18' WHERE SecCode = 6416392 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 6416396 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-09-21' WHERE SecCode = 6418158 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-09-22' WHERE SecCode = 6421094 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-09-22' WHERE SecCode = 6421141 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6423141 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6423142 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 6436727 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 6440020 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-17', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 6440031 AND Type_ = 10; UPDATE data_universe_permid SET PriInstrPermID = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6441630 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '9648', PermOrgIPODate = '2025-09-16' WHERE SecCode = 6441631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796059428, ExchCode = 'STU' WHERE SecCode = 6443222 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-14' WHERE SecCode = 6443239 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '544514', PermOrgIPODate = '2025-09-17' WHERE SecCode = 6443241 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', PermOrgIPODate = '2025-09-23' WHERE SecCode = 6443242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789615804, IsPrimaryQuote = 1, Ticker = 'URBANCO', ExchCode = 'NSI', PriTRBCIndPermID = 4294951197.0, PermOrgIPODate = '2025-09-17' WHERE SecCode = 6445464 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 6445465 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-17', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 6445470 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 6445471 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-21' WHERE SecCode = 6448293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796057730, ExchCode = 'GTX' WHERE SecCode = 6448294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795663595, ExchCode = 'TDG' WHERE SecCode = 6448295 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796057759, ExchCode = 'MUN' WHERE SecCode = 6448296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126473178, ExchCode = 'DEU' WHERE SecCode = 6448297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126473223, ExchCode = 'DEU' WHERE SecCode = 6448298 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 6448561 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-10' WHERE SecCode = 6449021 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 6449065 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 6449398 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795918128, ExchCode = 'MUN' WHERE SecCode = 6451087 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 10887936 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 10891076 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10925096 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'MBRFY' WHERE SecCode = 10968220 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'NASC', PriTRBCIndPermID = 4294951546.0 WHERE SecCode = 10990101 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11004066 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951184.0 WHERE SecCode = 11009012 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 11009046 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11020243 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 11020471 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'GROW.H', ExchCode = 'NEX' WHERE SecCode = 11024834 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11027815 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22' WHERE SecCode = 11033942 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11035950 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11037266 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 11037506 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11047720 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11047731 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11050854 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11052195 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 11052288 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 11058378 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11060595 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 11061551 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11061697 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 11062007 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'GTRIF' WHERE SecCode = 11063828 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11064997 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951202.0 WHERE SecCode = 11065822 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-17', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 11066407 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SPP.H', ExchCode = 'NEX' WHERE SecCode = 11069199 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096759636, OrgTypeCode = 'COM', PermOrgIPODate = '2013-01-05' WHERE SecCode = 11073563 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11077542 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 11107128 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 11137706 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11143909 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'ORPOF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-19', PermSecMapEndDate = NULL WHERE SecCode = 11151837 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11156633 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11159248 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11177652 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 11183359 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17' WHERE SecCode = 11189988 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11195660 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-22', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-22' WHERE SecCode = 11199506 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11199637 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 22128936132, PriTrdQuotePermID = 22128936132.0, ExchCode = 'PSE', QuoteClass = 'ETFC', InstrClass = 'ETFC', PermSecMapStartDate = '2025-09-19' WHERE SecCode = 11201199 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11203252 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232885330517.0, IsPrimaryInstr = 0 WHERE SecCode = 11203282 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11205537 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11206889 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11207746 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11208299 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11208879 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11209772 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11212458 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11214158 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 11214720 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NYS' WHERE SecCode = 11214926 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11214934 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 11216248 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11216266 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951697.0 WHERE SecCode = 11216682 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 11218488 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11221086 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11221176 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096762159, PermOrgIPODate = '1986-06-06' WHERE SecCode = 11222396 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727247621, PriTrdQuotePermID = NULL, Ticker = 'LSBCF', ExchCode = 'PNK' WHERE SecCode = 11228127 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-17', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 11228483 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727234094, PriTrdQuotePermID = NULL, Ticker = 'FAASF', ExchCode = 'PNK' WHERE SecCode = 11229729 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236793806111, ValQuotePermID = 21856492172.0, IsPrimaryQuote = 0, ExchCode = 'GTC', PermSecMapStartDate = '2025-02-20', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11234013 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11237264 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236795665875, IsPrimaryQuote = 1, PermQuoteStatus = 'AC', Ticker = 'ANGX', ExchCode = 'NYS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-09', PermSecMapEndDate = NULL WHERE SecCode = 11237780 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11240709 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11240710 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240711 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240712 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11240713 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-22', PermOrgIPODate = NULL WHERE SecCode = 11240747 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240851 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11240852 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11240853 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11240854 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11241414 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SMNR', PermOrgIPODate = NULL WHERE SecCode = 11242359 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242778 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242779 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242780 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242805 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11242806 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242807 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242808 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11242850 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242851 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11242951 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11243196 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11243210 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11243528 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NMS' WHERE SecCode = 11243561 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11244440 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11244594 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LUXHQ' WHERE SecCode = 11244678 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11244741 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11244742 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11244780 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11244901 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 11244902 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11245025 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11245067 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11245068 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 11245134 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11245168 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11245169 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'TWELF' WHERE SecCode = 11245290 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'WDBQB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-16', PermSecMapEndDate = NULL WHERE SecCode = 11245526 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11246337 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11246541 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11246542 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11246581 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11246634 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11246635 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'TARGD' WHERE SecCode = 11247040 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 11247807 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11247901 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11247902 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11247903 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11248246 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951361.0, PermSecMapEndDate = NULL WHERE SecCode = 11249437 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-17' WHERE SecCode = 11249518 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727247621, PriTrdQuotePermID = NULL, Ticker = 'LSBCF', ExchCode = 'PNK' WHERE SecCode = 11250503 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11251288 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'OBRUD' WHERE SecCode = 11251487 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'FDXTF' WHERE SecCode = 11251873 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11252397 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11252443 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'HZLID' WHERE SecCode = 11252776 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SABA' WHERE SecCode = 11255290 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11255736 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11255737 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11255738 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11255739 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11256003 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11256004 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11256413 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 11256986 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11257897 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11257898 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11257899 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11257900 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11258010 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LUXPQ' WHERE SecCode = 11258091 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'CNRCF' WHERE SecCode = 11259676 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11259684 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11260050 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11260258 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11260451 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11261515 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11261847 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2024-02-01' WHERE SecCode = 11262138 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-17' WHERE SecCode = 11263056 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11267922 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11268521 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'HPUMF' WHERE SecCode = 11269670 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11269762 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-16', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-16' WHERE SecCode = 11270043 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'IPST' WHERE SecCode = 11271912 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5096758343, PermOrgIPODate = '2025-05-30' WHERE SecCode = 11274795 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NYS' WHERE SecCode = 11275118 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951741.0 WHERE SecCode = 11275276 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276240 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276241 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276249 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276290 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11276292 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-17', PermSecMapEndDate = '2025-09-17' WHERE SecCode = 11276342 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11276343 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11276409 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11276411 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11276412 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11276416 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11276603 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11276606 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11276607 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11276608 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11276610 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11276611 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11276613 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11276614 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 11278193 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11278232 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232885330517.0, IsPrimaryInstr = 1 WHERE SecCode = 11278309 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11278441 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279508 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279509 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279510 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279511 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279512 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11279513 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279542 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279544 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279545 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279546 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279547 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279548 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279550 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279551 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279552 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279553 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279554 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279555 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279556 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279557 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279616 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279619 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279671 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279672 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279673 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279675 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279676 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279677 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279680 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11279682 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279771 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279774 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279775 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279776 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279836 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279837 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279842 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11279843 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-19', PermSecMapEndDate = '2025-09-19' WHERE SecCode = 11280859 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 11281000 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11281112 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23' WHERE SecCode = 11281282 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232888786653.0, IsPrimaryInstr = 0 WHERE SecCode = 11281693 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11284056 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-18', PermSecMapEndDate = '2025-09-18' WHERE SecCode = 11284099 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5057764257, PriInstrPermID = 25727283306.0, IsPrimaryInstr = 0, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2021-04-14' WHERE SecCode = 11284186 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5000069094, PriInstrPermID = 8590933196.0, IsPrimaryInstr = 0, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951864.0, PermOrgIPODate = '1961-10-11' WHERE SecCode = 11284197 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232888096122.0, IsPrimaryInstr = 0 WHERE SecCode = 11284219 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-15' WHERE SecCode = 11284582 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'RIV RT' WHERE SecCode = 11285120 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'WSBCL' WHERE SecCode = 11285207 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365573.0 WHERE SecCode = 11285222 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285254 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285256 AND Type_ = 1;