UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 2935 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 2936 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 2937 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 8681 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'ADR' WHERE SecCode = 10318 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 17260 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 17267 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 17271 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 17273 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 17276 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 17279 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BWL86C' WHERE SecCode = 23996 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 28281 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 28313 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = 'LEG.N^H26', RkdDisplayRIC = 'LEG.N^H26', RkdIssueStatus = 0.0 WHERE SecCode = 41718 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 42740 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 44555 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-08-26' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 49733 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 65664 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75277 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 76084 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76681 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77957 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-05-27' WHERE SecCode = 78074 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-25' WHERE SecCode = 85790 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-27', SecMapEndDate = '2026-08-26', endDate = '2026-08-26' WHERE SecCode = 86666 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89261 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92215 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 92961 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SCTh.V^H26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-08-26', PermSecMapEndDate = '2026-08-26' WHERE SecCode = 94726 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX3F2Q2' WHERE SecCode = 97070 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113490 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115140 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 115973 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TERAI', RkdRIC = 'TERI.NS', RkdDisplayRIC = 'TERI.NS', RkdExchCode = 'NSE' WHERE SecCode = 137017 AND Type_ = 10;
UPDATE data_universe SET Name = 'CSA COSMIC COLTD KRW100', DsCtryQtStatus = 'A' WHERE SecCode = 147076 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 170011 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VLG', QuotePermID = 55838736391.0, ExchCode = 'MCE', PermQuoteRetireDate = '2013-08-09' WHERE SecCode = 182166 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'RAVAL A.C.S. LTD ILS0.01' WHERE SecCode = 300182 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 311238 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-26' WHERE SecCode = 316370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 323829 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-09-11' WHERE SecCode = 333489 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 342780 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 353486 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '1999-10-07', endDate = '1999-10-07' WHERE SecCode = 520991 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 568101 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SIGNETICS CORP KRW2500', DsCtryQtStatus = 'A' WHERE SecCode = 889182 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PDIDB', PermSecMapEndDate = '2026-08-25' WHERE SecCode = 890647 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXIA SA PLN1.00' WHERE SecCode = 925527 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 944678 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 Name = 'GOLFZON D' WHERE SecCode = 2396445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2409481 AND Type_ = 10;
UPDATE data_universe SET Name = 'TAVEXIA LIFECARE INR1(POST SUBD)' WHERE SecCode = 3054015 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 3118174 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 3337681 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PDIDB' WHERE SecCode = 3356354 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3393877 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3410196 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NXMG' WHERE SecCode = 3558196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteStatus = 'AC', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL, endDate = '2026-08-25' WHERE SecCode = 3661124 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3837261 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3881173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4053515 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-27', endDate = '2026-08-27' WHERE SecCode = 4079177 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHECK POINT SFTWRE BDR EACH 12 REPR 1 COM' WHERE SecCode = 4079208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4197876 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 4361073 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951222.0 WHERE SecCode = 4362627 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2020-10-29' WHERE SecCode = 4382172 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 4388301 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951324.0 WHERE SecCode = 4391264 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 4440273 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4444662 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 4447562 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4452295 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 128658.0 WHERE SecCode = 4680272 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2022-02-23', startDate = '2022-02-01' WHERE SecCode = 4854760 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 4871191 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 131675.0 WHERE SecCode = 5134573 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951466.0 WHERE SecCode = 5295044 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5491798 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5527385 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '5617.T^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-27', SecMapEndDate = '2023-12-19', PermSecMapEndDate = '2026-08-26', endDate = '2023-12-19' WHERE SecCode = 5612363 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5657384 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5693824 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7834.TWO^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-27', SecMapEndDate = '2026-08-26', PermSecMapEndDate = '2026-08-26', endDate = '2026-08-26' WHERE SecCode = 6281750 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000476863', RkdTicker = 'FDC', RkdSEDOL = 'BWYF7F', RkdCUSIP = 'Q3748Z10', RkdRIC = 'FDC.AX', RkdDisplayRIC = 'FDC.AX', RkdCode = 145403.0, RkdIssueID = 1.0, RkdIssueCode = 186116.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6974616 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-08-10' WHERE SecCode = 7040613 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2026-08-18' WHERE SecCode = 7055232 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-08-18' WHERE SecCode = 7055234 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-08-25' WHERE SecCode = 7067671 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-25', PermSecMapEndDate = '2026-08-25' WHERE SecCode = 10923445 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX3F2X9' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 11023927 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11141457 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11141459 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'DBT' WHERE SecCode = 11157443 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SRGE', Name = 'SURGE DIGITAL INC COM', PermSecMapEndDate = '2026-08-26', endDate = '2026-08-26' WHERE SecCode = 11174939 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'VAI', RkdRIC = 'VAI.O', RkdDisplayRIC = 'VAI.OQ', Name = 'VALOR ENERGY INC COM' WHERE SecCode = 11183463 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-27', SecMapEndDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 11192959 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 11199336 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 11202017 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NFGC', DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11210907 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11211824 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-26', SecMapEndDate = '2026-08-25', endDate = '2026-08-25' WHERE SecCode = 11213474 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-26', SecMapEndDate = '2026-08-25', endDate = '2026-08-25' WHERE SecCode = 11214672 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951955.0 WHERE SecCode = 11216029 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX3F2V7' WHERE SecCode = 11219287 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EK', Name = 'EVERKIND WELLNESS INC COM SHS', PermSecMapEndDate = '2026-08-26', endDate = '2026-08-26' WHERE SecCode = 11220828 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 11224447 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11226283 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11229943 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX3F2W8' WHERE SecCode = 11237859 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11238913 AND Type_ = 1;
UPDATE data_universe SET Name = 'EVENTER TECHNOLOGIES LTD COM SHS' WHERE SecCode = 11239946 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 11243215 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11257663 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11260025 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11274056 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-08-26', PermSecMapEndDate = '2026-08-26' WHERE SecCode = 11282159 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX3F325' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11288189 AND Type_ = 1;
UPDATE data_universe SET Name = 'INFLECTION POINT ACQUISITION C UNIT 02/11/2031' WHERE SecCode = 11291836 AND Type_ = 1;
UPDATE data_universe SET Name = 'INFLECTION POINT ACQUISITION C USD CL A ORD SHS' WHERE SecCode = 11292617 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'NA' WHERE SecCode = 11294226 AND Type_ = 1;
UPDATE data_universe SET Name = 'AF3 CAP CORP COM SHS' WHERE SecCode = 11296182 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11298355 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PPURF', QuotePermID = 236809207729.0, InstrPermID = 232930064835.0, OrgPermID = 6000135769.0, PriValQuotePermID = 236807111700.0, PriInstrPermID = 232930064835.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PermOrgIPODate = '2026-05-15', PermSecMapStartDate = '2026-06-30' WHERE SecCode = 11298562 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-08-12' WHERE SecCode = 11300262 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ADBT', QuotePermID = 236812899356.0, InstrPermID = 232906584084.0, OrgPermID = 5097065782.0, PriTrdQuotePermID = 236812899356.0, PriValQuotePermID = 25726992668.0, PriInstrPermID = 232906584084.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'USA', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2026-08-25', PermSecMapStartDate = '2026-08-22', startDate = '2026-08-22' WHERE SecCode = 11300849 AND Type_ = 1;