UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CTRA.N^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2026-05-07', SecMapEndDate = '2026-05-06', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, endDate = '2026-05-06' WHERE SecCode = 11586 AND Type_ = 1;
UPDATE data_universe SET Name = 'CARNIVAL CORP LTD COMMON SHARES', Country = 'BMU' WHERE SecCode = 12512 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-06', PermSecMapEndDate = '2026-05-07', endDate = '2026-05-06' WHERE SecCode = 12513 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-07' WHERE SecCode = 32261 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-05-07' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'OSR', DomCntry = 'USA' WHERE SecCode = 56468 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 72565 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75375 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WIZ CORP INC KRW2500' WHERE SecCode = 75950 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 76090 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77529 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHASYS CO LTD KRW2000' WHERE SecCode = 78536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82138 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82559 AND Type_ = 10;
UPDATE data_universe SET Name = 'KYUNG NAM PHARM CO KRW500' WHERE SecCode = 82772 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG8406P1182', RkdSEDOL = 'BT8SXW', RkdCUSIP = 'G8406P11', DsPrimQtSedol = 'BT8SXW1' WHERE SecCode = 83518 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85941 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 86418 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GREAT NEW WAVE COM KRW2500' WHERE SecCode = 87193 AND Type_ = 10;
UPDATE data_universe SET Name = 'COSLEAGUER GLOBAL KRW2500' WHERE SecCode = 87378 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727196678.0, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '2344.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 88379 AND Type_ = 10;
UPDATE data_universe SET Name = 'ABSOLUTELY CRITICAL RES CORP COM' WHERE SecCode = 90115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA21750Y2024', RkdSEDOL = 'BT9R0R', RkdCUSIP = '21750Y20', DsPrimQtSedol = 'BT9R0R1' WHERE SecCode = 90764 AND Type_ = 1;
UPDATE data_universe SET Name = 'KOREA STEEL CO LTD KRW1000' WHERE SecCode = 93275 AND Type_ = 10;
UPDATE data_universe SET Name = 'FIYTA PRECISION TE ''A''CNY1' WHERE SecCode = 95369 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEVADA KING GOLD CORP COM NEW' WHERE SecCode = 98713 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 99989 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 101339 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 111786 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BVK55Z16', RkdSEDOL = 'BVK55Z', RkdCUSIP = 'G7398R11', DsPrimQtSedol = 'BVK55Z1' WHERE SecCode = 114317 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 114440 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126342 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LKFT' WHERE SecCode = 133510 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'LKFT', PermIDTicker = 'LKFT', RkdRIC = 'LKFT.AS', RkdDisplayRIC = 'LKFT.AS' WHERE SecCode = 133511 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140586 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BKMQQR47', RkdSEDOL = 'BKMQQR', RkdCUSIP = 'G9007U11', DsPrimQtSedol = 'BKMQQR4' WHERE SecCode = 142500 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 146379 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 165065 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 = 21798248733.0, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 192507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 194789 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21518995421.0, ExchCode = 'DEU' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 289610 AND Type_ = 10;
UPDATE data_universe SET Name = 'MANHATTAN URANIUM DISCOVERY COM' WHERE SecCode = 316714 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 320068 AND Type_ = 10;
UPDATE data_universe SET Name = 'LAKEFRONT BIOTHERAPEUTICS ADS' WHERE SecCode = 331528 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 384296 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'LCC.HNO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2025-05-30', endDate = '2025-05-30' WHERE SecCode = 683529 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CTA.HNO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2023-02-24', endDate = '2023-02-24' WHERE SecCode = 832249 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 836871 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'AVF.HNO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2023-12-08', endDate = '2023-12-08' WHERE SecCode = 873717 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IMN' WHERE SecCode = 904700 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1151656 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '139050.KQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 1254621 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779438.0, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2000130 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2360090 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2572310 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TUIN', QuotePermID = 21553466682.0, ExchCode = 'LSE', PermQuoteRetireDate = '2015-02-11' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2900880 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '217620.KQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 2911861 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VAF', RkdSEDOL = NULL, RkdRIC = 'VAF.HNO', RkdDisplayRIC = 'VAF.HNO', DsCtryQtStatus = 'A', RkdIssueStatus = 1.0, RkdExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', endDate = '2026-04-27' WHERE SecCode = 2912792 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21568326330.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08', endDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 2945279 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931857.0, ExchCode = 'BTE' WHERE SecCode = 3157265 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 Name = 'BNC KOREA INC KRW100' WHERE SecCode = 3285557 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 112451.0 WHERE SecCode = 3322264 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3386085 AND Type_ = 10;
UPDATE data_universe SET Name = 'GUIZHOU CHANHEN CH CNY1 A' WHERE SecCode = 3387571 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-05-07', PermSecMapEndDate = NULL, startDate = '2017-12-25', endDate = NULL WHERE SecCode = 3407480 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3429803 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-02-06', PermQuoteRetireDate = '2026-05-07', PermSecMapEndDate = '2026-05-07', endDate = '2026-02-06' WHERE SecCode = 3433491 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3545181 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ZINITIX CO LTD KRW500' WHERE SecCode = 3588129 AND Type_ = 10;
UPDATE data_universe SET Name = 'TS TRILLION CO LTD KRW500' WHERE SecCode = 3818857 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3818906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3881129 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 3947539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3959739 AND Type_ = 10;
UPDATE data_universe SET Name = 'CARNIVAL CORP LTD BDR EACH REPR 1 COM SHS', Country = 'BMU' WHERE SecCode = 4054210 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-06', PermQuoteRetireDate = '2026-05-07', PermSecMapEndDate = '2026-05-07', endDate = '2026-05-06' WHERE SecCode = 4054213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4124817 AND Type_ = 10;
UPDATE data_universe SET Name = 'IQUEST CO LTD KRW200' WHERE SecCode = 4491669 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4598834 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IMN' WHERE SecCode = 4648192 AND Type_ = 10;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 4780386 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 4802265 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236799418543.0, ExchCode = 'SIG' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236784380571.0, ExchCode = 'LAS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4946199 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 5013431 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236806461878.0, PermInstrStatus = 'AC' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5482613 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-06' WHERE SecCode = 5544127 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785347880.0, ExchCode = 'FRA' WHERE SecCode = 5886926 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'TAI' WHERE SecCode = 6177697 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 6324026 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IL0012370313', RkdTicker = 'PRDM', RkdSEDOL = 'BT02D7', RkdCUSIP = 'M8S57P10', RkdRIC = 'PRDM.TA', RkdDisplayRIC = 'PRDM.TA', RkdCode = 144765.0, RkdIssueID = 1.0, RkdIssueCode = 185140.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6686348 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6772975 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-04-17' WHERE SecCode = 6779471 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-05-07', PermSecMapEndDate = '2026-04-17', endDate = '2026-04-17' WHERE SecCode = 6786370 AND Type_ = 10;
UPDATE data_universe SET Name = 'KAOKO METALS LTD NPV' WHERE SecCode = 6789483 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007LJ8' WHERE SecCode = 6789485 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007LK6' WHERE SecCode = 6796788 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6802673 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007LL4' WHERE SecCode = 6820135 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 10925166 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0813793076', RkdSEDOL = 'BT9R00', RkdCUSIP = '08137930', DsPrimQtSedol = 'BT9R004' WHERE SecCode = 10934601 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA6857432059', RkdSEDOL = 'BT9QZY', RkdCUSIP = '68574320', DsPrimQtSedol = 'BT9QZY0' WHERE SecCode = 10961584 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11002308 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-09' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 11153630 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT9QSP2' WHERE SecCode = 11173442 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11183916 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA89712R3009', RkdSEDOL = 'BT9QZF', RkdCUSIP = '89712R30', DsPrimQtSedol = 'BT9QZF1' WHERE SecCode = 11186317 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11187936 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11191594 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11194627 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11206349 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US06682J6055', RkdCUSIP = '06682J60', DsPrimQtSedol = 'BT9QV86' WHERE SecCode = 11219296 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA35638E1051', RkdTicker = 'FRDM', RkdSEDOL = 'BT9QVQ', RkdCUSIP = '35638E10', RkdRIC = 'FRDM.CD', RkdDisplayRIC = 'FRDM.CD', DsPrimQtSedol = 'BT9QVQ4' WHERE SecCode = 11242346 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-06', PermSecMapEndDate = '2026-05-06' WHERE SecCode = 11251539 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11255356 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'UPERF' WHERE SecCode = 11257436 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11277843 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'APADU.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-08', SecMapEndDate = '2026-05-07' WHERE SecCode = 11281412 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 = 11293243 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232905454586.0 WHERE SecCode = 11294535 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US98386P1021', RkdTicker = 'XE', RkdSEDOL = 'BW0TQY', RkdCUSIP = '98386P10', RkdRIC = 'XE.O', RkdDisplayRIC = 'XE.OQ', RkdCode = 144768.0, RkdIssueID = 1.0, RkdIssueCode = 185145.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294934 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG717021078', RkdTicker = 'PONO', RkdSEDOL = 'BX565K', RkdCUSIP = 'G7170210', RkdRIC = 'PONO.O', RkdDisplayRIC = 'PONO.OQ', RkdCode = 144306.0, RkdIssueID = 1.0, RkdIssueCode = 184318.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295354 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VECA.U', QuotePermID = 236796891242.0, InstrPermID = 232903530782.0, OrgPermID = 5096911354.0, PriTrdQuotePermID = 236796891242.0, PriValQuotePermID = 25727058471.0, PriInstrPermID = 232903530782.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-06', PermSecMapStartDate = '2026-05-05', startDate = '2026-05-05' WHERE SecCode = 11295427 AND Type_ = 1;