UPDATE data_universe SET QuotePermID = 21715145964.0, ExchCode = 'AQX' WHERE SecCode = 1807 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US0846701086', RkdTicker = 'BRK A', RkdSEDOL = '209366', RkdCUSIP = '08467010', RkdRIC = 'BRKa', RkdDisplayRIC = 'BRKa.N', RkdCode = 614.0, RkdIssueID = 1.0, RkdIssueCode = 852.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 9061 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US0846707026', RkdTicker = 'BRK B', RkdSEDOL = '207339', RkdCUSIP = '08467070', RkdRIC = 'BRKb', RkdDisplayRIC = 'BRKb.N', RkdCode = 614.0, RkdIssueID = 2.0, RkdIssueCode = 756.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 9062 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 31065 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'FR001400IE67', RkdTicker = 'MHM', RkdSEDOL = 'BQYLWV', RkdCUSIP = 'F4R07612', RkdRIC = 'MHM.PA', RkdDisplayRIC = 'MHM.PA', RkdCode = 37616.0, RkdIssueID = 1.0, RkdIssueCode = 49858.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'EPA', RkdExchCtry = 'FRA' WHERE SecCode = 33966 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-22', SecMapEndDate = '2026-09-21', PermQuoteRetireDate = '2026-09-22', endDate = '2026-09-21' WHERE SecCode = 37867 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CH0034389707', RkdTicker = 'ALPH', RkdSEDOL = '460652', RkdCUSIP = 'H0210910', RkdRIC = 'ALPH.S^L19', RkdDisplayRIC = 'ALPH.S', RkdCode = 19088.0, RkdIssueID = 1.0, RkdIssueCode = 26996.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SWF', RkdExchCtry = 'CHE' WHERE SecCode = 43816 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55842440800.0, ExchCode = 'CHI', PermQuoteRetireDate = '2012-05-04', endDate = '2012-05-04' WHERE SecCode = 45820 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-09-21' WHERE SecCode = 49578 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55836324566.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-09' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-09-20', endDate = '2026-09-18' WHERE SecCode = 67667 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, PrimaryIssueCode = NULL, COATypeCode = NULL WHERE SecCode = 69925 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70042 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70438 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 74162 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74493 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75057 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'KBIO LABS INC KRW2500' WHERE SecCode = 76681 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78583 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79086 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80017 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 80024 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 80541 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US9569251013', RkdTicker = 'AVTS', RkdSEDOL = 'BPCXK0', RkdCUSIP = '95692510', RkdRIC = 'AVTS.V', RkdDisplayRIC = 'AVTS.V', RkdCode = 23440.0, RkdIssueID = 1.0, RkdIssueCode = 32078.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 81608 AND Type_ = 1; UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-09-20', endDate = '2026-09-18' WHERE SecCode = 81657 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'HEGAM' WHERE SecCode = 82006 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82801 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'ABU DH NAT INV AND AED1' WHERE SecCode = 86794 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951366.0 WHERE SecCode = 87401 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90013 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA03444Q2099', RkdSEDOL = '203265', RkdCUSIP = '03444Q20', RkdRIC = 'ADWb.TO^H26', RkdDisplayRIC = 'ADWb.TO', RkdCode = 14963.0, RkdIssueID = 2.0, RkdIssueCode = 21336.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 2.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PriInstrPermID = NULL WHERE SecCode = 90404 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA03444Q1000', RkdSEDOL = '203264', RkdCUSIP = '03444Q10', RkdRIC = 'ADWa.TO^H26', RkdDisplayRIC = 'ADWa.TO', RkdCode = 14963.0, RkdIssueID = 1.0, RkdIssueCode = 21637.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PriInstrPermID = NULL WHERE SecCode = 90405 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA14888K1030', RkdTicker = 'CATX', PermIDTicker = 'CATX', RkdSEDOL = 'BV2G33', RkdCUSIP = '14888K10', RkdRIC = 'CATX.V', RkdDisplayRIC = 'CATX.V', DsPrimQtSedol = 'BV2G336', RkdCode = 123785.0, RkdIssueID = 1.0, RkdIssueCode = 156303.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 91396 AND Type_ = 1; UPDATE data_universe SET Name = 'ANTIMONY RESOURCE NPV', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 91543 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2026-09-19', endDate = '2026-09-19' WHERE SecCode = 94048 AND Type_ = 1; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 95697 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236788945141.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-18', PermOrgIPODate = '1991-11-25', PermSecMapEndDate = '2026-09-20', endDate = '2026-09-18' WHERE SecCode = 98177 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'PTVAA0AM0019', RkdTicker = 'VAF', RkdSEDOL = 'BFX594', RkdCUSIP = 'X9T9AU13', RkdRIC = 'VAF.LS^I26', RkdDisplayRIC = 'VAF.LS', RkdCode = 20869.0, RkdIssueID = 1.0, RkdIssueCode = 29120.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ELI', RkdExchCtry = 'PRT', PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-18', PermSecMapEndDate = '2026-09-21', endDate = '2026-09-18' WHERE SecCode = 100657 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115260 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115980 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 119593 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120585 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 124738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125625 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125692 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126259 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126305 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126429 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126430 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126457 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126634 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126810 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126828 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126972 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 128794 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134846 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134904 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135448 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135730 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136034 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136772 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136981 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136987 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136991 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-09-20', endDate = '2026-09-18' WHERE SecCode = 140966 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142542 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; 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 QuotePermID = 55836333820.0, ExchCode = 'BER' WHERE SecCode = 178289 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'FRESITA PROTEINS INR10' WHERE SecCode = 193324 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243222 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243354 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 257965 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 300864 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378080 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378081 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 389876 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 403765 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 408145 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 413017 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 431231 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 442754 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-22', SecMapEndDate = '2026-09-21', endDate = '2026-09-21' WHERE SecCode = 554603 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'C0C5JH1' WHERE SecCode = 703056 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 794875 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'MCST GROUP JSC VND10000' WHERE SecCode = 817712 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 841140 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 999958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1039780 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1040923 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1204782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209860 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209863 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209871 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 1263511 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 1347567 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951660.0 WHERE SecCode = 1471745 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 1482794 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 1485661 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951999.0 WHERE SecCode = 1493555 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951785.0 WHERE SecCode = 1494099 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 ISIN = NULL, Name = 'VERIMATRIX EUR0.1' WHERE SecCode = 1524536 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 1534187 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21491231453.0, ExchCode = 'BUR' WHERE SecCode = 1534902 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951831.0 WHERE SecCode = 1541388 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951909.0 WHERE SecCode = 1565080 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 1580334 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2380641 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2387392 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21540177743.0, PermQuoteStatus = 'AC', ExchCode = 'TRQ', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2417968 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21634375087.0, ExchCode = 'BTE', PermQuoteRetireDate = '2018-10-19' WHERE SecCode = 2438937 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452498 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2529641 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'REED SCA EUR6.53' WHERE SecCode = 2559083 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580912 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592376 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951909.0 WHERE SecCode = 2671255 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951783.0 WHERE SecCode = 2693649 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2782958 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21560879167.0, ExchCode = 'STU' WHERE SecCode = 2855772 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueCode = 98674.0 WHERE SecCode = 2894522 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951169.0 WHERE SecCode = 2900880 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2940864 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21568326330.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08', PermSecMapEndDate = '2022-06-08', endDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21589220364.0, ExchCode = 'DEU' WHERE SecCode = 2976573 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-22', SecMapEndDate = '2026-09-15', PermQuoteRetireDate = '2026-09-22', endDate = '2026-09-15' WHERE SecCode = 3010342 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'KOJI ASSET INV JT VND10000' WHERE SecCode = 3100328 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 3167369 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21588488685.0, PermQuoteStatus = 'DC', ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2025-02-03' WHERE SecCode = 3177550 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'ESTAID KRW500' WHERE SecCode = 3192859 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'ALELIs', QuotePermID = 21631067659.0, ExchCode = 'BCO', PermQuoteRetireDate = '2024-04-08' WHERE SecCode = 3198788 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BTRVTQ7' WHERE SecCode = 3207296 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212151 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212191 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247268 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10; UPDATE data_universe SET Name = 'CENTURY GP INTL HKD0.2 (POST CON)' WHERE SecCode = 3254562 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 3261255 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951287.0 WHERE SecCode = 3264431 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'SE0024173637', RkdTicker = 'ATORX', RkdSEDOL = 'BQV3S2', RkdCUSIP = 'W0470R42', RkdRIC = 'ATORX.ST', RkdDisplayRIC = 'ATORX.ST', RkdCode = 110560.0, RkdIssueID = 1.0, RkdIssueCode = 138920.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE' WHERE SecCode = 3271830 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3317677 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX', PermQuoteRetireDate = '2022-10-03', endDate = '2022-10-03' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3325946 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3378303 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3427869 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'ROR', QuotePermID = 21858705514.0, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3554989 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'NXM', Name = 'NEXUM GROUP AG NPV (POST SPLIT)' WHERE SecCode = 3558196 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'ARTEX SECURITIES J VND10000' WHERE SecCode = 3610773 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3877630 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3980863 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4018127 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'ENLIE PHARMACEUTIC VND10000' WHERE SecCode = 4041226 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 4248127 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 4421087 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4451115 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 4468561 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236777414895.0, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2026-04-27' WHERE SecCode = 4511455 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4517654 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951366.0 WHERE SecCode = 4539140 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'THE TRADE DESK INC BDR EACH REPR 1 COM' WHERE SecCode = 4555972 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4562054 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21815952055.0, ExchCode = 'FRA' WHERE SecCode = 4614958 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4675093 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4702567 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4702652 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'TAT KA WAI HONG PH A CNY1' WHERE SecCode = 4796244 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4804621 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4830903 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4932395 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951909.0 WHERE SecCode = 5411329 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'ENL', DsPrimQtSedol = 'BS718H4' WHERE SecCode = 5607462 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5620303 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 22007599680.0, ExchCode = 'DEU' WHERE SecCode = 5620353 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5738355 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 5779226 AND Type_ = 10; UPDATE data_universe SET DsExchMnem = 'TAI', ExchCode = 'TAI' WHERE SecCode = 6078434 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '25752l', QuotePermID = 236793411522.0, ExchCode = 'SIG' WHERE SecCode = 6334328 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 6546182 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'GRUPO LAR RETAIL I EUR1.03' WHERE SecCode = 6605910 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6629438 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6927579 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951909.0 WHERE SecCode = 6967208 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000475774', RkdTicker = 'ELK', RkdSEDOL = 'BVSV3R', RkdCUSIP = 'Q3451V10', RkdRIC = 'ELK.AX', RkdDisplayRIC = 'ELK.AX', RkdCode = 145596.0, RkdIssueID = 1.0, RkdIssueCode = 186432.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7040615 AND Type_ = 10; UPDATE data_universe SET Name = 'CENTURY GP INTL HKD0.2 (PARALLEL 20/10/26)' WHERE SecCode = 7101260 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7105122 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'PH0000062986', RkdTicker = 'BC', RkdSEDOL = 'C0C53J', RkdCUSIP = 'Y0783215', RkdRIC = 'BC.PS', RkdDisplayRIC = 'BC.PS', RkdCode = 56442.0, RkdIssueID = 1.0, RkdIssueCode = 73490.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'PSE', RkdExchCtry = 'PHL', PrimaryIssueType = 'EQU', PrimaryIssueCode = 56442.0, COATypeCode = 'IND' WHERE SecCode = 7107718 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE2D0Q01027', RkdTicker = '544922', RkdSEDOL = 'C04FVZ', RkdCUSIP = 'Y6S2XQ11', RkdRIC = 'OMGL.BO', RkdDisplayRIC = 'OMGL.BO', RkdCode = 145601.0, RkdIssueID = 1.0, RkdIssueCode = 186438.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7110835 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2006-05-17' WHERE SecCode = 10924425 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US60871R1005', RkdTicker = 'TAP A', RkdSEDOL = 'B067CN', RkdCUSIP = '60871R10', RkdRIC = 'TAPa', RkdDisplayRIC = 'TAPa.N', RkdCode = 1235.0, RkdIssueID = 2.0, RkdIssueCode = 1214.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 10924512 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11003923 AND Type_ = 1; UPDATE data_universe SET DsExchMnem = 'TSE' WHERE SecCode = 11013283 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BV2FZS2' WHERE SecCode = 11015187 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA00810E2087', RkdTicker = 'AETH.X', RkdSEDOL = 'BNRN90', RkdCUSIP = '00810E20', RkdRIC = 'AETHx.CD', RkdDisplayRIC = 'AETHx.CD', RkdCode = 89497.0, RkdIssueID = 1.0, RkdIssueCode = 112461.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11028341 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D', ExchCode = 'CVE', DsSecDelistDate = '2026-09-22', SecMapEndDate = '2026-09-21', PermQuoteRetireDate = NULL, endDate = '2026-09-21' WHERE SecCode = 11150246 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11199570 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BV2FZP9' WHERE SecCode = 11232843 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ESYN', Name = 'ENERSYN GLOBAL INC COM NEW' WHERE SecCode = 11240002 AND Type_ = 1; UPDATE data_universe SET Name = 'JE CLEANTECH HOLDINGS LIMITE CLASS A ORDINARY' WHERE SecCode = 11241169 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11244824 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-09-19', endDate = '2026-09-19' WHERE SecCode = 11260721 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US47760D2018', RkdTicker = 'NAMI', RkdSEDOL = 'BXD1F1', RkdCUSIP = '47760D20', RkdRIC = 'NAMI.O', RkdDisplayRIC = 'NAMI.OQ', RkdCode = 137424.0, RkdIssueID = 1.0, RkdIssueCode = 174708.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'ADR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', ShPerListing = 450.0 WHERE SecCode = 11270779 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-22', endDate = '2026-09-22' WHERE SecCode = 11275439 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NWCL', DsPrimQtSedol = 'BX835R3' WHERE SecCode = 11277492 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SVIA', Name = 'SILVIA INC COM SHS' WHERE SecCode = 11279077 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SYMCF', QuotePermID = 236814606628.0, InstrPermID = 232942207823.0, OrgPermID = 6000278615.0, PriValQuotePermID = 236813069371.0, PriInstrPermID = 232942207823.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = '2026-08-26', PermSecMapStartDate = '2026-09-15' WHERE SecCode = 11301805 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11301922 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'LEDRU', QuotePermID = 236814734048.0, InstrPermID = 232943575761.0, OrgPermID = 6000164672.0, PriTrdQuotePermID = 236814734048.0, PriValQuotePermID = 25726989089.0, PriInstrPermID = 232943575761.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-09-18', PermSecMapStartDate = '2026-09-18' WHERE SecCode = 11301987 AND Type_ = 1;