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 QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 36833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509917171, ExchCode = 'TDG' WHERE SecCode = 37853 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096166223, PriInstrPermID = 8590001879.0, PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '2001-07-11' WHERE SecCode = 39407 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21575481673, ExchCode = 'FRA' WHERE SecCode = 40598 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 40869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836523767, ExchCode = 'FRA' WHERE SecCode = 41385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302063, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 43574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627498, ExchCode = 'DEU' WHERE SecCode = 43579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519893986, ExchCode = 'STU' WHERE SecCode = 43583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328604, Ticker = 'FRZS', ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 48237 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 49597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035006, ExchCode = 'TDG', PermQuoteRetireDate = '2013-08-21' WHERE SecCode = 53240 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 54979 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 55160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501625448, ExchCode = 'TDG' WHERE SecCode = 55696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835779680, ExchCode = 'DUS', PermQuoteRetireDate = '2011-04-12' WHERE SecCode = 56163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632625982, ExchCode = 'TDG' WHERE SecCode = 56216 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 56806 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GOGYD' WHERE SecCode = 58855 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21478345271, ExchCode = 'TDG' WHERE SecCode = 59240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196283, ExchCode = 'QTX' WHERE SecCode = 60024 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 60453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018990, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-16', PermSecMapEndDate = '2023-08-16' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204033, PermQuoteStatus = 'AC', Ticker = 'RE21d', ExchCode = 'BCO', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 63207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521225233, PermQuoteStatus = 'AC', Ticker = 'HVP0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 64448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475633259, ExchCode = 'GER', PermQuoteRetireDate = '2006-11-13' WHERE SecCode = 64462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331910, ExchCode = 'BER' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475572381, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2004-09-13', PermSecMapEndDate = '2022-06-30' WHERE SecCode = 65029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359995, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 65092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294059, ExchCode = 'GTX' WHERE SecCode = 65163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830299459, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 66530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498521055, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 66532 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 66878 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 67230 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BLEG' WHERE SecCode = 79606 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 80076 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 83443 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = NULL WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 84357 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809169812, PermQuoteStatus = 'AC', Ticker = 'RSINF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-29', PermSecMapEndDate = NULL WHERE SecCode = 85622 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PRNAF' WHERE SecCode = 87545 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 88761 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 93827 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 96243 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000176703, OrgTypeCode = 'UNK', DomCntry = NULL, PriTRBCIndPermID = NULL WHERE SecCode = 97012 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796141120, ExchCode = 'FRA' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101260 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102996 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 104996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'UDM0' WHERE SecCode = 113108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179548619, ExchCode = 'DEU' WHERE SecCode = 119132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204021, Ticker = 'UN9d', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 126790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331849, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 126858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123504, ExchCode = 'FRA' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204029, Ticker = 'GXEd', ExchCode = 'BCO', PermSecMapStartDate = '2025-12-31' WHERE SecCode = 134039 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 141615 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 142831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204023, Ticker = 'NKTd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 143626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22190463183, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-01', PermSecMapEndDate = NULL WHERE SecCode = 144831 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 QuotePermID = 236809204050, Ticker = 'LRCd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 144888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204063, Ticker = 'TW10d', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 145154 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 145209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204058, Ticker = 'AXNAd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 145406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474938264, ExchCode = 'DEU' WHERE SecCode = 145432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204022, PermQuoteStatus = 'AC', Ticker = 'O3Pd', ExchCode = 'BCO', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-12-31', PermSecMapEndDate = NULL WHERE SecCode = 145888 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 145951 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 146066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169215035, ExchCode = 'DEU' WHERE SecCode = 146536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662910516, ExchCode = 'FRA' WHERE SecCode = 146555 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204030, PermQuoteStatus = 'AC', Ticker = 'BDSBd', ExchCode = 'BCO', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 147415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527198700, ExchCode = 'STU' WHERE SecCode = 162372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566116516, ExchCode = 'STU' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536544263, ExchCode = 'DEU' WHERE SecCode = 186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838540118, ExchCode = 'STU' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383425, ExchCode = 'FRA' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 206837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 252418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204044, Ticker = 'XCAd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 254983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858508, ExchCode = 'DUS' WHERE SecCode = 258042 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 289032 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-30' WHERE SecCode = 309268 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 315105 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 317753 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 319543 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 323011 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 326348 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'CAXXF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-01', PermSecMapEndDate = NULL WHERE SecCode = 326902 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 333698 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 334010 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 341703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485225744, ExchCode = 'STU', PermQuoteRetireDate = '2016-05-16' WHERE SecCode = 348104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 348109 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GAON' WHERE SecCode = 349154 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 353933 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5085490534, PriInstrPermID = 21863189322.0, IncCntry = 'AUS', PermOrgIPODate = '2008-07-15' WHERE SecCode = 361482 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-30' WHERE SecCode = 409378 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01' WHERE SecCode = 436284 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 467492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-07-01' WHERE SecCode = 519216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783658859, ExchCode = 'TQE' WHERE SecCode = 521413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714460362, ExchCode = 'DXE' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714444925, ExchCode = 'DXE' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714445246, ExchCode = 'DXE' WHERE SecCode = 521423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714445358, ExchCode = 'DXE' WHERE SecCode = 521425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714450310, ExchCode = 'DXE' WHERE SecCode = 521426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666607625, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2018-12-03' WHERE SecCode = 521434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846578496, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 521901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 548199 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 554355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255778, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157401812, ExchCode = 'DEU' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475858943, ExchCode = 'BTE', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 819430 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232940880151.0 WHERE SecCode = 863623 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232940880151.0 WHERE SecCode = 863867 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1158086 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 1192662 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 PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512412458, Ticker = 'CTY1SN011', ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1721139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802866853, ExchCode = 'DEU' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648777621, ExchCode = 'TDG' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308485, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2222230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615737, ExchCode = 'MUN' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527321541, Ticker = 'GPA', ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433951, ExchCode = 'MUN' WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670714959, ExchCode = 'TDG' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530098344, ExchCode = 'FRA' WHERE SecCode = 2362509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807341682, ExchCode = 'OCE' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530485265, ExchCode = 'DEU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531377381, ExchCode = 'DEU' WHERE SecCode = 2381665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384853, ExchCode = 'LAS' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607391, ExchCode = 'QTX' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536966570, ExchCode = 'STU' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110077, ExchCode = 'FRA' WHERE SecCode = 2391353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223768, ExchCode = 'QTX' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-30' WHERE SecCode = 2394793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532119904, ExchCode = 'DEU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542388488, PermQuoteStatus = 'DC', Ticker = 'GKO0', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 2397376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620411353, ExchCode = 'STU' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997786, ExchCode = 'FRA' WHERE SecCode = 2402414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386146, ExchCode = 'LAS' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 2417295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197362, Ticker = 'MRK', ExchCode = 'BRN' WHERE SecCode = 2465112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774613413, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2465278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387906, ExchCode = 'LAS' WHERE SecCode = 2470092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780660022, ExchCode = 'TDG' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823953337, ExchCode = 'DUS' WHERE SecCode = 2515711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907918, ExchCode = 'FRA' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101512, ExchCode = 'FRA' WHERE SecCode = 2524752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475000070, Ticker = 'PREVIS-OSA', ExchCode = 'SGO' WHERE SecCode = 2524756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367747, ExchCode = 'BEC' WHERE SecCode = 2524779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 2531731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478404, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-24' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585062784, ExchCode = 'SGO' WHERE SecCode = 2539930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385094, ExchCode = 'LAS' WHERE SecCode = 2545058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478415, ExchCode = 'QTX' WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731262060, ExchCode = 'BER' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550101775, ExchCode = 'FRA' WHERE SecCode = 2559800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793909715, ExchCode = 'TDG' WHERE SecCode = 2568912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768665, ExchCode = 'MUN' WHERE SecCode = 2572311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705735, ExchCode = 'MXQ' WHERE SecCode = 2572313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705667, ExchCode = 'MXQ' WHERE SecCode = 2572314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705247, ExchCode = 'MXQ' WHERE SecCode = 2572315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704187, ExchCode = 'MXQ' WHERE SecCode = 2572318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705290, Ticker = 'LINN', ExchCode = 'MXQ' WHERE SecCode = 2572322 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-30' WHERE SecCode = 2576965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543086076, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-24' WHERE SecCode = 2578880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793501847, ExchCode = 'MUN' WHERE SecCode = 2578881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550101787, ExchCode = 'FRA' WHERE SecCode = 2579447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042131, ExchCode = 'FRA' WHERE SecCode = 2580935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543709073, ExchCode = 'FRA' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204060, Ticker = '1F80d', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 2585498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067641975, ExchCode = 'CHI' WHERE SecCode = 2600378 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2603245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204064, Ticker = '1AEd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722349014, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109507, ExchCode = 'FRA', PermQuoteRetireDate = '2018-06-11' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288297, ExchCode = 'GTX' WHERE SecCode = 2644157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194870, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2024-08-09' WHERE SecCode = 2679891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194883, ExchCode = 'SWX' WHERE SecCode = 2679902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194873, PermQuoteStatus = 'AC', Ticker = 'EXK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL WHERE SecCode = 2682091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194953, PermQuoteStatus = 'AC', Ticker = 'AG', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL WHERE SecCode = 2682092 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 2682111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378822, Ticker = NULL, ExchCode = 'BRN', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 2682137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173494, PermQuoteStatus = 'AC', Ticker = 'SGE', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2682169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173515, PermQuoteStatus = 'AC', Ticker = 'RNL', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2682171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379222, PermQuoteStatus = 'AC', Ticker = 'ITB', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2682181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379108, PermQuoteStatus = 'AC', Ticker = 'ZEG', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2682187 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2696581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552008104, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2711155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705935887, ExchCode = 'BIV' WHERE SecCode = 2724356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789017040, ExchCode = 'DUS' WHERE SecCode = 2747510 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2764536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789940347, ExchCode = 'FRA' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558477129, ExchCode = 'DEU' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560390655, ExchCode = 'STU' WHERE SecCode = 2841897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650196, ExchCode = 'DUS' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561901515, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2873688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569832692, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-03' WHERE SecCode = 2880970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562688444, ExchCode = 'FRA' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563614493, ExchCode = 'STU' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204026, PermQuoteStatus = 'AC', Ticker = '472d', ExchCode = 'BCO', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 2890452 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 2892988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2902829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-30' WHERE SecCode = 2916149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890828, PermQuoteStatus = 'AC', Ticker = 'VZLBd', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985207, ExchCode = 'TDG' WHERE SecCode = 2935962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567481828, ExchCode = 'FRA', PermQuoteRetireDate = '2020-05-07' WHERE SecCode = 2936005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370461, ExchCode = 'GTX' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573607460, ExchCode = 'DUS' WHERE SecCode = 2956411 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570455715, ExchCode = 'DEU' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589220364, ExchCode = 'DEU' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204049, Ticker = 'ANId', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 3028494 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864421, ExchCode = 'STU' WHERE SecCode = 3030075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520298, ExchCode = 'QTX' WHERE SecCode = 3038439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22190463179, PermQuoteStatus = 'AC', Ticker = '81G', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3044834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611487587, ExchCode = 'FRA' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991744, ExchCode = 'DEU' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792293391, ExchCode = 'FRA' WHERE SecCode = 3074402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285720, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235696, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855827347, ExchCode = 'GER', PermQuoteRetireDate = '2022-03-14', PermSecMapEndDate = '2022-03-14' WHERE SecCode = 3090272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580910339, ExchCode = 'DEU' WHERE SecCode = 3090322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933862, ExchCode = 'MUN' WHERE SecCode = 3105902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489945, ExchCode = 'FRA' WHERE SecCode = 3120784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296679, ExchCode = 'GTX' WHERE SecCode = 3172332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = NULL WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079754, ExchCode = 'TDG' WHERE SecCode = 3219367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641516, ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 3219383 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = NULL WHERE SecCode = 3220899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595530115, ExchCode = 'STU', PermQuoteRetireDate = '2024-06-28' WHERE SecCode = 3237127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334992, ExchCode = 'DEU' WHERE SecCode = 3247427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621838, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2016-12-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3263708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007430, ExchCode = 'DEU' WHERE SecCode = 3282311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792256326, ExchCode = 'MUN' WHERE SecCode = 3282366 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3282989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604346350, ExchCode = 'BER', PermQuoteRetireDate = '2022-01-06' WHERE SecCode = 3283289 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-30' WHERE SecCode = 3285254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, ExchCode = 'STU' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419079, ExchCode = 'LAS' WHERE SecCode = 3337707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204047, Ticker = '2X1d', ExchCode = 'BCO', PermSecMapStartDate = '2026-06-30' WHERE SecCode = 3345529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631068545, Ticker = 'BIOSs', ExchCode = 'BCO', PermQuoteRetireDate = '2024-05-21' WHERE SecCode = 3350742 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BLINC B' WHERE SecCode = 3355024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050504, ExchCode = 'FRA' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232940880151.0 WHERE SecCode = 3371087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957123, PermQuoteStatus = 'DC', Ticker = 'C5B', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-19' WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234952, ExchCode = 'MUN' WHERE SecCode = 3405059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835864, Ticker = 'DTSd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232940880151.0 WHERE SecCode = 3408541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629966004, ExchCode = 'FRA', PermQuoteRetireDate = '2020-02-26' WHERE SecCode = 3408843 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 3408864 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3408872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3434928 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 3435598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858470979, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380072, ExchCode = 'LAS' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100414, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3491217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650965200, Ticker = 'NOKIA', ExchCode = 'PRA' WHERE SecCode = 3504673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947481, ExchCode = 'FRA' WHERE SecCode = 3526199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758498, ExchCode = 'STU' WHERE SecCode = 3531554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781272952, ExchCode = 'DUS' WHERE SecCode = 3535855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3543179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238718, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3553157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789697925, ExchCode = 'QTX' WHERE SecCode = 3555055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786322046, ExchCode = 'STU', PermQuoteRetireDate = '2024-10-29', PermSecMapEndDate = NULL WHERE SecCode = 3586882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358321, Ticker = 'CS9', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732047, ExchCode = 'TDG' WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609678, ExchCode = 'DEU' WHERE SecCode = 3588082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995361, ExchCode = 'DEU' WHERE SecCode = 3588110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872250, ExchCode = 'FRA' WHERE SecCode = 3588112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197812, ExchCode = 'FRA' WHERE SecCode = 3588113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316444, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918858, ExchCode = 'FRA' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114251, ExchCode = 'FRA' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC', PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 3706713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21676006277, ExchCode = 'DEU' WHERE SecCode = 3708151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673848109, ExchCode = 'BIV' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220426, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712565, ExchCode = 'STU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620914214, Ticker = 'CZBl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296352, ExchCode = 'GTX' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692561684, ExchCode = 'DEU' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705621141, ExchCode = 'QTX' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353726, ExchCode = 'QTX', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368210, ExchCode = 'MEX' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198380, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807886595, InstrPermID = 232937981300, ValQuotePermID = 236807886595.0, PermSecMapStartDate = '2026-06-02', PermSecMapEndDate = NULL WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828455, Ticker = '1AIXAm', ExchCode = 'BCO' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828404, Ticker = '1BODm', ExchCode = 'BCO' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026897, Ticker = '1COST' WHERE SecCode = 4031830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999014151, Ticker = '2DDD' WHERE SecCode = 4031839 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4032063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059848, ExchCode = 'FRA' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788219439, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260229, ExchCode = 'DEU' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735310153, Ticker = '7M40', ExchCode = 'STU', PermQuoteRetireDate = '2024-02-02' WHERE SecCode = 4103711 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4129530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, Ticker = '4U1', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = '2025-04-01' WHERE SecCode = 4212367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752139678, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752244343, ExchCode = 'TDG' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752408872, ExchCode = 'FRA' WHERE SecCode = 4248820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809736, ExchCode = 'DEU' WHERE SecCode = 4275420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757668911, ExchCode = 'FRA' WHERE SecCode = 4282400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01' WHERE SecCode = 4291578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770832967, ExchCode = 'DEU' WHERE SecCode = 4362675 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 4388174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778893562, ExchCode = 'FRA', PermQuoteRetireDate = '2020-11-17' WHERE SecCode = 4400157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779062122, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-26' WHERE SecCode = 4401406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307570, ExchCode = 'BIV' WHERE SecCode = 4403942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307218, ExchCode = 'BIV' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783652671, ExchCode = 'DEU' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303270, ExchCode = 'BIV' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783670602, ExchCode = 'EQD' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833140761, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-26' WHERE SecCode = 4434385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307221, ExchCode = 'MEX' WHERE SecCode = 4444709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307580, ExchCode = 'MEX' WHERE SecCode = 4456082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789191252, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4456112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794257515, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817586, ExchCode = 'DEU' WHERE SecCode = 4481115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795226688, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-29', PermSecMapEndDate = '2023-06-29' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307575, ExchCode = 'MEX' WHERE SecCode = 4487928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792403448, ExchCode = 'FRA' WHERE SecCode = 4505788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801053714, ExchCode = 'MUN' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194911, Ticker = 'APH', ExchCode = 'SWX' WHERE SecCode = 4531618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015234, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4531850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349196, ExchCode = 'BIV' WHERE SecCode = 4550708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848268, ExchCode = 'DEU' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288448, ExchCode = 'DEU' WHERE SecCode = 4609999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755662, ExchCode = 'MUN', PermQuoteRetireDate = '2023-09-11', PermSecMapEndDate = NULL WHERE SecCode = 4622149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805522557, ExchCode = 'DEU' WHERE SecCode = 4624222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236808501799.0 WHERE SecCode = 4633023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849335, ExchCode = 'FRA' WHERE SecCode = 4633105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826245482, ExchCode = 'TDG' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831542326, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845533132, ExchCode = 'GTX' WHERE SecCode = 4724688 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4751011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098679, ExchCode = 'FRA' WHERE SecCode = 4753666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853953632, ExchCode = 'QTX' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795665928, ExchCode = 'FRA' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 4802323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156627, ExchCode = 'MUN' WHERE SecCode = 4827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792865451, ExchCode = 'MUN' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4873389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716262, ExchCode = 'FRA' WHERE SecCode = 4960863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889564320, ExchCode = 'STU' WHERE SecCode = 4960864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727205509, ExchCode = 'BIV' WHERE SecCode = 4962789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886412706, ExchCode = 'FRA' WHERE SecCode = 4965055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888036745, ExchCode = 'MUN' WHERE SecCode = 4969368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907555781, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4969375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886193164, ExchCode = 'FRA' WHERE SecCode = 4969376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314817, ExchCode = 'OCE' WHERE SecCode = 4969408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066264784, ExchCode = 'CHI' WHERE SecCode = 4969409 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4975833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 4999998 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5005673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788890733, ExchCode = 'QTX' WHERE SecCode = 5047099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209490, ExchCode = 'FRA' WHERE SecCode = 5059308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194940, Ticker = 'FTNT', ExchCode = 'SWX' WHERE SecCode = 5071086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903354806, ExchCode = 'FRA' WHERE SecCode = 5071115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388829, ExchCode = 'LAS' WHERE SecCode = 5071117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931482934, ExchCode = 'GTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236809169007.0 WHERE SecCode = 5155289 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 = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650379, ExchCode = 'QTX' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954812, ExchCode = 'LAS' WHERE SecCode = 5166813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783316559, ExchCode = 'STU' WHERE SecCode = 5168258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049597, ExchCode = 'MXQ' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 5257731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 5281320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386763, ExchCode = 'LAS' WHERE SecCode = 5292727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957771304, ExchCode = 'FRA' WHERE SecCode = 5374832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783749193, ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 5374833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487235, ExchCode = 'FRA' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777272868, ExchCode = 'MUN' WHERE SecCode = 5402859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777583966, ExchCode = 'DUS', PermSecMapStartDate = '2026-07-01' WHERE SecCode = 5417716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849037685, ExchCode = 'MUN' WHERE SecCode = 5430827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667447, ExchCode = 'STU', PermQuoteRetireDate = '2026-06-22' WHERE SecCode = 5436573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667355, ExchCode = 'STU' WHERE SecCode = 5436574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986459012, Ticker = 'USFAl', ExchCode = 'SIG' WHERE SecCode = 5516823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223797, ExchCode = 'QTX' WHERE SecCode = 5516829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781013274, ExchCode = 'FRA' WHERE SecCode = 5638751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830325, ExchCode = 'GER', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089214794, Ticker = '3TSEd', ExchCode = 'BTE' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949567 WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 5689852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22027362169, ExchCode = 'STU' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782771597, ExchCode = 'FRA' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097265, ExchCode = 'LAS' WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379581, ExchCode = 'LAS' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783009907, ExchCode = 'STU' WHERE SecCode = 5758113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812186220, ExchCode = 'FRA' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22035457659, ExchCode = 'DEU' WHERE SecCode = 5765005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040671244, ExchCode = 'MUN' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783330017, ExchCode = 'FRA' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329733, ExchCode = 'FRA' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353647, ExchCode = 'FRA' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353632, ExchCode = 'FRA' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353639, ExchCode = 'FRA' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 5807949 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 5808179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787198171, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264814, ExchCode = 'FRA' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044538463, ExchCode = 'DEU' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784419514, ExchCode = 'STU' WHERE SecCode = 5827173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21967216830, Ticker = 'CO3S', ExchCode = 'LSE' WHERE SecCode = 5839249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600489, ExchCode = 'STU' WHERE SecCode = 5839460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913642, ExchCode = 'DEU' WHERE SecCode = 5839461 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'A2E0' WHERE SecCode = 5839463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5842624 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-30' WHERE SecCode = 5859850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195012, ExchCode = 'SWX' WHERE SecCode = 5886970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054671258, ExchCode = 'DEU' WHERE SecCode = 5890417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086035577, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5897569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666338, ExchCode = 'DXE' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786285846, ExchCode = 'BTE' WHERE SecCode = 5923083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736829339, ExchCode = 'FRA' WHERE SecCode = 5944851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802149994, ExchCode = 'SWX' WHERE SecCode = 6032793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012125626, ExchCode = 'DUS' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799762, ExchCode = 'HAM' WHERE SecCode = 6097368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV' WHERE SecCode = 6097383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177418, ExchCode = 'FRA' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928860, Ticker = 'NVDSl', ExchCode = 'BCO' WHERE SecCode = 6097436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911612, ExchCode = 'BIV' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015392, ExchCode = 'FRA' WHERE SecCode = 6104634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086925583, ExchCode = 'MUN' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-30' WHERE SecCode = 6104639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089463033, ExchCode = 'DEU' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790959257, ExchCode = 'GTX' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790533564, ExchCode = 'BIV' WHERE SecCode = 6176235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22095615043, ExchCode = 'DEU' WHERE SecCode = 6205893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22095625709, ExchCode = 'DEU' WHERE SecCode = 6205895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22101892365, ExchCode = 'TDG' WHERE SecCode = 6226091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257931, ExchCode = 'FRA' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655583, ExchCode = 'GER' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116662449, ExchCode = 'QTX' WHERE SecCode = 6368869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116657866, ExchCode = 'DEU' WHERE SecCode = 6368870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655573, ExchCode = 'FRA' WHERE SecCode = 6368872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655581, ExchCode = 'GER' WHERE SecCode = 6368874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228183, ExchCode = 'TDG' WHERE SecCode = 6371577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934079, ExchCode = 'TDG' WHERE SecCode = 6371578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122679002, ExchCode = 'DEU' WHERE SecCode = 6416433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794542873, ExchCode = 'BIV' WHERE SecCode = 6441527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22189197578, Ticker = 'PJSRm', ExchCode = 'BCO' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136092715, ExchCode = 'GTX' WHERE SecCode = 6482759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131851181, ExchCode = 'DEU' WHERE SecCode = 6482768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01' WHERE SecCode = 6548134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168734, ExchCode = 'SIG' WHERE SecCode = 6578406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955090, ExchCode = 'BIV' WHERE SecCode = 6590630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800658724, ExchCode = 'QTX' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195025, Ticker = 'NOW', ExchCode = 'SWX' WHERE SecCode = 6617619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165242, ExchCode = 'DEU' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6627012 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6627244 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6627432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801727825, ExchCode = 'MUN' WHERE SecCode = 6628073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833042, ExchCode = 'FRA' WHERE SecCode = 6628088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833107, ExchCode = 'FRA' WHERE SecCode = 6628089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833228, ExchCode = 'FRA' WHERE SecCode = 6628091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801913112, ExchCode = 'GTX' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801914263, ExchCode = 'FRA' WHERE SecCode = 6628800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22158417254, ExchCode = 'DEU' WHERE SecCode = 6654707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191253, ExchCode = 'BEC' WHERE SecCode = 6678589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803534582, ExchCode = 'FRA' WHERE SecCode = 6691932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803756309, ExchCode = 'FRA' WHERE SecCode = 6696823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803758766, ExchCode = 'FRA' WHERE SecCode = 6696824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165234298, ExchCode = 'GTX' WHERE SecCode = 6710093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808183783, ExchCode = 'TDG' WHERE SecCode = 6721467 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 6724414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755612, ExchCode = 'FRA' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755696, ExchCode = 'FRA' WHERE SecCode = 6737927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755694, ExchCode = 'FRA' WHERE SecCode = 6737928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095337, ExchCode = 'QTX' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169965637, ExchCode = 'DEU' WHERE SecCode = 6753080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805309516, ExchCode = 'MEX' WHERE SecCode = 6768846 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PRABHAPP1', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 6772975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956057, ExchCode = 'FRA' WHERE SecCode = 6773256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901586, ExchCode = 'CHI' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705305, ExchCode = 'FRA' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805701903, ExchCode = 'FRA' WHERE SecCode = 6782677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805902026, ExchCode = 'FRA' WHERE SecCode = 6793389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406435, ExchCode = 'BIV' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236809167292.0 WHERE SecCode = 6806307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228771, ExchCode = 'FRA' WHERE SecCode = 6813221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228774, ExchCode = 'FRA' WHERE SecCode = 6813222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176932924, ExchCode = 'DEU' WHERE SecCode = 6826539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382110, ExchCode = 'LAS' WHERE SecCode = 6829114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806599398, ExchCode = 'FRA' WHERE SecCode = 6832519 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-01' WHERE SecCode = 6846678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141115, ExchCode = 'TDG' WHERE SecCode = 6857306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807421874, ExchCode = 'BIV' WHERE SecCode = 6876843 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 6890856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807884296, ExchCode = 'MEX' WHERE SecCode = 6897215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807886741, ExchCode = 'FRA' WHERE SecCode = 6897216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807886743, ExchCode = 'FRA' WHERE SecCode = 6897217 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 6900903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807978130, ExchCode = 'FRA' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 6901174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195009, Ticker = 'KLAC', ExchCode = 'SWX' WHERE SecCode = 6901199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194990, Ticker = 'LITE1', ExchCode = 'SWX' WHERE SecCode = 6901274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195029, Ticker = 'RGLD', ExchCode = 'SWX' WHERE SecCode = 6901511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194874, Ticker = 'EQT', ExchCode = 'SWX' WHERE SecCode = 6901545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195035, Ticker = 'TTWO', ExchCode = 'SWX' WHERE SecCode = 6901595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195039, Ticker = 'TER', ExchCode = 'SWX' WHERE SecCode = 6901605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195066, Ticker = 'WM', ExchCode = 'SWX' WHERE SecCode = 6901653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195068, Ticker = 'WDAY', ExchCode = 'SWX' WHERE SecCode = 6901667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194915, Ticker = 'AXON', ExchCode = 'SWX' WHERE SecCode = 6901741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194942, Ticker = 'CDNS', ExchCode = 'SWX' WHERE SecCode = 6901772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194936, Ticker = 'AVAV', ExchCode = 'SWX' WHERE SecCode = 6901829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194959, Ticker = 'FANG', ExchCode = 'SWX' WHERE SecCode = 6901856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809194877, Ticker = 'UUUU', ExchCode = 'SWX' WHERE SecCode = 6901871 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6901923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809195010, Ticker = 'PH', ExchCode = 'SWX' WHERE SecCode = 6902120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808061554, ExchCode = 'FRA' WHERE SecCode = 6902189 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 6902651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808331780, ExchCode = 'CHI' WHERE SecCode = 6914466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808548554, ExchCode = 'FRA' WHERE SecCode = 6923756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188701934, ExchCode = 'GTX' WHERE SecCode = 6930689 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 6934738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791346396, ExchCode = 'FRA' WHERE SecCode = 6937664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808923108, ExchCode = 'FRA' WHERE SecCode = 6941646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808923463, ExchCode = 'FRA' WHERE SecCode = 6941647 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236809168320.0 WHERE SecCode = 6951855 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236809168321.0 WHERE SecCode = 6951856 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-01' WHERE SecCode = 6952027 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 10922117 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NSLR' WHERE SecCode = 11002274 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'KPEA' WHERE SecCode = 11003802 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'BKSTD' WHERE SecCode = 11047950 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11067506 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11148269 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11149443 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25769770007, IsPrimaryQuote = 1, PermInstrStatus = 'DC', ExchCode = 'TOR', PermQuoteRetireDate = '2026-06-30', PermSecMapStartDate = '2016-04-26', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 11158560 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11169286 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11178625 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11196712 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809171108, PermQuoteStatus = 'AC', Ticker = 'GLAS', ExchCode = 'MPE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL WHERE SecCode = 11198864 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11201264 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11202259 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-30' WHERE SecCode = 11203978 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11213950 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FOXOD' WHERE SecCode = 11218296 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11223249 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 11225296 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11225847 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11227447 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 11232376 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NSLRL' WHERE SecCode = 11235673 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11243194 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'MSHKF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-01', PermSecMapEndDate = NULL WHERE SecCode = 11247408 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11252479 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 11272367 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 236808501799.0 WHERE SecCode = 11273466 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'HODO' WHERE SecCode = 11275764 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000174710, IncCntry = 'USA', PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11277555 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11280082 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11286184 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11286195 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11286780 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290003 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290168 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290170 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290172 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290173 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290174 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11290227 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11290994 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293905 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293906 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293908 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293968 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293970 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293972 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293974 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293975 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293976 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293979 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293981 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11293983 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236809171124.0, ValQuotePermID = 25727015579.0, PermInstrStatus = 'NA' WHERE SecCode = 11298236 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'MBGL' WHERE SecCode = 11298320 AND Type_ = 1;