UPDATE data_universe SET PermIDTicker = 'FWDI' WHERE SecCode = 28027 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AIREz', QuotePermID = 21523788483.0, IsPrimaryQuote = 0.0, ExchCode = 'BTE', PermQuoteRetireDate = '2025-11-14' WHERE SecCode = 35857 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475801368.0, ExchCode = 'SIG', PermQuoteRetireDate = '2018-10-03', endDate = '2018-10-03' WHERE SecCode = 54237 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21816912692.0, PriValQuotePermID = 21816912692.0, ExchCode = 'GER' WHERE SecCode = 59071 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21665411080.0, ExchCode = 'GER' WHERE SecCode = 59657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69150 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CMXH.BO', RkdDisplayRIC = 'CMXH.BO' WHERE SecCode = 70587 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951876.0 WHERE SecCode = 77908 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79806 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 = 'A' WHERE SecCode = 85361 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6297.T^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 85724 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92479 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CCE.V^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-05', PermQuoteRetireDate = '2025-11-05', PermSecMapEndDate = '2025-11-15', endDate = '2025-11-05' WHERE SecCode = 92563 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97012 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145473 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 186145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 269427 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395061 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 411775 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 417522 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55849326297.0 WHERE SecCode = 507255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 858263 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55870596306.0, PriValQuotePermID = 55870596306.0, IsPrimaryQuote = 1.0, ExchCode = 'MEX' WHERE SecCode = 1079810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1081881 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 1655467 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21515321658.0 WHERE SecCode = 1966088 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 1980903 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21515321658.0 WHERE SecCode = 2372684 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '8001.HK^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 2465108 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 2569968 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 2628800 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2736322 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2882471 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951453.0 WHERE SecCode = 3230620 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TKWY.AS^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 3247374 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3339794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3377103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4434318 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 4458705 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 4533297 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HUBSO.TE^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 4540765 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 4570383 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4763068 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4878707 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4969545 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MODIS', QuotePermID = 236798868249.0, ExchCode = 'NSI' WHERE SecCode = 5072191 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '442770.KQ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', PermOrgIPODate = NULL, endDate = '2025-11-17' WHERE SecCode = 5276216 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 5584112 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5859857 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236797033402.0, PriValQuotePermID = 236797033402.0, ExchCode = 'NGO', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2025-11-15', endDate = '2025-11-15' WHERE SecCode = 5996607 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6467506 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MEG.TO^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 10965391 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GP', DsCtryQtStatus = 'D', QuotePermID = 25727330147.0, PriTrdQuotePermID = 25727330147.0, PriValQuotePermID = 21557206996.0, ExchCode = 'NAS', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2020-08-28', endDate = '2025-11-17' WHERE SecCode = 11005290 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GXU.V^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11133656 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11144431 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'PVBC.OQ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11150425 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'HONE.OQ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11160338 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BPCWN1', DsPrimQtSedol = 'BPCWN10', RkdListingType = 'OSR', ShPerListing = NULL, PermSecMapEndDate = '2025-11-15', endDate = '2025-11-15' WHERE SecCode = 11188238 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BLGXLV', DsPrimQtSedol = 'BLGXLV7', PermSecMapEndDate = '2025-11-15' WHERE SecCode = 11189388 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CDXh.V^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11199686 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11210761 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097007882.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951182.0, PermOrgIPODate = '2022-01-26' WHERE SecCode = 11218017 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097007882.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951182.0, PermOrgIPODate = '2022-01-26' WHERE SecCode = 11218018 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SVRN' WHERE SecCode = 11234372 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11255021 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'BOWN.OQ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-17', PermQuoteRetireDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 11256445 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BVMNM0', DsPrimQtSedol = 'BVMNM07', PermSecMapEndDate = '2025-11-15', endDate = '2025-11-15' WHERE SecCode = 11275065 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232892820150.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11285908 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232899985506.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11287404 AND Type_ = 1;
UPDATE data_universe SET QuoteClass = 'CEF', InstrClass = 'CEF' WHERE SecCode = 11288143 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'US', Country = 'USA' WHERE SecCode = 11288145 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798897327.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11288185 AND Type_ = 1;
