UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 17992 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 24430 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA', IncCntry = 'USA' WHERE SecCode = 24565 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'ELEKTRA.MX^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-27', SecMapEndDate = '2026-04-24', PermQuoteRetireDate = '2026-04-27', PermSecMapEndDate = '2026-04-27', endDate = '2026-04-24' WHERE SecCode = 31370 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHE' WHERE SecCode = 34915 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHE' WHERE SecCode = 34916 AND Type_ = 10;
UPDATE data_universe SET Name = 'BCA POP DI SONDRIO EUR3' WHERE SecCode = 36029 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 42619 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-04-27' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-04-27' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 51163 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ILKKA1.HE^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-28', SecMapEndDate = '2026-04-27', PermQuoteRetireDate = '2026-04-28', endDate = '2026-04-27' WHERE SecCode = 58851 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ILKKA', PermIDTicker = 'ILKKA', RkdRIC = 'ILKKA.HE', RkdDisplayRIC = 'ILKKA.HE' WHERE SecCode = 58852 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67149 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69928 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1986-01-03' WHERE SecCode = 69936 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR' WHERE SecCode = 71190 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHE' WHERE SecCode = 71407 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 71904 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72507 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74585 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 75423 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'IA INC KRW1000' WHERE SecCode = 75860 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 76235 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ELRL', PermIDTicker = 'ELRL', RkdRIC = 'ELRL.TA', RkdDisplayRIC = 'ELRL.TA' WHERE SecCode = 78430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79286 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-04-24', PermSecMapEndDate = '2026-04-26', endDate = '2026-04-24' WHERE SecCode = 80148 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 81404 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82087 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GYFT.BO', RkdDisplayRIC = 'GYFT.BO' WHERE SecCode = 82553 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 82780 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 83697 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 84887 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85834 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ARE' WHERE SecCode = 86156 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 86464 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87109 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 88188 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727196678.0, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88968 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 90050 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'SK SECURITIES CO KRW1000' WHERE SecCode = 90104 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SK SECURITIES CO PRF KRW1000' WHERE SecCode = 90107 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-04-24', PermSecMapEndDate = '2026-04-26', endDate = '2026-04-24' WHERE SecCode = 91011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91674 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IDN' WHERE SecCode = 93059 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TSE' WHERE SecCode = 93447 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93553 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-27' WHERE SecCode = 93937 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 94249 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94751 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95316 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95337 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95479 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SUNGCHANG ENTERPRI KRW2500' WHERE SecCode = 96538 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 97478 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA78657T1084', RkdTicker = 'SF', PermIDTicker = 'SF', RkdSEDOL = 'BPBPBW', RkdCUSIP = '78657T10', RkdRIC = 'SF.V', RkdDisplayRIC = 'SF.V', DsPrimQtSedol = 'BPBPBW7' WHERE SecCode = 97778 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 100845 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951515.0 WHERE SecCode = 100924 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdTicker = 'EBP', PermIDTicker = 'EBP', RkdRIC = 'EBP.WA', RkdDisplayRIC = 'EBP.WA', Name = 'ERSTE BANK POLSKA PLN10.00' WHERE SecCode = 101022 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'FOLD.OQ^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-28', SecMapEndDate = '2026-04-24', PermQuoteRetireDate = '2026-04-28', endDate = '2026-04-24' WHERE SecCode = 102088 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 111786 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 111831 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116295 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GGY' WHERE SecCode = 132965 AND Type_ = 10;
UPDATE data_universe SET Name = 'DESI FARMS INDIA INR10' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 141332 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 142079 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 153607 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 169161 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951594.0 WHERE SecCode = 180085 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 180086 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 183623 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951650.0 WHERE SecCode = 190460 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JAS ROBOTICS INC KRW500' WHERE SecCode = 191528 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-04-03', PermSecMapEndDate = '2026-04-26', endDate = '2026-04-03' WHERE SecCode = 285308 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US9286612067', RkdSEDOL = 'BMWDT4', RkdCUSIP = '92866120', DsPrimQtSedol = 'BMWDT47' WHERE SecCode = 295486 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 296938 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951536.0 WHERE SecCode = 301293 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'IFS' WHERE SecCode = 302149 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2007-06-29' WHERE SecCode = 302635 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 310997 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEWI INVEST ASA NOK12' WHERE SecCode = 317693 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, Name = 'OSCILLATE PLC ORD GBP0.005', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-04-27', PermSecMapEndDate = '2026-04-27' WHERE SecCode = 317701 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 333221 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 334255 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 338708 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIG DIGITAL ENERGY INC COM NEW' WHERE SecCode = 340288 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55834800221.0, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24', endDate = '2018-04-16' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MIRL' WHERE SecCode = 345939 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 353888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 357801 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 383390 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 387264 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 387440 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395057 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798948725.0, ExchCode = 'DUS' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 496999 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 551344 AND Type_ = 10;
UPDATE data_universe SET Name = 'METRO MINING LTD NPV DFD 04/05/26(EX-RIGHTS)' WHERE SecCode = 555050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 564881 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 565563 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 697807 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 850477 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'UKR' WHERE SecCode = 866994 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 890820 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'VGB' WHERE SecCode = 904700 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 962511 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1076521 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1210717 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 1225241 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1467740 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 1482794 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 PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 1534187 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779438.0, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 1544263 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1611710 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1614005 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1617060 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 2200211 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2270944 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2450640 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2459992 AND Type_ = 10;
UPDATE data_universe SET Name = 'JTL DEFENCE LTD INR10 (POST SPLT)' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 2579463 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 2591694 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 2646541 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 2693650 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2695648 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TUINl', QuotePermID = 21553634480.0, ExchCode = 'BCO', PermQuoteRetireDate = '2015-05-20' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2800418 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951943.0 WHERE SecCode = 2885882 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'VAF.HM^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-28', SecMapEndDate = '2026-04-24', endDate = '2026-04-24' WHERE SecCode = 2912792 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951846.0 WHERE SecCode = 2921461 AND Type_ = 10;
UPDATE data_universe SET Name = 'ZGOO HLDGS CO LTD KRW500' WHERE SecCode = 2924542 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 2924577 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 2945279 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 2990820 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951624.0 WHERE SecCode = 2994417 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2994441 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951369.0 WHERE SecCode = 3002460 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 3003939 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3010363 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3021792 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3043894 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951756.0 WHERE SecCode = 3071812 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3112871 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3124242 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOLUMIX CO LTD KRW200' WHERE SecCode = 3145242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3152611 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-04-24', PermSecMapEndDate = '2026-04-26', endDate = '2026-04-24' WHERE SecCode = 3174446 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3208816 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951592.0 WHERE SecCode = 3275687 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951590.0 WHERE SecCode = 3289743 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 3317675 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'SWE' WHERE SecCode = 3341126 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BALYOp', QuotePermID = 21615240978.0, IsPrimaryQuote = 0.0, ExchCode = 'BCO', SecMapEndDate = '2026-04-10', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2026-04-27', endDate = '2026-04-10' WHERE SecCode = 3358228 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3358513 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3379226 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 3398617 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 3403370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951846.0 WHERE SecCode = 3403838 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951280.0 WHERE SecCode = 3407063 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '5259.T^D26', RkdIssueStatus = 0.0 WHERE SecCode = 3407834 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3409379 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 3430218 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 3435531 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3495780 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3501411 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 3545200 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 3549454 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951611.0 WHERE SecCode = 3550497 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 3551900 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951860.0 WHERE SecCode = 3578291 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951592.0 WHERE SecCode = 3586867 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3595446 AND Type_ = 10;
UPDATE data_universe SET Name = 'KUKJEON CO LTD KRW100' WHERE SecCode = 3704764 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 3735954 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 3789373 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 3809778 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951546.0 WHERE SecCode = 3839133 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951874.0 WHERE SecCode = 3875780 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 3894824 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 3930586 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 3941017 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 3947539 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 3960045 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 3991811 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 4054258 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 4066103 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4129533 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4242463 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951546.0 WHERE SecCode = 4272423 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4291239 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4320807 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 4361073 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791494702.0, PermQuoteStatus = 'AC', ExchCode = 'JAX', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'GVTDA' WHERE SecCode = 4377196 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 4393370 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 4396708 AND Type_ = 10;
UPDATE data_universe SET Name = 'TOTAL GRAPHITE PLC ORD GBP0.01' WHERE SecCode = 4442693 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NNG.AX^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-27', SecMapEndDate = '2024-04-24', PermQuoteRetireDate = '2026-04-27', PermSecMapEndDate = '2026-04-27', endDate = '2024-04-24' WHERE SecCode = 4502482 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-04-24', PermSecMapEndDate = '2026-04-27', endDate = '2026-04-24' WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 4546467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4550511 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4557731 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 4557909 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21821642083.0, ExchCode = 'BTE', PermQuoteRetireDate = '2025-08-05' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951883.0 WHERE SecCode = 4622042 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'VGB' WHERE SecCode = 4648192 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 4649974 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21853461208.0, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4750082 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 4786371 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 4787472 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ARE' WHERE SecCode = 4800499 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 4804664 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4871153 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 4981867 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5009318 AND Type_ = 10;
UPDATE data_universe SET Name = 'Q AID CO LTD KRW500' WHERE SecCode = 5054827 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5067491 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951762.0 WHERE SecCode = 5082434 AND Type_ = 10;
UPDATE data_universe SET Name = 'PICOMAT HOLDING JO VND10000' WHERE SecCode = 5104479 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TAR', PermIDTicker = 'TAR', RkdRIC = 'TAR.L', RkdDisplayRIC = 'TAR.L' WHERE SecCode = 5281304 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 5381824 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 5455271 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 5550746 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 5622345 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 5702905 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7760.TW', RkdDisplayRIC = '7760.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5917709 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 5985680 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6026120 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHE' WHERE SecCode = 6305206 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6421094 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951578.0 WHERE SecCode = 6431525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 6546182 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 6548034 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-28', SecMapEndDate = '2026-04-27', PermQuoteRetireDate = '2026-04-28', endDate = '2026-04-27' WHERE SecCode = 6622352 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NO0013697029', RkdTicker = 'KMAR', RkdSEDOL = 'BVMZHV', RkdCUSIP = 'R0R21J10', RkdRIC = 'KMAR.OL', RkdDisplayRIC = 'KMAR.OL', RkdCode = 144736.0, RkdIssueID = 1.0, RkdIssueCode = 185081.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'OSL', RkdExchCtry = 'NOR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6802673 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 6806193 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 10906505 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 10914011 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 10971266 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11006190 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11014953 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11023815 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951918.0 WHERE SecCode = 11028389 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11029630 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11034601 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 1.0 WHERE SecCode = 11074374 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'VGB' WHERE SecCode = 11148269 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11153361 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11162301 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-29' WHERE SecCode = 11162946 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11165638 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BHS' WHERE SecCode = 11178321 AND Type_ = 1;
UPDATE data_universe SET Name = 'OSIRIS ONE METALS LTD COM' WHERE SecCode = 11182728 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11183460 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11186707 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 11189974 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11191594 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'USA' WHERE SecCode = 11192522 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11192685 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11192883 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 11194856 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BHS' WHERE SecCode = 11195175 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11197145 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11198674 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'USA' WHERE SecCode = 11198864 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'PRI' WHERE SecCode = 11199549 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 11200331 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11205537 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 11216029 AND Type_ = 1;
UPDATE data_universe SET Name = 'Z SQUARED INC COM' WHERE SecCode = 11216358 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 19515.0, RelType = 1.0 WHERE SecCode = 11216640 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11216890 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11222469 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11225564 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US45032V3069', RkdSEDOL = 'BPBP61', RkdCUSIP = '45032V30', DsPrimQtSedol = 'BPBP611' WHERE SecCode = 11225845 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11228344 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11232101 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0515341059', RkdTicker = 'AURR', RkdSEDOL = 'BPBP63', RkdCUSIP = '05153410', RkdRIC = 'AURR.CD', RkdDisplayRIC = 'AURR.CD', DsPrimQtSedol = 'BPBP633' WHERE SecCode = 11233898 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'VBIO', PermIDTicker = 'VBIO', RkdRIC = 'VBIO.O', RkdDisplayRIC = 'VBIO.OQ', Name = 'VALION BIO INC COMMON STOCK' WHERE SecCode = 11233903 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11234264 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11235401 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA92244M1041', RkdTicker = 'PAIN', PermIDTicker = 'PAIN', RkdSEDOL = 'BPBPC4', RkdCUSIP = '92244M10', RkdRIC = 'PAIN.V', RkdDisplayRIC = 'PAIN.V', DsPrimQtSedol = 'BPBPC46', SecMapStartDate = '2022-07-27' WHERE SecCode = 11244158 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 11248419 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951580.0 WHERE SecCode = 11251522 AND Type_ = 1;
UPDATE data_universe SET Name = 'US GOLDMINING INC *W EXP 05/1/2026' WHERE SecCode = 11252345 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MMET', QuotePermID = 236778397700.0, IsPrimaryQuote = 1.0, ExchCode = 'CVE', PermSecMapStartDate = '2023-07-20' WHERE SecCode = 11256838 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11257130 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11260025 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11266043 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'ZSPC.PK', RkdDisplayRIC = 'ZSPC.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-28', endDate = '2026-04-28' WHERE SecCode = 11272365 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951416.0 WHERE SecCode = 11273567 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG286871127', RkdSEDOL = 'BPBP5J', RkdCUSIP = 'G2868711', DsPrimQtSedol = 'BPBP5J2' WHERE SecCode = 11274178 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11278234 AND Type_ = 1;
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 WHERE SecCode = 11292544 AND Type_ = 1;
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 WHERE SecCode = 11293143 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-03-18' WHERE SecCode = 11293460 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8557R1039', RkdTicker = 'SUMA', RkdSEDOL = 'BRWG5Z', RkdCUSIP = 'G8557R10', RkdRIC = 'SUMA.O', RkdDisplayRIC = 'SUMA.OQ', RkdCode = 144663.0, RkdIssueID = 1.0, RkdIssueCode = 184946.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294692 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9037S1093', RkdTicker = 'TRGS', RkdSEDOL = 'BX54H2', RkdCUSIP = 'G9037S10', RkdRIC = 'TRGS.O', RkdDisplayRIC = 'TRGS.OQ', RkdCode = 144321.0, RkdIssueID = 1.0, RkdIssueCode = 184336.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294694 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EM', QuotePermID = 236805997205.0, InstrPermID = 232929351653.0, OrgPermID = 6000034282.0, PriValQuotePermID = 236805997205.0, PriInstrPermID = 232929351653.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'CVE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951901.0, PermOrgIPODate = '2026-04-22', PermSecMapStartDate = '2026-04-21', startDate = '2026-04-21' WHERE SecCode = 11294772 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KCA.U', QuotePermID = 236806021125.0, InstrPermID = 232923243076.0, OrgPermID = 6000025245.0, PriTrdQuotePermID = 236806021125.0, PriValQuotePermID = 25727025688.0, PriInstrPermID = 232920552837.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-04', PermSecMapStartDate = '2026-04-22', startDate = '2026-04-22' WHERE SecCode = 11294935 AND Type_ = 1;
