UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 23965 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'BATICIM BATI ANADO TRY1 (B SHARES)' WHERE SecCode = 36128 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'COFB.BR^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 36833 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 40869 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-30' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BPXZLR0' WHERE SecCode = 60432 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'BATICIM CIMENTO SA TRY1 (B SHARES)' WHERE SecCode = 65907 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68204 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 68209 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69136 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 72507 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GUJENERGY' WHERE SecCode = 72544 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73995 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 74536 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 76126 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76748 AND Type_ = 10;
UPDATE data_universe SET Name = 'AURIQUE LTD INR10 (POST SPLIT)', DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHINA NETCOM TECHN HKD0.25' WHERE SecCode = 79390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80018 AND Type_ = 10;
UPDATE data_universe SET Name = 'MINING AMERICAS INC COM SHS', PermSecMapEndDate = '2026-01-03', endDate = '2026-01-03' WHERE SecCode = 80076 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 81061 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81363 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 82584 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '008500.KS^F26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85483 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951742.0 WHERE SecCode = 85852 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91086 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 94266 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94873 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 95203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97012 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DNK' WHERE SecCode = 100680 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 114440 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120444 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 121068 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 123508 AND Type_ = 10;
UPDATE data_universe SET Name = 'IMPERA WWIDE LTD INR10' WHERE SecCode = 126342 AND Type_ = 10;
UPDATE data_universe SET Name = 'LEXORA GLOBAL LTD INR10' WHERE SecCode = 126816 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126831 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IND' WHERE SecCode = 139134 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142684 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'B8L', QuotePermID = 55836024490.0, ExchCode = 'ISE', PermQuoteRetireDate = '2011-09-02', endDate = '2011-09-01' WHERE SecCode = 145528 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21518995421.0, ExchCode = 'DEU' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VOIM' WHERE SecCode = 212058 AND Type_ = 10;
UPDATE data_universe SET Name = 'PADAM INDUSTRIES L INR1(POST SUBD)' WHERE SecCode = 243321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 293429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 298971 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 303801 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SURYASTONE INTEGRA INR10' WHERE SecCode = 311013 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 319543 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ECHO', RkdRIC = 'ECHO.O', RkdDisplayRIC = 'ECHO.OQ' WHERE SecCode = 335216 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 355015 AND Type_ = 1;
UPDATE data_universe SET 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, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL WHERE SecCode = 387643 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 409378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 533042 AND Type_ = 10;
UPDATE data_universe SET Name = 'KMD BRANDS LTD NPV POST SPLIT' WHERE SecCode = 552491 AND Type_ = 10;
UPDATE data_universe SET Name = 'UNIFY GROUP EUR0.02' WHERE SecCode = 555021 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-29' WHERE SecCode = 797593 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GENEA CAP JT STK VND10000' WHERE SecCode = 905102 AND Type_ = 10;
UPDATE data_universe SET Name = 'EC EXCEL HLDGS BHD NPV' WHERE SecCode = 941144 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 1025043 AND Type_ = 10;
UPDATE data_universe SET 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-30', SecMapEndDate = '2026-06-26', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2011-02-23', endDate = '2026-06-26' WHERE SecCode = 1025098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1108511 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1241264 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 QuotePermID = 21492779438.0, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BDFZZM' WHERE SecCode = 1632047 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', endDate = '2026-06-30' WHERE SecCode = 2394793 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2455559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2455560 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-05-15', PermQuoteRetireDate = '2026-07-01', endDate = '2026-05-15' WHERE SecCode = 2531731 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PIPN.BO', RkdDisplayRIC = 'PIPN.BO', Name = 'PIPAN OILS LTD INR2 (POST SPLT)' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2606470 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2731219 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2775918 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, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2015-03-10' WHERE SecCode = 2835285 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2862763 AND Type_ = 10;
UPDATE data_universe SET Name = 'STARBEAM VENTURES INR1 (POST SUBD)' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2911314 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'MMR' WHERE SecCode = 2926784 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 2945892 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589172352.0, ExchCode = 'FRA' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2987277 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3056107 AND Type_ = 10;
UPDATE data_universe SET Name = 'A INFRSTR LTD INR5 (POST CONSOLIDATION)' WHERE SecCode = 3083499 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3244872 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3246339 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MLPTZ', DsCtryQtStatus = 'A' WHERE SecCode = 3275891 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3276033 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3282988 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3354056 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLINCVISION AB SER''B''NPV' WHERE SecCode = 3355024 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3382505 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3382506 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951237.0 WHERE SecCode = 3392421 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3395018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3409200 AND Type_ = 10;
UPDATE data_universe SET Name = 'INERTIA ALU TECH L INR10' WHERE SecCode = 3430222 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MEDFIN B' WHERE SecCode = 3433717 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21859526011.0, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-20', endDate = '2022-06-20' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET Name = 'HUA XIA WATER GROU HKD0.01' WHERE SecCode = 3441674 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3600988 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DDG', DsCtryQtStatus = 'A', PermQuoteStatus = 'AC', ExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, endDate = '2026-06-23' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 3706713 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3812315 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3887973 AND Type_ = 10;
UPDATE data_universe SET Name = 'GREEN POWER GROU HKD0.01' WHERE SecCode = 4010777 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4201682 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4361053 AND Type_ = 10;
UPDATE data_universe SET Name = 'C&R RESEARCH INC KRW500' WHERE SecCode = 4365041 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 4388301 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 4494105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4557737 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4631916 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, Name = 'CHERRY SE NPV (POST SPLIT)', 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, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2021-06-29' WHERE SecCode = 4632104 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4733111 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4794505 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4821107 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMERICAN WEST GOLD NPV' WHERE SecCode = 4847060 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET Name = 'NINE & CO INC KRW100' WHERE SecCode = 4936070 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 4981867 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5119093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5146920 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5234138 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 5257731 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5293397 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5350554 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 5353894 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5397477 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5443486 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISDEM TECHNOSYS L INR10' WHERE SecCode = 5536095 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5577479 AND Type_ = 10;
UPDATE data_universe SET Name = 'DOCTRACK SOLN LTD INR10' WHERE SecCode = 5646894 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '136A', QuotePermID = 236781345007.0, InstrPermID = 232836950709.0, OrgPermID = 5039678512.0, PriValQuotePermID = 236781345007.0, PriInstrPermID = 232836950709.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'TYO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'JPN', PriTRBCIndPermID = 4294951807.0, PermQuoteRetireDate = '2026-06-30', PermSecMapStartDate = '2024-02-07', PermSecMapEndDate = '2026-06-29', startDate = '2024-02-07' WHERE SecCode = 5668353 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5674196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 5689852 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-28' WHERE SecCode = 5807861 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-30', SecMapEndDate = '2025-08-18', PermQuoteRetireDate = '2026-06-30', endDate = '2025-08-18' WHERE SecCode = 5859850 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-07-09' WHERE SecCode = 6354196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6434966 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6645649 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 6724414 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N', QuotePermID = 236806710555.0, InstrPermID = 232934017108.0, OrgPermID = 5096933363.0, PriValQuotePermID = 236806710555.0, PriInstrPermID = 232929330331.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'WSE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'POL', IncCntry = 'POL', PriTRBCIndPermID = 4294951592.0, PermQuoteRetireDate = '2026-06-29', PermOrgIPODate = '2026-05-07', PermSecMapStartDate = '2026-05-06', PermSecMapEndDate = '2026-06-29', startDate = '2026-05-06' WHERE SecCode = 6832532 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 6927579 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A426PD9', RkdTicker = 'FTG', RkdSEDOL = 'BS700V', RkdCUSIP = 'D2S2DZ10', RkdRIC = 'FTG.VI', RkdDisplayRIC = 'FTG.VI', RkdCode = 144467.0, RkdIssueID = 1.0, RkdIssueCode = 184593.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'WBAG', RkdExchCtry = 'AUT', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6927586 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6934848 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TW0007418B18', RkdTicker = '7418', RkdSEDOL = 'BXFHZM', RkdCUSIP = 'Y443JR10', RkdRIC = '7418.TWO', RkdDisplayRIC = '7418.TWO', RkdCode = 145095.0, RkdIssueID = 1.0, RkdIssueCode = 185655.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6945383 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TW0007929002', RkdTicker = '7929', RkdSEDOL = 'BXFHZR', RkdCUSIP = 'Y124BZ10', RkdRIC = '7929.TWO', RkdDisplayRIC = '7929.TWO', RkdCode = 145094.0, RkdIssueID = 1.0, RkdIssueCode = 185654.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6945384 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TW0007931008', RkdTicker = '7931', RkdSEDOL = 'BPQVBN', RkdCUSIP = 'Y832L010', RkdRIC = '7931.TWO', RkdDisplayRIC = '7931.TWO', RkdCode = 145096.0, RkdIssueID = 1.0, RkdIssueCode = 185656.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6948295 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 6948338 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236809167270.0, PriValQuotePermID = 236809064863.0, ExchCode = 'FRA', PriTRBCIndPermID = 4294951694.0 WHERE SecCode = 6948353 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 10771857 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'NSLR', RkdRIC = 'NSLR.O', RkdDisplayRIC = 'NSLR.OQ', Name = 'NEOSTELLAR CAPITAL CORP COM NEW' WHERE SecCode = 11002274 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 11014953 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'DST.CD^F26', RkdIssueStatus = 0.0 WHERE SecCode = 11133200 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 11142096 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 236779729186.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'PNK', PermQuoteRetireDate = '2025-07-25', PermSecMapStartDate = '2023-10-21', PermSecMapEndDate = '2025-07-25', endDate = '2025-07-25' WHERE SecCode = 11158560 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', endDate = '2026-06-30' WHERE SecCode = 11169286 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', endDate = '2026-06-30' WHERE SecCode = 11178625 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-11', endDate = '2026-04-11' WHERE SecCode = 11196712 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 236793803185.0, PermQuoteStatus = 'DC', ExchCode = 'GTC', PermQuoteRetireDate = '2026-06-30', PermSecMapEndDate = '2021-07-03', endDate = '2021-07-03' WHERE SecCode = 11198864 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11201544 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11205238 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRSCTV0' WHERE SecCode = 11210122 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPXZLQ9' WHERE SecCode = 11225381 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-04-11', endDate = '2025-04-11' WHERE SecCode = 11227447 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2021-09-09', startDate = '2021-09-09' WHERE SecCode = 11233791 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096906340.0, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2026-06-26', startDate = '2022-01-25' WHERE SecCode = 11237342 AND Type_ = 1;
UPDATE data_universe SET Name = 'STABLECOINX INC *W EXP 06/25/2031' WHERE SecCode = 11237509 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-24', endDate = '2026-02-24' WHERE SecCode = 11252479 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11255442 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11256494 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11264180 AND Type_ = 1;
UPDATE data_universe SET Name = 'MAREX GROUP LIMITED ORD', DsPrimQtSedol = 'BSBB331' WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11270991 AND Type_ = 1;
UPDATE data_universe SET Name = 'HOUSE OF DOGE INC COM' WHERE SecCode = 11275764 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US87821B1098', RkdTicker = 'TMS', RkdSEDOL = 'BVSRPN', RkdCUSIP = '87821B10', RkdRIC = 'TMS.O', RkdDisplayRIC = 'TMS.OQ' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA03772D1015', RkdTicker = 'APTX', RkdSEDOL = 'BVMH6Y', RkdCUSIP = '03772D10', RkdRIC = 'APTX.TO', RkdDisplayRIC = 'APTX.TO', RkdCode = 145109.0, RkdIssueID = 1.0, RkdIssueCode = 185672.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11297255 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US6989551014', RkdTicker = 'PBLS', RkdSEDOL = 'BVMHN7', RkdCUSIP = '69895510', RkdRIC = 'PBLS.O', RkdDisplayRIC = 'PBLS.OQ', RkdCode = 145100.0, RkdIssueID = 1.0, RkdIssueCode = 185662.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11297326 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297726 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'APMC', QuotePermID = 236809001616.0, InstrPermID = 232942228392.0, OrgPermID = 6000064759.0, PriTrdQuotePermID = 236809001616.0, PriValQuotePermID = 25727015871.0, PriInstrPermID = 232942228392.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-03', PermSecMapStartDate = '2026-06-26', startDate = '2026-06-03' WHERE SecCode = 11298445 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OTAI', QuotePermID = 236808931504.0, InstrPermID = 232927390510.0, OrgPermID = 5097138024.0, PriTrdQuotePermID = 236808931504.0, PriValQuotePermID = 25727016108.0, PriInstrPermID = 232927390510.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-08', PermSecMapStartDate = '2026-06-25', startDate = '2026-05-08' WHERE SecCode = 11298447 AND Type_ = 1;
