UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 1284 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951274.0 WHERE SecCode = 1773 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 7518 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 11243 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 17419 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'USA' WHERE SecCode = 18658 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 27933 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-06' WHERE SecCode = 29931 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 30010 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DATA.L', QuotePermID = 21475534682.0, ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 31747 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837361395.0, ExchCode = 'GER' WHERE SecCode = 34242 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475405466.0, ExchCode = 'STU' WHERE SecCode = 35324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BIB', QuotePermID = 55836324256.0, ExchCode = 'BER', PermQuoteRetireDate = '2013-03-20' WHERE SecCode = 35717 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 39868 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US5913242070', RkdTicker = 'MUINQ', RkdCUSIP = '59132420', RkdRIC = 'MUSA.OQ^L05', RkdCode = 9767.0, RkdIssueID = 1.0, RkdIssueCode = 13375.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 2.0, RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'DBT', COATypeCode = 'IND' WHERE SecCode = 46437 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 47916 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, PermQuoteStatus = 'AC', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474842993.0, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02', endDate = '2010-07-02' WHERE SecCode = 48469 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 48916 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 51248 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 52953 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'naso' WHERE SecCode = 53383 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2010-06-02' WHERE SecCode = 56814 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = '566407' WHERE SecCode = 58288 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 67366 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 71523 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 71571 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 72714 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HLLC.CL^C17' WHERE SecCode = 73071 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 73302 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'YNAM.SI^L24', RkdIssueStatus = 0.0 WHERE SecCode = 73666 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 73755 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 75753 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'RABL.NS^D25', RkdIssueStatus = 0.0 WHERE SecCode = 76848 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 77357 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 78692 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 80408 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 = 81499 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 81541 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 83795 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 83831 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 83832 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 85436 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86645 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86797 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88602 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 93082 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 93656 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94982 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 98020 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'B0XZXV3' WHERE SecCode = 101146 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '6022.TWO^H17' WHERE SecCode = 114768 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 120435 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142684 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143394 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 164376 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21738226557.0, ExchCode = 'STU', PermQuoteRetireDate = '2023-02-21', endDate = '2023-02-21' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 184425 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248733.0, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 251973 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 258037 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 296181 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177730.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2019-06-19' WHERE SecCode = 333820 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 349158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395049 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 61412.0 WHERE SecCode = 411689 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 559885 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'kpmg', RkdIssueStatus = 0.0 WHERE SecCode = 703166 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 703181 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'mggd' WHERE SecCode = 703323 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 861365 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 984775 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'VRS.L^B26', RkdIssueStatus = 0.0, endDate = '2026-02-09' WHERE SecCode = 2264327 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2658229 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 2710260 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG983421275', RkdSEDOL = 'BVMD7K', RkdCUSIP = 'G9834212', DsPrimQtSedol = 'BVMD7K2' WHERE SecCode = 2753942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2831965 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2882481 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 = 3040839 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3091123 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 3206339 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 112509.0 WHERE SecCode = 3338460 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3359296 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TH8380010000' WHERE SecCode = 3410326 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '288490.KN^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-02-09', endDate = '2026-02-09' WHERE SecCode = 3671085 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3713187 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3965130 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-06', endDate = '2026-02-06' WHERE SecCode = 4036735 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'AAGN.VI^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-09', endDate = '2026-02-09' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4646580 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4850936 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5115511 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-02-06', PermSecMapEndDate = '2026-02-06' WHERE SecCode = 6095675 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ARIS' WHERE SecCode = 6339499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6478327 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-01-28' WHERE SecCode = 6629437 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6629441 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 6629614 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-05' WHERE SecCode = 6643263 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-05' WHERE SecCode = 6643264 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6643268 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645642 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645647 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645650 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645651 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11002303 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US34417J5002', RkdSEDOL = 'BS1KW8', RkdCUSIP = '34417J50', DsPrimQtSedol = 'BS1KW86' WHERE SecCode = 11138087 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11176876 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL, RkdRIC = 'VERO.PK', RkdDisplayRIC = 'VERO.PK', RkdExchCode = 'OTC', endDate = '2026-02-09' WHERE SecCode = 11177059 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US91704K3014', RkdSEDOL = 'BS1KW3', RkdCUSIP = '91704K30', DsPrimQtSedol = 'BS1KW31' WHERE SecCode = 11199427 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11210203 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BMZC81' WHERE SecCode = 11210591 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11219974 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CREVF', RkdSEDOL = NULL, RkdRIC = 'CREVF.PK', RkdDisplayRIC = 'CREVF.PK', RkdExchCode = 'OTC', endDate = '2026-02-09' WHERE SecCode = 11223114 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727255978.0 WHERE SecCode = 11225824 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-06', endDate = '2026-02-06' WHERE SecCode = 11229325 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US74319X2071', RkdSEDOL = 'BS1KW6', RkdCUSIP = '74319X20', DsPrimQtSedol = 'BS1KW64' WHERE SecCode = 11237417 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-05-08' WHERE SecCode = 11241337 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG322121131', RkdSEDOL = 'BS1KVT', DsPrimQtSedol = 'BS1KVT0' WHERE SecCode = 11277491 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'UTWO', RkdSEDOL = 'BMXGXM', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-02-07', endDate = '2026-02-07' WHERE SecCode = 11278158 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232872827345.0 WHERE SecCode = 11289560 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232893324032.0 WHERE SecCode = 11289585 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232903986374.0 WHERE SecCode = 11289589 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232910062948.0 WHERE SecCode = 11289672 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232911301199.0 WHERE SecCode = 11289673 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232902068023.0 WHERE SecCode = 11289728 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AXIA PRC' WHERE SecCode = 11290250 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 34481832842.0, ExchCode = 'NYS', PermSecMapStartDate = '2026-02-05' WHERE SecCode = 11291081 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951533.0 WHERE SecCode = 11291582 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802545316.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11291609 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802546059.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11291631 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802545185.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291635 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236802546036.0, PriValQuotePermID = 25727036511.0, IsPrimaryInstr = 1.0 WHERE SecCode = 11291636 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OFRM', QuotePermID = 236802472839.0, InstrPermID = 232904174402.0, OrgPermID = 5053681977.0, PriTrdQuotePermID = 236802472839.0, PriValQuotePermID = 25727036866.0, PriInstrPermID = 232904174402.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951428.0, PermOrgIPODate = '2026-02-06', PermSecMapStartDate = '2026-02-04', startDate = '2026-02-04' WHERE SecCode = 11291685 AND Type_ = 1;
