UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 27634 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 28294 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-11-06' WHERE SecCode = 36539 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'INVN.I', QuotePermID = 21475591267.0, ExchCode = 'CSS', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 42094 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 51700 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 51907 AND Type_ = 10;
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 QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MR BRICOLAGE SA EUR5.8' WHERE SecCode = 65667 AND Type_ = 10;
UPDATE data_universe SET Name = 'CYPRIUM METALS LTD NPV' WHERE SecCode = 73540 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 74181 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76156 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'COMPUCASE ENT CO TWD10' WHERE SecCode = 79849 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GRIV0RG', QuotePermID = 55838823916.0, ExchCode = 'JKT', PermQuoteRetireDate = '2007-05-02' WHERE SecCode = 80954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81643 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82755 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 83231 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 85232 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 88019 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951638.0 WHERE SecCode = 88072 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-20' WHERE SecCode = 90803 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 93075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93941 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA45968V2057', RkdSEDOL = 'BP9MB5', RkdCUSIP = '45968V20', DsPrimQtSedol = 'BP9MB53' WHERE SecCode = 96426 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951710.0 WHERE SecCode = 97085 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951931.0 WHERE SecCode = 114067 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951287.0 WHERE SecCode = 114907 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837424519.0, ExchCode = 'TYO' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 116143 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140586 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474848733.0, ExchCode = 'DEU', PermQuoteRetireDate = '2023-05-17', endDate = '2023-05-16' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 187271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 192507 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 243470 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 329642 AND Type_ = 10;
UPDATE data_universe SET Name = 'ETHTRY PLC ORD GBP0.00002' WHERE SecCode = 370942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 379145 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 391589 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000422537', RkdTicker = 'TMKDD', PermIDTicker = 'TMKDD', RkdSEDOL = 'BVMYP6', RkdRIC = 'TMKDD.AX', RkdDisplayRIC = 'TMKDD.AX', DsPrimQtSedol = 'BVMYP67', SecMapEndDate = '2025-11-05', endDate = '2025-11-05' WHERE SecCode = 391897 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951338.0 WHERE SecCode = 684567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 799260 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1482696 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1675617 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q9436126' WHERE SecCode = 1712306 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2313087 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q3482M16' WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2379792 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2527863 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TMKDD', DsPrimQtSedol = 'BVMYP67' WHERE SecCode = 2529648 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 2882468 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2940863 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 3218367 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3282787 AND Type_ = 10;
UPDATE data_universe SET Name = 'GLOBE ENT INDIA INR2' WHERE SecCode = 3396319 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3405972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3438770 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'T''WAY AIR CO LTD KRW100' WHERE SecCode = 3564647 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TMKDD', DsPrimQtSedol = 'BVMYP67' WHERE SecCode = 3972133 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4307882 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TSP ADV TECHS PLC ORD GBP0.0001' WHERE SecCode = 4334575 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2020-10-21' WHERE SecCode = 4386318 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-11-06' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'YOUG.DE^K25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-11-07', endDate = '2025-11-07' WHERE SecCode = 4620960 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365618.0 WHERE SecCode = 4646578 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 4646579 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4745232 AND Type_ = 10;
UPDATE data_universe SET Name = 'CLUB DE FUTBOL INT EUR0.05' WHERE SecCode = 4759584 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'COLLAX', PermIDTicker = 'COLLAX', RkdRIC = 'COLLAX.ST', RkdDisplayRIC = 'COLLAX.ST' WHERE SecCode = 4808888 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4887335 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KLINIQ.BK', RkdDisplayRIC = 'KLINIQ.BK' WHERE SecCode = 5228532 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5239788 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-11-06', PermSecMapEndDate = '2025-11-06' WHERE SecCode = 5346555 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 5388815 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SKY' WHERE SecCode = 5399889 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5764048 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5035526218.0, PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2017-04-07' WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6272209 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 6476445 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-07', SecMapEndDate = '2025-11-06', endDate = '2025-11-06' WHERE SecCode = 6503812 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6507166 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 6513037 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'THD342010002', RkdTicker = 'IDG', RkdSEDOL = 'BTMQ1V', RkdCUSIP = 'Y4104911', RkdRIC = 'IDGm.BK', RkdDisplayRIC = 'IDGm.BK', RkdCode = 143384.0, RkdIssueID = 1.0, RkdIssueCode = 183058.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BAK', RkdExchCtry = 'THA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6518457 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'THD165010006', RkdTicker = 'MASTEC', RkdSEDOL = 'BVBFHF', RkdCUSIP = 'Y5894011', RkdRIC = 'MASTEC.BK', RkdDisplayRIC = 'MASTEC.BK', RkdCode = 143386.0, RkdIssueID = 1.0, RkdIssueCode = 183060.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BAK', RkdExchCtry = 'THA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6520660 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 6533602 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000428088', RkdTicker = 'CMA', RkdSEDOL = 'BMHX19', RkdCUSIP = 'Q2099M10', RkdRIC = 'CMA.AX', RkdDisplayRIC = 'CMA.AX', RkdCode = 143382.0, RkdIssueID = 1.0, RkdIssueCode = 183056.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6533604 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PriTRBCIndPermID = 1004365366.0 WHERE SecCode = 6533611 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0, PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 6533615 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0, PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 6533616 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6533617 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232817158766.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6533636 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MRC.N^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-06', SecMapEndDate = '2025-11-05', PermQuoteRetireDate = '2025-11-06', PermSecMapEndDate = '2025-11-06', endDate = '2025-11-05' WHERE SecCode = 11026293 AND Type_ = 1;
UPDATE data_universe SET Name = 'ELSE NUTRITION HLDGS INC COM NEW', PermSecMapEndDate = '2025-11-06', endDate = '2025-11-06' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2012-10-03' WHERE SecCode = 11036562 AND Type_ = 1;
UPDATE data_universe SET Name = 'USA COMPRESSION PARTNERS LP COM UNIT LTDPAR' WHERE SecCode = 11046053 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-06', SecMapEndDate = '2025-11-05', endDate = '2025-11-05' WHERE SecCode = 11174189 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097003431.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951465.0, PermOrgIPODate = '2021-02-17' WHERE SecCode = 11219488 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AUHID', Name = 'ADVANCED GOLD EXPL INC COM NEW' WHERE SecCode = 11235068 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11236999 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'DHAI.PK', RkdDisplayRIC = 'DHAI.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-11-07', endDate = '2025-11-07' WHERE SecCode = 11239922 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11255994 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG7385S1193', RkdSEDOL = 'BP9M53', RkdCUSIP = 'G7385S11', DsPrimQtSedol = 'BP9M539' WHERE SecCode = 11265201 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11270950 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0, startDate = '2024-11-27' WHERE SecCode = 11272056 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798432215.0, PriTrdQuotePermID = 236798432215.0, PriValQuotePermID = 25727047711.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11274658 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232907181719.0 WHERE SecCode = 11286202 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232875264284.0 WHERE SecCode = 11286560 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951578.0 WHERE SecCode = 11287078 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232907181719.0 WHERE SecCode = 11287453 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-10-31' WHERE SecCode = 11287553 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798432197.0, PriTrdQuotePermID = 236798432197.0, PriValQuotePermID = 25727047752.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NAS' WHERE SecCode = 11287731 AND Type_ = 1;
