UPDATE data_universe SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 43286 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-25', SecMapEndDate = '2007-12-28', PermSecMapEndDate = '2025-09-25', endDate = '2007-12-28' WHERE SecCode = 70899 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '9613.T^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-26', SecMapEndDate = '2025-09-25', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 71468 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 74457 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 78656 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 79978 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81224 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 83801 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'GVTDA' WHERE SecCode = 84866 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-24', startDate = '1989-06-01' WHERE SecCode = 86007 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '0226.HK^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-26', SecMapEndDate = '2025-09-25', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 87347 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2013-04-17' WHERE SecCode = 90135 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92314 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7451.T^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-26', SecMapEndDate = '2025-09-25', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 94005 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 94296 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '6821807' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA33944M4083', RkdSEDOL = 'BVBFJL', RkdCUSIP = '33944M40', DsPrimQtSedol = 'BVBFJL4' WHERE SecCode = 97202 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU0000421893', RkdTicker = 'PL9', PermIDTicker = 'PL9', RkdSEDOL = 'BVBLVK', RkdRIC = 'PL9.AX', RkdDisplayRIC = 'PL9.AX', DsPrimQtSedol = 'BVBLVK5', SecMapEndDate = '2025-09-24', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-24' WHERE SecCode = 99030 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HNL.DE', RkdDisplayRIC = 'HNL.DE' WHERE SecCode = 99529 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-09-26', endDate = '2025-09-26' WHERE SecCode = 110311 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU0000421851', RkdTicker = 'ELV', PermIDTicker = 'ELV', RkdSEDOL = 'BVBM1M', RkdRIC = 'ELV.AX', RkdDisplayRIC = 'ELV.AX', DsPrimQtSedol = 'BVBM1M0', SecMapEndDate = '2025-09-24', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-24' WHERE SecCode = 111747 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-25', SecMapEndDate = '2008-01-15', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-25', endDate = '2008-01-15' WHERE SecCode = 135529 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 140027 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q2096E23' WHERE SecCode = 141616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142797 AND Type_ = 10;
UPDATE data_universe SET Name = 'MASTRAD EUR0.005' WHERE SecCode = 145136 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 180539 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 270236 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 294471 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'P6438618' WHERE SecCode = 302757 AND Type_ = 10;
UPDATE data_universe SET Name = 'MALIBU LIFE HOLD L ORD USD0.01 (DI)' WHERE SecCode = 310251 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 336183 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'HLHL.SI^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-26', SecMapEndDate = '2025-09-04', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-04' WHERE SecCode = 415865 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PL9', DsPrimQtSedol = 'BVBLVK5' WHERE SecCode = 566622 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2009-12-21' WHERE SecCode = 580355 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-24', PermQuoteRetireDate = '2025-09-25', endDate = '2025-09-24' WHERE SecCode = 774326 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 944678 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PL9', DsPrimQtSedol = 'BVBLVK5' WHERE SecCode = 1129014 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1496294 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'VG', DomCntry = 'VGB' WHERE SecCode = 1981169 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KRIS.SI^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-25', SecMapEndDate = '2019-08-13', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25', endDate = '2019-08-13' WHERE SecCode = 2298762 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE428B01021', RkdSEDOL = 'BRVVXC', DsPrimQtSedol = 'BRVVXC3', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 2380633 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ELV', DsPrimQtSedol = 'BVBM1M0' WHERE SecCode = 2384507 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SCHLR' WHERE SecCode = 2515727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2536075 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 2569983 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PL9', DsPrimQtSedol = 'BVBLVK5' WHERE SecCode = 3285139 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q9093A18' WHERE SecCode = 3320330 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE219Y01026', RkdSEDOL = 'BSSB6X', DsPrimQtSedol = 'BSSB6X5', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 3396332 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3599035 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3881163 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4388410 AND Type_ = 10;
UPDATE data_universe SET Name = 'PROSTATYPE GENOMIC NPV' WHERE SecCode = 4396721 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4474199 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4539145 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE418L01047', RkdSEDOL = 'BSSB76', DsPrimQtSedol = 'BSSB765', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 4542550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4697290 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4751051 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5112409 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236796327838.0 WHERE SecCode = 5144072 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5493583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5516790 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2024-01-10' WHERE SecCode = 5623170 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2024-01-26' WHERE SecCode = 5623171 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5626466 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4585.TW', RkdDisplayRIC = '4585.TW', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5931893 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-02-05' WHERE SecCode = 6063952 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-02-24' WHERE SecCode = 6063953 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6258207 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SGXE10283153', RkdTicker = 'LCC', RkdSEDOL = 'BVN3XG', RkdCUSIP = 'Y536KU10', RkdRIC = 'LUMC.SI', RkdDisplayRIC = 'LUMC.SI', RkdCode = 143052.0, RkdIssueID = 1.0, RkdIssueCode = 182623.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SIN', RkdExchCtry = 'SGP', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6377047 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IT0005664641', RkdTicker = 'AMI', RkdSEDOL = 'BNRN7M', RkdCUSIP = 'T4R49110', RkdRIC = 'AMI.MI', RkdDisplayRIC = 'AMI.MI', RkdCode = 143050.0, RkdIssueID = 1.0, RkdIssueCode = 182618.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BIT', RkdExchCtry = 'ITA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6407335 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y447LF10' WHERE SecCode = 6467526 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469315 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469316 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469317 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469319 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US53814X3008', RkdSEDOL = 'BVBFGJ', RkdCUSIP = '53814X30', DsPrimQtSedol = 'BVBFGJ1' WHERE SecCode = 11002865 AND Type_ = 1;
UPDATE data_universe SET Name = 'LUX METALS CORP COM', PermSecMapEndDate = '2025-09-25', endDate = '2025-09-25' WHERE SecCode = 11072382 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11178780 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11199574 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-09-25', SecMapEndDate = '2025-09-24', endDate = '2025-09-24' WHERE SecCode = 11212952 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11215640 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11218535 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11224473 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11227644 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11241066 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11252317 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA', DsExchMnem = 'NAS' WHERE SecCode = 11253494 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'Q4933C13' WHERE SecCode = 11270044 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096778001.0, PriInstrPermID = 232856268550.0, PermOrgIPODate = NULL WHERE SecCode = 11270656 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE data_universe SET Name = 'ELEVRA LITHIUM LTD SPONSORED ADS' WHERE SecCode = 11284307 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4365E1035', RkdTicker = 'HCMA', RkdSEDOL = 'BVRVFJ', RkdCUSIP = 'G4365E10', RkdRIC = 'HCMA.O', RkdDisplayRIC = 'HCMA.OQ', RkdCode = 142640.0, RkdIssueID = 3.0, RkdIssueCode = 182621.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11285633 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GWO.PR.Z', QuotePermID = 236796239767.0, InstrPermID = 232900478694.0, OrgPermID = 4295860615.0, PriValQuotePermID = 236796239767.0, PriInstrPermID = 8590928195.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'NONCUM', InstrClass = 'NONCUM', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951339.0, PermOrgIPODate = '1986-06-26', PermSecMapStartDate = '2025-09-23', startDate = '2025-09-23' WHERE SecCode = 11285638 AND Type_ = 1;