UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4778 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'TGNA.N^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-20', SecMapEndDate = '2026-03-19', PermQuoteRetireDate = '2026-03-20', PermSecMapEndDate = '2026-03-20', endDate = '2026-03-19' WHERE SecCode = 29132 AND Type_ = 1;
UPDATE data_universe SET Name = 'INTELLICHECK MOBILISA INC COM NEW' WHERE SecCode = 36459 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-03-20' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-24' WHERE SecCode = 50228 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 52567 AND Type_ = 10;
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 RkdIssueStatus = 0.0 WHERE SecCode = 61585 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Country = 'HKG' WHERE SecCode = 71995 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 55036.0 WHERE SecCode = 78331 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SINGERIND', QuotePermID = 236804436684.0, ExchCode = 'NSI' WHERE SecCode = 80014 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AHL.N^B19' WHERE SecCode = 83798 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951741.0 WHERE SecCode = 85148 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 86364 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2000-12-22' WHERE SecCode = 90744 AND Type_ = 10;
UPDATE data_universe SET Name = 'WINSHEAR METALS CORP COM NEW', PermSecMapEndDate = '2026-03-20', endDate = '2026-03-20' WHERE SecCode = 94983 AND Type_ = 1;
UPDATE data_universe SET Name = 'LITHIUM-FOR-EARTH KRW500' WHERE SecCode = 105080 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 142778 AND Type_ = 10;
UPDATE data_universe SET Name = 'JK SYNAPSE CO LTD KRW100' WHERE SecCode = 143394 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 288989 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '1893.H', QuotePermID = 21476459275.0, ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24', endDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473202.0, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236792907732.0, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 411681 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-20' WHERE SecCode = 726370 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET Name = 'ONEUL E&M CO.LTD KRW200' WHERE SecCode = 2620149 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-20' WHERE SecCode = 3183968 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-23' WHERE SecCode = 3200664 AND Type_ = 10;
UPDATE data_universe SET Name = 'OPTIMUM RE SPAIN S EUR3.46' WHERE SecCode = 3247303 AND Type_ = 10;
UPDATE data_universe SET Name = 'TURNSTONE RES LTD NPV' WHERE SecCode = 3296401 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3841574 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'EASY BIO INC KRW100.00' WHERE SecCode = 4248125 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21910570378.0, PermQuoteStatus = 'DC', ExchCode = 'CHJ', PermQuoteRetireDate = '2025-09-04', endDate = '2025-09-04' WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 4482511 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 4571432 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-20' WHERE SecCode = 4627843 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5052443 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-19', SecMapEndDate = '2025-04-09', endDate = '2025-04-09' WHERE SecCode = 6182386 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-19', SecMapEndDate = '2026-03-05', endDate = '2026-03-05' WHERE SecCode = 6256352 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-19', SecMapEndDate = '2025-10-30', endDate = '2025-10-30' WHERE SecCode = 6305182 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A40ET88', RkdTicker = 'FXT', RkdSEDOL = 'BW01T6', RkdCUSIP = 'D2R4ZG11', RkdRIC = 'FXTn.DE', RkdDisplayRIC = 'FXTn.DE', RkdCode = 144519.0, RkdIssueID = 1.0, RkdIssueCode = 184693.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ETR', RkdExchCtry = 'DEU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6448288 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-19' WHERE SecCode = 6654321 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TSE' WHERE SecCode = 11008504 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11133288 AND Type_ = 1;
UPDATE data_universe SET Name = 'VIVOPOWER PLC SHS NEW' WHERE SecCode = 11166235 AND Type_ = 1;
UPDATE data_universe SET Name = 'SOL-GEL TECHNOLOGIES LTD SHS NEW' WHERE SecCode = 11181558 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11185342 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'SBD.X', RkdRIC = 'SBDx.CD', RkdDisplayRIC = 'SBDx.CD' WHERE SecCode = 11188593 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US2848981039', RkdCUSIP = '28489810', DsPrimQtSedol = 'BMW23D1' WHERE SecCode = 11192817 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951758.0 WHERE SecCode = 11193010 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11194856 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11199082 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11201788 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 11202501 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951289.0 WHERE SecCode = 11208468 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365405.0 WHERE SecCode = 11221669 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11235068 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG9888Q1110' WHERE SecCode = 11264467 AND Type_ = 1;
UPDATE data_universe SET Name = 'ZJK INDL CO. LTD. ORD SHS CL A' WHERE SecCode = 11270118 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11271326 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2024-11-28' WHERE SecCode = 11272207 AND Type_ = 1;
UPDATE data_universe SET Name = 'WETOUR ROBOTICS LTD SHS' WHERE SecCode = 11275372 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG053845019', RkdCUSIP = 'G0538450', RkdRIC = 'AHL.N^B26', RkdCode = 36498.0, RkdIssueID = 5.0, RkdIssueCode = 181027.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 3.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 11278125 AND Type_ = 1;
UPDATE data_universe SET Name = 'DELIXY HLDGS LTD CL A ORD SHS' WHERE SecCode = 11280356 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-10-07', startDate = '2025-10-07' WHERE SecCode = 11286616 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-01-03' WHERE SecCode = 11290939 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, IsPrimaryInstr = 0.0 WHERE SecCode = 11291139 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, PriInstrPermID = 232910237563.0 WHERE SecCode = 11291180 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, PriInstrPermID = 232916052851.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11291183 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804442492.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293396 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236804485145.0, PriValQuotePermID = 25727030088.0, IsPrimaryInstr = 1.0 WHERE SecCode = 11293452 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3865B1142', RkdTicker = 'GIX', RkdSEDOL = 'BVP8Z3', RkdCUSIP = 'G3865B11', RkdRIC = 'GIX.O', RkdDisplayRIC = 'GIX.OQ', RkdCode = 144123.0, RkdIssueID = 1.0, RkdIssueCode = 184089.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '', PriTrdQuotePermID = 236804485248.0, PriValQuotePermID = 25727030057.0, IsPrimaryInstr = 1.0, startDate = '2026-01-27' WHERE SecCode = 11293453 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236804485410.0, PriValQuotePermID = 25727029993.0, IsPrimaryInstr = 1.0 WHERE SecCode = 11293456 AND Type_ = 1;
