UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2343 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11922 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 12664 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 20297 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 22164 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 30013 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 30025 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 55789 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67390 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 = 70438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 73855 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74386 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000145979.0, PriInstrPermID = 8590935125.0, PermOrgIPODate = '1996-08-01' WHERE SecCode = 75029 AND Type_ = 1;
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 = 76492 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-22' WHERE SecCode = 76880 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 78460 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 = 78742 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 DsCtryQtStatus = 'S' WHERE SecCode = 79462 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 84781 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88601 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91746 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET Name = 'ROBINSON ENERGY LTD COM SHS' WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA59863J1003', RkdSEDOL = 'BRSD2C', RkdCUSIP = '59863J10', Name = 'MIIVO AI INC COM SHS', DsPrimQtSedol = 'BRSD2C5' WHERE SecCode = 93731 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94501 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95337 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'JPN' WHERE SecCode = 98717 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98993 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113724 AND Type_ = 10;
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 = 115981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 119593 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 = 123750 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 = 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 = 126433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126595 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 = 126831 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 = 131520 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TERA', RkdRIC = 'TERAN.L', RkdDisplayRIC = 'TERAN.L' WHERE SecCode = 131838 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 = 134785 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 = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136734 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 DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 143466 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 144974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdTicker = 'ETIHADENERGY', RkdRIC = 'ETIHAD.DU', RkdDisplayRIC = 'ETIHAD.DU', Name = 'ETIHAD ENERGY HOLD AED1' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21915101968.0, ExchCode = 'DEU' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 195140 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5076368902.0, PriTRBCIndPermID = NULL WHERE SecCode = 203639 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243154 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 = 283464 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 299990 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 322233 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'M96', DsPrimQtSedol = 'BX59CS4', SecMapEndDate = '2026-06-21', endDate = '2026-06-21' WHERE SecCode = 336664 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 341321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 359140 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 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 = 425884 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 RkdTicker = NULL, RkdRIC = 'VKP.HNO^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-23', SecMapEndDate = '2017-09-06', PermQuoteRetireDate = '2026-06-23', endDate = '2017-09-06' WHERE SecCode = 522882 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 558540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT5J2R5' WHERE SecCode = 588831 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 637304 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 = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 853527 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 = 1209871 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 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 DsCtryQtStatus = 'S' WHERE SecCode = 1693310 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 Name = 'EAM SOLAR AS NOK1' WHERE SecCode = 2173082 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 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 = '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 = 2593559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2701612 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2729683 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2855943 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 IsPrimaryInstr = 1.0 WHERE SecCode = 2912882 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ATMI.BO', RkdDisplayRIC = 'ATMI.BO', DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2952375 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2963471 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'HPM.HNO^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-05', PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-05' WHERE SecCode = 3062337 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3076058 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3194837 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 DsCtryQtStatus = 'A' WHERE SecCode = 3217958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3358921 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3390477 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3435529 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3436907 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'BOOSTHEAT EUR0.2' WHERE SecCode = 3978248 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '3DA', DsPrimQtSedol = 'BKRQJZ8' WHERE SecCode = 4036738 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 4043304 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 4434255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4440272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'M96', DsPrimQtSedol = 'BX59CS4' WHERE SecCode = 4565158 AND Type_ = 10;
UPDATE data_universe SET Name = 'FIBO SA PLN0.10' WHERE SecCode = 4582489 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 = 'S' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 4854751 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 5134669 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET Name = 'DOLPHIN DRILLING NOK2.5' WHERE SecCode = 5155393 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5272018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5281304 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5399782 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET Name = 'KRUSO KAPITAL S.P. NPV.' WHERE SecCode = 5635825 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 6065879 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6203038 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-18', PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-18' WHERE SecCode = 6305206 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236806935461.0, InstrPermID = 232934680680.0, OrgPermID = 5076944702.0, PriValQuotePermID = 236806935461.0, PriInstrPermID = 21772232735.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951833.0, PermQuoteRetireDate = '2026-06-22', PermOrgIPODate = '2023-01-17', PermSecMapStartDate = '2026-05-11', PermSecMapEndDate = '2026-06-21', startDate = '2026-05-11' WHERE SecCode = 6849662 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 6880028 AND Type_ = 10;
UPDATE data_universe SET Name = 'TIDHAR GROUP LTD NPV' WHERE SecCode = 6902210 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927580 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927581 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927582 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927583 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927584 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927585 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6927586 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE2L0V01019', RkdTicker = '544793', RkdSEDOL = 'BSRDB3', RkdCUSIP = 'Y832EU10', RkdRIC = 'SUSN.BO', RkdDisplayRIC = 'SUSN.BO', RkdCode = 145041.0, RkdIssueID = 1.0, RkdIssueCode = 185562.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6927587 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BOHUS', QuotePermID = 236808613401.0, IsPrimaryQuote = 1.0, ExchCode = 'OSL' WHERE SecCode = 6927600 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930573 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930574 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930575 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930576 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930577 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930578 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6930579 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236805390569.0 WHERE SecCode = 6930638 AND Type_ = 10;
UPDATE data_universe SET Name = 'PARKIT ENTERPRISE INC COM SHS' WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951210.0 WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 10973754 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 10987798 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX55HP4' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRSCWV1' WHERE SecCode = 11138087 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 11160125 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRSCZS9' WHERE SecCode = 11198767 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2079-06-06', endDate = '2026-06-19' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET Name = 'FIRY INC COM' WHERE SecCode = 11207267 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVSRPF9' WHERE SecCode = 11214004 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000156910.0, PriInstrPermID = 25727305270.0, PermOrgIPODate = '2020-11-06' WHERE SecCode = 11214228 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000156910.0, PriInstrPermID = 25727305270.0, IsPrimaryInstr = 1.0, PermOrgIPODate = '2020-11-06', startDate = '2020-11-06' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 11232560 AND Type_ = 1;
UPDATE data_universe SET Name = 'SMARTBIRD INC COM CL A' WHERE SecCode = 11233216 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000148932.0, DomCntry = NULL, PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = NULL WHERE SecCode = 11234647 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-10-12' WHERE SecCode = 11246642 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 11249600 AND Type_ = 1;
UPDATE data_universe SET Name = 'OSR HEALTH INC COM', PriTRBCIndPermID = NULL WHERE SecCode = 11250417 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRSCV25' WHERE SecCode = 11264467 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWTYQX1' WHERE SecCode = 11266759 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-02-03' WHERE SecCode = 11272673 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-02-03' WHERE SecCode = 11274579 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe SET Name = 'TEAMSHARES INC CL A SHS', DsPrimQtSedol = 'BVSRPN7' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5086637871.0, PriInstrPermID = 232883208784.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5086637871.0, PriInstrPermID = 232883208784.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11295027 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', COATypeCode = 'IND' WHERE SecCode = 11295063 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11295148 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11295151 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11295152 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 11295230 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US31556C1062', RkdTicker = 'FRVO', RkdSEDOL = 'BVK0QZ', RkdCUSIP = '31556C10', RkdRIC = 'FRVO.O', RkdDisplayRIC = 'FRVO.OQ', RkdCode = 145040.0, RkdIssueID = 1.0, RkdIssueCode = 185560.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295811 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295860 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11296944 AND Type_ = 1;
