UPDATE data_universe SET RkdRIC = 'TIRU.L^G26', InfoCode = 400614, DsSecCode = 274783, IsMajorSec = 'N', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BTDN2T1', RkdIssueStatus = 0.0, DsSecDelistDate = NULL, DsExchQtStartDate = '2026-07-13', SecMapStartDate = '2026-07-13', SecMapEndDate = '2079-06-06' WHERE SecCode = 3260 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA8859331016', RkdTicker = 'TCCM', PermIDTicker = 'TCCM', RkdSEDOL = 'BXS032', RkdCUSIP = '88593310', RkdRIC = 'TCCM.V', RkdDisplayRIC = 'TCCM.V', Name = 'THREE CROWNS CRITICAL METALS COM', SecMapEndDate = '2026-07-13', endDate = '2026-07-13' WHERE SecCode = 5820 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', startDate = '1960-01-01' WHERE SecCode = 23846 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 23996 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 25075 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 2.0 WHERE SecCode = 28602 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 1.0 WHERE SecCode = 28624 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOVABASE SGPS SA EUR0.97' WHERE SecCode = 35101 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 39076 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 39279 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 39280 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837361864.0, ExchCode = 'GER' WHERE SecCode = 46439 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 55063 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 69151 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IND' WHERE SecCode = 71407 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GREEN LEADER HLDGS HKD0.004' WHERE SecCode = 72986 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 73158 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000478117', RkdTicker = 'CYV', RkdSEDOL = 'BSSF4N', RkdRIC = 'CYV.AX', RkdDisplayRIC = 'CYV.AX' WHERE SecCode = 74387 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 78585 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPY0C48' WHERE SecCode = 79390 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4834.SP^G26', RkdIssueStatus = 0.0, PermSecMapEndDate = '2026-07-13' WHERE SecCode = 79403 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951804.0 WHERE SecCode = 79892 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 84805 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'XOMA.OQ^G26', RkdIssueStatus = 0.0 WHERE SecCode = 85191 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85899 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '012510.KS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-15', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 86473 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 87093 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG1941S1504', RkdSEDOL = 'BW61LW', RkdCUSIP = 'G1941S15' WHERE SecCode = 88263 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG522112017', RkdSEDOL = 'BXD2L2', RkdCUSIP = 'G5221120' WHERE SecCode = 89269 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 RkdCUSIP = 'Y2944J13', PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 90598 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90720 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 91086 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 91216 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95047 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '000004.SZ^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-14', startDate = '1991-08-26' WHERE SecCode = 95337 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 RkdTicker = NULL, RkdRIC = '600636.SS^F26', RkdIssueStatus = 0.0 WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '600421.SS^F26', RkdIssueStatus = 0.0 WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'EBIL.BO', RkdDisplayRIC = 'EBIL.BO' WHERE SecCode = 135128 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AHNDA', DsPrimQtSedol = 'BWM2LY8', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-14' WHERE SecCode = 180020 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 302601 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 312992 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 333221 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BV4K2J5', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-14' WHERE SecCode = 411896 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 553461 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '300029.SZ^G26', RkdIssueStatus = 0.0 WHERE SecCode = 558540 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '002808.SZ^G26', RkdIssueStatus = 0.0, PermSecMapEndDate = '2026-07-13' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2026-07-14', endDate = '2026-07-14' WHERE SecCode = 702056 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2026-06-19', PermQuoteRetireDate = '2026-07-15', endDate = '2026-06-19' WHERE SecCode = 783007 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 863623 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 1060452 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 86408.0 WHERE SecCode = 1205687 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'EFEN.WA^G26', RkdIssueStatus = 0.0 WHERE SecCode = 1341380 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BPY0C48' WHERE SecCode = 1534257 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AURUS GEM CORP LTD INR10' WHERE SecCode = 1618087 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdTicker = 'AAGB', RkdRIC = 'AIRG.KL', RkdDisplayRIC = 'AIRG.KL', Name = 'AIRASIA GROUP BHD NPV' WHERE SecCode = 2278101 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'VGB' WHERE SecCode = 2536035 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2564920 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2708934 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2864406 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2894516 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BRB' WHERE SecCode = 2905569 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2025-10-08', PermQuoteRetireDate = '2026-07-15', endDate = '2025-10-08' WHERE SecCode = 2935048 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365483.0 WHERE SecCode = 2955835 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3546.T^F26', RkdIssueStatus = 0.0 WHERE SecCode = 3235105 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'VGB' WHERE SecCode = 3316565 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 3321102 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 3350753 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'TCD.HM^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2025-10-08', PermQuoteRetireDate = '2026-07-15', endDate = '2025-10-08' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3397145 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 3409309 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'CYKEL AI PLC ORD GBP0.10' WHERE SecCode = 3906622 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-14', endDate = '2026-07-14' WHERE SecCode = 3917553 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 117890.0 WHERE SecCode = 4335825 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 4385223 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 RkdTicker = 'FIB', RkdRIC = 'FIBP.WA', RkdDisplayRIC = 'FIBP.WA' WHERE SecCode = 4582489 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MNRA-M' WHERE SecCode = 4651023 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 4787472 AND Type_ = 10;
UPDATE data_universe SET Name = 'ATLAS NEXUS GP TBK IDR10' WHERE SecCode = 5002422 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5250953 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000477440', RkdTicker = 'SKG', RkdSEDOL = 'BVPFTH', RkdRIC = 'SKG.AX', RkdDisplayRIC = 'SKG.AX' WHERE SecCode = 5485039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5617213 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6414075 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6431535 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6513037 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', QuotePermID = 236800860348.0, ExchCode = 'DUS', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-10', PermQuoteRetireDate = '2026-07-14', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-10' WHERE SecCode = 6562598 AND Type_ = 10;
UPDATE data_universe SET Name = 'ZAGROS RENDA IMOBI COTAS' WHERE SecCode = 6601463 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6617659 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6734290 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6813816 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6829246 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6900879 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'VBB.HM', RkdDisplayRIC = 'VBB.HM', RkdIssueStatus = 1.0, RkdExchCode = 'HCM' WHERE SecCode = 6927579 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6939102 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007QH1', RkdTicker = '1688', RkdSEDOL = 'BPQV5V', RkdCUSIP = 'Y527JS10', RkdRIC = '1688.HK', RkdDisplayRIC = '1688.HK', RkdCode = 145157.0, RkdIssueID = 1.0, RkdIssueCode = 185742.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 86408.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6945361 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-07-01', startDate = '2026-06-15' WHERE SecCode = 6955168 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PLROBYG00321', RkdTicker = 'ROB', RkdSEDOL = 'BRT7B6', RkdCUSIP = 'X7362011', RkdRIC = 'ROBP.WA', RkdDisplayRIC = 'ROBP.WA', RkdCode = 83892.0, RkdIssueID = 1.0, RkdIssueCode = 105751.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'WAR', RkdExchCtry = 'POL', PrimaryIssueType = 'PVT', COATypeCode = 'IND' WHERE SecCode = 6957663 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007QJ7', RkdTicker = '668', RkdSEDOL = 'BVSTMH', RkdCUSIP = 'Y0142511', RkdRIC = '0668.HK', RkdDisplayRIC = '0668.HK', RkdCode = 145159.0, RkdIssueID = 1.0, RkdIssueCode = 185745.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 117890.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6957670 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6967200 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6969132 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6969134 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 6969197 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6974605 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ID1000214406', RkdTicker = 'RANS', RkdSEDOL = 'BTFGMN', RkdRIC = 'RANS.JK', RkdDisplayRIC = 'RANS.JK', RkdCode = 145156.0, RkdIssueID = 1.0, RkdIssueCode = 185740.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'JAK', RkdExchCtry = 'IDN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6977543 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0XE501015', RkdTicker = 'ICELCO', RkdSEDOL = 'BX59CP', RkdCUSIP = 'Y3R5DK10', RkdRIC = 'ICEL.NS', RkdDisplayRIC = 'ICEL.NS', RkdCode = 145154.0, RkdIssueID = 1.0, RkdIssueCode = 185738.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6977549 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'WSR.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 10967956 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermSecMapEndDate = '2026-07-14' WHERE SecCode = 11078249 AND Type_ = 1;
UPDATE data_universe SET Name = 'EXPRO LTD ORD SHS', Country = 'CYM' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11151156 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11158566 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000175781.0 WHERE SecCode = 11163549 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'EEX.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 11171866 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'AZIO', RkdRIC = 'AZIO.O', RkdDisplayRIC = 'AZIO.OQ' WHERE SecCode = 11173743 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11192959 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'XOMAP.OQ', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 11216248 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2026-07-13', endDate = '2026-07-13' WHERE SecCode = 11222396 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11226560 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11226875 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL WHERE SecCode = 11231455 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2021-12-15' WHERE SecCode = 11235729 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11241616 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11250859 AND Type_ = 1;
UPDATE data_universe SET Name = 'HONGLI GROUP INC. CL A SHR' WHERE SecCode = 11250986 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11256250 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11276347 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SDM.OQ^G26', RkdIssueStatus = 0.0 WHERE SecCode = 11277960 AND Type_ = 1;
UPDATE data_universe SET Name = 'IQM QUANTUM COMPUTERS OYJ', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11278832 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000169509.0, PermOrgIPODate = '2025-11-13' WHERE SecCode = 11279159 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BXRVNH' WHERE SecCode = 11286103 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11286421 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11295628 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11296311 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232921039825.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11296370 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG731671015', RkdTicker = 'QLEP', RkdSEDOL = 'BSGYVN', RkdCUSIP = 'G7316710', RkdRIC = 'QLEP.K', RkdDisplayRIC = 'QLEP.N', RkdCode = 144360.0, RkdIssueID = 3.0, RkdIssueCode = 185750.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11298136 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8443M1024', RkdTicker = 'OTAI', RkdSEDOL = 'BVV841', RkdCUSIP = 'G8443M10', RkdRIC = 'OTAI.K', RkdDisplayRIC = 'OTAI.N', RkdCode = 144371.0, RkdIssueID = 1.0, RkdIssueCode = 184427.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11298447 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3645W1078', RkdTicker = 'FXAC', RkdSEDOL = 'BXM0PB', RkdCUSIP = 'G3645W10', RkdRIC = 'FXAC.O', RkdDisplayRIC = 'FXAC.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 = 'IND' WHERE SecCode = 11298872 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA94420C1086', RkdSEDOL = 'BTMT3T', RkdCUSIP = '94420C10' WHERE SecCode = 11298890 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'SKHY', RkdRIC = 'SKHY.O', RkdDisplayRIC = 'SKHY.OQ' WHERE SecCode = 11299029 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG7862H1231', RkdTicker = 'SAMO.U', RkdSEDOL = 'BTMQZ1', RkdCUSIP = 'G7862H12', RkdRIC = 'SAMO_u.K', RkdDisplayRIC = 'SAMO_u.N', RkdCode = 145067.0, RkdIssueID = 1.0, RkdIssueCode = 185613.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11299061 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRCDLV3' WHERE SecCode = 11299063 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TVIV', QuotePermID = 236809682149.0, InstrPermID = 232907768660.0, OrgPermID = 5097065975.0, PriTrdQuotePermID = 236809682149.0, PriValQuotePermID = 25727006345.0, PriInstrPermID = 232907768660.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-06-18', PermSecMapStartDate = '2026-07-10', startDate = '2026-06-18' WHERE SecCode = 11299126 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'YICC', QuotePermID = 236809682170.0, InstrPermID = 232933035177.0, OrgPermID = 6000136262.0, PriTrdQuotePermID = 236809682170.0, PriValQuotePermID = 25727006324.0, PriInstrPermID = 232933035177.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-06-16', PermSecMapStartDate = '2026-07-10', startDate = '2026-06-16' WHERE SecCode = 11299127 AND Type_ = 1;
