UPDATE data_universe SET PermIDTicker = 'FVA' WHERE SecCode = 2412 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5027 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 9563 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-10-13' WHERE SecCode = 10093 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 29519 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 29651 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 33376 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 35482 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 36439 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US5381463091', RkdSEDOL = 'BVBQPK', RkdCUSIP = '53814630', DsPrimQtSedol = 'BVBQPK8', PermSecMapEndDate = '2025-10-11', endDate = '2025-10-11' WHERE SecCode = 42719 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 53514 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 55516 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 57922 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'VVAGk.F^J25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-10-13', endDate = '2025-10-13' WHERE SecCode = 58043 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 66945 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 66977 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 71143 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 72988 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 74283 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 75331 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 75749 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 77470 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78038 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78304 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78502 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 78506 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 78610 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 79718 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80096 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80814 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 82838 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 82864 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84034 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 88260 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 89706 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 91971 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92128 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 92907 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951381.0 WHERE SecCode = 93457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93847 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 94606 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 98647 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 98751 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951705.0 WHERE SecCode = 98860 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 104775 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 111297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116434 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 122693 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VGL' WHERE SecCode = 128522 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 139594 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 143154 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 143253 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145040 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TRUE' WHERE SecCode = 277134 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 295184 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PABDA', PermSecMapEndDate = '2025-10-10', endDate = '2025-10-10' WHERE SecCode = 300101 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SRVL' WHERE SecCode = 317701 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 369170 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 771390 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 860100 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SYNEXO' WHERE SecCode = 868742 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 1327341 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 DsCtryQtStatus = 'A' WHERE SecCode = 1599535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 2083922 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 2226908 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2515633 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2693648 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 2731234 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2864442 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3128148 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3166450 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3282223 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'NGM' WHERE SecCode = 3378737 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3406836 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3435659 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3565859 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3593745 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3599035 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3673678 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3694105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3721420 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3886816 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3958670 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4048987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4066102 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 4197878 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4338899 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4368606 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-09-03', endDate = '2025-09-03' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4557781 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'UFBL' WHERE SecCode = 4557787 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899438276.0, ExchCode = 'BTE' WHERE SecCode = 4634345 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 4638891 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MARKOLINES', QuotePermID = 236797164736.0, PriValQuotePermID = 236797164736.0, ExchCode = 'NSI' WHERE SecCode = 4720484 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4804821 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4871152 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21890431017.0, PriValQuotePermID = 21890431017.0, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4970859 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5349583 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 5351843 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5362441 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5391281 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5391294 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'KLS' WHERE SecCode = 5428098 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 5509537 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 6164295 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6205870 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'NVDR' WHERE SecCode = 6478392 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6487499 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 6487503 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 6487601 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6490055 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6490060 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 6493227 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6493228 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6495238 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11035496 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'BINI.PK', RkdDisplayRIC = 'BINI.PK', RkdExchCode = 'OTC', QuotePermID = 21512541821.0, PriTrdQuotePermID = NULL, ExchCode = 'PNK' WHERE SecCode = 11036554 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11102277 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'CARM.PK', RkdDisplayRIC = 'CARM.PK', RkdExchCode = 'OTC', QuotePermID = 21534732713.0, PriTrdQuotePermID = NULL, ExchCode = 'PNK' WHERE SecCode = 11129194 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11147225 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'ETSY.K', RkdDisplayRIC = 'ETSY.N', RkdExchCode = 'NYSE', ExchCode = 'NYS' WHERE SecCode = 11147236 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11150427 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11158473 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11180048 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727404555.0, ExchCode = 'NAQ' WHERE SecCode = 11185229 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727402334.0, ExchCode = 'NAQ' WHERE SecCode = 11186268 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236787710553.0, ExchCode = 'MPM' WHERE SecCode = 11194103 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.76923 WHERE SecCode = 11196231 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11196861 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727359231.0, ExchCode = 'NAQ' WHERE SecCode = 11202501 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11206314 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727280215.0, ExchCode = 'NAQ' WHERE SecCode = 11220031 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951296.0 WHERE SecCode = 11227794 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MTAL.N^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-13', PermQuoteRetireDate = '2025-10-13', endDate = '2025-10-13' WHERE SecCode = 11230316 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11231537 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11236688 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG7308J1132', RkdSEDOL = 'BVBQPF', RkdCUSIP = 'G7308J11', DsPrimQtSedol = 'BVBQPF3', PermSecMapEndDate = '2025-10-11', endDate = '2025-10-11' WHERE SecCode = 11238855 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US20678X4034', RkdSEDOL = 'BVBQPG', RkdCUSIP = '20678X40', DsPrimQtSedol = 'BVBQPG4', PermSecMapEndDate = '2025-10-11', endDate = '2025-10-11' WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11244795 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236782382219.0, ExchCode = 'MPG' WHERE SecCode = 11250433 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5084H1112', RkdSEDOL = 'BT8PB2', RkdCUSIP = 'G5084H11', DsPrimQtSedol = 'BT8PB28', PermSecMapEndDate = '2025-10-11', endDate = '2025-10-11' WHERE SecCode = 11252318 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'AURE', PermIDTicker = 'AURE', RkdRIC = 'AURE.O', RkdDisplayRIC = 'AURE.OQ' WHERE SecCode = 11254624 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG570371149', RkdSEDOL = 'BVBQPN', RkdCUSIP = 'G5703711', DsPrimQtSedol = 'BVBQPN1', PermSecMapEndDate = '2025-10-11', endDate = '2025-10-11' WHERE SecCode = 11263023 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236793287940.0, ExchCode = 'IEX' WHERE SecCode = 11279694 AND Type_ = 1;
