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 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 = 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 QuotePermID = 21571963234.0, ExchCode = 'DEU' WHERE SecCode = 2982615 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 = 21747653407.0, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-18' 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 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 endDate = '2026-10-12' WHERE SecCode = 4749885 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 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 = 236778016184.0, ExchCode = 'FRA' WHERE SecCode = 5452246 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 endDate = '2026-10-12' WHERE SecCode = 5558460 AND Type_ = 10;