UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1098 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 6817 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 6818 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 6878 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 8521 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836052415, Ticker = 'ZHEH', ExchCode = 'LSE', PermQuoteRetireDate = '2023-05-19' WHERE SecCode = 9121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461399, Ticker = '0Q1Nl', ExchCode = 'BCO' WHERE SecCode = 9338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836049459, Ticker = 'PACC', ExchCode = 'LSE', PermQuoteRetireDate = '2016-03-07' WHERE SecCode = 9856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556856, Ticker = 'KPN', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 9908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621264, Ticker = '0KXA', ExchCode = 'LSE' WHERE SecCode = 10268 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 13073 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 15037 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GLW' WHERE SecCode = 29782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358466, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475561654, PermQuoteStatus = 'DC', Ticker = 'ALDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34314 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 = 55836386343, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-31' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'KY3' WHERE SecCode = 35131 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 35462 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 35474 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 35486 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 36199 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 36511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475586089, PermQuoteStatus = 'DC', Ticker = 'CPAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 38268 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 38269 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 39255 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'KWY' WHERE SecCode = 39746 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 40705 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 40728 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 41810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581385252, ExchCode = 'DEU' WHERE SecCode = 43705 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 43708 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 44241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853561637, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 48843 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 49518 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 49524 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951937.0 WHERE SecCode = 50491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 53117 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 54202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475576317, ExchCode = 'STU', PermQuoteRetireDate = '2008-01-07' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417008, ExchCode = 'MUN', PermQuoteRetireDate = '2009-11-19' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 55621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590786433, ExchCode = 'TDG' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835934, Ticker = 'STFd', ExchCode = 'BCO' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641483764, ExchCode = 'STU' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 58166 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 58763 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 59013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475443568, ExchCode = 'STU', PermQuoteRetireDate = '2010-02-03' WHERE SecCode = 59024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961976075, ExchCode = 'FRA' WHERE SecCode = 59936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613489654, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-06' WHERE SecCode = 59963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322892, ExchCode = 'BER' WHERE SecCode = 60097 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427368, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836516282, ExchCode = 'FRA' WHERE SecCode = 60537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531132175, Ticker = 'NSUd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601556166, ExchCode = 'STU' WHERE SecCode = 61371 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 61787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 62188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 63901 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 64214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411094, ExchCode = 'FRA' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742524, ExchCode = 'HAN' WHERE SecCode = 66686 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951397.0 WHERE SecCode = 67941 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 69368 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 69369 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 69396 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 69660 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 70372 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951291.0 WHERE SecCode = 70974 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 73356 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 75101 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 76098 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 77602 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 79181 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 79958 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BUYDA' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 83718 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 83793 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84824 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84858 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 85079 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 85244 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951699.0 WHERE SecCode = 85569 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 85706 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 85932 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 86038 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87770 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 88176 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 88307 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 88867 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 89411 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 90824 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 90856 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 90896 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 90904 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 91591 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 94094 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365342.0 WHERE SecCode = 94232 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 95664 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 96735 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 97724 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 99097 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951291.0 WHERE SecCode = 99519 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 100588 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 100613 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 100614 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 103428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521652536, ExchCode = 'BER' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914302350, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627613, ExchCode = 'DEU' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528804114, ExchCode = 'STU' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499886, ExchCode = 'GER' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569056620, ExchCode = 'MUN' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 105655 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 111294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951699.0 WHERE SecCode = 112263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857170641, ExchCode = 'QTX' WHERE SecCode = 112468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183753, ExchCode = 'MXQ' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951630.0 WHERE SecCode = 114518 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 115419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298391, ExchCode = 'FRA' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525931704, ExchCode = 'STU' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008736, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 117749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474928478, ExchCode = 'DEU' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179548619, ExchCode = 'DEU' WHERE SecCode = 119132 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951937.0 WHERE SecCode = 131115 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 136711 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 140147 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 141169 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VISACHROME' WHERE SecCode = 143733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 144058 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-28' WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 145246 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 145393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491680, ExchCode = 'QTX' WHERE SecCode = 146365 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 146469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474940370, ExchCode = 'DEU' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514316877, ExchCode = 'STU' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-07' WHERE SecCode = 165534 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 176163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517511603, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-04', PermSecMapEndDate = '2024-04-04' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836489072, ExchCode = 'FRA' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650181, ExchCode = 'DUS' WHERE SecCode = 179171 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 191026 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21672400458, Ticker = 'SEL', ExchCode = 'MIL' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 200545 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'DD5' WHERE SecCode = 213645 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951291.0 WHERE SecCode = 249342 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 276136 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 283346 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 283347 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 283348 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 292595 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 302783 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 309339 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 313541 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21531772020, ExchCode = 'STU' WHERE SecCode = 319526 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 321759 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 324169 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 324858 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 326447 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-20' WHERE SecCode = 327476 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 330800 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 332777 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 334505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178668432, ExchCode = 'DEU' WHERE SecCode = 336756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845607, ExchCode = 'FRA' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914565, ExchCode = 'FRA' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 363995 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951366.0 WHERE SecCode = 373240 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 376430 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 395153 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951699.0 WHERE SecCode = 427679 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 432432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 467564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 520745 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 529184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856295357, ExchCode = 'STU' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 547445 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 547521 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 555531 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 558794 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 559112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565562489, ExchCode = 'BEC' WHERE SecCode = 561528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908479, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 566221 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 568904 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-21' WHERE SecCode = 577384 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 578755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255888, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-17' WHERE SecCode = 600391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 773879 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 829995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 1091913 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 1109069 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 = 21478824473, ExchCode = 'TDG' WHERE SecCode = 1480701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514028112, ExchCode = 'TDG' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704626, ExchCode = 'MXQ' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289597, ExchCode = 'FRA' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659841732, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098687, ExchCode = 'DEU' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 1530809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480768, ExchCode = 'QTX' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849881, Ticker = 'RBT', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492895638, ExchCode = 'DEU', PermQuoteRetireDate = '2014-04-08' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273313, ExchCode = 'GTX' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 1538579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775091189, ExchCode = 'DEU' WHERE SecCode = 1541396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779440, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 1544250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480207, PermQuoteStatus = 'DC', Ticker = '7NU', ExchCode = 'QTX', PermQuoteRetireDate = '2023-08-03', PermSecMapEndDate = '2025-06-13' WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802875945, ExchCode = 'LAS' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650254, ExchCode = 'DUS' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583635015, ExchCode = 'DEU' WHERE SecCode = 1552943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498532317, ExchCode = 'FRA' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502335108, ExchCode = 'FRA' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884533, ExchCode = 'MUN' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 1582265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505184781, ExchCode = 'STO' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515927789, ExchCode = 'DEU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068247, ExchCode = 'TDG' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1614017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493518, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513069367, ExchCode = 'TDG' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100401, ExchCode = 'QTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510005786, ExchCode = 'FRA' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835904, Ticker = '7O2d', ExchCode = 'BCO' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320060, ExchCode = 'DEU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522286896, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504836182, Ticker = 'CHMT', ExchCode = 'PAR', PermQuoteRetireDate = '2017-04-25' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799113029, ExchCode = 'LAS' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183066, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-18' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512395856, ExchCode = 'DEU' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426483, ExchCode = 'MUN' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955269, ExchCode = 'FRA' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 1720593 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 PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 1725270 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 1725271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513253394, ExchCode = 'BER', PermQuoteRetireDate = '2015-08-19' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480142, ExchCode = 'QTX' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 1876384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860800, ExchCode = 'FRA' WHERE SecCode = 1905111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513493664, ExchCode = 'FRA' WHERE SecCode = 1905903 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 1948243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423685, ExchCode = 'FRA' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673265, ExchCode = 'BIV' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516375730, ExchCode = 'FRA' WHERE SecCode = 2021774 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 PriTRBCIndPermID = 4294951469.0 WHERE SecCode = 2077605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302126, ExchCode = 'STU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589938022, ExchCode = 'FRA' WHERE SecCode = 2126923 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 = 21521578467, ExchCode = 'DEU' WHERE SecCode = 2200210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525927737, ExchCode = 'FRA' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485240, ExchCode = 'QTX' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525642309, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-10' WHERE SecCode = 2279777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527321541, Ticker = 'GPA', ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834371, ExchCode = 'DEU' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 2370529 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2372641 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 = 236784384853, ExchCode = 'LAS' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607391, ExchCode = 'QTX' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223768, ExchCode = 'QTX' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386146, ExchCode = 'LAS' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET 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 = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 2545067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782012516, ExchCode = 'DEU' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589641130, ExchCode = 'STU' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2655939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 2665954 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-20' WHERE SecCode = 2682415 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 2696579 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 2697120 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 2710430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355954, ExchCode = 'TDG' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 2739724 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 = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21577065352, ExchCode = 'DEU' WHERE SecCode = 2887226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033693, InstrPermID = 8590942120, OrgPermID = 4295862624, ValQuotePermID = 55838794989.0, PriInstrPermID = 8590942120.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'A4L', ExchCode = 'TDG', PermQuoteRetireDate = '2015-07-06', PermOrgIPODate = NULL WHERE SecCode = 2939990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 2981355 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 3001099 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2022-02-07' WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951366.0 WHERE SecCode = 3040832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048899, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578813192, ExchCode = 'FRA' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579890634, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3068301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927375, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2020-07-09' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460747, Ticker = 'OD7F', ExchCode = 'FRA' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100417, ExchCode = 'QTX' WHERE SecCode = 3080538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235696, ExchCode = 'DUS' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569839, ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-08' WHERE SecCode = 3102662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586629555, Ticker = 'W47', ExchCode = 'TDG', PermQuoteRetireDate = '2025-05-02' WHERE SecCode = 3104810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386091, ExchCode = 'LAS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704245, ExchCode = 'MXQ' WHERE SecCode = 3120787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164689174, ExchCode = 'MUN' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621432527, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3121290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705450, ExchCode = 'MXQ' WHERE SecCode = 3123787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544712, ExchCode = 'QTX' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 3148614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460744, ExchCode = 'FRA' WHERE SecCode = 3160192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285715, ExchCode = 'DUS' WHERE SecCode = 3160205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077947, ExchCode = 'LAS' WHERE SecCode = 3160206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724552589, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3177550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548007992, ExchCode = 'FRA' WHERE SecCode = 3177608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705812, Ticker = 'TLRDQ*', ExchCode = 'MXQ' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460804, ExchCode = 'GER' WHERE SecCode = 3195424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460787, ExchCode = 'GER' WHERE SecCode = 3195425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460803, ExchCode = 'GER' WHERE SecCode = 3195426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862038094, ExchCode = 'DUS' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997785, ExchCode = 'FRA' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786584619, ExchCode = 'FRA' WHERE SecCode = 3198703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821257511, ExchCode = 'DUS' WHERE SecCode = 3199702 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 = 21830274001, ExchCode = 'GTX', PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 3200605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962344738, Ticker = '1VOW3m', ExchCode = 'BTE' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591801382, ExchCode = 'BER' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449069, ExchCode = 'DEU' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016577, ExchCode = 'MUN' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150007, Ticker = 'AD', ExchCode = 'SWX' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614269130, ExchCode = 'MUN' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963315, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-11' WHERE SecCode = 3228677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999663, ExchCode = 'FRA' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301751, Ticker = '0EF', ExchCode = 'GTX' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824694891, ExchCode = 'DUS' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485238, Ticker = '1CBK', ExchCode = 'MIL' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373312, ExchCode = 'DEU' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415254, ExchCode = 'MUN' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684286324, Ticker = '3660', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-02' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597702989, ExchCode = 'DEU' WHERE SecCode = 3260047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598409316, ExchCode = 'DEU', PermQuoteRetireDate = '2016-11-11' WHERE SecCode = 3260094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800110, ExchCode = 'CHI' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663194058, ExchCode = 'MEX' WHERE SecCode = 3271811 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 3277208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582105, ExchCode = 'TDG' WHERE SecCode = 3282881 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 3282990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604352845, ExchCode = 'STU' WHERE SecCode = 3283650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605105387, ExchCode = 'BER', PermQuoteRetireDate = '2019-02-08' WHERE SecCode = 3283717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634479982, ExchCode = 'MUN' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833203, ExchCode = 'DEU' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797988618, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-29' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750316962, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786651644, ExchCode = 'QTX' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443154, ExchCode = 'DEU' WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 3321104 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3321123 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3322333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3324228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649841825, ExchCode = 'BER' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612487102, ExchCode = 'DEU' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 3359156 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 3367947 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 3385617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019517, ExchCode = 'FRA' WHERE SecCode = 3386374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920549797, ExchCode = 'DEU' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029272, ExchCode = 'SWX' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029271, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-07-04' WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624542752, ExchCode = 'DEU' WHERE SecCode = 3400265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674061, ExchCode = 'BIV' WHERE SecCode = 3403875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234952, ExchCode = 'MUN' WHERE SecCode = 3405059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141123, ExchCode = 'FRA' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256368, ExchCode = 'QTX' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629380897, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-19', PermSecMapStartDate = '2017-12-11', PermSecMapEndDate = '2026-05-19' WHERE SecCode = 3408227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631199559, ExchCode = 'STU' WHERE SecCode = 3410277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630898, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-02-21', PermSecMapEndDate = '2026-01-29' WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630922, ExchCode = 'FRA', PermQuoteRetireDate = '2025-02-26', PermSecMapEndDate = '2025-02-26' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3431690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634766459, ExchCode = 'DEU' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 3433323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651603021, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-26' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 3435654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21834281133, ExchCode = 'TDG' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643435020, ExchCode = 'FRA' WHERE SecCode = 3441171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679474, ExchCode = 'BIV' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298408, ExchCode = 'GTX' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 3446473 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 3446474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305949, ExchCode = 'FRA' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645435116, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-02' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '0UL0', PermSecMapEndDate = '2023-12-27' WHERE SecCode = 3507389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650788270, Ticker = NULL, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305699, ExchCode = 'GTX' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452965, ExchCode = 'FRA' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656632105, Ticker = 'DNK', ExchCode = 'LSE', PermQuoteRetireDate = '2021-09-24' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951249.0 WHERE SecCode = 3568468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-10-07' WHERE SecCode = 3587035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3731076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750785399, ExchCode = 'DEU' WHERE SecCode = 3731132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733938467, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-05', PermSecMapEndDate = NULL WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690815100, ExchCode = 'DEU' WHERE SecCode = 3817679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196448, ExchCode = 'DUS' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932282, ExchCode = 'DEU' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590408, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727370134, Ticker = 'IMGN*', ExchCode = 'BIV' WHERE SecCode = 3864446 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 3878847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701450919, ExchCode = 'MUN' WHERE SecCode = 3881176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704921848, ExchCode = 'DEU' WHERE SecCode = 3906532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365612.0 WHERE SecCode = 3909704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-05-20' WHERE SecCode = 3945211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 3968255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4043071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725971281, ExchCode = 'TDG' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 4077659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 4106653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787721995, ExchCode = 'MUN' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21740303517, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097198, ExchCode = 'LAS' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778023555, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-28' WHERE SecCode = 4228115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406183, ExchCode = 'DEU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756548990, ExchCode = 'FRA' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'MAV0' WHERE SecCode = 4335842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799675, ExchCode = 'HAM' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606711, ExchCode = 'FRA' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510749, ExchCode = 'DUS' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644859, ExchCode = 'STU' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783391809, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349094, ExchCode = 'MEX' WHERE SecCode = 4382991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739113739, ExchCode = 'QTX' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 4388121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531963, ExchCode = 'GTX' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778679902, ExchCode = 'MUN' WHERE SecCode = 4394781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644978, ExchCode = 'BER' WHERE SecCode = 4394782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826522500, ExchCode = 'QTX' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786673386, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777025689, ExchCode = 'STU' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790192047, ExchCode = 'FRA' WHERE SecCode = 4425728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307225, ExchCode = 'MEX' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653687, ExchCode = 'MUN' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727170684, ExchCode = 'SIG' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026948, Ticker = '1VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810230, ExchCode = 'CHI' WHERE SecCode = 4429632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991601, ExchCode = 'FRA' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 4434315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685950, ExchCode = 'DEU' WHERE SecCode = 4444002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740545, ExchCode = 'LAS' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790713764, ExchCode = 'STU' WHERE SecCode = 4458936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789562275, ExchCode = 'FRA' WHERE SecCode = 4458938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954874, ExchCode = 'LAS' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791933842, ExchCode = 'DUS' WHERE SecCode = 4463150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306964, ExchCode = 'BEC' WHERE SecCode = 4464699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835452, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4466437 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 4466633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793533769, PermQuoteStatus = 'DC', ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-24' WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798225679, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-12', PermSecMapEndDate = '2025-02-12' WHERE SecCode = 4470353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727302437, ExchCode = 'MEX' WHERE SecCode = 4472876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781362966, ExchCode = 'DUS', PermQuoteRetireDate = '2024-02-20' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817586, ExchCode = 'DEU' WHERE SecCode = 4481115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835966, PermQuoteRetireDate = '2023-09-27' WHERE SecCode = 4487664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342536, ExchCode = 'MEX' WHERE SecCode = 4492131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555797, ExchCode = 'DEU' WHERE SecCode = 4496736 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 4499133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799115765, ExchCode = 'LAS' WHERE SecCode = 4502474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287359, ExchCode = 'MEX' WHERE SecCode = 4505578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813169859, ExchCode = 'TDG' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386713, ExchCode = 'LAS' WHERE SecCode = 4513650 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 4513757 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 4517649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387389, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4527883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 4531959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954971, ExchCode = 'LAS' WHERE SecCode = 4536359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804817015, ExchCode = 'STU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 4546565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301437, ExchCode = 'BIV' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349196, ExchCode = 'BIV' WHERE SecCode = 4550708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893554092, ExchCode = 'DEU' WHERE SecCode = 4554184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143000521, ExchCode = 'DEU' WHERE SecCode = 4557948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872251161, ExchCode = 'MUN' WHERE SecCode = 4568422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950973, ExchCode = 'FRA' WHERE SecCode = 4568423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811570272, ExchCode = 'MUN' WHERE SecCode = 4585453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305820, ExchCode = 'BIV' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379572, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4598716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549166, ExchCode = 'GTX' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817036435, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21944534852, ExchCode = 'STU' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138518181, ExchCode = 'BCO' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799779, ExchCode = 'HAM' WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963730, ExchCode = 'STU' WHERE SecCode = 4641628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334921, ExchCode = 'DEU' WHERE SecCode = 4643318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073655, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-22', PermSecMapEndDate = '2025-12-22' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381815, ExchCode = 'LAS' WHERE SecCode = 4658662 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4667070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914397, ExchCode = 'STU' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388764, ExchCode = 'LAS' WHERE SecCode = 4676228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, Ticker = 'CARBm', ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153605, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011348, Ticker = '2STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043657, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845567605, ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854716241, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4742663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742271, ExchCode = 'DEU' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307219, ExchCode = 'BIV' WHERE SecCode = 4768117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552670, ExchCode = 'LAS' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722496, ExchCode = 'MUN' WHERE SecCode = 4775201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705511, ExchCode = 'STU' WHERE SecCode = 4786540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858098062, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4786544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860077592, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4800489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105263, ExchCode = 'MUN' WHERE SecCode = 4800490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860307393, ExchCode = 'STU' WHERE SecCode = 4800491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898480958, ExchCode = 'MUN' WHERE SecCode = 4800492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216390, ExchCode = 'BIV' WHERE SecCode = 4800493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231064, ExchCode = 'BCO' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886807336, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369659, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 4819878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947043272, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234885, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-09-25' WHERE SecCode = 4827911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727258450, ExchCode = 'BIV' WHERE SecCode = 4827927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580680, ExchCode = 'DEU' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953884, ExchCode = 'MUN', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866893816 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398299, ExchCode = 'FRA', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580391, ExchCode = 'FRA' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055968, ExchCode = 'GTX' WHERE SecCode = 4845045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888021696, ExchCode = 'GTX' WHERE SecCode = 4846846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301751, ExchCode = 'FRA' WHERE SecCode = 4852142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140095713, ExchCode = 'HAM' WHERE SecCode = 4854866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871894898, ExchCode = 'DEU' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129773, Ticker = '9XK0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-21' WHERE SecCode = 4873803 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 4882385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874645094, ExchCode = 'TDG' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929410708, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656927, ExchCode = 'FRA' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 4897802 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 4914438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888704331, PermQuoteStatus = 'AC', Ticker = 'V6M1', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 4975852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953078, ExchCode = 'FRA' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894536981, ExchCode = 'DUS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 5022238 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TMHK' WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898242757, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-03-19', PermSecMapEndDate = '2026-03-19' WHERE SecCode = 5038681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902626358, Ticker = 'XWD1', ExchCode = 'LSE' WHERE SecCode = 5067183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727206688, ExchCode = 'MEX' WHERE SecCode = 5067670 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 5072142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663797, ExchCode = 'DEU' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380640, ExchCode = 'LAS' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204807, ExchCode = 'MEX' WHERE SecCode = 5099007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349287, Ticker = 'ABEC', ExchCode = 'BRN' WHERE SecCode = 5099022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729398003, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-31' WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 5119086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915977241, ExchCode = 'DEU' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 5142401 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 5142402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430438, ExchCode = 'DEU' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430452, ExchCode = 'DEU' WHERE SecCode = 5153444 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 = 25727347142, ExchCode = 'BIV' WHERE SecCode = 5161305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180699, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344849, ExchCode = 'BIV' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, ExchCode = 'DUS' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421566, PermQuoteStatus = 'AC', Ticker = '3SZNm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872761574, Ticker = 'AFTT', ExchCode = 'PAR' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801543852, ExchCode = 'HAM' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790104332, ExchCode = 'FRA' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787664879, ExchCode = 'QTX' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959379813, ExchCode = 'TDG' WHERE SecCode = 5265007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397479, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 5272295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 5281315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979391, ExchCode = 'QTX' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894948509, PermQuoteStatus = 'AC', ExchCode = 'AEX', PermQuoteRetireDate = NULL WHERE SecCode = 5315560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732431, ExchCode = 'MEX' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954130974, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803603455, ExchCode = 'TDG' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716964, ExchCode = 'DEU' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962357045, ExchCode = 'DEU' WHERE SecCode = 5395770 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 5402782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812181526, ExchCode = 'FRA' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 5460511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779165176, ExchCode = 'STU' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223819, ExchCode = 'QTX' WHERE SecCode = 5479512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893349, ExchCode = 'TDG' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421406, PermQuoteStatus = 'AC', Ticker = '3LFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5496168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982260691, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5496242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982274729, Ticker = '3BAS', ExchCode = 'MIL' WHERE SecCode = 5496244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904150, ExchCode = 'CHI' WHERE SecCode = 5503692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528245, ExchCode = 'STU' WHERE SecCode = 5503701 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 = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823945, ExchCode = 'AQE' WHERE SecCode = 5503780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663720, ExchCode = 'AQE' WHERE SecCode = 5503782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776471889, ExchCode = 'BIV' WHERE SecCode = 5503860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309751, Ticker = '3LPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891290, ExchCode = 'FRA' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787446918, ExchCode = 'STU' WHERE SecCode = 5523278 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 = 21992342600, ExchCode = 'DEU' WHERE SecCode = 5550738 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21995078680, ExchCode = 'DEU' WHERE SecCode = 5563110 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 5563558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833306101, Ticker = '3LZN', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5569207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835780, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110928, PermQuoteStatus = 'AC', Ticker = 'FANGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143010649, ExchCode = 'QTX' WHERE SecCode = 5569235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828704528, Ticker = 'FANG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5569236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835651, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830166, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5569303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566165, ExchCode = 'DEU' WHERE SecCode = 5569313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864463, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566180, ExchCode = 'FRA' WHERE SecCode = 5569354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566250, ExchCode = 'GER' WHERE SecCode = 5569360 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 = 236779955537, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-15' WHERE SecCode = 5570015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152999678, Ticker = 'NGLSl', ExchCode = 'AQX' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659889, ExchCode = 'BIV' WHERE SecCode = 5590170 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780192624, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212166, ExchCode = 'BIV' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5611413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781095333, ExchCode = 'STU' WHERE SecCode = 5633895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778712188, ExchCode = 'BIV' WHERE SecCode = 5644662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954864, ExchCode = 'LAS' WHERE SecCode = 5655040 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 = 236781580967, ExchCode = 'STU' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866504754, ExchCode = 'UAX' WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138698590, ExchCode = 'HAM' WHERE SecCode = 5674239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020600393, ExchCode = 'DEU' WHERE SecCode = 5679100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858189, ExchCode = 'FRA' WHERE SecCode = 5687957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782376739, ExchCode = 'FRA' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22027362169, ExchCode = 'STU' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793731712, ExchCode = 'TDG' WHERE SecCode = 5731414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782771597, ExchCode = 'FRA' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928831, Ticker = 'SOXLm', ExchCode = 'BCO' WHERE SecCode = 5740824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928832, Ticker = 'MAG7m', ExchCode = 'BCO' WHERE SecCode = 5740826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690921, ExchCode = 'BCO' WHERE SecCode = 5740827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 5740830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097265, ExchCode = 'LAS' WHERE SecCode = 5745665 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 = 236784379581, ExchCode = 'LAS' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419156, ExchCode = 'LAS' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154585460, ExchCode = 'BTE' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107272, ExchCode = 'FRA' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 5820889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207229, ExchCode = 'FRA' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784278056, ExchCode = 'STU' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357765, ExchCode = 'BIV' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786957574, ExchCode = 'GTX' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786044119, ExchCode = 'GTX', PermQuoteRetireDate = '2025-05-09', PermSecMapEndDate = NULL WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786091052, ExchCode = 'FRA' WHERE SecCode = 5914176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784960654, ExchCode = 'MEX' WHERE SecCode = 5917759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666338, ExchCode = 'DXE' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061296562, ExchCode = 'STU' WHERE SecCode = 5920851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934081, ExchCode = 'TDG' WHERE SecCode = 5931913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786509617, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5931956 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 5936371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798309817, ExchCode = 'FRA' WHERE SecCode = 5947065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786800651, ExchCode = 'FRA' WHERE SecCode = 5947076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787906828, Ticker = '7YG', ExchCode = 'STU' WHERE SecCode = 5949087 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'AUS' WHERE SecCode = 5958664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799223625, ExchCode = 'TQE' WHERE SecCode = 5959461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782630075, ExchCode = 'FRA' WHERE SecCode = 5969012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787590957, ExchCode = 'STU' WHERE SecCode = 5978470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787541533, ExchCode = 'TDG' WHERE SecCode = 5978474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786355845, ExchCode = 'BIV' WHERE SecCode = 5985969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788004437, ExchCode = 'FRA' WHERE SecCode = 6001792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207224, ExchCode = 'FRA' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782564339, ExchCode = 'MEX' WHERE SecCode = 6032854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792840838, Ticker = '1HUTm', ExchCode = 'BCO' WHERE SecCode = 6047903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788967709, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6050973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180991, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180917, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976518, ExchCode = 'SGO' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902796, ExchCode = 'FRA' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834786, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835874, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834880, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834808, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827614120, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22030766403, ExchCode = 'BTE' WHERE SecCode = 6097336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835789, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089781512, PermQuoteStatus = 'AC', Ticker = 'A4AN9W', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674562, ExchCode = 'BIV' WHERE SecCode = 6097401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829820, ExchCode = 'GER' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753429666, PermQuoteStatus = 'AC', Ticker = 'TSLS', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 6097440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128285, ExchCode = 'BCO' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779005194, PermQuoteStatus = 'AC', Ticker = '5VF', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480616, ExchCode = 'QTX' WHERE SecCode = 6097577 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951819.0 WHERE SecCode = 6117161 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951819.0 WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 6139935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793109030, ExchCode = 'LAS' WHERE SecCode = 6151861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509192, ExchCode = 'TDG' WHERE SecCode = 6204565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 6223907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111001, Ticker = 'BTCFl', ExchCode = 'BTE' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580182, ExchCode = 'DUS' WHERE SecCode = 6256405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181397, ExchCode = 'BIV' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293760, Ticker = '2IU0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 6264012 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 6264046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792206094, ExchCode = 'QTX' WHERE SecCode = 6264277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269530, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269527, ExchCode = 'HAM' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792340963, ExchCode = 'DUS' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792747075, ExchCode = 'FRA' WHERE SecCode = 6297519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792747076, ExchCode = 'FRA' WHERE SecCode = 6297520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792747071, ExchCode = 'FRA' WHERE SecCode = 6297523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988748, ExchCode = 'MUN' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 6316658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22110493298, ExchCode = 'DEU' WHERE SecCode = 6318955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793283369, ExchCode = 'GTX' WHERE SecCode = 6318956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788323, ExchCode = 'BIV' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GLWD' WHERE SecCode = 6325279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6360729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793732870, ExchCode = 'SIG' WHERE SecCode = 6361844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056707, ExchCode = 'STU' WHERE SecCode = 6364834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745447, ExchCode = 'MEX' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794030741, ExchCode = 'DUS' WHERE SecCode = 6383874 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 6389714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794094894, ExchCode = 'QTX' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515592, ExchCode = 'MEX' WHERE SecCode = 6394335 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6407289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799203643, ExchCode = 'ASX' WHERE SecCode = 6421140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083975572, ExchCode = 'QTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793789294, ExchCode = 'TDG' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788837443, ExchCode = 'MEX' WHERE SecCode = 6448789 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 6449044 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 6449060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695775, ExchCode = 'GTX' WHERE SecCode = 6451070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795802495, ExchCode = 'QTX' WHERE SecCode = 6453946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125760536, ExchCode = 'MIL' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231077, ExchCode = 'BCO' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128281486, ExchCode = 'QTX' WHERE SecCode = 6457998 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 6482766 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 6492959 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 6501101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798105812, ExchCode = 'QTX' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 6522468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462190, ExchCode = 'GTX' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799161275, ExchCode = 'MUN' WHERE SecCode = 6548128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798768097, ExchCode = 'DUS' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547036355, Ticker = 'UNV0d', ExchCode = 'BCO' WHERE SecCode = 6551100 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 6552508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799174470, ExchCode = 'FRA' WHERE SecCode = 6564772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140857331, ExchCode = 'FRA' WHERE SecCode = 6564781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799174468, ExchCode = 'FRA' WHERE SecCode = 6564784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727300993, Ticker = '724', ExchCode = 'BRN' WHERE SecCode = 6578367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607253, Ticker = 'KR', ExchCode = 'SWX' WHERE SecCode = 6578370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793223, ExchCode = 'DEU' WHERE SecCode = 6593800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800709245, ExchCode = 'QTX' WHERE SecCode = 6593866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800600756, ExchCode = 'FRA' WHERE SecCode = 6603628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135602762, ExchCode = 'GTX' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451421, ExchCode = 'CHI' WHERE SecCode = 6627463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801727826, ExchCode = 'FRA' WHERE SecCode = 6627853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801543940, ExchCode = 'HAM' WHERE SecCode = 6628842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22155220901, ExchCode = 'DEU' WHERE SecCode = 6629415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156552523, ExchCode = 'STU' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803239109, ExchCode = 'MEX' WHERE SecCode = 6680976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165589156, ExchCode = 'DEU' WHERE SecCode = 6716121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165599099, ExchCode = 'DEU' WHERE SecCode = 6716122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165599170, ExchCode = 'DEU' WHERE SecCode = 6716123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165601692, ExchCode = 'DEU' WHERE SecCode = 6716124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165601854, ExchCode = 'DEU' WHERE SecCode = 6716125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804778699, ExchCode = 'GTX' WHERE SecCode = 6721535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804839165, InstrPermID = 232924875827, ValQuotePermID = NULL, IsPrimaryQuote = 0, IsPrimaryInstr = 1, PermInstrStatus = 'NA', Ticker = 'GENOO', ExchCode = 'STO' WHERE SecCode = 6741012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 6773031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173818047, ExchCode = 'TDG' WHERE SecCode = 6773144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140087946, ExchCode = 'HAM' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406435, ExchCode = 'BIV' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806019660, ExchCode = 'BIV' WHERE SecCode = 6797367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806409092, ExchCode = 'MUN' WHERE SecCode = 6797368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168114, ExchCode = 'FRA' WHERE SecCode = 6802854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806166496, ExchCode = 'TDG' WHERE SecCode = 6802855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168121, ExchCode = 'FRA' WHERE SecCode = 6802856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168123, ExchCode = 'FRA' WHERE SecCode = 6802860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168117, ExchCode = 'FRA' WHERE SecCode = 6802861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524855, ExchCode = 'DEU' WHERE SecCode = 6808918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176578988, ExchCode = 'DEU' WHERE SecCode = 6820242 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 6826515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176932924, ExchCode = 'DEU' WHERE SecCode = 6826539 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 6826558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178348922, ExchCode = 'DEU' WHERE SecCode = 6836182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178354350, ExchCode = 'DEU' WHERE SecCode = 6836183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178354486, ExchCode = 'DEU' WHERE SecCode = 6836184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178355606, ExchCode = 'DEU' WHERE SecCode = 6836185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179528075, ExchCode = 'DEU' WHERE SecCode = 6849998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807026219, ExchCode = 'FRA' WHERE SecCode = 6854883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807105937, ExchCode = 'MUN' WHERE SecCode = 6854888 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-18' WHERE SecCode = 6857272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835099, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6857276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22180375757, ExchCode = 'DEU' WHERE SecCode = 6857285 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 10810595 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 10813256 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 10814695 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 10902572 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 10928741 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 10959307 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10966118 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 11003215 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 11021466 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11030383 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11044262 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-20' WHERE SecCode = 11052723 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'STTMF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-18', PermSecMapEndDate = NULL WHERE SecCode = 11057745 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 11057747 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 11058213 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 11059029 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 11059225 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 11105619 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 11108466 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11108815 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-19', PermSecMapEndDate = '2022-08-26' WHERE SecCode = 11139994 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 11141262 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 11152843 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'AGNPF' WHERE SecCode = 11156632 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11166691 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11169119 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11174891 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ULTHD', PermSecMapEndDate = '2023-12-27' WHERE SecCode = 11185275 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951249.0 WHERE SecCode = 11188389 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 11189369 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11189848 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11194993 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AMHLF', PermQuoteRetireDate = NULL WHERE SecCode = 11201407 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11207860 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 11210769 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236793886067, PermQuoteStatus = 'DC', Ticker = 'CRMWF', ExchCode = 'GTC', PermQuoteRetireDate = '2025-08-06', PermSecMapStartDate = '2021-05-11', PermSecMapEndDate = '2025-08-06' WHERE SecCode = 11211313 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 11213537 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11214647 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 11215416 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-11-21' WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-19', PermSecMapStartDate = '2024-01-02', PermSecMapEndDate = '2026-05-19' WHERE SecCode = 11221896 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11224658 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 11224802 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CHMMF' WHERE SecCode = 11226685 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 11232980 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11233871 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NPV', PermSecMapEndDate = '2026-05-19' WHERE SecCode = 11237323 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11260949 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-06-14' WHERE SecCode = 11264491 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 11269371 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11271949 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 11279768 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232901226787.0 WHERE SecCode = 11295427 AND Type_ = 1;
