UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 18317 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-13' WHERE SecCode = 35857 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798769538.0, ExchCode = 'ASE', PermSecMapStartDate = '2025-11-12' WHERE SecCode = 54177 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NDASEs', QuotePermID = 21617880508.0, ExchCode = 'EBT', PermQuoteRetireDate = '2018-11-28', endDate = '2018-11-28' WHERE SecCode = 54237 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TTOG.DE', RkdDisplayRIC = 'TTOG.DE', RkdExchCode = 'ETR' WHERE SecCode = 59657 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 DsCtryQtStatus = 'S' WHERE SecCode = 63770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 66986 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68473 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69698 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71712 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 71986 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 78024 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE375C01022', RkdSEDOL = 'BRF55W', RkdCUSIP = 'Y7470X15', DsPrimQtSedol = 'BRF55W5', PermSecMapEndDate = '2025-11-13', endDate = '2025-11-13' WHERE SecCode = 78616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80552 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 = 81729 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82656 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 84897 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 86334 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 86668 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-12-17' WHERE SecCode = 87006 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87880 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727196678.0, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 89403 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SGXE20364795', RkdTicker = '1U8', PermIDTicker = '1U8', RkdSEDOL = 'BRC370', DsPrimQtSedol = 'BRC3704', PermSecMapEndDate = '2025-11-13', endDate = '2025-11-13' WHERE SecCode = 89861 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 90843 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 90844 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92479 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'EMX.V^K25', RkdIssueStatus = 0.0 WHERE SecCode = 93742 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, PermOrgIPODate = '2025-12-17' WHERE SecCode = 105303 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115323 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115341 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000430365', RkdTicker = 'TD1DB', PermIDTicker = 'TD1DB', RkdSEDOL = 'BSML5B', RkdRIC = 'TD1DB.AX', RkdDisplayRIC = 'TD1DB.AX', DsPrimQtSedol = 'BSML5B2', SecMapEndDate = '2025-11-12', PermSecMapEndDate = '2025-11-13', endDate = '2025-11-12' WHERE SecCode = 115415 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-12' WHERE SecCode = 126434 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE855C01023', RkdSEDOL = 'BRF567', RkdCUSIP = 'Y9532G15', DsPrimQtSedol = 'BRF5677', PermSecMapEndDate = '2025-11-13', endDate = '2025-11-13' WHERE SecCode = 126910 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 141412 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145473 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 147153 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000AMA8', RkdTicker = 'AMA', PermIDTicker = 'AMA', RkdSEDOL = 'B1CND9', RkdCUSIP = 'Q0280A21', RkdRIC = 'AMA.AX', RkdDisplayRIC = 'AMA.AX', DsPrimQtSedol = 'B1CND93' WHERE SecCode = 161050 AND Type_ = 10;
UPDATE data_universe SET Name = 'PYRAMID AG NPV' WHERE SecCode = 171251 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 243353 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA28620K1066', RkdSEDOL = 'BVMNPR', RkdCUSIP = '28620K10', DsPrimQtSedol = 'BVMNPR5' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'DIVISO GRUPO FINAN PEN0.05' WHERE SecCode = 323357 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG0137L1106', RkdSEDOL = 'BS848C', RkdCUSIP = 'G0137L11', DsPrimQtSedol = 'BS848C7' WHERE SecCode = 331506 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 348329 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 348331 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1195576 AND Type_ = 10;
UPDATE data_universe SET Name = 'PASUKHAS GROUP NPV' WHERE SecCode = 1660236 AND Type_ = 10;
UPDATE data_universe SET Name = 'JAVELIN MINERALS L NPV' WHERE SecCode = 1712306 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2238141 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2238143 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2457963 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 2465108 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 2514702 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'QHE', RkdRIC = 'QHE.L', RkdDisplayRIC = 'QHE.L' WHERE SecCode = 2528745 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2739713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-13', SecMapEndDate = '2023-07-25', PermQuoteRetireDate = '2025-11-13', endDate = '2023-07-25' WHERE SecCode = 2745149 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-13', SecMapEndDate = '2020-04-30', PermQuoteRetireDate = '2025-11-13', endDate = '2020-04-30' WHERE SecCode = 2836275 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-11-12', PermSecMapEndDate = NULL, startDate = '2015-07-08', endDate = NULL WHERE SecCode = 2930569 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2984547 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TD1DB', DsPrimQtSedol = 'BSML5B2' WHERE SecCode = 3010340 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 3254554 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 3289746 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3305553 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 0.0 WHERE SecCode = 3434717 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-12' WHERE SecCode = 3980857 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4219579 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 4291597 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 4339150 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-11-13' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MPA.AX^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-13', SecMapEndDate = '2025-11-03', PermQuoteRetireDate = '2025-11-13', PermSecMapEndDate = '2025-11-13', endDate = '2025-11-03' WHERE SecCode = 4546462 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097007832.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4620960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4645344 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4763068 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860598463.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5045206 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'MODIS', RkdRIC = 'MODA.NS', RkdDisplayRIC = 'MODA.NS', RkdExchCode = 'NSE' WHERE SecCode = 5072191 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 5276216 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21951566813.0 WHERE SecCode = 5346555 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-11-12' WHERE SecCode = 5388816 AND Type_ = 10;
UPDATE data_universe SET Name = 'LANA MEDICAL CO SAR1' WHERE SecCode = 5601075 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '275A.NG', RkdDisplayRIC = '275A.NG', RkdExchCode = 'NAG' WHERE SecCode = 5996607 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-11-13', SecMapEndDate = '2025-02-11', PermQuoteRetireDate = '2025-11-13', endDate = '2025-02-11' WHERE SecCode = 6058661 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097007832.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6091323 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6325222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6375311 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6548032 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MAE.V^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-11-14', endDate = '2025-11-14' WHERE SecCode = 10778640 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 10912421 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 10980767 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11137077 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11153539 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11176943 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11178696 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11185342 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11192150 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11200546 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11205692 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11208243 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11213414 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA5273691025', RkdSEDOL = 'BS84D0', RkdCUSIP = '52736910', DsPrimQtSedol = 'BS84D00' WHERE SecCode = 11219153 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11221183 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11221756 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11222419 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11239988 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BOIL', DsExchMnem = 'TSE', QuotePermID = 21895251398.0, IsPrimaryQuote = 1.0, ExchCode = 'TOR', PermSecMapStartDate = '2022-05-25' WHERE SecCode = 11243838 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11269987 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG646271137', RkdSEDOL = 'BV973B', RkdCUSIP = 'G6462711', DsPrimQtSedol = 'BV973B0' WHERE SecCode = 11271889 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MTSR.OQ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-11-14', SecMapEndDate = '2025-11-13', endDate = '2025-11-13' WHERE SecCode = 11274512 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MRP' WHERE SecCode = 11274664 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11275634 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 192882307903.0 WHERE SecCode = 11285114 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2021-05-26' WHERE SecCode = 11285215 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 11287136 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236798769646.0 WHERE SecCode = 11287712 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 11287745 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236798769513.0 WHERE SecCode = 11287918 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IFC.PR.M', Name = 'INTACT FINL CORP 5.5 CL A SR 13', QuotePermID = 236798748122.0, InstrPermID = 232906149559.0, OrgPermID = 4295862990.0, PriValQuotePermID = 236798748122.0, PriInstrPermID = 8590940855.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'NONCUM', InstrClass = 'NONCUM', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951344.0, PermOrgIPODate = '2004-12-10', PermSecMapStartDate = '2025-11-11', startDate = '2025-11-11' WHERE SecCode = 11288058 AND Type_ = 1;
