UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SONN.OQ^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-03', SecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 13481 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 15817 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 30119 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 30493 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 30962 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 31342 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NORTH ATLANTIC ENE EUR7.65' WHERE SecCode = 39192 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836451588.0, ExchCode = 'FRA', PermQuoteRetireDate = '2015-03-20' WHERE SecCode = 39278 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NRDF.CO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-03', SecMapEndDate = '2025-12-02', PermQuoteRetireDate = '2025-12-03', PermSecMapEndDate = '2025-12-03', endDate = '2025-12-02' WHERE SecCode = 44351 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5087301461.0, PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 50366 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NDASEs', QuotePermID = 21617880508.0, ExchCode = 'EBT', PermQuoteRetireDate = '2018-11-28', endDate = '2018-11-28' WHERE SecCode = 54237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 55790 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BTBA.I', QuotePermID = 21475514359.0, ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 59414 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 PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 61699 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000429920', RkdTicker = 'IXRDB', PermIDTicker = 'IXRDB', RkdSEDOL = 'BVLCNR', RkdRIC = 'IXRDB.AX', RkdDisplayRIC = 'IXRDB.AX', DsPrimQtSedol = 'BVLCNR9', SecMapEndDate = '2025-12-01', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-01' WHERE SecCode = 74451 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q8352517', Name = 'SENETAS CORP NPV DFD 08/12/25 (EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 77000 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78134 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GALADA PWR & TELEC INR10 (POST SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 78324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GRIV0RG', QuotePermID = 55838823916.0, ExchCode = 'JKT', PermQuoteRetireDate = '2007-05-02' WHERE SecCode = 80954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81556 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2015-03-31' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-19' WHERE SecCode = 82207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82762 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 83390 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236799609250.0 WHERE SecCode = 84727 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 87854 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'D.S. KULKARNI DEVE INR10(POST SPLT)' WHERE SecCode = 88310 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838797189.0, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 93179 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 100359 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueType = 'EQU' WHERE SecCode = 100361 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'Q9021B21', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 105149 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q6059820', Name = 'METGASCO LIMITED NPV DFD 08/12/25(EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 124896 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MINI DIAMONDS (IND INR2(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 136523 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'IMPE.SI^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-03', SecMapEndDate = '2023-06-20', PermQuoteRetireDate = '2025-12-03', PermSecMapEndDate = '2025-12-02', endDate = '2023-06-20' WHERE SecCode = 143175 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000AVL6', RkdTicker = 'AVL', PermIDTicker = 'AVL', RkdSEDOL = 'BZ4SXB', RkdCUSIP = 'Q1125T17', RkdRIC = 'AVL.AX', RkdDisplayRIC = 'AVL.AX', DsPrimQtSedol = 'BZ4SXB6' WHERE SecCode = 143868 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TSG DEVELOPMENT CO TWD10' WHERE SecCode = 162903 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q8S48T15', Name = 'RBR GROUP LTD NPV DFD 08/12/25(EX-SPLT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 189956 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, SecMapStartDate = '2007-01-29', SecMapEndDate = '2025-11-27', startDate = '2007-01-29', endDate = '2025-11-27' WHERE SecCode = 195229 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'INVESTIGATOR SILVE NPV' WHERE SecCode = 209045 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 238622 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU0000430233', RkdTicker = 'CNJDG', PermIDTicker = 'CNJDG', RkdSEDOL = 'BMD006', RkdRIC = 'CNJDG.AX', RkdDisplayRIC = 'CNJDG.AX', DsPrimQtSedol = 'BMD0066', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 297622 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 351431 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 439771 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CESCEPC1', RkdRIC = 'CESCEPC1.LM', RkdDisplayRIC = 'CESCEPC1.LM' WHERE SecCode = 519134 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 519723 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 520257 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 557914 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000309841', RkdTicker = 'G11', PermIDTicker = 'G11', RkdSEDOL = 'BNKT8H', RkdCUSIP = 'Q7036R11', RkdRIC = 'G11.AX', RkdDisplayRIC = 'G11.AX', DsPrimQtSedol = 'BNKT8H0' WHERE SecCode = 683072 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 771390 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-12-01', SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2025-12-01', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1153566 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 = 1470576 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'IXRDB', DsPrimQtSedol = 'BVLCNR9' WHERE SecCode = 1476274 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q7S24721', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1528086 AND Type_ = 10;
UPDATE data_universe SET Name = 'EDITEL SA PLN1.00' WHERE SecCode = 1552936 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2228078 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 2260558 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 2283957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2578862 AND Type_ = 10;
UPDATE data_universe SET Name = 'GRAMEVA LTD INR10' WHERE SecCode = 2884678 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21568326330.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08', endDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21614525595.0, ExchCode = 'TDG' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212168 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3217959 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BOD.AX^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-02', SecMapEndDate = '2023-11-27', PermQuoteRetireDate = '2025-12-02', PermSecMapEndDate = '2025-12-02', endDate = '2023-11-27' WHERE SecCode = 3259339 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 3284987 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3318171 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SHLF.OL^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-03', SecMapEndDate = '2025-12-02', PermQuoteRetireDate = '2025-12-03', PermSecMapEndDate = '2025-12-03', endDate = '2025-12-02' WHERE SecCode = 3345530 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3348751 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-03', SecMapEndDate = '2025-10-28', endDate = '2025-10-28' WHERE SecCode = 3387586 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000440042', RkdTicker = 'ABR', PermIDTicker = 'ABR', RkdSEDOL = 'BTGTLT', RkdRIC = 'ABR.AX', RkdDisplayRIC = 'ABR.AX', DsPrimQtSedol = 'BTGTLT9', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 3397149 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470979.0, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3444335 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG6118R1332', RkdSEDOL = 'BNRNDW', RkdCUSIP = 'G6118R13', DsPrimQtSedol = 'BNRNDW5' WHERE SecCode = 3550499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3619075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3641197 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KARNOV GROUP AB SER''A''NPV' WHERE SecCode = 3812223 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4066102 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-02', SecMapEndDate = '2025-11-25', PermQuoteRetireDate = '2025-12-01', PermSecMapEndDate = '2025-12-02', endDate = '2025-11-25' WHERE SecCode = 4077672 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4204830 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 4211729 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4242186 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4337006 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4359804 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4363588 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4363589 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-12-02' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-03', SecMapEndDate = '2025-10-20', PermQuoteRetireDate = '2025-12-03', PermSecMapEndDate = '2025-12-03', endDate = '2025-10-20' WHERE SecCode = 4533308 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4588291 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q3556K17', Name = 'EPX LTD NPV DFD 09/12/25(EX-SPLT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4592044 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BRARNDACNOR6', RkdTicker = 'ARND3', RkdRIC = 'ARND3.SA', RkdDisplayRIC = 'ARND3.SA' WHERE SecCode = 4598557 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-12-02' WHERE SecCode = 4608566 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 4645346 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4724713 AND Type_ = 10;
UPDATE data_universe SET Name = 'EMINENCE MINERALS NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4738014 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000439838', RkdTicker = 'MEX', PermIDTicker = 'MEX', RkdSEDOL = 'BTGTPB', RkdRIC = 'MEX.AX', RkdDisplayRIC = 'MEX.AX', DsPrimQtSedol = 'BTGTPB9', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 5028086 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNRM4F2', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SCOIN.OL^L25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-12-03', PermSecMapEndDate = '2025-12-03', endDate = '2025-12-03' WHERE SecCode = 5045206 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727194318.0, PriValQuotePermID = 25727194318.0, ExchCode = 'MEX' WHERE SecCode = 5078429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5146920 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5156823 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SDNS.OL^L25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-12-03', PermSecMapEndDate = '2025-12-03', endDate = '2025-12-03' WHERE SecCode = 5195338 AND Type_ = 10;
UPDATE data_universe SET Name = 'ENERGEIA AS NOK2.5', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5272152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5283625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5411323 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5446069 AND Type_ = 10;
UPDATE data_universe SET Name = 'PIONEER MINERALS L NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5539507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5623997 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 5632180 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 5870946 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000059461', RkdTicker = 'VLL2A', RkdSEDOL = 'BTFZP1', RkdCUSIP = 'Y9382G12', RkdRIC = 'VLL2A.PS', RkdDisplayRIC = 'VLL2A.PS', RkdCode = 65287.0, RkdIssueID = 3.0, RkdIssueCode = 183385.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'PSE', RkdExchCtry = 'PHL', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 5944914 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000059479', RkdTicker = 'VLL2B', RkdSEDOL = 'BTFZP2', RkdCUSIP = 'Y9382G11', RkdRIC = 'VLL2B.PS', RkdDisplayRIC = 'VLL2B.PS', RkdCode = 65287.0, RkdIssueID = 4.0, RkdIssueCode = 183386.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 3.0, RkdExchCode = 'PSE', RkdExchCtry = 'PHL', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 5944915 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-03', endDate = '2025-12-03' WHERE SecCode = 6177632 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-03', SecMapEndDate = '2025-12-02', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 6522470 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6564751 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 18068889405.0 WHERE SecCode = 6564893 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6569465 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236799611253.0 WHERE SecCode = 6571970 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6575268 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLACK HORSE MINING NPV' WHERE SecCode = 6578038 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000432239', RkdTicker = 'EPI', RkdSEDOL = 'BS8952', RkdCUSIP = 'Q3549310', RkdRIC = 'EPI.AX', RkdDisplayRIC = 'EPI.AX', RkdCode = 143608.0, RkdIssueID = 1.0, RkdIssueCode = 183375.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6578324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HMMC', Name = 'HEMLO MNG CORP COM SHS', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 10776460 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11004828 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'KES.V^L25', RkdIssueStatus = 0.0 WHERE SecCode = 11016665 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA05157N1096', RkdTicker = 'AUME', RkdSEDOL = 'BTFHS5', RkdCUSIP = '05157N10', RkdRIC = 'AUME.V', RkdDisplayRIC = 'AUME.V', DsPrimQtSedol = 'BTFHS59' WHERE SecCode = 11026187 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GOLD', DsExchMnem = 'NYS', ExchCode = 'NYS' WHERE SecCode = 11131445 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-12-01', PermQuoteRetireDate = '2025-12-02', PermSecMapEndDate = '2025-12-02', endDate = '2025-12-01' WHERE SecCode = 11147114 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-12-02', PermSecMapEndDate = '2025-12-02' WHERE SecCode = 11152414 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11156578 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5087301461.0, PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 11169439 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11177272 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11178865 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'BM', OrgPermID = 5097047966.0, DomCntry = 'BMU', IncCntry = 'BMU' WHERE SecCode = 11188494 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8693672011', RkdSEDOL = 'BTFHQP', RkdCUSIP = '86936720', DsPrimQtSedol = 'BTFHQP5' WHERE SecCode = 11190127 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11190160 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SONIF', Name = 'SONICSTRATEGY INC COM' WHERE SecCode = 11199055 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11199088 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA8469181009', RkdTicker = 'SHK.P', RkdSEDOL = 'BTFHS2', RkdCUSIP = '84691810', RkdRIC = 'SHKp.V', RkdDisplayRIC = 'SHKp.V', DsPrimQtSedol = 'BTFHS26' WHERE SecCode = 11200655 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 11210778 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 11213380 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', SecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 11255285 AND Type_ = 1;
UPDATE data_universe SET Name = 'RAFAEL HLDGS INC *W EXP 12/11/2025' WHERE SecCode = 11276891 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-05-23' WHERE SecCode = 11278535 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11286620 AND Type_ = 1;
UPDATE data_universe SET RkdCode = 143609.0, RkdIssueCode = 183376.0, COATypeCode = '' WHERE SecCode = 11286632 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11287691 AND Type_ = 1;
