UPDATE data_universe SET Name = 'EBIQUITY PLC ORD GBP 0.0001' WHERE SecCode = 5832 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 7309 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 11987 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 12764 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 17325 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 17326 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 17327 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 27134 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'FONR.OQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-02', endDate = '2026-06-02' WHERE SecCode = 27805 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 29418 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 30232 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'PPLI', RkdRIC = 'PPLI.O', RkdDisplayRIC = 'PPLI.OQ', Name = 'PEOPLE INCORPORATED COM NEW' WHERE SecCode = 34455 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 42410 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 42571 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 42761 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1988-04-05' WHERE SecCode = 45794 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951271.0 WHERE SecCode = 45939 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 50949 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 59120 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 64069 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 67906 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951554.0 WHERE SecCode = 69894 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 70269 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 73192 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '000638.SZ^F26', DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-03', SecMapEndDate = '2026-04-13', PermQuoteRetireDate = '2026-06-03', PermSecMapEndDate = '2026-06-03', endDate = '2026-04-13' WHERE SecCode = 73938 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 74368 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 74369 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 75219 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ATHDA', PermSecMapEndDate = '2026-06-02', endDate = '2026-06-02' WHERE SecCode = 75379 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '2000-07-13', SecMapEndDate = '2003-05-12', startDate = '2000-07-07' WHERE SecCode = 77092 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '1984-07-02', SecMapEndDate = '1996-10-07' WHERE SecCode = 77232 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1988-08-05' WHERE SecCode = 80148 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80552 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82759 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 86303 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 87126 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '9067.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-03', PermSecMapEndDate = '2026-06-03', endDate = '2026-06-03' WHERE SecCode = 88511 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '1997-04-11' WHERE SecCode = 90401 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 90602 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 93799 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365342.0 WHERE SecCode = 96809 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 97398 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 98178 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 100359 AND Type_ = 1; UPDATE data_universe SET RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 100361 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 101146 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 104982 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 111297 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115324 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115343 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 116171 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125762 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126465 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 126884 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 133245 AND Type_ = 10; UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 135748 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 144431 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1993-10-21' WHERE SecCode = 145422 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 146444 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55846008505.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-31', endDate = '2018-10-31' WHERE SecCode = 147917 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2023-04-12' WHERE SecCode = 169581 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 243646 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 255957 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'SIRS.BO^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-03', SecMapEndDate = '2026-06-02', PermQuoteRetireDate = '2026-06-04', PermSecMapEndDate = '2026-06-03', endDate = '2026-06-02' WHERE SecCode = 314958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 334731 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 334732 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 376837 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2005-07-07' WHERE SecCode = 378468 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SAIGON TREASURE CO VND10000' WHERE SecCode = 522897 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 537956 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 887451 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1039780 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1040923 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 1261606 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 1286114 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951271.0 WHERE SecCode = 1546587 AND Type_ = 10; UPDATE data_universe SET Name = 'HONG KONG GOLD HKD0.04' WHERE SecCode = 1565080 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 1660586 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951345.0 WHERE SecCode = 1706291 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2200264 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2201231 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DK0060477263', RkdTicker = 'A31', RkdSEDOL = 'B9LXBH', RkdCUSIP = 'K0R71710', RkdRIC = 'A31.F', RkdDisplayRIC = 'A31.F', RkdCode = 93890.0, RkdIssueID = 1.0, RkdIssueCode = 118217.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'FRA', RkdExchCtry = 'DEU', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 2216872 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2238141 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2238143 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2441643 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2465135 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 2551294 AND Type_ = 10; UPDATE data_universe SET Name = 'HUA HONG SEMICONDU NPV' WHERE SecCode = 2650541 AND Type_ = 10; UPDATE data_universe SET Name = 'HONG KONG GOLD HKD0.04' WHERE SecCode = 2671255 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2693648 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2752923 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'SE0029277631', RkdSEDOL = 'BVYHMY', RkdCUSIP = 'W7820929', DsPrimQtSedol = 'BVYHMY1' WHERE SecCode = 2909235 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21566116815.0, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 2920449 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2924590 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2924592 AND Type_ = 10; UPDATE data_universe SET Name = 'XINMING CHINA HOLD HKD0.25' WHERE SecCode = 2924595 AND Type_ = 10; UPDATE data_universe SET Name = 'CHIA TAI ENTERPRIS USD0.1' WHERE SecCode = 2929636 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2960314 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951671.0 WHERE SecCode = 2990814 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3184368 AND Type_ = 10; UPDATE data_universe SET Name = 'TAI KAM HOLDINGS L HKD0.05' WHERE SecCode = 3258937 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3318040 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3318951 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'IS3DB', PermSecMapEndDate = '2026-06-02', endDate = '2026-06-02' WHERE SecCode = 3319350 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3375310 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE000A41YD16', RkdTicker = 'B4B0', RkdSEDOL = 'BN4PWJ', RkdCUSIP = 'D5S17Q21', RkdRIC = 'B4B0n.H', RkdDisplayRIC = 'B4B0n.H', DsPrimQtSedol = 'BN4PWJ4' WHERE SecCode = 3376114 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE000A41YD24', RkdTicker = 'B4B1', RkdSEDOL = 'BN4PX7', RkdCUSIP = 'D5S17Q22', RkdRIC = 'B4B1n_p.H', RkdDisplayRIC = 'B4B1n_p.H', DsPrimQtSedol = 'BN4PX79' WHERE SecCode = 3376117 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3396657 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951788.0 WHERE SecCode = 3410320 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3547815 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3569566 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3569568 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 3837224 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 3887970 AND Type_ = 10; UPDATE data_universe SET Name = 'JUNWEA GP CHINA CO HKD0.1' WHERE SecCode = 3929435 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 3998150 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2020-02-28' WHERE SecCode = 4079127 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 4079154 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2020-02-07' WHERE SecCode = 4079217 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'STABL.ST^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-02', PermQuoteRetireDate = '2026-06-04', endDate = '2026-06-02' WHERE SecCode = 4129789 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4242183 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379702 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379704 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2020-10-14' WHERE SecCode = 4382206 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 4438321 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 4491668 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 4491673 AND Type_ = 10; UPDATE data_universe SET Name = 'LE MINERALS LTD NPV' WHERE SecCode = 4558203 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET IncCntry = 'SGP' WHERE SecCode = 4784485 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4798367 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2022-02-23', startDate = '2022-02-01' WHERE SecCode = 4854727 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2022-02-22', startDate = '2022-02-01' WHERE SecCode = 4854746 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2022-02-23', startDate = '2022-02-01' WHERE SecCode = 4854761 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2022-02-23', startDate = '2022-02-01' WHERE SecCode = 4854763 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2022-02-23', startDate = '2022-02-01' WHERE SecCode = 4854808 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe SET Name = 'OCEAN GEOLOOP ASA NOK0.02' WHERE SecCode = 4911182 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 5031884 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'GB00BN0ZLR96', RkdSEDOL = 'BN0ZLR', RkdCUSIP = 'G937EZ10', DsPrimQtSedol = 'BN0ZLR9' WHERE SecCode = 5067274 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-06-03' WHERE SecCode = 5108979 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-03', PermSecMapEndDate = '2026-06-03' WHERE SecCode = 5161399 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2024-04-01' WHERE SecCode = 5407907 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2024-04-01' WHERE SecCode = 5422842 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2024-04-01' WHERE SecCode = 5470846 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2024-04-01' WHERE SecCode = 5485038 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2024-04-01' WHERE SecCode = 5487910 AND Type_ = 10; UPDATE data_universe SET Name = 'HUA HONG SEMICONDU CNY1 A' WHERE SecCode = 5490557 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5493583 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 5640162 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 5668353 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 6285561 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 6285562 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'LU0720694636', RkdTicker = 'SCHI', RkdSEDOL = 'BQT4YW', RkdCUSIP = 'L8019Q10', RkdRIC = 'SCHIS.MC', RkdDisplayRIC = 'SCHIS.MC', RkdCode = 100849.0, RkdIssueID = 1.0, RkdIssueCode = 126880.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MCE', RkdExchCtry = 'ESP', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6389711 AND Type_ = 10; UPDATE data_universe SET Name = 'HUA HONG SEMICONDU DR70:1' WHERE SecCode = 6426959 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AEE01700S258', RkdTicker = 'SAGA', RkdSEDOL = 'BPCPCZ', RkdCUSIP = 'M8T22S10', RkdRIC = 'SAGA.AD', RkdDisplayRIC = 'SAGA.AD', RkdCode = 144966.0, RkdIssueID = 1.0, RkdIssueCode = 185434.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ABD', RkdExchCtry = 'ARE', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6434966 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'SGXPZ11CH7U7', RkdTicker = 'SWICH', RkdSEDOL = 'BTK0HW', RkdCUSIP = 'Y9573C10', RkdRIC = 'SWICH.AS', RkdDisplayRIC = 'SWICH.AS', RkdCode = 144769.0, RkdIssueID = 1.0, RkdIssueCode = 185146.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AMS', RkdExchCtry = 'NLD', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6672572 AND Type_ = 10; UPDATE data_universe SET Name = 'NANCHANG SANRUI CNY1' WHERE SecCode = 6773037 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6789475 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-03', PermSecMapEndDate = '2026-06-03', endDate = '2026-06-03' WHERE SecCode = 6806176 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Q4566740' WHERE SecCode = 6808989 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6846681 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'M2723M10' WHERE SecCode = 6865118 AND Type_ = 10; UPDATE data_universe SET Name = 'EI POWER BHD NPV' WHERE SecCode = 6868104 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21475110262.0, ExchCode = 'NSQ' WHERE SecCode = 10965319 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-03', PermSecMapEndDate = '2026-06-03', endDate = '2026-06-03' WHERE SecCode = 11019872 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 11034260 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11034341 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 11035829 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-03' WHERE SecCode = 11045356 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 11070570 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 11103421 AND Type_ = 1; UPDATE data_universe SET RkdCUSIP = 'M5307120' WHERE SecCode = 11110620 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11111276 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 2500.0 WHERE SecCode = 11131840 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 11176481 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11183394 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11183588 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11192616 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11197095 AND Type_ = 1; UPDATE data_universe SET Name = 'EPIC GOLD CORP COM NEW' WHERE SecCode = 11199074 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BSQLM2', RkdRIC = 'BIPC.TO', RkdDisplayRIC = 'BIPC.TO', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 11206349 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 11206880 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11209569 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11211234 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11212316 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11214005 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11214796 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2021-06-25' WHERE SecCode = 11226283 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11235265 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2022-02-04' WHERE SecCode = 11238076 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11239574 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 11245859 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PBK' WHERE SecCode = 11250433 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 11250924 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 11251539 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11258427 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'IPTNF' WHERE SecCode = 11261939 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11267607 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2024-09-13' WHERE SecCode = 11269640 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11274333 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951271.0 WHERE SecCode = 11274605 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11276347 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG9627S1131', RkdSEDOL = 'BWMWQ5', RkdCUSIP = 'G9627S11', DsPrimQtSedol = 'BWMWQ54' WHERE SecCode = 11276890 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11279172 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NUKUF' WHERE SecCode = 11280331 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 11284197 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 11284219 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 11285566 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11294834 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG3645W1235', RkdTicker = 'FXACU', RkdSEDOL = 'BT3HHT', RkdCUSIP = 'G3645W12', RkdRIC = 'FXACU.O', RkdDisplayRIC = 'FXACU.OQ', RkdCode = 144970.0, RkdIssueID = 1.0, RkdIssueCode = 185438.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11296311 AND Type_ = 1;