UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68474 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 = 70358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71695 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74186 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75375 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76652 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CTLP.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-11', PermQuoteRetireDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 77383 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951820.0 WHERE SecCode = 78038 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 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 = 78933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81037 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 81636 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81754 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 = 82656 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4530.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 83170 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83668 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 85441 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85941 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET PriTrdQuotePermID = 55835372179.0, PriValQuotePermID = 55839301037.0 WHERE SecCode = 86891 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 87258 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 89166 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89573 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-08', endDate = '2026-05-08' WHERE SecCode = 90764 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 91288 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'UE.CD^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-11', PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 91604 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92479 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93102 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951244.0 WHERE SecCode = 95289 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365459.0 WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 97751 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 105528 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 111512 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951828.0 WHERE SecCode = 114294 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114727 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 = 116213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120580 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 = 124075 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 = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 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 = 130540 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 = 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 = 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 = 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 = 142870 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HCD' WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 146379 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 174727 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 DsCtryQtStatus = 'A' WHERE SecCode = 257809 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 320068 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 323167 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 323829 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'LKFT', PermIDTicker = 'LKFT', RkdRIC = 'LKFT.O', RkdDisplayRIC = 'LKFT.OQ' WHERE SecCode = 331528 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 340882 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 347790 AND Type_ = 1;
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 QuotePermID = 236798948725.0, ExchCode = 'DUS' WHERE SecCode = 396306 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 QuotePermID = 21530872359.0, ExchCode = 'BTE' WHERE SecCode = 437391 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 446599 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 536847 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BURl', QuotePermID = 21538768084.0, IsPrimaryQuote = 0.0, ExchCode = 'BCO' WHERE SecCode = 551365 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 703341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1043297 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1254621 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475892461.0, ExchCode = 'GER', PermQuoteRetireDate = '2012-04-10', endDate = '2012-04-10' WHERE SecCode = 1265152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GRADIENTE', QuotePermID = 236806710929.0, ExchCode = 'NSI' WHERE SecCode = 1611823 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 DsCtryQtStatus = 'A' WHERE SecCode = 1670286 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 = 1997851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2193116 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 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 = 2412427 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 2433009 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TAI', ExchCode = 'TAI' WHERE SecCode = 2439906 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 = 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 DsCtryQtStatus = 'A' WHERE SecCode = 2701612 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2711205 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2725363 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2763364 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2829009 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 = 'S' WHERE SecCode = 2879979 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 2907002 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PriTRBCIndPermID = 4294951546.0 WHERE SecCode = 2911861 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VAF', PermQuoteStatus = 'AC', ExchCode = 'UPC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-08', PermSecMapEndDate = NULL, startDate = '2015-06-22', endDate = NULL WHERE SecCode = 2912792 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 DsCtryQtStatus = 'A' WHERE SecCode = 2963471 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 = 3072605 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GNRO.PA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-11', PermQuoteRetireDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 3125027 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3200982 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 3208816 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 3247786 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3247789 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 3296840 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3409644 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3429657 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3433491 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3436908 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 3543178 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'QON.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 3736002 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3791544 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DADC' WHERE SecCode = 3845903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3945211 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4092025 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4288890 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791494702.0, PermQuoteStatus = 'AC', ExchCode = 'JAX', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 4388110 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 4442678 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 4607553 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21821642083.0, ExchCode = 'BTE', PermQuoteRetireDate = '2025-08-05' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BQKY081', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 4638781 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 4646583 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4650985 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4712596 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 25727217499.0 WHERE SecCode = 4802265 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951541.0 WHERE SecCode = 4816837 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4818274 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 4969534 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 5013431 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5078439 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5127374 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5128568 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 5128570 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DOTL' WHERE SecCode = 5155320 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5288726 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 5430794 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 5453396 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5544127 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5574872 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-08', endDate = '2026-05-08' WHERE SecCode = 5635825 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 5738387 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5848777 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 5944557 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5978189 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6100251 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 6305192 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236806766676.0, ExchCode = 'GER' WHERE SecCode = 6318935 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 6324026 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-11', PermQuoteRetireDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 6622165 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6622347 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0, startDate = '2017-04-11' WHERE SecCode = 6626331 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 6654548 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-23', PermSecMapEndDate = '2026-05-08' WHERE SecCode = 6756271 AND Type_ = 10;
UPDATE data_universe SET InstrClass = 'FULLPAID' WHERE SecCode = 6789483 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6808759 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6820137 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AMRZE', QuotePermID = 236806597785.0, InstrPermID = 232933253626.0, OrgPermID = 5090785715.0, PriValQuotePermID = 236806597785.0, PriInstrPermID = 232881858824.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SWX', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CHE', PriTRBCIndPermID = 4294951893.0, PermOrgIPODate = '2025-06-23', PermSecMapStartDate = '2026-05-04', startDate = '2026-05-04' WHERE SecCode = 6829205 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '8557', QuotePermID = 236806449090.0, InstrPermID = 232933009783.0, OrgPermID = 5051396564.0, PriValQuotePermID = 236806449090.0, PriInstrPermID = 21591802085.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951590.0, PermQuoteRetireDate = '2026-06-11', PermOrgIPODate = '2017-01-12', PermSecMapStartDate = '2026-04-30', startDate = '2026-04-30' WHERE SecCode = 6829241 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-05-08' WHERE SecCode = 6836129 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-08', endDate = '2026-05-08' WHERE SecCode = 10934601 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGNT' WHERE SecCode = 10985859 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA92556L5045', RkdSEDOL = 'BT9QVK', RkdCUSIP = '92556L50', DsPrimQtSedol = 'BT9QVK8' WHERE SecCode = 11024402 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0, PriValQuotePermID = 236781124630.0 WHERE SecCode = 11079898 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11163321 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US4831193010', RkdSEDOL = 'BV3N0S', RkdCUSIP = '48311930', DsPrimQtSedol = 'BV3N0S0', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11174616 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000112927.0, PriInstrPermID = 21625648120.0, IsPrimaryInstr = 1.0, PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11182728 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 11185713 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-08', endDate = '2026-05-08' WHERE SecCode = 11186317 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 11191102 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = NULL, PriValQuotePermID = 25727351915.0 WHERE SecCode = 11206349 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000113076.0, PriInstrPermID = 25727262629.0, IsPrimaryInstr = 1.0, PermOrgIPODate = NULL WHERE SecCode = 11224790 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'EWCZ.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-11', PermQuoteRetireDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 11228341 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA01176C1095' WHERE SecCode = 11234105 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'IE0008D7EWV5', RkdSEDOL = 'BV3N1T', RkdCUSIP = 'G8267K19', DsPrimQtSedol = 'BV3N1T8' WHERE SecCode = 11235178 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US7389203057', RkdSEDOL = 'BV3N1P', RkdCUSIP = '73892030', DsPrimQtSedol = 'BV3N1P4', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11240840 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SPODD', PermSecMapEndDate = '2026-05-08', endDate = '2026-05-08' WHERE SecCode = 11242346 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US98423X3089', RkdSEDOL = 'BV3N1K', RkdCUSIP = '98423X30', DsPrimQtSedol = 'BV3N1K9', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11250292 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000051984.0, PriInstrPermID = 25727171616.0, IncCntry = 'VGB', PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11265135 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11268849 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US37518P1012', RkdSEDOL = 'BX73CC', RkdCUSIP = '37518P10', DsPrimQtSedol = 'BX73CC8', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-11', PermQuoteRetireDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 11271538 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US09940T1007', RkdTicker = NULL, PermIDTicker = 'BRUN', RkdSEDOL = 'BX734Y', RkdCUSIP = '09940T10', DsPrimQtSedol = 'BX734Y4', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11273589 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 11281412 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2657S1113', RkdSEDOL = 'BV3N1V', RkdCUSIP = 'G2657S11', DsPrimQtSedol = 'BV3N1V0', PermSecMapEndDate = '2026-05-09', endDate = '2026-05-09' WHERE SecCode = 11281952 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ENHA', ExchCode = 'NYS' WHERE SecCode = 11284217 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11293243 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232896022139.0 WHERE SecCode = 11293509 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11294535 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SPTX', QuotePermID = 236806469997.0, InstrPermID = 232931927377.0, OrgPermID = 5090665467.0, PriTrdQuotePermID = 236806469997.0, PriValQuotePermID = 25727024490.0, PriInstrPermID = 232931927377.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951265.0, PermOrgIPODate = '2026-05-01', PermSecMapStartDate = '2026-05-01' WHERE SecCode = 11295203 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PONO', QuotePermID = 236806601823.0, InstrPermID = 232923523003.0, OrgPermID = 6000016288.0, PriTrdQuotePermID = 236806601823.0, PriValQuotePermID = 25727024252.0, PriInstrPermID = 232923523003.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CYM', IncCntry = 'CYM', PermOrgIPODate = '2026-03-13', PermSecMapStartDate = '2026-05-05', startDate = '2026-03-13' WHERE SecCode = 11295354 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SMCD.P', QuotePermID = 236806601907.0, InstrPermID = 232929764183.0, OrgPermID = 6000088065.0, PriValQuotePermID = 236806601907.0, PriInstrPermID = 232929764183.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-08', PermOrgIPODate = '2026-05-06', PermSecMapStartDate = '2026-05-05', startDate = '2026-05-05' WHERE SecCode = 11295411 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295427 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236806601937.0, PriValQuotePermID = 25727024155.0, PermInstrStatus = 'AC' WHERE SecCode = 11295445 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 11295462 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MOBI', QuotePermID = 236806601880.0, InstrPermID = 232933686206.0, OrgPermID = 5000668025.0, PriTrdQuotePermID = 236806601880.0, PriValQuotePermID = 25727024222.0, PriInstrPermID = 232933686206.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951290.0, PermOrgIPODate = '2026-05-08', PermSecMapStartDate = '2026-05-07', startDate = '2026-05-07' WHERE SecCode = 11295602 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-05-08' WHERE SecCode = 11295603 AND Type_ = 1;
