UPDATE data_universe SET QuotePermID = 21715145964.0, ExchCode = 'AQX' WHERE SecCode = 1807 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US0906557055', RkdSEDOL = 'BRF0S4', RkdCUSIP = '09065570' WHERE SecCode = 15660 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 26615 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 38223 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55842440800.0, PermQuoteRetireDate = '2012-05-04', endDate = '2012-05-04' WHERE SecCode = 45820 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2026-07-28' WHERE SecCode = 48143 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'MS PRA' WHERE SecCode = 48206 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRA' WHERE SecCode = 53924 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRB' WHERE SecCode = 53925 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRC' WHERE SecCode = 53926 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRD' WHERE SecCode = 53927 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRE' WHERE SecCode = 53928 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRG' WHERE SecCode = 53934 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRH' WHERE SecCode = 53943 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PCG PRI' WHERE SecCode = 53951 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PBR A' WHERE SecCode = 55248 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68018 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'SPG PRJ' WHERE SecCode = 69859 AND Type_ = 1; 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 OrgPermID = 4296494813.0, PriInstrPermID = NULL, PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 70590 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 4296494813.0, PriInstrPermID = NULL, PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 70591 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 4296494813.0, PriInstrPermID = NULL, PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 70592 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 4296494813.0, PriInstrPermID = NULL, PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 70595 AND Type_ = 1; 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 DsCtryQtStatus = 'S' WHERE SecCode = 73754 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 PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 76171 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'USB PRH' WHERE SecCode = 77348 AND Type_ = 1; 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 = 79086 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU000000FBR4', RkdTicker = 'FBR', RkdSEDOL = 'BZ0291', RkdCUSIP = 'Q3R26D21', RkdRIC = 'FBR.AX', RkdDisplayRIC = 'FBR.AX' WHERE SecCode = 79182 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'KYG2117P1458', RkdSEDOL = 'BPY0C4', RkdCUSIP = 'G2117P14' WHERE SecCode = 79390 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'WSO B' WHERE SecCode = 80971 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'MEDICAPQ', RkdRIC = 'MEDI.NS', RkdDisplayRIC = 'MEDI.NS', RkdExchCode = 'NSE' WHERE SecCode = 82347 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 RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 85852 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86339 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86528 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 DsCtryQtStatus = 'A' WHERE SecCode = 90657 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91257 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'PANCHMAHQ', RkdRIC = 'PANS.NS', RkdDisplayRIC = 'PANS.NS', RkdExchCode = 'NSE' WHERE SecCode = 92158 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92313 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'PERMAGN', RkdRIC = 'PRMG.NS', RkdDisplayRIC = 'PRMG.NS', RkdExchCode = 'NSE' WHERE SecCode = 92344 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94403 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'BHIB.KL^I26', RkdIssueStatus = 0.0 WHERE SecCode = 94982 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueCode = 61633.0 WHERE SecCode = 97401 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 RkdSEDOL = NULL WHERE SecCode = 113738 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 RkdSEDOL = NULL WHERE SecCode = 115728 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 = 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 = 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 PriValQuotePermID = NULL, IsPrimaryQuote = 0.0 WHERE SecCode = 134894 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 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 = 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 = 139411 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 142079 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 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 = 145938 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 170011 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 176980 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55836333820.0, ExchCode = 'BER' WHERE SecCode = 178289 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = NULL, IsPrimaryQuote = 0.0 WHERE SecCode = 180518 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 184802 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 = 255960 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'RC PRC' WHERE SecCode = 262538 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 299025 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA7059171024', RkdTicker = 'PEL', RkdSEDOL = 'C08TQK', RkdCUSIP = '70591710', RkdRIC = 'PEL.CD', RkdDisplayRIC = 'PEL.CD', RkdExchCode = 'CNQ' WHERE SecCode = 336770 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WFC PRL' WHERE SecCode = 348300 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 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 = 519104 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951905.0 WHERE SecCode = 582001 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 588859 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 624469 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 674803 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 = 999958 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'SHOW3.SA^I26', RkdIssueStatus = 0.0 WHERE SecCode = 1110900 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 RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 1493830 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueCode = 100282.0 WHERE SecCode = 1540033 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 PermIDTicker = 'ABGPe', QuotePermID = 21513756453.0, PriValQuotePermID = NULL, IsPrimaryQuote = 0.0, ExchCode = 'HFT', PermQuoteRetireDate = '2014-05-02', endDate = '2014-05-02' WHERE SecCode = 1699140 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 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 = 2529641 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2580912 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 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 PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2764599 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2782958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2800426 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 = 2923366 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 = 3212151 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212191 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 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 RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3441154 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3488287 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'PADL', RkdRIC = 'PADL.ASE', RkdDisplayRIC = 'PADL.ASE' WHERE SecCode = 3566802 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3587036 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'DEEP', RkdRIC = 'DEPP.NS', RkdDisplayRIC = 'DEPP.NS', RkdExchCode = 'NSE' WHERE SecCode = 3596594 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3735955 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 PrimaryIssueCode = 120441.0 WHERE SecCode = 4142522 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 4288890 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4300561 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = '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 PrimaryIssueCode = 107926.0 WHERE SecCode = 4630511 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21854742316.0, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4761537 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueCode = 129879.0 WHERE SecCode = 4766077 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4777363 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4903829 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5035049 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5083931 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5450886 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 5565405 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5566779 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5623997 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5693824 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5738355 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6394298 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6422983 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7025896 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7086798 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TAP A' WHERE SecCode = 10924512 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'USB PRA' WHERE SecCode = 10963681 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 10971989 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232947646661.0 WHERE SecCode = 10989428 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'MITT PRA' WHERE SecCode = 11034060 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SLG PRI' WHERE SecCode = 11034526 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'MITT PRB' WHERE SecCode = 11035949 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'VNO PRL' WHERE SecCode = 11061167 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SCE PRG' WHERE SecCode = 11062458 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PEB PRE' WHERE SecCode = 11068776 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SNUS PRI' WHERE SecCode = 11070075 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRE' WHERE SecCode = 11108107 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRF' WHERE SecCode = 11112205 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 4296494813.0, PriInstrPermID = NULL, IsPrimaryInstr = 0.0, PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 11130430 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PW PRA' WHERE SecCode = 11131600 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SB PRC' WHERE SecCode = 11134779 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SB PRD' WHERE SecCode = 11136775 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRI' WHERE SecCode = 11139885 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'DLNG PRA' WHERE SecCode = 11150414 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SCHW PRD' WHERE SecCode = 11156976 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'STT PRG' WHERE SecCode = 11158070 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PEB PRF' WHERE SecCode = 11159166 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SEAL PRA' WHERE SecCode = 11163153 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRK' WHERE SecCode = 11166966 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PMT PRA' WHERE SecCode = 11169084 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TWO PRA' WHERE SecCode = 11169287 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TEN PRE' WHERE SecCode = 11170326 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WFC PRY' WHERE SecCode = 11171533 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRF' WHERE SecCode = 11172866 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'NGL PRB', PermIDTicker = 'NGL PRB' WHERE SecCode = 11173429 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PMT PRB' WHERE SecCode = 11174145 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TWO PRB' WHERE SecCode = 11174853 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NLY PRF' WHERE SecCode = 11175197 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRG' WHERE SecCode = 11175599 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'IVR PRC' WHERE SecCode = 11175855 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RLJ PRA' WHERE SecCode = 11176400 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'XRN PRA' WHERE SecCode = 11176836 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'FRT PRC' WHERE SecCode = 11177185 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SEAL PRB' WHERE SecCode = 11178082 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'REXR PRB' WHERE SecCode = 11178868 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TWO PRC' WHERE SecCode = 11179294 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'VNO PRM' WHERE SecCode = 11179844 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SNUS PRH' WHERE SecCode = 11179901 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SRG PRA' WHERE SecCode = 11180027 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NLY PRG' WHERE SecCode = 11181004 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'UMH PRD' WHERE SecCode = 11181213 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 25727227247.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11185229 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OAK PRA' WHERE SecCode = 11185343 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RNR PRF' WHERE SecCode = 11186408 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TEN PRF' WHERE SecCode = 11186705 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OAK PRB' WHERE SecCode = 11188744 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'USB PRP' WHERE SecCode = 11188843 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SF PRB' WHERE SecCode = 11194254 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRH' WHERE SecCode = 11194414 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRTN PRA' WHERE SecCode = 11194826 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'NGL PRC', PermIDTicker = 'NGL PRC' WHERE SecCode = 11195317 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RF PRC' WHERE SecCode = 11196145 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'VOYA PRB' WHERE SecCode = 11197986 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRTN PRB' WHERE SecCode = 11198082 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NLY PRI' WHERE SecCode = 11198119 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RITM PRA' WHERE SecCode = 11198266 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RITM PRB' WHERE SecCode = 11199502 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRI' WHERE SecCode = 11200155 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'MITT PRC' WHERE SecCode = 11200204 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'REXR PRC' WHERE SecCode = 11200236 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRTN PRC' WHERE SecCode = 11201743 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRJ' WHERE SecCode = 11201898 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SYF PRA' WHERE SecCode = 11201964 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRL' WHERE SecCode = 11202312 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TFC PRI' WHERE SecCode = 11202918 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRK' WHERE SecCode = 11203150 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRTN PRD' WHERE SecCode = 11204334 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RITM PRC' WHERE SecCode = 11205241 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'T PRC' WHERE SecCode = 11205247 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SF PRC' WHERE SecCode = 11207701 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TFC PRO' WHERE SecCode = 11207877 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PNFP PRC' WHERE SecCode = 11208071 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRL' WHERE SecCode = 11208520 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NREF PRA' WHERE SecCode = 11210204 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TFC PRR' WHERE SecCode = 11210557 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRM' WHERE SecCode = 11210937 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRN' WHERE SecCode = 11213097 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OPP PRA' WHERE SecCode = 11213894 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'USB PRQ' WHERE SecCode = 11213986 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WFC PRA' WHERE SecCode = 11214021 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRO' WHERE SecCode = 11214641 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'VNO PRN' WHERE SecCode = 11215026 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NXDT PRA' WHERE SecCode = 11217181 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WFC PRC' WHERE SecCode = 11217996 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'USB PRR' WHERE SecCode = 11218203 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TDS PRU' WHERE SecCode = 11219703 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SCHW PRJ' WHERE SecCode = 11221478 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RF PRE' WHERE SecCode = 11223143 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PEB PRG' WHERE SecCode = 11223872 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US98957E1064', RkdSEDOL = 'BV8CX0', RkdCUSIP = '98957E10', OrgPermID = 6000269150.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = NULL WHERE SecCode = 11223968 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SHO PRH' WHERE SecCode = 11224030 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RC PRE' WHERE SecCode = 11225223 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRTX PRC' WHERE SecCode = 11225329 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SACH PRA' WHERE SecCode = 11226207 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RNR PRG' WHERE SecCode = 11226879 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SHO PRI' WHERE SecCode = 11227201 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SF PRD' WHERE SecCode = 11227453 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WFC PRD' WHERE SecCode = 11227625 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PEB PRH' WHERE SecCode = 11227660 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TDS PRV' WHERE SecCode = 11228523 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRQ' WHERE SecCode = 11228572 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRTN PRE' WHERE SecCode = 11228683 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PMT PRC' WHERE SecCode = 11228809 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RITM PRD' WHERE SecCode = 11229948 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'VNO PRO' WHERE SecCode = 11229990 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WAL PRA' WHERE SecCode = 11230114 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRO' WHERE SecCode = 11232405 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRR' WHERE SecCode = 11233801 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OPP PRB' WHERE SecCode = 11234145 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PSA PRS' WHERE SecCode = 11236692 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'USB PRS' WHERE SecCode = 11237944 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'RIV PRA' WHERE SecCode = 11240910 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'GPUS PRD' WHERE SecCode = 11242104 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MS PRP' WHERE SecCode = 11244191 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'UHAL B' WHERE SecCode = 11247265 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US98423X4079', RkdCUSIP = '98423X40', DsPrimQtSedol = 'BRF0S21' WHERE SecCode = 11250292 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2023-08-10' WHERE SecCode = 11256250 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'TONT U', PermIDTicker = 'TONT U' WHERE SecCode = 11266669 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11279159 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MZYX U' WHERE SecCode = 11292491 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OCAC U' WHERE SecCode = 11297292 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232925554044.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11299372 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236813849964.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11301300 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236813846180.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11301363 AND Type_ = 1;