UPDATE data_universe SET QuotePermID = 21512281669.0, ExchCode = 'TRQ' WHERE SecCode = 1807 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB0004126271', RkdTicker = 'WEB', RkdSEDOL = '041262', RkdCUSIP = 'G9512S10', RkdRIC = 'WEBH.L^A25', RkdDisplayRIC = 'WEBH.L', RkdCode = 28194.0, RkdIssueID = 1.0, RkdIssueCode = 38549.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 5833 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 6774 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11339 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11836 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 4295904162.0, PriInstrPermID = 21475818707.0, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = NULL WHERE SecCode = 23840 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475422364.0, ExchCode = 'HAN', PermQuoteRetireDate = '2004-04-23', endDate = '2004-04-23' WHERE SecCode = 36125 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RKKK', QuotePermID = 21475081838.0, ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14', endDate = '2013-12-14' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE0005937007', RkdTicker = 'MAN', RkdSEDOL = '556352', RkdCUSIP = 'D5171610', RkdRIC = 'MANG.TG', RkdDisplayRIC = 'MANG.TG', RkdCode = 16394.0, RkdIssueID = 1.0, RkdIssueCode = 23558.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NA' WHERE SecCode = 56757 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21757842473.0, ExchCode = 'BER', PermQuoteRetireDate = '2021-06-11' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '008290.KQ^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 67667 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236814633273.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-09-16' WHERE SecCode = 68136 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68527 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000062986', RkdSEDOL = 'C0C53J', RkdCUSIP = 'Y0783215' WHERE SecCode = 69925 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70042 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73123 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75296 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76681 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76780 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79596 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '046070.KQ^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 81657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82801 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AEA000501014', RkdTicker = 'ADID', RkdSEDOL = '651848', RkdCUSIP = 'M0152S10', RkdRIC = 'ADID.AD', RkdDisplayRIC = 'ADID.AD', RkdCode = 48655.0, RkdIssueID = 1.0, RkdIssueCode = 63577.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ABD', RkdExchCtry = 'ARE' WHERE SecCode = 86794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-18' WHERE SecCode = 91543 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA33833E4004', RkdTicker = 'FEX', RkdSEDOL = 'BYXKY8', RkdCUSIP = '33833E40', RkdRIC = 'FEX.V', RkdDisplayRIC = 'FEX.V', RkdCode = 36894.0, RkdIssueID = 1.0, RkdIssueCode = 48791.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 94048 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97105 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '9914.NG', RkdDisplayRIC = '9914.NG', DsCtryQtStatus = 'D', RkdExchCode = 'NAG', DsSecDelistDate = '2026-09-21', PermOrgIPODate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 98177 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 100657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105204 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114108 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126634 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 127261 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134904 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136034 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 136737 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '082660.KQ^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 140966 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142542 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A0JDU97', RkdTicker = 'IFM', RkdSEDOL = 'B14ZRD', RkdCUSIP = 'D3575910', RkdRIC = 'IFMG.BE^A16', RkdDisplayRIC = 'IFMG.BE', RkdCode = 54566.0, RkdIssueID = 1.0, RkdIssueCode = 70793.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BER', RkdExchCtry = 'DEU' WHERE SecCode = 145572 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21720719075.0, ExchCode = 'BER', PermQuoteRetireDate = '2023-06-27', endDate = '2023-05-16' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 257965 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 311068 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 330453 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 359141 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 392081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 429392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 520670 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 562395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 656599 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 862079 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209863 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE177M01021', RkdSEDOL = 'BXXSX2', RkdCUSIP = 'Y4R92G16' WHERE SecCode = 1471725 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21491231424.0, ExchCode = 'OSL' WHERE SecCode = 1534902 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1542760 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951882.0 WHERE SecCode = 1611710 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 1617059 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 1622903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 1703312 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 1994294 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951661.0 WHERE SecCode = 2068084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21553114204.0, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03', endDate = '2017-02-03' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2417968 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21533733328.0, ExchCode = 'STO', PermQuoteRetireDate = '2018-10-18' WHERE SecCode = 2438937 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2529641 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 2578193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2580912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21560857304.0, ExchCode = 'DEU' WHERE SecCode = 2855772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21761647591.0, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-13', PermSecMapEndDate = NULL, endDate = '2022-06-10' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589172352.0, ExchCode = 'FRA' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 2989585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3001070 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21724552589.0, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3177550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3192859 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALELIO', QuotePermID = 21590251367.0, ExchCode = 'STO', PermQuoteRetireDate = '2023-11-07' WHERE SecCode = 3198788 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247268 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3285607 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3317677 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21615835622.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-27', endDate = '2022-09-27' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3358511 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3407819 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RORd', QuotePermID = 21889550159.0, ExchCode = 'BCO', PermQuoteRetireDate = '2024-06-26' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3488287 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951620.0 WHERE SecCode = 3545200 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3554989 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX80F30' WHERE SecCode = 3558196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3586985 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3886819 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951882.0 WHERE SecCode = 3991811 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4018127 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4604831 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21815921914.0, ExchCode = 'DEU' WHERE SecCode = 4614958 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21820741604.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-10' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4702567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4827919 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4932395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5473221 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236780730608.0, ExchCode = 'FRA' WHERE SecCode = 5620353 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951882.0 WHERE SecCode = 5622345 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5632198 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5738355 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NO0013178616', RkdTicker = 'PUBLI', RkdSEDOL = 'BS3F0B', RkdCUSIP = 'R7S51210', RkdRIC = 'PUBLI.OL^E26', RkdDisplayRIC = 'PUBLI.OL', RkdCode = 139316.0, RkdIssueID = 1.0, RkdIssueCode = 177496.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'OSL', RkdExchCtry = 'NOR' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5885464 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GGPl', QuotePermID = 236793500279.0, ExchCode = 'BCO' WHERE SecCode = 6334328 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6482833 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7107690 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5085706224.0, DomCntry = 'IND', PermOrgIPODate = '2026-09-17' WHERE SecCode = 7107709 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000234986.0, PriTRBCIndPermID = NULL WHERE SecCode = 10924425 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475110262.0, ExchCode = 'NSQ' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US74349J1034', RkdSEDOL = 'BJTZQ8', RkdCUSIP = '74349J10', RkdRIC = 'PROS.N^H21', RkdDisplayRIC = 'PROS.N', RkdCode = 119935.0, RkdIssueID = 1.0, RkdIssueCode = 151331.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11198931 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US22113B1035', RkdTicker = 'CSANY', RkdSEDOL = 'BNNL52', RkdCUSIP = '22113B10', RkdRIC = 'CSANY.PK', RkdDisplayRIC = 'CSANY.PK', RkdCode = 127653.0, RkdIssueID = 1.0, RkdIssueCode = 161746.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'ADR', RkdExchCode = 'OTC', RkdExchCtry = 'USA', ShPerListing = 4.0, PriTrdQuotePermID = NULL, PermQuoteRetireDate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 11220149 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA95861P3007', RkdTicker = 'WMS', RkdSEDOL = 'BTMT3Z', RkdCUSIP = '95861P30', RkdRIC = 'WMS.V', RkdDisplayRIC = 'WMS.V', RkdCode = 138670.0, RkdIssueID = 1.0, RkdIssueCode = 176590.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 11231753 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11237818 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11240002 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG508752055', RkdTicker = 'JCSE', RkdSEDOL = 'BRBR1R', RkdCUSIP = 'G5087520', RkdRIC = 'JCSE.O', RkdDisplayRIC = 'JCSE.OQ', RkdCode = 122557.0, RkdIssueID = 1.0, RkdIssueCode = 154789.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11241169 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5500B1361', RkdTicker = 'UZX', RkdSEDOL = 'C053MN', RkdCUSIP = 'G5500B13', RkdRIC = 'UZX.O', RkdDisplayRIC = 'UZX.OQ', RkdCode = 137633.0, RkdIssueID = 1.0, RkdIssueCode = 174963.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PermSecMapEndDate = '2025-04-05', endDate = '2025-04-05' WHERE SecCode = 11260721 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000253007.0, PriInstrPermID = 232862744779.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11275776 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232945043242.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11299930 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236814714278.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11301920 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236814716382.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11301924 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236814716400.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11301926 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XIII', QuotePermID = 236814735356.0, InstrPermID = 232945043242.0, OrgPermID = 6000198683.0, PriTrdQuotePermID = 236814735356.0, PriValQuotePermID = 25726989019.0, PriInstrPermID = 232945043242.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-07-31', PermSecMapStartDate = '2026-09-18', startDate = '2026-07-31' WHERE SecCode = 11301985 AND Type_ = 1;