UPDATE data_universe SET Name = 'BFC CAPITAL TRUST II PFD TR 7.20%' WHERE SecCode = 7658 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OMUB', QuotePermID = 21475099510.0, ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14', endDate = '2013-12-14' WHERE SecCode = 10135 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'WCW.L^C26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-04' WHERE SecCode = 12664 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA68237J2092', RkdSEDOL = 'BVWQGP', RkdCUSIP = '68237J20', DsPrimQtSedol = 'BVWQGP9' WHERE SecCode = 35648 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 46170 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-03' WHERE SecCode = 46879 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-03-03' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 52483 AND Type_ = 10;
UPDATE data_universe SET Name = 'PLUG PWR INC COM NEW' WHERE SecCode = 56343 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 62057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67020 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 69369 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 70634 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73025 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-24' WHERE SecCode = 75052 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000458002', RkdTicker = 'ASPDA', PermIDTicker = 'ASPDA', RkdSEDOL = 'BWGBL1', RkdRIC = 'ASPDA.AX', RkdDisplayRIC = 'ASPDA.AX', DsPrimQtSedol = 'BWGBL18' WHERE SecCode = 75796 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80552 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80617 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCHOOLBLAZER LTD NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 82262 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83586 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '0230.HK^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-04', SecMapEndDate = '2026-03-03', endDate = '2026-03-03' WHERE SecCode = 86370 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SAUDI ENERGY COMP SAR10' WHERE SecCode = 87387 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90115 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90117 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-03' WHERE SecCode = 90997 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GDI.TO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-04', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-04' WHERE SecCode = 91135 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93121 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'IFX.V^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-04', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-04' WHERE SecCode = 95226 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 96110 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA54019J1049', RkdSEDOL = 'BVWQGR', RkdCUSIP = '54019J10', DsPrimQtSedol = 'BVWQGR1' WHERE SecCode = 99667 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 111776 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 111783 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115343 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q7S43M23' WHERE SecCode = 142703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 334731 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 334732 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 529633 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 529635 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'HVX.HM^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-04', SecMapEndDate = '2026-03-03', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-03' WHERE SecCode = 826229 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1039780 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1040923 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2049301 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2200264 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2201231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2238141 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2238143 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2576985 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580244 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2581527 AND Type_ = 10;
UPDATE data_universe SET Name = 'OMANSH ENTERPRISES INR2 (POST SPLT)' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NZMPGE0003S1', RkdSEDOL = 'BSHWM3', DsPrimQtSedol = 'BSHWM31' WHERE SecCode = 2600875 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-03' WHERE SecCode = 2802740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2924590 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2924592 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2984547 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21597458276.0, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27', endDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3317567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3318927 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '8257.HK^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-04', SecMapEndDate = '2026-03-03', endDate = '2026-03-03' WHERE SecCode = 3377103 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3395183 AND Type_ = 10;
UPDATE data_universe SET Name = 'POLYFAIR HLDGS LTD HKD0.001' WHERE SecCode = 3436254 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569568 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3894832 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3989796 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4092025 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4121487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4379702 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4379704 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 4491668 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-04', endDate = '2026-03-04' WHERE SecCode = 4571432 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4788553 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4794504 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET Name = 'SHANGHAI OBIO TECH A CNY1' WHERE SecCode = 4934306 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000458739', RkdTicker = 'WRX', PermIDTicker = 'WRX', RkdSEDOL = 'BW5SWY', RkdRIC = 'WRX.AX', RkdDisplayRIC = 'WRX.AX', DsPrimQtSedol = 'BW5SWY0' WHERE SecCode = 5037315 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5383310 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5383312 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '455910.KQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-04', SecMapEndDate = '2026-03-03', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-03' WHERE SecCode = 5476899 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-05' WHERE SecCode = 5481068 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6107054 AND Type_ = 10;
UPDATE data_universe SET Name = 'SHANGHAI ZHIDA TEC CNY0.2 H' WHERE SecCode = 6495251 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM', PermOrgIPODate = '2026-01-30' WHERE SecCode = 6635229 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MRDN' WHERE SecCode = 10901634 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NSM' WHERE SecCode = 10902812 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10985531 AND Type_ = 1;
UPDATE data_universe SET Name = 'SUPERNUS PHARMACEUTICALS COM' WHERE SecCode = 11024468 AND Type_ = 1;
UPDATE data_universe SET Name = 'NORWEGIAN CRUISE LINE HLDGS SHS' WHERE SecCode = 11060676 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'M8261813' WHERE SecCode = 11066999 AND Type_ = 1;
UPDATE data_universe SET Name = 'AH RLTY TR INC COM' WHERE SecCode = 11072969 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11143084 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11154170 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BROPF', PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 11172148 AND Type_ = 1;
UPDATE data_universe SET Name = 'FORUM MARKETS INC COM SHS' WHERE SecCode = 11174115 AND Type_ = 1;
UPDATE data_universe SET Name = 'BONANZA MINING CORPORATION COM NEW' WHERE SecCode = 11174984 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET Name = 'AH RLTY TR INC 6.75% CUM PFD A' WHERE SecCode = 11197966 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'RAPT.OQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-04', SecMapEndDate = '2026-03-02', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-02' WHERE SecCode = 11198988 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe SET Name = 'PURECYCLE TECHNOLOGIES INC UNIT 06/17/2026' WHERE SecCode = 11207457 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11208743 AND Type_ = 1;
UPDATE data_universe SET Name = 'PURECYCLE TECHNOLOGIES INC *W EXP 06/17/2026' WHERE SecCode = 11208793 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'RBOT.PK', RkdDisplayRIC = 'RBOT.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-04', endDate = '2026-03-04' WHERE SecCode = 11211907 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11214016 AND Type_ = 1;
UPDATE data_universe SET Name = 'FORGE GLOBAL HOLDINGS INC COM SHS' WHERE SecCode = 11218486 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11241723 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA91839J1049', RkdTicker = 'VTEN', PermIDTicker = 'VTEN', RkdSEDOL = 'BSHX29', RkdCUSIP = '91839J10', RkdRIC = 'VTEN.V', RkdDisplayRIC = 'VTEN.V', DsPrimQtSedol = 'BSHX290', DsExchQtStartDate = '2023-10-19' WHERE SecCode = 11257615 AND Type_ = 1;
UPDATE data_universe SET Name = 'BNP PARIBAS CDN DEPOSI REG S' WHERE SecCode = 11285148 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11290900 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291254 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA87614Y2096', RkdSEDOL = 'BV6G74', RkdCUSIP = '87614Y20', DsPrimQtSedol = 'BV6G741' WHERE SecCode = 11292601 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SUNB', QuotePermID = 236803469517.0, InstrPermID = 232902923596.0, OrgPermID = 6000024354.0, PriTrdQuotePermID = 236803469517.0, PriValQuotePermID = 25727033238.0, PriInstrPermID = 232902923596.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951349.0, PermOrgIPODate = '2026-03-02', PermSecMapStartDate = '2026-02-26', startDate = '2026-02-26' WHERE SecCode = 11292663 AND Type_ = 1;
