UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, PermIDTicker = 'CCO', RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueCode = NULL, RelType = NULL, QuotePermID = 55838805142.0, ExchCode = 'TOR', PermSecMapStartDate = '1991-07-08' WHERE SecCode = 11920 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'DRH.O', RkdDisplayRIC = 'DRH.OQ', RkdExchCode = 'NASD' WHERE SecCode = 19752 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 37033 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 37133 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 55846120871.0, ExchCode = 'CPH', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836324566.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605378798.0, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-01' WHERE SecCode = 64069 AND Type_ = 10;
UPDATE data_universe SET Name = 'VENARI MINERALS NL NPV DFD 03/12/25(EX-SPLT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 68866 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL, RelType = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = 55838857866.0 WHERE SecCode = 74703 AND Type_ = 1;
UPDATE data_universe SET Name = 'ALPHA AI CO LTD KRW500' WHERE SecCode = 77356 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 79735 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 81672 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000427973', RkdTicker = 'RC1DC', PermIDTicker = 'RC1DC', RkdSEDOL = 'BNRNFV', RkdRIC = 'RC1DC.AX', RkdDisplayRIC = 'RC1DC.AX', DsPrimQtSedol = 'BNRNFV8', SecMapEndDate = '2025-11-27', endDate = '2025-11-27' WHERE SecCode = 89085 AND Type_ = 10;
UPDATE data_universe SET Name = 'GOLD STRATEGY INC COM', PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 96753 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 97980 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BPPDD', DsPrimQtSedol = 'BW9MHH6' WHERE SecCode = 98789 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 99970 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU0000436891', RkdTicker = 'USC', PermIDTicker = 'USC', RkdSEDOL = 'BNRNMC', RkdRIC = 'USC.AX', RkdDisplayRIC = 'USC.AX', DsPrimQtSedol = 'BNRNMC8', SecMapEndDate = '2025-11-27', endDate = '2025-11-27' WHERE SecCode = 143532 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236799474665.0 WHERE SecCode = 145481 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q1626N26', Name = 'BLUGLASS LIMITED NPV DFD 01/12/25 (EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 164663 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000432056', RkdTicker = 'CAVDA', PermIDTicker = 'CAVDA', RkdSEDOL = 'BQB3NB', RkdRIC = 'CAVDA.AX', RkdDisplayRIC = 'CAVDA.AX', DsPrimQtSedol = 'BQB3NB1' WHERE SecCode = 195229 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-21', SecMapEndDate = '2025-11-20', PermSecMapEndDate = '2025-11-28', endDate = '2025-11-20' WHERE SecCode = 196442 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA7242551041', RkdTicker = 'YARR', RkdCUSIP = '72425510', RkdRIC = 'YARR.V', RkdDisplayRIC = 'YARR.V', DsPrimQtSedol = 'BNDY667' WHERE SecCode = 238622 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'LE TREE HLDGS LTD NPV' WHERE SecCode = 366352 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 427216 AND Type_ = 10;
UPDATE data_universe SET Name = 'ETIHAD GO TELECOM SAR10' WHERE SecCode = 490279 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 539286 AND Type_ = 10;
UPDATE data_universe SET Name = 'G11 RESOURCES LTD NPV DFD 02/12//25(EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 683072 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000430183', RkdTicker = 'NETDB', PermIDTicker = 'NETDB', RkdSEDOL = 'BVLCQ9', RkdRIC = 'NETDB.AX', RkdDisplayRIC = 'NETDB.AX', DsPrimQtSedol = 'BVLCQ92', SecMapEndDate = '2025-11-27', endDate = '2025-11-27' WHERE SecCode = 822496 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000437493', RkdTicker = 'AHE', PermIDTicker = 'AHE', RkdSEDOL = 'BNRNM8', RkdRIC = 'AHE.AX', RkdDisplayRIC = 'AHE.AX', DsPrimQtSedol = 'BNRNM84', SecMapEndDate = '2025-11-27', endDate = '2025-11-27' WHERE SecCode = 1153566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1158940 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000436933', RkdTicker = 'OR3', PermIDTicker = 'OR3', RkdSEDOL = 'BNRNMF', RkdRIC = 'OR3.AX', RkdDisplayRIC = 'OR3.AX', DsPrimQtSedol = 'BNRNMF1' WHERE SecCode = 1232910 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RC1DC', DsPrimQtSedol = 'BNRNFV8' WHERE SecCode = 1245949 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BPPDD', DsPrimQtSedol = 'BW9MHH6' WHERE SecCode = 1296216 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 1552936 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GI000A41V1Y7', RkdSEDOL = 'BSSBXC', RkdCUSIP = 'X980C414', DsPrimQtSedol = 'BSSBXC3' WHERE SecCode = 1625573 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NETDB', DsPrimQtSedol = 'BVLCQ92' WHERE SecCode = 1668753 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'QDC', PermIDTicker = 'QDC', RkdRIC = 'QDCm.BK', RkdDisplayRIC = 'QDCm.BK' WHERE SecCode = 1685821 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'QDC-R' WHERE SecCode = 1686506 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5037933183.0, IsPrimaryInstr = 1.0, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1966088 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2586474 AND Type_ = 10;
UPDATE data_universe SET Name = 'UNISON METALS LTD INR1(POST SUB)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2627626 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NETDB', DsPrimQtSedol = 'BVLCQ92' WHERE SecCode = 2637937 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RC1DC', DsPrimQtSedol = 'BNRNFV8' WHERE SecCode = 2653605 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5071491626.0, IsPrimaryInstr = 0.0, OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = NULL WHERE SecCode = 2685352 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'PRO', PermIDTicker = 'PRO', RkdRIC = 'PROB.L', RkdDisplayRIC = 'PROB.L' WHERE SecCode = 2804047 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISIONFLEX GROUP L NPV DFD 05/12/25(EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2911255 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BPPDD', DsPrimQtSedol = 'BW9MHH6' WHERE SecCode = 2916713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2963471 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097036246.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3255571 AND Type_ = 10;
UPDATE data_universe SET Name = 'REBOOST BLOCKCHAIN EUR0.01' WHERE SecCode = 3275891 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951684.0 WHERE SecCode = 3288611 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BMHXS5', RkdRIC = 'DEC', RkdDisplayRIC = 'DEC.N', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 3302642 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 3321433 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BPPDD', DsPrimQtSedol = 'BW9MHH6' WHERE SecCode = 3403999 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-01' WHERE SecCode = 3441651 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097025700.0, OrgTypeCode = 'CINV', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3520029 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000427650', RkdTicker = 'BPPDD', PermIDTicker = 'BPPDD', RkdSEDOL = 'BW9MHH', RkdRIC = 'BPPDD.AX', RkdDisplayRIC = 'BPPDD.AX', DsPrimQtSedol = 'BW9MHH6', SecMapEndDate = '2025-11-27', endDate = '2025-11-27' WHERE SecCode = 3587065 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AHE', DsPrimQtSedol = 'BNRNM84' WHERE SecCode = 4030518 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097034274.0, PriInstrPermID = 25727350621.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = NULL WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe SET Name = 'BRAVA ENERGIA SA COMMON SHS NPV' WHERE SecCode = 4409979 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4423824 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'USC', DsPrimQtSedol = 'BNRNMC8' WHERE SecCode = 4426887 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-11-28' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4557739 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000429615', RkdTicker = 'EPXDA', PermIDTicker = 'EPXDA', RkdSEDOL = 'BQ3QCC', RkdRIC = 'EPXDA.AX', RkdDisplayRIC = 'EPXDA.AX', DsPrimQtSedol = 'BQ3QCC2' WHERE SecCode = 4592044 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0026821852', RkdSEDOL = 'BVQZFX', RkdCUSIP = 'W2R94220', DsPrimQtSedol = 'BVQZFX3' WHERE SecCode = 4627925 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RC1DC', DsPrimQtSedol = 'BNRNFV8' WHERE SecCode = 4749891 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 4798499 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 4914668 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 5072191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5147773 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 5376812 AND Type_ = 10;
UPDATE data_universe SET Name = 'EVERGOLD MINERALS NPV' WHERE SecCode = 5391266 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000437634', RkdTicker = 'TSK', PermIDTicker = 'TSK', RkdSEDOL = 'BSHS3F', RkdRIC = 'TSK.AX', RkdDisplayRIC = 'TSK.AX', DsPrimQtSedol = 'BSHS3F8', PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 5455244 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNTY5X1' WHERE SecCode = 5487914 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5807642 AND Type_ = 10;
UPDATE data_universe SET Name = 'GIMIC CO LTD NPV' WHERE SecCode = 6054084 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6465197 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0, startDate = '2014-06-25' WHERE SecCode = 6562448 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6567900 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6572062 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6575274 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10924415 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9630257882', RkdCUSIP = '96302578' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US60855D4088', RkdCUSIP = '60855D40' WHERE SecCode = 11156578 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'CLSD.OQ' WHERE SecCode = 11156633 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'GRDX', RkdRIC = 'GRDX.O', RkdDisplayRIC = 'GRDX.OQ' WHERE SecCode = 11161215 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5223X1676', RkdCUSIP = 'G5223X16' WHERE SecCode = 11178865 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET Name = 'CUSHMAN AND WAKEFIELD LTD COMMON SHARES', Country = 'BMU' WHERE SecCode = 11188494 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA38940L3048', RkdCUSIP = '38940L30', DsPrimQtSedol = 'BNDY4L8' WHERE SecCode = 11211075 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-28' WHERE SecCode = 11214005 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG0544E4022', RkdCUSIP = 'G0544E40' WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2023-10-23' WHERE SecCode = 11259083 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MRP_w' WHERE SecCode = 11274664 AND Type_ = 1;
UPDATE data_universe SET Name = 'INTURAI VENTURES CORP COM SHS', PriTRBCIndPermID = 4294951211.0, PermSecMapEndDate = '2025-11-28', endDate = '2025-11-28' WHERE SecCode = 11278117 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BNDY4N0', PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 11282244 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA2971901004', RkdTicker = 'ESXR', RkdSEDOL = 'BTMNSL', RkdCUSIP = '29719010', RkdRIC = 'ESXR.V', RkdDisplayRIC = 'ESXR.V', RkdCode = 143589.0, RkdIssueID = 1.0, RkdIssueCode = 183335.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11287172 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BN.PF.M', QuotePermID = 236799306743.0, InstrPermID = 232908949727.0, OrgPermID = 4295861073.0, PriValQuotePermID = 236799306743.0, PriInstrPermID = 8590936126.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'CUM', InstrClass = 'CUM', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '1997-08-11', PermSecMapStartDate = '2025-11-25', startDate = '2025-11-25' WHERE SecCode = 11288672 AND Type_ = 1;