UPDATE data_universe SET QuotePermID = 55838320947.0, InstrPermID = 8590933415.0, OrgPermID = 4295903660.0, PriTrdQuotePermID = 55838320947.0, PriValQuotePermID = 55839027600.0, PriInstrPermID = 8590933415.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951997.0, PermQuoteRetireDate = '2026-05-07', PermOrgIPODate = '1990-02-08', PermSecMapStartDate = '1990-03-23', PermSecMapEndDate = '2026-05-07' WHERE SecCode = 11586 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-08' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 65660 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8805Y24', Name = 'SUREFIRE RESOURCES NPV DFD 14/05/26 (EX-SPLIT)' WHERE SecCode = 72565 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55835372179.0, IsPrimaryQuote = 1.0, ExchCode = 'NYS' WHERE SecCode = 86891 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 88379 AND Type_ = 10;
UPDATE data_universe SET Name = 'FLEX LTD ORD' WHERE SecCode = 88720 AND Type_ = 1;
UPDATE data_universe SET Name = 'COPPER LAKE RES LTD COM NEW' WHERE SecCode = 90764 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2003-05-28' WHERE SecCode = 95345 AND Type_ = 1;
UPDATE data_universe SET Name = 'TFI INTERNATIONAL INC COM' WHERE SecCode = 100381 AND Type_ = 1;
UPDATE data_universe SET Name = 'ERSTE BK POLSKA SA PLN10.00' WHERE SecCode = 101022 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'REABOLD RESOURCES ORD GBP1' WHERE SecCode = 114317 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LAKEFRONT BIOTHERA NPV' WHERE SecCode = 133510 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LAKEFRONT BIOTHERA NPV' WHERE SecCode = 133511 AND Type_ = 10;
UPDATE data_universe SET Name = 'TRAFALGAR PROPERTY ORD GBP0.01' WHERE SecCode = 142500 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000074742', RkdTicker = 'HCD', RkdSEDOL = 'BJYFY6', RkdCUSIP = 'Q4771623', RkdRIC = 'HCD.AX', RkdDisplayRIC = 'HCD.AX', DsPrimQtSedol = 'BJYFY67' WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe SET Name = 'MDS TECH INC KRW500' WHERE SecCode = 165065 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 683529 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 832249 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 873717 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 1254621 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 RkdIssueStatus = 0.0 WHERE SecCode = 1285773 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 ISIN = NULL WHERE SecCode = 1582266 AND Type_ = 10;
UPDATE data_universe SET Name = 'ECOGLOW CO LTD KRW500' WHERE SecCode = 2000130 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4195.TW', RkdDisplayRIC = '4195.TW', RkdExchCode = 'TPE' WHERE SecCode = 2439906 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2014-12-17', startDate = '2014-12-08' WHERE SecCode = 2720697 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ZUOLI KECHUANG CO ''H'' CNY1' WHERE SecCode = 2748650 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 2911861 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BY9CRX' WHERE SecCode = 2912792 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21762568152.0, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07', endDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOLUMIX CO LTD KRW500' WHERE SecCode = 3145242 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET Name = 'APTN INC KRW1000' WHERE SecCode = 3386085 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG9428A1215', RkdSEDOL = 'BTXZ5B', RkdCUSIP = 'G9428A12', DsPrimQtSedol = 'BTXZ5B0' WHERE SecCode = 3818085 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'DADC', RkdRIC = 'DADC.CO', RkdDisplayRIC = 'DADC.CO' WHERE SecCode = 3845903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3881129 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'HANWOOL SEMICON KRW500' WHERE SecCode = 3959739 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'MXFFFI1Z0009', RkdTicker = 'FIDEAL20', RkdSEDOL = 'BMYMGT', RkdCUSIP = 'P1R44B77', RkdRIC = 'FIDEAL20.MX', RkdDisplayRIC = 'FIDEAL20.MX', RkdCode = 144781.0, RkdIssueCode = 185158.0, RkdExchCode = 'MXK', RkdExchCtry = 'MEX' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe SET Name = 'LAKEFRONT BIOTHERA BDR EACH 20 REPR 1 ADR' WHERE SecCode = 4385253 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BSLNG492', RkdTicker = 'TIN', RkdSEDOL = 'BSLNG4', RkdCUSIP = 'G3104R10', RkdRIC = 'TIN.L', RkdDisplayRIC = 'TIN.L', RkdCode = 144777.0, RkdIssueID = 1.0, RkdIssueCode = 185154.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4501936 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 QuotePermID = 236799369659.0, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'DOTL', RkdRIC = 'DOTL.L', RkdDisplayRIC = 'DOTL.L' WHERE SecCode = 5155320 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5482613 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5493583 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHINA REG MED INTL HKD2 (PARALLEL 11/10/23)', Country = 'CYM' WHERE SecCode = 5516788 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IT0005707341', RkdSEDOL = 'BX73F7', DsPrimQtSedol = 'BX73F74' WHERE SecCode = 5635825 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = 140491.0, RkdIssueCode = 179065.0, RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueType = 'PVT', PrimaryIssueCode = NULL, COATypeCode = '' WHERE SecCode = 5996598 AND Type_ = 10;
UPDATE data_universe SET Name = 'ORGANOIDSCIENCES KRW500' WHERE SecCode = 6276732 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL WHERE SecCode = 6339508 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236801528079.0 WHERE SecCode = 6487500 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 6654548 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IL0012369679', RkdTicker = 'ALL', RkdSEDOL = 'BT02DW', RkdCUSIP = 'M0836310', RkdRIC = 'ALL.TA', RkdDisplayRIC = 'ALL.TA', RkdCode = 144787.0, RkdIssueID = 1.0, RkdIssueCode = 185164.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6686349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-04-22', endDate = '2026-04-22' WHERE SecCode = 6756271 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 6786370 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BVRY9595', RkdTicker = 'RIFT', RkdSEDOL = 'BVRY95', RkdCUSIP = 'G7572510', RkdRIC = 'RIFT.L', RkdDisplayRIC = 'RIFT.L', RkdCode = 144789.0, RkdIssueID = 1.0, RkdIssueCode = 185166.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6797444 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KR70070X0000', RkdTicker = '0070X0', RkdSEDOL = 'BWKCCN', RkdCUSIP = 'Y816FV10', RkdRIC = '0070X0.KN', RkdDisplayRIC = '0070X0.KN', RkdCode = 144779.0, RkdIssueID = 1.0, RkdIssueCode = 185156.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'KON', RkdExchCtry = 'KOR', PrimaryIssueType = 'EQU', PrimaryIssueCode = 144779.0, COATypeCode = '' WHERE SecCode = 6808759 AND Type_ = 10;
UPDATE data_universe SET Name = 'REX CONCEPTS SA PLN1.00 ALLOTMENT CERTS C' WHERE SecCode = 6832532 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEMETALS CORP COM NEW' WHERE SecCode = 10934601 AND Type_ = 1;
UPDATE data_universe SET Name = 'ORD MOUNTAIN RESOURCES CORP COM NEW', PermSecMapEndDate = '2026-05-08', endDate = '2026-05-08' WHERE SecCode = 10961584 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 10971989 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'AGNT', RkdRIC = 'AGNT.O', RkdDisplayRIC = 'AGNT.OQ' WHERE SecCode = 10985859 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US78418A8027', RkdSEDOL = 'BT9QSP', RkdCUSIP = '78418A80' WHERE SecCode = 11173442 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BT9QV8' WHERE SecCode = 11219296 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA01176C2085', RkdCUSIP = '01176C20' WHERE SecCode = 11234105 AND Type_ = 1;
UPDATE data_universe SET Name = 'FREEDOM GOLD CORP COM' WHERE SecCode = 11242346 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 60.0 WHERE SecCode = 11250292 AND Type_ = 1;
UPDATE data_universe SET Name = 'US GOLDMINING INC *W EXP 05/22/2026' WHERE SecCode = 11252345 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'BRUN.O', RkdDisplayRIC = 'BRUN.OQ' WHERE SecCode = 11273589 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11281412 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA', DsPrimQtSedol = 'BSHW2F3', DsExchMnem = 'NYS' WHERE SecCode = 11284217 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292733 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 = 11294535 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG507651092', RkdTicker = 'JATT', RkdSEDOL = 'BX54H1', RkdCUSIP = 'G5076510', RkdRIC = 'JATT.O', RkdDisplayRIC = 'JATT.OQ', RkdCode = 144793.0, RkdIssueID = 1.0, RkdIssueCode = 185172.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294653 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US51255A1025', RkdTicker = 'LABT', RkdSEDOL = 'BTWP1S', RkdCUSIP = '51255A10', RkdRIC = 'LABT.O', RkdDisplayRIC = 'LABT.OQ', RkdCode = 144772.0, RkdIssueID = 1.0, RkdIssueCode = 185149.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US05348Y1055', RkdTicker = 'AVLN', RkdSEDOL = 'BNZGT6', RkdCUSIP = '05348Y10', RkdRIC = 'AVLN.O', RkdDisplayRIC = 'AVLN.OQ', RkdCode = 144771.0, RkdIssueID = 1.0, RkdIssueCode = 185148.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295064 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG629801264', RkdTicker = 'MCAHU', RkdSEDOL = 'BNZGTW', RkdCUSIP = 'G6298012', RkdRIC = 'MCAHU.O', RkdDisplayRIC = 'MCAHU.OQ', RkdCode = 144796.0, RkdIssueID = 1.0, RkdIssueCode = 185175.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295152 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG770AL1119', RkdTicker = 'RREVU', RkdSEDOL = 'BNZGTH', RkdCUSIP = 'G770AL11', RkdRIC = 'RREVU.O', RkdDisplayRIC = 'RREVU.OQ', RkdCode = 144770.0, RkdIssueID = 1.0, RkdIssueCode = 185147.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295153 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US4202011056', RkdTicker = 'HAWK', PermIDTicker = 'HAWK', RkdSEDOL = 'BX566N', RkdCUSIP = '42020110', RkdRIC = 'HAWK.K', RkdDisplayRIC = 'HAWK.N', RkdCode = 144773.0, RkdIssueID = 1.0, RkdIssueCode = 185150.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '', QuotePermID = 236806601937.0, InstrPermID = 232929761055.0, OrgPermID = 5052530356.0, PriInstrPermID = 232929761055.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'NA', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951182.0, PermOrgIPODate = '2026-05-07', PermSecMapStartDate = '2026-05-05', startDate = '2026-05-05' WHERE SecCode = 11295445 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG7315L1014', RkdTicker = 'QRED', RkdSEDOL = 'BX695M', RkdCUSIP = 'G7315L10', RkdRIC = 'QRED.K', RkdDisplayRIC = 'QRED.N', RkdCode = 142970.0, RkdIssueID = 1.0, RkdIssueCode = 182517.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11295486 AND Type_ = 1;
