UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4052 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US70532Y4026', RkdSEDOL = 'BSHX2B', RkdCUSIP = '70532Y40', DsPrimQtSedol = 'BSHX2B2' WHERE SecCode = 9838 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 10008 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 23554 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-14' WHERE SecCode = 27134 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000054860.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 28027 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-14' WHERE SecCode = 29418 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 34550 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 41255 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 45900 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-03-12' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 51774 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 57718 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'FRA', DsExchQtStartDate = '1999-10-13' WHERE SecCode = 61780 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'QBY0', Name = 'Q.BEYOND AG NPV (CON SHARES)' WHERE SecCode = 65452 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 65489 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67304 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 71080 AND Type_ = 10;
UPDATE data_universe SET Name = 'NATIONSMARK NEXTGEN COM NEW' WHERE SecCode = 76618 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'BAIJUYI HLDGS GROU HKD0.01' WHERE SecCode = 76703 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NURT.BO', RkdDisplayRIC = 'NURT.BO' WHERE SecCode = 77682 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951759.0, PermQuoteRetireDate = '2026-03-16' WHERE SecCode = 78626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80041 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG1987Y2020', RkdSEDOL = 'BVY6G1', RkdCUSIP = 'G1987Y20', DsPrimQtSedol = 'BVY6G13' WHERE SecCode = 82731 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83586 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951989.0 WHERE SecCode = 84043 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85361 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-30' WHERE SecCode = 85909 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86796 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-16' WHERE SecCode = 88266 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FULL.SI^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-13', SecMapEndDate = '2018-02-14', endDate = '2018-02-14' WHERE SecCode = 91198 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 91239 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = '8BF', RkdRIC = '8BF.SG^C26', RkdExchCode = 'BWB', RkdExchCtry = 'DEU', QuotePermID = 21480669147.0, PriValQuotePermID = 55838511827.0, IsPrimaryQuote = 0.0, ExchCode = 'PNK', PermSecMapStartDate = '2011-12-06' WHERE SecCode = 92004 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BEAR', Name = 'BIG BEAR GOLD CORP COM' WHERE SecCode = 92669 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '2374.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-13', SecMapEndDate = '2026-03-12', endDate = '2026-03-12' WHERE SecCode = 92746 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 93867 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7718.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-13', SecMapEndDate = '2026-03-12', endDate = '2026-03-12' WHERE SecCode = 96268 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, PriValQuotePermID = 55838607005.0 WHERE SecCode = 96478 AND Type_ = 10;
UPDATE data_universe SET Name = 'PINETREE CAPITAL LTD COM' WHERE SecCode = 98021 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2024-11-16' WHERE SecCode = 120435 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236804169193.0 WHERE SecCode = 122690 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 129820 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 141573 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 145199 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 145352 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 179656 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 185740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 268435 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '1893.H', QuotePermID = 21476459275.0, ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24', endDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473202.0, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395061 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-16' WHERE SecCode = 467519 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 774870 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 826229 AND Type_ = 10;
UPDATE data_universe SET Name = 'VINH LG CEREAL & VND10000' WHERE SecCode = 919300 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1072162 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1606548 AND Type_ = 10;
UPDATE data_universe SET Name = 'REGION RE LTD NPV' WHERE SecCode = 1911626 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 1975053 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-14' WHERE SecCode = 2253329 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 2367780 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 = 2531731 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 2782865 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-12' WHERE SecCode = 2830896 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2885873 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3072605 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE799B01025', RkdSEDOL = 'BS850W', RkdCUSIP = 'Y319BD11', DsPrimQtSedol = 'BS850W4' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247161 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 3284006 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 3297033 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 3300832 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3317156 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3320055 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SHANGHAI PORIGINE A CNY1' WHERE SecCode = 3353725 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GURK.BO', RkdDisplayRIC = 'GURK.BO' WHERE SecCode = 3356357 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3395204 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 3409381 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3441675 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3707974 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AEPL', QuotePermID = 236804088302.0, ExchCode = 'NSI' WHERE SecCode = 3831386 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 119497.0 WHERE SecCode = 4433930 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 4565159 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KITW.L^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-13', SecMapEndDate = '2026-03-12', endDate = '2026-03-12' WHERE SecCode = 4605803 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4612954 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21818254739.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-13' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4794514 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 PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 4929218 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5257731 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 5710445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5965452 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-12' WHERE SecCode = 6271271 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 6305339 AND Type_ = 10;
UPDATE data_universe SET Name = 'SURAJ INDUSTRIES INR10 (PPD10 UPD30)' WHERE SecCode = 6554792 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SA16H0MGKM14', RkdTicker = '1324', RkdSEDOL = 'BQLPJR', RkdRIC = '1324.SE', RkdDisplayRIC = '1324.SE', Name = 'SALEH ABDULAZIZ AL SAR10', RkdCode = 144482.0, RkdIssueID = 1.0, RkdIssueCode = 184624.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SAU', RkdExchCtry = 'SAU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6710027 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710028 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710029 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710030 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710031 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710032 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710033 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710034 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710035 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710036 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710037 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710038 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710039 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710146 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6710293 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10934600 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 10961120 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ALEX.N^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-13', SecMapEndDate = '2026-03-12', endDate = '2026-03-12' WHERE SecCode = 11030360 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA53044R8672', RkdSEDOL = 'BTMSZR', RkdCUSIP = '53044R86', DsPrimQtSedol = 'BTMSZR6' WHERE SecCode = 11065308 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11070567 AND Type_ = 1;
UPDATE data_universe SET QuoteClass = 'CUM', InstrClass = 'CUM' WHERE SecCode = 11157844 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804090484.0, PriTrdQuotePermID = 236804090484.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-03-11', startDate = '2017-07-12' WHERE SecCode = 11174584 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5223X1759', RkdSEDOL = 'BTHZ06', RkdCUSIP = 'G5223X17', DsPrimQtSedol = 'BTHZ066' WHERE SecCode = 11178865 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000049816.0, PriInstrPermID = 21670874421.0, PermOrgIPODate = NULL WHERE SecCode = 11192690 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11194931 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11199612 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11205229 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QUCY', Name = 'MAINZ BIOMED N V SHS NEW' WHERE SecCode = 11233390 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11233691 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-09-18', SecMapEndDate = '2025-09-16', endDate = '2025-09-16' WHERE SecCode = 11241414 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GRML' WHERE SecCode = 11241417 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GMEX', Name = 'GMEX ROBOTICS CORP SHS CL A', Country = 'VGB' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096759285.0, PriInstrPermID = 232850027482.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11268211 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8437Q1275', RkdSEDOL = 'BTMRWL', RkdCUSIP = 'G8437Q12', DsPrimQtSedol = 'BTMRWL6' WHERE SecCode = 11270583 AND Type_ = 1;
UPDATE data_universe SET Country = 'CYM' WHERE SecCode = 11275317 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BGXCF' WHERE SecCode = 11275324 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANCO SANTANDER SA SANTANDER CN DEP' WHERE SecCode = 11278268 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11286562 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291136 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291635 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293010 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804090541.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293143 AND Type_ = 1;
