UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 8411 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 9676 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'WHI', QuotePermID = 55836051758.0, InstrPermID = 8589957153.0, OrgPermID = 4295895543.0, PriValQuotePermID = 55836051758.0, PriInstrPermID = 8589957153.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'LSE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951354.0, PermQuoteRetireDate = '2026-03-25', PermOrgIPODate = '2000-07-27', PermSecMapStartDate = '2000-07-26', PermSecMapEndDate = '2026-03-25' WHERE SecCode = 12348 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'IE', DomCntry = 'IRL' WHERE SecCode = 13136 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 19855 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 19856 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 19857 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MERC4.SA^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', endDate = '2026-03-27' WHERE SecCode = 29843 AND Type_ = 10;
UPDATE data_universe SET Name = 'HARMONY GOLD MNG LTD SPONSORED ADR' WHERE SecCode = 32542 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55836451588.0, ExchCode = 'FRA', PermQuoteRetireDate = '2015-03-20' WHERE SecCode = 39278 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'CLGUN' WHERE SecCode = 50750 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 57911 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'NATURGY ENGY GP SA EUR1' WHERE SecCode = 58087 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'WITH.HE^C26', RkdIssueStatus = 0.0 WHERE SecCode = 62226 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TELG.I', QuotePermID = 21475456222.0, ExchCode = 'CST', PermQuoteRetireDate = '2008-04-30' WHERE SecCode = 65616 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67397 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75917 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 PermIDTicker = 'SCIPACK', QuotePermID = 55838809394.0, InstrPermID = 8590023567.0, OrgPermID = 4295883981.0, PriValQuotePermID = 55838809394.0, PriInstrPermID = 8590023567.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'KLS', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', OrgTypeCode = 'COM', DomCntry = 'MYS', IncCntry = 'MYS', PriTRBCIndPermID = 4294951871.0, PermQuoteRetireDate = '2026-03-25', PermSecMapStartDate = '1990-10-03', PermSecMapEndDate = '2026-03-24' WHERE SecCode = 76309 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 DsCtryQtStatus = 'A' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 84787 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'IE', DomCntry = 'IRL' WHERE SecCode = 85168 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 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 PermSecMapEndDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 89843 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '1841.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-26', endDate = '2026-03-26' WHERE SecCode = 94697 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55838822618.0, IsPrimaryQuote = 1.0, ExchCode = 'TOR', PermQuoteRetireDate = '2026-03-25', PermSecMapStartDate = '1990-03-23', PermSecMapEndDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 94805 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-25' WHERE SecCode = 94806 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'LU3306723589', RkdSEDOL = 'BV4K98', RkdCUSIP = 'L5S2AP10', DsPrimQtSedol = 'BV4K983' WHERE SecCode = 95711 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7923.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-26', endDate = '2026-03-26' WHERE SecCode = 97746 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 98338 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 100589 AND Type_ = 1;
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 = '3454.TW^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-18', endDate = '2026-03-18' WHERE SecCode = 132380 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE1LKO01015', RkdSEDOL = 'BWTZ1Z', RkdCUSIP = 'Y1R49B10', DsPrimQtSedol = 'BWTZ1Z1' WHERE SecCode = 136022 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GAS', QuotePermID = 21475431308.0, ExchCode = 'OSL', PermQuoteRetireDate = '2008-07-30' WHERE SecCode = 141248 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21528682235.0, ExchCode = 'QMF', PermQuoteRetireDate = '2012-09-03', endDate = '2012-08-31' WHERE SecCode = 164836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 180539 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21830289175.0, ExchCode = 'GTX' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'V2RETAIL', QuotePermID = 55856026523.0, InstrPermID = 8589965983.0, OrgPermID = 4295874090.0, PriValQuotePermID = 55856026523.0, PriInstrPermID = 8589965983.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSI', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', OrgTypeCode = 'COM', DomCntry = 'IND', IncCntry = 'IND', PriTRBCIndPermID = 4294951490.0, PermOrgIPODate = '2007-06-28', PermSecMapStartDate = '2007-07-04', startDate = '2007-06-28' WHERE SecCode = 303642 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 334757 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'LANM.SI', RkdDisplayRIC = 'LANM.SI' WHERE SecCode = 340262 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US44984F8804', RkdSEDOL = 'BTZS1M', RkdCUSIP = '44984F88', DsPrimQtSedol = 'BTZS1M0' WHERE SecCode = 354777 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '002231.SZ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', endDate = '2026-03-27' WHERE SecCode = 380600 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395057 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 521517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 527873 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2014-09-25', PermSecMapEndDate = '2026-03-25', endDate = '2024-05-31' WHERE SecCode = 586465 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475002890.0, InstrPermID = 21475002889.0, OrgPermID = 5000735811.0, PriValQuotePermID = 21475002890.0, PriInstrPermID = 21475002889.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'UPC', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'VNM', IncCntry = 'VNM', PriTRBCIndPermID = 4294951333.0, PermQuoteRetireDate = '2026-03-25', PermOrgIPODate = '2014-01-16', PermSecMapStartDate = '2014-01-08', PermSecMapEndDate = '2026-03-25' WHERE SecCode = 684152 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 702391 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475138813.0, InstrPermID = 21475134089.0, OrgPermID = 5000053573.0, PriValQuotePermID = 21475138813.0, PriInstrPermID = 21475134089.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'PHS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'PHL', IncCntry = 'PHL', PriTRBCIndPermID = 4294951329.0, PermQuoteRetireDate = '2025-10-31', PermOrgIPODate = '2010-12-09', PermSecMapStartDate = '2010-11-08', PermSecMapEndDate = '2026-03-24', startDate = '2010-11-08', endDate = '2025-10-31' WHERE SecCode = 863684 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 946876 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y270NR10' WHERE SecCode = 1123551 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 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 RkdRIC = 'INDC.BO', DsCtryQtStatus = 'S', RkdIssueStatus = 1.0, DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', endDate = '2024-10-15' WHERE SecCode = 1513718 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 1666188 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1931452 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2287227 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2459985 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2529631 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y6337E10' WHERE SecCode = 2536101 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermSecMapStartDate = '2021-06-29', PermSecMapEndDate = '2026-03-25', startDate = '2015-03-11', endDate = '2024-05-31' WHERE SecCode = 2831954 AND Type_ = 10;
UPDATE data_universe SET Name = 'DRONE VOLT EUR0.1' WHERE SecCode = 2876211 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-26', PermSecMapEndDate = '2026-03-25' WHERE SecCode = 3018639 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3217959 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3289823 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-26', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 3304566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3367032 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727416086.0, InstrPermID = 25727416087.0, OrgPermID = 5000053573.0, PriValQuotePermID = 25727416086.0, PriInstrPermID = 21475134089.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'PHS', QuoteClass = 'PRF', InstrClass = 'PRF', OrgTypeCode = 'COM', DomCntry = 'PHL', IncCntry = 'PHL', PriTRBCIndPermID = 4294951329.0, PermQuoteRetireDate = '2025-10-31', PermOrgIPODate = '2010-12-09', PermSecMapStartDate = '2019-03-07', PermSecMapEndDate = '2026-03-24', endDate = '2025-10-31' WHERE SecCode = 3406739 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 3634524 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SCPKR', RkdRIC = 'SCPKR.MC', RkdDisplayRIC = 'SCPKR.MC', DsCtryQtStatus = 'D', DsPrimQtSedol = NULL, DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-26', PermQuoteRetireDate = '2026-03-27', endDate = '2026-03-26' WHERE SecCode = 3738156 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3817879 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3881132 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 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 PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-25' WHERE SecCode = 4053516 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'IE', DomCntry = 'IRL' WHERE SecCode = 4079078 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 4079129 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 PrimaryIssueType = 'EQU' WHERE SecCode = 4339150 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 4388291 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4425536 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'TAI' WHERE SecCode = 4426890 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727291478.0, InstrPermID = 25727291479.0, OrgPermID = 5000053573.0, PriValQuotePermID = 25727291478.0, PriInstrPermID = 21475134089.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'PHS', QuoteClass = 'PRF', InstrClass = 'PRF', OrgTypeCode = 'COM', DomCntry = 'PHL', IncCntry = 'PHL', PriTRBCIndPermID = 4294951329.0, PermQuoteRetireDate = '2025-10-31', PermOrgIPODate = '2010-12-09', PermSecMapStartDate = '2021-02-01', PermSecMapEndDate = '2026-03-24', startDate = '2021-02-01', endDate = '2025-10-31' WHERE SecCode = 4495557 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BSHRN331', RkdTicker = 'COIL', RkdSEDOL = 'BSHRN3', RkdCUSIP = 'G7636D10', RkdRIC = 'COIL.L', RkdDisplayRIC = 'COIL.L', DsPrimQtSedol = 'BSHRN33' WHERE SecCode = 4539312 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 DsCtryQtStatus = 'S' WHERE SecCode = 4746803 AND Type_ = 10;
UPDATE data_universe SET Name = 'SHANDONG OUMA A CNY1' WHERE SecCode = 4777220 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4826126 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-25', PermSecMapEndDate = '2026-03-25' WHERE SecCode = 4854749 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'JACK', QuotePermID = 236804755237.0, InstrPermID = 21884129024.0, OrgPermID = 5036209770.0, PriValQuotePermID = 236804755237.0, PriInstrPermID = 21884129024.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'OSL', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'NOR', IncCntry = 'NOR', PriTRBCIndPermID = 4294951981.0, PermOrgIPODate = '2019-03-06', PermSecMapStartDate = '2026-03-25', startDate = '2019-03-06' WHERE SecCode = 4950985 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5239788 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '7116', QuotePermID = 21933067230.0, InstrPermID = 21933062616.0, OrgPermID = 5071354903.0, PriValQuotePermID = 21933067230.0, PriInstrPermID = 21933062616.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'TYO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'JPN', PriTRBCIndPermID = 4294951812.0, PermQuoteRetireDate = '2026-03-25', PermSecMapStartDate = '2022-11-22', PermSecMapEndDate = '2026-03-24', startDate = '2022-11-22' WHERE SecCode = 5286272 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOLARA ACTIVE PHAR INR10 (PPD262.575UPD112.5)' WHERE SecCode = 5762104 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NTST34' WHERE SecCode = 5786171 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0NQ401024', RkdSEDOL = 'BW43D0', RkdCUSIP = 'Y048FE12', DsPrimQtSedol = 'BW43D09' WHERE SecCode = 6075860 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y3R80Z11' WHERE SecCode = 6645649 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y2S47A10' WHERE SecCode = 6645655 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'SGP' WHERE SecCode = 6712342 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6731964 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-03-25' WHERE SecCode = 6737826 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 10925215 AND Type_ = 1;
UPDATE data_universe SET Name = 'CONTANGO SILVER & GOLD INC COM' WHERE SecCode = 10982650 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 10999173 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11010072 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11025279 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11071808 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2013-04-10', startDate = '2013-04-10' WHERE SecCode = 11072363 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11131804 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BCEIF', QuotePermID = 236804839638.0, InstrPermID = 46636162447.0, OrgPermID = 4295860591.0, PriValQuotePermID = 21548127428.0, PriInstrPermID = 8590926982.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951190.0, PermOrgIPODate = '1988-01-04', PermSecMapStartDate = '2026-03-25' WHERE SecCode = 11140445 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11142971 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11145834 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11149433 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11151301 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-01' WHERE SecCode = 11157749 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11157785 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11175650 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11176526 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11181827 AND Type_ = 1;
UPDATE data_universe SET Name = 'AMERICAN PAC MNG CORP COM' WHERE SecCode = 11184600 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11193662 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11194629 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CMBMF', RkdRIC = 'CMBMF.PK', RkdDisplayRIC = 'CMBMF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11198280 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US00791N2018', RkdSEDOL = 'BTZS1P', RkdCUSIP = '00791N20', DsPrimQtSedol = 'BTZS1P3' WHERE SecCode = 11200200 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11200720 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11232126 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US2437335084', RkdSEDOL = 'BTZS29', RkdCUSIP = '24373350', DsPrimQtSedol = 'BTZS294' WHERE SecCode = 11234992 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US20678X5023', RkdSEDOL = 'BTZS24', RkdCUSIP = '20678X50', DsPrimQtSedol = 'BTZS249' WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'TBMC.OQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-26', endDate = '2026-03-26' WHERE SecCode = 11252862 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5480M1107', RkdSEDOL = 'BTTMLQ', RkdCUSIP = 'G5480M11', DsPrimQtSedol = 'BTTMLQ2' WHERE SecCode = 11270869 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA6279311089', RkdSEDOL = 'BTG0PM', RkdCUSIP = '62793110', DsPrimQtSedol = 'BTG0PM3', SecMapEndDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 11274307 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-26', endDate = '2026-03-26' WHERE SecCode = 11277711 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CHAC.OQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-27', SecMapEndDate = '2026-03-26', endDate = '2026-03-26' WHERE SecCode = 11278379 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-26', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-03-26' WHERE SecCode = 11278442 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, Name = 'GREENLAND ENERGY CO SHS', Country = 'USA', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-26', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-03-26', startDate = '2025-06-12' WHERE SecCode = 11279226 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RDWCF', COATypeCode = 'IND', QuotePermID = 236804834450.0, InstrPermID = 232917987130.0, OrgPermID = 6000003635.0, PriValQuotePermID = 236802608670.0, PriInstrPermID = 232917987130.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2026-02-06', PermSecMapStartDate = '2026-03-25' WHERE SecCode = 11293659 AND Type_ = 1;
