UPDATE data_universe SET PermIDTicker = 'OMLl', QuotePermID = 21474899459.0, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02', endDate = '2010-07-02' WHERE SecCode = 10135 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2000-12-07' WHERE SecCode = 13256 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 18019 AND Type_ = 1;
UPDATE data_universe SET Name = 'ENI SPA SPONSORED ADR' WHERE SecCode = 22454 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-03-06' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 68600 AND Type_ = 10;
UPDATE data_universe SET Name = 'KHEN ENERGY LTD NPV (POST-SPLT)' WHERE SecCode = 71417 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q0569120', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 75796 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE639B01023', RkdSEDOL = 'BW6HQG', DsPrimQtSedol = 'BW6HQG6' WHERE SecCode = 81064 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'INDIUM TARGET ADVA ''A''CNY1' WHERE SecCode = 83586 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALGONQUIN POWER & UTILITIES COM' WHERE SecCode = 90226 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-05' WHERE SecCode = 99200 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 112830 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113835 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000PGY8', RkdTicker = 'PGY', RkdSEDOL = 'BYTYBR', RkdCUSIP = 'Q7S43M10', RkdRIC = 'PGY.AX', RkdDisplayRIC = 'PGY.AX', DsPrimQtSedol = 'BYTYBR4' WHERE SecCode = 142703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 188900 AND Type_ = 10;
UPDATE data_universe SET Name = 'SUNSTONE METALS LT NPV' WHERE SecCode = 202343 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'DIVIC1.LM^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-07', SecMapEndDate = '2025-03-13', endDate = '2025-03-13' WHERE SecCode = 323357 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 347684 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 803713 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 897075 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = '2026-03-05' WHERE SecCode = 1019998 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1072702 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = '2026-03-05' WHERE SecCode = 1529243 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1591241 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BYTYBR4' WHERE SecCode = 2300028 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BYTYBR4' WHERE SecCode = 2365687 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-05', PermSecMapEndDate = NULL, startDate = '2014-07-30', endDate = NULL WHERE SecCode = 2600875 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-05' WHERE SecCode = 2879975 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TINC NV/SA NPV' WHERE SecCode = 2883543 AND Type_ = 10;
UPDATE data_universe SET Name = 'GIGA DEVICE A CNY1' WHERE SecCode = 3220407 AND Type_ = 10;
UPDATE data_universe SET Name = 'OMNIVISION A CNY1' WHERE SecCode = 3342720 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MEERA INDUSTRIES L POST SUBD INR5' WHERE SecCode = 3347652 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BYTYBR4' WHERE SecCode = 3359286 AND Type_ = 10;
UPDATE data_universe SET Name = 'SILVER TOUCH TECHN INR2 (POST SUBD)' WHERE SecCode = 3430809 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ROAD', RkdRIC = 'ROAD.L', RkdDisplayRIC = 'ROAD.L', RkdExchCode = 'LON' WHERE SecCode = 3533849 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21865296667.0, ExchCode = 'BTE', PermQuoteRetireDate = '2025-06-02' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5834513 AND Type_ = 10;
UPDATE data_universe SET Name = 'OMNIVISION CNY1 H' WHERE SecCode = 6626594 AND Type_ = 10;
UPDATE data_universe SET Name = 'GIGA DEVICE CNY1 H' WHERE SecCode = 6626817 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699505 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699506 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699508 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699509 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699512 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699513 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699515 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699517 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699519 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699520 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699521 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699525 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699527 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699528 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699529 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699530 AND Type_ = 10;
UPDATE data_universe SET Name = 'VANGUARD INTL EQUI DR(1500:1)', Country = 'USA', IsPrimaryQuote = 1.0 WHERE SecCode = 6699531 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699532 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699533 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699534 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699535 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699536 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699537 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699538 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699539 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6699541 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10922742 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US79400X6022', RkdCUSIP = '79400X60', DsPrimQtSedol = 'BW47PD8' WHERE SecCode = 11144431 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US76152G2093', RkdCUSIP = '76152G20', DsPrimQtSedol = 'BW47PT4' WHERE SecCode = 11191215 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG1329V1225', RkdCUSIP = 'G1329V12', DsPrimQtSedol = 'BVCHVZ7' WHERE SecCode = 11199112 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y', IsPrimaryInstr = 1.0 WHERE SecCode = 11199469 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US0070258779', RkdCUSIP = '00702587', DsPrimQtSedol = 'BW47PF0' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'ALUR.PK', RkdDisplayRIC = 'ALUR.PK', RkdExchCode = 'OTC' WHERE SecCode = 11221773 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MLM.CD', RkdDisplayRIC = 'MLM.CD', RkdExchCode = 'CNQ' WHERE SecCode = 11241337 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2677P1138', RkdCUSIP = 'G2677P11', DsPrimQtSedol = 'BW5TRR1' WHERE SecCode = 11257345 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-05-21' WHERE SecCode = 11277291 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11278125 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, PriInstrPermID = 232903189246.0 WHERE SecCode = 11290608 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291251 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291897 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292080 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG0R21F1214', RkdTicker = 'TRAD.U', RkdSEDOL = 'BWFB40', RkdCUSIP = 'G0R21F12', RkdRIC = 'TRAD_u.K', RkdDisplayRIC = 'TRAD_u.N', RkdCode = 144434.0, RkdIssueID = 1.0, RkdIssueCode = 184515.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11292538 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US04965N1046', RkdTicker = 'RNA', RkdSEDOL = 'BVPN4Z', RkdCUSIP = '04965N10', RkdRIC = 'RNA.O', RkdDisplayRIC = 'RNA.OQ', RkdCode = 144433.0, RkdIssueID = 1.0, RkdIssueCode = 184514.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11292547 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236803833643.0, ExchCode = 'NYS', PermSecMapStartDate = '2026-03-05' WHERE SecCode = 11292600 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SVIV', ModelCntry = 'US', QuotePermID = 236803605570.0, InstrPermID = 232916884514.0, OrgPermID = 5097138035.0, PriTrdQuotePermID = 236803605570.0, PriValQuotePermID = 25727032427.0, PriInstrPermID = 232916884514.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-02-10', PermSecMapStartDate = '2026-02-28', startDate = '2026-02-10' WHERE SecCode = 11292839 AND Type_ = 1;