UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475442982, Ticker = 'XAN', ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951268.0 WHERE SecCode = 36119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474911789, ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-29' WHERE SecCode = 38580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334221, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 38608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034862, ExchCode = 'TDG' WHERE SecCode = 38610 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951919.0 WHERE SecCode = 40328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836523767, ExchCode = 'FRA' WHERE SecCode = 41385 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 43038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323413, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 43574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836524782, ExchCode = 'FRA' WHERE SecCode = 43579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824525549, ExchCode = 'DUS' WHERE SecCode = 43583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474913868, Ticker = 'MACO', ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 50294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475604368, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2006-03-08' WHERE SecCode = 55766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808993824, PermQuoteStatus = 'AC', Ticker = 'NCYC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 55950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168469, ExchCode = 'STU' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475435128, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874382, ExchCode = 'DEU' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607299315, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-11' WHERE SecCode = 61371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006551, ExchCode = 'STU' WHERE SecCode = 64559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488610, ExchCode = 'QTX' WHERE SecCode = 64572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474889376, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 64581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331910, ExchCode = 'BER' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335540, Ticker = 'SPJ', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64845 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 86877 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 91559 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000170804, DomCntry = NULL, PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-08-22' WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 101044 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 114528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560429607, ExchCode = 'DEU' WHERE SecCode = 114573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550078870, ExchCode = 'HAM' WHERE SecCode = 114612 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 115380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780682738, PermQuoteStatus = 'DC', ExchCode = 'GTX', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 128769 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 130629 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957764680, ExchCode = 'FRA' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472969, ExchCode = 'MUN' WHERE SecCode = 132940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540736583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177351, ExchCode = 'DEU' WHERE SecCode = 141782 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 142781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 164900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 186379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566116516, ExchCode = 'STU' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536544263, ExchCode = 'DEU' WHERE SecCode = 186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838540118, ExchCode = 'STU' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383425, ExchCode = 'FRA' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 193147 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 193148 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 193152 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 193153 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 194642 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 194654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714469392, Ticker = 'SELm', ExchCode = 'DXE' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 201454 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 201455 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 201459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474902041, ExchCode = 'DEU', PermQuoteRetireDate = '2020-12-28' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 225124 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 238617 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 266229 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 270299 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 272752 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 292119 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 292121 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 292123 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 292124 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 299116 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 302461 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 302463 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 304560 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 304561 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 304565 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 304566 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 304965 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 309272 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 309891 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 309892 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 309896 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 309898 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 313522 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 313523 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 313529 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 313530 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 313755 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320557 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320558 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320563 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320759 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320761 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320764 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320767 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320768 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320830 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320833 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 320836 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 321191 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 321192 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 321193 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 328849 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 330363 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 335234 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 335634 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 342113 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 345666 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 354678 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 358845 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 358846 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 358847 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 362349 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 362354 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 362750 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 362757 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 368489 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 368490 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 368494 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 368500 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 372399 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 372403 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 412822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808993817, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 424416 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 441302 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 441305 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 = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073604520, Ticker = 'XAXDl', ExchCode = 'BTE' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 482743 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 498831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 517854 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-08-22' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 519475 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 533506 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 533821 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 534825 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 539253 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 542963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22189532382, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 557486 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-26' WHERE SecCode = 561082 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 561631 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 561632 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 561633 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 561634 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 566331 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 566455 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 568777 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 568813 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 568815 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 568840 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 568841 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 577301 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 602782 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 602882 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 603095 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 623509 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 623522 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 624923 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 625132 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 625133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808993860, ExchCode = 'SIG', PermSecMapStartDate = '2026-06-15' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 669736 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 737768 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 798142 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 798788 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 854065 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 854143 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 854208 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 854256 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 887594 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 888054 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 888083 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 888102 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 888115 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 894024 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 894116 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 972870 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1154797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408685, ExchCode = 'FRA' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1476676 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1486508 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1505365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1518822 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1525732 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1530652 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534751 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534762 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534769 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534840 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534874 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534882 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534893 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535724 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535734 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535736 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535739 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535743 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535801 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535806 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535808 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535811 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535820 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535821 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535826 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535827 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535830 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535831 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535838 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1610436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1926984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2189346 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2189347 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2189348 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2189349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 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 = 21750324218, ExchCode = 'DEU' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782890682, ExchCode = 'STU' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2239317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563646, ExchCode = 'DEU' WHERE SecCode = 2239343 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 = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539606835, ExchCode = 'DUS' WHERE SecCode = 2278227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967852, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2278243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485240, ExchCode = 'QTX' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525348690, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 2279777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854591, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-06' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2306670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527321541, Ticker = 'GPA', ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 2343130 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807341682, ExchCode = 'OCE' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367842 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367878 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367969 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367971 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367972 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367973 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779363674, ExchCode = 'FRA' WHERE SecCode = 2379809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531377381, ExchCode = 'DEU' WHERE SecCode = 2381665 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 = 21538722817, ExchCode = 'STU' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110077, ExchCode = 'FRA' WHERE SecCode = 2391353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223768, ExchCode = 'QTX' WHERE SecCode = 2394769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620411353, ExchCode = 'STU' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997786, ExchCode = 'FRA' WHERE SecCode = 2402414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 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 = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2420892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2438660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777272865, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-04', PermSecMapEndDate = NULL WHERE SecCode = 2450650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535492269, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA', PermQuoteRetireDate = '2018-11-19' WHERE SecCode = 2467266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387906, ExchCode = 'LAS' WHERE SecCode = 2470092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780660022, ExchCode = 'TDG' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660442, ExchCode = 'DUS' WHERE SecCode = 2482710 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2486552 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2486553 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2486557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481714947, ExchCode = 'TDG' WHERE SecCode = 2487654 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2490761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181315008, ExchCode = 'OCE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2511541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431271, ExchCode = 'FRA' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823953337, ExchCode = 'DUS' WHERE SecCode = 2515711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907918, ExchCode = 'FRA' WHERE SecCode = 2518703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 2526051 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 = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585062784, ExchCode = 'SGO' WHERE SecCode = 2539930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385094, ExchCode = 'LAS' WHERE SecCode = 2545058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2551357 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 QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768665, ExchCode = 'MUN' WHERE SecCode = 2572311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705735, ExchCode = 'MXQ' WHERE SecCode = 2572313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705667, ExchCode = 'MXQ' WHERE SecCode = 2572314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705247, ExchCode = 'MXQ' WHERE SecCode = 2572315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704187, ExchCode = 'MXQ' WHERE SecCode = 2572318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705290, Ticker = 'LINN', ExchCode = 'MXQ' WHERE SecCode = 2572322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768596, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2573038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543086076, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-24' WHERE SecCode = 2578880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793501847, ExchCode = 'MUN' WHERE SecCode = 2578881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543709073, ExchCode = 'FRA' WHERE SecCode = 2584743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544213987, ExchCode = 'TDG', PermQuoteRetireDate = '2020-05-26' WHERE SecCode = 2593544 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2599264 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 = 21545105822, ExchCode = 'FRA' WHERE SecCode = 2604390 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 = 21642374749, ExchCode = 'DEU' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371263, ExchCode = 'BEC' WHERE SecCode = 2625122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312003, ExchCode = 'GTX' WHERE SecCode = 2626786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546596463, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2631528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 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 = 21548014433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 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 = 21548204121, ExchCode = 'FRA' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535985, ExchCode = 'QTX', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 2644169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704172, ExchCode = 'MXQ' WHERE SecCode = 2644179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397387, ExchCode = 'GTX' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 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 = 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 PermOrgIPODate = NULL WHERE SecCode = 2665953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549893799, ExchCode = 'DEU' WHERE SecCode = 2668929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431688, ExchCode = 'DEU' WHERE SecCode = 2671254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607245, Ticker = 'HL', ExchCode = 'SWX' WHERE SecCode = 2682233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550459903, ExchCode = 'DEU' WHERE SecCode = 2682326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137710, ExchCode = 'MUN', PermQuoteRetireDate = '2021-07-05' WHERE SecCode = 2693639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384079, ExchCode = 'LAS' WHERE SecCode = 2693643 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 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 = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2718467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554451923, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-14' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2796990 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2796991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557003843, ExchCode = 'FRA' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2808086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322226, ExchCode = 'DEU' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558476903, ExchCode = 'FRA' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155337, ExchCode = 'FRA' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289547, PermQuoteStatus = 'AC', Ticker = '8PSG', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559845838, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2849907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560128262, ExchCode = 'STU' WHERE SecCode = 2849922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2856942 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599175171, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21727515465, ExchCode = 'TDG', PermQuoteRetireDate = '2021-02-19' WHERE SecCode = 2870126 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2874471 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2879953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180586, ExchCode = 'DEU' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, Ticker = 'SX7EEz', ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 2898744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077770, ExchCode = 'LAS' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907194 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907196 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907197 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907198 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907202 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565633193, PermQuoteStatus = 'AC', Ticker = 'CM30', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915113 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915116 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915117 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915125 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915126 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915146 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2923365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994122, Ticker = '1EBAYm', ExchCode = 'BCO' WHERE SecCode = 2925433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566806429, ExchCode = 'DEU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567022234, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-27', PermSecMapEndDate = NULL WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567104630, InstrPermID = 21575328144, OrgPermID = 5093618813, ValQuotePermID = 21575328161.0, PriInstrPermID = 21575328144.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '1AL', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermOrgIPODate = '2015-07-06' WHERE SecCode = 2939990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2957296 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2960310 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = NULL WHERE SecCode = 2963579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2987282 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2988170 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2988171 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3000089 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3009126 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 3024441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3040828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611487587, ExchCode = 'FRA' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3098007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22124025589, ExchCode = 'DEU' WHERE SecCode = 3124127 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3156217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931877, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3174319 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3174320 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3174450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3183978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449069, ExchCode = 'DEU' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 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 = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 3235105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805519656, ExchCode = 'MUN', PermQuoteRetireDate = '2024-06-28' WHERE SecCode = 3237127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599524546, ExchCode = 'STU' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621838, ExchCode = 'FRA' 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 3271360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21995867781, ExchCode = 'TRQ' 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 = 21656678970, ExchCode = 'BIV' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3282260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383543, ExchCode = 'DEU' WHERE SecCode = 3285135 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3296210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611219951, ExchCode = 'MUN', PermQuoteRetireDate = '2017-12-22' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3301720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833203, ExchCode = 'DEU' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3315813 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3315818 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3315819 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3315888 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 = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3317359 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3318814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610682901, Ticker = 'VEONa', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3349696 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3349697 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3357953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3365585 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3365653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749591716, PermQuoteStatus = 'DC', Ticker = '90S1', ExchCode = 'STU', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3374478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301079, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL 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 PermInstrStatus = 'DC' WHERE SecCode = 3387570 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 = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3394483 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3394485 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3395686 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3397013 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3397050 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3397052 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3397057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622941, ExchCode = 'DEU' WHERE SecCode = 3402562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835864, Ticker = 'DTSd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 3406952 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3407422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629966004, ExchCode = 'FRA', PermQuoteRetireDate = '2020-02-26' WHERE SecCode = 3408843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381227, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-04' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655828146, ExchCode = 'FRA' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3409386 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3409387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3427910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368528, Ticker = 'PU9D', ExchCode = 'SES', PermQuoteRetireDate = '2018-01-18' WHERE SecCode = 3429985 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3431584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994707, ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 3431866 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3431870 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3431871 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3431882 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3431889 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3431909 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 3432552 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3440422 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 3445080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676153, ExchCode = 'BIV' WHERE SecCode = 3445716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644530905, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3445747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644530943, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-29', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 3445749 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446000 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446002 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446004 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446007 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784910654, Ticker = 'NOKIAk', ExchCode = 'BCO' WHERE SecCode = 3504673 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3510566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 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 = 21762721933, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3535859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949649601, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-12-12' WHERE SecCode = 3545357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953341540, ExchCode = 'MUN' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058784, ExchCode = 'DEU' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3569683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667031, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 3588020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3610166 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3610337 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3615233 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3616760 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3619554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202587, ExchCode = 'MUN' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681018002, ExchCode = 'FRA' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818102039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690447593, ExchCode = 'STU' WHERE SecCode = 3666895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569892, ExchCode = 'QTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807025755, ExchCode = 'FRA' WHERE SecCode = 3739134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731163538, ExchCode = 'TDG', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3749084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 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 = 21684103049, ExchCode = 'FRA' WHERE SecCode = 3771411 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3779950 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3779952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298304, ExchCode = 'DUS' WHERE SecCode = 3780004 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3787353 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3787365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895438, ExchCode = 'STU' WHERE SecCode = 3793375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394405, ExchCode = 'BIV' 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 3835736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659513, ExchCode = 'LAS' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696869354, ExchCode = 'TDG', PermQuoteRetireDate = '2022-08-25' WHERE SecCode = 3843078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830030, ExchCode = 'QTX' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3875783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 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 = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3903730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 3947544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295405, ExchCode = 'GTX', PermQuoteRetireDate = '2024-10-01', PermSecMapEndDate = '2024-10-01' WHERE SecCode = 3949028 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 3952658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363718, ExchCode = 'MEX' WHERE SecCode = 3966586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363715, ExchCode = 'MEX' WHERE SecCode = 3966587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808198439, ExchCode = 'MUN' WHERE SecCode = 3972240 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 3977925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817960149, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4001066 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 = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720015410, PermQuoteStatus = 'AC', Ticker = '0XM1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4007107 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4008980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026873, Ticker = '1BAC', ExchCode = 'MIL' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808928250, Ticker = '1Tm', ExchCode = 'BCO' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828390, Ticker = '1RBIm', ExchCode = 'BCO' WHERE SecCode = 4031756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026865, Ticker = '11COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026856, Ticker = '1ADJ' WHERE SecCode = 4031785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828455, Ticker = '1AIXAm', ExchCode = 'BCO' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828404, Ticker = '1BODm', ExchCode = 'BCO' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026897, Ticker = '1COST' WHERE SecCode = 4031830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 236808828467, Ticker = '1DHERm', ExchCode = 'BCO' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026741, Ticker = '1WBD' WHERE SecCode = 4031843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828427, Ticker = '1EUZm', ExchCode = 'BCO' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010228, Ticker = '2FRA' WHERE SecCode = 4031875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012795, Ticker = '2KHC' WHERE SecCode = 4031921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808928220, Ticker = '1RDCm', ExchCode = 'BCO' WHERE SecCode = 4031987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026937, Ticker = '1SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026960, Ticker = '1VAR' WHERE SecCode = 4032036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026965, Ticker = '1WAF' WHERE SecCode = 4032047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026743, Ticker = '1WCH' WHERE SecCode = 4032048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011930, Ticker = '2BYND' WHERE SecCode = 4032087 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 = 236780026796, Ticker = '1IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184449, ExchCode = 'SIG' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733939843, ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-09', PermSecMapEndDate = '2023-11-17' WHERE SecCode = 4035670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 4036730 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'LUX', IncCntry = 'LUX' WHERE SecCode = 4043104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700905983, ExchCode = 'MEX' WHERE SecCode = 4054118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412447, ExchCode = 'FRA' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729887692, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = NULL WHERE SecCode = 4062000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301372, ExchCode = 'MUN' WHERE SecCode = 4068293 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 = 21732154086, ExchCode = 'DEU' WHERE SecCode = 4080678 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4094237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4109296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352699, ExchCode = 'MEX' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4156471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4226178 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4237791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752139678, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752244343, ExchCode = 'TDG' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4252593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 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 = 21789215871, ExchCode = 'FRA' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4284357 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4286238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768111804, PermQuoteStatus = 'DC', Ticker = '9EG', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011157, Ticker = '2SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143914, Ticker = '2TKWY', ExchCode = 'MIL' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010963, Ticker = '2AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011282, Ticker = '2NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143959, Ticker = '2RMS', ExchCode = 'MIL' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143858, Ticker = '2ASM', ExchCode = 'MIL' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012280, Ticker = '2FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432057, ExchCode = 'DEU' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932244786, ExchCode = 'BCO' WHERE SecCode = 4315108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580130, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709367298, ExchCode = 'MXQ', PermOrgIPODate = '1753-01-01' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801716826, ExchCode = 'TDG' 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 = 21764112355, ExchCode = 'FRA' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796439340, ExchCode = 'LAS' WHERE SecCode = 4333278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183761, ExchCode = 'MEX' WHERE SecCode = 4362644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644859, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, ExchCode = 'MUN' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740524, ExchCode = 'LAS' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 4426889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785083437, ExchCode = 'TDG' WHERE SecCode = 4434247 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 = 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 = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818102097, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4449683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854730428, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-31', PermSecMapEndDate = NULL WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299967, ExchCode = 'MEX' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897786131, ExchCode = 'MUN' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4482549 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 = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4522790 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4522791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4536482 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4536483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874195189, ExchCode = 'PFT' WHERE SecCode = 4566923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 4598801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21944534852, ExchCode = 'STU' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934986349, ExchCode = 'BTE' WHERE SecCode = 4608547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387260, PermQuoteStatus = 'DC', Ticker = 'WWT', ExchCode = 'LAS', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996699, ExchCode = 'LAS' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884954175, ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-04', PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831917952, ExchCode = 'DEU' WHERE SecCode = 4677594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380604, ExchCode = 'LAS' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235606, ExchCode = 'BIV' WHERE SecCode = 4709611 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 = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 4745407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381631, ExchCode = 'STU' WHERE SecCode = 4790646 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4811104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860859987, ExchCode = 'FRA' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4815325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874018782, ExchCode = 'QTX' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580680, ExchCode = 'DEU' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953884, ExchCode = 'MUN', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4839981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398299, ExchCode = 'FRA', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580391, ExchCode = 'FRA' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954949, ExchCode = 'LAS' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4915874 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4964965 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 4975833 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4992158 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5005670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5067183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031229, ExchCode = 'STU' WHERE SecCode = 5067269 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 DomCntry = 'USA' WHERE SecCode = 5101412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193843, ExchCode = 'MEX', PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 5117007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520648, ExchCode = 'DEU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5161230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853640013, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5162547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5199974 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5202220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049597, ExchCode = 'MXQ', PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919819094, ExchCode = 'MXQ' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' 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 = 236777397469, ExchCode = 'CHI' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 5323925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953951669, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5381927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962720157, ExchCode = 'DUS' WHERE SecCode = 5402910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21964248992, ExchCode = 'DEU' WHERE SecCode = 5403084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996696, ExchCode = 'LAS' WHERE SecCode = 5403242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223422, ExchCode = 'STU' WHERE SecCode = 5407839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803099316, ExchCode = 'STU' WHERE SecCode = 5407840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777248728, PermQuoteStatus = 'AC', Ticker = 'T2I1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5407846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21965213442, ExchCode = 'DEU' WHERE SecCode = 5407861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5417722 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 5418880 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5426592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076773, ExchCode = 'LAS', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171626, ExchCode = 'MEX' WHERE SecCode = 5443497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726334950, ExchCode = 'DEU' WHERE SecCode = 5466446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778346108, ExchCode = 'FRA' WHERE SecCode = 5470870 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = 0, IsPrimaryInstr = 0 WHERE SecCode = 5474595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 5478173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893349, ExchCode = 'TDG' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904150, ExchCode = 'CHI' WHERE SecCode = 5503692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776471888, ExchCode = 'MEX' WHERE SecCode = 5503860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309751, Ticker = '3LPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787118150, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-08' WHERE SecCode = 5506510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223859, ExchCode = 'QTX' WHERE SecCode = 5506511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21984114239, ExchCode = 'DEU' WHERE SecCode = 5506512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891290, ExchCode = 'FRA' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970292562, ExchCode = 'GTX' WHERE SecCode = 5533517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970292563, ExchCode = 'MUN' WHERE SecCode = 5533518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566088, ExchCode = 'FRA', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5533519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786107921, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566091, ExchCode = 'FRA' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, PermQuoteStatus = 'DC', Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771506, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5574862 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5577466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360178, ExchCode = 'MEX' WHERE SecCode = 5581641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585114, ExchCode = 'MEX' WHERE SecCode = 5582137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414738, ExchCode = 'LAS' WHERE SecCode = 5603347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5610271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793574816, ExchCode = 'TDG' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ECHO*' WHERE SecCode = 5623403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460751, ExchCode = 'FRA' WHERE SecCode = 5638843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449511, Ticker = 'TS2Sl', ExchCode = 'BCO' WHERE SecCode = 5638844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, ExchCode = 'QTX' WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778712185, ExchCode = 'MEX' WHERE SecCode = 5644662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089214794, Ticker = '3TSEd', ExchCode = 'BTE' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223838, ExchCode = 'QTX' WHERE SecCode = 5663968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778500348, ExchCode = 'BIV' WHERE SecCode = 5671941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949657, ExchCode = 'PFT' WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078152, ExchCode = 'LAS' WHERE SecCode = 5703208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808828470, Ticker = '1HENSm', ExchCode = 'BCO' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028649127, ExchCode = 'DEU' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26', PermSecMapEndDate = '2026-06-26' WHERE SecCode = 5816821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784326338, ExchCode = 'STU' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327232, ExchCode = 'FRA' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784329431, ExchCode = 'HAM' WHERE SecCode = 5827173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 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 = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807350258, ExchCode = 'LAS' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348220, ExchCode = 'STU' WHERE SecCode = 5857780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5898743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001789, PermQuoteStatus = 'AC', Ticker = '83W', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942828047, ExchCode = 'MXQ', PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 6024138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864380, ExchCode = 'STU' WHERE SecCode = 6078492 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6095685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550078857, PermQuoteStatus = 'DC', Ticker = 'ECQ', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 6097302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171968, ExchCode = 'BIV' WHERE SecCode = 6097384 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 = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, ExchCode = 'DEU' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835913, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834940, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089463033, ExchCode = 'DEU' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790959257, ExchCode = 'GTX' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6190882 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6190885 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6190886 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6190889 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6198596 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6198597 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6211080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22101513679, ExchCode = 'LAS' WHERE SecCode = 6226091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388787, ExchCode = 'LAS' WHERE SecCode = 6256419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829970, ExchCode = 'DEU' 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 = 236808994102, Ticker = '1FANGm', ExchCode = 'BCO' WHERE SecCode = 6263873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994107, Ticker = '1DXCMm', ExchCode = 'BCO' WHERE SecCode = 6263875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994101, Ticker = '1DECKm', ExchCode = 'BCO' WHERE SecCode = 6263877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994108, Ticker = '1DHIm', ExchCode = 'BCO' WHERE SecCode = 6263881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994097, Ticker = '1CPRTm', ExchCode = 'BCO' WHERE SecCode = 6263893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994095, Ticker = '1COHRm', ExchCode = 'BCO' WHERE SecCode = 6263904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173713, Ticker = '1TOST', ExchCode = 'MIL' WHERE SecCode = 6263917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994150, Ticker = '1GEHCm', ExchCode = 'BCO' WHERE SecCode = 6263934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994086, Ticker = '1CVNAm', ExchCode = 'BCO' WHERE SecCode = 6263953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994084, Ticker = '1CARRm', ExchCode = 'BCO' WHERE SecCode = 6263957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994079, Ticker = '1CAHm', ExchCode = 'BCO' WHERE SecCode = 6263966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994080, Ticker = '1CDNSm', ExchCode = 'BCO' WHERE SecCode = 6263981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994076, Ticker = '1BROm', ExchCode = 'BCO' WHERE SecCode = 6264007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994191, Ticker = '1ICEm', ExchCode = 'BCO' WHERE SecCode = 6264008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994160, Ticker = '1HUMm', ExchCode = 'BCO' WHERE SecCode = 6264037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994159, Ticker = '1HSYm', ExchCode = 'BCO' WHERE SecCode = 6264042 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994133, Ticker = '1ENPHm', ExchCode = 'BCO' WHERE SecCode = 6264062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994149, Ticker = '1GEVm', ExchCode = 'BCO' WHERE SecCode = 6264070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994151, Ticker = '1AJGm', ExchCode = 'BCO' WHERE SecCode = 6264077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994145, Ticker = '1FTNTm', ExchCode = 'BCO' WHERE SecCode = 6264084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994127, Ticker = '1EPAMm', ExchCode = 'BCO' WHERE SecCode = 6264121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994111, Ticker = '1DPZm', ExchCode = 'BCO' WHERE SecCode = 6264140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994153, Ticker = '1GWWm', ExchCode = 'BCO' WHERE SecCode = 6264198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994099, Ticker = '1CAGm', ExchCode = 'BCO' WHERE SecCode = 6264210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994162, Ticker = '1HWMm', ExchCode = 'BCO' WHERE SecCode = 6264262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792340963, ExchCode = 'DUS' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049582, PermQuoteStatus = 'AC', Ticker = 'ORGN', ExchCode = 'MXQ', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 6285558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049593, PermQuoteStatus = 'AC', Ticker = 'PMEN', ExchCode = 'MXQ', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-25', PermSecMapEndDate = NULL WHERE SecCode = 6285559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792486362, ExchCode = 'BIV' WHERE SecCode = 6285560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108940399, ExchCode = 'DEU' WHERE SecCode = 6308566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959792, ExchCode = 'FRA' WHERE SecCode = 6310331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959791, ExchCode = 'FRA' WHERE SecCode = 6310332 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6334037 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6334045 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6334166 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6336174 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6336175 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6336176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6366723 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6371507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745447, ExchCode = 'MEX' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866542, ExchCode = 'BIV' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6392572 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794616561, ExchCode = 'FRA' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794619095, ExchCode = 'QTX' WHERE SecCode = 6418488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794616600, ExchCode = 'STU' WHERE SecCode = 6418489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083975572, ExchCode = 'QTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6453951 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6453954 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6467512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408686, Ticker = 'S0N0', ExchCode = 'FRA' WHERE SecCode = 6503395 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 = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798105812, ExchCode = 'QTX' WHERE SecCode = 6520702 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 QuotePermID = 236798270114, ExchCode = 'FRA' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269869, ExchCode = 'FRA' WHERE SecCode = 6528825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462190, ExchCode = 'GTX' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743814, ExchCode = 'QTX' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808974749, ExchCode = 'MUN' WHERE SecCode = 6554820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994128, Ticker = '1EMEm', ExchCode = 'BCO' WHERE SecCode = 6564725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994120, Ticker = '1DYTm', ExchCode = 'BCO' WHERE SecCode = 6564726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994091, Ticker = '1FIXm', ExchCode = 'BCO' WHERE SecCode = 6564731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994085, Ticker = '1CMGm', ExchCode = 'BCO' WHERE SecCode = 6564734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808994116, Ticker = '1ELFm', ExchCode = 'BCO' WHERE SecCode = 6564748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799371518, ExchCode = 'FRA' WHERE SecCode = 6575446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346662, Ticker = '0QF', ExchCode = 'BRN' WHERE SecCode = 6578363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168734, ExchCode = 'SIG' WHERE SecCode = 6578406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6626842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152236620, ExchCode = 'DEU' WHERE SecCode = 6627152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152237029, ExchCode = 'DEU' WHERE SecCode = 6627153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806018926, ExchCode = 'LAS' WHERE SecCode = 6628800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 6658285 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ZN4' WHERE SecCode = 6672570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191250, ExchCode = 'SGO' WHERE SecCode = 6678589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165234298, ExchCode = 'GTX' WHERE SecCode = 6710093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805776179, ExchCode = 'MUN' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140087946, ExchCode = 'HAM' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6808907 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6813403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809000062, ExchCode = 'LAS' WHERE SecCode = 6820147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22177707113, ExchCode = 'DEU' WHERE SecCode = 6829248 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-26' WHERE SecCode = 6839686 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 6843176 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26', PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6849873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807255715, ExchCode = 'MUN' WHERE SecCode = 6862202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184495661, ExchCode = 'DEU' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808332135, ExchCode = 'LAS' WHERE SecCode = 6902160 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 6914477 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-25' WHERE SecCode = 6921022 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26', PermSecMapEndDate = '2026-06-26' WHERE SecCode = 6921034 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808826779, ExchCode = 'TDG' WHERE SecCode = 6923756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188701934, ExchCode = 'GTX' WHERE SecCode = 6930689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808715500, ExchCode = 'TDG' WHERE SecCode = 6937683 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 6939105 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-25' WHERE SecCode = 6941637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808923463, ExchCode = 'FRA' WHERE SecCode = 6941647 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10902674 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 10928866 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11060533 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11064537 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11143140 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11148647 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11153481 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11154987 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11159115 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11163549 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11190074 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11194050 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 11202539 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727345869, PriTrdQuotePermID = NULL, PermQuoteStatus = 'AC', Ticker = 'ADTX', ExchCode = 'PNK', PermQuoteRetireDate = NULL WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11224867 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11230564 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-26' WHERE SecCode = 11234124 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11236980 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11274582 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11276055 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11276222 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11276223 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11276468 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11276469 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11276668 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11277467 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11277468 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11277560 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11277822 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-05-02' WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11278112 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11278549 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11278632 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11278633 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11278634 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11278927 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11279154 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11279661 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-05-02' WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11279822 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11280056 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11280348 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11280558 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11285817 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11285818 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11285833 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11285841 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11286781 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11288403 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11288938 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11289210 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11289271 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11289678 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11289699 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11289943 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11289944 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2026-06-25' WHERE SecCode = 11289946 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11290681 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11291296 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11291751 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11294715 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11295111 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11295337 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232866587681.0 WHERE SecCode = 11296753 AND Type_ = 1;
