UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-11' WHERE SecCode = 39355 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 52476 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 QuotePermID = 21589872687.0, ExchCode = 'STU' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 66960 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'UNIW.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 71410 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 74203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75879 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77859 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 78701 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GRIVRG', QuotePermID = 21475431561.0, ExchCode = 'SUB', PermQuoteRetireDate = '2007-01-11' WHERE SecCode = 80954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 83169 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '010620.KS^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', PermOrgIPODate = NULL, endDate = '2025-12-15' WHERE SecCode = 84049 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 99410 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 116621 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126880 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 136728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138752 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838243234.0, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-17', PermSecMapEndDate = NULL, endDate = '2023-03-17' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 320875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 321245 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'VXTR.V^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 321644 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 322233 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SOL.N^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 336580 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 526292 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 526293 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 702419 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2038603 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ECOF.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2039528 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CHAE.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2173107 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HPBC.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2194153 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'EDYN.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2283948 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'INTM.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2412426 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2455559 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GDLN.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2551346 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 2830722 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 RkdRIC = 'CONR.BO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 2950178 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3043691 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3064600 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3540.T^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 3177501 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TRER.OL^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 3192982 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3242487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3255084 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 3282947 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3389693 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3396657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3691618 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4588291 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4787325 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4798367 AND Type_ = 10;
UPDATE data_universe SET QuoteClass = 'DEFER', InstrClass = 'DEFER' WHERE SecCode = 4816848 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4871140 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5078443 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5102742 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5234136 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5292508 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5292509 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'T9G.DE', RkdDisplayRIC = 'T9G.DE', RkdExchCode = 'ETR', PriValQuotePermID = 236800300159.0 WHERE SecCode = 5383334 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5410102 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-16' WHERE SecCode = 5479893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5490563 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6533604 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6577917 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6577930 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6593845 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6596072 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 11162392 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG514131546', RkdSEDOL = 'BS1LKP', RkdCUSIP = 'G5141315' WHERE SecCode = 11175825 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097044883.0 WHERE SecCode = 11188853 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA1850535016', RkdSEDOL = 'BS1LKM', RkdCUSIP = '18505350', PermSecMapEndDate = '2025-12-13', endDate = '2025-12-13' WHERE SecCode = 11199053 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US67079Y4070', RkdSEDOL = 'BS1LKN', RkdCUSIP = '67079Y40', PermSecMapEndDate = '2025-12-13', endDate = '2025-12-13' WHERE SecCode = 11207414 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US98400V2007', RkdSEDOL = 'BS1LKR', RkdCUSIP = '98400V20', PermSecMapEndDate = '2025-12-13', endDate = '2025-12-13' WHERE SecCode = 11223377 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US08178Q5071', RkdSEDOL = 'BS1LKX', RkdCUSIP = '08178Q50', PermSecMapEndDate = '2025-12-13', endDate = '2025-12-13' WHERE SecCode = 11235403 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-12-13', endDate = '2025-12-13' WHERE SecCode = 11237647 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-15', endDate = '2025-12-15' WHERE SecCode = 11248072 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'BLMZF', PermIDTicker = 'BLMZF', RkdRIC = 'BLMZF.PK', RkdDisplayRIC = 'BLMZF.PK', RkdExchCode = 'OTC', QuotePermID = 25727125508.0, PriTrdQuotePermID = NULL, ExchCode = 'PNK', PermQuoteRetireDate = NULL WHERE SecCode = 11267636 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232870504678.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11286422 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232895700695.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11287201 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 1.0, RkdListingType = 'OSR' WHERE SecCode = 11288432 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2025-12-12', startDate = '2025-12-12' WHERE SecCode = 11289154 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236800272026.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11289419 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236800271988.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11289422 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236800272006.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11289423 AND Type_ = 1;
