UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 19538 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'FARM.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-06', SecMapEndDate = '2026-05-04', PermQuoteRetireDate = '2026-05-06', endDate = '2026-05-04' WHERE SecCode = 25455 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 28992 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 32261 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 38223 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 42637 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 49092 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-05' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET Name = 'FLSMIDTH & CO A/S DKK0.1' WHERE SecCode = 53028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-04-30', endDate = '2026-04-30' WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'CCR', DomCntry = 'CAN' WHERE SecCode = 60083 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'ATARI EUR2 (POST CONS)' WHERE SecCode = 63566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70771 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70885 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71695 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 71922 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 72002 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000463291', RkdTicker = 'SRNDB', PermIDTicker = 'SRNDB', RkdSEDOL = 'BR1FB4', RkdRIC = 'SRNDB.AX', RkdDisplayRIC = 'SRNDB.AX', DsPrimQtSedol = 'BR1FB43', SecMapEndDate = '2026-05-04', endDate = '2026-05-04' WHERE SecCode = 72565 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73144 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 73639 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 73894 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75276 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75296 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 75538 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76132 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76652 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 77317 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78146 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78476 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81471 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82359 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82656 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83668 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84034 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951600.0 WHERE SecCode = 84930 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 86877 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951600.0 WHERE SecCode = 86912 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 87258 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90276 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 90990 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92988 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93102 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94993 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 95172 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98809 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99006 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 99231 AND Type_ = 10;
UPDATE data_universe SET Name = 'MULVIHILL CAPITAL MANAGEMENT PREMIUM GLB CL A', PermSecMapEndDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 101281 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHE' WHERE SecCode = 101803 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105066 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = NULL WHERE SecCode = 105376 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 112948 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 113490 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 113879 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SGXE12305384', RkdTicker = 'WNH', PermIDTicker = 'WNH', RkdSEDOL = 'BSBFYC', DsPrimQtSedol = 'BSBFYC9' WHERE SecCode = 113941 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'REC SILICON ASA NOK0.1' WHERE SecCode = 114528 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114538 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951188.0 WHERE SecCode = 116848 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120580 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 124075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125442 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126433 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 126438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126439 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 131520 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 132399 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136734 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137011 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 137521 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 139163 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 140663 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 140965 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142542 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 145495 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 155319 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 162938 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 165084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 174946 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdSEDOL = 'BX686Y', Name = 'BRADSAUDE SA COM NPV', DsPrimQtSedol = 'BX686Y4' WHERE SecCode = 184471 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 190572 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'LEXR.BO', RkdDisplayRIC = 'LEXR.BO' WHERE SecCode = 256764 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 257809 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 298943 AND Type_ = 10;
UPDATE data_universe SET Name = 'SERVAL RES PLC ORD GBP0.005' WHERE SecCode = 317701 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 338708 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 340812 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 342877 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 DsCtryQtStatus = 'A' WHERE SecCode = 349523 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473202.0, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 362271 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236792907732.0, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 429392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 431231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 546612 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 547454 AND Type_ = 10;
UPDATE data_universe SET Name = 'METRO MINING LTD NPV' WHERE SecCode = 555050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 557329 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951245.0 WHERE SecCode = 557938 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474908406.0, ExchCode = 'DEU', PermQuoteRetireDate = '2018-02-05' WHERE SecCode = 564280 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 598890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 623643 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 683529 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951674.0 WHERE SecCode = 683638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 717246 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 784604 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 832249 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 873717 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 877039 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 1043297 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1544263 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 1544676 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 1565080 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 1617059 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1619265 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1661624 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1693310 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1997851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2051462 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMATHEON AGRI HLDG EUR0.10' WHERE SecCode = 2087901 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2193116 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2372649 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2412427 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-05-04', PermQuoteRetireDate = '2026-05-05', endDate = '2026-05-04' WHERE SecCode = 2458784 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951559.0 WHERE SecCode = 2536845 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 2560607 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2585474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2593559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2623933 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 2628633 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 2646533 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2650080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2658229 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 2671255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2701612 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2725363 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2763364 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2800425 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2829009 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2830903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2853468 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2862755 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2882464 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 2911289 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2919788 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 2924593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2937562 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2941983 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2963471 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3064630 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3072605 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951257.0 WHERE SecCode = 3109366 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3152632 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3196947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3200982 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 3208330 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3210058 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3242026 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 3263272 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-04', endDate = '2026-05-04' WHERE SecCode = 3288678 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3288938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 3321108 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3365045 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3377753 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3385731 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3392421 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3394722 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3403353 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 3403847 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21627526402.0 WHERE SecCode = 3407480 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951377.0 WHERE SecCode = 3429345 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 3430218 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3436908 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'PER' WHERE SecCode = 3438892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SRNDB', DsPrimQtSedol = 'BR1FB43' WHERE SecCode = 3445122 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3509116 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 3547833 AND Type_ = 10;
UPDATE data_universe SET Name = 'AVRO INDIA LTD INR1(POST SUBD)' WHERE SecCode = 3559194 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3678990 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'MYQ0450OO005', RkdSEDOL = 'BX593T' WHERE SecCode = 3693295 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3706496 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951813.0 WHERE SecCode = 3789372 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3791544 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 3796468 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951388.0 WHERE SecCode = 3847123 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3899672 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3899674 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3899677 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3986739 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 3991810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3999398 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 4291603 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 4295603 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4326990 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4359806 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 4369901 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 4456052 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4531619 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4607294 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236779442609.0, ExchCode = 'EQD', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4645345 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4650985 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4651843 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4697278 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0028354936', RkdSEDOL = 'BSHW9C', RkdCUSIP = 'W5150J22', DsPrimQtSedol = 'BSHW9C9' WHERE SecCode = 4711623 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 4830791 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21959379953.0, ExchCode = 'TDG' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 5059329 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-05-05' WHERE SecCode = 5112392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 5207903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5239788 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 5241270 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 5301614 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 5357733 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 5411329 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG9541D1438', RkdSEDOL = 'BS1L8L', RkdCUSIP = 'G9541D14', DsPrimQtSedol = 'BS1L8L4' WHERE SecCode = 5629057 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 5693827 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 5782811 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22053017262.0, ExchCode = 'DEU' WHERE SecCode = 5886926 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5978189 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6173318 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 6258500 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6281777 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'MYS' WHERE SecCode = 6318870 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 6361848 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236806467614.0, PermSecMapStartDate = '2025-11-18', startDate = '2025-11-18' WHERE SecCode = 6562602 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 6589128 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 6617616 AND Type_ = 10;
UPDATE data_universe SET Name = 'SANOFI EUR2 (RFD 01/01/2026)', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6622347 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-04' WHERE SecCode = 6737828 AND Type_ = 10;
UPDATE data_universe SET Name = 'SERVAL RES PLC ORD GBP0.005' WHERE SecCode = 6806445 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007HW9', RkdTicker = '6810', RkdSEDOL = 'BNNM6S', RkdCUSIP = 'Y7T8J010', RkdRIC = '6810.HK', RkdDisplayRIC = '6810.HK', RkdCode = 144753.0, RkdIssueID = 1.0, RkdIssueCode = 185124.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 129339.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6813821 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'I3M0', QuotePermID = 236806335035.0, InstrPermID = 232925613790.0, OrgPermID = 6000034016.0, PriValQuotePermID = 236806335035.0, PriInstrPermID = 232925613790.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'DUS', QuoteClass = 'GENUS', InstrClass = 'GENUS', OrgTypeCode = 'COM', DomCntry = 'DEU', IncCntry = 'DEU', PermSecMapStartDate = '2026-04-29' WHERE SecCode = 6813917 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-04-30', startDate = '2026-04-21' WHERE SecCode = 6820111 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 10902812 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 10925336 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 10933004 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL, RkdCode = 79583.0, RkdIssueCode = 164459.0, RelType = 2.0 WHERE SecCode = 10999173 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11006190 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11023815 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11142190 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 11148547 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11149514 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-04-16' WHERE SecCode = 11153361 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL, RkdCode = 79583.0, RkdIssueCode = 164463.0, RelType = 2.0 WHERE SecCode = 11157785 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11163321 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11178183 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11186707 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11186768 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 11195367 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11195932 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 11196231 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11196578 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11196721 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'DBT' WHERE SecCode = 11200546 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'CAL', RkdExchCtry = 'IND' WHERE SecCode = 11206869 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11216101 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'TERN.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-06', SecMapEndDate = '2026-05-04', PermQuoteRetireDate = '2026-05-06', endDate = '2026-05-04' WHERE SecCode = 11218773 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11221146 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11221982 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 11222359 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11223968 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11224331 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 11225117 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11227595 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11229567 AND Type_ = 1;
UPDATE data_universe SET Name = 'THISTLE RESOURCES INC COM', PermSecMapEndDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 11246642 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA9080861011', RkdTicker = 'UPPR', RkdSEDOL = 'BX566L', RkdCUSIP = '90808610', RkdRIC = 'UPPR.CD', RkdDisplayRIC = 'UPPR.CD', DsPrimQtSedol = 'BX566L6', PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11257436 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11260506 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IPTND', Name = 'CREDISSENTIAL INC COM NEW', SecMapEndDate = '2079-06-06', PermSecMapEndDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 11261939 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11263502 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SLCNF' WHERE SecCode = 11271927 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG6146G1173', RkdSEDOL = 'BX565Z', RkdCUSIP = 'G6146G11', DsPrimQtSedol = 'BX565Z3' WHERE SecCode = 11273895 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11277444 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 11280405 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291832 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232923523003.0 WHERE SecCode = 11293243 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SKMPF', QuotePermID = 236805613655.0, InstrPermID = 232813463607.0, OrgPermID = 5086689648.0, PriValQuotePermID = 236779627457.0, PriInstrPermID = 232813463607.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951922.0, SecMapStartDate = '2025-03-11', PermOrgIPODate = '2023-10-17', PermSecMapStartDate = '2026-04-11', startDate = '2023-10-17' WHERE SecCode = 11294403 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CAIIU', QuotePermID = 236806335012.0, InstrPermID = 232925823389.0, OrgPermID = 6000078832.0, PriTrdQuotePermID = 236806335012.0, PriValQuotePermID = 25727024805.0, PriInstrPermID = 232925823389.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-04-29', PermSecMapStartDate = '2026-04-29' WHERE SecCode = 11295063 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ARCLU', QuotePermID = 236806334965.0, InstrPermID = 232891590776.0, OrgPermID = 5095925178.0, PriTrdQuotePermID = 236806334965.0, PriValQuotePermID = 25727024862.0, PriInstrPermID = 232891590776.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'VGB', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = '2026-04-30', PermSecMapStartDate = '2026-04-29', startDate = '2026-04-29' WHERE SecCode = 11295149 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FTHAU', QuotePermID = 236806414085.0, InstrPermID = 232916091007.0, OrgPermID = 6000052050.0, PriTrdQuotePermID = 236806414085.0, PriValQuotePermID = 25727024650.0, PriInstrPermID = 232916091007.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'CYM', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-04-30', PermSecMapStartDate = '2026-04-30' WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QLEP.U', QuotePermID = 236806413577.0, InstrPermID = 232917713313.0, OrgPermID = 6000030958.0, PriTrdQuotePermID = 236806413577.0, PriValQuotePermID = 25727024681.0, PriInstrPermID = 232917713313.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-01', PermSecMapStartDate = '2026-04-30', startDate = '2026-04-30' WHERE SecCode = 11295230 AND Type_ = 1;