UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 10081 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 42608 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-04-15' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 56230 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589872687.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JSW DULUX LTD INR10' WHERE SecCode = 71430 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'V V FOOD AND BEVER ''A''CNY1' WHERE SecCode = 76600 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NCCORPORATION KRW500' WHERE SecCode = 76776 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BMU' WHERE SecCode = 77873 AND Type_ = 10;
UPDATE data_universe SET Name = 'OVANTI LIMITED NPV' WHERE SecCode = 77877 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GARF.BO', RkdDisplayRIC = 'GARF.BO' WHERE SecCode = 78612 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TSSF.BO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-16', SecMapEndDate = '2024-08-19', endDate = '2024-08-19' WHERE SecCode = 79135 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BMU' WHERE SecCode = 84070 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'DAYOU A-TECH KRW500' WHERE SecCode = 86683 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 92379 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'FOM.TO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-16', PermQuoteRetireDate = '2026-04-16', endDate = '2026-04-16' WHERE SecCode = 94094 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 94746 AND Type_ = 10;
UPDATE data_universe SET Name = 'KAIROS MINERALS LT NPV' WHERE SecCode = 99340 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MAV' WHERE SecCode = 100885 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 100923 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KG FINANCIAL CO LT KRW500' WHERE SecCode = 123295 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LIG ACCUVER CO LTD KRW500' WHERE SecCode = 124705 AND Type_ = 10;
UPDATE data_universe SET Name = 'APS INNOVATION CO KRW500' WHERE SecCode = 126782 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 146574 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA3060443064', RkdSEDOL = 'BVPLGD', RkdCUSIP = '30604430', DsPrimQtSedol = 'BVPLGD9' WHERE SecCode = 334746 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 335310 AND Type_ = 1;
UPDATE data_universe SET Name = 'WEST WITS MINING NPV DFD 20/04/26 (EX-SPLIT)' WHERE SecCode = 347684 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395047 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 451563 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 533556 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 561073 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SWISS RE AG USD0.12' WHERE SecCode = 1155052 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '138490.KS^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-16', SecMapEndDate = '2026-03-27', PermQuoteRetireDate = '2026-04-16', endDate = '2026-03-27' WHERE SecCode = 1182141 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 PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MATA.BO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-16', SecMapEndDate = '2019-02-18', endDate = '2019-02-18' WHERE SecCode = 1694061 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BMU' WHERE SecCode = 1990909 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-04-16', SecMapEndDate = '2015-12-23', endDate = '2015-12-23' WHERE SecCode = 2586428 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 2930562 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3430661 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 4236123 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 4320768 AND Type_ = 10;
UPDATE data_universe SET Name = 'WILDCAT GOLD PLC ORD GBP0.000028' WHERE SecCode = 4458935 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q2378723' WHERE SecCode = 4470097 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 4565445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4601622 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 4705686 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BMU' WHERE SecCode = 4854739 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'LON' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe SET Name = 'SEERS KRW500' WHERE SecCode = 5807663 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6258193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-15', SecMapEndDate = '2026-04-10', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15', endDate = '2026-04-10' WHERE SecCode = 6310618 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6571951 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6629614 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-15', SecMapEndDate = '2026-04-14', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15', endDate = '2026-04-14' WHERE SecCode = 6710098 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6748873 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6762065 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GFTRF' WHERE SecCode = 10924415 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US64130M3088', RkdSEDOL = 'BVPKCD', RkdCUSIP = '64130M30' WHERE SecCode = 11038598 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA29250N7339', RkdTicker = 'ENB.PR.T', RkdSEDOL = 'B92W46', RkdCUSIP = '29250N73', RkdRIC = 'ENB_pt.TO', RkdDisplayRIC = 'ENB_pt.TO', RkdCode = 23901.0, RkdIssueID = 9.0, RkdIssueCode = 184991.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 7.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', PrimaryIssueCode = 23901.0, COATypeCode = 'IND' WHERE SecCode = 11044249 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA29250N6265', RkdTicker = 'ENB.PF.A', RkdSEDOL = 'BKRHF8', RkdCUSIP = '29250N62', RkdRIC = 'ENB_pfa.TO', RkdDisplayRIC = 'ENB_pfa.TO', RkdCode = 23901.0, RkdIssueID = 10.0, RkdIssueCode = 184992.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 8.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', PrimaryIssueCode = 23901.0, COATypeCode = 'IND' WHERE SecCode = 11131299 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG2659M1041', RkdSEDOL = 'BVPKCT', RkdCUSIP = 'G2659M10' WHERE SecCode = 11153361 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11194352 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'XTKG.OQ^D26', RkdIssueStatus = 0.0 WHERE SecCode = 11195616 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11246941 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11247797 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11292836 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11293198 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293576 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236805674162.0, PermSecMapStartDate = '2026-04-14', startDate = '2026-04-14' WHERE SecCode = 11293741 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293913 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293952 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ICGSF', QuotePermID = 236805614161.0, InstrPermID = 232920806410.0, OrgPermID = 6000074134.0, PriValQuotePermID = 236804914382.0, PriInstrPermID = 232920806410.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951901.0, PermOrgIPODate = '2026-03-31', PermSecMapStartDate = '2026-04-11' WHERE SecCode = 11294399 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLED', QuotePermID = 236805536915.0, InstrPermID = 232913532647.0, OrgPermID = 5096945912.0, PriTrdQuotePermID = 236805536915.0, PriValQuotePermID = 25727027536.0, PriInstrPermID = 232913532647.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-04', PermSecMapStartDate = '2026-04-10', startDate = '2026-03-04' WHERE SecCode = 11294496 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTAL', QuotePermID = 236805537272.0, InstrPermID = 232921672474.0, OrgPermID = 6000016529.0, PriTrdQuotePermID = 236805537272.0, PriValQuotePermID = 25727027424.0, PriInstrPermID = 232921672474.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CYM', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-12', PermSecMapStartDate = '2026-04-10', startDate = '2026-03-12' WHERE SecCode = 11294498 AND Type_ = 1;
