UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 1742 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 2677 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 2869 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 7274 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 7940 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 8350 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 8382 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 8937 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 11715 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 11795 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 18300 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 25341 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 27577 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 30112 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 32862 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 33703 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 37449 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 42020 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 42021 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951803.0 WHERE SecCode = 44268 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 44444 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 45933 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 46865 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 51845 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 53169 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 53926 AND Type_ = 10; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 55209 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 55322 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 60482 AND Type_ = 1; 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 DsCtryQtStatus = 'A' WHERE SecCode = 68818 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71191 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 73130 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73265 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73890 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73903 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74387 AND Type_ = 10; UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 74392 AND Type_ = 1; UPDATE data_universe SET RkdRIC = '042670.KS^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 74992 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951184.0 WHERE SecCode = 75012 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75145 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75403 AND Type_ = 10; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 76409 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 78635 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78891 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80275 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81254 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81556 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 81759 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951392.0 WHERE SecCode = 81908 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-27' WHERE SecCode = 85955 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86753 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87170 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87934 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89723 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90560 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93380 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93565 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93867 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94843 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '010600.KS^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 99233 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'ALENR.PA^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 101984 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120797 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124850 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133128 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133888 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134615 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2017-12-28' WHERE SecCode = 134894 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137529 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140399 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 144424 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 145185 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'B8L', QuotePermID = 55836024490.0, ExchCode = 'ISE', PermQuoteRetireDate = '2011-09-02', endDate = '2011-09-01' WHERE SecCode = 145528 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145840 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BRBNNJ', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 159732 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 55836333820.0, ExchCode = 'BER', PermQuoteRetireDate = '2023-03-16', PermSecMapEndDate = '2023-03-16', endDate = '2023-03-16' WHERE SecCode = 178289 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'VLGe', QuotePermID = 21517719870.0, ExchCode = 'SIG', PermQuoteRetireDate = '2013-08-12' WHERE SecCode = 182166 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 186176 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21518995421.0, ExchCode = 'DEU' WHERE SecCode = 201949 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 311238 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'BPAN4.SA^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-26', PermQuoteRetireDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 340658 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '1893.H', QuotePermID = 21476459275.0, ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24', endDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 375203 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 379152 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-26' WHERE SecCode = 391456 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 397637 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 585502 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'S96.HNO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 586469 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 822496 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 881834 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 897188 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1072162 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 1112903 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55850366387.0, ExchCode = 'BER', PermQuoteRetireDate = '2012-05-07', endDate = '2012-05-05' WHERE SecCode = 1265152 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1292949 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 1592142 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1599536 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1668753 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1803433 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2014209 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2157369 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2273695 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2024-07-02' WHERE SecCode = 2322356 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2394815 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '150840.KQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 2441643 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'ALMCP.PA^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 2513984 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2518701 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2593540 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2598695 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2637937 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2679840 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2682320 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US45579U1097', RkdSEDOL = 'BTZRLN', RkdCUSIP = '45579U10' WHERE SecCode = 2745164 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2747568 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2831965 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2885873 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2940845 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2970654 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 = 3020761 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3022449 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3113869 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'PH0000061798', RkdTicker = 'VLC', RkdRIC = 'VLC.PS', RkdDisplayRIC = 'VLC.PS' WHERE SecCode = 3200566 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3211294 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 3322264 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3387565 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3407483 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3418988 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3434591 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3444651 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3495771 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3505141 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3812315 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3817689 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 = 4032275 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4204830 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4218669 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4369885 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4427868 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4429543 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4502482 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4550492 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4558203 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4601622 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4607551 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4634301 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2021-07-20' WHERE SecCode = 4649908 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4650985 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4767820 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4767831 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4794498 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4811076 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe SET DsExchMnem = 'KLS' WHERE SecCode = 5035040 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5067130 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5156823 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'CINIS.ST^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 5208169 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5227158 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5288773 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5454652 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5597176 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5618934 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 5816808 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5894960 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-27' WHERE SecCode = 6039879 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6100251 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6211060 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6440023 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6583675 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6593989 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CSG', QuotePermID = 236801945389.0, IsPrimaryQuote = 1.0, ExchCode = 'AEX', PermOrgIPODate = '2026-01-23' WHERE SecCode = 6628921 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 5097137743.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11139732 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'EZRA' WHERE SecCode = 11142544 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'ATXS.OQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-26', endDate = '2026-01-26' WHERE SecCode = 11149498 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'DRC', RkdSEDOL = 'BNHV9Q', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11199545 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5097136364.0, PriInstrPermID = 25727306465.0, PriTRBCIndPermID = NULL WHERE SecCode = 11212834 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BRF0735' WHERE SecCode = 11212890 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5097136364.0, PriInstrPermID = 25727306465.0, PriTRBCIndPermID = NULL WHERE SecCode = 11214756 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US3622AW5029', RkdSEDOL = 'BRBNNV', RkdCUSIP = '3622AW50', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11218581 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5073633495.0, PriInstrPermID = 25727268407.0, PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11224254 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'VGG0544E1390', RkdSEDOL = 'BTY4LS', RkdCUSIP = 'G0544E13', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11239813 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5097133902.0, PriValQuotePermID = 21869175685.0, PriInstrPermID = 21869175686.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11241337 AND Type_ = 1; UPDATE data_universe SET RkdCUSIP = 'M2R43K39' WHERE SecCode = 11242197 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'VGG6209W1243', RkdSEDOL = 'BRBNNX', RkdCUSIP = 'G6209W12', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11250671 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'MHY182841772', RkdSEDOL = 'BRBNMT', RkdCUSIP = 'Y1828417', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11253723 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US50172T3014', RkdSEDOL = 'BRBNRF', RkdCUSIP = '50172T30', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11258156 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG6S85D1170', RkdSEDOL = 'BRBNN7', RkdCUSIP = 'G6S85D11', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11264399 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US71989C2089', RkdSEDOL = 'BRBNNQ', RkdCUSIP = '71989C20', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11274027 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BWQLRX', PermSecMapEndDate = '2026-01-24', endDate = '2026-01-24' WHERE SecCode = 11288084 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11289051 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, ModelCntry = 'KY', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = 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, startDate = '2025-12-04' WHERE SecCode = 11289053 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11289054 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = 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, startDate = '2025-12-04' WHERE SecCode = 11289056 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232901767226.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11289101 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232899379359.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11289178 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236801975772.0, PriTrdQuotePermID = 236801975772.0, PriValQuotePermID = 25727039150.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS' WHERE SecCode = 11290981 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236801976311.0, PriTrdQuotePermID = 236801976311.0, PriValQuotePermID = 25727038993.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS', startDate = '2025-12-03' WHERE SecCode = 11290982 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236801976330.0, PriTrdQuotePermID = 236801976330.0, PriValQuotePermID = 25727038932.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS', PermOrgIPODate = '2026-01-23' WHERE SecCode = 11290984 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236801975846.0, PriTrdQuotePermID = 236801975846.0, PriValQuotePermID = 25727039121.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS' WHERE SecCode = 11290991 AND Type_ = 1;