UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 915 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2587 AND Type_ = 10;
UPDATE data_universe SET RkdDisplayRIC = 'TFC.N' WHERE SecCode = 7536 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 9703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11418 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 12348 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'EXAS.OQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 24869 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951771.0 WHERE SecCode = 28600 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 41247 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 45301 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'NGD.TO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 50228 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 53655 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US7240782091', RkdSEDOL = 'BVLNNN', RkdCUSIP = '72407820', DsPrimQtSedol = 'BVLNNN8' WHERE SecCode = 56167 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 56762 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 56796 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET RkdDisplayRIC = 'SGRP.OQ' WHERE SecCode = 61660 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 64039 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 66291 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74445 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'CCR', PrimaryIssueCode = 22316.0 WHERE SecCode = 74703 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7635.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-24', SecMapEndDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 75052 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GVND.BO^D25', RkdIssueStatus = 0.0 WHERE SecCode = 78131 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79236 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-03-19', PermSecMapEndDate = '2026-03-22', endDate = '2026-03-19' WHERE SecCode = 80329 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = NULL WHERE SecCode = 81537 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81568 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82108 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 82762 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 3.0 WHERE SecCode = 83798 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 86958 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-03-19', PermSecMapEndDate = '2026-03-22', endDate = '2026-03-19' WHERE SecCode = 87315 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88321 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 = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91289 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 92181 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 92577 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'KNEOMEDIA LTD NPV' WHERE SecCode = 93867 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 94983 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 COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99460 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 22316.0 WHERE SecCode = 99970 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 122690 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 122791 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126781 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 132080 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 132617 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SAPR.BO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-23', SecMapEndDate = '2024-08-12', PermQuoteRetireDate = '2026-03-24', endDate = '2024-08-12' WHERE SecCode = 135942 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145002 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 145310 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 194176 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 199026 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 252435 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 255424 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258792 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 290921 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 293451 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 347012 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 376026 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 383497 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 411775 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 450695 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 519052 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 550827 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 692769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 703064 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 776068 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 839885 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 890004 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 918649 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 940672 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1082058 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1110147 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 1139779 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1262130 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1270231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1316139 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1382814 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q0R81T11' WHERE SecCode = 1465316 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1630431 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1631904 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1643769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1725334 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2065778 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2152212 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2294759 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 2361705 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2367784 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2373426 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2461864 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2462091 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 2518693 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2523128 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2563183 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 2622292 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2835196 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2864249 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2865468 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2870124 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2872655 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 2887268 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2915026 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2918009 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2928723 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2937551 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2947814 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2959530 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2961761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2974277 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3018641 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3022438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3044826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3048457 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3049345 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3050876 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051792 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051797 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3064787 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3067181 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3087022 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3133501 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3157196 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3162862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172341 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172415 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3177070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3181407 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3184000 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2023-11-01', PermSecMapEndDate = '2026-03-23', endDate = '2023-11-01' WHERE SecCode = 3200664 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3213023 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3242484 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-03-19', PermSecMapEndDate = '2026-03-22', endDate = '2026-03-19' WHERE SecCode = 3247113 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 3266302 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3276031 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283859 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283969 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3285690 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3295160 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8655R25' WHERE SecCode = 3296401 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3297239 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3304566 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BRPPLAUNT007', RkdTicker = 'PPLA11', RkdSEDOL = 'BF2LP8', RkdCUSIP = 'P7S0EN13', RkdRIC = 'PPLA11.SA', RkdDisplayRIC = 'PPLA11.SA', RkdIssueOrder = 2.0, RkdListingType = NULL, RkdExchCode = 'SAO', RkdExchCtry = 'BRA' WHERE SecCode = 3306808 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3317888 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347459 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347763 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3365085 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3368522 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3374472 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3392350 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3392371 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3393831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401731 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401776 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3402856 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'KY', DomCntry = 'CYM' WHERE SecCode = 3403840 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3407187 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FUTE.NS^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-24', SecMapEndDate = '2025-10-27', endDate = '2025-10-27' WHERE SecCode = 3409197 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3409783 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3435135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3441470 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445582 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445583 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3511850 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3520029 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3527769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3559180 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3586927 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3588090 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3593756 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3745523 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3750914 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3773445 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3784691 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3799576 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3809775 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3827729 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3901291 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3939942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3945211 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 COATypeCode = '' WHERE SecCode = 3978268 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4041277 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4046400 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4054122 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4054495 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4060785 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4081906 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4087371 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4156862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4240052 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 COATypeCode = '' WHERE SecCode = 4310593 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4313231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4339145 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4341610 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4377200 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4382912 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4446112 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4456283 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4550734 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4557733 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 COATypeCode = '' WHERE SecCode = 4563452 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-03-20', PermQuoteRetireDate = '2026-03-23', endDate = '2026-03-20' WHERE SecCode = 4578183 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4580741 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4592043 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4598562 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4603473 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615772 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615787 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615941 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4616827 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4620141 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4622018 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4638782 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4716072 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BRAINP.CO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-24', SecMapEndDate = '2026-03-19', PermQuoteRetireDate = '2026-03-24', endDate = '2026-03-19' WHERE SecCode = 4731832 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4750452 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4786370 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4807668 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4893249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21923937062.0, ExchCode = 'MUN' WHERE SecCode = 4959594 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4989476 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5025166 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5122912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5156824 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 5176772 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5288763 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5347334 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5367666 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 5398946 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5434330 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5440961 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5448755 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5466047 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5500244 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5511073 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5516786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5535014 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5563070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5610275 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5658429 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5686490 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5760059 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5804325 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5820916 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5821016 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5839359 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5886907 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5936391 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5975843 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5985400 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5999070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6018364 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6020925 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6039879 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6048000 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6092920 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6114249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6117162 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6203038 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6220150 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6223908 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6289734 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6300607 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6324115 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6347455 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361850 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6389703 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6400766 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6407335 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6448288 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6450911 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6482833 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6490057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6538858 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6538865 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6558331 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6562448 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6562602 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6571970 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6578038 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6590752 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6593987 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6598936 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6601641 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6605884 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0023594528', RkdTicker = 'ELLOS', RkdSEDOL = 'BTBKQ5', RkdCUSIP = 'W2R51G10', RkdRIC = 'ELLOS.NFF', RkdDisplayRIC = 'ELLOS.NFF', RkdCode = 144529.0, RkdIssueID = 1.0, RkdIssueCode = 184706.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NFF', RkdExchCtry = 'NOR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6608224 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6614114 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6622333 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6622350 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6626814 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6627229 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6627674 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6628669 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6628819 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6629614 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6631816 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6635227 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6635229 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6638309 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6643268 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6645649 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6645652 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6645655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6649305 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6658285 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6664664 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6672539 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6674464 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6685955 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6694374 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6702410 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6702411 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6705491 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6705492 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6705493 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6705695 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6708243 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6710146 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6712342 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-24', SecMapEndDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 6719150 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6728353 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000VNC0014', RkdTicker = 'V1NC', RkdSEDOL = 'BW5VWD', RkdCUSIP = 'D8T4XZ10', RkdRIC = 'V1NC.DE', RkdDisplayRIC = 'V1NC.DE', RkdCode = 144528.0, RkdIssueID = 1.0, RkdIssueCode = 184705.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ETR', RkdExchCtry = 'DEU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6728563 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10928445 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10934016 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10963618 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10979389 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10983013 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10985917 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10990193 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11002517 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11003868 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 11003923 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11024269 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US35953D4016', RkdSEDOL = 'BWTYSN', RkdCUSIP = '35953D40', DsPrimQtSedol = 'BWTYSN5' WHERE SecCode = 11030696 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11031081 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11046194 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11073795 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11115529 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11143036 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11146600 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11153770 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-22', endDate = '2026-03-22' WHERE SecCode = 11156315 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11158900 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11159154 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11165205 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11165973 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11166433 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11169166 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11174613 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11176658 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11180458 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11183295 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11183588 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11186234 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11186810 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'RVR.CD^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 11189384 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11190289 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11191099 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11192602 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHINA SXT PHARMACEUTICALS IN USD CL A ORD SHS' WHERE SecCode = 11193246 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11194907 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11199469 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11203428 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11204795 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11209243 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11211492 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11214658 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11214925 AND Type_ = 1;
UPDATE data_universe SET Name = 'CORVEX INC COM' WHERE SecCode = 11221473 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11226015 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0, startDate = '2021-09-20' WHERE SecCode = 11230025 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11234547 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11235400 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-22', endDate = '2026-03-22' WHERE SecCode = 11235694 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11237048 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11237780 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11241711 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 11244824 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11246941 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11250261 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11256311 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11258687 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11258995 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11262695 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11263217 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11265031 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-22', endDate = '2026-03-22' WHERE SecCode = 11265202 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11266729 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-22', endDate = '2026-03-22' WHERE SecCode = 11268806 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11271326 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11272073 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000066687.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 11272207 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11275070 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11276401 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277332 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-22', endDate = '2026-03-22' WHERE SecCode = 11277444 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 1.0 WHERE SecCode = 11278125 AND Type_ = 1;
UPDATE data_universe SET Name = 'AURONOVA RES INC COM SHS', COATypeCode = '' WHERE SecCode = 11278789 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11279787 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 11280338 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284555 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11287866 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11288510 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11289033 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11289318 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11289387 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11289422 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, QuotePermID = 236802295092.0, IsPrimaryInstr = 0.0, ExchCode = 'NAS' WHERE SecCode = 11289849 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11290818 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11290984 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11290991 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291071 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291140 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291142 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291253 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291346 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 11291349 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291563 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291582 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291636 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291711 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291746 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291750 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291832 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291844 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291898 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11291899 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292189 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292229 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292240 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292424 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292621 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NBRKF', QuotePermID = 236803759300.0, InstrPermID = 21916861689.0, OrgPermID = 5078678616.0, PriValQuotePermID = 21916839389.0, PriInstrPermID = 21916861689.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 = '2022-09-07', PermSecMapStartDate = '2026-03-03' WHERE SecCode = 11292690 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292838 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292932 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292933 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11292967 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293198 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293243 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293248 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293292 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293310 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293311 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11293453 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CLCH', ModelCntry = 'CA', QuotePermID = 236804484471.0, InstrPermID = 232911350002.0, OrgPermID = 5081494824.0, PriValQuotePermID = 236804484471.0, PriInstrPermID = 232911350002.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951913.0, PermOrgIPODate = '2026-03-20', PermSecMapStartDate = '2026-03-18', startDate = '2026-03-18' WHERE SecCode = 11293460 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JAN', COATypeCode = '', QuotePermID = 236803758785.0, InstrPermID = 232923694983.0, OrgPermID = 6000018682.0, PriTrdQuotePermID = 236803758785.0, PriValQuotePermID = 25727032020.0, PriInstrPermID = 232923694983.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'CINV', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951323.0, PermOrgIPODate = '2026-03-20', PermSecMapStartDate = '2026-03-18', startDate = '2026-03-18' WHERE SecCode = 11293479 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BWIV.U', ModelCntry = 'US', QuotePermID = 236804485475.0, InstrPermID = 232922953833.0, OrgPermID = 5097058005.0, PriTrdQuotePermID = 236804485475.0, PriValQuotePermID = 25727029945.0, PriInstrPermID = 232922953833.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-03-20', PermSecMapStartDate = '2026-03-19', startDate = '2026-03-19' WHERE SecCode = 11293509 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KRAQ', ModelCntry = 'US', QuotePermID = 236804538001.0, InstrPermID = 232910237563.0, OrgPermID = 5097125294.0, PriTrdQuotePermID = 236804538001.0, PriValQuotePermID = 25727029817.0, PriInstrPermID = 232910237563.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-01-28', PermSecMapStartDate = '2026-03-20', startDate = '2026-01-28' WHERE SecCode = 11293510 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SAAQ', ModelCntry = 'US', QuotePermID = 236804485510.0, InstrPermID = 232916052851.0, OrgPermID = 5096984952.0, PriTrdQuotePermID = 236804485510.0, PriValQuotePermID = 25727029923.0, PriInstrPermID = 232916052851.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-01-28', PermSecMapStartDate = '2026-03-19', startDate = '2026-01-28' WHERE SecCode = 11293512 AND Type_ = 1;
