UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6779 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL, PermOrgIPODate = NULL, startDate = '2005-11-15' WHERE SecCode = 9467 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 26763 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 27634 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'BQE CANT DE GENEVE CHF5(REG)' WHERE SecCode = 36418 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 PermIDTicker = 'DYH', QuotePermID = 55836326929.0, ExchCode = 'BER' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21524803142.0, ExchCode = 'DEU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-30' WHERE SecCode = 71379 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79123 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y8T33Y12' WHERE SecCode = 84503 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 85724 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6973.T^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2025-10-15', PermSecMapEndDate = '2025-10-15', endDate = '2025-10-15' WHERE SecCode = 85934 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86799 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 89663 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', startDate = '1960-01-01' WHERE SecCode = 92676 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'GREEN ENERGY GROUP HKD0.01' WHERE SecCode = 93588 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 105124 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 121067 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130761 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 132847 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-30' WHERE SecCode = 133501 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE331C01025', RkdSEDOL = 'BRBN4T', DsPrimQtSedol = 'BRBN4T3', PermSecMapEndDate = '2025-10-15', endDate = '2025-10-15' WHERE SecCode = 142568 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GOR.AX^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-15', SecMapEndDate = '2025-09-26', PermQuoteRetireDate = '2025-10-15', PermSecMapEndDate = '2025-10-15', endDate = '2025-09-26' WHERE SecCode = 145658 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 147135 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 258753 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q7322A27' WHERE SecCode = 300101 AND Type_ = 10;
UPDATE data_universe SET Name = 'MICRONET ILS1.5' WHERE SecCode = 358625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 377135 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 549141 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'G4742410' WHERE SecCode = 582997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 820840 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ISRAEL LAND DEVELO ILS0.01' WHERE SecCode = 893982 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1082174 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1177622 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NO0013683409', RkdSEDOL = 'BW5T1V', RkdCUSIP = 'R5S38812', DsPrimQtSedol = 'BW5T1V3', PermSecMapEndDate = '2025-10-15', endDate = '2025-10-15' WHERE SecCode = 1458933 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1482575 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1565080 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 1665211 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2025-10-15', PermQuoteRetireDate = '2025-10-16', endDate = '2025-10-15' WHERE SecCode = 2601968 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2671255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2807594 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y0R7Y314' WHERE SecCode = 2854268 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TRA', PermIDTicker = 'TRA', RkdRIC = 'TRA.MC', RkdDisplayRIC = 'TRA.MC' WHERE SecCode = 2946507 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 2950178 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3069157 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y2740H15' WHERE SecCode = 3109824 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3217959 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3339576 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3396317 AND Type_ = 10;
UPDATE data_universe SET Name = 'GLOBE INTERNATIONA INR5(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3396342 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CWX.AX^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-10-15', SecMapEndDate = '2025-10-09', PermQuoteRetireDate = '2025-10-15', PermSecMapEndDate = '2025-10-15', endDate = '2025-10-09' WHERE SecCode = 3408003 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3434424 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858705514.0, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04', endDate = '2023-12-29' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TSFINV', PermIDTicker = 'TSFINV', RkdRIC = 'TSFI.NS', RkdDisplayRIC = 'TSFI.NS' WHERE SecCode = 3441472 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3513957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3587036 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 3593745 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3642396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3709717 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3956797 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3968093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4095846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4099699 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'NTC.HNO^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2025-10-15', PermQuoteRetireDate = '2025-10-16', PermSecMapEndDate = '2025-10-15', endDate = '2025-10-15' WHERE SecCode = 4333240 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4337006 AND Type_ = 10;
UPDATE data_universe SET Country = 'BMU' WHERE SecCode = 4388102 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q902A010' WHERE SecCode = 4496725 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-15' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET Name = 'RICHMOND HILL RE ORD GBP0.001', PriValQuotePermID = 236797408859.0 WHERE SecCode = 4531654 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21831570623.0, ExchCode = 'DEU' WHERE SecCode = 4671288 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q9162S10' WHERE SecCode = 4777362 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'G4674M11', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4788580 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'M4628Y11' WHERE SecCode = 4867401 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET Name = 'CABASSE SA EUR0.0015' WHERE SecCode = 5257731 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q1R28A10' WHERE SecCode = 5261360 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '446750.KQ^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2025-10-15', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-15', endDate = '2025-10-15' WHERE SecCode = 5354938 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5573658 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7788.TW', RkdDisplayRIC = '7788.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5974237 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6354186 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y709P511' WHERE SecCode = 6363468 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IL0012275520', RkdTicker = 'AXN', RkdSEDOL = 'BVN7LS', RkdCUSIP = 'M1R67B10', RkdRIC = 'AXN.TA', RkdDisplayRIC = 'AXN.TA', RkdCode = 143219.0, RkdIssueID = 1.0, RkdIssueCode = 182834.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6434975 AND Type_ = 10;
UPDATE data_universe SET Name = 'KRUNG THAI BNK LTD DR1000:1', Country = 'THA' WHERE SecCode = 6450904 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0, startDate = '2023-02-09' WHERE SecCode = 6456244 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6478352 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6482679 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-10-10' WHERE SecCode = 6495238 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-10-14' WHERE SecCode = 6501036 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA14919F3051', RkdSEDOL = 'BS55HW', RkdCUSIP = '14919F30', DsPrimQtSedol = 'BS55HW6' WHERE SecCode = 11019872 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'NLTAh.V^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2023-11-07', PermQuoteRetireDate = '2025-10-16', endDate = '2023-11-07' WHERE SecCode = 11074055 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 236797407837.0, PermOrgIPODate = '2025-10-14' WHERE SecCode = 11142838 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2018-09-10', startDate = '2018-09-10' WHERE SecCode = 11189990 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'AVDX.OQ^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-16', PermQuoteRetireDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 11232126 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'ARIS.N^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-15', SecMapEndDate = '2025-10-14', PermQuoteRetireDate = '2025-10-15', PermSecMapEndDate = '2025-10-15', endDate = '2025-10-14' WHERE SecCode = 11232562 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RFLXD' WHERE SecCode = 11246784 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11257663 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG003501191', RkdSEDOL = 'BVPW8G', RkdCUSIP = 'G0035011', Name = 'LOBO TECHNOLOGIES LTD SHS', DsPrimQtSedol = 'BVPW8G9' WHERE SecCode = 11263502 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11272365 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NKLR', ModelCntry = 'IT', InfoCode = 388010, DsSecCode = 268309, DsCmpyCode = 210283, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BVBQSY3', QuotePermID = 236797033451.0, InstrPermID = 232902855427.0, OrgPermID = 5096927639.0, PriTrdQuotePermID = 236797033451.0, PriValQuotePermID = 25727058136.0, PriInstrPermID = 232902855427.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', DomCntry = 'ITA', IncCntry = 'NLD', PriTRBCIndPermID = 4294951816.0, DsSecDelistDate = NULL, DsExchQtStartDate = '2025-10-10', SecMapStartDate = '2025-10-10', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-10', PermSecMapEndDate = NULL, startDate = '2025-10-10', endDate = NULL WHERE SecCode = 11273297 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11277132 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11278867 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285376 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285479 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285979 AND Type_ = 1;
