UPDATE data_universe SET PermOrgIPODate = '2025-02-01' WHERE SecCode = 11392 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EMBJ', RkdRIC = 'EMBJ.K' WHERE SecCode = 23541 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69162 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71229 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74937 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MNGL.NS^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 83605 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88601 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89771 AND Type_ = 10;
UPDATE data_universe SET RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 91731 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'AMSCM.OL^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 137922 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BREMBJACNOR1', RkdTicker = 'EMBJ3', RkdRIC = 'EMBJ3.SA', RkdDisplayRIC = 'EMBJ3.SA' WHERE SecCode = 146014 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 147575 AND Type_ = 10;
UPDATE data_universe SET Name = 'WORLD COPPER LTD COM CL A' WHERE SecCode = 291245 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 318558 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ETHY' WHERE SecCode = 370942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 552470 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 593922 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1665933 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'KDST.TA^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-02', endDate = '2025-11-02' WHERE SecCode = 2267530 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PLUND.ST^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 2383400 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2651700 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2800415 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 2819089 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '3326.HK^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 3055015 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3166717 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3287567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3315876 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ALPH.L^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 3321165 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3337334 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HRCW.CO^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 3434717 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3445257 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 3493632 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21813567823.0, IsPrimaryQuote = 0.0 WHERE SecCode = 3825584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4369869 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4434256 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4557790 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SOZAP.ST^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4773789 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860598463.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-10-31', endDate = '2025-10-31' WHERE SecCode = 4815285 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5388816 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5764048 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 236788762053.0, IsPrimaryQuote = 0.0, ExchCode = 'SIG', PermQuoteRetireDate = '2025-10-31' WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6253475 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6289686 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 6469295 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6518470 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-10-31' WHERE SecCode = 6520689 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EDCU', RkdSEDOL = 'BSLN6J', DsPrimQtSedol = 'BSLN6J4', PermSecMapEndDate = '2025-11-01', endDate = '2025-11-01' WHERE SecCode = 11025361 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-03', PermQuoteRetireDate = '2025-11-03', endDate = '2025-11-03' WHERE SecCode = 11147483 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11151910 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BSLN60', DsPrimQtSedol = 'BSLN605', PermSecMapEndDate = '2025-11-01', endDate = '2025-11-01' WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BSLN6F', DsPrimQtSedol = 'BSLN6F0', PermSecMapEndDate = '2025-11-01', endDate = '2025-11-01' WHERE SecCode = 11178148 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.66667 WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BSLN5R', DsPrimQtSedol = 'BSLN5R5', PermSecMapEndDate = '2025-11-01', endDate = '2025-11-01' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 236793803206.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'GTC', PermQuoteRetireDate = '2025-10-31', PermSecMapStartDate = '2024-12-17', PermSecMapEndDate = '2025-10-31', endDate = '2025-10-31' WHERE SecCode = 11236204 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BSMLKZ', DsPrimQtSedol = 'BSMLKZ1', PermSecMapEndDate = '2025-11-01', endDate = '2025-11-01' WHERE SecCode = 11236809 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BSLN5L', DsPrimQtSedol = 'BSLN5L9', PermSecMapEndDate = '2025-11-01', endDate = '2025-11-01' WHERE SecCode = 11239312 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11267641 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FTW.U' WHERE SecCode = 11268211 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FTW' WHERE SecCode = 11270085 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232898486293.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11285256 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11286613 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2025-10-31' WHERE SecCode = 11287208 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NOMA', QuotePermID = 236798224256.0, InstrPermID = 232871029129.0, OrgPermID = 5086813357.0, PriTrdQuotePermID = 236798224256.0, PriValQuotePermID = 25727048615.0, PriInstrPermID = 232871029129.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951401.0, PermSecMapStartDate = '2025-10-30', startDate = '2025-10-30' WHERE SecCode = 11287553 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'VACI.U' WHERE SecCode = 11287596 AND Type_ = 1;
