UPDATE data_universe SET DsSecDelistDate = '2025-09-12' WHERE SecCode = 697 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 18201 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69698 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-21' WHERE SecCode = 73311 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75850 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 76930 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6406.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 80329 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85973 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6734.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 87315 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89723 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1994-01-20' WHERE SecCode = 98095 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 112295 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 122791 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126781 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142727 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 4.0 WHERE SecCode = 334841 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 81608.0 WHERE SecCode = 623290 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1082263 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1485661 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1678746 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1999277 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1994-01-20' WHERE SecCode = 2315229 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2574384 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2865468 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'IGLD.L^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 3200664 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3961.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 3247113 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3297239 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3409194 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3999456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4375184 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 4444652 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 4482511 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 4571432 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KTEn.H^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-23', endDate = '2026-03-23' WHERE SecCode = 4578183 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 136379.0 WHERE SecCode = 5383315 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 136379.0 WHERE SecCode = 5383316 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6166983 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6503823 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6628670 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6661526 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US02919L8853', RkdSEDOL = 'BMW1W0', RkdCUSIP = '02919L88', DsPrimQtSedol = 'BMW1W08' WHERE SecCode = 11156315 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11190289 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11191099 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BMW23D', PermSecMapEndDate = '2026-03-21', endDate = '2026-03-21' WHERE SecCode = 11192817 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11219081 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.66667 WHERE SecCode = 11225764 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232926650516.0 WHERE SecCode = 11230025 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG3142E1473', RkdSEDOL = 'BMW1W2', RkdCUSIP = 'G3142E14', DsPrimQtSedol = 'BMW1W20' WHERE SecCode = 11235694 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BMW1WK', RkdCUSIP = 'G9888Q11', DsPrimQtSedol = 'BMW1WK8', PermSecMapEndDate = '2026-03-21', endDate = '2026-03-21' WHERE SecCode = 11264467 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG7396L1297', RkdSEDOL = 'BX2HZT', RkdCUSIP = 'G7396L12', DsPrimQtSedol = 'BX2HZT3' WHERE SecCode = 11265202 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG063821329', RkdSEDOL = 'BMW1W1', RkdCUSIP = 'G0638213', DsPrimQtSedol = 'BMW1W19' WHERE SecCode = 11268806 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3580P2080', RkdSEDOL = 'BMW1W3', RkdCUSIP = 'G3580P20', DsPrimQtSedol = 'BMW1W31' WHERE SecCode = 11277444 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232816459926.0 WHERE SecCode = 11289849 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11291180 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232913683809.0 WHERE SecCode = 11291349 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291903 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293396 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804485145.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293452 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804485248.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293453 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804485410.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293456 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293509 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11293510 AND Type_ = 1;
