UPDATE data_universe SET RkdISIN = 'US09175M8799', RkdSEDOL = 'BVK8VB', RkdCUSIP = '09175M87' WHERE SecCode = 19848 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 23996 AND Type_ = 1; UPDATE data_universe SET Name = 'FASA SA NPV BRL', PriTRBCIndPermID = 4294951439.0, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 29462 AND Type_ = 10; UPDATE data_universe SET Name = 'HORNBECK OFFSHORE SERVICES INC COM' WHERE SecCode = 33185 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 35365 AND Type_ = 10; UPDATE data_universe SET Name = 'PARADIUMAI INC COM' WHERE SecCode = 36397 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, ExchCode = 'AQX', PermQuoteRetireDate = '2026-07-28' WHERE SecCode = 48143 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-09-01' WHERE SecCode = 49578 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21605378798.0, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'SNOWa', QuotePermID = 21524609015.0, ExchCode = 'CHI', PermQuoteRetireDate = '2023-08-01', endDate = '2023-08-01' WHERE SecCode = 62097 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'FINANCIERE DE NPV' WHERE SecCode = 62780 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'INQ GROUP AB (PUBL NPV' WHERE SecCode = 66082 AND Type_ = 10; UPDATE data_universe SET Name = 'WEBBEDS GROUP LTD NPV' WHERE SecCode = 67578 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-01', SecMapEndDate = '2005-10-07', endDate = '2005-10-07' WHERE SecCode = 68545 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1986-01-02' WHERE SecCode = 69823 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10; UPDATE data_universe SET Name = 'WOOYANG P&L CO LTD KRW500' WHERE SecCode = 73818 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74753 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76053 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-29' WHERE SecCode = 78010 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'OLBA DVX HLTH CARE NPV' WHERE SecCode = 78463 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'UOGROUP CO LTD NPV' WHERE SecCode = 78546 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2025-11-06' WHERE SecCode = 78795 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78828 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'BLUE STAR' WHERE SecCode = 79420 AND Type_ = 10; UPDATE data_universe SET Name = 'KANTRA COPPER LTD NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 83058 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2026-07-24' WHERE SecCode = 83485 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-29' WHERE SecCode = 86002 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'LAND33' WHERE SecCode = 86338 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55838797189.0, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SEO HAN KRW2500' WHERE SecCode = 88892 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'MCNALLY BHARAT ENG INR10 ( POST SPLT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 88988 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SI RESOURCES CO KRW1000' WHERE SecCode = 90658 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-28' WHERE SecCode = 90918 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-29' WHERE SecCode = 90956 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 94982 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2026-09-01', endDate = '2026-09-01' WHERE SecCode = 95169 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 96166 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951890.0 WHERE SecCode = 103984 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'USHOL.E', RkdRIC = 'USHOL.IS', RkdDisplayRIC = 'USHOL.IS' WHERE SecCode = 133994 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'FINANCIERE DE NPV (B/R 17/06/2005)' WHERE SecCode = 137547 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21798248733.0, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'VIXTON CORPORATION NPV' WHERE SecCode = 197158 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243153 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 243415 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'SGLD' WHERE SecCode = 306658 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232951324954.0, IsPrimaryInstr = 0.0, PermOrgIPODate = '2026-09-01' WHERE SecCode = 336770 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 351650 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', endDate = '2026-09-02' WHERE SecCode = 361205 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-09-01' WHERE SecCode = 395045 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 424431 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CYC.HNO^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 522857 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'RDP.HNO^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 546068 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 552209 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BVPXSV7' WHERE SecCode = 566853 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 586476 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21682909478.0, PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 863623 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1178432 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = NULL WHERE SecCode = 1278568 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1583284 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1694231 AND Type_ = 10; UPDATE data_universe SET Name = 'ALKEN FUND SICAV ALKEN GLOBAL CNV USD ACC', Country = 'LUX' WHERE SecCode = 2396445 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452495 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2595744 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2727820 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 2885882 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2900881 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2905771 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 2907002 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 2911289 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 2911861 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 2913389 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951226.0 WHERE SecCode = 2921461 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 2924577 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 2924593 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2928725 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2935048 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951204.0 WHERE SecCode = 2955167 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'JPN' WHERE SecCode = 3037818 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3217947 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 3222692 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SEWHA P&C INC KRW500' WHERE SecCode = 3260769 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '3480.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-09-01', endDate = '2026-09-01' WHERE SecCode = 3378303 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-08-31', PermSecMapEndDate = '2026-09-01', endDate = '2026-08-31' WHERE SecCode = 3405345 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21858705514.0, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3535945 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3631185 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3774518 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4032276 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4333241 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'HK0001353686', RkdSEDOL = 'BXD2HP', RkdCUSIP = 'Y210U610', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BXD2HP7' WHERE SecCode = 4396374 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-09-01', endDate = '2026-09-01' WHERE SecCode = 4444662 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4447184 AND Type_ = 10; UPDATE data_universe SET Name = 'MPC ENERGY SOLUTIO EUR0.66' WHERE SecCode = 4476778 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 4646583 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4759419 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'EAU', DsPrimQtSedol = 'BW6FSL9' WHERE SecCode = 4788553 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21865296667.0, ExchCode = 'BTE', PermQuoteRetireDate = '2025-06-02' WHERE SecCode = 4800907 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-29' WHERE SecCode = 4969540 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5045124 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5127374 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5331771 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5392796 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236779469274.0 WHERE SecCode = 5558460 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '471050.KQ^I26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 5636927 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5649726 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 5738387 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 6281777 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-08-31', PermQuoteRetireDate = '2026-09-01', PermSecMapEndDate = '2026-09-01', endDate = '2026-08-31' WHERE SecCode = 6658385 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 232921473387.0 WHERE SecCode = 6672572 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2026-08-14' WHERE SecCode = 6980182 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TRPL15', QuotePermID = 22193191670.0, InstrPermID = 18068926127.0, OrgPermID = 5097119530.0, PriValQuotePermID = 22193191670.0, PriInstrPermID = 18068895628.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'CEF', InstrClass = 'CEF', OrgTypeCode = 'CINV', DomCntry = 'BRA', IncCntry = 'BRA', PriTRBCIndPermID = 4294951323.0, PermOrgIPODate = '2026-01-08', PermSecMapStartDate = '2026-07-14', startDate = '2026-07-14' WHERE SecCode = 6985088 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6997043 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-09-01', endDate = '2026-09-01' WHERE SecCode = 7014881 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'FIN' WHERE SecCode = 7034025 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-09-01', endDate = '2026-09-01' WHERE SecCode = 7044696 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2026-08-26', startDate = '2026-08-17' WHERE SecCode = 7070150 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 7077875 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7077878 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7077879 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7077880 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7077881 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7077882 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7077883 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11045990 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11153097 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11156680 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 11171585 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 11187864 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MOGL', Name = 'MOGUL MTN VENTURES CORP COM', PriTRBCIndPermID = 4294951916.0, PermSecMapEndDate = '2026-09-01', endDate = '2026-09-01' WHERE SecCode = 11198089 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11212907 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11223856 AND Type_ = 1; UPDATE data_universe SET Name = 'GENERATION INCOME PPTYS INC *W EXP 09/08/2026' WHERE SecCode = 11231709 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11233903 AND Type_ = 1; UPDATE data_universe SET Name = 'SVRN INC COM' WHERE SecCode = 11234372 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BQZCK79', SecMapStartDate = '2022-06-28' WHERE SecCode = 11243215 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11245715 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11250372 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11250501 AND Type_ = 1; UPDATE data_universe SET Name = 'YYFORCE INC USD CL A ORD SHS' WHERE SecCode = 11264467 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11269574 AND Type_ = 1; UPDATE data_universe SET IncCntry = 'ARE' WHERE SecCode = 11270581 AND Type_ = 1; UPDATE data_universe SET IncCntry = 'ARE' WHERE SecCode = 11272209 AND Type_ = 1; UPDATE data_universe SET PermSecMapStartDate = '2025-07-29', startDate = '2025-07-29' WHERE SecCode = 11281412 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2025-11-06' WHERE SecCode = 11287713 AND Type_ = 1; UPDATE data_universe SET Name = 'SOUTHERN CROSS ACQUISITION I ORD SHS' WHERE SecCode = 11299935 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299987 AND Type_ = 1; UPDATE data_universe SET Name = 'JAB ACQUISITION CORP I CL A ORD SHS' WHERE SecCode = 11300122 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SAMO', QuotePermID = 236813154976.0, InstrPermID = 232944098261.0, OrgPermID = 6000164605.0, PriTrdQuotePermID = 236813154976.0, PriValQuotePermID = 25726992105.0, PriInstrPermID = 232944098261.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-07-10', PermSecMapStartDate = '2026-08-27', startDate = '2026-07-10' WHERE SecCode = 11301170 AND Type_ = 1;