UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 18047 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 27910 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 27911 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXM1HJ9' WHERE SecCode = 28391 AND Type_ = 1;
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 = 4294951782.0 WHERE SecCode = 47438 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-07-07' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US6551866097', RkdSEDOL = 'BVMYDT', RkdCUSIP = '65518660' WHERE SecCode = 50767 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951822.0 WHERE SecCode = 50801 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 59148 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951391.0 WHERE SecCode = 66162 AND Type_ = 10;
UPDATE data_universe SET Name = 'METRODATA ELECTRON IDR10' WHERE SecCode = 74610 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76411 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 77675 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 78290 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232943337046.0 WHERE SecCode = 78664 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLS PHARM LTD NPV', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81778 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85888 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE659F01022', RkdSEDOL = 'BXPWHT', DsPrimQtSedol = 'BXPWHT9' WHERE SecCode = 90598 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 95728 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-07', SecMapEndDate = '2026-06-25', PermQuoteRetireDate = '2026-07-07', PermSecMapEndDate = '2026-07-07', endDate = '2026-06-25' WHERE SecCode = 96110 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96998 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET Name = 'QUALITY HOUSES BUS THB8.1747 (LOCAL) REIT' WHERE SecCode = 186191 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TULI.BO^G26', RkdIssueStatus = 0.0 WHERE SecCode = 243344 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOMAD PWR SOLUTIONS INC COM', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 320972 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 321914 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 351431 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VNE', DsCtryQtStatus = 'A', PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-07', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 522937 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 552491 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-07', PermSecMapEndDate = '2026-07-07' WHERE SecCode = 561094 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1108511 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 1556960 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-07', PermSecMapEndDate = '2026-07-07' WHERE SecCode = 2384518 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '203690.KQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-08', SecMapEndDate = '2026-07-07', PermSecMapEndDate = '2026-07-07', endDate = '2026-07-07' WHERE SecCode = 2646553 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PRESENT24 SA PLN0.06' WHERE SecCode = 2963505 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ADR', DsPrimQtSedol = 'BYW6FR5' WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589220364.0, ExchCode = 'DEU' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3026618 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3108173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3348751 AND Type_ = 10;
UPDATE data_universe SET Name = 'HAOSEN FINTECH GP HKD0.002' WHERE SecCode = 3378474 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXD2KZ8' WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3401662 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3404165 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3495863 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Country = 'GGY' WHERE SecCode = 4586450 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4630501 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-08', SecMapEndDate = '2026-07-01', PermQuoteRetireDate = '2026-07-08', endDate = '2026-07-01' WHERE SecCode = 4631916 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BRECOMACNOR9', RkdTicker = 'ECOM3', PermIDTicker = 'ECOM3', RkdRIC = 'ECOM3.SA', RkdDisplayRIC = 'ECOM3.SA', DsPrimQtSedol = 'BXPVNL0', PermSecMapEndDate = '2026-07-07', endDate = '2026-07-07' WHERE SecCode = 4657577 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5072141 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5257731 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ADR', DsPrimQtSedol = 'BYW6FR5' WHERE SecCode = 5607472 AND Type_ = 10;
UPDATE data_universe SET Name = 'QUALITY HOUSES BUS THB8.1747 (LOCAL) REIT' WHERE SecCode = 6047857 AND Type_ = 10;
UPDATE data_universe SET Country = 'GBR' WHERE SecCode = 6590637 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVYHS87' WHERE SecCode = 6608224 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVYHS87', SecMapEndDate = '2026-07-06', endDate = '2026-07-06' WHERE SecCode = 6930639 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEU HORIZON NPV' WHERE SecCode = 6941636 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945369 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6955124 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 6957668 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11019872 AND Type_ = 1;
UPDATE data_universe SET Name = 'TECNOGLASS INC COM' WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 11080057 AND Type_ = 1;
UPDATE data_universe SET Name = 'DISCOVERY MNG LTD COM' WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11182627 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11204164 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11207414 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 11219530 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-08', SecMapEndDate = '2026-07-06', endDate = '2026-07-06' WHERE SecCode = 11231455 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11245064 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11247311 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11267756 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11272674 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11273677 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NMS' WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 11291638 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232930747007.0 WHERE SecCode = 11296311 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297326 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 11298232 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG815691087', RkdTicker = 'SIND', RkdSEDOL = 'BXD1L3', RkdCUSIP = 'G8156910', RkdRIC = 'SIND.K', RkdDisplayRIC = 'SIND.N', RkdCode = 145137.0, RkdIssueID = 1.0, RkdIssueCode = 185709.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11298355 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GUAC', QuotePermID = 236809330255.0, InstrPermID = 232925334128.0, OrgPermID = 6000114794.0, PriTrdQuotePermID = 236809330255.0, PriValQuotePermID = 25727014693.0, PriInstrPermID = 232925334128.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-05-15', PermSecMapStartDate = '2026-07-03', startDate = '2026-05-15' WHERE SecCode = 11298805 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IDAC', QuotePermID = 236809330273.0, InstrPermID = 232905293752.0, OrgPermID = 6000007950.0, PriTrdQuotePermID = 236809330273.0, PriValQuotePermID = 25727014550.0, PriInstrPermID = 232905293752.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-05-15', PermSecMapStartDate = '2026-07-03', startDate = '2026-05-15' WHERE SecCode = 11298806 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PTAC', QuotePermID = 236809330291.0, InstrPermID = 232925354116.0, OrgPermID = 6000052765.0, PriTrdQuotePermID = 236809330291.0, PriValQuotePermID = 25727014549.0, PriInstrPermID = 232925354116.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-05-15', PermSecMapStartDate = '2026-07-03', startDate = '2026-05-15' WHERE SecCode = 11298807 AND Type_ = 1;
