UPDATE data_universe SET RkdRIC = 'SCEU.L^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-26', SecMapEndDate = '2026-05-20', PermQuoteRetireDate = '2026-05-26', PermSecMapEndDate = '2026-05-26', endDate = '2026-05-20' WHERE SecCode = 4052 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11473 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951766.0 WHERE SecCode = 19818 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 27983 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 28027 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 29804 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 30232 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueCode = 33416.0 WHERE SecCode = 31067 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueCode = 33416.0 WHERE SecCode = 31179 AND Type_ = 10; UPDATE data_universe SET Name = 'AEDES SPA NPV AEDES', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 34059 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-05-25' WHERE SecCode = 49578 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'GIVG.SG', RkdDisplayRIC = 'GIVG.SG', RkdIssueStatus = 1.0, RkdExchCode = 'BWB' WHERE SecCode = 56158 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 56948 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 58061 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'TREVI FINANZIARIA EUR1', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 59824 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69942 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 69969 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 DsCtryQtStatus = 'S' WHERE SecCode = 72266 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73041 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76492 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76739 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 78006 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 RkdSEDOL = NULL WHERE SecCode = 78237 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 = 'A' WHERE SecCode = 78925 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79084 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 = 82358 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82359 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82656 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10; UPDATE data_universe SET Name = 'BOUNTY OIL & GAS NPV DFD 28/05/26(EX-SPLIT)' WHERE SecCode = 83612 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 85118 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 85334 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BXGT6V', DsPrimQtSedol = 'BXGT6V4', SecMapEndDate = '2026-05-25', endDate = '2026-05-25' WHERE SecCode = 90242 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 91066 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10; UPDATE data_universe SET Name = 'MDS RETAILING TBK LKD SHS(IDR5000 & IDR350 &' WHERE SecCode = 91760 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 92018 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92836 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 94018 AND Type_ = 1; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'NCR RESOURCES LIMI NPV' WHERE SecCode = 96942 AND Type_ = 10; UPDATE data_universe SET Name = 'QUADRAVEST CAPITAL MANAGEMEN PRIM DI CO CL NO' WHERE SecCode = 98211 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 QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 103909 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 105486 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114727 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 115380 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115981 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 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 = 124738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125442 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 = 126342 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 = 126439 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE678B01039', RkdSEDOL = 'BXCWSM', RkdCUSIP = 'Y3854T13', DsPrimQtSedol = 'BXCWSM2', PermSecMapEndDate = '2026-05-25', endDate = '2026-05-25' WHERE SecCode = 126440 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 = 126595 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 DsCtryQtStatus = 'S' WHERE SecCode = 132399 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 = 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 = 137011 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 RkdISIN = 'AU0000471252', RkdTicker = 'LAC', PermIDTicker = 'LAC', RkdSEDOL = 'BKVF43', RkdRIC = 'LAC.AX', RkdDisplayRIC = 'LAC.AX', DsPrimQtSedol = 'BKVF434', SecMapEndDate = '2026-05-24', PermSecMapEndDate = '2026-05-25', endDate = '2026-05-24' WHERE SecCode = 140815 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 141223 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 141819 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142542 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144665 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 146104 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 = 257809 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 258767 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 285306 AND Type_ = 10; UPDATE data_universe SET Name = 'BROMPTON FUNDS LTD. LIFE SP CO COM A' WHERE SecCode = 293451 AND Type_ = 1; UPDATE data_universe SET Name = 'QUADRAVEST CAPITAL MANAGEMEN TDB SP CO SH CL' WHERE SecCode = 317359 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 318162 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 = 425905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 429392 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 = 537537 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 866787 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 903247 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 1122451 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 DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 1210106 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1349008 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1445509 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1456152 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1619265 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 1671641 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 DsCtryQtStatus = 'S' WHERE SecCode = 2193116 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 2300024 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 DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 2484920 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2499277 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2514640 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 DsPrimQtSedol = 'BXGT6V4' WHERE SecCode = 2650077 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2658230 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'GUJJ.BO', RkdDisplayRIC = 'GUJJ.BO' WHERE SecCode = 2659213 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2701612 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2725363 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2763364 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2853468 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2865456 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2882481 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 = 2937562 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2963471 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 3038373 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3053961 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3055003 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3064630 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE108T01021', RkdSEDOL = 'BXGTMK', RkdCUSIP = 'Y2575Q12', DsPrimQtSedol = 'BXGTMK5', PermSecMapEndDate = '2026-05-25', endDate = '2026-05-25' WHERE SecCode = 3069380 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3072605 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3084613 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3101370 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3200982 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 = 'S' WHERE SecCode = 3247535 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3255090 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3262686 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3318059 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 RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3405594 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3431044 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3436908 AND Type_ = 10; UPDATE data_universe SET DsExchMnem = 'HNX' WHERE SecCode = 3531558 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4298610 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4408305 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4408307 AND Type_ = 10; UPDATE data_universe SET Name = 'VETTED ASSETS AB NPV' WHERE SecCode = 4524561 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951824.0 WHERE SecCode = 4588371 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'TOFD', PermIDTicker = 'TOFD', RkdRIC = 'TOFD.TA', RkdDisplayRIC = 'TOFD.TA' WHERE SecCode = 4784326 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5202071 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'LAC', DsPrimQtSedol = 'BKVF434' WHERE SecCode = 5600663 AND Type_ = 10; UPDATE data_universe SET Name = 'PUB PROP INV ASA NPV', Country = 'NOR' WHERE SecCode = 5738497 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 5824200 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5975843 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5978189 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'X4802U25' WHERE SecCode = 6622147 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'SGXE84077846', RkdTicker = 'KIN', RkdSEDOL = 'BVPQR3', RkdRIC = 'KINL.SI', RkdDisplayRIC = 'KINL.SI', RkdCode = 144883.0, RkdIssueID = 1.0, RkdIssueCode = 185330.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SIN', RkdExchCtry = 'SGP', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6802674 AND Type_ = 10; UPDATE data_universe SET Name = 'QUADRAVEST CAPITAL MANAGEMEN M SP CO CA SH' WHERE SecCode = 10934016 AND Type_ = 1; UPDATE data_universe SET Name = 'QUADRAVEST INC. PFD SHS CL II' WHERE SecCode = 10958845 AND Type_ = 1; UPDATE data_universe SET Name = 'COMMERCE SPLIT CORP CORP CAP SHS' WHERE SecCode = 10958846 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 10986427 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11019099 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11143036 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 11162946 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11165423 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11172678 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11174950 AND Type_ = 1; UPDATE data_universe SET Name = 'BIG PHARMA SPLIT CORP CLASS A SHS' WHERE SecCode = 11179563 AND Type_ = 1; UPDATE data_universe SET Name = 'PINNACLE FINL PARTNERS INC FIX FL NCUM PF A' WHERE SecCode = 11186432 AND Type_ = 1; UPDATE data_universe SET Name = 'PINNACLE FINL PARTNERS INC FIX RA NCUM PF B' WHERE SecCode = 11198210 AND Type_ = 1; UPDATE data_universe SET Name = 'XCYTE DIGITAL CORP SUBOR VTG SHS' WHERE SecCode = 11210896 AND Type_ = 1; UPDATE data_universe SET Name = 'REAL ESTATE SPLIT CORP CORP CL A SHS' WHERE SecCode = 11214925 AND Type_ = 1; UPDATE data_universe SET DsExchMnem = 'TSE', DsExchQtStartDate = '2026-05-21' WHERE SecCode = 11216466 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11219078 AND Type_ = 1; UPDATE data_universe SET Name = 'ANGEL STUDIOS INC. CL A COM' WHERE SecCode = 11237780 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'BTMCQ', RkdRIC = 'BTMCQ.PK', RkdDisplayRIC = 'BTMCQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 11241004 AND Type_ = 1; UPDATE data_universe SET Name = 'BANC OF CALIFORNIA INC DEP SHS PFD F' WHERE SecCode = 11242408 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11247542 AND Type_ = 1; UPDATE data_universe SET Name = 'MACH NATURAL RESOURCES LP COM UN LT PA IN' WHERE SecCode = 11259127 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11261898 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-26', SecMapEndDate = '2026-05-22', PermSecMapEndDate = '2026-05-26', endDate = '2026-05-22' WHERE SecCode = 11268849 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11270991 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11271538 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2024-12-28' WHERE SecCode = 11273589 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 11275118 AND Type_ = 1; UPDATE data_universe SET Name = 'LIBERTY CAPITAL CORPORATION COM SER A' WHERE SecCode = 11280431 AND Type_ = 1; UPDATE data_universe SET Name = 'LIBERTY CAPITAL CORPORATION COM SER C' WHERE SecCode = 11280432 AND Type_ = 1; UPDATE data_universe SET Name = 'PINNACLE FINL PARTNERS INC FIX FL NCUM PF A' WHERE SecCode = 11290244 AND Type_ = 1; UPDATE data_universe SET Name = 'PINNACLE FINL PARTNERS INC FIX RA NCUM PF B' WHERE SecCode = 11290245 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11290981 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11290984 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291750 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11292241 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293143 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293308 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293509 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11294417 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11294692 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US81221K1088', RkdTicker = 'SPTX', RkdSEDOL = 'BVVC86', RkdCUSIP = '81221K10', RkdRIC = 'SPTX.O', RkdDisplayRIC = 'SPTX.OQ', RkdCode = 144882.0, RkdIssueID = 1.0, RkdIssueCode = 185329.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295203 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 11295229 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA80620E1016', RkdTicker = 'SMCD.P', RkdSEDOL = 'BX567R', RkdCUSIP = '80620E10', RkdRIC = 'SMCDp.V', RkdDisplayRIC = 'SMCDp.V', RkdCode = 144879.0, RkdIssueID = 1.0, RkdIssueCode = 185322.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295411 AND Type_ = 1; UPDATE data_universe SET SecMapStartDate = '2026-05-07' WHERE SecCode = 11295442 AND Type_ = 1; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11295488 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295602 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11295695 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295985 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US20715F1003', RkdTicker = 'CNXU', RkdSEDOL = 'BN4KJM', RkdCUSIP = '20715F10', RkdRIC = 'CNXU.O', RkdDisplayRIC = 'CNXU.OQ', RkdCode = 144878.0, RkdIssueID = 1.0, RkdIssueCode = 185319.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11296272 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PECEU', QuotePermID = 236797173556.0, InstrPermID = 232903886036.0, OrgPermID = 5096920868.0, PriInstrPermID = 232903886036.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-22', PermSecMapStartDate = '2026-05-21', startDate = '2026-05-21' WHERE SecCode = 11296373 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG8116J1058', RkdTicker = 'SAGU', RkdSEDOL = 'BT3HML', RkdCUSIP = 'G8116J10', RkdRIC = 'SAGU.K', RkdDisplayRIC = 'SAGU.N', RkdCode = 144825.0, RkdIssueID = 1.0, RkdIssueCode = 185208.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11296376 AND Type_ = 1;