UPDATE data_universe SET PermIDTicker = 'KFXl', QuotePermID = 21475788761.0, ExchCode = 'BTE', PermQuoteRetireDate = '2015-03-31', endDate = '2015-03-30' WHERE SecCode = 3735 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 6167 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 6168 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 7749 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US15130G8657', RkdSEDOL = 'BXM5CM', RkdCUSIP = '15130G86', DsPrimQtSedol = 'BXM5CM9' WHERE SecCode = 12961 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-04', PermSecMapEndDate = '2026-06-04' WHERE SecCode = 27805 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 28992 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951330.0 WHERE SecCode = 29505 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951330.0 WHERE SecCode = 29506 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-01', SecMapEndDate = '2026-06-02' WHERE SecCode = 32631 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PPLI' WHERE SecCode = 34455 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951931.0 WHERE SecCode = 41709 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951931.0 WHERE SecCode = 41710 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 42270 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 42271 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 42272 AND Type_ = 1;
UPDATE data_universe SET Name = 'STOCKWIK FORVALTNI NPV' WHERE SecCode = 45389 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 55846120871.0, ExchCode = 'CPH', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-04' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'D1176028' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365429.0 WHERE SecCode = 54693 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'OSR' WHERE SecCode = 60083 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA8119271028', RkdSEDOL = 'BW5VLW', RkdCUSIP = '81192710', DsPrimQtSedol = 'BW5VLW0' WHERE SecCode = 68823 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8321545043', RkdSEDOL = 'BXM75Z', RkdCUSIP = '83215450', DsPrimQtSedol = 'BXM75Z9' WHERE SecCode = 70172 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 73192 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q0267618', Name = 'ALTERITY THERAPEUT NPV DFD 11/06/26(EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 75379 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 76235 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 77276 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 77277 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 78958 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 80322 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951257.0 WHERE SecCode = 82051 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951170.0 WHERE SecCode = 82632 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000469710', RkdTicker = 'NVADC', PermIDTicker = 'NVADC', RkdSEDOL = 'BVMFMT', RkdRIC = 'NVADC.AX', RkdDisplayRIC = 'NVADC.AX', RkdListingType = 'EDR', ShPerListing = 0.0, PrimaryIssueCode = NULL, QuoteClass = 'CHESS', InstrClass = 'CHESS', PermSecMapEndDate = '2026-06-04', endDate = '2026-06-04' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q1714E20' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 84491 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951879.0 WHERE SecCode = 84752 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951931.0 WHERE SecCode = 85224 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 85577 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 85641 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 85832 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 85929 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 89199 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90338 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 90785 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951512.0 WHERE SecCode = 91038 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 91436 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 93710 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951929.0 WHERE SecCode = 94311 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA92767B2049', RkdSEDOL = 'BV3PZT', RkdCUSIP = '92767B20', DsPrimQtSedol = 'BV3PZT2', SecMapEndDate = '2026-06-03', endDate = '2026-06-03' WHERE SecCode = 95324 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 95423 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96193 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 96819 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 97833 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 97843 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951897.0 WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 98237 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 98274 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'POPB.BO', RkdDisplayRIC = 'POPB.BO' WHERE SecCode = 116617 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 141851 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 145652 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'E2NG.H', RkdDisplayRIC = 'E2NG.H', RkdIssueStatus = 1.0, RkdExchCode = 'HAM' WHERE SecCode = 146206 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 146277 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55856245271.0, ExchCode = 'DUS', PermQuoteRetireDate = '2018-11-14', endDate = '2018-11-13' WHERE SecCode = 147917 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 176521 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SHUAIBA', RkdRIC = 'SHUAIBA.KW', RkdDisplayRIC = 'SHUAIBA.KW' WHERE SecCode = 243506 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 283838 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 286911 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ZEFG.H', RkdDisplayRIC = 'ZEFG.H', RkdIssueStatus = 1.0, RkdExchCode = 'HAM', PriValQuotePermID = 55838777196.0 WHERE SecCode = 301431 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 329547 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 334844 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN', IncCntry = 'CAN' WHERE SecCode = 376085 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 376139 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 390333 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 438759 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 620020 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 690431 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 787290 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 850990 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 852952 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 887451 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 1109069 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CRAR.BO', RkdDisplayRIC = 'CRAR.BO' WHERE SecCode = 1204807 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 1347567 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 1411535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 1420636 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951929.0 WHERE SecCode = 1996530 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ENER.MI^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-05', SecMapEndDate = '2022-06-15', endDate = '2022-06-15' WHERE SecCode = 2189779 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 2375338 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 2380623 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2536054 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951783.0 WHERE SecCode = 2635724 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951191.0 WHERE SecCode = 2648275 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2698375 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2702970 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951703.0 WHERE SecCode = 2727861 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951369.0 WHERE SecCode = 2868655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2909235 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2914936 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2016-02-19' WHERE SecCode = 2945288 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951170.0 WHERE SecCode = 2947932 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 2959625 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3022416 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '230980.KQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-04', PermQuoteRetireDate = '2026-06-05', endDate = '2026-06-04' WHERE SecCode = 3101370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3120762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3207291 AND Type_ = 10;
UPDATE data_universe SET Name = 'OPTIMUM RE SPAIN S EUR2.86' WHERE SecCode = 3247303 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3256348 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2016-12-01' WHERE SecCode = 3275877 AND Type_ = 10;
UPDATE data_universe SET Name = 'PROCREDIT HOLDING EUR5' WHERE SecCode = 3285103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3318059 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdCUSIP = 'Q4978J15', Name = 'I SYNERGY GROUP NPV DFD 12/06/26 (EX-SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3319350 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 PriTRBCIndPermID = 4294951377.0 WHERE SecCode = 3363509 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'B4B0', Name = 'METRO AG NPV(REG)' WHERE SecCode = 3376114 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'B4B1', Name = 'METRO AG PREF (REG)' WHERE SecCode = 3376117 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3379538 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951170.0 WHERE SecCode = 3385186 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951225.0, DsExchQtStartDate = '2017-09-18', startDate = '2017-09-15' WHERE SecCode = 3394128 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 3401653 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3441472 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE255Z01027', RkdSEDOL = 'BWMWQK', RkdCUSIP = 'Y2R4CA12', DsPrimQtSedol = 'BWMWQK9', PermSecMapEndDate = '2026-06-04', endDate = '2026-06-04' WHERE SecCode = 3497959 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3516773 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3587034 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3675449 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365432.0 WHERE SecCode = 3707990 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 3918940 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951723.0 WHERE SecCode = 3966485 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 4054294 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-04' WHERE SecCode = 4129789 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 4211734 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 4362647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4365041 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 4381181 AND Type_ = 10;
UPDATE data_universe SET Name = 'PEOPLE INC BDR EACH 20 REPR 1 COM NPV' WHERE SecCode = 4382896 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 125741.0 WHERE SecCode = 4425536 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951801.0 WHERE SecCode = 4546436 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NVADC', QuoteClass = 'CHESS', InstrClass = 'CHESS' WHERE SecCode = 4798367 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4844932 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 4868616 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4952493 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5067274 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-04' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 5168281 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 5168302 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5264846 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951343.0 WHERE SecCode = 5269452 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 5454695 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951410.0 WHERE SecCode = 5669491 AND Type_ = 10;
UPDATE data_universe SET Name = 'PUB PROP INV ASA NPV', Country = 'NOR' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 5848665 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'THA' WHERE SecCode = 5987843 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6291863 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 6361848 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6400757 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 6418152 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 6429307 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 6567895 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y4774N10' WHERE SecCode = 6802674 AND Type_ = 10;
UPDATE data_universe SET Name = 'PPI PUB PROP INV A NPV', Country = 'SWE' WHERE SecCode = 6870728 AND Type_ = 10;
UPDATE data_universe SET Name = 'AI REV ASSISTANT S NPV' WHERE SecCode = 6893660 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232905519213.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6893661 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BSTG', QuotePermID = 236807899027.0, InstrPermID = 232938153138.0, OrgPermID = 5073671377.0, PriValQuotePermID = 236807899027.0, PriInstrPermID = 232938153138.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TLV', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'ISR', IncCntry = 'ISR', PriTRBCIndPermID = 4294951812.0, PermOrgIPODate = '2026-06-03', PermSecMapStartDate = '2026-06-02', startDate = '2026-06-02' WHERE SecCode = 6893665 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CSX', RkdRIC = 'CSX.V', RkdDisplayRIC = 'CSX.V', RkdExchCode = 'CVE' WHERE SecCode = 11012454 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = '3ST0', RkdSEDOL = 'BX74SG', RkdRIC = '3ST0.F', RkdDisplayRIC = '3ST0.F', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 11024402 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11045356 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951320.0 WHERE SecCode = 11148378 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11149260 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 11149566 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 11149568 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = 'CTX.TO^F26', RkdDisplayRIC = 'CTX.TO^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-05', PermQuoteRetireDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 11157118 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11169713 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951320.0 WHERE SecCode = 11176665 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA45674Q4097', RkdSEDOL = 'BXM7BN', RkdCUSIP = '45674Q40', DsPrimQtSedol = 'BXM7BN9' WHERE SecCode = 11181696 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA23126M3003', RkdSEDOL = 'BXM7BL', RkdCUSIP = '23126M30', DsPrimQtSedol = 'BXM7BL7' WHERE SecCode = 11183460 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 11200228 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 11201757 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951320.0 WHERE SecCode = 11202377 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5095937906.0, PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11212363 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 11213191 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11234420 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 21841738796.0 WHERE SecCode = 11245859 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 11256250 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951320.0 WHERE SecCode = 11257020 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951320.0 WHERE SecCode = 11257021 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 125741.0, RelType = 1.0 WHERE SecCode = 11260395 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2024-08-29', startDate = '2024-08-29' WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11289468 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 11292663 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232902122712.0 WHERE SecCode = 11295229 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'IE0003YHD8K8', RkdTicker = 'OCTV', RkdSEDOL = 'BRJHXG', RkdCUSIP = 'G2284510', RkdRIC = 'OCTV.O', RkdDisplayRIC = 'OCTV.OQ', RkdCode = 144982.0, RkdIssueID = 1.0, RkdIssueCode = 185454.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11296310 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232911343828.0 WHERE SecCode = 11296373 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AADX', QuotePermID = 236807061825.0, InstrPermID = 232935365278.0, OrgPermID = 5097052118.0, PriTrdQuotePermID = 236807061825.0, PriValQuotePermID = 25727022553.0, PriInstrPermID = 232935365278.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951866.0, PermOrgIPODate = '2026-06-03', PermSecMapStartDate = '2026-05-30', startDate = '2026-05-30' WHERE SecCode = 11296851 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AESPU', QuotePermID = 236797942498.0, InstrPermID = 232905637317.0, OrgPermID = 5096956708.0, PriTrdQuotePermID = 236797942498.0, PriValQuotePermID = 25727049405.0, PriInstrPermID = 232905637317.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-03', PermSecMapStartDate = '2025-12-22', startDate = '2025-12-22' WHERE SecCode = 11296943 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11296944 AND Type_ = 1;