UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1386 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 9028 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10981 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 27223 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 27786 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 30034 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BXCGHG', PermSecMapEndDate = '2026-05-30', endDate = '2026-05-30' WHERE SecCode = 32929 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 44507 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 45794 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 6000143481.0, PriInstrPermID = 8590936144.0, PermOrgIPODate = NULL WHERE SecCode = 49041 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 51554 AND Type_ = 10; UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 51555 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 21500701254.0 WHERE SecCode = 56158 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 57184 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ARTU.I', QuotePermID = 21475582436.0, ExchCode = 'CAM', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 62097 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69942 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 RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 73964 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76487 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76492 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78203 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 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 = 78742 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79462 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81754 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82140 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82359 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82584 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82656 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82957 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '1726.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 87641 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 = 91332 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92313 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92836 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'FO.V^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 93886 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'LIS.V^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 94475 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 DsCtryQtStatus = 'A' WHERE SecCode = 95877 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 97555 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21474872920.0, PriValQuotePermID = 21788257848.0, IsPrimaryQuote = 0.0, ExchCode = 'KAB', PermQuoteRetireDate = '2011-11-01', endDate = '2011-11-01' WHERE SecCode = 97597 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '6201.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 97844 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 98717 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21616157076.0, ExchCode = 'MCX' WHERE SecCode = 102656 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 113724 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114727 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115197 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115981 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116213 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119593 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 = 125442 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 = 125762 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 = 126342 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 = 126433 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126439 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 = 126595 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126831 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 = 131520 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 132399 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 = 135730 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136499 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136507 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136734 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 = 137011 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 = 144665 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 145422 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 193324 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 243153 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 DsCtryQtStatus = 'A' WHERE SecCode = 257809 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 258767 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'LOGIa.ST^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 291899 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 294907 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US8677818093', RkdSEDOL = 'BXCGG5', RkdCUSIP = '86778180', DsPrimQtSedol = 'BXCGG53' WHERE SecCode = 317489 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 320346 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 357801 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 367748 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 RkdRIC = 'STEH.BO^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', SecMapEndDate = '2024-12-02', endDate = '2024-12-02' WHERE SecCode = 378468 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 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 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 = 429392 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 = 'A' WHERE SecCode = 537537 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 549523 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 556650 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 562961 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 786648 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 797952 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 833514 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 900837 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1072078 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1077940 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 PermInstrStatus = 'DC' WHERE SecCode = 1214471 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1619265 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1627735 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1644134 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1670286 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' 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 PermInstrStatus = 'DC' WHERE SecCode = 2152212 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2193116 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 21668632693.0 WHERE SecCode = 2216872 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2356424 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 DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469416 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2587195 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2593559 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2701612 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2725363 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2739709 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2763364 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2853468 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 DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2937562 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '6173.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 2955168 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2963471 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21777322524.0, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23', endDate = '2021-03-22' WHERE SecCode = 2976573 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3001070 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3005679 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3064630 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3084613 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 21575800338.0, IsPrimaryQuote = 1.0 WHERE SecCode = 3130996 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3200982 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3207868 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 DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3305356 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3309013 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3379538 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3384465 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3396069 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3406950 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3436908 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 3566698 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3631185 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 3682014 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3754743 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3945211 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 3961764 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 = 'A' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 21575800338.0 WHERE SecCode = 4066633 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 4079100 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 PermInstrStatus = 'DC' WHERE SecCode = 4339135 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4372706 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4425686 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '257990.KN^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-01', SecMapEndDate = '2026-05-13', endDate = '2026-05-13' WHERE SecCode = 4456235 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 4510247 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 21801065554.0 WHERE SecCode = 4513760 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' 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 QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4811133 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = 21575800338.0 WHERE SecCode = 5145485 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21979863375.0, ExchCode = 'DEU' WHERE SecCode = 5482616 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5553171 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5597638 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5657397 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5978189 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 6318935 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6786369 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-01', SecMapEndDate = '2026-05-29', endDate = '2026-05-29' WHERE SecCode = 6802657 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'LFT', QuotePermID = 236807481103.0, InstrPermID = 232936773209.0, OrgPermID = 5082159139.0, PriValQuotePermID = 236807481103.0, PriInstrPermID = 21901959188.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'ASX', QuoteClass = 'CHESS', InstrClass = 'CHESS', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951901.0, PermOrgIPODate = '2022-06-27', PermSecMapStartDate = '2026-05-22', startDate = '2026-05-22' WHERE SecCode = 6809155 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6813826 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '8559', QuotePermID = 236807310308.0, InstrPermID = 232936287990.0, OrgPermID = 4295872037.0, PriValQuotePermID = 236807310308.0, PriInstrPermID = 8590924293.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'BMU', PriTRBCIndPermID = 4294951380.0, PermQuoteRetireDate = '2026-06-16', PermOrgIPODate = '2002-11-15', PermSecMapStartDate = '2026-05-20', startDate = '2026-05-20' WHERE SecCode = 6849705 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '2955', QuotePermID = 236807262961.0, InstrPermID = 232936081942.0, OrgPermID = 4295870812.0, PriValQuotePermID = 236807262961.0, PriInstrPermID = 8590937746.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951366.0, PermQuoteRetireDate = '2026-06-15', PermOrgIPODate = '2001-05-03', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 6849708 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'ACLNE', QuotePermID = 236807271900.0, InstrPermID = 232935981625.0, OrgPermID = 5083371192.0, PriValQuotePermID = 236807271900.0, PriInstrPermID = 21921863673.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SWX', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951856.0, PermOrgIPODate = '2022-10-03', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 6862194 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '7205', QuotePermID = 236807272360.0, InstrPermID = 232936115219.0, OrgPermID = 5087532550.0, PriValQuotePermID = 236807272360.0, PriInstrPermID = 232936115219.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAU', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'SAU', IncCntry = 'SAU', PriTRBCIndPermID = 4294951782.0, PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 6865118 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236807262139.0, PermInstrStatus = 'AC' WHERE SecCode = 6870704 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'AAN', QuotePermID = 236807254803.0, InstrPermID = 232935763270.0, OrgPermID = 5085663168.0, PriValQuotePermID = 236807254803.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HSX', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'VNM', IncCntry = 'VNM', PriTRBCIndPermID = 4294951445.0, PermOrgIPODate = '2026-05-22', PermSecMapStartDate = '2026-05-18', startDate = '2026-05-18' WHERE SecCode = 6870730 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'OCTV SDB', QuotePermID = 236807275393.0, InstrPermID = 232928579463.0, OrgPermID = 5092319824.0, PriValQuotePermID = 236807275393.0, PriInstrPermID = 232924000396.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'STO', QuoteClass = 'SWEDDR', InstrClass = 'SWEDDR', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'IRL', PermOrgIPODate = '2026-05-21', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 6873666 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TEAMTECH', QuotePermID = 236807474168.0, InstrPermID = 232935925399.0, OrgPermID = 5087005867.0, PriValQuotePermID = 236807474168.0, PriInstrPermID = 232935925399.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSI', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'IND', IncCntry = 'IND', PriTRBCIndPermID = 4294951812.0, PermOrgIPODate = '2026-05-26', PermSecMapStartDate = '2026-05-22', startDate = '2026-05-22' WHERE SecCode = 6880023 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '2723', QuotePermID = 236807278640.0, InstrPermID = 232935940183.0, OrgPermID = 5001171732.0, PriValQuotePermID = 236807278640.0, PriInstrPermID = 232935940183.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CHN', IncCntry = 'CHN', PriTRBCIndPermID = 4294951568.0, PermOrgIPODate = '2026-05-27', PermSecMapStartDate = '2026-05-20', startDate = '2026-05-20' WHERE SecCode = 6880027 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '901', QuotePermID = 236807278639.0, InstrPermID = 232935941499.0, OrgPermID = 5043460776.0, PriValQuotePermID = 236807278639.0, PriInstrPermID = 232935941499.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CHN', IncCntry = 'CHN', PriTRBCIndPermID = 4294951246.0, PermOrgIPODate = '2026-05-27', PermSecMapStartDate = '2026-05-21', startDate = '2026-05-21' WHERE SecCode = 6880028 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236807278641.0, PermInstrStatus = 'AC' WHERE SecCode = 6880029 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '7898', QuotePermID = 236807260204.0, InstrPermID = 232936017384.0, OrgPermID = 5086982527.0, PriValQuotePermID = 236807260204.0, PriInstrPermID = 232936017384.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TWO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'TWN', IncCntry = 'TWN', PriTRBCIndPermID = 4294951261.0, PermOrgIPODate = '2026-05-27', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 6880030 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '7921', QuotePermID = 236807260203.0, InstrPermID = 232936017475.0, OrgPermID = 5083450843.0, PriValQuotePermID = 236807260203.0, PriInstrPermID = 232936017475.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TWO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'TWN', IncCntry = 'TWN', PriTRBCIndPermID = 4294951971.0, PermOrgIPODate = '2026-05-27', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 6880031 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '2958', QuotePermID = 236807361308.0, InstrPermID = 232936476111.0, OrgPermID = 4295871816.0, PriValQuotePermID = 236807361308.0, PriInstrPermID = 8590939756.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951738.0, PermQuoteRetireDate = '2026-07-03', PermOrgIPODate = '1998-10-14', PermSecMapStartDate = '2026-05-21', startDate = '2026-05-21' WHERE SecCode = 6880047 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '2959', QuotePermID = 236807361316.0, InstrPermID = 232936476175.0, OrgPermID = 4295871014.0, PriValQuotePermID = 236807361316.0, PriInstrPermID = 8590931697.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'BMU', PriTRBCIndPermID = 4294951662.0, PermQuoteRetireDate = '2026-07-03', PermOrgIPODate = '1994-02-02', PermSecMapStartDate = '2026-05-21', startDate = '2026-05-21' WHERE SecCode = 6880048 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'AZUL97', QuotePermID = 236807620892.0, InstrPermID = 232932491110.0, OrgPermID = 5040244203.0, PriValQuotePermID = 236807620892.0, PriInstrPermID = 232913707193.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'BRA', IncCntry = 'BRA', PriTRBCIndPermID = 4294951735.0, PermOrgIPODate = '2017-04-11', PermSecMapStartDate = '2026-05-27' WHERE SecCode = 6880265 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'AZUL98', QuotePermID = 236807620890.0, InstrPermID = 232932491068.0, OrgPermID = 5040244203.0, PriValQuotePermID = 236807620890.0, PriInstrPermID = 232913707193.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'BRA', IncCntry = 'BRA', PriTRBCIndPermID = 4294951735.0, PermOrgIPODate = '2017-04-11', PermSecMapStartDate = '2026-05-27' WHERE SecCode = 6880266 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'AZUL99', QuotePermID = 236807620893.0, InstrPermID = 232935688333.0, OrgPermID = 5040244203.0, PriValQuotePermID = 236807620893.0, PriInstrPermID = 232913707193.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'BRA', IncCntry = 'BRA', PriTRBCIndPermID = 4294951735.0, PermOrgIPODate = '2017-04-11', PermSecMapStartDate = '2026-05-27' WHERE SecCode = 6880267 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236807361207.0, IsPrimaryQuote = 1.0, PermInstrStatus = 'AC' WHERE SecCode = 6885937 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '7735', QuotePermID = 236807580117.0, InstrPermID = 232936895667.0, OrgPermID = 6000140567.0, PriValQuotePermID = 236807580117.0, PriInstrPermID = 232936895667.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TWO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'TWN', IncCntry = 'TWN', PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = '2026-05-29', PermSecMapStartDate = '2026-05-25', startDate = '2026-05-25' WHERE SecCode = 6885938 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'SNM SDB', QuotePermID = 236807362028.0, InstrPermID = 232935699084.0, OrgPermID = 4295861501.0, PriValQuotePermID = 236807362028.0, PriInstrPermID = 8590928593.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'STO', QuoteClass = 'SWEDDR', InstrClass = 'SWEDDR', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951997.0, PermOrgIPODate = '1993-02-10', PermSecMapStartDate = '2026-05-21', startDate = '2026-05-21' WHERE SecCode = 6885945 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '7873', QuotePermID = 236807580116.0, InstrPermID = 232936444103.0, OrgPermID = 5051605882.0, PriValQuotePermID = 236807580116.0, PriInstrPermID = 232936444103.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TWO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'TWN', IncCntry = 'TWN', PriTRBCIndPermID = 4294951261.0, PermOrgIPODate = '2026-05-29', PermSecMapStartDate = '2026-05-25', startDate = '2026-05-25' WHERE SecCode = 6885947 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BXGPXX', PermSecMapEndDate = '2026-05-30', endDate = '2026-05-30' WHERE SecCode = 11131010 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11189393 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11192011 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11196231 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'JPN' WHERE SecCode = 11206889 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236807727984.0, PriTrdQuotePermID = 236807727984.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-05-29', startDate = '2020-07-10' WHERE SecCode = 11209704 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11218062 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 11221669 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11226283 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'IE000CNLGHH1', RkdSEDOL = 'BXCGDR', RkdCUSIP = 'G8267K21', DsPrimQtSedol = 'BXCGDR4' WHERE SecCode = 11235178 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US1717562086', RkdSEDOL = 'BXCGG3', RkdCUSIP = '17175620', DsPrimQtSedol = 'BXCGG31', PermSecMapEndDate = '2026-05-30', endDate = '2026-05-30' WHERE SecCode = 11236863 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 1004365414.0 WHERE SecCode = 11240940 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG2030P1155', RkdSEDOL = 'BXCGDJ', RkdCUSIP = 'G2030P11', DsPrimQtSedol = 'BXCGDJ6', PermSecMapEndDate = '2026-05-30', endDate = '2026-05-30' WHERE SecCode = 11264398 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG7396L1370', RkdSEDOL = 'BXCGF8', RkdCUSIP = 'G7396L13', DsPrimQtSedol = 'BXCGF89', PermSecMapEndDate = '2026-05-30', endDate = '2026-05-30' WHERE SecCode = 11265202 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SPACu.TO^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-01', endDate = '2026-06-01' WHERE SecCode = 11269373 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US1048133086', RkdSEDOL = 'BXCGG8', RkdCUSIP = '10481330', DsPrimQtSedol = 'BXCGG86', PermSecMapEndDate = '2026-05-30', endDate = '2026-05-30' WHERE SecCode = 11275764 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11291637 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11294225 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 25727292579.0, InstrPermID = 25727292581.0, OrgPermID = 5079700268.0, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = 25727292581.0, PermInstrStatus = 'NA', IncCntry = 'USA', PermOrgIPODate = NULL, PermSecMapStartDate = '2026-03-27', startDate = '2026-03-27' WHERE SecCode = 11294226 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11295149 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295880 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'AFC.P', QuotePermID = 236807259364.0, InstrPermID = 232931976140.0, OrgPermID = 6000136804.0, PriValQuotePermID = 236807259364.0, PriInstrPermID = 232931976140.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'CVE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951348.0, DsExchQtStartDate = '2026-05-29', PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 11296182 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'AMSS', QuotePermID = 236807259533.0, InstrPermID = 232907575225.0, OrgPermID = 5080146012.0, PriTrdQuotePermID = 236807259533.0, PriValQuotePermID = 25727021846.0, PriInstrPermID = 232907575225.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951578.0, PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-19', startDate = '2026-05-19' WHERE SecCode = 11296183 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'QADR', QuotePermID = 236807278562.0, InstrPermID = 232902764891.0, OrgPermID = 5096766999.0, PriTrdQuotePermID = 236807278562.0, PriValQuotePermID = 25727021644.0, PriInstrPermID = 232902764891.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-03-27', PermSecMapStartDate = '2026-05-20', startDate = '2026-03-27' WHERE SecCode = 11296240 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RACC', QuotePermID = 236807278642.0, InstrPermID = 232934346868.0, OrgPermID = 6000090093.0, PriTrdQuotePermID = 236807278642.0, PriValQuotePermID = 25727021496.0, PriInstrPermID = 232934346868.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-20' WHERE SecCode = 11296241 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RREV', COATypeCode = 'IND', QuotePermID = 236807259553.0, InstrPermID = 232925935066.0, OrgPermID = 6000089157.0, PriTrdQuotePermID = 236807259553.0, PriValQuotePermID = 25727021805.0, PriInstrPermID = 232925935066.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-04-30', PermSecMapStartDate = '2026-05-19', startDate = '2026-04-30' WHERE SecCode = 11296242 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'CNXU', QuotePermID = 236807359758.0, InstrPermID = 232885350652.0, OrgPermID = 5094169374.0, PriTrdQuotePermID = 236807359758.0, PriValQuotePermID = 25727021358.0, PriInstrPermID = 232885350652.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951265.0, PermOrgIPODate = '2026-05-21', PermSecMapStartDate = '2026-05-21' WHERE SecCode = 11296272 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'FXACU', QuotePermID = 236807278428.0, InstrPermID = 232930746924.0, OrgPermID = 6000098602.0, PriTrdQuotePermID = 236807278428.0, PriValQuotePermID = 25727021693.0, PriInstrPermID = 232930746924.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-05-22', PermSecMapStartDate = '2026-05-20', startDate = '2026-05-20' WHERE SecCode = 11296311 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'DGAC.U', QuotePermID = 236807483040.0, InstrPermID = 232927755670.0, OrgPermID = 6000102181.0, PriTrdQuotePermID = 236807483040.0, PriValQuotePermID = 25727021061.0, PriInstrPermID = 232927755670.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-27', PermSecMapStartDate = '2026-05-23', startDate = '2026-05-23' WHERE SecCode = 11296371 AND Type_ = 1; UPDATE data_universe SET PriTrdQuotePermID = 236797173556.0, PriValQuotePermID = 25727055916.0 WHERE SecCode = 11296373 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SAGU', QuotePermID = 236807277694.0, InstrPermID = 232910237341.0, OrgPermID = 5096845468.0, PriTrdQuotePermID = 236807277694.0, PriValQuotePermID = 25727021755.0, PriInstrPermID = 232910237341.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-07', PermSecMapStartDate = '2026-05-20', startDate = '2026-05-07' WHERE SecCode = 11296376 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PWRL', QuotePermID = 236807620650.0, InstrPermID = 232902937445.0, OrgPermID = 5091618234.0, PriTrdQuotePermID = 236807620650.0, PriValQuotePermID = 25727020727.0, PriInstrPermID = 232902937445.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PermSecMapStartDate = '2026-05-27' WHERE SecCode = 11296529 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ACGC', QuotePermID = 236807620665.0, InstrPermID = 232926164305.0, OrgPermID = 6000052223.0, PriTrdQuotePermID = 236807620665.0, PriValQuotePermID = 25727020678.0, PriInstrPermID = 232926164305.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-04-07', PermSecMapStartDate = '2026-05-27', startDate = '2026-04-07' WHERE SecCode = 11296578 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'AACP', QuotePermID = 236807620485.0, InstrPermID = 232926339285.0, OrgPermID = 6000052402.0, PriTrdQuotePermID = 236807620485.0, PriValQuotePermID = 25727020789.0, PriInstrPermID = 232926339285.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-04-07', PermSecMapStartDate = '2026-05-27', startDate = '2026-04-07' WHERE SecCode = 11296579 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ARCL', QuotePermID = 236807727663.0, InstrPermID = 232891591990.0, OrgPermID = 5095925178.0, PriTrdQuotePermID = 236807727663.0, PriValQuotePermID = 25727020343.0, PriInstrPermID = 232891591990.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'VGB', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = '2026-04-30', PermSecMapStartDate = '2026-05-29', startDate = '2026-04-30' WHERE SecCode = 11296648 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236803112281.0, PriTrdQuotePermID = 236803112281.0, ExchCode = 'NMS' WHERE SecCode = 11296650 AND Type_ = 1;