UPDATE data_universe SET RkdCUSIP = 'G2815316' WHERE SecCode = 3002 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 13227 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CNSY', RkdRIC = 'CNSY.O', RkdDisplayRIC = 'CNSY.OQ' WHERE SecCode = 18270 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 19809 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 23368 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PriValQuotePermID = 21633180184.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-05', PermSecMapEndDate = '2026-08-05' WHERE SecCode = 23378 AND Type_ = 1;
UPDATE data_universe SET Name = 'PAMPA INVEST SA COM NPV' WHERE SecCode = 29336 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-13', SecMapEndDate = '2026-07-10', endDate = '2026-07-10' WHERE SecCode = 29401 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 32114 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ANCR.L^G26' WHERE SecCode = 33139 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 RkdRIC = 'WHATS.BR^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 48155 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 49547 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 63675 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68473 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 69562 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73598 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 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 PermOrgIPODate = NULL WHERE SecCode = 76880 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y311QN10', RkdRIC = 'METR.SI', RkdDisplayRIC = 'METR.SI' WHERE SecCode = 77332 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 78795 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'SUNCORP TECH HKD0.03' WHERE SecCode = 80202 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', COATypeCode = 'IND', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-05', SecMapEndDate = '2025-12-15', PermQuoteRetireDate = '2026-08-06', PermSecMapEndDate = '2026-08-05', endDate = '2025-12-15' WHERE SecCode = 81568 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 84806 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88899 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89261 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 93447 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA30055E1007', RkdSEDOL = 'BVYB5Z', RkdCUSIP = '30055E10', Name = 'EVOLUTION POWERX CORP COM NEW', DsPrimQtSedol = 'BVYB5Z5', PermSecMapEndDate = '2026-08-05', endDate = '2026-08-05' WHERE SecCode = 93659 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA2688481084', RkdTicker = 'ERDA', PermIDTicker = 'ERDA', RkdSEDOL = 'BNYGM7', RkdCUSIP = '26884810', RkdRIC = 'ERDA.V', RkdDisplayRIC = 'ERDA.V', Name = 'ERDA RESOURCE OPPORTUNITIES COM' WHERE SecCode = 93906 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93909 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 = '0VH4', RkdRIC = '0VH4.L^F26', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 95865 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 96636 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 98237 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 98916 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 98956 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 99231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105667 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 RkdIssueStatus = 0.0 WHERE SecCode = 130647 AND Type_ = 10;
UPDATE data_universe SET Name = 'TRAFALGAR MINERALS ORD GBP0.01' WHERE SecCode = 142500 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 147153 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836394912.0, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 161158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 192507 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-08-05' WHERE SecCode = 265315 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 270169 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-05', PermSecMapEndDate = '2026-08-05' WHERE SecCode = 309037 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q2362314' WHERE SecCode = 325884 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-08-05' WHERE SecCode = 331641 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2019-06-08' WHERE SecCode = 336830 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 358152 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395046 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236792907732.0, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET Name = 'DU DU HOLDINGS HKD0.2' WHERE SecCode = 562883 AND Type_ = 10;
UPDATE data_universe SET Name = 'SINO ENERGY CONSER USD0.01', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 565859 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 573274 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 580377 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CPPG.L^G26', RkdIssueStatus = 0.0 WHERE SecCode = 589622 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 821300 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 889182 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-06', PermSecMapEndDate = '2026-08-05', endDate = '2026-08-05' WHERE SecCode = 962511 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1485663 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POTASIOS INVEST SA COM NPV SER''A''' WHERE SecCode = 1488277 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POTASIOS INVEST SA COM NPV SER''B''' WHERE SecCode = 1493776 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'GNGP.WA^F26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 1610436 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2535221 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2700373 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2953264 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951443.0, PermOrgIPODate = NULL WHERE SecCode = 3026504 AND Type_ = 10;
UPDATE data_universe SET Name = 'ECOFINITY ATOMIX INR10' WHERE SecCode = 3030739 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951775.0 WHERE SecCode = 3032260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-06' WHERE SecCode = 3124242 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6197.T^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-06', SecMapEndDate = '2026-08-05', PermSecMapEndDate = '2026-08-05', endDate = '2026-08-05' WHERE SecCode = 3181340 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'DCTA.L^E26' WHERE SecCode = 3182305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3242482 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3406759 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21859526011.0, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-20', endDate = '2022-06-20' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3509105 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TEMBO GLOBAL INDUS INR1(POST SUBD)', DsPrimQtSedol = 'BX86GL3' WHERE SecCode = 3574018 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SCPDD', DsPrimQtSedol = 'BV2D7Z7', SecMapEndDate = '2026-08-04', PermSecMapEndDate = '2026-08-05', endDate = '2026-08-04' WHERE SecCode = 3721200 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-08-04', PermQuoteRetireDate = '2026-08-05', PermSecMapEndDate = '2026-08-05', endDate = '2026-08-04' WHERE SecCode = 3838939 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3841594 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3930588 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 DsCtryQtStatus = 'A' WHERE SecCode = 4029409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4168437 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 = 'S' WHERE SecCode = 4466617 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 PermOrgIPODate = NULL WHERE SecCode = 4605803 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4649877 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IL0011788622', RkdTicker = 'JNGO', RkdSEDOL = 'BMVCBK', RkdCUSIP = 'M6S33F11', RkdRIC = 'JNGO.TA', RkdDisplayRIC = 'JNGO.TA', RkdCode = 145300.0, RkdIssueID = 1.0, RkdIssueCode = 185939.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4656719 AND Type_ = 10;
UPDATE data_universe SET Name = 'BHINEKA INOVASI KE IDR25' WHERE SecCode = 4932395 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4996839 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5230191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5239788 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SCPDD', DsPrimQtSedol = 'BV2D7Z7' WHERE SecCode = 5438122 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5527385 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VISDEM' WHERE SecCode = 5536095 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5590335 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SCPDD', DsPrimQtSedol = 'BV2D7Z7' WHERE SecCode = 5949059 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES0105852000', RkdTicker = 'STNA', RkdSEDOL = 'BSCBBX', RkdCUSIP = 'E8656Q10', RkdRIC = 'STNA.MC', RkdDisplayRIC = 'STNA.MC', RkdCode = 145301.0, RkdIssueID = 1.0, RkdIssueCode = 185940.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MCE', RkdExchCtry = 'ESP', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6032820 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0, PermOrgIPODate = '1753-01-01' WHERE SecCode = 6601458 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0, PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6601504 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6649305 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NZTCME0001S6', RkdTicker = 'TCM', RkdSEDOL = 'BVPR5W', RkdCUSIP = 'Q8816J10', RkdRIC = 'TCM.NZ', RkdDisplayRIC = 'TCM.NZ', RkdCode = 145296.0, RkdIssueID = 1.0, RkdIssueCode = 185934.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NZE', RkdExchCtry = 'NZL', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6699549 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6846668 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6900878 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-08-04' WHERE SecCode = 6951858 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-06', SecMapEndDate = '2026-08-05', PermSecMapEndDate = '2026-08-05', endDate = '2026-08-05' WHERE SecCode = 6957672 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 6960587 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6969134 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6969155 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6974597 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000473464', RkdTicker = 'AXQ', RkdSEDOL = 'BVMJ55', RkdRIC = 'AXQ.AX', RkdDisplayRIC = 'AXQ.AX', RkdCode = 145302.0, RkdIssueID = 1.0, RkdIssueCode = 185941.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'EDR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', ShPerListing = 1.0, PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6974604 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6974607 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'FR0014018Y10', RkdTicker = 'ALLSF', RkdSEDOL = 'BSKSD4', RkdCUSIP = 'F5800510', RkdRIC = 'ALLSF.PA', RkdDisplayRIC = 'ALLSF.PA', RkdCode = 129793.0, RkdIssueID = 1.0, RkdIssueCode = 164553.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'EPA', RkdExchCtry = 'FRA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6974633 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IT0005713232', RkdTicker = 'OROX', RkdSEDOL = 'BWPH9V', RkdCUSIP = 'T5R17M11', RkdRIC = 'OROX.MI', RkdDisplayRIC = 'OROX.MI', RkdCode = 145295.0, RkdIssueID = 1.0, RkdIssueCode = 185932.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BIT', RkdExchCtry = 'ITA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6982424 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y224EY10' WHERE SecCode = 7014883 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 7017411 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 7023687 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007TG7' WHERE SecCode = 7025893 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 10924425 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21565122724.0, ExchCode = 'GSB' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SPAR', Name = 'SPARTACUS METALS INC COM NEW' WHERE SecCode = 11019669 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11025361 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-06', PermQuoteRetireDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 11027691 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11033683 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2013-01-15' WHERE SecCode = 11046053 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'LU3433852426', RkdSEDOL = 'BVCK9X', RkdCUSIP = 'L2067510', RkdListingType = 'OSR', ShPerListing = NULL WHERE SecCode = 11107997 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C084C73' WHERE SecCode = 11144128 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US1031975055', RkdSEDOL = 'BPK473', RkdCUSIP = '10319750' WHERE SecCode = 11151885 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRCB6X4' WHERE SecCode = 11181173 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-07' WHERE SecCode = 11187718 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-02-07', SecMapEndDate = '2025-02-06', endDate = '2025-02-06' WHERE SecCode = 11195409 AND Type_ = 1;
UPDATE data_universe SET Name = 'OBSIDIAN THERAPEUTICS INC COM', PriTrdQuotePermID = 236811734356.0 WHERE SecCode = 11202000 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'STLN', RkdRIC = 'STLN.O', RkdDisplayRIC = 'STLN.OQ', Name = 'STARLING ONCOLOGY INC COM' WHERE SecCode = 11207431 AND Type_ = 1;
UPDATE data_universe SET Name = 'STARLING ONCOLOGY INC *W EXP 11/15/2026' WHERE SecCode = 11207554 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11208072 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BXP2W3' WHERE SecCode = 11210266 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA80928K1066', RkdTicker = 'SMET', RkdSEDOL = 'BVY6YV', RkdCUSIP = '80928K10', RkdRIC = 'SMET.CD', RkdDisplayRIC = 'SMET.CD', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11211670 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11232560 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 11236479 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11238417 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11240505 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EGLT', DsPrimQtSedol = 'C084HD4', SecMapStartDate = '2023-07-27', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 11255741 AND Type_ = 1;
UPDATE data_universe SET Name = 'INTEGRATED QUANTUM TECHNOL I COM' WHERE SecCode = 11260025 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C0471P7', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 11261930 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11266044 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C084C62', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 11273567 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11274425 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA75026P1062', RkdTicker = 'RUC', PermIDTicker = 'RUC', RkdSEDOL = 'BT6MK5', RkdCUSIP = '75026P10', RkdRIC = 'RUC.CD', RkdDisplayRIC = 'RUC.CD', DsPrimQtSedol = 'BT6MK57', RkdExchCode = 'CNQ', ExchCode = 'CNX' WHERE SecCode = 11278535 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11278832 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU', PermOrgIPODate = NULL WHERE SecCode = 11287713 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 11296309 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232938109379.0 WHERE SecCode = 11297350 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11298892 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WAUXF', QuotePermID = 236810639273.0, InstrPermID = 232903215216.0, OrgPermID = 6000116872.0, PriValQuotePermID = 236806230646.0, PriInstrPermID = 232903215216.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951923.0, PermOrgIPODate = '2026-04-27', PermSecMapStartDate = '2026-07-27', startDate = '2026-04-27' WHERE SecCode = 11299657 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951924.0 WHERE SecCode = 11299750 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG0511G1257', RkdTicker = 'FJDIU', RkdSEDOL = 'BX7WKZ', RkdCUSIP = 'G0511G12', RkdRIC = 'FJDIU.O', RkdDisplayRIC = 'FJDIU.OQ', RkdCode = 136339.0, RkdIssueID = 1.0, RkdIssueCode = 173262.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'IPO', COATypeCode = 'IND', QuotePermID = 236811734256.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11300030 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BX7WL2' WHERE SecCode = 11300031 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236811734238.0, PriValQuotePermID = 25726994989.0, IsPrimaryInstr = 1.0, startDate = '2026-07-08' WHERE SecCode = 11300033 AND Type_ = 1;