UPDATE data_universe SET DsPrimQtSedol = 'BVYB5Y4' WHERE SecCode = 2459 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-07-31', PermSecMapEndDate = '2026-08-03' WHERE SecCode = 3611 AND Type_ = 10;
UPDATE data_universe SET Name = 'CERENOME INC COM NEW' WHERE SecCode = 18270 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-07-30', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-30' WHERE SecCode = 23368 AND Type_ = 1;
UPDATE data_universe SET InfoCode = 401296, DsSecCode = 275160, DsCmpyCode = 215342, DsCtryQtStatus = 'A', DsPrimQtSedol = '4010414', DsExchMnem = 'MAD', DsSecDelistDate = NULL, DsExchQtStartDate = '2026-07-17', SecMapStartDate = '2026-07-17', SecMapEndDate = '2079-06-06', startDate = '2026-07-17', endDate = NULL WHERE SecCode = 34112 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21593087896.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 44481 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 PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 46706 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-20', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-20' WHERE SecCode = 48360 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-08-03' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-16', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-16' WHERE SecCode = 69239 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73145 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-31' WHERE SecCode = 73692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 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 DsCtryQtStatus = 'S' WHERE SecCode = 76487 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SGXE38148339', RkdTicker = 'WYO', RkdSEDOL = 'BXJPKF' WHERE SecCode = 77332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-16', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-16' WHERE SecCode = 80912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86795 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 88073 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SOLT-M' WHERE SecCode = 88549 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG2164J2089', RkdSEDOL = 'BVZJWH', RkdCUSIP = 'G2164J20' WHERE SecCode = 92897 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 93799 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1993-06-09' WHERE SecCode = 94367 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 8590933623.0, IsPrimaryInstr = 1.0 WHERE SecCode = 95876 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNYGMB9' WHERE SecCode = 98956 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114727 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 DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116617 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 DsCtryQtStatus = 'S' WHERE SecCode = 125539 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 = 125762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126259 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 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 = 126529 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 DsCtryQtStatus = 'S' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 133893 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 DsCtryQtStatus = 'S' WHERE SecCode = 135125 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 DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136034 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 RkdRIC = 'VELL.BO', RkdDisplayRIC = 'VELL.BO', Name = 'VELLORA IMPACT LTD INR10' WHERE SecCode = 136988 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 137928 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PHC' WHERE SecCode = 143799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55856245271.0, ExchCode = 'DUS', PermQuoteRetireDate = '2018-11-14', endDate = '2018-11-13' WHERE SecCode = 147917 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 154474 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 161158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 180539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 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 DsCtryQtStatus = 'S' WHERE SecCode = 243314 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 DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 288634 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-31' WHERE SecCode = 295300 AND Type_ = 10;
UPDATE data_universe SET Name = 'TAKE SOLUTIONS INR1' WHERE SecCode = 318166 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-31', endDate = '2026-07-31' WHERE SecCode = 336830 AND Type_ = 1;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 347222 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 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 DsCtryQtStatus = 'S' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798948725.0, ExchCode = 'DUS' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GOLDEN BRDG GP HOL NPV' WHERE SecCode = 401666 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 DsCtryQtStatus = 'S' WHERE SecCode = 411896 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 DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 559631 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHYY DEVELOPMENT G USD0.01' WHERE SecCode = 565859 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PTSC SAO' WHERE SecCode = 586504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 786648 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 = 'A' WHERE SecCode = 853194 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 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 PermQuoteRetireDate = '2026-09-01' WHERE SecCode = 1278568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-31' WHERE SecCode = 1485705 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622760 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 DsCtryQtStatus = 'S' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2252347 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 QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2455560 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET Name = 'JIUFANG DIGITAL TE HKD0.2' WHERE SecCode = 2813094 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-04', SecMapEndDate = '2015-09-29', endDate = '2015-09-29' WHERE SecCode = 2990831 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 3033895 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MAISONS DU MONDE EUR0.001' WHERE SecCode = 3174281 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SPRU.NS', RkdDisplayRIC = 'SPRU.NS' WHERE SecCode = 3185057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET Name = 'PRABHAT TECHNOLOGI INR10' WHERE SecCode = 3220940 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-31', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 3258936 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-31', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 3259989 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3272839 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21859526011.0, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-20', endDate = '2022-06-20' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-31', PermQuoteRetireDate = '2026-08-03', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 3518286 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21654873862.0, ExchCode = 'BCO', PermQuoteRetireDate = '2022-08-22' WHERE SecCode = 3537067 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 DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ENT', RkdRIC = 'ENTE.MI', RkdDisplayRIC = 'ENTE.MI', Name = 'ENTERA S.P.A NPV' WHERE SecCode = 3794666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4032215 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21593061041.0 WHERE SecCode = 4057452 AND Type_ = 10;
UPDATE data_universe SET Name = 'JIUTAI DIGITAL TEC HKD0.001' WHERE SecCode = 4154006 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AMRQ', QuotePermID = 21762166652.0, IsPrimaryQuote = 1.0, ExchCode = 'LSE' WHERE SecCode = 4314879 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'MXFFFO0K0021', RkdTicker = 'FORION20', RkdSEDOL = 'BNHNHG', RkdCUSIP = 'P0R05G29', RkdRIC = 'FORION20.MX', RkdDisplayRIC = 'FORION20.MX', RkdCode = 145287.0, RkdIssueID = 1.0, RkdIssueCode = 185920.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MXK', RkdExchCtry = 'MEX', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4393370 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 4617777 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4639575 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 4850228 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5448770 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-07-07' WHERE SecCode = 5455474 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE682M01020', RkdSEDOL = 'BXQ15X', RkdCUSIP = 'Y4S77P13' WHERE SecCode = 5527280 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 5693825 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6258181 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236796470075.0, PriValQuotePermID = 236796470075.0, ExchCode = 'TYO' WHERE SecCode = 6487500 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0VI201010', RkdTicker = '544662', RkdSEDOL = 'BTBKPL', RkdCUSIP = 'Y793KB10', RkdRIC = 'SIMD.BO', RkdDisplayRIC = 'SIMD.BO', RkdCode = 145288.0, RkdIssueID = 1.0, RkdIssueCode = 185921.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6610153 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 6737828 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AEROPLANE' WHERE SecCode = 6756394 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945361 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-07-31', PermSecMapEndDate = '2026-08-02', endDate = '2026-07-31' WHERE SecCode = 6945371 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-04', SecMapEndDate = '2026-08-03', PermSecMapEndDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 6948289 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-04', SecMapEndDate = '2026-08-03', PermSecMapEndDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 6982423 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 7006693 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7017401 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-07-31' WHERE SecCode = 7017417 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 10973754 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 21478725082.0, IsPrimaryInstr = 1.0, PermOrgIPODate = '2011-11-16', startDate = '2011-11-16' WHERE SecCode = 11015444 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 11171838 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US3724464017', RkdSEDOL = 'BV4JYK', RkdCUSIP = '37244640' WHERE SecCode = 11177776 AND Type_ = 1;
UPDATE data_universe SET Country = 'BMU', PriInstrPermID = 21631734783.0, IsPrimaryInstr = 1.0 WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-31' WHERE SecCode = 11182962 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11186433 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 21593061041.0, IsPrimaryInstr = 1.0, startDate = '2016-08-01' WHERE SecCode = 11192844 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', endDate = '2025-02-07' WHERE SecCode = 11195409 AND Type_ = 1;
UPDATE data_universe SET Name = 'STARLING ONCOLOGY INSTITUTE IN COM' WHERE SecCode = 11207431 AND Type_ = 1;
UPDATE data_universe SET Name = 'STARLING ONCOLOGY INSTITUTE IN *W EXP 99/99/9999' WHERE SecCode = 11207554 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BNYG3Z0' WHERE SecCode = 11208072 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVY6YV9' WHERE SecCode = 11211670 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727310928.0, IsPrimaryInstr = 1.0, PermOrgIPODate = '2020-10-29' WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-30', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-30' WHERE SecCode = 11222838 AND Type_ = 1;
UPDATE data_universe SET Name = 'DERMATA THERAPEUTICS INC *W EXP 8/17/2026' WHERE SecCode = 11228754 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11242380 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 21895251400.0, IsPrimaryInstr = 1.0 WHERE SecCode = 11243838 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BNYG4S', PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11255741 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-31' WHERE SecCode = 11256233 AND Type_ = 1;
UPDATE data_universe SET Name = 'QUANOME TECHNOLOGIES INC COM' WHERE SecCode = 11266820 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE', SecMapStartDate = '2024-09-19', startDate = '2024-09-19' WHERE SecCode = 11269743 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11270869 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11275372 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'JOLT.X', RkdRIC = 'JOLTx.CD', RkdDisplayRIC = 'JOLTx.CD' WHERE SecCode = 11277622 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 141712.0 WHERE SecCode = 11277714 AND Type_ = 1;
UPDATE data_universe SET RkdCode = 145291.0, RkdIssueID = 1.0, RkdIssueCode = 185927.0, RkdListingType = 'ADR', ShPerListing = 1.0, PrimaryIssueCode = 141712.0, RelType = 1.0, COATypeCode = '' WHERE SecCode = 11278832 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232817132721.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11297292 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297671 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232930731709.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11298233 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232933255515.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11298871 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232937618325.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11298973 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG752281090', RkdTicker = 'RACD', RkdSEDOL = 'BXRVNK', RkdCUSIP = 'G7522810', RkdRIC = 'RACD.O', RkdDisplayRIC = 'RACD.OQ', RkdCode = 145286.0, RkdIssueID = 1.0, RkdIssueCode = 185919.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11299125 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232936115238.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11299479 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-07-27' WHERE SecCode = 11299636 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XIIIU', QuotePermID = 236809913950.0, InstrPermID = 232945418916.0, OrgPermID = 6000198683.0, PriTrdQuotePermID = 236809913950.0, PriValQuotePermID = 25727005048.0, PriInstrPermID = 232945418916.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-07-31', PermSecMapStartDate = '2026-07-30', startDate = '2026-07-30' WHERE SecCode = 11299930 AND Type_ = 1;