UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 17968 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'BICE', PermIDTicker = 'BICE', RkdRIC = 'BICE.SN', RkdDisplayRIC = 'BICE.SN' WHERE SecCode = 27399 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'FWDI', RkdRIC = 'FWDI.O', RkdDisplayRIC = 'FWDI.OQ' WHERE SecCode = 28027 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 55838236362.0 WHERE SecCode = 35857 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 40589 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 53907 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'RTVGn.DE', RkdDisplayRIC = 'RTVGn.DE', RkdExchCode = 'ETR' WHERE SecCode = 59071 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21665411080.0 WHERE SecCode = 59657 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 75019 AND Type_ = 10;
UPDATE data_universe SET Name = 'SAMPRE NUTRITIONS INR5 (POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 78616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79806 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL WHERE SecCode = 79883 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG2153W1116', RkdSEDOL = 'BSMLL2', RkdCUSIP = 'G2153W11', DsPrimQtSedol = 'BSMLL25' WHERE SecCode = 83979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMPLITUDE ENERGY NPV DFD 19/11/25 (EX-SPLIT)' WHERE SecCode = 86668 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86798 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232908273981.0, IsPrimaryInstr = 0.0 WHERE SecCode = 87006 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG2124R1184', RkdSEDOL = 'BSML7R', RkdCUSIP = 'G2124R11', DsPrimQtSedol = 'BSML7R2' WHERE SecCode = 89680 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'RICH CAPITAL HOLDI NPV (POST SPLT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 89861 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CCE', RkdRIC = 'CCE.V', RkdDisplayRIC = 'CCE.V' WHERE SecCode = 92563 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-14', PermQuoteRetireDate = '2025-11-14', PermSecMapEndDate = '2025-11-14', endDate = '2025-11-14' WHERE SecCode = 93742 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'MKHZN', PermIDTicker = 'MKHZN', RkdRIC = 'MKHZN.KW', RkdDisplayRIC = 'MKHZN.KW' WHERE SecCode = 97439 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-16' WHERE SecCode = 97819 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257745.0, ExchCode = 'BTE' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232908273981.0, IsPrimaryInstr = 0.0 WHERE SecCode = 105303 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 119138 AND Type_ = 10;
UPDATE data_universe SET Name = 'WEBSOL ENERGY SYST INR1 (POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 126910 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE363L01045', RkdSEDOL = 'BVBCMH', RkdCUSIP = 'Y8344X15', DsPrimQtSedol = 'BVBCMH2', PermSecMapEndDate = '2025-11-14', endDate = '2025-11-14' WHERE SecCode = 135123 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 146814 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMA GROUP LIMITED NPV' WHERE SecCode = 161050 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEXTURN & ROLLKORE KRW2500' WHERE SecCode = 174546 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 269427 AND Type_ = 10;
UPDATE data_universe SET Name = 'ELEMENTAL RTY CORP COM NEW', PermSecMapEndDate = '2025-11-14', endDate = '2025-11-14' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 381482 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395061 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474956325.0 WHERE SecCode = 507255 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BICE' WHERE SecCode = 522545 AND Type_ = 10;
UPDATE data_universe SET Name = 'ZCZL INDL TECH GRO ''A''CNY1' WHERE SecCode = 772788 AND Type_ = 10;
UPDATE data_universe SET Name = 'UBS FUND MANAGEMEN UBS (CH) PROP FD - DIRT GRN' WHERE SecCode = 935925 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BSML7R2' WHERE SecCode = 1152379 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 1441935 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 PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 1718056 AND Type_ = 10;
UPDATE data_universe SET Name = 'ZCZL INDL TECH GRO ''H''CNY1' WHERE SecCode = 1941970 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 2253409 AND Type_ = 10;
UPDATE data_universe SET Name = 'ENEGEX LTD NPV' WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2465108 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'QHE', Name = 'QUANTUM HELIUM LTD ORD NPV (DI)' WHERE SecCode = 2528745 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-11-13' WHERE SecCode = 2745149 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-11-13' WHERE SecCode = 2836275 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 3247374 AND Type_ = 10;
UPDATE data_universe SET Name = 'SEVEN ELEMENTS INV HKD0.002' WHERE SecCode = 3304634 AND Type_ = 10;
UPDATE data_universe SET Name = 'BHAKTI GEMS AND JE INR10' WHERE SecCode = 3356357 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21655845782.0 WHERE SecCode = 3435757 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951319.0 WHERE SecCode = 3527769 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 3765600 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3921297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 4041258 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951871.0 WHERE SecCode = 4041274 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951253.0 WHERE SecCode = 4101081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4349879 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 4355912 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-11-14' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 4534816 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 4540765 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232903436643.0, IsPrimaryInstr = 0.0, PermOrgIPODate = '2025-11-14' WHERE SecCode = 4597210 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q3369K15' WHERE SecCode = 4746930 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21865296667.0, ExchCode = 'BTE', PermQuoteRetireDate = '2025-06-02' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236798868249.0 WHERE SecCode = 5072191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5230201 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SEAPT', QuotePermID = 21951566813.0, IsPrimaryQuote = 1.0, PermQuoteStatus = 'DC', ExchCode = 'OSL', PermQuoteRetireDate = '2025-11-06' WHERE SecCode = 5346555 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 5546614 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 5907899 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6043234 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-11-13' WHERE SecCode = 6058661 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6467509 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000418782', RkdTicker = 'NXN', RkdSEDOL = 'BVTBD1', RkdCUSIP = 'Q6751810', RkdRIC = 'NXN.AX', RkdDisplayRIC = 'NXN.AX', RkdCode = 143492.0, RkdIssueID = 1.0, RkdIssueCode = 183200.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6501036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000420002', RkdTicker = 'DSM', RkdSEDOL = 'BVSYJQ', RkdCUSIP = 'Q3179310', RkdRIC = 'DSM.AX', RkdDisplayRIC = 'DSM.AX', RkdCode = 138548.0, RkdIssueID = 1.0, RkdIssueCode = 176439.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6513038 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6551070 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-11-14', PermSecMapEndDate = '2025-11-14' WHERE SecCode = 10778640 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 10965391 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 11005290 AND Type_ = 1;
UPDATE data_universe SET Name = 'VAL-D OR MNG CORP COM' WHERE SecCode = 11006191 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 11133656 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'SENS.O', RkdDisplayRIC = 'SENS.OQ', RkdExchCode = 'NASD', ExchCode = 'NSM' WHERE SecCode = 11145550 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11160338 AND Type_ = 1;
UPDATE data_universe SET Name = 'CYPHERPUNK TECHNOLOGIES INC COM NEW' WHERE SecCode = 11166914 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG1820C1024', RkdCUSIP = 'G1820C10', DsTypeCode = 'EQ', RkdListingType = 'EDR', QuoteClass = 'ORD', InstrClass = 'ORD' WHERE SecCode = 11188238 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA00783T1093', RkdTicker = 'QESS', RkdCUSIP = '00783T10', RkdRIC = 'QESS.CD', RkdDisplayRIC = 'QESS.CD', SecMapEndDate = '2025-11-14', endDate = '2025-11-14' WHERE SecCode = 11189388 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2019-02-11', startDate = '2019-02-11' WHERE SecCode = 11194108 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 11199686 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 1.0, startDate = '2015-10-29' WHERE SecCode = 11205692 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 11213560 AND Type_ = 1;
UPDATE data_universe SET Name = 'LEVIATHAN METALS CORP COM NEW', PermSecMapEndDate = '2025-11-14', endDate = '2025-11-14' WHERE SecCode = 11219153 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 11220875 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'SVRN', RkdRIC = 'SVRN.O', RkdDisplayRIC = 'SVRN.OQ' WHERE SecCode = 11234372 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11243910 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11270517 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-11-14', PermSecMapEndDate = '2025-11-14' WHERE SecCode = 11274512 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG309051145', RkdCUSIP = 'G3090511' WHERE SecCode = 11275065 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798830200.0, ExchCode = 'NAS', PermSecMapStartDate = '2025-11-13' WHERE SecCode = 11279080 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798769646.0, ExchCode = 'NYS', PermSecMapStartDate = '2025-11-12' WHERE SecCode = 11287712 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798769513.0, ExchCode = 'NSM', PermSecMapStartDate = '2025-11-12' WHERE SecCode = 11287918 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 1.0, RkdListingType = 'OSR', QuotePermID = 236798769471.0, IsPrimaryQuote = 1.0, ExchCode = 'NYS' WHERE SecCode = 11288143 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALUB.U', ModelCntry = 'US', QuotePermID = 236798747659.0, InstrPermID = 232905383456.0, OrgPermID = 5096938619.0, PriTrdQuotePermID = 236798747659.0, PriValQuotePermID = 25727047033.0, PriInstrPermID = 232905383456.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2025-11-13', PermSecMapStartDate = '2025-11-11', startDate = '2025-11-11' WHERE SecCode = 11288167 AND Type_ = 1;
