UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 19752 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CL0003054906', RkdSEDOL = 'BTZDWD', DsPrimQtSedol = 'BTZDWD3', DsTypeCode = 'EQ', QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 27399 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, QuoteClass = 'ORD', InstrClass = 'ORD' WHERE SecCode = 27523 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'NAE', PermIDTicker = 'NAE', RkdRIC = 'NAE.PA', RkdDisplayRIC = 'NAE.PA' WHERE SecCode = 39192 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21497273980.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-12' WHERE SecCode = 39278 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74375 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE255C01026', RkdSEDOL = 'BNRNKM', RkdCUSIP = 'Y267MT10', DsPrimQtSedol = 'BNRNKM4', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 78324 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'JAYKAY', RkdRIC = 'JKEL.NS', RkdDisplayRIC = 'JKEL.NS', RkdExchCode = 'NSE' WHERE SecCode = 84727 AND Type_ = 10;
UPDATE data_universe SET Name = 'AGENT AI CO LTD KRW1000' WHERE SecCode = 87756 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE891A01022', RkdSEDOL = 'BNRNKV', RkdCUSIP = 'Y2108E15', DsPrimQtSedol = 'BNRNKV3' WHERE SecCode = 88310 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90383 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '7732.T^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-02', SecMapEndDate = '2025-12-01', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 97575 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'J7012M10' WHERE SecCode = 105303 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 113780 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'HBI.N^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-01', SecMapEndDate = '2025-11-28', PermQuoteRetireDate = '2025-12-01', PermSecMapEndDate = '2025-12-01', endDate = '2025-11-28' WHERE SecCode = 123714 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, RkdISIN = 'JP3153140003', RkdTicker = '463A', RkdSEDOL = 'BMW5X1', RkdCUSIP = 'J2482410', RkdRIC = '463A.T', RkdDisplayRIC = '463A.T', Name = 'INTELLEX HOLDINGS NPV', RkdCode = 143363.0, RkdIssueCode = 183036.0, COATypeCode = '', QuotePermID = 236798432171.0, InstrPermID = 232906982835.0, PriValQuotePermID = 236798432171.0, PermSecMapStartDate = '2025-11-05', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 132080 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE281E01028', RkdSEDOL = 'BVPNCQ', RkdCUSIP = 'Y6065414', DsPrimQtSedol = 'BVPNCQ0', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 136523 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q402A016', Name = 'US1 CRITICAL MINER NPV', SecMapStartDate = '2025-12-01', SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2025-12-01', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 143532 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CYBERSTEP HLDGS NPV' WHERE SecCode = 146052 AND Type_ = 10;
UPDATE data_universe SET Name = 'PIRATE GOLD CORP COM' WHERE SecCode = 238622 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 309517 AND Type_ = 10;
UPDATE data_universe SET Name = 'Nomura Growth & Income Fund;A' WHERE SecCode = 332406 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, QuoteClass = 'ORD', InstrClass = 'ORD' WHERE SecCode = 522545 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 561672 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 85891.0 WHERE SecCode = 1111347 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BNG8CK', Name = 'ADHERIS HEALTH NPV', DsPrimQtSedol = 'BNG8CK2' WHERE SecCode = 1153566 AND Type_ = 10;
UPDATE data_universe SET Name = 'ORE RESOURCES LTD NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1232910 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1544263 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1617057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1623752 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1625573 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1671533 AND Type_ = 10;
UPDATE data_universe SET Name = 'QUANTUM D C PCL THB150 (LOCAL)' WHERE SecCode = 1685821 AND Type_ = 10;
UPDATE data_universe SET Name = 'QUANTUM D C PCL THB150 (NVDR)' WHERE SecCode = 1686506 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 1966088 AND Type_ = 10;
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 = 1999277 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 2574393 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2587437 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 2731218 AND Type_ = 10;
UPDATE data_universe SET Name = 'PROSERVICE BUILDIN ORD GBP0.01' WHERE SecCode = 2804047 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'BESS', PermIDTicker = 'BESS', RkdRIC = 'BESS.NGM', RkdDisplayRIC = 'BESS.NGM' WHERE SecCode = 2880969 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GRAM.BO', RkdDisplayRIC = 'GRAM.BO' WHERE SecCode = 2884678 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q7134T22' WHERE SecCode = 2911255 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21762568152.0, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07', endDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3200566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3273515 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3367944 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y793AE13' WHERE SecCode = 3396345 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 3461310 AND Type_ = 10;
UPDATE data_universe SET Name = 'AI HEALTH TECHNOLO HKD0.001' WHERE SecCode = 3550499 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MIRARTH REAL ESTAT REIT' WHERE SecCode = 3560283 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 3644455 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3894833 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNG8CK2' WHERE SecCode = 4030518 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4425519 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SWAYq.KL^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-02', SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-12-01', endDate = '2025-11-14' WHERE SecCode = 4434318 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-12-01' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000435034', RkdTicker = 'BMODA', PermIDTicker = 'BMODA', RkdSEDOL = 'BPCQXS', RkdRIC = 'BMODA.AX', RkdDisplayRIC = 'BMODA.AX', DsPrimQtSedol = 'BPCQXS9', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 4533300 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BELLB.L^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-02', SecMapEndDate = '2025-07-01', PermQuoteRetireDate = '2025-12-02', endDate = '2025-07-01' WHERE SecCode = 4608566 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4627925 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000439168', RkdTicker = 'EMA', PermIDTicker = 'EMA', RkdSEDOL = 'BSY5RF', RkdRIC = 'EMA.AX', RkdDisplayRIC = 'EMA.AX', DsPrimQtSedol = 'BSY5RF0', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 4738014 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4815193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4842772 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BNRM4F24', RkdSEDOL = 'BNRM4F' WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'P7647N10' WHERE SecCode = 5130625 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NO0013698431', RkdSEDOL = 'BVD9GD', RkdCUSIP = 'R2R8AH14', DsPrimQtSedol = 'BVD9GD5', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 5272152 AND Type_ = 10;
UPDATE data_universe SET Name = 'TUSKER MINERALS NPV', PermSecMapStartDate = '2025-12-01', PermSecMapEndDate = NULL, startDate = '2023-06-29', endDate = NULL WHERE SecCode = 5455244 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000439135', RkdTicker = 'PMM', PermIDTicker = 'PMM', RkdSEDOL = 'BSZ9LF', RkdRIC = 'PMM.AX', RkdDisplayRIC = 'PMM.AX', DsPrimQtSedol = 'BSZ9LF9', PermSecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 5539507 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'JP3244860007', RkdSEDOL = 'BN6NH9', RkdCUSIP = 'J6466B10', Name = 'QPS HOLDINGS INC NPV', RkdCode = 143362.0, RkdIssueCode = 183035.0, COATypeCode = '', QuotePermID = 236798432174.0, InstrPermID = 232906982851.0, PriValQuotePermID = 236798432174.0, PermSecMapStartDate = '2025-11-05', PermSecMapEndDate = NULL, startDate = '2023-12-06', endDate = NULL WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365459.0 WHERE SecCode = 5626262 AND Type_ = 10;
UPDATE data_universe SET Name = 'TIANJIN CONSTRUCTI NPV' WHERE SecCode = 5656167 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6456421 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LSOP11', QuotePermID = 22141665143.0, InstrPermID = 18068889405.0, OrgPermID = 5097026171.0, PriValQuotePermID = 22141665143.0, PriInstrPermID = 965453538.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'CEF', InstrClass = 'CEF', OrgTypeCode = 'CINV', DomCntry = 'BRA', IncCntry = 'BRA', PriTRBCIndPermID = 4294951317.0, PermOrgIPODate = '2025-11-19', PermSecMapStartDate = '2025-11-19', startDate = '2025-11-19' WHERE SecCode = 6564893 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 6569462 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KA1n.DE', RkdDisplayRIC = 'KA1n.DE', RkdExchCode = 'ETR' WHERE SecCode = 6571970 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6575270 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA42366G1046', RkdTicker = 'HMMC', RkdSEDOL = 'BSTM1K', RkdCUSIP = '42366G10', RkdRIC = 'HMMC.V', RkdDisplayRIC = 'HMMC.V', DsPrimQtSedol = 'BSTM1K9' WHERE SecCode = 10776460 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US4440974065', RkdSEDOL = 'BTTQTR', RkdCUSIP = '44409740', DsPrimQtSedol = 'BTTQTR1' WHERE SecCode = 10963990 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 10978674 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'GOLD', RkdRIC = 'GOLD.K', RkdDisplayRIC = 'GOLD.N', RkdExchCode = 'NYSE' WHERE SecCode = 11131445 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 11147114 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-02', endDate = '2025-12-02' WHERE SecCode = 11152414 AND Type_ = 1;
UPDATE data_universe SET Name = 'GRIDAI TECHNOLOGIES CORP COM NEW', PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11161215 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11180183 AND Type_ = 1;
UPDATE data_universe SET Name = 'LAZYDAYS HLDGS INC COM NEW' WHERE SecCode = 11183482 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BSTKW77' WHERE SecCode = 11187884 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11190160 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA83546W1068', RkdTicker = 'SONI', RkdSEDOL = 'BSTKR9', RkdCUSIP = '83546W10', RkdRIC = 'SONI.CD', RkdDisplayRIC = 'SONI.CD', DsPrimQtSedol = 'BSTKR94' WHERE SecCode = 11199055 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'SGD.TO', RkdDisplayRIC = 'SGD.TO', RkdExchCode = 'TSE' WHERE SecCode = 11199088 AND Type_ = 1;
UPDATE data_universe SET Name = 'GRAYCLIFF EXPL LTD COM NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11211075 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'MOOO.X', RkdRIC = 'MOOOx.CD', RkdDisplayRIC = 'MOOOx.CD' WHERE SecCode = 11245786 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG837611170', RkdSEDOL = 'BVPNH4', RkdCUSIP = 'G8376111', DsPrimQtSedol = 'BVPNH43' WHERE SecCode = 11270654 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8802452040', RkdSEDOL = 'BSTKWT', RkdCUSIP = '88024520', DsPrimQtSedol = 'BSTKWT9' WHERE SecCode = 11274891 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11278117 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'BNK' WHERE SecCode = 11281578 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'MHY1250N2066', RkdSEDOL = 'BNRNL9', RkdCUSIP = 'Y1250N20', DsPrimQtSedol = 'BNRNL98' WHERE SecCode = 11281757 AND Type_ = 1;
UPDATE data_universe SET Name = 'UNITED CRITICAL MINERALS COR COM', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11282244 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285907 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11287172 AND Type_ = 1;
