UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2176 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 5421 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 8590923227.0 WHERE SecCode = 7851 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 9949 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 8589939980.0 WHERE SecCode = 16143 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 8589939980.0 WHERE SecCode = 27994 AND Type_ = 10; UPDATE data_universe SET RkdIssueOrder = 1.0, PriInstrPermID = 8589939980.0 WHERE SecCode = 27995 AND Type_ = 10; UPDATE data_universe SET RkdIssueOrder = 2.0, PriInstrPermID = 8589939980.0 WHERE SecCode = 28133 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 56109 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'IPOk.DE', RkdDisplayRIC = 'IPOk.DE' WHERE SecCode = 57210 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 57961 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 58417 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 55836324566.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77529 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77608 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'GARWARE OFF SVCS INR10' WHERE SecCode = 78612 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 79135 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80452 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'CLGUN' WHERE SecCode = 80910 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'WLS HLDGS LTD (B) HKD0.01 POST CON' WHERE SecCode = 83024 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83951 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85361 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 85957 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 88379 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 PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 90552 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET RkdTicker = '6051', PermIDTicker = '6051', RkdRIC = '6051.HK', RkdDisplayRIC = '6051.HK' WHERE SecCode = 92897 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 94094 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 94407 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105546 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 111776 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 111783 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET Name = 'QINGDA ORIENTAL GR ''H''CNY0.1', PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 114152 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 115315 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 133646 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135965 AND Type_ = 10; UPDATE data_universe SET Name = 'SIDETRADE SA EUR1' WHERE SecCode = 137808 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'IBIS-M', RkdRIC = 'IBIS.TA', RkdDisplayRIC = 'IBIS.TA' WHERE SecCode = 146133 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55836333820.0, ExchCode = 'BER' WHERE SecCode = 178289 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'COSMO NV EUR0.26 (REGD)' WHERE SecCode = 203053 AND Type_ = 10; UPDATE data_universe SET DsExchMnem = 'LON', DsExchQtStartDate = '2007-07-23', SecMapStartDate = '2007-07-23', startDate = '2007-07-23' WHERE SecCode = 311068 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 320085 AND Type_ = 10; UPDATE data_universe SET Name = 'FALCON GOLD CORP COM' WHERE SecCode = 334746 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 357924 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 369170 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395047 AND Type_ = 10; UPDATE data_universe SET Name = 'JANUS GROUP JOINT VND10000' WHERE SecCode = 583350 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 602222 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 1182141 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 1694061 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'ASGA.BO', RkdDisplayRIC = 'ASGA.BO' WHERE SecCode = 1997874 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 2586428 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2831967 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3054014 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3318543 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3319123 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE124Y01028', RkdSEDOL = 'BPGN4R', RkdCUSIP = 'Y6785612', DsPrimQtSedol = 'BPGN4R2' WHERE SecCode = 3396301 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3396929 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951250.0 WHERE SecCode = 3402529 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3410416 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10; UPDATE data_universe SET Name = 'TRINITY AWY S CO KRW100' WHERE SecCode = 3564647 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'KOS INTL TALENT GR HKD0.01' WHERE SecCode = 3620665 AND Type_ = 10; UPDATE data_universe SET Name = 'M N C WIRELESS BER ICPS 12/09/29 MYR0.31' WHERE SecCode = 3955659 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 DsCtryQtStatus = 'S' WHERE SecCode = 3999398 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 8590923227.0 WHERE SecCode = 4001136 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL, RkdRIC = 'M8S.AX^B25', RkdDisplayRIC = 'M8S.AX^B25', RkdIssueStatus = 0.0 WHERE SecCode = 4040156 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 RkdRIC = 'BEN1.DE', RkdDisplayRIC = 'BEN1.DE', RkdExchCode = 'ETR' WHERE SecCode = 4369879 AND Type_ = 10; UPDATE data_universe SET RkdListingType = 'ADR', ShPerListing = 0.0, PrimaryIssueCode = 47198.0, RelType = 7.0, PriInstrPermID = 8590923227.0 WHERE SecCode = 4540648 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 PriInstrPermID = 8589939980.0 WHERE SecCode = 4577875 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 4882385 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5019011 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 5413651 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 8590923227.0 WHERE SecCode = 5455472 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'PNG' WHERE SecCode = 5579584 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6128239 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6441887 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 8590923227.0 WHERE SecCode = 6548033 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951282.0 WHERE SecCode = 6571951 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6583642 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6755625 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6756389 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BVPKCD8' WHERE SecCode = 11038598 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11111276 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'P', RkdRIC = 'P', RkdDisplayRIC = 'P.N' WHERE SecCode = 11152585 AND Type_ = 1; UPDATE data_universe SET Country = 'VGB', DsPrimQtSedol = 'BVPKCT4' WHERE SecCode = 11153361 AND Type_ = 1; UPDATE data_universe SET Name = 'WESTERN URANIUM & VANADIUM COM' WHERE SecCode = 11157205 AND Type_ = 1; UPDATE data_universe SET Name = 'POLAR PWR INC. COM NEW' WHERE SecCode = 11165503 AND Type_ = 1; UPDATE data_universe SET Name = 'BROOKFIELD CORP 4.75 PFD 48 A' WHERE SecCode = 11175901 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11189974 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11194352 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-16', SecMapEndDate = '2026-04-01', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16', endDate = '2026-04-01' WHERE SecCode = 11195616 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11225910 AND Type_ = 1; UPDATE data_universe SET Name = 'MYSEUM.AI INC COM NEW' WHERE SecCode = 11228699 AND Type_ = 1; UPDATE data_universe SET Name = 'MYSEUM.AI INC *W EXP 08/17/2026' WHERE SecCode = 11228800 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11236900 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US1827442013', RkdSEDOL = 'BWYD5H', RkdCUSIP = '18274420' WHERE SecCode = 11238076 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11247797 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US23249H1059', RkdTicker = 'CYAB', PermIDTicker = 'CYAB', RkdSEDOL = 'BWTYYP', RkdCUSIP = '23249H10', RkdRIC = 'CYAB.O', RkdDisplayRIC = 'CYAB.OQ', InfoCode = 395702, DsSecCode = 272235, DsCmpyCode = 213131, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BWTYYP9', RkdCode = 144590.0, RkdIssueCode = 184803.0, RkdIssueStatus = 1.0, QuotePermID = 236804914022.0, InstrPermID = 232870579239.0, OrgPermID = 5090726709.0, PriTrdQuotePermID = 236804914022.0, PriValQuotePermID = 25727028989.0, PriInstrPermID = 232870579239.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PriTRBCIndPermID = 4294951203.0, DsSecDelistDate = NULL, DsExchQtStartDate = '2026-03-27', SecMapStartDate = '2026-03-27', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-27', PermSecMapStartDate = '2026-03-27', PermSecMapEndDate = NULL, startDate = '2026-03-27', endDate = NULL WHERE SecCode = 11252862 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 8589939980.0 WHERE SecCode = 11260982 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'VGG7200G1265', RkdSEDOL = 'BW5DNN', RkdCUSIP = 'G7200G12', DsPrimQtSedol = 'BW5DNN1' WHERE SecCode = 11269125 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NATQF' WHERE SecCode = 11271493 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289033 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232918789762.0 WHERE SecCode = 11292424 AND Type_ = 1; 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, COATypeCode = NULL WHERE SecCode = 11292836 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292967 AND Type_ = 1; 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, COATypeCode = NULL WHERE SecCode = 11293198 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232915006505.0 WHERE SecCode = 11293452 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11294069 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG041261275', RkdCode = 144686.0, RkdIssueCode = 185002.0 WHERE SecCode = 11294226 AND Type_ = 1; UPDATE data_universe SET SecMapStartDate = '2026-04-09' WHERE SecCode = 11294283 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ASRFF', QuotePermID = 236805672453.0, InstrPermID = 232907241484.0, OrgPermID = 6000080689.0, PriValQuotePermID = 236805096554.0, PriInstrPermID = 232907241484.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951954.0, PermOrgIPODate = '2026-03-31', PermSecMapStartDate = '2026-04-13' WHERE SecCode = 11294422 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG3710B1032', RkdTicker = 'GLED', RkdSEDOL = 'BVBJR9', RkdCUSIP = 'G3710B10', RkdRIC = 'GLED.K', RkdDisplayRIC = 'GLED.N', RkdCode = 143427.0, RkdIssueID = 1.0, RkdIssueCode = 183115.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294496 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG604201098', RkdTicker = 'MTAL', RkdSEDOL = 'BTZ9X6', RkdCUSIP = 'G6042010', RkdRIC = 'MTAL.K', RkdDisplayRIC = 'MTAL.N', RkdCode = 144284.0, RkdIssueID = 1.0, RkdIssueCode = 184285.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294498 AND Type_ = 1;