UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-15', SecMapEndDate = '2025-09-11', PermQuoteRetireDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-11' WHERE SecCode = 697 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 4.0 WHERE SecCode = 4537 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIO GREEN MED SOLUTION  INC COM JUNE 2025' WHERE SecCode = 18200 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIO GREEN MED SOLUTION  INC PFD CONV EX 6%' WHERE SecCode = 18201 AND Type_ = 1;
UPDATE data_universe SET Name = 'DURECT CORP COM NEW' WHERE SecCode = 22244 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 45120 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21532854931.0, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15', endDate = '2025-09-15' WHERE SecCode = 59308 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BTBB', QuotePermID = 21474924570.0, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06', endDate = '2023-11-03' WHERE SecCode = 59414 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000419624', RkdTicker = 'GA8', PermIDTicker = 'GA8', RkdSEDOL = 'BVPGHD', RkdRIC = 'GA8.AX', RkdDisplayRIC = 'GA8.AX', DsPrimQtSedol = 'BVPGHD1' WHERE SecCode = 74740 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75698 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GANESH HOUSING LTD INR10(DEMAT)' WHERE SecCode = 78667 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81287 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81729 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 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 = 'A' WHERE SecCode = 90284 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 90297 AND Type_ = 10;
UPDATE data_universe SET Name = 'APOLLO SILVER CORP COM NEW', SecMapEndDate = '2079-06-06', endDate = '2025-09-13' WHERE SecCode = 90372 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 90958 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-15' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET Name = 'DPM METALS INC COM' WHERE SecCode = 93359 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8506K14' WHERE SecCode = 95744 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000417149', RkdTicker = 'SOLDA', PermIDTicker = 'SOLDA', RkdSEDOL = 'BT8NLQ', RkdRIC = 'SOLDA.AX', RkdDisplayRIC = 'SOLDA.AX', DsPrimQtSedol = 'BT8NLQ6', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-15' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CEMPRO', PermIDTicker = 'CEMPRO', RkdRIC = 'CEMI.NS', RkdDisplayRIC = 'CEMI.NS' WHERE SecCode = 97785 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 99982 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 100312 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'Q8329N31', Name = 'SAYONA MINING LTD NPV DFD 19/09/25 (EX-SPLIT)', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 111747 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 112954 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 DsCtryQtStatus = 'S' WHERE SecCode = 116434 AND Type_ = 10;
UPDATE data_universe SET Name = 'ADVANCED NANO TECH NPV DFD 13/10/17(EX-SPLT)' WHERE SecCode = 128181 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEVERLY WILSHIRE NPV (POST-SPLT)' WHERE SecCode = 144934 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE809Q01020', RkdSEDOL = 'BMYS0F', RkdCUSIP = 'Y271BT10', DsPrimQtSedol = 'BMYS0F8', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-15' WHERE SecCode = 214104 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FLNG.OL^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-16', SecMapEndDate = '2025-09-15', PermQuoteRetireDate = '2025-09-16', endDate = '2025-09-15' WHERE SecCode = 286050 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA28619K2083', RkdSEDOL = 'BTZP33', RkdCUSIP = '28619K20', DsPrimQtSedol = 'BTZP336' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 319114 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 320072 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 331648 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365381.0 WHERE SecCode = 336707 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 345744 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 391897 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'YUZHOU GROUP HOLDI HKD1' WHERE SecCode = 551335 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 558354 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 559630 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 767057 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BLINDATA LIMITED ORD EUR 0.01' WHERE SecCode = 844012 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21481777624.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 1453952 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 RkdRIC = 'SKYI.SI', RkdDisplayRIC = 'SKYI.SI' WHERE SecCode = 1631746 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GA8', DsPrimQtSedol = 'BVPGHD1' WHERE SecCode = 2255680 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TIGERLOGS', RkdRIC = 'TIGE.NS', RkdDisplayRIC = 'TIGE.NS', RkdExchCode = 'NSE' WHERE SecCode = 2349750 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-08-25' WHERE SecCode = 2378956 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-08-21', PermSecMapEndDate = '2025-09-14', endDate = '2025-08-21' WHERE SecCode = 2483617 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2529648 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GA8', DsPrimQtSedol = 'BVPGHD1' WHERE SecCode = 2800403 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 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 = 2832701 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3043688 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-09-09', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15', endDate = '2025-09-09' WHERE SecCode = 3338654 AND Type_ = 10;
UPDATE data_universe SET Name = 'FONCIERE IMMOB TUN NPV' WHERE SecCode = 3349716 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3504370 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE467X01023' WHERE SecCode = 3587036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3651875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3671059 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 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 DsCtryQtStatus = 'A' WHERE SecCode = 3972133 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4286258 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4798499 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5104594 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7750.TW', RkdDisplayRIC = '7750.TW', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5807735 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5886937 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 6351573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6405360 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 100.0 WHERE SecCode = 11002303 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11020243 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0500591049', RkdSEDOL = 'BTZP31', RkdCUSIP = '05005910', DsPrimQtSedol = 'BTZP314' WHERE SecCode = 11181676 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096758753.0, PermOrgIPODate = '2018-03-23' WHERE SecCode = 11183359 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9618843018', RkdSEDOL = 'BTZNZT', RkdCUSIP = '96188430', DsPrimQtSedol = 'BTZNZT0' WHERE SecCode = 11206889 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-12' WHERE SecCode = 11208299 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-12' WHERE SecCode = 11209772 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-06-20', startDate = '2022-06-20' WHERE SecCode = 11243073 AND Type_ = 1;
UPDATE data_universe SET Name = 'STRIVE INC CL A COM', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11249437 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG982181114', RkdSEDOL = 'BTZNZL', RkdCUSIP = 'G9821811', DsPrimQtSedol = 'BTZNZL2' WHERE SecCode = 11251558 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FDXTF' WHERE SecCode = 11251873 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 11278193 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11278441 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PVS.PR.U', QuotePermID = 236795699218.0, InstrPermID = 232898321106.0, OrgPermID = 4295860712.0, PriValQuotePermID = 236795699218.0, PriInstrPermID = 192818697641.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-09-10', startDate = '2025-09-10' WHERE SecCode = 11285114 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285141 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-09-11', startDate = '2025-09-11' WHERE SecCode = 11285148 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-09-11', startDate = '2025-09-11' WHERE SecCode = 11285175 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VIA', QuotePermID = 236795698805.0, InstrPermID = 232895278183.0, OrgPermID = 5043315335.0, PriTrdQuotePermID = 236795698805.0, PriValQuotePermID = 25727062349.0, PriInstrPermID = 232895278183.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2025-09-12', PermSecMapStartDate = '2025-09-10', startDate = '2025-09-10' WHERE SecCode = 11285245 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ONCH', ModelCntry = 'US', QuotePermID = 236795754566.0, InstrPermID = 232880117527.0, OrgPermID = 5095647428.0, PriTrdQuotePermID = 236795754566.0, PriValQuotePermID = 25727062090.0, PriInstrPermID = 232880117527.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2025-07-02', PermSecMapStartDate = '2025-09-11', startDate = '2025-07-02' WHERE SecCode = 11285255 AND Type_ = 1;
