UPDATE data_universe SET Name = 'BNB PLUS CORP COM NEW' WHERE SecCode = 6067 AND Type_ = 1; UPDATE data_universe SET RkdCUSIP = 'P2283510' WHERE SecCode = 28602 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'P2283511' WHERE SecCode = 28624 AND Type_ = 10; 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 = 35857 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 43097 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 46631 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'OCG.TO', RkdDisplayRIC = 'OCG.TO', RkdExchCode = 'TSE' WHERE SecCode = 47189 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'HULT B', PermIDTicker = 'HULT B', RkdRIC = 'HULTb.ST', RkdDisplayRIC = 'HULTb.ST' WHERE SecCode = 63974 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69900 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73415 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951630.0 WHERE SecCode = 74173 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75796 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79218 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80292 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80487 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80552 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000427775', RkdTicker = 'VAUDA', PermIDTicker = 'VAUDA', RkdSEDOL = 'BW9MJ3', RkdRIC = 'VAUDA.AX', RkdDisplayRIC = 'VAUDA.AX', DsPrimQtSedol = 'BW9MJ36', SecMapEndDate = '2025-11-16', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-16' WHERE SecCode = 80875 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 82172 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83476 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84605 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-11-16', endDate = '2025-11-14' WHERE SecCode = 85724 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86798 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y728DT10' WHERE SecCode = 89861 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95943 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '2002-07-29' WHERE SecCode = 96658 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97012 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 98521 AND Type_ = 10; UPDATE data_universe SET Name = 'SBI SHINSEI BANK NPV', DsPrimQtSedol = NULL, QuotePermID = 236798897434.0, InstrPermID = 232908273981.0, PriValQuotePermID = 236798897434.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-11-17', PermSecMapEndDate = NULL, startDate = '2004-02-19' WHERE SecCode = 105303 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 = 113508 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115323 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115341 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Q8840N22' WHERE SecCode = 115415 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = NULL WHERE SecCode = 132080 AND Type_ = 10; UPDATE data_universe SET Name = 'SYNTHIKO FOILS LTD INR1', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 135123 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 294232 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 348329 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 348331 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU000000TMK7', RkdTicker = 'TMK', PermIDTicker = 'TMK', RkdSEDOL = 'B4NKTX', RkdCUSIP = 'Q8842U31', RkdRIC = 'TMK.AX', RkdDisplayRIC = 'TMK.AX', DsPrimQtSedol = 'B4NKTX0' WHERE SecCode = 391897 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 602158 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'CLEANAWAY COMPANY TWD1' WHERE SecCode = 858263 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 1441935 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'VAUDA', DsPrimQtSedol = 'BW9MJ36' WHERE SecCode = 1472062 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1534927 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 1535918 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1641477 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1694231 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 = 'A' WHERE SecCode = 2238141 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2238143 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 2257471 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-11-14', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-11-16', endDate = '2025-11-14' WHERE SecCode = 2465108 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'QLOSRb.ST^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-18', SecMapEndDate = '2025-11-17', PermQuoteRetireDate = '2025-11-18', PermSecMapEndDate = '2025-11-18', endDate = '2025-11-17' WHERE SecCode = 2465135 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'MCLSM.L^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-18', SecMapEndDate = '2022-11-02', PermQuoteRetireDate = '2025-11-18', PermSecMapEndDate = '2025-11-18', endDate = '2022-11-02' WHERE SecCode = 2510706 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TMK', DsPrimQtSedol = 'B4NKTX0' WHERE SecCode = 2529648 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 2727841 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 2727862 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 2894535 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3057588 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-14' WHERE SecCode = 3247374 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951737.0 WHERE SecCode = 3315885 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3339794 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'ALCODIS', PermIDTicker = 'ALCODIS', RkdRIC = 'ALCK.NS', RkdDisplayRIC = 'ALCK.NS' WHERE SecCode = 3396339 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 3403843 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TMK', DsPrimQtSedol = 'B4NKTX0' WHERE SecCode = 3972133 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3999398 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4001158 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'DEUTSCHE ACCESS IN ADS' WHERE SecCode = 4106545 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 4291597 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4339156 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 DsCtryQtStatus = 'A' WHERE SecCode = 4415699 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-11-17' WHERE SecCode = 4511509 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-14' WHERE SecCode = 4540765 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'APPHG.DE^K25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-11-17', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 4588499 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4597210 AND Type_ = 10; UPDATE data_universe SET Name = 'BEYON 3D LTD ILS0.003(POST CONS)' WHERE SecCode = 4610012 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BP4YF96' WHERE SecCode = 4754728 AND Type_ = 10; UPDATE data_universe SET RkdTicker = '2POINTZERO', PermIDTicker = '2POINTZERO', RkdRIC = '2POINTZERO.AD', RkdDisplayRIC = '2POINTZERO.AD' WHERE SecCode = 4794514 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4925656 AND Type_ = 10; UPDATE data_universe SET Name = 'KRONA PUBLIC REAL NPV' WHERE SecCode = 4956706 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 5059330 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5102746 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5115507 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142544 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5189080 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5230201 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-10-22', PermSecMapEndDate = '2025-11-16', endDate = '2025-10-22' WHERE SecCode = 5276216 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5450871 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-14' WHERE SecCode = 5584112 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 5600657 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = NULL WHERE SecCode = 5601206 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 232835164248.0 WHERE SecCode = 5632180 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '7786.TW', RkdDisplayRIC = '7786.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5968995 AND Type_ = 10; UPDATE data_universe SET DsExchMnem = 'NGO', DsExchQtStartDate = '2025-11-17', SecMapStartDate = '2025-11-17', PermSecMapStartDate = '2025-11-17', PermSecMapEndDate = NULL, startDate = '2024-11-14', endDate = NULL WHERE SecCode = 5996607 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'NL0015002K83', RkdSEDOL = 'BVD9FN', RkdCUSIP = 'N8T24211', DsPrimQtSedol = 'BVD9FN8', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 6039875 AND Type_ = 10; UPDATE data_universe SET Name = 'NETFLIX INC DR (1000:1) NETFLIX INC' WHERE SecCode = 6272211 AND Type_ = 10; UPDATE data_universe SET DsSecDelistDate = '2025-11-18', endDate = '2025-11-18' WHERE SecCode = 6308568 AND Type_ = 10; UPDATE data_universe SET Name = 'KIATNAKIN PHATRA S DR 1000:1 NETFLIX INC.' WHERE SecCode = 6316545 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6325222 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6474420 AND Type_ = 10; UPDATE data_universe SET Name = 'KIATNAKIN PHATRA S DR5000:1 CROWDSTRIKE HOLDIN', Country = 'THA' WHERE SecCode = 6476475 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-18', SecMapEndDate = '2025-11-17', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-17' WHERE SecCode = 6497440 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6513037 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE1TAE01010', RkdTicker = 'TMCV', RkdSEDOL = 'BSNRFT', RkdCUSIP = 'Y8T4YR10', RkdRIC = 'TATM.NS', RkdDisplayRIC = 'TATM.NS', RkdCode = 143509.0, RkdIssueID = 1.0, RkdIssueCode = 183222.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6524546 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6538872 AND Type_ = 10; UPDATE data_universe SET Name = 'KRUNG THAI BNK LTD DR 1000:1' WHERE SecCode = 6548045 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA03090L1085', RkdTicker = 'AMCO', RkdSEDOL = 'BMDPSK', RkdCUSIP = '03090L10', RkdRIC = 'AMCO.V', RkdDisplayRIC = 'AMCO.V', DsPrimQtSedol = 'BMDPSK1' WHERE SecCode = 10902375 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2025-11-17' WHERE SecCode = 10965391 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2012-03-27' WHERE SecCode = 11025050 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11026293 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'TDAY', RkdRIC = 'TDAY.K', RkdDisplayRIC = 'TDAY.N', Name = 'USA TODAY CO INC COM' WHERE SecCode = 11128102 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2025-11-17' WHERE SecCode = 11133656 AND Type_ = 1; UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 11145550 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-14' WHERE SecCode = 11150425 AND Type_ = 1; UPDATE data_universe SET SecMapEndDate = '2025-10-31', PermSecMapEndDate = '2025-11-17', endDate = '2025-10-31' WHERE SecCode = 11160338 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET Name = 'AEGIS CRITICAL ENERGY DEFENC COM', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11189388 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2025-11-17' WHERE SecCode = 11199686 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11209070 AND Type_ = 1; UPDATE data_universe SET SecMapEndDate = '2025-11-14', PermSecMapEndDate = '2025-11-17', endDate = '2025-11-14' WHERE SecCode = 11210761 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217696 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11219153 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11225910 AND Type_ = 1; UPDATE data_universe SET RkdCUSIP = 'G8267K30' WHERE SecCode = 11235178 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US00503R5081', RkdSEDOL = 'BLGXLP', RkdCUSIP = '00503R50', DsPrimQtSedol = 'BLGXLP1' WHERE SecCode = 11241826 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'WBG', RkdRIC = 'WBG.CD', RkdDisplayRIC = 'WBG.CD' WHERE SecCode = 11245791 AND Type_ = 1; UPDATE data_universe SET SecMapEndDate = '2025-07-15', PermSecMapEndDate = '2025-11-17', endDate = '2025-07-15' WHERE SecCode = 11255021 AND Type_ = 1; UPDATE data_universe SET SecMapEndDate = '2025-07-15', PermSecMapEndDate = '2025-11-17', endDate = '2025-07-15' WHERE SecCode = 11256445 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11285908 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11287404 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PVS.PR.V', QuotePermID = 236798769577.0, InstrPermID = 232906874136.0, OrgPermID = 4295860712.0, PriValQuotePermID = 236798769577.0, PriInstrPermID = 192882307903.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '2015-10-29', PermSecMapStartDate = '2025-11-12', startDate = '2025-11-12' WHERE SecCode = 11288102 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11288113 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11288185 AND Type_ = 1;