UPDATE data_universe SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 856 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21715145964.0, ExchCode = 'AQX' WHERE SecCode = 1807 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 1949 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951170.0 WHERE SecCode = 2210 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 2385 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AED CL', QuotePermID = 34488745096.0, PermQuoteStatus = 'DC', ExchCode = 'ADC', PermQuoteRetireDate = '2019-06-17', PermSecMapEndDate = '2019-06-17' WHERE SecCode = 2407 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 2505 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 2533 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 2692 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2841 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3095 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 3352 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3552 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951541.0 WHERE SecCode = 3785 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 4119 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365525.0 WHERE SecCode = 4599 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951338.0 WHERE SecCode = 4924 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 5043 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 5321 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951338.0 WHERE SecCode = 5917 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 6139 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 7103 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 7169 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 7333 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 7399 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 34488348169.0, ExchCode = 'BTY' WHERE SecCode = 7562 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 8097 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 8186 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951785.0 WHERE SecCode = 8356 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 8488 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 8701 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951169.0 WHERE SecCode = 8819 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 9388 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 9395 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 9736 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 9771 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 9948 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 10187 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 10318 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 10389 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 10404 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 10619 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11226 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11507 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11525 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11942 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 11969 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 12080 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951382.0 WHERE SecCode = 13373 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951840.0 WHERE SecCode = 13451 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 13513 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 13613 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 13635 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 13658 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 14417 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 14631 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 14853 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 15046 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 47759677934.0, ExchCode = 'XNE' WHERE SecCode = 15747 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 16321 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 16551 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 16947 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 17058 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 17084 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 17333 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17410 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 17415 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 17530 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 17632 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 18229 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 18746 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 19035 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 19347 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 19493 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951222.0 WHERE SecCode = 19547 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 19999 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US2883981001', RkdTicker = 'ELET', RkdCUSIP = '28839810', RkdRIC = 'ELET.O^C01', RkdDisplayRIC = 'ELET.OB', RkdCode = 6915.0, RkdIssueID = 1.0, RkdIssueCode = 9155.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 23486 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2002-05-08' WHERE SecCode = 24017 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 24891 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 25125 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 25469 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 25504 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 25738 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 26447 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 26802 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 27010 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1988-01-04' WHERE SecCode = 27152 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 27318 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 27337 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 27774 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 27818 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 27903 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 27930 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 28117 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 28132 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 28143 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 28217 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 28280 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 28281 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 28297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1990-01-09' WHERE SecCode = 28313 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 28327 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 28568 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 28697 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 28699 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 28702 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 28703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 28704 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951288.0 WHERE SecCode = 28756 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 28758 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 29097 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 29606 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 29699 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 29842 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 29864 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 29886 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 30080 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 30310 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 30345 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 30432 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 30521 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 30528 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 30533 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 30601 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 30612 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 30788 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 31124 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 31430 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 31807 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 31821 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 32695 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 34488348108.0, ExchCode = 'LCY' WHERE SecCode = 32892 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 32893 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 32991 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 33435 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 33516 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 33767 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 33841 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 34071 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US4458913021', RkdTicker = 'HTDLY', RkdCUSIP = '44589130', RkdRIC = 'HTD.N^L00', RkdCode = 2411.0, RkdIssueID = 1.0, RkdIssueCode = 3981.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'EDR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', ShPerListing = 5.0 WHERE SecCode = 34267 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 34675 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 34968 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 35551 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BIB', QuotePermID = 21475512051.0, ExchCode = 'HAN', PermQuoteRetireDate = '2007-09-12' WHERE SecCode = 35717 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ISG CL', QuotePermID = 34482590628.0, PermQuoteStatus = 'DC', ExchCode = 'CIN', PermQuoteRetireDate = '2020-04-15', PermSecMapEndDate = '2020-04-15' WHERE SecCode = 36046 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 36088 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475422364.0, ExchCode = 'HAN', PermQuoteRetireDate = '2004-04-23', endDate = '2004-04-23' WHERE SecCode = 36125 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 36180 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 36671 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 36674 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 36676 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 36677 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 36938 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 37148 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 37355 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 37481 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 37621 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MLOTT' WHERE SecCode = 37718 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 37855 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 37871 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 34486755973.0, ExchCode = 'BOS' WHERE SecCode = 37977 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 38085 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 38094 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 38361 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 38417 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 38777 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 39320 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 39343 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951887.0 WHERE SecCode = 39363 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 39607 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 40228 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 40485 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 40570 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 40767 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 40917 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 41122 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 41535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 41609 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 41719 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 42240 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 42520 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951338.0 WHERE SecCode = 42568 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MNPZ', QuotePermID = 55856136113.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2015-08-14', PermSecMapStartDate = '2014-09-11', PermSecMapEndDate = '2015-08-15' WHERE SecCode = 42884 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 43140 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 43233 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 43263 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 43466 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 43497 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 43554 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 43847 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 43996 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 44306 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 44344 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 44428 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 44633 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 44705 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 44810 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 44907 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 45445 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RTRKSh', QuotePermID = 21475085789.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 45820 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 PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 46037 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 46258 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 46567 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951629.0 WHERE SecCode = 46571 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 46696 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 46722 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 46857 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475389822.0, ExchCode = 'FRA' WHERE SecCode = 47266 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 47550 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 47918 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 47919 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 48419 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 49539 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 49554 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 49965 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 50531 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 51261 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 51713 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 51866 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 51975 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 52051 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 52231 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 52268 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 52630 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21506505201.0, PermQuoteStatus = 'DC', ExchCode = 'RTS', PermQuoteRetireDate = '2021-02-13', PermSecMapStartDate = '2012-07-03', PermSecMapEndDate = '2020-01-16' WHERE SecCode = 53105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 53145 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 54293 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 54858 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 55189 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951533.0 WHERE SecCode = 55397 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951887.0 WHERE SecCode = 55695 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951222.0 WHERE SecCode = 55940 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 56050 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 56147 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 56303 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 56581 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 57009 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 58268 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 58662 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 59054 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951274.0 WHERE SecCode = 59149 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 60511 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 61218 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55838227211.0, InstrPermID = 8591042828.0, OrgPermID = 5000062056.0, PriValQuotePermID = 55838227211.0, PriInstrPermID = NULL, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'STO', DomCntry = 'SWE', IncCntry = 'SWE', PermQuoteRetireDate = '2005-03-05', PermOrgIPODate = NULL, PermSecMapStartDate = '2000-12-14', PermSecMapEndDate = '2005-03-10', startDate = '1999-10-11', endDate = '2005-02-28' WHERE SecCode = 61588 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 61617 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 61839 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 62746 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 64493 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 66579 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 67041 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 67564 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837433808.0, InstrPermID = 8590923017.0, PriValQuotePermID = 55837433808.0, PermSecMapStartDate = '1998-09-30' WHERE SecCode = 67697 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 67870 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 68020 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 68194 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68249 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68250 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68252 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68254 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 68254 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68257 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 68258 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68259 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68263 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68265 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68268 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68273 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HJG CL', QuotePermID = 34488747190.0, ExchCode = 'DEX', PermQuoteRetireDate = '2012-08-20', endDate = '2012-08-16' WHERE SecCode = 68290 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 68358 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 68503 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 68507 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 68730 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 68844 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 68907 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 68959 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 69014 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 69105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 69125 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 69440 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 69921 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70042 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 70190 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 70223 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 70329 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 70473 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 70484 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55835147370.0, InstrPermID = 15629626765.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', ExchCode = 'ASE', PermQuoteRetireDate = '2020-09-28', PermSecMapEndDate = '2020-09-28' WHERE SecCode = 70593 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 70627 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 70747 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 70793 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 71054 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 71160 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 71164 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 71502 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 71573 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 71890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 72046 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 72163 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951457.0 WHERE SecCode = 72513 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 72652 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 72771 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 72919 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 72920 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 72925 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 73174 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951831.0 WHERE SecCode = 73521 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951416.0 WHERE SecCode = 73590 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 73615 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73886 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 73907 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG7403L1384', RkdSEDOL = 'BX4ZP0', RkdCUSIP = 'G7403L13' WHERE SecCode = 73912 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 73930 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 74129 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 74250 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 74478 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 74764 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1994-06-13' WHERE SecCode = 74829 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1996-01-02' WHERE SecCode = 75145 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 75185 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 75271 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 75751 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 75821 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 75828 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 75831 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 76082 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 76437 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 76712 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 76742 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 76842 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 77236 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 77273 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 77345 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 77490 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4800.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 77865 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 78000 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 78088 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 78366 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 78421 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermSecMapStartDate = NULL WHERE SecCode = 78439 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 78544 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 78715 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 78749 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 78809 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 79008 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 79035 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 79107 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951480.0 WHERE SecCode = 79215 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermSecMapStartDate = NULL WHERE SecCode = 79554 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 79744 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 79747 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 79878 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 80118 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 80118 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 80156 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55837427093.0, InstrPermID = 8589949463.0, PriValQuotePermID = 55837427093.0, PermSecMapStartDate = '1990-03-23', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 80309 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GST-R' WHERE SecCode = 80661 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 80731 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 80795 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 80981 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 80986 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 81284 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 81348 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 81365 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838791208.0, InstrPermID = 8590003972.0, PriValQuotePermID = 55838791208.0, PermSecMapStartDate = '1996-12-16', startDate = '1996-12-16' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 81484 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 81910 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 81990 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 82264 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 82305 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 82480 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 82507 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 82540 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82801 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 82816 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 82965 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837433383.0, InstrPermID = 8590928853.0, PriValQuotePermID = 55837433383.0, PermSecMapStartDate = '1990-03-23' WHERE SecCode = 83142 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951637.0 WHERE SecCode = 83144 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 83427 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 83544 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 83822 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 84084 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 84580 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 85077 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 85142 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 85176 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 85182 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 85196 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 85214 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 85304 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 86037 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 86100 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 86694 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 86760 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 86832 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951222.0 WHERE SecCode = 87067 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 87653 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951999.0 WHERE SecCode = 87961 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 88102 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 89057 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 89294 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90056 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90059 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 90096 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 90248 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 90392 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90446 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90447 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 90522 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90613 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 90714 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90750 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951520.0 WHERE SecCode = 90770 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837436625.0, InstrPermID = 8589982160.0, PriValQuotePermID = 55837436625.0, PermInstrStatus = 'AC', PermSecMapStartDate = '2003-11-11', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90810 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90875 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '5202.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 90918 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 90935 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 90961 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951887.0 WHERE SecCode = 91032 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 91110 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 91277 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 91331 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 91337 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 91338 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 91481 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 91743 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 91803 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951338.0 WHERE SecCode = 91844 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 92449 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 92613 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 93049 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 4297699920.0, IsPrimaryInstr = 0.0 WHERE SecCode = 93082 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 93170 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 93196 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 93397 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 93434 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 93525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 93568 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951822.0 WHERE SecCode = 93654 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 93764 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 93765 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 93914 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 93969 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 94328 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 94352 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 94380 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 94449 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 94578 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 94749 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 95069 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951895.0 WHERE SecCode = 95097 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 95126 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'GST', PermIDTicker = 'GST', RkdRIC = 'GST.BK', RkdDisplayRIC = 'GST.BK' WHERE SecCode = 95186 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 95430 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 95548 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 95654 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 95665 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 95735 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95767 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 95880 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 95963 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951317.0 WHERE SecCode = 96109 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 96184 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 96212 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 96319 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 96324 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 96332 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951657.0 WHERE SecCode = 96613 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96658 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 96927 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 96969 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 96988 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 97173 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 97477 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 97866 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 97980 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 98035 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951996.0 WHERE SecCode = 98332 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951184.0 WHERE SecCode = 98343 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 98387 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 98395 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 98498 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA92837C2085', RkdTicker = 'VLI', RkdSEDOL = 'BW0XV5', RkdCUSIP = '92837C20', RkdRIC = 'VLI.V', RkdDisplayRIC = 'VLI.V', RkdCode = 54473.0, RkdIssueID = 1.0, RkdIssueCode = 70832.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 98629 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 98943 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 99064 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837435231.0, InstrPermID = 8590018344.0, PriValQuotePermID = 55837435231.0, PermSecMapStartDate = '1993-10-28', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 99148 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7426.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 99240 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 99468 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 99538 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951996.0 WHERE SecCode = 99591 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 99737 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 99796 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 99963 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 99998 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 100563 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 100770 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 101178 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21616157076.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105182 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 111562 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 111610 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL WHERE SecCode = 114461 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 QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL WHERE SecCode = 115979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 115985 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116213 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5058604983.0, PriInstrPermID = 21630775964.0, IsPrimaryInstr = 0.0, PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 117147 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 PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 124153 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125556 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL WHERE SecCode = 125621 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 QuotePermID = 21503676346.0, InstrPermID = 8590343814.0, OrgPermID = 4295946688.0, PriValQuotePermID = 55852842816.0, PriInstrPermID = 8590343814.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'INC', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', PriTRBCIndPermID = 4294951374.0, PermQuoteRetireDate = '2016-08-17', PermOrgIPODate = NULL, PermSecMapEndDate = '2012-05-02', startDate = '1994-07-20' WHERE SecCode = 126053 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL WHERE SecCode = 126301 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermSecMapStartDate = NULL WHERE SecCode = 126371 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 PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermSecMapStartDate = NULL WHERE SecCode = 126807 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 = 130886 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837435159.0, InstrPermID = 8590014252.0, PriValQuotePermID = 55837435159.0, PermSecMapStartDate = '2008-01-07' WHERE SecCode = 132080 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL WHERE SecCode = 134777 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 = 135958 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 136001 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136034 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 136300 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 = 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 PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 137002 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermSecMapStartDate = NULL WHERE SecCode = 137093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140586 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836323663.0, ExchCode = 'BER', PermQuoteRetireDate = '2016-03-04', endDate = '2016-03-03' WHERE SecCode = 141320 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 142501 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 PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 143500 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1995-01-25' WHERE SecCode = 144362 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 4297699920.0, IsPrimaryInstr = 0.0 WHERE SecCode = 164376 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 180539 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 184458 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 186974 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 186976 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951359.0 WHERE SecCode = 190162 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 55835777030.0 WHERE SecCode = 193790 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 201905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 254678 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 255963 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 257965 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 290236 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951336.0 WHERE SecCode = 290897 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 295873 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951923.0 WHERE SecCode = 301776 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55838786543.0, InstrPermID = 8590010695.0, PriValQuotePermID = 55838786543.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-01-30', PermSecMapStartDate = '2007-06-28', PermSecMapEndDate = '2025-01-29', startDate = '2007-06-28' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 316187 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3856.T^I26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC' WHERE SecCode = 316370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 320251 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951657.0 WHERE SecCode = 320652 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 332778 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474947675.0, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-28', PermSecMapStartDate = '2018-02-01', PermSecMapEndDate = '2019-05-28' WHERE SecCode = 336464 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 337312 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 340602 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 343815 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 345859 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 348099 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 348129 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365468.0 WHERE SecCode = 353065 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 353513 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55838845711.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2020-12-18', PermSecMapStartDate = '2008-01-29', PermSecMapEndDate = '2020-12-18', startDate = '2008-01-29' WHERE SecCode = 355759 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 357147 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 363105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 366217 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 367365 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 375772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 390882 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 PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 411150 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 411229 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 425047 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 452230 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 490265 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 519142 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2005-09-26' WHERE SecCode = 519486 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 519604 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, IncCntry = NULL, PermSecMapStartDate = NULL WHERE SecCode = 519690 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 521094 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PAVT', QuotePermID = 21507368927.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2013-05-06', PermSecMapStartDate = '2012-07-10', PermSecMapEndDate = '2013-05-06' WHERE SecCode = 534987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 546604 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 547552 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 548365 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 552473 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 553833 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BENRP', QuotePermID = 55851409444.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2011-06-10', PermSecMapStartDate = '2009-11-02', PermSecMapEndDate = '2011-09-01' WHERE SecCode = 556058 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 559119 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 561094 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 561100 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 561672 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 703035 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 703206 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 744618 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 771423 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 783007 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 787209 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365465.0 WHERE SecCode = 798106 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 852081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 999958 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1029112 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 1040444 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1098862 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1110130 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1111663 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MFBA', QuotePermID = 21475799570.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2012-10-08', PermSecMapStartDate = '2011-04-08', PermSecMapEndDate = '2012-10-08', startDate = '2011-04-08' WHERE SecCode = 1111756 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 1153309 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 1157313 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2002-03-27' WHERE SecCode = 1204771 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 1204823 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 PermOrgIPODate = NULL, startDate = '2011-06-30' WHERE SecCode = 1209943 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 1331183 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1406086 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1480689 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1481794 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951864.0 WHERE SecCode = 1484963 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 1518051 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 = 1998415 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2279815 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2373494 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 2384448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2417968 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452495 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 2459994 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 2469373 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 PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2659985 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 2694744 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 2700696 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2702971 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2745140 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2802732 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 2830880 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2855836 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2864364 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 2866604 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '2015-04-16' WHERE SecCode = 2907956 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 2916779 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2924599 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2928777 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2947928 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2963599 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 RkdISIN = 'ZAE000209532', RkdSEDOL = 'BYYN3C', RkdCUSIP = 'S0R95L10', RkdRIC = 'BWNJ.J^I26', RkdDisplayRIC = 'BWNJ.J', RkdCode = 104914.0, RkdIssueID = 1.0, RkdIssueCode = 131942.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'JNB', RkdExchCtry = 'ZAF' WHERE SecCode = 3010342 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 3018599 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3054012 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 = 3217947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 3247244 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247268 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3262987 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 3309471 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3317677 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL WHERE SecCode = 3327999 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3339561 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3350629 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3358012 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21621084663.0, InstrPermID = 21621066453.0, PriValQuotePermID = 21621084663.0, PermSecMapStartDate = '2017-08-31', startDate = '2017-08-31' WHERE SecCode = 3394204 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3403633 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3403635 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3405167 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3405169 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21626599263.0, InstrPermID = 21626518471.0, PriValQuotePermID = 21626599263.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-28', PermSecMapStartDate = '2017-11-15', PermSecMapEndDate = '2026-04-27', startDate = '2017-11-15', endDate = '2026-04-27' WHERE SecCode = 3407834 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3439290 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3491796 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3504370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3504662 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3545191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3588049 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3588109 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3625879 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3625881 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3694103 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3796477 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3812315 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3817677 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = NULL WHERE SecCode = 3869751 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21708475736.0, InstrPermID = 21708349280.0, PriValQuotePermID = 21708475736.0, PermSecMapStartDate = '2019-08-26', startDate = '2019-08-26' WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4056242 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 4081803 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4228170 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4359799 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES0105507000', RkdSEDOL = 'BMBQD8', RkdCUSIP = 'E6S80410', RkdRIC = 'YJSS.MC^K25', RkdDisplayRIC = 'YJSS.MC', RkdCode = 129984.0, RkdIssueID = 1.0, RkdIssueCode = 164858.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MCE', RkdExchCtry = 'ESP', PermInstrStatus = 'DC' WHERE SecCode = 4366521 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21785093269.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2023-08-18', PermSecMapStartDate = '2020-12-19', PermSecMapEndDate = '2023-08-18', startDate = '2020-12-19' WHERE SecCode = 4449673 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4453364 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4453366 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4579647 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4671267 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4675176 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4684126 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4712592 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PYRUMo', QuotePermID = 236787861852.0, ExchCode = 'BCO' WHERE SecCode = 4726082 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4749903 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-24', PermOrgIPODate = NULL WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4820978 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4827919 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HT5', QuotePermID = 21890431098.0 WHERE SecCode = 4989623 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5156815 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932834890.0, InstrPermID = 21932801792.0, PriValQuotePermID = 21932834890.0, PermSecMapStartDate = '2022-11-22', startDate = '2022-11-22' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5473221 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5513351 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5527529 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5531918 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236779874202.0, InstrPermID = 232828045936.0, PriValQuotePermID = 236779874202.0, PermSecMapStartDate = '2023-11-01', startDate = '2023-11-01' WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1996-01-02' WHERE SecCode = 5618934 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5626466 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5674192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5677485 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5738355 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5758210 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5850252 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 5991019 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 6336210 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BP084X98', RkdTicker = 'WVIA', RkdSEDOL = 'BP084X', RkdCUSIP = 'G971JB10', RkdRIC = 'WVIA.L', RkdDisplayRIC = 'WVIA.L', RkdCode = 54520.0, RkdIssueID = 1.0, RkdIssueCode = 71434.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 6528955 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 6645648 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 6668263 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 7058573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 7067509 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7092688 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7107703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 7110814 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 7110815 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7110816 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 7110817 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 7110823 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 7110834 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7110835 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544931', QuotePermID = 236803112878.0, ExchCode = 'BSE' WHERE SecCode = 7116174 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OUTLT', QuotePermID = 236815047135.0, IsPrimaryQuote = 1.0, ExchCode = 'OSL' WHERE SecCode = 7119112 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7121865 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 10810505 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 10911631 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 10922456 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 10961061 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CELG RT', QuotePermID = 21475129964.0, InstrPermID = 21475113620.0, OrgPermID = 4295903619.0, PriTrdQuotePermID = 21475129964.0, PriValQuotePermID = 21475113642.0, PriInstrPermID = 8590937206.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'RTS', InstrClass = 'RTS', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951272.0, PermOrgIPODate = '1980-03-17', PermSecMapStartDate = '2010-10-18', startDate = '2010-10-18' WHERE SecCode = 10971048 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 34488745245.0, PermQuoteStatus = 'DC', ExchCode = 'WCB', PermQuoteRetireDate = '2014-05-01', PermSecMapEndDate = '2021-05-12', endDate = '2014-05-01' WHERE SecCode = 10977340 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 10985023 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 34488738498.0, PermQuoteStatus = 'DC', ExchCode = 'WCB', PermQuoteRetireDate = '2014-05-01', PermSecMapEndDate = '2021-05-12', endDate = '2014-05-01' WHERE SecCode = 10999497 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11005823 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475790540.0, ExchCode = 'BTY', QuoteClass = 'ORD' WHERE SecCode = 11007027 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US45257L2079', RkdSEDOL = 'BW0XSV', RkdCUSIP = '45257L20' WHERE SecCode = 11026378 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PNC PR Q', QuotePermID = 21512120442.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'WCB', PermQuoteRetireDate = '2014-05-01', PermSecMapEndDate = '2020-09-01', endDate = '2014-05-01' WHERE SecCode = 11035839 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 44643755599.0, PermQuoteStatus = 'DC', ExchCode = 'WCB', PermQuoteRetireDate = '2014-05-01', PermSecMapEndDate = '2017-11-17', endDate = '2014-05-01' WHERE SecCode = 11036019 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 11078838 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA89658P1027', RkdTicker = 'TOM', RkdSEDOL = 'BW0XV3', RkdCUSIP = '89658P10', RkdRIC = 'TOM.V', RkdDisplayRIC = 'TOM.V', RkdCode = 93553.0, RkdIssueID = 1.0, RkdIssueCode = 117782.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 11079081 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11107747 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US5768104029', RkdTicker = 'MTNB', RkdSEDOL = 'C053M8', RkdCUSIP = '57681040', RkdRIC = 'MTNB.K', RkdDisplayRIC = 'MTNB.A', RkdCode = 97340.0, RkdIssueID = 1.0, RkdIssueCode = 122761.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASE', RkdExchCtry = 'USA' WHERE SecCode = 11128630 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11131041 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL WHERE SecCode = 11136441 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11139756 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11144123 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000404489.0, PriTRBCIndPermID = NULL WHERE SecCode = 11150246 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11151309 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ET PRI', QuotePermID = 25727368324.0, InstrPermID = 232829813773.0, OrgPermID = 6000187321.0, PriTrdQuotePermID = 25727368324.0, PriValQuotePermID = 21608015103.0, PriInstrPermID = 8590920095.0, PriTRBCIndPermID = 4294951977.0, PermOrgIPODate = '2006-02-03', PermSecMapStartDate = '2019-07-09' WHERE SecCode = 11168246 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 11169287 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 11174853 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 11179294 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL, startDate = '2019-08-02' WHERE SecCode = 11199265 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11201339 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11215942 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11226466 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 25727256682.0, InstrPermID = 25727256684.0, OrgPermID = 5080068891.0, PriTrdQuotePermID = 25727256682.0, PriValQuotePermID = 25727256683.0, PriInstrPermID = 25727244278.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'NAS', QuoteClass = 'UNT', InstrClass = 'UNT', DomCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2024-02-23', PermSecMapEndDate = '2024-02-23' WHERE SecCode = 11226559 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US37892C2052', RkdTicker = 'BTLN', RkdSEDOL = 'BW0XSL', RkdCUSIP = '37892C20', RkdRIC = 'BTLN.O', RkdDisplayRIC = 'BTLN.OQ', RkdCode = 127976.0, RkdIssueID = 1.0, RkdIssueCode = 162195.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11226614 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11230021 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4465R1450', RkdTicker = 'DCX', RkdSEDOL = 'BW0XSP', RkdCUSIP = 'G4465R14', RkdRIC = 'DCX.O', RkdDisplayRIC = 'DCX.OQ', RkdCode = 130958.0, RkdIssueID = 1.0, RkdIssueCode = 166123.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11236809 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11242842 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US16307X4007', RkdTicker = 'CTNT', RkdSEDOL = 'BW0XSM', RkdCUSIP = '16307X40', RkdRIC = 'CTNT.O', RkdDisplayRIC = 'CTNT.OQ', RkdCode = 136493.0, RkdIssueID = 1.0, RkdIssueCode = 173473.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11255869 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG3514S1618', RkdTicker = 'GMEX', RkdSEDOL = 'BW0XSR', RkdCUSIP = 'G3514S16', RkdRIC = 'GMEX.O', RkdDisplayRIC = 'GMEX.OQ', RkdCode = 134615.0, RkdIssueID = 1.0, RkdIssueCode = 171121.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 11274903 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3337S1176', RkdTicker = 'FBGL', RkdSEDOL = 'BW0XSQ', RkdCUSIP = 'G3337S11', RkdRIC = 'FBGL.O', RkdDisplayRIC = 'FBGL.OQ', RkdCode = 135841.0, RkdIssueID = 1.0, RkdIssueCode = 172663.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11275238 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4067B1005', RkdTicker = 'GOW', RkdSEDOL = 'BR4XPB', RkdCUSIP = 'G4067B10', RkdRIC = 'GOW.O', RkdDisplayRIC = 'GOW.OQ', DsPrimQtSedol = 'BXFGFT7', RkdCode = 141195.0, RkdIssueID = 1.0, RkdIssueCode = 179913.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11275867 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2703G1111', RkdTicker = 'DLXY', RkdSEDOL = 'BV8DW2', RkdCUSIP = 'G2703G11', RkdRIC = 'DLXY.O', RkdDisplayRIC = 'DLXY.OQ', RkdCode = 140924.0, RkdIssueID = 1.0, RkdIssueCode = 179596.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11280356 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802594375.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291638 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802664825.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291746 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802607948.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291747 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802594319.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291749 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236802665325.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291750 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236805392258.0, InstrPermID = 232929710169.0, OrgPermID = 6000052402.0, PriTrdQuotePermID = 236805392258.0, PriValQuotePermID = 22171411943.0, PriInstrPermID = 232926339285.0, IsPrimaryInstr = 0.0, PermInstrStatus = 'AC', IncCntry = 'CYM', PermOrgIPODate = '2026-04-07', PermSecMapStartDate = '2026-04-07', startDate = '2026-04-07' WHERE SecCode = 11294226 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11300030 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232932832728.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11300259 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2026-09-25' WHERE SecCode = 11302031 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236815084728.0, PriTrdQuotePermID = 236815084728.0, PriValQuotePermID = 25726988540.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS', startDate = '2026-08-04' WHERE SecCode = 11302260 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NSM' WHERE SecCode = 11302266 AND Type_ = 1;