UPDATE data_universe SET PermIDTicker = 'ATV.L', QuotePermID = 21475526216.0, ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 364 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PZQAi', QuotePermID = 21511986900.0, ExchCode = 'BTE', PermQuoteRetireDate = '2013-07-08', endDate = '2013-07-08' WHERE SecCode = 1807 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474899459.0, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02', endDate = '2010-07-02' WHERE SecCode = 10135 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475450492.0, ExchCode = 'BEC' WHERE SecCode = 28192 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838830955.0, ExchCode = 'BEC' WHERE SecCode = 28657 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ANFP.I', QuotePermID = 21475586638.0, ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'WLVG.I', QuotePermID = 21475586117.0, ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34242 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492516206.0, ExchCode = 'STU' WHERE SecCode = 35642 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BIBd', QuotePermID = 21475113523.0, ExchCode = 'EQD', PermQuoteRetireDate = '2013-03-21' WHERE SecCode = 35717 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21523788402.0, ExchCode = 'CHI' WHERE SecCode = 35857 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ILH', QuotePermID = 21475581963.0, ExchCode = 'HAN', PermQuoteRetireDate = '2007-09-12', endDate = '2007-09-12' WHERE SecCode = 35941 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475422367.0, ExchCode = 'DUS', PermQuoteRetireDate = '2006-06-05', endDate = '2006-06-02' WHERE SecCode = 36125 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475360133.0, ExchCode = 'STU' WHERE SecCode = 39970 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'INVN.I', QuotePermID = 21475591267.0, ExchCode = 'CSS', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 42094 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'YZAi', QuotePermID = 21474865386.0, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02' WHERE SecCode = 42203 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RTRKSh', QuotePermID = 21474859088.0, ExchCode = 'HFT', PermQuoteRetireDate = '2014-05-02', endDate = '2014-05-02' 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 QuotePermID = 55837361864.0, ExchCode = 'GER' WHERE SecCode = 46439 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21526380304.0, ExchCode = 'CHI' WHERE SecCode = 47172 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475389827.0, ExchCode = 'BER' WHERE SecCode = 47266 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475051252.0, ExchCode = 'TDG' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474860786.0, ExchCode = 'BTE', PermQuoteRetireDate = '2019-11-01', endDate = '2019-11-01' WHERE SecCode = 49244 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21524803141.0, ExchCode = 'FRA', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSU', QuotePermID = 21475572971.0, ExchCode = 'HAN', PermQuoteRetireDate = '2007-09-12', endDate = '2007-09-12' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474946626.0, ExchCode = 'DEU' WHERE SecCode = 60874 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475422918.0, ExchCode = 'GER', PermQuoteRetireDate = '2002-08-27', PermSecMapEndDate = '1999-09-11', endDate = '1999-09-11' WHERE SecCode = 60880 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PSF.I', QuotePermID = 21475581196.0, ExchCode = 'CML', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 62335 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7709.T^J26', RkdIssueStatus = 0.0 WHERE SecCode = 79000 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79132 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86340 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CPNT.I', QuotePermID = 21475535230.0, ExchCode = 'CST', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 113625 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21850698720.0, ExchCode = 'DUS', PermQuoteRetireDate = '2023-10-18' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21548011121.0, ExchCode = 'STU' WHERE SecCode = 184361 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DOCK.I', QuotePermID = 21475510665.0, ExchCode = 'COO', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 196096 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21617621751.0, ExchCode = 'MCD' WHERE SecCode = 390099 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21653403679.0, ExchCode = 'FRA' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'URKAn', QuotePermID = 21642369635.0, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL, endDate = '2022-12-14' WHERE SecCode = 555865 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'POLY.GB', QuotePermID = 21477404722.0, ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17', endDate = '2012-01-17' WHERE SecCode = 1453952 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21479505819.0, ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17', endDate = '2012-01-17' WHERE SecCode = 1472965 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21529230543.0, ExchCode = 'HKG', PermQuoteRetireDate = '2020-11-13', endDate = '2018-08-10' WHERE SecCode = 2343144 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21533733328.0, ExchCode = 'STO', PermQuoteRetireDate = '2018-10-18' WHERE SecCode = 2438937 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21539340100.0, ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 2530826 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21560857303.0, ExchCode = 'FRA' WHERE SecCode = 2855772 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21656680093.0, ExchCode = 'BIV' WHERE SecCode = 2934154 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PNEUMATIC', QuotePermID = 21572076101.0, ExchCode = 'INC' WHERE SecCode = 2983749 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21596926507.0, ExchCode = 'DEU' WHERE SecCode = 3247790 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21598409269.0, ExchCode = 'FRA' WHERE SecCode = 3260114 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21623235806.0, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-27', endDate = '2022-06-27' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470839.0, ExchCode = 'DEU', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LGRSl', QuotePermID = 21693145541.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 3818837 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21766464303.0, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2023-02-07', endDate = '2023-02-07' WHERE SecCode = 3837240 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4010770 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21766027156.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2025-10-23' WHERE SecCode = 4338899 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21800722506.0, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21820741604.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-10' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AURAo', QuotePermID = 236791725077.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-13' WHERE SecCode = 4640279 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PYRUMo', QuotePermID = 236787861852.0, ExchCode = 'BCO' WHERE SecCode = 4726082 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TMTAl', QuotePermID = 21848685830.0, ExchCode = 'BCO', PermQuoteRetireDate = '2024-06-27' WHERE SecCode = 4735056 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SIGNUs', QuotePermID = 21858693058.0, ExchCode = 'BCO', PermQuoteRetireDate = '2023-09-26' WHERE SecCode = 4781670 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0017084361', RkdTicker = 'VIVA', RkdSEDOL = 'BMG4XS', RkdCUSIP = 'W9821R10', RkdRIC = 'VIVA.ST^I26', RkdDisplayRIC = 'VIVA.ST', RkdCode = 131562.0, RkdIssueID = 1.0, RkdIssueCode = 166912.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE' WHERE SecCode = 4806550 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236787711124.0, ExchCode = 'BCO' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21871506212.0, ExchCode = 'EBT', PermQuoteRetireDate = '2023-06-08' WHERE SecCode = 4865336 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21890440366.0, ExchCode = 'DEU' WHERE SecCode = 4989623 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CREGm', QuotePermID = 21954311219.0, ExchCode = 'BCO' WHERE SecCode = 5354972 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778101323.0, ExchCode = 'FRA' WHERE SecCode = 5457246 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778518455.0, ExchCode = 'FRA' WHERE SecCode = 5482616 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA29643A1093', RkdTicker = 'ESKR', RkdSEDOL = 'BWJGXS', RkdCUSIP = '29643A10', RkdRIC = 'ESKR.V', RkdDisplayRIC = 'ESKR.V', RkdCode = 92227.0, RkdIssueID = 1.0, RkdIssueCode = 116048.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 11105030 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US98585L1008', RkdTicker = 'YRD', RkdSEDOL = 'BYPHX2', RkdCUSIP = '98585L10', RkdRIC = 'YRD', RkdDisplayRIC = 'YRD.N', RkdCode = 105750.0, RkdIssueID = 1.0, RkdIssueCode = 132988.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'ADR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', ShPerListing = 2.0 WHERE SecCode = 11155145 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-10-02', endDate = '2026-10-02' WHERE SecCode = 11231619 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US6293JP1094', RkdSEDOL = 'BPBLY2', RkdCUSIP = '6293JP10', RkdRIC = 'NSTS.OQ^J26', RkdDisplayRIC = 'NSTS.OQ', RkdCode = 130284.0, RkdIssueID = 1.0, RkdIssueCode = 165255.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11237224 AND Type_ = 1;