UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 762 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 1762 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 2070 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 2071 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 5312 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 5314 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 5476 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 5515 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 6154 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-28', PermSecMapEndDate = '2026-08-28' WHERE SecCode = 6892 AND Type_ = 1; UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 7127 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 11339 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 13089 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US36117V6002', RkdSEDOL = 'BVPTKR', RkdCUSIP = '36117V60', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 23996 AND Type_ = 1; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 31008 AND Type_ = 1; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 33300 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'PAAI', PermIDTicker = 'PAAI', RkdRIC = 'PAAI.K', RkdDisplayRIC = 'PAAI.A' WHERE SecCode = 36397 AND Type_ = 1; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 40135 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 57494 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 21757842473.0, ExchCode = 'BER', PermQuoteRetireDate = '2021-06-11' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68018 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 69176 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70042 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76103 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76715 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78740 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 80870 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 82262 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82801 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83586 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55838797189.0, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90016 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 95043 AND Type_ = 1; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 95839 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96166 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21748242454.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 102656 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115197 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115980 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115997 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116213 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116617 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120585 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125539 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125625 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125692 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126429 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126430 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126457 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126634 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126638 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126828 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126972 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130886 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133893 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134770 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134846 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135125 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135272 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135448 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135730 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135958 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2026-08-28', endDate = '2026-08-28' WHERE SecCode = 136004 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136034 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136507 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136772 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136775 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136779 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136981 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136987 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136991 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138036 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 139413 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142542 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142799 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 147160 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 161250 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 180539 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 193324 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243154 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243222 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243314 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 254713 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 309037 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 346531 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378080 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395045 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 401626 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 403765 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 408145 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-16' WHERE SecCode = 412789 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425884 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 431231 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 490265 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 521162 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '082640.KS^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-31', PermQuoteRetireDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 548524 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 560734 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 794875 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 846667 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 999958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1151589 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209860 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209863 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209871 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1622760 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1627735 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1629626 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1670286 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CTY1SN011', QuotePermID = 21512412458.0, ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1693310 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1980972 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2341361 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2373427 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2380641 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2387392 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 2394815 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2529641 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951687.0 WHERE SecCode = 2560607 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951331.0 WHERE SecCode = 2579463 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2580912 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 2583457 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2604161 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2621757 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951512.0 WHERE SecCode = 2646533 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 2693650 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 2747570 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2753903 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951564.0 WHERE SecCode = 2755821 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 2761273 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2782958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2912848 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951233.0 WHERE SecCode = 2921488 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2923366 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951872.0 WHERE SecCode = 2924585 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3001070 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3084613 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3187179 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212191 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3225482 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3233484 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3247566 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3272839 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3309013 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3317677 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3344593 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3441467 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-31', PermQuoteRetireDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 3441470 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 3505145 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3564647 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3574012 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3587036 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3616775 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Q2039L19' WHERE SecCode = 3721200 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3754743 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-31', PermQuoteRetireDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 3843087 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3930588 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4053515 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-09-29' WHERE SecCode = 4089894 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 4510031 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4531619 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4579643 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2018-03-23' WHERE SecCode = 4749894 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4873565 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5035049 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '4328', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BX53HG9' WHERE SecCode = 5041664 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5078439 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5234143 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778518455.0, ExchCode = 'FRA' WHERE SecCode = 5482616 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5534935 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '6022', DsCtryQtStatus = 'A', PermSecMapEndDate = '2026-08-28', endDate = '2026-08-28' WHERE SecCode = 5597158 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5612363 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-31', PermQuoteRetireDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 5631491 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5738355 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6281750 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6902161 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7040597 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0, PermOrgIPODate = '2026-08-28' WHERE SecCode = 7044848 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 7073251 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'OMC', QuotePermID = 236813198396.0, InstrPermID = 232950020678.0, OrgPermID = 6000235583.0, PriValQuotePermID = 236813198396.0, PriInstrPermID = 232950020678.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'OSL', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'BMU', IncCntry = 'BMU', PriTRBCIndPermID = 4294951973.0, PermOrgIPODate = '2026-08-28', PermSecMapStartDate = '2026-08-27' WHERE SecCode = 7075697 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2026-08-28' WHERE SecCode = 7075702 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2026-08-28' WHERE SecCode = 7075707 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BNNNK5', RkdRIC = 'PPTA.O', RkdDisplayRIC = 'PPTA.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA', QuotePermID = 25727287084.0, ExchCode = 'NAS', PermSecMapStartDate = '2021-02-18', startDate = '2011-07-14' WHERE SecCode = 11006190 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US45824Q8877', RkdSEDOL = 'BVPTKW', RkdCUSIP = '45824Q88', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11045990 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2013-01-15' WHERE SecCode = 11046053 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11147281 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5096993995.0, PriInstrPermID = 21543150288.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 11149514 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US04301G8050', RkdSEDOL = 'BVPTJB', RkdCUSIP = '04301G80', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11153097 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BV8CW19' WHERE SecCode = 11156680 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-28', PermSecMapEndDate = '2026-08-28' WHERE SecCode = 11171002 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5096993995.0, PriInstrPermID = 21543150288.0, OrgTypeCode = 'UNK', PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 11178183 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 11180183 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BWH9S65' WHERE SecCode = 11186707 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-08-28', endDate = '2026-08-28' WHERE SecCode = 11191545 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'CSRVF' WHERE SecCode = 11211670 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US38942Q3011', RkdSEDOL = 'BVPTK3', RkdCUSIP = '38942Q30', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11212907 AND Type_ = 1; UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11216072 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-31', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11216266 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US6934892059', RkdSEDOL = 'BVPTL3', RkdCUSIP = '69348920', DsPrimQtSedol = 'BVPTL38', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11223856 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US9189422028', RkdSEDOL = 'BVPTL2', RkdCUSIP = '91894220', DsPrimQtSedol = 'BVPTL27', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11233903 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US65345B3006', RkdSEDOL = 'BVPTKX', RkdCUSIP = '65345B30', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11245715 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US89669L3069', RkdSEDOL = 'BT9RPH', RkdCUSIP = '89669L30', DsPrimQtSedol = 'BT9RPH6', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11250372 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG6S38M1318', RkdSEDOL = 'BVPTKZ', RkdCUSIP = 'G6S38M13', DsPrimQtSedol = 'BVPTKZ3', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11250501 AND Type_ = 1; UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11266167 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-28', PermSecMapEndDate = '2026-08-28' WHERE SecCode = 11267479 AND Type_ = 1; UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11268449 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US42227T3032', RkdSEDOL = 'BNGC7L', RkdCUSIP = '42227T30', DsPrimQtSedol = 'BNGC7L0', PermSecMapEndDate = '2026-08-29', endDate = '2026-08-29' WHERE SecCode = 11269574 AND Type_ = 1; UPDATE data_universe SET PriTrdQuotePermID = 236804914388.0, PriValQuotePermID = 22169410018.0 WHERE SecCode = 11278379 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-08-28', PermSecMapEndDate = '2026-08-28' WHERE SecCode = 11281575 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11282159 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'XLAB' WHERE SecCode = 11283919 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-08-28', PermSecMapEndDate = '2026-08-28' WHERE SecCode = 11290408 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSQL' WHERE SecCode = 11291179 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ATLQU' WHERE SecCode = 11297350 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11298526 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232944098261.0 WHERE SecCode = 11299061 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG034561293', RkdTicker = 'AMACU', RkdSEDOL = 'BXP2VX', RkdCUSIP = 'G0345612', RkdRIC = 'AMACU.O', RkdDisplayRIC = 'AMACU.OQ', RkdCode = 145420.0, RkdIssueID = 1.0, RkdIssueCode = 186145.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11299372 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA02290C1086', RkdTicker = 'AMAP', RkdSEDOL = 'BRCB6H', RkdCUSIP = '02290C10', RkdRIC = 'AMAP.TO', RkdDisplayRIC = 'AMAP.TO', RkdCode = 145421.0, RkdIssueID = 1.0, RkdIssueCode = 186147.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11299619 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ATLQ' WHERE SecCode = 11300122 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11300648 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'AAC', QuotePermID = 236813154830.0, InstrPermID = 232941848040.0, OrgPermID = 6000164544.0, PriTrdQuotePermID = 236813154812.0, PriValQuotePermID = 25726992227.0, PriInstrPermID = 232941848040.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'XNE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-30', PermSecMapStartDate = '2026-08-27', startDate = '2026-06-30' WHERE SecCode = 11301061 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'XTER', QuotePermID = 236813154966.0, InstrPermID = 232946991499.0, OrgPermID = 6000220221.0, PriTrdQuotePermID = 236813154966.0, PriValQuotePermID = 25726992094.0, PriInstrPermID = 232946991499.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-08-18', PermSecMapStartDate = '2026-08-27', startDate = '2026-08-18' WHERE SecCode = 11301063 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RNAQU', QuotePermID = 236813154963.0, InstrPermID = 232947349140.0, OrgPermID = 6000269058.0, PriTrdQuotePermID = 236813154946.0, PriValQuotePermID = 25726992185.0, PriInstrPermID = 232947349140.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'XNC', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-08-27', PermSecMapStartDate = '2026-08-27' WHERE SecCode = 11301064 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'IPHXU', QuotePermID = 236812378938.0, InstrPermID = 232949622946.0, OrgPermID = 6000246592.0, PriTrdQuotePermID = 236812378938.0, PriValQuotePermID = 25726993657.0, PriInstrPermID = 232949622946.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-08-28', PermSecMapStartDate = '2026-08-28' WHERE SecCode = 11301108 AND Type_ = 1;