UPDATE data_universe SET Name = 'ICICI BK LTD HONG KONG BRANC ADR' WHERE SecCode = 35383 AND Type_ = 1;
UPDATE data_universe SET Name = 'KAISER ALUMINIUM CORPORATION COM PAR $0.01' WHERE SecCode = 39168 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF GREENLAND DKK100' WHERE SecCode = 40228 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21556317777.0 WHERE SecCode = 44550 AND Type_ = 10;
UPDATE data_universe SET Name = 'MARSH COM' WHERE SecCode = 44716 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, ExchCode = 'AQX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET Name = 'PROCTER & GAMBLE CO COM' WHERE SecCode = 57508 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 68000 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KOTAK MAHINDRA BAN INR1(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 71861 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 72133 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '033180.KS^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-15', SecMapEndDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 73063 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'REGANTO ENTERPRISE INR1' WHERE SecCode = 76533 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80964 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82274 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-15', SecMapEndDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 83226 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 83690 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83956 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87755 AND Type_ = 10;
UPDATE data_universe SET Name = 'IBC ADVANCED ALLOY COM' WHERE SecCode = 95676 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'AJMERA REALTY & IN INR2(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 95887 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99233 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 136522 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 136743 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'OPENMOVE AI BHD MYR0.10' WHERE SecCode = 141865 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y8070T14' WHERE SecCode = 145678 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 147109 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PriValQuotePermID = 55836487034.0, DsSecDelistDate = '2026-01-15', SecMapEndDate = '2026-01-13', PermSecMapEndDate = '2026-01-14', endDate = '2026-01-13' WHERE SecCode = 176977 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 243458 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 1.0 WHERE SecCode = 334841 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'BEIJING ORIENT ECO ''A''CNY1' WHERE SecCode = 554140 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 991752 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '1263.HK^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-15', SecMapEndDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 1493553 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-14' WHERE SecCode = 2466513 AND Type_ = 10;
UPDATE data_universe SET Name = 'GATE GROUP TEKNOLO TRY1 (B SHARES)' WHERE SecCode = 2827902 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'HALDER', RkdRIC = 'VINE.NS', RkdDisplayRIC = 'VINE.NS', RkdExchCode = 'NSE' WHERE SecCode = 3155992 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y0S7NZ10' WHERE SecCode = 3619195 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 3967146 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4010780 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MARSH BDR EACH 2 REPR 1 COM' WHERE SecCode = 4077652 AND Type_ = 10;
UPDATE data_universe SET Name = 'TIRUPATI GRAPHITE ORD GBP0.01' WHERE SecCode = 4442693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4447564 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 4571417 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-08-22' WHERE SecCode = 4777507 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6722.TW', RkdDisplayRIC = '6722.TW', RkdExchCode = 'TPE' WHERE SecCode = 4972255 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, DsPrimQtSedol = 'BNXMYV2', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, SecMapEndDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 4985764 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5128580 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5383306 AND Type_ = 10;
UPDATE data_universe SET Name = 'PERSISTENCE GOLD HKD0.01' WHERE SecCode = 5617107 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5822237 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7795.TW', RkdDisplayRIC = '7795.TW' WHERE SecCode = 6020732 AND Type_ = 10;
UPDATE data_universe SET Name = 'BALSU GIDA SANAYI TRY1' WHERE SecCode = 6139876 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6443226 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6562457 AND Type_ = 10;
UPDATE data_universe SET Name = 'HAIAN RUBBER GR CO CNY1 A' WHERE SecCode = 6569448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-15', SecMapEndDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 6589126 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6593827 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIMANDHAR IMPEX INR10' WHERE SecCode = 6610153 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6612484 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6626028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 6626810 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y757AQ10' WHERE SecCode = 6626812 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-14' WHERE SecCode = 11014560 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 11038945 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BXDZ9Z', RkdRIC = 'SHOP.O', RkdDisplayRIC = 'SHOP.OQ', InfoCode = 282712, DsPrimQtSedol = 'BXDZ9Z0', DsExchMnem = 'NAS', DsExchCtryCode = 'US', DsQuoteCurr = 'USD', RkdCode = 102603.0, RkdIssueCode = 128997.0, RkdExchCode = 'NASD', RkdExchCtry = 'USA', RelType = NULL WHERE SecCode = 11148569 AND Type_ = 1;
UPDATE data_universe SET Name = 'ONDAS HOLDINGS INC COM NEW' WHERE SecCode = 11181887 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'JE00BV7DQ550', RkdSEDOL = 'BV7DQ5', RkdCUSIP = 'G0250X14' WHERE SecCode = 11197962 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-14', SecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 11217418 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 11223576 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'US', OrgPermID = 5097121481.0, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11225955 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289102 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289259 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2131A1242', RkdTicker = 'CCXIU', RkdSEDOL = 'BP7MXP', RkdCUSIP = 'G2131A12', RkdRIC = 'CCXIU.O', RkdDisplayRIC = 'CCXIU.OQ', RkdCode = 143961.0, RkdIssueID = 1.0, RkdIssueCode = 183872.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11289585 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GCDT', ModelCntry = 'HK', QuotePermID = 236801426590.0, InstrPermID = 232837462888.0, OrgPermID = 5087018830.0, PriTrdQuotePermID = 236801426590.0, PriValQuotePermID = 25727040074.0, PriInstrPermID = 232837462888.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'ASE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951828.0, PermOrgIPODate = '2026-01-13', PermSecMapStartDate = '2026-01-10', startDate = '2026-01-10' WHERE SecCode = 11290571 AND Type_ = 1;