UPDATE data_universe SET ExchCode = 'NSM' WHERE SecCode = 19752 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475801368.0, ExchCode = 'SIG', PermQuoteRetireDate = '2018-10-03', endDate = '2018-10-03' WHERE SecCode = 54237 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 RkdRIC = 'PSIBb.BQB^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-01', SecMapEndDate = '2025-09-22', PermSecMapEndDate = '2025-12-01', endDate = '2025-09-22' WHERE SecCode = 64069 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74375 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TECK.B', QuotePermID = 55838857866.0, ExchCode = 'TOR', PermSecMapStartDate = '1990-03-30' WHERE SecCode = 74703 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77146 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78488 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 81933 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 85724 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 88710 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 89085 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 100359 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 100361 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55837424519.0, ExchCode = 'TYO' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-19' WHERE SecCode = 117300 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 128181 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140590 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BNG97G', DsPrimQtSedol = 'BNG97G6', PermSecMapEndDate = '2025-11-28' WHERE SecCode = 143532 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PAUSHAKLTD', QuotePermID = 236799474665.0, ExchCode = 'NSI' WHERE SecCode = 145481 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 182791 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 185717 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 195229 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'YARR', RkdSEDOL = 'BNDY66', PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 238622 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 293429 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 354777 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 383389 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 391857 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 822496 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 946876 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 963175 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 1153566 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BNG959', DsPrimQtSedol = 'BNG9595', PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 1232910 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1493448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1617057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1623752 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 1625573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1796548 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = 'BRAR.WA^L25', RkdDisplayRIC = 'BRAR.WA^L25', RkdIssueStatus = 0.0 WHERE SecCode = 1999277 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2264327 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2293015 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2587437 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2731219 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212696 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3242487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3273515 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3296406 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-05' WHERE SecCode = 3318537 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FVIR.MI^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-01', SecMapEndDate = '2025-11-27', PermSecMapEndDate = '2025-12-01', endDate = '2025-11-27' WHERE SecCode = 3441651 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 3587065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3894833 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4033056 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNG97G6' WHERE SecCode = 4426887 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 4491668 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 4592044 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 4627925 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097046772.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = NULL WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4934300 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4969545 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5059330 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097048823.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '2022-06-30' WHERE SecCode = 5078429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5115507 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 130071.0 WHERE SecCode = 5140051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5268212 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097049014.0, PriInstrPermID = 232801208789.0, IsPrimaryInstr = 1.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5274293 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000278103', RkdTicker = 'LNW', RkdSEDOL = 'BMXNX1', RkdCUSIP = 'U8067910', RkdRIC = 'LNW.AX', RkdDisplayRIC = 'LNW.AX', RkdCode = 4812.0, RkdIssueID = 4.0, RkdIssueCode = 183357.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'EDR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', ShPerListing = 1.0, PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 5421844 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BVMVCF', DsPrimQtSedol = 'BVMVCF6', PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 5455244 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 5595256 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5758201 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5885464 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6067543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6318909 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951724.0 WHERE SecCode = 6339509 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6478348 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-01', SecMapEndDate = '2025-11-28', PermSecMapEndDate = '2025-11-30', endDate = '2025-11-28' WHERE SecCode = 6518452 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6564749 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6564752 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6567905 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BVMSMW', DsPrimQtSedol = 'BVMSMW4', PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-01', SecMapEndDate = '2025-11-28', PermQuoteRetireDate = '2025-12-01', PermSecMapEndDate = '2025-12-01', endDate = '2025-11-28' WHERE SecCode = 11145445 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BVMSRF', DsPrimQtSedol = 'BVMSRF2', PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 11156578 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CLSDQ', PermIDTicker = 'CLSDQ', RkdRIC = 'CLSDQ.PK', RkdDisplayRIC = 'CLSDQ.PK', RkdExchCode = 'OTC', QuotePermID = 21588529972.0, PriTrdQuotePermID = NULL, ExchCode = 'PNK' WHERE SecCode = 11156633 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GRDX' WHERE SecCode = 11161215 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11177272 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BVMSMT', DsPrimQtSedol = 'BVMSMT1', PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 11178865 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11180183 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11188494 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'LIDA.CD^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-01' WHERE SecCode = 11207842 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GRYCD', RkdSEDOL = 'BNDY4L', PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 11211075 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BVLFJ0', DsPrimQtSedol = 'BVLFJ03', PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MRP' WHERE SecCode = 11274664 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-29', endDate = '2025-11-29' WHERE SecCode = 11282244 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2025-11-28', SecMapStartDate = '2025-10-23' WHERE SecCode = 11287199 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11287481 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2025-11-28', SecMapStartDate = '2025-11-13' WHERE SecCode = 11288140 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2025-11-28', SecMapStartDate = '2025-11-26' WHERE SecCode = 11288778 AND Type_ = 1;
