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 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 PriTRBCIndPermID = 4294951577.0 WHERE SecCode = 62097 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 63770 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 69486 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 71161 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SRDX.OQ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-20', SecMapEndDate = '2025-11-18', PermQuoteRetireDate = '2025-11-20', PermSecMapEndDate = '2025-11-20', endDate = '2025-11-18' WHERE SecCode = 73587 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75796 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISION SYNERGY HLD HKD0.01 (POST CONS)' WHERE SecCode = 78018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80292 AND Type_ = 10;
UPDATE data_universe SET Name = 'VAULT MINERALS LTD NPV DFD 26/11/25 (EX-SPLIT)' WHERE SecCode = 80875 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 83158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83841 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-21', SecMapEndDate = '2025-10-29', PermQuoteRetireDate = '2025-11-21', PermSecMapEndDate = '2025-11-20', endDate = '2025-10-29' WHERE SecCode = 84036 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 85087 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87733 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PACIFIC RES LTD NPV' WHERE SecCode = 89212 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA7800171091', RkdTicker = 'RM', PermIDTicker = 'RM', RkdSEDOL = 'BVPJDG', RkdCUSIP = '78001710', RkdRIC = 'RM.CD', RkdDisplayRIC = 'RM.CD', DsPrimQtSedol = 'BVPJDG5' WHERE SecCode = 94193 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-21', endDate = '2025-11-21' WHERE SecCode = 95971 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET Name = 'TALI DIGITAL LTD NPV DFD 24/11/25(EX-SPLT)' WHERE SecCode = 115415 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 116978 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 136731 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BMFX8L4' WHERE SecCode = 146398 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIVFEX BHD NPV' WHERE SecCode = 147184 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 180539 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVPJ9W3' WHERE SecCode = 340288 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-21', SecMapEndDate = '2025-07-01', PermQuoteRetireDate = '2025-11-21', endDate = '2025-07-01' WHERE SecCode = 381551 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 400273 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 411498 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 728041 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 734657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 736972 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 DsCtryQtStatus = 'A' WHERE SecCode = 1534927 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTVK6Z8', PermSecMapEndDate = '2025-11-20', endDate = '2025-11-20' WHERE SecCode = 1685821 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2200264 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2201231 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 2722935 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-21', SecMapEndDate = '2025-11-20', PermSecMapEndDate = '2025-11-20', endDate = '2025-11-20' WHERE SecCode = 2739713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2800413 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951254.0 WHERE SecCode = 2998970 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TKWYa', QuotePermID = 21596783867.0, PriValQuotePermID = NULL, IsPrimaryQuote = 0.0, ExchCode = 'CHI' WHERE SecCode = 3247374 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 3247406 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3341120 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 DsCtryQtStatus = 'S' WHERE SecCode = 3518212 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ENP', DsPrimQtSedol = 'BVQZG07', SecMapEndDate = '2025-11-19', PermSecMapEndDate = '2025-11-20', endDate = '2025-11-19' WHERE SecCode = 3703404 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3719721 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3894833 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3899684 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3954652 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4010770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4066102 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SUBGEN' WHERE SecCode = 4277580 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4339149 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 4348233 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365618.0 WHERE SecCode = 4369890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4396351 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4396359 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4441403 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-11-20' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 4597210 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EMS', DsPrimQtSedol = 'BLGT1G0', PermSecMapStartDate = '2025-11-20', PermSecMapEndDate = NULL, startDate = '2021-10-25', endDate = NULL WHERE SecCode = 4746930 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4850948 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4878707 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5112406 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5323657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5411323 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLACK BEAR MINERAL NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5496146 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'KLS' WHERE SecCode = 5643202 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ENP', DsPrimQtSedol = 'BVQZG07' WHERE SecCode = 5737047 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-21', endDate = '2025-11-21' WHERE SecCode = 5834517 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 5975862 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6240368 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236792532877.0 WHERE SecCode = 6281752 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 6363464 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6450902 AND Type_ = 10;
UPDATE data_universe SET Name = 'NYSE U.S. 100 E/W', Country = 'USA' WHERE SecCode = 6558278 AND Type_ = 10;
UPDATE data_universe SET Name = 'EURONEXT DEV EUROZONE S/CAP(TRN', Country = 'NLD' WHERE SecCode = 6558282 AND Type_ = 10;
UPDATE data_universe SET Name = 'EURONEXT DEV EUROZONE SM/CAP', Country = 'NLD' WHERE SecCode = 6558283 AND Type_ = 10;
UPDATE data_universe SET Name = 'EURONEXT DEV EUROZONE SM/CAP(TRN', Country = 'NLD', IsPrimaryQuote = 1.0 WHERE SecCode = 6558285 AND Type_ = 10;
UPDATE data_universe SET Name = 'EURONEXT DEV EUROZONE S/CAP', Country = 'NLD', IsPrimaryQuote = 1.0 WHERE SecCode = 6558286 AND Type_ = 10;
UPDATE data_universe SET Name = 'EURONEXT DEV EUROZONE S/CAP(TRG', Country = 'NLD', IsPrimaryQuote = 1.0 WHERE SecCode = 6558287 AND Type_ = 10;
UPDATE data_universe SET Name = 'NORTHERN TRUST UCI NT WLD SMLLCP LOWCRBN EQIDX', Country = 'IRL' WHERE SecCode = 6558294 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCHRODER UNIT TRST SCHRODER ACTV AST ALLOC PFO', Country = 'LUX' WHERE SecCode = 6558295 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTTRQ17' WHERE SecCode = 10924405 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVPJCW4' WHERE SecCode = 10982696 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVPJ8Q0' WHERE SecCode = 11062007 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'OSG', PermIDTicker = 'OSG', RkdRIC = 'OSG', RkdDisplayRIC = 'OSG.N' WHERE SecCode = 11074267 AND Type_ = 1;
UPDATE data_universe SET Name = 'USA TODAY CO INC COM' WHERE SecCode = 11128102 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET Name = 'GCM GROSVENOR INC *W EXP 11/17/2025' WHERE SecCode = 11193809 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097026333.0, PriTRBCIndPermID = 4294951296.0 WHERE SecCode = 11199686 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-21', SecMapEndDate = '2025-10-29', endDate = '2025-10-29' WHERE SecCode = 11203034 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVPJ8P9' WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVMNM30' WHERE SecCode = 11222087 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA70662P2052', RkdTicker = 'EVI', PermIDTicker = 'EVI', RkdSEDOL = 'BTTS42', RkdCUSIP = '70662P20', RkdRIC = 'EVI.V', RkdDisplayRIC = 'EVI.V', Name = 'PENBAR CAPITAL LTD COM NEW', DsPrimQtSedol = 'BTTS427' WHERE SecCode = 11237647 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-21', endDate = '2025-11-21' WHERE SecCode = 11241681 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA65704Y1079', RkdSEDOL = 'BSNY04', RkdCUSIP = '65704Y10', Name = 'NORTH AMERN NIOBIUM COM SHS' WHERE SecCode = 11249876 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11262650 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11264266 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVPJ8R1' WHERE SecCode = 11267636 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 11270869 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL WHERE SecCode = 11274491 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232892829165.0 WHERE SecCode = 11286100 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-10-30', startDate = '2025-10-30' WHERE SecCode = 11286859 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11287151 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11287515 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232906104965.0 WHERE SecCode = 11287596 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11288185 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236799045912.0, PriTrdQuotePermID = 236799045912.0, PriValQuotePermID = 25727045599.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NSM' WHERE SecCode = 11288401 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALIS', ModelCntry = 'US', QuotePermID = 236799018940.0, InstrPermID = 232849449997.0, OrgPermID = 5088440971.0, PriTrdQuotePermID = 236799018940.0, PriValQuotePermID = 25727045793.0, PriInstrPermID = 232849449997.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2025-10-22', PermSecMapStartDate = '2025-11-18', startDate = '2025-10-22' WHERE SecCode = 11288430 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236799045884.0, PriTrdQuotePermID = 236799045884.0, PriValQuotePermID = 25727045640.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS', startDate = '2025-10-30' WHERE SecCode = 11288432 AND Type_ = 1;
