UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-26', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 4052 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11473 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951766.0 WHERE SecCode = 19818 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 28027 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 30232 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 34059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET 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 = 55836337849, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 37823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518955, ExchCode = 'DUS' WHERE SecCode = 43402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308629, ExchCode = 'GTX' WHERE SecCode = 43512 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 44283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB' WHERE SecCode = 46535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328604, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 52185 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836341384, ExchCode = 'BER', PermQuoteRetireDate = '2023-03-08' WHERE SecCode = 53366 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837361619, Ticker = 'KCE1', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 53401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801607810, ExchCode = 'GTX' WHERE SecCode = 53597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339609, ExchCode = 'BER', PermQuoteRetireDate = '2012-12-14' WHERE SecCode = 56247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327898, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 56454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 56948 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 PermSecMapEndDate = NULL WHERE SecCode = 59824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838238912, ExchCode = 'MUN' WHERE SecCode = 59881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21961975860, ExchCode = 'DEU' WHERE SecCode = 59936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492066, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-07' WHERE SecCode = 59963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21577586769, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04', PermSecMapEndDate = NULL WHERE SecCode = 60667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526392841, ExchCode = 'DEU' WHERE SecCode = 60669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838349451, ExchCode = 'STU' WHERE SecCode = 61517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851456817, ExchCode = 'FRA', PermQuoteRetireDate = '2016-04-05' WHERE SecCode = 63618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661803831, ExchCode = 'FRA' WHERE SecCode = 63625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329646, ExchCode = 'BER' WHERE SecCode = 65414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21487385255, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-06' WHERE SecCode = 65643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538346502, ExchCode = 'STU', PermQuoteRetireDate = '2019-08-01' WHERE SecCode = 65700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525792637, ExchCode = 'DEU', PermQuoteRetireDate = '2014-02-12' WHERE SecCode = 65966 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 69969 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 78006 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 83530 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 85118 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 85334 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 88356 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 91066 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 92018 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 93736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531043704, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 100052 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474923314, ExchCode = 'DEU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 103762 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 105486 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475775904, ExchCode = 'MUN' WHERE SecCode = 112468 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 112899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520491, ExchCode = 'FRA' WHERE SecCode = 113643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484708, ExchCode = 'QTX' WHERE SecCode = 113649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773002576, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 113864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272816, ExchCode = 'GTX' WHERE SecCode = 113978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836333992, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-01', PermSecMapEndDate = '2022-07-01' WHERE SecCode = 113979 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 115380 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 PermSecMapEndDate = '2026-05-25' WHERE SecCode = 126440 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-26' WHERE SecCode = 133246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836390769, ExchCode = 'FRA' WHERE SecCode = 133773 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 137240 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 137241 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 138009 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'LAC', PermSecMapEndDate = '2026-05-25' WHERE SecCode = 140815 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 141223 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 141819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 176179 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 177540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593612748, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 178014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 184482 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ZZF0' WHERE SecCode = 200714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324730, ExchCode = 'BER' WHERE SecCode = 303347 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 309209 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 318162 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 329453 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 336187 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 411543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55879740079, Ticker = 'COM.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 523414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 866787 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 903247 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-25', PermSecMapEndDate = '2026-05-25' WHERE SecCode = 948166 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1328212 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1349008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482228292, Ticker = 'BLIT', ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-25', PermSecMapEndDate = '2026-05-25' WHERE SecCode = 1459217 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-25', PermSecMapEndDate = '2026-05-25' WHERE SecCode = 1459271 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 = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 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 OrgTypeCode = 'COM' WHERE SecCode = 1594710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 1631974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513069367, ExchCode = 'TDG' WHERE SecCode = 1635476 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21939948839, PermQuoteStatus = 'DC', Ticker = 'OD7L', ExchCode = 'HAN', PermQuoteRetireDate = '2024-03-05' WHERE SecCode = 1793899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681116521, ExchCode = 'DEU' WHERE SecCode = 1795399 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951434.0 WHERE SecCode = 1926064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518074502, ExchCode = 'DEU' WHERE SecCode = 2055361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379476, ExchCode = 'LAS', PermQuoteRetireDate = '2026-01-27', PermSecMapEndDate = NULL WHERE SecCode = 2205173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430949, ExchCode = 'DEU' WHERE SecCode = 2213927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538154, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2221995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308485, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2222230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606147777, ExchCode = 'STU', PermQuoteRetireDate = '2018-05-09' WHERE SecCode = 2232834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750324218, ExchCode = 'DEU' WHERE SecCode = 2232877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782890682, ExchCode = 'STU' WHERE SecCode = 2239280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523563646, ExchCode = 'DEU' WHERE SecCode = 2239343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478541, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2240547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789017062, ExchCode = 'DUS' WHERE SecCode = 2246863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869920397, ExchCode = 'MUN' WHERE SecCode = 2255684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370630, ExchCode = 'SGO' WHERE SecCode = 2272715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' 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 = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 2294795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723974163, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-10-17' WHERE SecCode = 2332152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21670714959, ExchCode = 'TDG' WHERE SecCode = 2338094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781520237, ExchCode = 'QTX' WHERE SecCode = 2339259 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704580, ExchCode = 'MXQ' WHERE SecCode = 2359427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530098344, ExchCode = 'FRA' WHERE SecCode = 2362509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21730025109, ExchCode = 'MUN' WHERE SecCode = 2377960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21779363674, ExchCode = 'FRA' WHERE SecCode = 2379809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531721248, InstrPermID = 8590005814, OrgPermID = 4295915565, ValQuotePermID = 55838797234.0, PriInstrPermID = 8590005814.0, PermInstrStatus = 'DC', Ticker = '56A', ExchCode = 'BER', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2020-09-09' WHERE SecCode = 2387360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781607391, ExchCode = 'QTX' WHERE SecCode = 2391333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536966570, ExchCode = 'STU' WHERE SecCode = 2391345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223768, ExchCode = 'QTX' WHERE SecCode = 2394769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659447, ExchCode = 'LAS' WHERE SecCode = 2395640 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542388488, PermQuoteStatus = 'DC', Ticker = 'GKO0', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 2397376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620411353, ExchCode = 'STU' WHERE SecCode = 2397377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951766.0 WHERE SecCode = 2409464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777643090, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2412432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786676625, ExchCode = 'BIV' WHERE SecCode = 2414027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824100155, ExchCode = 'TDG' WHERE SecCode = 2458822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381214, ExchCode = 'LAS' WHERE SecCode = 2466343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537746016, ExchCode = 'BER', PermQuoteRetireDate = '2015-04-03' WHERE SecCode = 2466346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535492269, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 2466348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA' WHERE SecCode = 2467266 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2469397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780660022, ExchCode = 'TDG' WHERE SecCode = 2479012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2499277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999786388, ExchCode = 'DXE' WHERE SecCode = 2510129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538134690, ExchCode = 'DEU' WHERE SecCode = 2513070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431271, ExchCode = 'FRA' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823953337, ExchCode = 'DUS' WHERE SecCode = 2515711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696140082, ExchCode = 'QTX' WHERE SecCode = 2522906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704312, Ticker = 'BCHN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2526118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '0T81' WHERE SecCode = 2540723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21572615842, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2542450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540230611, ExchCode = 'DEU' WHERE SecCode = 2542461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385094, ExchCode = 'LAS' WHERE SecCode = 2545058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540108933, ExchCode = 'DEU' WHERE SecCode = 2554904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478415, ExchCode = 'QTX' WHERE SecCode = 2556599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731262060, ExchCode = 'BER' WHERE SecCode = 2556600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542058382, ExchCode = 'STU' WHERE SecCode = 2558484 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 2559104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550103570, ExchCode = 'DEU' WHERE SecCode = 2559800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564889103, ExchCode = 'FRA' WHERE SecCode = 2568911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542768665, ExchCode = 'MUN' WHERE SecCode = 2572311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793501847, ExchCode = 'MUN' WHERE SecCode = 2578881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782012516, ExchCode = 'DEU' WHERE SecCode = 2585381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22121993910, ExchCode = 'BCO' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21792941383, ExchCode = 'DEU' WHERE SecCode = 2591696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629958117, ExchCode = 'TDG' WHERE SecCode = 2599304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067757998, ExchCode = 'BCO' WHERE SecCode = 2600076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22067641975, ExchCode = 'CHI' WHERE SecCode = 2600378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566715663, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2604391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662105437, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2604394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547450530, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2636990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538237, ExchCode = 'GTX' WHERE SecCode = 2642455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587109507, ExchCode = 'FRA', PermQuoteRetireDate = '2018-06-11' WHERE SecCode = 2643269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288297, ExchCode = 'GTX' WHERE SecCode = 2644157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789432566, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2644161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397387, ExchCode = 'GTX' WHERE SecCode = 2649166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549840146, ExchCode = 'FRA' WHERE SecCode = 2649167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777698966, ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-25' WHERE SecCode = 2650629 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624667850, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-28' WHERE SecCode = 2650642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548773265, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2653612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549921085, ExchCode = 'CHI' WHERE SecCode = 2665921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550459903, ExchCode = 'DEU' WHERE SecCode = 2682326 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 2696735 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 2696924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551920812, ExchCode = 'MUN' WHERE SecCode = 2700708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119337, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 2700711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551965230, Ticker = 'CBKe', ExchCode = 'SIG', PermQuoteRetireDate = '2014-12-10' WHERE SecCode = 2706343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552008104, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2711155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21553011650, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2718428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954950, InstrPermID = 8590932786, OrgPermID = 4295893865, ValQuotePermID = 55836043261.0, PriInstrPermID = 8590932786.0, PermQuoteStatus = 'AC', Ticker = 'FVQ1', ExchCode = 'LAS', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951361.0, PermQuoteRetireDate = NULL, PermOrgIPODate = '2000-12-06' WHERE SecCode = 2718429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552507986, Ticker = 'SRE', ExchCode = 'JNB' WHERE SecCode = 2718458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584014278, ExchCode = 'BTE', PermQuoteRetireDate = '2021-06-01' WHERE SecCode = 2720682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273765, PermQuoteStatus = 'AC', Ticker = '5WP0', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2731233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789017040, ExchCode = 'DUS' WHERE SecCode = 2747510 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554995304, ExchCode = 'STU' WHERE SecCode = 2750981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273861, PermQuoteStatus = 'AC', Ticker = 'XV2', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2751767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322186, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2809751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557589784, ExchCode = 'DEU' WHERE SecCode = 2810887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558551421, ExchCode = 'DEU' WHERE SecCode = 2827908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566120165, Ticker = 'T051', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560390655, ExchCode = 'STU' WHERE SecCode = 2841897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2865456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561797862, ExchCode = 'FRA' WHERE SecCode = 2872657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732998267, Ticker = 'A2PL', ExchCode = 'QTX', PermQuoteRetireDate = '2021-06-09' WHERE SecCode = 2872658 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2873588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562620362, ExchCode = 'MUN' WHERE SecCode = 2880972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780428180, ExchCode = 'GTX' WHERE SecCode = 2887226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564231392, ExchCode = 'TRQ', PermQuoteRetireDate = '2015-05-28' WHERE SecCode = 2900876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 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 = 236779370461, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2947926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 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 = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576175357, ExchCode = 'DEU' WHERE SecCode = 3032214 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 3038373 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3053961 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3059751 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-25' WHERE SecCode = 3069380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21580910339, ExchCode = 'DEU' WHERE SecCode = 3090322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887241129, ExchCode = 'BTE' WHERE SecCode = 3174320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658137738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3183538 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 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 = 21592182710, ExchCode = 'FRA', PermQuoteRetireDate = '2023-09-29', PermSecMapEndDate = '2023-09-29' WHERE SecCode = 3215568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597328149, ExchCode = 'MUN' WHERE SecCode = 3255527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597621641, ExchCode = 'DEU' WHERE SecCode = 3255528 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647013837, ExchCode = 'BCO' WHERE SecCode = 3275560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602049206, ExchCode = 'MUN' WHERE SecCode = 3282950 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22057914115, ExchCode = 'DEU' WHERE SecCode = 3315780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22131153720, ExchCode = 'HAM' WHERE SecCode = 3315799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739162126, ExchCode = 'MUN' WHERE SecCode = 3317931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378734, ExchCode = 'GTX' WHERE SecCode = 3318532 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830286060, ExchCode = 'GTX' WHERE SecCode = 3320207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679671, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3327117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22098741670, ExchCode = 'CHI' WHERE SecCode = 3359183 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743475404, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3378582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623458470, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3395682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792285260, Ticker = 'MEOv', ExchCode = 'BCO' WHERE SecCode = 3395686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628937008, ExchCode = 'TDG' WHERE SecCode = 3405439 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3405594 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 = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 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 = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636056227, ExchCode = 'FRA' WHERE SecCode = 3435060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647633189, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3491217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652333996, ExchCode = 'DEU' WHERE SecCode = 3526149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947471, ExchCode = 'DEU' WHERE SecCode = 3526199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 3552995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731165516, ExchCode = 'DEU' WHERE SecCode = 3584663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21664433945, ExchCode = 'STU' WHERE SecCode = 3610818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830287622, ExchCode = 'GTX' WHERE SecCode = 3616264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681018002, ExchCode = 'FRA' WHERE SecCode = 3654098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293822, ExchCode = 'GTX' WHERE SecCode = 3657811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636387547, Ticker = '2NFL.GB', ExchCode = 'AQS' WHERE SecCode = 3669927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750787655, ExchCode = 'FRA' WHERE SecCode = 3731132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383888, ExchCode = 'BIV' WHERE SecCode = 3732368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830288603, ExchCode = 'GTX' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682712573, ExchCode = 'STU' WHERE SecCode = 3754712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788220426, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3756592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620914214, Ticker = 'CZBl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3762759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 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 = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544674, ExchCode = 'DUS' WHERE SecCode = 3817679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858452393, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3849234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21698786104, ExchCode = 'CHI', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 3856714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815153752, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3877613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727368208, ExchCode = 'BIV' WHERE SecCode = 3890234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702763885, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3890307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21679348107, ExchCode = 'BIV' WHERE SecCode = 3934323 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718186483, ExchCode = 'DEU' WHERE SecCode = 3997065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727359395, ExchCode = 'SIG' WHERE SecCode = 4024795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026845, Ticker = '1GLW' WHERE SecCode = 4031714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784327741, Ticker = '1BOD' WHERE SecCode = 4031822 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026785, Ticker = '1NDX' WHERE SecCode = 4031953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026878, Ticker = '1PYPL' WHERE SecCode = 4031977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013288, Ticker = '2PM' WHERE SecCode = 4032067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013994, Ticker = '2CRM' WHERE SecCode = 4032071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143797, Ticker = '2AKZA', ExchCode = 'MIL' WHERE SecCode = 4032088 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 = 236796059848, ExchCode = 'FRA' WHERE SecCode = 4046669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630041763, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729105331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4056300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388381, ExchCode = 'LAS' WHERE SecCode = 4079321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21730198054, Ticker = 'ZWIPE', ExchCode = 'STO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 4079329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732569272, ExchCode = 'DEU' WHERE SecCode = 4081944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774922610, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 4081958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297913, ExchCode = 'DEU' WHERE SecCode = 4081959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732298218, ExchCode = 'DEU' WHERE SecCode = 4081961 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727355173, ExchCode = 'BIV' WHERE SecCode = 4081964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587084065, ExchCode = 'STU' WHERE SecCode = 4103598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815144829, ExchCode = 'TDG' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787721995, ExchCode = 'MUN' WHERE SecCode = 4110887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823963671, ExchCode = 'STU' WHERE SecCode = 4124714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704289, Ticker = 'AZULBN', ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625622942, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4188130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747988879, ExchCode = 'QTX' WHERE SecCode = 4212561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349640, ExchCode = 'MEX' WHERE SecCode = 4259231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-08' WHERE SecCode = 4274159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756809736, ExchCode = 'DEU' WHERE SecCode = 4275420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21534178673, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759692047, ExchCode = 'FRA' WHERE SecCode = 4295731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763901203, ExchCode = 'QTX' WHERE SecCode = 4324503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771983377, ExchCode = 'DUS' WHERE SecCode = 4362679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772740424, Ticker = '2ENR', ExchCode = 'MIL' WHERE SecCode = 4372484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774613209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4379791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294239, ExchCode = 'GTX' WHERE SecCode = 4383000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775812056, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 4385267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777644978, ExchCode = 'BER' WHERE SecCode = 4394782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307570, ExchCode = 'BIV' WHERE SecCode = 4403942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781439298, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816908115, ExchCode = 'TQE' WHERE SecCode = 4423997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779047734, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787553936, ExchCode = 'DEU', PermQuoteRetireDate = '2021-01-07' WHERE SecCode = 4446127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791470018, ExchCode = 'QTX' WHERE SecCode = 4451262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793526925, ExchCode = 'QTX' WHERE SecCode = 4476811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795226688, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-29', PermSecMapEndDate = '2023-06-29' WHERE SecCode = 4482720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727291861, ExchCode = 'BIV' WHERE SecCode = 4485970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809915701, ExchCode = 'STU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797820607, ExchCode = 'FRA' WHERE SecCode = 4499152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803607182, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808388561, PermQuoteStatus = 'DC', Ticker = '3K70', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-10' WHERE SecCode = 4557860 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4558223 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4558224 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4558225 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4558226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22140274066, ExchCode = 'BTE' WHERE SecCode = 4563419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22076466680, Ticker = 'XLMEd', ExchCode = 'BCO' WHERE SecCode = 4579626 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951824.0 WHERE SecCode = 4588371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812848268, ExchCode = 'DEU' WHERE SecCode = 4590581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4613099 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4613100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818266412, ExchCode = 'DEU' WHERE SecCode = 4617743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4639598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21934228224, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824689924, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831908634, ExchCode = 'GTX' WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21833145669, ExchCode = 'FRA' WHERE SecCode = 4677605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873118953, ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781822280, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-06-05' WHERE SecCode = 4709616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 = 21859546343, ExchCode = 'GTX' WHERE SecCode = 4767878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856729893, ExchCode = 'DEU' WHERE SecCode = 4777352 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'TOFD' WHERE SecCode = 4784326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380489, ExchCode = 'LAS' WHERE SecCode = 4792475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859821791, ExchCode = 'STO' WHERE SecCode = 4802290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4806671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860858404, ExchCode = 'DEU' WHERE SecCode = 4813526 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864897333, ExchCode = 'DEU' WHERE SecCode = 4823663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865290174, ExchCode = 'GTX' WHERE SecCode = 4823664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955234885, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-09-25' WHERE SecCode = 4827911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861142851, ExchCode = 'DEU' WHERE SecCode = 4829216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398298, ExchCode = 'GER', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 4834793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU' WHERE SecCode = 4845029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888953971, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-17' WHERE SecCode = 4845030 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580736, ExchCode = 'GER' WHERE SecCode = 4845032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381824, ExchCode = 'LAS' WHERE SecCode = 4845067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872586858, ExchCode = 'DEU' WHERE SecCode = 4873679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879838731, ExchCode = 'FRA' WHERE SecCode = 4918607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879839237, ExchCode = 'DEU' WHERE SecCode = 4918608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879838813, ExchCode = 'FRA' WHERE SecCode = 4918609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879838698, ExchCode = 'FRA' WHERE SecCode = 4918611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 4938311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806835525, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778071474, ExchCode = 'MUN' WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380555, ExchCode = 'LAS' WHERE SecCode = 4950865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4957874 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 4957875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716262, ExchCode = 'FRA' WHERE SecCode = 4960863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179871224, Ticker = '2MUE', ExchCode = 'HAM' WHERE SecCode = 4965038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5054935 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5054937 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5054938 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5054939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805605436, ExchCode = 'MUN' WHERE SecCode = 5089305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910168364, ExchCode = 'DUS' WHERE SecCode = 5094355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659492, ExchCode = 'LAS' WHERE SecCode = 5130678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797935268, ExchCode = 'MUN' WHERE SecCode = 5140247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529719609, ExchCode = 'TDG', PermQuoteRetireDate = '2014-12-05' WHERE SecCode = 5161223 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 = 25727344849, ExchCode = 'BIV' WHERE SecCode = 5161363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21657632265, Ticker = 'FT5', ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-04' WHERE SecCode = 5161374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305815, ExchCode = 'BIV' WHERE SecCode = 5161409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850513498, ExchCode = 'FRA' WHERE SecCode = 5161417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783316559, ExchCode = 'STU' WHERE SecCode = 5168258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943643469, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5174473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5206345 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5206346 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5206347 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5206348 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 5215832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783782321, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5230330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21930005423, ExchCode = 'FRA' WHERE SecCode = 5230331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780478262, PermQuoteStatus = 'DC', Ticker = 'VJ3', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5230332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935904685, ExchCode = 'FRA' WHERE SecCode = 5283711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775732426, ExchCode = 'BIV' WHERE SecCode = 5329511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776104211, Ticker = 'ACAG', ExchCode = 'VIE' WHERE SecCode = 5372903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812181526, ExchCode = 'FRA' WHERE SecCode = 5410114 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5433631 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 5436331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727277713, ExchCode = 'MEX' WHERE SecCode = 5503675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786107921, ExchCode = 'FRA' WHERE SecCode = 5553189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591864463, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970566091, ExchCode = 'FRA' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522671160, PermQuoteStatus = 'AC', Ticker = 'YE20', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794060301, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-05', PermSecMapEndDate = NULL WHERE SecCode = 5577589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'LAC' WHERE SecCode = 5600663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780661116, ExchCode = 'DUS' WHERE SecCode = 5620203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781224681, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5631688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781013274, ExchCode = 'FRA' WHERE SecCode = 5638751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966434, PermQuoteStatus = 'DC', Ticker = 'N8I1', ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823715, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5638860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 5638862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781543275, ExchCode = 'STU' WHERE SecCode = 5655040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' WHERE SecCode = 5658305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22072896303, ExchCode = 'TDG' WHERE SecCode = 5715993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782699246, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2024-12-05' WHERE SecCode = 5734836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22030335238, ExchCode = 'DEU' WHERE SecCode = 5734837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782871477, ExchCode = 'STU' 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 = 236799419156, ExchCode = 'LAS' WHERE SecCode = 5749956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783081066, ExchCode = 'FRA' WHERE SecCode = 5764020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783158225, ExchCode = 'FRA' WHERE SecCode = 5765005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154585726, ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22092544696, Ticker = 'RZ8B', ExchCode = 'DEU' WHERE SecCode = 5782810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783671621, ExchCode = 'FRA' WHERE SecCode = 5799761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783675132, ExchCode = 'FRA' WHERE SecCode = 5799763 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783964354, ExchCode = 'STU' WHERE SecCode = 5807637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386901, ExchCode = 'LAS' WHERE SecCode = 5807638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783963974, ExchCode = 'STU' WHERE SecCode = 5807639 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5814818 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 5824200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596707, ExchCode = 'FRA' WHERE SecCode = 5839460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596711, ExchCode = 'FRA' WHERE SecCode = 5839461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596713, ExchCode = 'FRA' WHERE SecCode = 5839464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596706, ExchCode = 'FRA' WHERE SecCode = 5839466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784596709, ExchCode = 'FRA' WHERE SecCode = 5839467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784890672, ExchCode = 'FRA' WHERE SecCode = 5857780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784957812, ExchCode = 'FRA' WHERE SecCode = 5859824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22076466658, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2025-02-11' WHERE SecCode = 5897569 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174666337, ExchCode = 'CHI' WHERE SecCode = 5920812 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 5920839 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 5927959 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790682427, PermQuoteStatus = 'DC', Ticker = '83W0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5928247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798426612, ExchCode = 'GTX' WHERE SecCode = 5947065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786839717, ExchCode = 'STU' WHERE SecCode = 5947076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786355844, ExchCode = 'MEX' WHERE SecCode = 5985969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381827, ExchCode = 'LAS' WHERE SecCode = 6065904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386194, ExchCode = 'FRA' WHERE SecCode = 6065905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475007845, PermQuoteStatus = 'AC', Ticker = 'ECQ0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV' WHERE SecCode = 6097383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21972857485, ExchCode = 'MXQ' WHERE SecCode = 6097467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 6097473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382116, ExchCode = 'LAS' WHERE SecCode = 6128378 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6134755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173202, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6260557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792340963, ExchCode = 'DUS' WHERE SecCode = 6270465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22108707582, ExchCode = 'DEU' WHERE SecCode = 6313497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793173877, ExchCode = 'TDG' WHERE SecCode = 6324049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172912563, ExchCode = 'SWX' WHERE SecCode = 6324051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22114348084, ExchCode = 'DEU' WHERE SecCode = 6351553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793595703, ExchCode = 'TDG' WHERE SecCode = 6351557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796057757, ExchCode = 'MUN' WHERE SecCode = 6448294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22127289121, ExchCode = 'DEU' WHERE SecCode = 6450941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6524571 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-25' WHERE SecCode = 6556384 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6564729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607123, Ticker = 'SNOW', ExchCode = 'SWX' WHERE SecCode = 6578368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800096565, ExchCode = 'FRA' WHERE SecCode = 6590583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800228284, ExchCode = 'FRA' WHERE SecCode = 6593801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800229276, ExchCode = 'FRA' WHERE SecCode = 6593803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800228885, ExchCode = 'FRA' WHERE SecCode = 6593805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800228883, ExchCode = 'FRA' WHERE SecCode = 6593806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145977584, ExchCode = 'DEU' WHERE SecCode = 6593866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801914263, ExchCode = 'FRA' WHERE SecCode = 6628800 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GGY', IncCntry = 'GGY' WHERE SecCode = 6629299 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22011191250, ExchCode = 'SGO' WHERE SecCode = 6678589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403431, ExchCode = 'FRA' WHERE SecCode = 6686042 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403427, ExchCode = 'FRA' WHERE SecCode = 6686043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403424, ExchCode = 'FRA' WHERE SecCode = 6686044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403434, ExchCode = 'FRA' WHERE SecCode = 6686045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403851, ExchCode = 'FRA' WHERE SecCode = 6686046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803756309, ExchCode = 'FRA' WHERE SecCode = 6696823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803758766, ExchCode = 'FRA' WHERE SecCode = 6696824 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 6708289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804998607, ExchCode = 'QTX' WHERE SecCode = 6737926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530357, ExchCode = 'MUN' WHERE SecCode = 6737927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168605391, ExchCode = 'DEU' WHERE SecCode = 6737928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6776286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805901582, ExchCode = 'BTE' WHERE SecCode = 6779523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-24' WHERE SecCode = 6797271 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806019660, ExchCode = 'BIV' WHERE SecCode = 6797367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176932924, ExchCode = 'DEU' WHERE SecCode = 6826539 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806640335, ExchCode = 'FRA' WHERE SecCode = 6829248 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-25' WHERE SecCode = 6836159 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-25' WHERE SecCode = 6846669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807109352, ExchCode = 'MEX' WHERE SecCode = 6857261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807169191, ExchCode = 'FRA' WHERE SecCode = 6857288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22180065660, ExchCode = 'MXQ' WHERE SecCode = 6862277 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-25', PermSecMapEndDate = '2026-05-25' WHERE SecCode = 6868115 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-05-25', PermSecMapEndDate = NULL WHERE SecCode = 10901055 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10906835 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 10982617 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951434.0 WHERE SecCode = 11014132 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11019099 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-25' WHERE SecCode = 11062045 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11066017 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 11108917 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11161776 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11174950 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11219078 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11222174 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11222218 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11224591 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11246416 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11247542 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 11258439 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11261898 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11262594 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11268849 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11270991 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11271538 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11272028 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11273589 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 11275118 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11284171 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11290981 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11292241 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292416 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292417 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292418 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292420 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292422 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292455 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292458 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292459 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292460 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292462 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292468 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292469 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292521 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292522 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292523 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292525 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292533 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292534 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292535 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292604 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292605 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292606 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292607 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-26' WHERE SecCode = 11292612 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293143 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293308 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293509 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11293667 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11294417 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11294692 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11294693 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11295695 AND Type_ = 1;