UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 16723 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASSERTIO HOLDINGS INC COM NEW', PermSecMapEndDate = '2026-06-17' WHERE SecCode = 19506 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 44556 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 45221 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 51199 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdRIC = '4659.T^F26', RkdDisplayRIC = '4659.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-19', SecMapEndDate = '2026-06-18', endDate = '2026-06-18' WHERE SecCode = 67906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68572 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75847 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76411 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78826 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BYW3ZW', Name = 'NOVA MINLS CORP CDI 12:1', Country = 'USA', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BYW3ZW1', SecMapEndDate = '2079-06-06' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-09' WHERE SecCode = 84806 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 86967 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87939 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MIECO BHD NPV' WHERE SecCode = 89539 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2008-08-01' WHERE SecCode = 90135 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90658 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ONIDA' WHERE SecCode = 93697 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 95865 AND Type_ = 1;
UPDATE data_universe SET Name = 'MACKENZIE MASTER LP UNIT LTD PART', SecMapStartDate = '1995-06-30', startDate = '1995-06-30' WHERE SecCode = 96306 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '9927.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', IncCntry = NULL, DsSecDelistDate = '2026-06-19', SecMapEndDate = '2026-06-18', endDate = '2026-06-18' WHERE SecCode = 98717 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'RUP.TO^F26', RkdIssueStatus = 0.0, PermSecMapEndDate = '2026-06-18' WHERE SecCode = 98901 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-18', SecMapEndDate = '2026-06-17', PermSecMapEndDate = '2026-06-17', endDate = '2026-06-17' WHERE SecCode = 99171 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 113906 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 123563 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BTJTP05' WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 197824 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 214165 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 322278 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 357924 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 536888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 643063 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1218409 AND Type_ = 10;
UPDATE data_universe SET Name = 'VERVE GROUP MEDIA SER''A''EUR1' WHERE SecCode = 1241411 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2011-09-15' WHERE SecCode = 1399023 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1569390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 2727836 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CAP' WHERE SecCode = 2830908 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ANHUI YINGJIAGONGJ A CNY1' WHERE SecCode = 2894536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 3213357 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951938.0 WHERE SecCode = 3225482 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3318165 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 = 4294951988.0 WHERE SecCode = 3402106 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 3402815 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 3407835 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3529092 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3693296 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 4613101 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 DsCtryQtStatus = 'A', DsPrimQtSedol = 'BYW3ZW1' WHERE SecCode = 4798367 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4808847 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOMAD COMPUTE PLC ORD GBP0.0001' WHERE SecCode = 5067274 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5264846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5383312 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-18', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-17' WHERE SecCode = 5581593 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 5693829 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXFJ7P6' WHERE SecCode = 5969252 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCHINDLER-HLDG AG CHF0.1 2 LINIE' WHERE SecCode = 5983576 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCHINDLER-HLDG AG CHF0.1 2 LINIE NOV 2024' WHERE SecCode = 5983577 AND Type_ = 10;
UPDATE data_universe SET Name = 'COX INFRSTR GP SA EUR0.1' WHERE SecCode = 5999072 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6123552 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6377032 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6385615 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6387693 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6389715 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6403367 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6414074 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6440004 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6478352 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6583658 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6626020 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6752845 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6772977 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 126258.0, RelType = 4.0 WHERE SecCode = 6813227 AND Type_ = 10;
UPDATE data_universe SET Name = 'COMMERZBANK AG NPV (ASD 3/7/26 UNCED SHRE' WHERE SecCode = 6846732 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000465338', RkdTicker = 'KTK', RkdSEDOL = 'BW9GS8', RkdCUSIP = 'Q5376810', RkdRIC = 'KTK.AX', RkdDisplayRIC = 'KTK.AX', RkdCode = 145038.0, RkdIssueID = 1.0, RkdIssueCode = 185557.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6854786 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 145014.0 WHERE SecCode = 6908111 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE1V1R01014', RkdTicker = 'UTKAL', RkdCUSIP = 'Y931CX10' WHERE SecCode = 6923705 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-06-17' WHERE SecCode = 6923746 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0, DsExchQtStartDate = '2026-06-17' WHERE SecCode = 6923751 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2008-10-03' WHERE SecCode = 10781932 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 11133200 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWL8QP3' WHERE SecCode = 11142037 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HAPN', ExchCode = 'NSM' WHERE SecCode = 11142751 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 11144792 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIODEXA PHARMACEUTICALS PLC SPON ADS RP 50' WHERE SecCode = 11154766 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRSBT84', SecMapEndDate = '2026-06-17', endDate = '2026-06-17' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FIRY' WHERE SecCode = 11207267 AND Type_ = 1;
UPDATE data_universe SET Name = 'PURECYCLE TECHNOLOGIES INC *W EXP 03/17/2027' WHERE SecCode = 11208793 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11233216 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-17' WHERE SecCode = 11241243 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KAZR' WHERE SecCode = 11274212 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11274684 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11279159 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11281385 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-08', endDate = '2026-05-07' WHERE SecCode = 11281412 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232927312177.0 WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232926623209.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11295026 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232931453854.0 WHERE SecCode = 11295027 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11296648 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LILAP' WHERE SecCode = 11296654 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808503555.0, ExchCode = 'NYS', PermSecMapStartDate = '2026-06-16', startDate = '2026-06-09' WHERE SecCode = 11297252 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-06-10' WHERE SecCode = 11297255 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 47767465140.0, ExchCode = 'NSM', PermSecMapStartDate = '2026-06-16', startDate = '2026-06-12' WHERE SecCode = 11297328 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11297513 AND Type_ = 1;
