UPDATE data_universe_permid SET QuotePermID = 55847137216, Ticker = 'ABBY.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 24 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807338493, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'OCU', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951784.0 WHERE SecCode = 3989 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 4602 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 12192 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 13395 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 18047 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836556100, ExchCode = 'FRA', PermQuoteRetireDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 37759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509917171, ExchCode = 'TDG' WHERE SecCode = 37853 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 39069 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '7DZ' WHERE SecCode = 39082 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 39129 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 39407 AND Type_ = 1;
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 DomCntry = 'GBR' WHERE SecCode = 48225 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 48430 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 49547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340900, PermQuoteStatus = 'DC', Ticker = 'ZWC1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 49643 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 56127 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ET80' WHERE SecCode = 64723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331910, ExchCode = 'BER' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838762505, ValQuotePermID = 55838762505.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 66878 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 73885 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'TOR' WHERE SecCode = 80076 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 82999 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 55838762505.0 WHERE SecCode = 83365 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-07' WHERE SecCode = 90149 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-07' WHERE SecCode = 90150 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 93821 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951737.0 WHERE SecCode = 94290 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-02' WHERE SecCode = 95203 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 96716 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-02' WHERE SecCode = 97914 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 99289 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 99358 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 101014 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809206338, ExchCode = 'GER' WHERE SecCode = 101252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 116276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179548619, ExchCode = 'DEU' WHERE SecCode = 119132 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 141139 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-03', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 145432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951737.0 WHERE SecCode = 177215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926938, ExchCode = 'FRA' WHERE SecCode = 183471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473861, ExchCode = 'GER' WHERE SecCode = 196149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802228564, ExchCode = 'MUN' WHERE SecCode = 199010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544954898, ExchCode = 'FRA' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527643731, ExchCode = 'STU' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175714363, ExchCode = 'DEU' WHERE SecCode = 208948 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 212058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962651, ExchCode = 'DEU' WHERE SecCode = 214142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475826525, ExchCode = 'TDG' WHERE SecCode = 214143 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermSecMapEndDate = '2026-07-02' WHERE SecCode = 215195 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 243344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379732, ExchCode = 'LAS' WHERE SecCode = 249186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326625, Ticker = 'CKI2', ExchCode = 'BER', PermQuoteRetireDate = '2020-11-06' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333664, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530163, ExchCode = 'FRA' WHERE SecCode = 249816 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 282759 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-02' WHERE SecCode = 283464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324576, ExchCode = 'BER' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 292506 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836461787, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573984403, PermQuoteStatus = 'AC', Ticker = 'C2U', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 302708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341653, ExchCode = 'BER', PermQuoteRetireDate = '2018-12-18', PermSecMapEndDate = '2018-12-18' WHERE SecCode = 302710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474858069, ExchCode = 'DEU' WHERE SecCode = 305002 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 309056 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 309135 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838351572, ExchCode = 'STU', PermQuoteRetireDate = '2011-05-25' WHERE SecCode = 312933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838234761, ExchCode = 'MUN', PermQuoteRetireDate = '2017-09-14' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808548996, ExchCode = 'DUS' WHERE SecCode = 313547 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951784.0 WHERE SecCode = 318428 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951784.0 WHERE SecCode = 318430 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-02' WHERE SecCode = 320137 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'NMAD', PriTRBCIndPermID = 4294951775.0 WHERE SecCode = 320972 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667479406, ExchCode = 'QTX' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856239637, ExchCode = 'DUS' WHERE SecCode = 325648 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 327826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789435058, ExchCode = 'DUS' WHERE SecCode = 328511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840262354, ExchCode = 'MEX' WHERE SecCode = 333869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482766270, ExchCode = 'MUN', PermQuoteRetireDate = '2015-06-16' WHERE SecCode = 336200 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-02' WHERE SecCode = 341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479577, ExchCode = 'QTX' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381539, ExchCode = 'LAS' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321177, ExchCode = 'BER', PermQuoteRetireDate = '2017-08-08' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419443, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837351233, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840407170, ExchCode = 'MEX' WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836362069, ExchCode = 'FRA' WHERE SecCode = 376072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439239, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-21' WHERE SecCode = 391170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877137536, ExchCode = 'MUN' WHERE SecCode = 391171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431734, ExchCode = 'DEU' WHERE SecCode = 401619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841617044, ExchCode = 'FRA' WHERE SecCode = 401621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842464917, Ticker = '1ENGI' WHERE SecCode = 408548 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 409378 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 413125 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 419650 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 425386 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 451110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841619375, ExchCode = 'MEX' WHERE SecCode = 462658 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 QuotePermID = 21662223441, ExchCode = 'TDG' WHERE SecCode = 512041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681521, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55879740079, Ticker = 'COM.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 523414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805519519, ExchCode = 'MUN', PermQuoteRetireDate = '2025-10-24' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857541012, ExchCode = 'FRA' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851903472, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 572386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230063, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293928, InstrPermID = 8591391476, OrgPermID = 5000663094, ValQuotePermID = 55858425773.0, PriInstrPermID = 8591391476.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ANK', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermOrgIPODate = '2010-04-01' WHERE SecCode = 601515 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 = 706545 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 726042 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-02' WHERE SecCode = 780397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504490118, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-02' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481705363, ExchCode = 'DEU' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514434081, Ticker = '5GQA', ExchCode = 'BER', PermQuoteRetireDate = '2020-04-02' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507269905, ExchCode = 'FRA' WHERE SecCode = 1618200 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331619, Ticker = 'KJ7A', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 1835498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673265, ExchCode = 'BIV' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302126, ExchCode = 'STU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658940658, ExchCode = 'MUN' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521092450, ExchCode = 'STO', PermQuoteRetireDate = '2024-03-27' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430949, ExchCode = 'DEU' WHERE SecCode = 2213927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569830, ExchCode = 'QTX' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869920397, ExchCode = 'MUN' WHERE SecCode = 2255684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55838762505.0 WHERE SecCode = 2258463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524954693, ExchCode = 'FRA' WHERE SecCode = 2267521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386762, ExchCode = 'LAS' WHERE SecCode = 2278225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539606835, ExchCode = 'DUS' WHERE SecCode = 2278227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967852, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2278243 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 2307812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528507836, ExchCode = 'DEU' WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676252, ExchCode = 'BIV' WHERE SecCode = 2359427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530098344, ExchCode = 'FRA' WHERE SecCode = 2362509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820384482, Ticker = 'XDN0l', ExchCode = 'BCO' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780887285, ExchCode = 'CHI' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308547, ExchCode = 'GTX' WHERE SecCode = 2377960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381501, ExchCode = 'LAS' WHERE SecCode = 2379809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384853, ExchCode = 'LAS' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531978999, ExchCode = 'FRA' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921479660, ExchCode = 'GTX' 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 QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834662, PermQuoteStatus = 'AC', Ticker = 'C68', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2397376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336720, ExchCode = 'FRA' 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 PermSecMapEndDate = '2026-07-03' WHERE SecCode = 2409463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777272865, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-04', PermSecMapEndDate = NULL WHERE SecCode = 2450650 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-03', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 2450658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443169, ExchCode = 'TDG' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534871419, ExchCode = 'FRA' WHERE SecCode = 2456856 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 = 21824100155, ExchCode = 'TDG' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA', PermQuoteRetireDate = '2018-11-19' WHERE SecCode = 2467266 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 = 21535535867, ExchCode = 'BCO', PermQuoteRetireDate = '2014-05-14' WHERE SecCode = 2494242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 2502552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181315008, ExchCode = 'OCE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET 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 = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-02' WHERE SecCode = 2528745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 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 = 21629786303, ExchCode = 'DEU' WHERE SecCode = 2539933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 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 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 = 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 = 21544213582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-16' WHERE SecCode = 2593544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369809, ExchCode = 'SGO' WHERE SecCode = 2598717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958117, ExchCode = 'TDG' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545107336, ExchCode = 'DEU' WHERE SecCode = 2604390 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 = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548014433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538237, ExchCode = 'GTX' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288297, ExchCode = 'GTX' WHERE SecCode = 2644157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789432566, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624667850, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-28' WHERE SecCode = 2650642 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2655924 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 = 21549921085, ExchCode = 'CHI' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742655, ExchCode = 'HAN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 2682111 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 = 236799607245, Ticker = 'HL', ExchCode = 'SWX' WHERE SecCode = 2682233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197291, Ticker = NULL, ExchCode = 'BRN', PermQuoteRetireDate = '2019-05-29', PermSecMapEndDate = '2019-05-29' WHERE SecCode = 2682394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197297, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 2682397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137710, ExchCode = 'MUN', PermQuoteRetireDate = '2021-07-05' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384079, ExchCode = 'LAS' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551920812, ExchCode = 'MUN' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119337, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 2700711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551965230, Ticker = 'CBKe', ExchCode = 'SIG', PermQuoteRetireDate = '2014-12-10' WHERE SecCode = 2706343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584014278, ExchCode = 'BTE', PermQuoteRetireDate = '2021-06-01' WHERE SecCode = 2720682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533308745, ExchCode = 'FRA' WHERE SecCode = 2747656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554995304, ExchCode = 'STU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554451923, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-14' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273861, PermQuoteStatus = 'AC', Ticker = 'XV2', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2751767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367198, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' 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 = 21557589784, ExchCode = 'DEU' WHERE SecCode = 2810887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275235, ExchCode = 'GTX' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274949, ExchCode = 'GTX' WHERE SecCode = 2855817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603343761, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865313, ExchCode = 'DEU' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486519, ExchCode = 'BIV' WHERE SecCode = 2870132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732998267, ExchCode = 'QTX' WHERE SecCode = 2872658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734475861, ExchCode = 'STU' WHERE SecCode = 2873688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073295, ExchCode = 'FRA', PermQuoteRetireDate = '2022-03-09' WHERE SecCode = 2880970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478695, ExchCode = 'QTX' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562620362, ExchCode = 'MUN' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563177438, ExchCode = 'DEU' WHERE SecCode = 2887312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562944695, ExchCode = 'DEU' WHERE SecCode = 2887317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 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 QuotePermID = 21564309877, ExchCode = 'FRA' WHERE SecCode = 2902752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943057400, ExchCode = 'STU' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564677908, ExchCode = 'FRA' WHERE SecCode = 2909231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289186, Ticker = 'MMAT', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2909232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565404048, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2912969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623096, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211564, Ticker = '34LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-21', PermSecMapEndDate = NULL WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565562433, ExchCode = 'SGO' WHERE SecCode = 2936007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370461, ExchCode = 'GTX' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641460082, ExchCode = 'BER' WHERE SecCode = 2958533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726926, ExchCode = 'MUN' WHERE SecCode = 2975172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628902471, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895439, ExchCode = 'STU' WHERE SecCode = 3008027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513500, ExchCode = 'DEU' WHERE SecCode = 3015987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576625962, ExchCode = 'FRA' WHERE SecCode = 3026615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260230, ExchCode = 'FRA' WHERE SecCode = 3030075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585829107, ExchCode = 'STU' WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603201534, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-04', PermSecMapEndDate = NULL WHERE SecCode = 3033923 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3038367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740543, ExchCode = 'LAS' WHERE SecCode = 3038477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22190463179, ExchCode = 'DEU' WHERE SecCode = 3044834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818952836, ExchCode = 'DUS' WHERE SecCode = 3045201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822880896, ExchCode = 'DUS' WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750433751, ExchCode = 'STU' WHERE SecCode = 3055016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578813192, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788253479, ExchCode = 'BIV' WHERE SecCode = 3060652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786322025, ExchCode = 'BER' WHERE SecCode = 3065856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386888, ExchCode = 'LAS' 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 = 21587055379, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14', PermSecMapEndDate = '2020-06-16' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580910339, ExchCode = 'DEU' WHERE SecCode = 3090322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109521, ExchCode = 'DEU' WHERE SecCode = 3116969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779496553, ExchCode = 'GTX' WHERE SecCode = 3120784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077935, ExchCode = 'LAS' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320104, ExchCode = 'FRA' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704364, Ticker = 'BRSS*', ExchCode = 'MXQ' WHERE SecCode = 3130990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515372, ExchCode = 'GTX' WHERE SecCode = 3151393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704755, ExchCode = 'MXQ' WHERE SecCode = 3151409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622175, Ticker = '0R9Ul', ExchCode = 'BCO' WHERE SecCode = 3156022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056939, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3169823 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3172342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758877, ExchCode = 'SIG' WHERE SecCode = 3197040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608121110, ExchCode = 'TDG', PermQuoteRetireDate = '2017-07-14' WHERE SecCode = 3201372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781343900, ExchCode = 'STU' WHERE SecCode = 3206355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810200303, ExchCode = 'STU' WHERE SecCode = 3206356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926812, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-08', PermSecMapEndDate = '2023-06-08' WHERE SecCode = 3213267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720719093, ExchCode = 'BER', PermQuoteRetireDate = '2023-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3215568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', Ticker = '16U', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386946, ExchCode = 'LAS' WHERE SecCode = 3230847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598163107, ExchCode = 'STU' WHERE SecCode = 3236427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597107042, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-01' WHERE SecCode = 3237127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348456, ExchCode = 'DUS' WHERE SecCode = 3247427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779584053, ExchCode = 'GTX' WHERE SecCode = 3247560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601632367, Ticker = 'DRGd', ExchCode = 'BCO', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3247729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882266791, ExchCode = 'HAN' WHERE SecCode = 3269645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755977768, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3282701 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 QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804160529, ExchCode = 'GTX' WHERE SecCode = 3296207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606316234, ExchCode = 'DEU' WHERE SecCode = 3301693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606471109, ExchCode = 'DEU' WHERE SecCode = 3301863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675845, ExchCode = 'BIV' WHERE SecCode = 3302683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482882, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 3305485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803594848, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3305656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131153720, ExchCode = 'HAM' WHERE SecCode = 3315799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, ExchCode = 'STU' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799016534, PermQuoteStatus = 'AC', Ticker = '2EB0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3317114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234907, ExchCode = 'BER' WHERE SecCode = 3317120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609269032, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3317854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181314, ExchCode = 'QTX' WHERE SecCode = 3317906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611219956, ExchCode = 'MUN', PermQuoteRetireDate = '2022-12-08', PermSecMapEndDate = '2022-12-08' WHERE SecCode = 3318355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387046, ExchCode = 'LAS' WHERE SecCode = 3322821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633333080, ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-02', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 3338477 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220383, ExchCode = 'STU' WHERE SecCode = 3352147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525598, ExchCode = 'FRA' WHERE SecCode = 3357972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615253063, ExchCode = 'TDG' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050504, ExchCode = 'FRA' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615498721, ExchCode = 'FRA' WHERE SecCode = 3363519 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3366969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783783668, ExchCode = 'QTX' WHERE SecCode = 3367998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186397, ExchCode = 'DEU' WHERE SecCode = 3371968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631611214, ExchCode = 'TDG' WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617889189, ExchCode = 'AUX' WHERE SecCode = 3378309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381342, ExchCode = 'LAS' WHERE SecCode = 3378316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954032, Ticker = '18H', ExchCode = 'STU' WHERE SecCode = 3379346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765833817, Ticker = '19U', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141211, ExchCode = 'SIG' WHERE SecCode = 3392282 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55838762505.0 WHERE SecCode = 3392582 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55838762505.0 WHERE SecCode = 3394012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-02' WHERE SecCode = 3396295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624238995, ExchCode = 'TDG' WHERE SecCode = 3396912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641222426, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31', PermSecMapEndDate = NULL WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704620, ExchCode = 'MXQ' WHERE SecCode = 3404480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234952, ExchCode = 'MUN' WHERE SecCode = 3405059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630755583, ExchCode = 'STU', PermQuoteRetireDate = '2020-02-25' WHERE SecCode = 3408843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381227, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-04' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655828146, ExchCode = 'FRA' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388177, ExchCode = 'LAS' WHERE SecCode = 3409178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397561, ExchCode = 'FRA' WHERE SecCode = 3409182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704376, ExchCode = 'MXQ' WHERE SecCode = 3430658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879249284, ExchCode = 'QTX', PermQuoteRetireDate = '2026-02-04', PermSecMapEndDate = '2026-03-13' WHERE SecCode = 3431060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122579, ExchCode = 'MUN' WHERE SecCode = 3432450 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 PermSecMapEndDate = '2026-07-03' WHERE SecCode = 3445202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646838408, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3445749 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3446642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645552908, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652317413, ExchCode = 'TDG' WHERE SecCode = 3473357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647430161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100414, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3491217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749468782, ExchCode = 'FRA' WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100415, ExchCode = 'QTX' WHERE SecCode = 3509155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651518719, ExchCode = 'BER' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947481, ExchCode = 'FRA' WHERE SecCode = 3526199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344034, ExchCode = 'QTX' WHERE SecCode = 3529091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21994180608, ExchCode = 'BTE' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452965, Ticker = '28S0', ExchCode = 'FRA', PermQuoteRetireDate = '2026-02-18' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166796, ExchCode = 'FRA' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21656058784, ExchCode = 'DEU' WHERE SecCode = 3555050 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 = 55856218033, ExchCode = 'SGO' WHERE SecCode = 3587010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856218034, ExchCode = 'SGO' WHERE SecCode = 3587014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619168949, ExchCode = 'STU' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559909557, ExchCode = 'TDG' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 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 IsPrimaryQuote = 0 WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099419588, Ticker = '2NFLl', ExchCode = 'BTE' WHERE SecCode = 3669927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918858, ExchCode = 'FRA' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675373923, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114251, ExchCode = 'FRA' WHERE SecCode = 3694578 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 = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296352, ExchCode = 'GTX' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650229, ExchCode = 'DUS' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767399333, ExchCode = 'MUN' WHERE SecCode = 3848225 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 = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368210, ExchCode = 'MEX' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785083485, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-26' WHERE SecCode = 3890307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703553666, ExchCode = 'DEU' WHERE SecCode = 3897396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295405, ExchCode = 'GTX', PermQuoteRetireDate = '2024-10-01', PermSecMapEndDate = '2024-10-01' WHERE SecCode = 3949028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715682637, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3977923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712308399, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3977926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819929880, ExchCode = 'DUS' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727361952, ExchCode = 'MEX' WHERE SecCode = 4001279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808928250, Ticker = '1Tm', ExchCode = 'BCO' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064402, Ticker = '1MRKXm', ExchCode = 'BCO' WHERE SecCode = 4031720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828442, Ticker = '1CECm', ExchCode = 'BCO' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809169178, Ticker = '11COVm', ExchCode = 'BCO' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 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 = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828427, Ticker = '1EUZm', ExchCode = 'BCO' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064385, Ticker = '1KHCm', ExchCode = 'BCO' WHERE SecCode = 4031921 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55838762505.0 WHERE SecCode = 4031942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808928220, Ticker = '1RDCm', ExchCode = 'BCO' WHERE SecCode = 4031987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026937, Ticker = '1SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE', IncCntry = 'CHE' WHERE SecCode = 4043104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725610707, ExchCode = 'FRA' WHERE SecCode = 4043316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 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 = 21729412273, ExchCode = 'DEU', PermQuoteRetireDate = '2020-01-22', PermSecMapEndDate = '2020-01-22' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388381, ExchCode = 'LAS' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730198054, Ticker = 'ZWIPE', ExchCode = 'STO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799650168, PermQuoteStatus = 'DC', Ticker = '2UO0', ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-08' WHERE SecCode = 4081793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779663, ExchCode = 'MUN' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774179873, Ticker = '7M4', ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 4103711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963695, ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772833533, Ticker = '4U1A', ExchCode = 'STU', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = NULL WHERE SecCode = 4212367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752247650, ExchCode = 'FRA' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518785, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 4282397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766441949, ExchCode = 'STU' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112355, ExchCode = 'FRA' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951737.0 WHERE SecCode = 4329259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796439340, ExchCode = 'LAS' WHERE SecCode = 4333278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156626, ExchCode = 'STU' WHERE SecCode = 4355923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776539131, ValQuotePermID = 21776539131.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4388174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776573519, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-30' WHERE SecCode = 4388204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780228924, ExchCode = 'GTX', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 4400159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815144720, ExchCode = 'TDG' WHERE SecCode = 4402245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307581, ExchCode = 'MEX' WHERE SecCode = 4403942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377503, ExchCode = 'MEX' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388562, ExchCode = 'LAS' WHERE SecCode = 4472933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386726, ExchCode = 'LAS' WHERE SecCode = 4474387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897786131, ExchCode = 'MUN' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4479183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291861, ExchCode = 'BIV' WHERE SecCode = 4485970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141645, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4487640 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-02' WHERE SecCode = 4494105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820607, ExchCode = 'FRA' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951775.0 WHERE SecCode = 4524462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380209, Ticker = 'XPH', ExchCode = 'BRN' WHERE SecCode = 4531618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804817015, ExchCode = 'STU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143288, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097393503, ExchCode = 'FRA' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312301, ExchCode = 'GTX' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097158, ExchCode = 'LAS' WHERE SecCode = 4590583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380574, ExchCode = 'LAS' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-03', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 4595795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837147181, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4598716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816905312, ExchCode = 'TDG' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-03', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 4616838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091542, ExchCode = 'TQE' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818264918, ExchCode = 'FRA' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758913, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821283441, ExchCode = 'DEU' WHERE SecCode = 4630664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799608110, ExchCode = 'LAS' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780368954, ExchCode = 'TDG' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824701678, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996699, ExchCode = 'LAS' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847352047, ExchCode = 'DEU' WHERE SecCode = 4675215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, Ticker = '9KK', ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793314093, PermQuoteStatus = 'DC', Ticker = '94Y0', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388765, ExchCode = 'LAS' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832282236, ExchCode = 'MXQ' WHERE SecCode = 4695826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380604, ExchCode = 'LAS' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781822280, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-06-05' WHERE SecCode = 4709616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158672, ExchCode = 'FRA' WHERE SecCode = 4748566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098679, ExchCode = 'FRA' WHERE SecCode = 4753666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546343, ExchCode = 'GTX' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855838897, ExchCode = 'QTX' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856729893, ExchCode = 'DEU' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043646, ExchCode = 'LAS' WHERE SecCode = 4790646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097096, ExchCode = 'LAS' WHERE SecCode = 4802327 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 = 21907559014, ExchCode = 'MUN', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999710, ExchCode = 'DEU' WHERE SecCode = 4823658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864899126, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4823660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864899514, ExchCode = 'DEU' WHERE SecCode = 4823661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897333, ExchCode = 'DEU' WHERE SecCode = 4823663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290174, ExchCode = 'GTX' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864884560, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156627, ExchCode = 'MUN' WHERE SecCode = 4827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21868326996, ExchCode = 'BER', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381824, ExchCode = 'LAS' WHERE SecCode = 4845067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872789092, ExchCode = 'FRA' WHERE SecCode = 4876061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204885, ExchCode = 'MEX' WHERE SecCode = 4911170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884081519, PermQuoteStatus = 'AC', Ticker = 'K9N', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381606, ExchCode = 'LAS' WHERE SecCode = 4959596 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 = 22179871224, Ticker = '2MUE', ExchCode = 'HAM' WHERE SecCode = 4965038 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 QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894948499, ExchCode = 'PAR' WHERE SecCode = 5013560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209490, ExchCode = 'FRA' WHERE SecCode = 5059308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777507074, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401000, ExchCode = 'FRA' WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719645, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5161223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679981, ExchCode = 'BIV' WHERE SecCode = 5161230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180699, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943643469, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5174473 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 QuotePermID = 236783133624, ExchCode = 'TDG' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 5258611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935263193, ExchCode = 'DEU' WHERE SecCode = 5265003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935906810, ExchCode = 'DEU' WHERE SecCode = 5265006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935906348, ExchCode = 'DEU' WHERE SecCode = 5265007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537961037, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397462, ExchCode = 'BTE' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950823856, ExchCode = 'FRA' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902793, ExchCode = 'STU' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777698922, ExchCode = 'STU' WHERE SecCode = 5399892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962720157, ExchCode = 'DUS' WHERE SecCode = 5402910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202568, ExchCode = 'MEX' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 5430768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849037685, ExchCode = 'MUN' WHERE SecCode = 5430827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107116, ExchCode = 'MEX' WHERE SecCode = 5430834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076773, ExchCode = 'LAS', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 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 = 236778172838, ExchCode = 'FRA' WHERE SecCode = 5454711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299981, ExchCode = 'FRA' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SKG' WHERE SecCode = 5485039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831436884, Ticker = 'SFTG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5534997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471184, ExchCode = 'BIV' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471180, ExchCode = 'MEX' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060301, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-05', PermSecMapEndDate = NULL WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5584112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781224681, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966732, PermQuoteStatus = 'DC', Ticker = 'N8I1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460803, ExchCode = 'GER' WHERE SecCode = 5638843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803622939, Ticker = 'TS2S', ExchCode = 'LSE' WHERE SecCode = 5638844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830322, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835007, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5638905 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 = 22026840053, ExchCode = 'STU' WHERE SecCode = 5703208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851321, ExchCode = 'LAS' WHERE SecCode = 5706779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799652775, ExchCode = 'LAS' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784438281, ExchCode = 'STU' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236809329411.0, PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-07-03' WHERE SecCode = 5842652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788448869, ExchCode = 'BCO' WHERE SecCode = 5886974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786957574, ExchCode = 'GTX' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776334351, ExchCode = 'MEX' WHERE SecCode = 5958705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727277406, ExchCode = 'BRN' WHERE SecCode = 6032793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788414637, ExchCode = 'TYO' WHERE SecCode = 6043600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799311189, ExchCode = 'QTX' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171969, ExchCode = 'MEX' WHERE SecCode = 6097384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784422712, ExchCode = 'BIV' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536624, ExchCode = 'TDG' WHERE SecCode = 6097395 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 = 21753458103, Ticker = 'NVDS', ExchCode = 'LSE' WHERE SecCode = 6097436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745365417, PermQuoteStatus = 'DC', Ticker = 'TSLASx', ExchCode = 'CHI', PermQuoteRetireDate = '2022-03-25' WHERE SecCode = 6097440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512196, Ticker = 'NVDEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083971913, ExchCode = 'DEU' WHERE SecCode = 6104635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086901855, ExchCode = 'GTX' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784572543, ExchCode = 'BIV' WHERE SecCode = 6130315 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 = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22101513679, ExchCode = 'LAS' WHERE SecCode = 6226091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759798861, PermQuoteStatus = 'DC', Ticker = '0BF1', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798226363, PermQuoteStatus = 'DC', Ticker = '2IU1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6256420 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 = 236803707463, ExchCode = 'FKA' WHERE SecCode = 6258213 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6271271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105867713, ExchCode = 'MUN' WHERE SecCode = 6286094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792558886, ExchCode = 'FRA' WHERE SecCode = 6286099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907994, ExchCode = 'FRA' WHERE SecCode = 6308566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793240767, ExchCode = 'TYO' WHERE SecCode = 6356130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655569, ExchCode = 'FRA' WHERE SecCode = 6368870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655530, ExchCode = 'GER' WHERE SecCode = 6368872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655499, ExchCode = 'FRA' WHERE SecCode = 6368874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22189197578, Ticker = 'PJSRm', ExchCode = 'BCO' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 6501022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798271089, PermQuoteStatus = 'DC', Ticker = 'S0N', ExchCode = 'QTX', PermQuoteRetireDate = '2026-07-01' WHERE SecCode = 6503395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799371518, ExchCode = 'FRA' WHERE SecCode = 6575446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799207726, ExchCode = 'TDG' WHERE SecCode = 6580798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165242, ExchCode = 'DEU' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801913112, ExchCode = 'GTX' WHERE SecCode = 6628715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429437, ExchCode = 'QTX' WHERE SecCode = 6635297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471207, ExchCode = 'QTX' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804305881, ExchCode = 'FRA' WHERE SecCode = 6721467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804838547, ExchCode = 'BIV' WHERE SecCode = 6748872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169522181, ExchCode = 'DEU' WHERE SecCode = 6748898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169522316, ExchCode = 'DEU' WHERE SecCode = 6748899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805094212, ExchCode = 'MUN' WHERE SecCode = 6748900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6772975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22177707113, ExchCode = 'DEU' WHERE SecCode = 6829248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408712, ExchCode = 'BIV' WHERE SecCode = 6900891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807977903, ExchCode = 'FRA' WHERE SecCode = 6900894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807978130, ExchCode = 'FRA' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808060836, ExchCode = 'TDG' WHERE SecCode = 6911172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808331780, ExchCode = 'CHI' WHERE SecCode = 6914466 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 6937615 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-03' WHERE SecCode = 6937628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22190167269, ExchCode = 'DEU' WHERE SecCode = 6951893 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6951895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809204238, Ticker = '544805', ExchCode = 'BSE', PermSecMapStartDate = '2026-06-30' WHERE SecCode = 6955116 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6955124 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6955163 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6955164 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6955165 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6955166 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6955190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22191150152, ExchCode = 'QTX' WHERE SecCode = 6955205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22191150151, ExchCode = 'QTX' WHERE SecCode = 6955206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22191150150, ExchCode = 'QTX' WHERE SecCode = 6955207 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1, IsPrimaryInstr = 1, PriTRBCIndPermID = 4294951745.0, PermOrgIPODate = '2026-07-03' WHERE SecCode = 6957660 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1, IsPrimaryInstr = 1, PermOrgIPODate = '2026-07-02' WHERE SecCode = 6957662 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6957668 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6957671 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236809272017.0 WHERE SecCode = 6957712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809298337, ValQuotePermID = 236809293316.0, ExchCode = 'TQE' WHERE SecCode = 6960467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809271784, PriTrdQuotePermID = 236809271784.0, ExchCode = 'ASE', PermSecMapStartDate = '2026-07-02' WHERE SecCode = 10920375 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11182627 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11204164 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11207414 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11245064 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11247311 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11267756 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11272674 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-07-03' WHERE SecCode = 11273677 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11274561 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11280087 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11286400 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11290231 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11290276 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11290280 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11290281 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11290369 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11290371 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294151 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294152 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294153 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294158 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294159 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294162 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294163 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294164 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294167 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294168 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294169 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294170 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294172 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294173 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294203 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294205 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 11294206 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11295808 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232933116409.0, IsPrimaryInstr = 0 WHERE SecCode = 11295910 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232925354116.0, IsPrimaryInstr = 0 WHERE SecCode = 11295911 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232925334128.0 WHERE SecCode = 11295985 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232905293752.0 WHERE SecCode = 11295986 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11296943 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809208556, PriTrdQuotePermID = 236809208556.0, ValQuotePermID = 25727015323.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NSM' WHERE SecCode = 11298541 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809208520, PriTrdQuotePermID = 236809208520.0, ValQuotePermID = 25727015385.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NMS' WHERE SecCode = 11298594 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236809208538, PriTrdQuotePermID = 236809208538.0, ValQuotePermID = 25727015322.0, IsPrimaryQuote = 1, ExchCode = 'NMS' WHERE SecCode = 11298595 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236809271604.0, ValQuotePermID = 25727015245.0 WHERE SecCode = 11298688 AND Type_ = 1;