UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 19809 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 30213 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 30235 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 75029 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75124 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79462 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 80275 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81556 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82359 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000150625.0, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 0.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24', startDate = '1989-09-01' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 84806 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951206.0 WHERE SecCode = 86678 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89000 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ROB', DsPrimQtSedol = 'BRSCZV2', PermSecMapEndDate = '2026-06-20', endDate = '2026-06-20' WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92836 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-20', endDate = '2026-06-20' WHERE SecCode = 93731 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98993 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115197 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120580 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 123563 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126439 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126595 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126831 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 127118 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 131520 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134785 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135125 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136734 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137011 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ETIHADENERGY' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21915101821.0, ExchCode = 'FRA' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 359140 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 409378 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951796.0 WHERE SecCode = 410955 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 455870 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 520165 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 561082 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 933268 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 961362 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1693310 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1835921 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1997851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2193116 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2593559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2763364 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2963471 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3174281 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3200982 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 = 3309013 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3395203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3529092 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3833955 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4043055 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-19', PermSecMapEndDate = '2026-06-19' WHERE SecCode = 4046415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4204830 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000150625.0, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 0.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24', startDate = '1989-09-01' WHERE SecCode = 4798367 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'A1GT34', DsPrimQtSedol = 'BX51QB1' WHERE SecCode = 4854751 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-22', SecMapEndDate = '2026-06-19', PermQuoteRetireDate = '2026-06-22', endDate = '2026-06-19' WHERE SecCode = 5134669 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5156823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5645855 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6389725 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6394301 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6403367 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6409741 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6431535 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6448553 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6449028 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6472001 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6478326 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6478352 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6513219 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6556268 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6583658 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6626028 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6638308 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6727820 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', 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, DsSecDelistDate = '2026-06-22', SecMapEndDate = '2026-06-18', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-05-14', endDate = '2026-06-18' WHERE SecCode = 6849662 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 6880028 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000154178.0, PriInstrPermID = 232937212202.0, DomCntry = 'BMU', IncCntry = 'BMU', PermOrgIPODate = '2026-06-05' WHERE SecCode = 6885945 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6923746 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6923751 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASTS01', QuotePermID = 236808578579.0, InstrPermID = 232940748875.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578579.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927580 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LITE01', QuotePermID = 236808578594.0, InstrPermID = 232940748884.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578594.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927581 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VRT01', QuotePermID = 236808578625.0, InstrPermID = 232940748887.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578625.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927582 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KLAC01', QuotePermID = 236808578637.0, InstrPermID = 232940748881.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578637.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927583 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'INTEL01', QuotePermID = 236808582553.0, InstrPermID = 232940748879.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808582553.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927584 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BONDUS01', QuotePermID = 236808583027.0, InstrPermID = 232940748883.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808583027.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927585 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FTG', QuotePermID = 236808619355.0, InstrPermID = 232925179624.0, OrgPermID = 5090749620.0, PriValQuotePermID = 236808619355.0, PriInstrPermID = 232925179624.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'VIE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'DEU', IncCntry = 'DEU', PriTRBCIndPermID = 4294951502.0, PermOrgIPODate = '2026-06-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927586 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236808613401.0 WHERE SecCode = 6927600 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RKLB01', QuotePermID = 236808578603.0, InstrPermID = 232940748885.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578603.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930573 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NBIS01', QuotePermID = 236808578605.0, InstrPermID = 232940748880.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578605.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930574 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LRCX01', QuotePermID = 236808578609.0, InstrPermID = 232940748876.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578609.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930575 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TER01', QuotePermID = 236808578612.0, InstrPermID = 232940748878.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808578612.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930576 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'COIN01', QuotePermID = 236808581724.0, InstrPermID = 232940748877.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808581724.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930577 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALAB01', QuotePermID = 236808581815.0, InstrPermID = 232940748886.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808581815.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930578 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AMAT01', QuotePermID = 236808582115.0, InstrPermID = 232940748882.0, OrgPermID = 4295892905.0, PriValQuotePermID = 236808582115.0, PriInstrPermID = 8590003657.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = '2018-12-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6930579 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000139106.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '2008-10-17' WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRSD2G9', PermSecMapEndDate = '2026-06-20', endDate = '2026-06-20' WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsTypeCode = 'PREF', DsSecDelistDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 11160125 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11195032 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CATTD' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11214228 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000161817.0, PriTRBCIndPermID = 4294951648.0, PermOrgIPODate = '2021-01-20' WHERE SecCode = 11217741 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX55HX2' WHERE SecCode = 11268688 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-19', endDate = '2026-06-19' WHERE SecCode = 11270668 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-19', endDate = '2026-06-19' WHERE SecCode = 11275270 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-19', endDate = '2026-06-19' WHERE SecCode = 11277033 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11281418 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-15', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11282047 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US73181R2076', RkdSEDOL = 'BPK4X5', RkdCUSIP = '73181R20', ShPerListing = 3.0, PermSecMapEndDate = '2026-06-19', endDate = '2026-06-19' WHERE SecCode = 11286613 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11286854 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-19', endDate = '2026-06-19' WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11295027 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232925823392.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11295063 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232916091000.0 WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232925299588.0 WHERE SecCode = 11295151 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232921381814.0 WHERE SecCode = 11295152 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232921151830.0 WHERE SecCode = 11296944 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11297292 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000150625.0, PriInstrPermID = 232812997654.0, IsPrimaryInstr = 1.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2024-07-24' WHERE SecCode = 11297633 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808551771.0, IsPrimaryQuote = 1.0, ExchCode = 'CVE', DsExchQtStartDate = '2026-06-19', SecMapStartDate = '2026-06-18' WHERE SecCode = 11297684 AND Type_ = 1;