UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 3120 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JOHNSON MATTHEY ORD GBP1.478994', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6872 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-17', SecMapEndDate = '2026-08-14', PermQuoteRetireDate = '2026-08-17', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-14' WHERE SecCode = 7360 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 9081 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VMRK', RkdRIC = 'VMRK.K', RkdDisplayRIC = 'VMRK.N', Name = 'VIVMARK RESIDENTIAL SH BEN INT' WHERE SecCode = 24399 AND Type_ = 1;
UPDATE data_universe SET Name = 'FRANKLIN TEMPLETON INC COM' WHERE SecCode = 28262 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'PROFUTURO AFP PEN1800.69' WHERE SecCode = 30331 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 SecMapEndDate = '2026-08-17' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 53259 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 56158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AUSTENG', QuotePermID = 236812532361.0, ExchCode = 'NSI' WHERE SecCode = 68052 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OPTIFIN', QuotePermID = 236812542322.0, ExchCode = 'NSI' WHERE SecCode = 69557 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-07-29', PermQuoteRetireDate = '2026-08-18', PermSecMapEndDate = '2026-08-17', endDate = '2026-07-29' WHERE SecCode = 69823 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ANSALBU', QuotePermID = 236812532352.0, ExchCode = 'NSI' WHERE SecCode = 70063 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VIJSOLX', QuotePermID = 236812532414.0, ExchCode = 'NSI' WHERE SecCode = 70564 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHIVAAGRO', QuotePermID = 236812542354.0, ExchCode = 'NSI' WHERE SecCode = 71781 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SPELS', QuotePermID = 236812542357.0, ExchCode = 'NSI' WHERE SecCode = 72144 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 72411 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TUTIALKA', QuotePermID = 236812542378.0, ExchCode = 'NSI' WHERE SecCode = 72736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AVANCE', QuotePermID = 236812532359.0, ExchCode = 'NSI' WHERE SecCode = 76634 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US8964386036', RkdSEDOL = 'BS54W8', RkdCUSIP = '89643860', ShPerListing = 600.0 WHERE SecCode = 76806 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SRIKPRIND', QuotePermID = 236812542360.0, ExchCode = 'NSI' WHERE SecCode = 78106 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SWISSMLTRY', PermIDTicker = 'SWISSMLTRY', RkdRIC = 'SWIS.NS', RkdDisplayRIC = 'SWIS.NS', RkdExchCode = 'NSE', QuotePermID = 236812542369.0, ExchCode = 'NSI' WHERE SecCode = 78194 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SGLRES', QuotePermID = 236812532404.0, ExchCode = 'NSI' WHERE SecCode = 78257 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VOITHPAPR', QuotePermID = 236812542389.0, ExchCode = 'NSI' WHERE SecCode = 78264 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHILGRAVQ', QuotePermID = 236812542345.0, ExchCode = 'NSI' WHERE SecCode = 78437 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SEKURITIND', QuotePermID = 236812542344.0, ExchCode = 'NSI' WHERE SecCode = 78556 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ZIJIN LONGKING CO ''A''CNY1' WHERE SecCode = 78697 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ECORECO', QuotePermID = 236812532379.0, ExchCode = 'NSI' WHERE SecCode = 78756 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TANAA', QuotePermID = 236812542372.0, ExchCode = 'NSI' WHERE SecCode = 78962 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NICCOPAR', QuotePermID = 236812542312.0, ExchCode = 'NSI' WHERE SecCode = 78967 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MYSORPETRO', QuotePermID = 236812542325.0, ExchCode = 'NSI' WHERE SecCode = 79117 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LAKSHMIMIL', QuotePermID = 236812542320.0, ExchCode = 'NSI' WHERE SecCode = 79458 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ACGL', QuotePermID = 236812532357.0, ExchCode = 'NSI' WHERE SecCode = 79532 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRAHMINFRA', QuotePermID = 236812532369.0, ExchCode = 'NSI' WHERE SecCode = 79552 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHERVANI', QuotePermID = 236812542348.0, ExchCode = 'NSI' WHERE SecCode = 79590 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ANDREWYU', QuotePermID = 236812532350.0, ExchCode = 'NSI' WHERE SecCode = 79991 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'JENBURPH', QuotePermID = 236812532394.0, ExchCode = 'NSI' WHERE SecCode = 80067 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'COMPEAU', QuotePermID = 236812532371.0, ExchCode = 'NSI' WHERE SecCode = 81046 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LOTUSCHO', QuotePermID = 236812542309.0, ExchCode = 'NSI' WHERE SecCode = 81054 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'JYOTIRES', QuotePermID = 236812532396.0, ExchCode = 'NSI' WHERE SecCode = 81153 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AMARJOTHI', PermIDTicker = 'AMARJOTHI', RkdRIC = 'AMSM.NS', RkdDisplayRIC = 'AMSM.NS', RkdExchCode = 'NSE', QuotePermID = 236812532351.0, ExchCode = 'NSI' WHERE SecCode = 81262 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CGVAK', QuotePermID = 236812532366.0, ExchCode = 'NSI' WHERE SecCode = 81442 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRIGHTBR', QuotePermID = 236812532367.0, ExchCode = 'NSI' WHERE SecCode = 82109 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MEDICAPQ', QuotePermID = 236812542318.0, ExchCode = 'NSI' WHERE SecCode = 82347 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HAMPTON', QuotePermID = 236812532386.0, ExchCode = 'NSI' WHERE SecCode = 82355 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SAMBANDAM', PermIDTicker = 'SAMBANDAM', RkdRIC = 'SAMB.NS', RkdDisplayRIC = 'SAMB.NS', RkdExchCode = 'NSE', QuotePermID = 236812542346.0, ExchCode = 'NSI' WHERE SecCode = 82445 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SUNSHIEL', QuotePermID = 236812542363.0, ExchCode = 'NSI' WHERE SecCode = 82648 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'YOGI', QuotePermID = 236812542395.0, ExchCode = 'NSI' WHERE SecCode = 82655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CRAVATEX', QuotePermID = 236812532370.0, ExchCode = 'NSI' WHERE SecCode = 82779 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SUPTANERY', QuotePermID = 236812542368.0, ExchCode = 'NSI' WHERE SecCode = 82819 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83328 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HBPOR', QuotePermID = 236812532387.0, ExchCode = 'NSI' WHERE SecCode = 83670 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'IPRINGLTD', PermIDTicker = 'IPRINGLTD', RkdRIC = 'IPRI.NS', RkdDisplayRIC = 'IPRI.NS', RkdExchCode = 'NSE', QuotePermID = 236812532392.0, ExchCode = 'NSI' WHERE SecCode = 84684 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'C051N29' WHERE SecCode = 85397 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '2323.HK^H26', RkdIssueStatus = 0.0, SecMapEndDate = '2026-08-14', PermSecMapEndDate = '2026-08-16', endDate = '2026-08-14' WHERE SecCode = 87246 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MLKFOOD', QuotePermID = 236812542315.0, ExchCode = 'NSI' WHERE SecCode = 88949 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89214 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 90404 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 90405 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 91266 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PANCHMAHQ', QuotePermID = 236812542334.0, ExchCode = 'NSI' WHERE SecCode = 92158 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PERMAGN', QuotePermID = 236812542337.0, ExchCode = 'NSI' WHERE SecCode = 92344 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PHOENXINTL', QuotePermID = 236812542333.0, ExchCode = 'NSI' WHERE SecCode = 92609 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ECORECO', QuotePermID = 236812532379.0, ExchCode = 'NSI' WHERE SecCode = 93183 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TGVSL', QuotePermID = 236812542374.0, ExchCode = 'NSI' WHERE SecCode = 94901 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SIMPLXREA', QuotePermID = 236812532408.0, ExchCode = 'NSI' WHERE SecCode = 95829 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SIEL', QuotePermID = 236812532410.0, ExchCode = 'NSI' WHERE SecCode = 96407 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'WATERBASE', PermIDTicker = 'WATERBASE', RkdRIC = 'WTRB.NS', RkdDisplayRIC = 'WTRB.NS', RkdExchCode = 'NSE', QuotePermID = 236812542392.0, ExchCode = 'NSI' WHERE SecCode = 98704 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'WHBRADY', QuotePermID = 236812542393.0, ExchCode = 'NSI' WHERE SecCode = 98851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21748242454.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ADDIND', QuotePermID = 236812532345.0, ExchCode = 'NSI' WHERE SecCode = 111839 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HAZOOR', QuotePermID = 236812532388.0, ExchCode = 'NSI' WHERE SecCode = 111840 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALFREDHE', QuotePermID = 236812532346.0, ExchCode = 'NSI' WHERE SecCode = 112366 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115197 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KSE', QuotePermID = 236812542310.0, ExchCode = 'NSI' WHERE SecCode = 115611 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ORIRAIL', QuotePermID = 236812542330.0, ExchCode = 'NSI' WHERE SecCode = 115973 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116617 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHRADDHA', QuotePermID = 236812542353.0, ExchCode = 'NSI' WHERE SecCode = 116633 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HINDADH', QuotePermID = 236812532389.0, ExchCode = 'NSI' WHERE SecCode = 118382 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHIVACEM', QuotePermID = 236812542352.0, ExchCode = 'NSI' WHERE SecCode = 125364 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ONIXSOLAR', QuotePermID = 236812532401.0, ExchCode = 'NSI' WHERE SecCode = 125442 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHRJAGP', QuotePermID = 236812542358.0, ExchCode = 'NSI' WHERE SecCode = 125496 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125539 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TRITONV', QuotePermID = 236812542377.0, ExchCode = 'NSI' WHERE SecCode = 125598 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MOHITE', QuotePermID = 236812542306.0, ExchCode = 'NSI' WHERE SecCode = 126268 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SUMEDHA', QuotePermID = 236812542364.0, ExchCode = 'NSI' WHERE SecCode = 126449 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126523 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASIANTNE', QuotePermID = 236812532358.0, ExchCode = 'NSI' WHERE SecCode = 126568 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RTSPOWR', QuotePermID = 236812542339.0, ExchCode = 'NSI' WHERE SecCode = 126625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126634 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VIRAT', QuotePermID = 236812542383.0, ExchCode = 'NSI' WHERE SecCode = 127097 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AXTEL', QuotePermID = 236812532360.0, ExchCode = 'NSI' WHERE SecCode = 130883 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PBMPOLY', QuotePermID = 236812542329.0, ExchCode = 'NSI' WHERE SecCode = 130995 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ISTLTD', QuotePermID = 236812532391.0, ExchCode = 'NSI' WHERE SecCode = 134766 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LADDERUP', QuotePermID = 236812542319.0, ExchCode = 'NSI' WHERE SecCode = 134906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135125 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EBIX', QuotePermID = 236812532377.0, ExchCode = 'NSI' WHERE SecCode = 135128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TRANSCOR', QuotePermID = 236812542375.0, ExchCode = 'NSI' WHERE SecCode = 135733 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KAMANWALA', QuotePermID = 236812532398.0, ExchCode = 'NSI' WHERE SecCode = 135959 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'STLSTRINF', QuotePermID = 236812542359.0, ExchCode = 'NSI' WHERE SecCode = 135964 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136034 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MINALIND', QuotePermID = 236812542313.0, ExchCode = 'NSI' WHERE SecCode = 136225 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'UPHOT', QuotePermID = 236812532412.0, ExchCode = 'NSI' WHERE SecCode = 136244 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AMAL', QuotePermID = 236812532349.0, ExchCode = 'NSI' WHERE SecCode = 136496 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TERAI', QuotePermID = 236812542373.0, ExchCode = 'NSI' WHERE SecCode = 137017 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BENARAS', QuotePermID = 236812532364.0, ExchCode = 'NSI' WHERE SecCode = 137262 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ODYCORP', QuotePermID = 236812542314.0, ExchCode = 'NSI' WHERE SecCode = 137338 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VIVOBIOT', QuotePermID = 236812542388.0, ExchCode = 'NSI' WHERE SecCode = 141014 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 143568 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'POLYSPIN', QuotePermID = 236812542342.0, ExchCode = 'NSI' WHERE SecCode = 145531 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MPDL', QuotePermID = 236812542321.0, ExchCode = 'NSI' WHERE SecCode = 145663 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 170844 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-17', PermQuoteRetireDate = '2026-08-17', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 186577 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MKEXIM', QuotePermID = 236812542323.0, ExchCode = 'NSI' WHERE SecCode = 193089 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TGVSL', QuotePermID = 236812542374.0, ExchCode = 'NSI' WHERE SecCode = 202359 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PACIFICI', QuotePermID = 236812542332.0, ExchCode = 'NSI' WHERE SecCode = 243289 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VADILENT', QuotePermID = 236812542382.0, ExchCode = 'NSI' WHERE SecCode = 243312 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ARYAMAN', QuotePermID = 236812532355.0, ExchCode = 'NSI' WHERE SecCode = 243347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MAKERSL', QuotePermID = 236812542317.0, ExchCode = 'NSI' WHERE SecCode = 255753 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SWARNSAR', QuotePermID = 236812542370.0, ExchCode = 'NSI' WHERE SecCode = 255787 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KJMCFIN', QuotePermID = 236812532399.0, ExchCode = 'NSI' WHERE SecCode = 256127 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LEENEE', QuotePermID = 236812542324.0, ExchCode = 'NSI' WHERE SecCode = 256129 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NTCIND', QuotePermID = 236812542308.0, ExchCode = 'NSI' WHERE SecCode = 256240 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ITL', QuotePermID = 236812532390.0, ExchCode = 'NSI' WHERE SecCode = 256502 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALUFLUOR', QuotePermID = 236812532348.0, ExchCode = 'NSI' WHERE SecCode = 258660 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EMPIND', QuotePermID = 236812532381.0, ExchCode = 'NSI' WHERE SecCode = 258785 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CRSL', QuotePermID = 236812532373.0, ExchCode = 'NSI' WHERE SecCode = 288469 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HINDALUMI', QuotePermID = 236812532383.0, ExchCode = 'NSI' WHERE SecCode = 288636 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HRYNSHP', QuotePermID = 236812532393.0, ExchCode = 'NSI' WHERE SecCode = 292388 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ADVANCED TECHNOL KWD0.1' WHERE SecCode = 319924 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 321364 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VTMLTD', PermIDTicker = 'VTMLTD', RkdRIC = 'VTML.NS', RkdDisplayRIC = 'VTML.NS', RkdExchCode = 'NSE', QuotePermID = 236812542387.0, ExchCode = 'NSI' WHERE SecCode = 322335 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MUKESHB', QuotePermID = 236812532403.0, ExchCode = 'NSI' WHERE SecCode = 378063 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 381505 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VASUPRADA', QuotePermID = 236812532409.0, ExchCode = 'NSI' WHERE SecCode = 410956 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KMCSHIL', QuotePermID = 236812542311.0, ExchCode = 'NSI' WHERE SecCode = 420073 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEDAVAAG', QuotePermID = 236812542385.0, ExchCode = 'NSI' WHERE SecCode = 488452 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MANBRO', QuotePermID = 236812532400.0, ExchCode = 'NSI' WHERE SecCode = 521517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 547478 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 80578.0 WHERE SecCode = 564890 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GKB', QuotePermID = 236812532385.0, ExchCode = 'NSI' WHERE SecCode = 601160 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PARNAXLAB', QuotePermID = 236812542336.0, ExchCode = 'NSI' WHERE SecCode = 1204815 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209863 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SAICAPI', QuotePermID = 236812542341.0, ExchCode = 'NSI' WHERE SecCode = 1209872 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ENKEIWHEL', QuotePermID = 236812532380.0, ExchCode = 'NSI' WHERE SecCode = 1220836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-17', PermQuoteRetireDate = '2026-08-17' WHERE SecCode = 1310768 AND Type_ = 10;
UPDATE data_universe SET Name = 'NORDIC FINAN ASA NOK0.50' WHERE SecCode = 1458933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AZADIND', QuotePermID = 236812532362.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 1466823 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1546660 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-14', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-14' WHERE SecCode = 1587600 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622760 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KANCOTEA', QuotePermID = 236812532395.0, ExchCode = 'NSI' WHERE SecCode = 1893757 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PRISMX', QuotePermID = 236812542340.0, ExchCode = 'NSI' WHERE SecCode = 1997898 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VIRTUALG', QuotePermID = 236812542384.0, ExchCode = 'NSI' WHERE SecCode = 2002197 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SVGLOBAL', QuotePermID = 236812542367.0, ExchCode = 'NSI' WHERE SecCode = 2252346 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2283967 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2341361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SUNLOC', QuotePermID = 236812542365.0, ExchCode = 'NSI' WHERE SecCode = 2467267 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ONEGLOBAL', QuotePermID = 236812532402.0, ExchCode = 'NSI' WHERE SecCode = 2530467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VISHAL', PermIDTicker = 'VISHAL', RkdRIC = 'VIFA.NS', RkdDisplayRIC = 'VIFA.NS', RkdExchCode = 'NSE', QuotePermID = 236812542390.0, ExchCode = 'NSI' WHERE SecCode = 2622965 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TOYAMSL', QuotePermID = 236812532411.0, ExchCode = 'NSI' WHERE SecCode = 2625813 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'MIIL', PermIDTicker = 'MIIL', RkdRIC = 'MEGC.NS', RkdDisplayRIC = 'MEGC.NS', RkdExchCode = 'NSE', QuotePermID = 236812542305.0, ExchCode = 'NSI' WHERE SecCode = 2643273 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DHABRIYA', QuotePermID = 236812532376.0, ExchCode = 'NSI' WHERE SecCode = 2659122 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VGCL', QuotePermID = 236812532413.0, ExchCode = 'NSI' WHERE SecCode = 2664092 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'WARDINMOBI', QuotePermID = 236812542391.0, ExchCode = 'NSI' WHERE SecCode = 2825602 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SAB', QuotePermID = 236812532405.0, ExchCode = 'NSI' WHERE SecCode = 2891375 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'POEL', QuotePermID = 236812542335.0, ExchCode = 'NSI' WHERE SecCode = 2924551 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2928723 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MSL', QuotePermID = 236812542316.0, ExchCode = 'NSI' WHERE SecCode = 2955170 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SUNRAKSHAK', QuotePermID = 236812542362.0, ExchCode = 'NSI' WHERE SecCode = 2963532 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21777322524.0, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23', endDate = '2021-03-22' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PANORAMA', QuotePermID = 236812542331.0, ExchCode = 'NSI' WHERE SecCode = 3033926 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'UDAYJEW', QuotePermID = 236812542379.0, ExchCode = 'NSI' WHERE SecCode = 3048300 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLUECLOUDS', QuotePermID = 236812532363.0, ExchCode = 'NSI' WHERE SecCode = 3077437 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FREDUN', QuotePermID = 236812532384.0, ExchCode = 'NSI' WHERE SecCode = 3118174 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ADVIKCA', QuotePermID = 236812532347.0, ExchCode = 'NSI' WHERE SecCode = 3120782 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'LANCER', PermIDTicker = 'LANCER', RkdRIC = 'LANC.NS', RkdDisplayRIC = 'LANC.NS', RkdExchCode = 'NSE', QuotePermID = 236812542307.0, ExchCode = 'NSI' WHERE SecCode = 3133062 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CFEL', QuotePermID = 236812532372.0, ExchCode = 'NSI' WHERE SecCode = 3216146 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EASTWEST', QuotePermID = 236812532378.0, ExchCode = 'NSI' WHERE SecCode = 3216907 AND Type_ = 10;
UPDATE data_universe SET Name = 'VALERO ENERGY CORP BDR EACH 16 REPR 1 COM' WHERE SecCode = 3220408 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DHATRE', QuotePermID = 236812532374.0, ExchCode = 'NSI' WHERE SecCode = 3242023 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3258797 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3258799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3272839 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LKPSEC', QuotePermID = 236812532397.0, ExchCode = 'NSI' WHERE SecCode = 3275554 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CHEMCRUX', QuotePermID = 236812532368.0, ExchCode = 'NSI' WHERE SecCode = 3318942 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SAYAJIIND', QuotePermID = 236812532407.0, ExchCode = 'NSI' WHERE SecCode = 3396059 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SGRL', QuotePermID = 236812542347.0, ExchCode = 'NSI' WHERE SecCode = 3396697 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3396703 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BPLPHARMA', QuotePermID = 236812532365.0, ExchCode = 'NSI' WHERE SecCode = 3440955 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3587036 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DEEP', QuotePermID = 236812532375.0, ExchCode = 'NSI' WHERE SecCode = 3596594 AND Type_ = 10;
UPDATE data_universe SET Name = 'IDENTITII LTD NPV DFD 24/08/26(EX-SPLT)' WHERE SecCode = 3623744 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET Name = 'TJX COS INC BDR EACH 15 REPR 1 COM USD1' WHERE SecCode = 3837272 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 3915673 AND Type_ = 10;
UPDATE data_universe SET Name = 'UNILEVER PLC BDR EACH 5 REPR 1 ADR' WHERE SecCode = 3998153 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARCHER DANIELS MID BDR EACH 8 REPR 1 COM NPV' WHERE SecCode = 4054200 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMER ELEC PWR INC BDR EACH 10 REP 1 COM' WHERE SecCode = 4054201 AND Type_ = 10;
UPDATE data_universe SET Name = 'CORNING INC BDR EACH 4 REPR 1 COM' WHERE SecCode = 4054227 AND Type_ = 10;
UPDATE data_universe SET Name = 'XCEL ENERGY INC BDR EACH 8 REP 1 COM' WHERE SecCode = 4054265 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASSAMENT', QuotePermID = 236812532356.0, ExchCode = 'NSI' WHERE SecCode = 4062016 AND Type_ = 10;
UPDATE data_universe SET Name = 'FRANKLIN TEMPLETON BDR EACH REPR 1 COM' WHERE SecCode = 4077695 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMPHENOL CORP BDR EACH 12 REPR 1 COM' WHERE SecCode = 4077698 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-08-14', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-14' WHERE SecCode = 4079136 AND Type_ = 10;
UPDATE data_universe SET Name = 'THE HARTFORD INSUR BDR EACH 12 REPR 1 COM' WHERE SecCode = 4079190 AND Type_ = 10;
UPDATE data_universe SET Name = 'ECOLAB INC BDR EACH 20 REPR 1 COM' WHERE SecCode = 4079199 AND Type_ = 10;
UPDATE data_universe SET Name = 'CUMMINS INC BDR EACH 56 REPR 1 COM' WHERE SecCode = 4079205 AND Type_ = 10;
UPDATE data_universe SET Name = 'AON PLC (IE) BDR EACH 24 REPR 1 COM' WHERE SecCode = 4079213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4168437 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379702 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379704 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 4429559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EKI', QuotePermID = 236812532382.0, ExchCode = 'NSI' WHERE SecCode = 4557791 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 = 'D', DsSecDelistDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 4634180 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PM1', DsPrimQtSedol = 'BVK8SY0', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 4702568 AND Type_ = 10;
UPDATE data_universe SET Name = 'VSA CAPITAL GROUP ORD GBP0.01' WHERE SecCode = 4702652 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2021-10-14', PermSecMapEndDate = '2026-08-16', endDate = '2021-10-14' WHERE SecCode = 4739247 AND Type_ = 10;
UPDATE data_universe SET Name = 'BE MAKER CHF0.02', PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 4830903 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'KLS' WHERE SecCode = 4977687 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5283354 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ARCL', QuotePermID = 236812532354.0, ExchCode = 'NSI' WHERE SecCode = 5540652 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 5712059 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RRECL', QuotePermID = 236812532406.0, ExchCode = 'NSI' WHERE SecCode = 6101886 AND Type_ = 10;
UPDATE data_universe SET Name = 'NAF COMPANY SAR1' WHERE SecCode = 6377041 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'VGG8676K1049', RkdTicker = 'TAPH', RkdSEDOL = 'BW9KGQ', RkdCUSIP = 'G8676K10', RkdRIC = 'TAPH.L', RkdDisplayRIC = 'TAPH.L', RkdCode = 145358.0, RkdIssueID = 1.0, RkdIssueCode = 186033.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6710293 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 6829246 AND Type_ = 10;
UPDATE data_universe SET Country = 'JPN' WHERE SecCode = 6921032 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-17', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 6982422 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7000372 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7048406 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 7050896 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT06SY0' WHERE SecCode = 10913025 AND Type_ = 1;
UPDATE data_universe SET Name = 'GREEN ARROW RES INC COM SHS' WHERE SecCode = 10928206 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'ALM', RkdSEDOL = 'BS84NZ', RkdRIC = 'ALM.O', RkdDisplayRIC = 'ALM.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 10964740 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'M6S83C10' WHERE SecCode = 11146091 AND Type_ = 1;
UPDATE data_universe SET Name = 'GLOBAL HEALTH CLINICS LTD COM SHS' WHERE SecCode = 11163196 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US3765493099', RkdTicker = 'LANDO', RkdSEDOL = 'BN44ZP', RkdCUSIP = '37654930', RkdRIC = 'LANDO.O', RkdDisplayRIC = 'LANDO.OQ', RkdCode = 83787.0, RkdIssueID = 6.0, RkdIssueCode = 186031.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 5.0, RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11181025 AND Type_ = 1;
UPDATE data_universe SET Name = 'BLACK PINE RES CORP COM' WHERE SecCode = 11182672 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RLGDD', QuotePermID = 236806334833.0, InstrPermID = 21637409895.0, OrgPermID = 5061162118.0, PriValQuotePermID = 21647543483.0, PriInstrPermID = 21637409895.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GTC', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951923.0, PermOrgIPODate = '2018-05-07', PermSecMapStartDate = '2026-08-08', startDate = '2018-05-07' WHERE SecCode = 11199084 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'TALK.OQ^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-14', endDate = '2026-08-14' WHERE SecCode = 11210508 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT06T03' WHERE SecCode = 11218761 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BV86X4' WHERE SecCode = 11226875 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-17', SecMapEndDate = '2026-08-14', endDate = '2026-08-14' WHERE SecCode = 11228800 AND Type_ = 1;
UPDATE data_universe SET Name = 'BRENX LTD ORD SHS NEW' WHERE SecCode = 11242197 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11243274 AND Type_ = 1;
UPDATE data_universe SET Name = 'QMMM HOLDINGS LTD COM SHS CL A' WHERE SecCode = 11267479 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-08-14', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-14' WHERE SecCode = 11277712 AND Type_ = 1;
UPDATE data_universe SET Name = 'AIR WATER VENTURES LTD ORD SHS', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11279412 AND Type_ = 1;
UPDATE data_universe SET Name = 'NRED INTELLIGENT MNG INC COM SHS', PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 11281521 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 11286777 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11298231 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11298978 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KARUF', QuotePermID = 236812038558.0, InstrPermID = 232836711769.0, OrgPermID = 5084055358.0, PriValQuotePermID = 236810394805.0, PriInstrPermID = 232836711769.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = '2026-07-22', PermSecMapStartDate = '2026-08-06' WHERE SecCode = 11299480 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299615 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA1231831050', RkdTicker = 'BUSH.P', RkdSEDOL = 'BXL2FT', RkdCUSIP = '12318310', RkdRIC = 'BUSHp.V', RkdDisplayRIC = 'BUSHp.V', RkdCode = 145357.0, RkdIssueID = 1.0, RkdIssueCode = 186032.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11299871 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US92859A1060', RkdTicker = 'VOGX', RkdSEDOL = 'BX86HW', RkdCUSIP = '92859A10', RkdRIC = 'VOGX.O', RkdDisplayRIC = 'VOGX.OQ', RkdCode = 145364.0, RkdIssueID = 1.0, RkdIssueCode = 186041.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11300389 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EWAV', QuotePermID = 236812378636.0, InstrPermID = 232920965462.0, OrgPermID = 6000035299.0, PriTrdQuotePermID = 236812378636.0, PriValQuotePermID = 25726993704.0, PriInstrPermID = 232920965462.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-07-31', PermSecMapStartDate = '2026-08-13', startDate = '2026-07-31' WHERE SecCode = 11300478 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'THEO', QuotePermID = 236812437874.0, InstrPermID = 232901420799.0, OrgPermID = 5096919336.0, PriTrdQuotePermID = 236812437874.0, PriValQuotePermID = 25726993536.0, PriInstrPermID = 232901420799.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 = '2026-08-04', PermSecMapStartDate = '2026-08-14', startDate = '2026-08-04' WHERE SecCode = 11300524 AND Type_ = 1;