UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTQHVY8', PermSecMapEndDate = '2026-08-14', endDate = '2026-08-14' WHERE SecCode = 6872 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 8885 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WEIR PLC ORD GBP0.125' WHERE SecCode = 12765 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 16691 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, RkdISIN = 'CL0002455229', RkdTicker = 'SCOTIABKCL', RkdSEDOL = 'BZ7PNX', RkdCUSIP = 'P8T35M11', RkdRIC = 'SCOTIABKCL.SN', RkdDisplayRIC = 'SCOTIABKCL.SN', Name = 'SCOTIABANK CHILE COM NPV SER ''A''', RkdCode = 40852.0, RkdIssueID = 1.0, RkdIssueCode = 53490.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SCL', RkdExchCtry = 'CHL', PrimaryIssueType = 'EQU', COATypeCode = 'BNK', SecMapStartDate = '1989-07-04', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, startDate = '1989-07-04', endDate = NULL WHERE SecCode = 27375 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT3FHB4' WHERE SecCode = 29198 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT3FHD6' WHERE SecCode = 29201 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT3FH92' WHERE SecCode = 30615 AND Type_ = 10;
UPDATE data_universe SET Name = 'NETMEDIA GROUP EUR0.1' WHERE SecCode = 34290 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1980-08-01' WHERE SecCode = 54850 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SICHUAN EXPWY GP ''H''CNY1' WHERE SecCode = 68687 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'BANPUU.BK^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 69239 AND Type_ = 10;
UPDATE data_universe SET Name = 'PARATECH COMPANY L KRW 2500' WHERE SecCode = 70467 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET Name = 'DHX COMPANY KRW5000' WHERE SecCode = 74319 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 = 'A' WHERE SecCode = 78134 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 80912 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'GYFTR', RkdRIC = 'GYFT.NS', RkdDisplayRIC = 'GYFT.NS', RkdExchCode = 'NSE' WHERE SecCode = 82553 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'PAN' WHERE SecCode = 87093 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteRetireDate = '2026-08-17' WHERE SecCode = 87246 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET Name = 'HANKUK PAPER MFG KRW5000' WHERE SecCode = 94355 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 QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838736409.0, PermQuoteRetireDate = '2013-10-15', endDate = '2013-10-14' WHERE SecCode = 103279 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475008125.0, ExchCode = 'DEU' WHERE SecCode = 103998 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21530337660.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-11-15', endDate = '2018-11-15' WHERE SecCode = 111823 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 114799 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474928708.0, ExchCode = 'JNX' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 133109 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475425489.0, ExchCode = 'LSE', PermQuoteRetireDate = '2008-12-04', endDate = '2008-10-31' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838757421.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 146200 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 QuotePermID = 21518995421.0, ExchCode = 'DEU' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CMHC' WHERE SecCode = 203053 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT3FHC5' WHERE SecCode = 214381 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236812361851.0 WHERE SecCode = 256133 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SICHUAN EXPWY GP ''A''CNY1' WHERE SecCode = 536443 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'FANTASIA HOLDINGS HKD0.5' WHERE SecCode = 554344 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AERIS RESOURCES LT NPV' WHERE SecCode = 992313 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-17' WHERE SecCode = 1587600 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 1639257 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CIZS.BO', RkdDisplayRIC = 'CIZS.BO' WHERE SecCode = 2701612 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CRDL', RkdRIC = 'CRDL.L^H26', RkdIssueStatus = 0.0, QuotePermID = 21649943543.0, InstrPermID = 21649943545.0, OrgPermID = 5062455695.0, PriValQuotePermID = 21649943543.0, PriInstrPermID = 21649943545.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'LSE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951205.0, PermQuoteRetireDate = '2026-08-14', PermOrgIPODate = '2018-05-30', PermSecMapStartDate = '2018-05-29', PermSecMapEndDate = '2026-08-14' WHERE SecCode = 3508349 AND Type_ = 10;
UPDATE data_universe SET Name = 'COM2US N KRW500' WHERE SecCode = 3597942 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '299900.KQ^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-14', SecMapEndDate = '2026-07-09', PermQuoteRetireDate = '2026-08-14', PermSecMapEndDate = '2026-08-14', endDate = '2026-07-09' WHERE SecCode = 3706493 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SCP', DsPrimQtSedol = 'BSPT2R8' WHERE SecCode = 3721200 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 = 4294951787.0 WHERE SecCode = 4043054 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 4066103 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 4129533 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 4156862 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 4272423 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951165.0 WHERE SecCode = 4287527 AND Type_ = 10;
UPDATE data_universe SET Name = 'NIUTECH TECHNOLOGY A CNY1' WHERE SecCode = 4294080 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 4295603 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 = 4294951749.0 WHERE SecCode = 4382911 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4171.T^H26', RkdIssueStatus = 0.0 WHERE SecCode = 4452295 AND Type_ = 10;
UPDATE data_universe SET Name = 'BAIRONG AI INC USD0.00002 B CLASS' WHERE SecCode = 4539146 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 QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4637758 AND Type_ = 10;
UPDATE data_universe SET Name = 'BROKEN HILL GOLD NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4638789 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'STAR7.MI^H26', RkdIssueStatus = 0.0 WHERE SecCode = 4815347 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SCP', DsPrimQtSedol = 'BSPT2R8' WHERE SecCode = 5438122 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SCP', DsPrimQtSedol = 'BSPT2R8' WHERE SecCode = 5949059 AND Type_ = 10;
UPDATE data_universe SET Name = 'FABTECH CLEANROOMS INR10' WHERE SecCode = 6071745 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-03-11' WHERE SecCode = 6710146 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE1YPB01014', RkdTicker = 'AGL', RkdSEDOL = 'BTRD8P', RkdCUSIP = 'Y0S5J910', RkdRIC = 'ALLG.NS', RkdDisplayRIC = 'ALLG.NS', RkdCode = 145348.0, RkdIssueID = 1.0, RkdIssueCode = 186011.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6957660 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y707TF10' WHERE SecCode = 6974585 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y716W610' WHERE SecCode = 6977543 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6982424 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007V49', RkdCUSIP = 'Y4460210', PrimaryIssueType = 'EQU' WHERE SecCode = 7037201 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0X9I01023', RkdTicker = '544863', RkdSEDOL = 'BVMQGZ', RkdCUSIP = 'Y5211W10', RkdRIC = 'LAPL.BO', RkdDisplayRIC = 'LAPL.BO', RkdCode = 145351.0, RkdIssueID = 1.0, RkdIssueCode = 186014.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7048406 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'C04SC24' WHERE SecCode = 10928206 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BNNPCZ1' WHERE SecCode = 11163196 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BXWZJS4' WHERE SecCode = 11182672 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXWZH57' WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US53620U8889', RkdSEDOL = 'BX0YHS', RkdCUSIP = '53620U88', ShPerListing = 292500.0, PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 11198134 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU', PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 11208468 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951242.0 WHERE SecCode = 11209363 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 11212121 AND Type_ = 1;
UPDATE data_universe SET Name = 'GOOD PURPOSE INVESTMENTS INC COM' WHERE SecCode = 11215871 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-14', SecMapEndDate = '2026-08-13', endDate = '2026-08-13' WHERE SecCode = 11217188 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236797175671.0, IsPrimaryQuote = 0.0, ExchCode = 'XNC' WHERE SecCode = 11220300 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951399.0 WHERE SecCode = 11224331 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000215649.0, PriInstrPermID = 8590941096.0 WHERE SecCode = 11234332 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXWZH35' WHERE SecCode = 11237417 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-08-14' WHERE SecCode = 11240733 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BWL886' WHERE SecCode = 11241616 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA74360H1010', RkdTicker = 'PSVA', PermIDTicker = 'PSVA', RkdSEDOL = 'BXDRBH', RkdCUSIP = '74360H10', RkdRIC = 'PSVA.V', RkdDisplayRIC = 'PSVA.V', Name = 'PROSPECTIVA RES LTD COM SHS', QuotePermID = 25727199136.0, InstrPermID = 25727199137.0, OrgPermID = 5082502822.0, PriValQuotePermID = 25727199136.0, PriInstrPermID = 25727199137.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'CVE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2022-06-29', PermSecMapStartDate = '2022-06-28', PermSecMapEndDate = '2026-08-14', startDate = '2022-06-28', endDate = '2026-08-14' WHERE SecCode = 11243274 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11262020 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US48208B3024', RkdSEDOL = 'BT6ML8', RkdCUSIP = '48208B30' WHERE SecCode = 11272226 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT06SN9' WHERE SecCode = 11279412 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXWZJQ2' WHERE SecCode = 11281521 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11293177 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11298134 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299220 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232920965462.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11299230 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-07-21', startDate = '2026-07-21' WHERE SecCode = 11299480 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 11299822 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11300031 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236812311106.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11300390 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GHXI', IsMajorSec = 'Y', QuotePermID = 236812311145.0, InstrPermID = 232933620241.0, OrgPermID = 6000152933.0, PriTrdQuotePermID = 236812311145.0, PriValQuotePermID = 25726993870.0, PriInstrPermID = 232933620241.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-23', PermSecMapStartDate = '2026-08-12', startDate = '2026-06-23' WHERE SecCode = 11300461 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TBCVU', QuotePermID = 236808850133.0, InstrPermID = 232941777794.0, OrgPermID = 6000164529.0, PriTrdQuotePermID = 236808850133.0, PriValQuotePermID = 25727016250.0, PriInstrPermID = 232941777794.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-08-13', PermSecMapStartDate = '2026-08-12', startDate = '2026-08-12' WHERE SecCode = 11300462 AND Type_ = 1;