UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 10008 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 23554 AND Type_ = 1; UPDATE data_universe SET Name = 'GRUPO AEROPORTUNARIO DEL PAC SPON ADS B' WHERE SecCode = 31509 AND Type_ = 1; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-11', PermSecMapEndDate = '2026-03-11' WHERE SecCode = 32536 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 34550 AND Type_ = 10; UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 43804 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 45900 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-03-11' WHERE SecCode = 49578 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 51774 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'FLNA' WHERE SecCode = 54134 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 54983 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE000A41YDG0', RkdTicker = 'QBY0', RkdSEDOL = 'BW5TWK', RkdCUSIP = 'D6S41S12', RkdRIC = 'QBY0k.DE', RkdDisplayRIC = 'QBY0k.DE', DsPrimQtSedol = 'BW5TWK9' WHERE SecCode = 65452 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'NXTG-M', PermIDTicker = 'NXTG-M' WHERE SecCode = 67304 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 68739 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 74171 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10; UPDATE data_universe SET Name = 'TENNESSEE VALLEY AUTH FED BE PARRS A 2029' WHERE SecCode = 75121 AND Type_ = 1; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951853.0 WHERE SecCode = 78010 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'UAMY', DsExchMnem = 'NYS', RkdIssueStatus = 1.0, ExchCode = 'NYS' WHERE SecCode = 78176 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y8532Y14' WHERE SecCode = 81064 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'GALAXY SUPERMARKET INR10' WHERE SecCode = 83588 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83885 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 84674 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 91135 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 91607 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-11' WHERE SecCode = 92004 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA0889361097', RkdTicker = 'BEAR', RkdSEDOL = 'BS0DRR', RkdCUSIP = '08893610', RkdRIC = 'BEAR.V', RkdDisplayRIC = 'BEAR.V', DsPrimQtSedol = 'BS0DRR0' WHERE SecCode = 92669 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 94026 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 RkdRIC = '9719.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-12', SecMapEndDate = '2026-03-11', PermQuoteRetireDate = '2026-03-12', PermSecMapEndDate = '2026-03-11', endDate = '2026-03-11' WHERE SecCode = 96478 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951887.0 WHERE SecCode = 96506 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'YASUHARA CHEM CO NPV' WHERE SecCode = 99200 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 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 RkdTicker = 'MARSONS', RkdRIC = 'MARS.NS', RkdDisplayRIC = 'MARS.NS', RkdExchCode = 'NSE' WHERE SecCode = 122690 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 126550 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126571 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 136967 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 141573 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142841 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '2006-02-10', SecMapEndDate = '2022-03-03', endDate = '2022-03-03' WHERE SecCode = 143312 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 145199 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 145352 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 179656 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 183464 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 191883 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'KYG2287A1426', RkdSEDOL = 'BS0DMR', RkdCUSIP = 'G2287A14', DsPrimQtSedol = 'BS0DMR5' WHERE SecCode = 306753 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2007-08-02', startDate = '2007-08-02' WHERE SecCode = 313272 AND Type_ = 10; 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 QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 496999 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 522787 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 558747 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 558958 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 561067 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 564083 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 574546 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 578977 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 586469 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 701767 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 798159 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 841108 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 919300 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'HANKING GOLD INTL HKD0.1' WHERE SecCode = 1393083 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 PermInstrStatus = 'DC' WHERE SecCode = 1975053 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2283953 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2367780 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe SET Name = 'ASSET CHAIN LTD HKD0.01 (POST CON)' WHERE SecCode = 2404657 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2638658 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'SDIPpref.ST^C26', DsCtryQtStatus = 'D', DsTypeCode = 'PREF', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-12', SecMapEndDate = '2026-03-11', PermQuoteRetireDate = '2026-03-12', endDate = '2026-03-11' WHERE SecCode = 2830896 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2865468 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21587931857.0, ExchCode = 'BTE' WHERE SecCode = 3157265 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 = 3367032 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3395204 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'AAVAS FINANCIERS INR10' WHERE SecCode = 3616774 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3694400 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3707974 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236804088302.0 WHERE SecCode = 3831386 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 PermOrgIPODate = NULL WHERE SecCode = 4041278 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4605803 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4612954 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 Name = 'BR ADVISORY PARTNE UNITS (1 COM & 2 PRF)' WHERE SecCode = 4807497 AND Type_ = 10; UPDATE data_universe SET Name = 'IANTE INVESTMENTS EUR1' WHERE SecCode = 5009347 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 5078429 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5678867 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5965452 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '2024-11-14' WHERE SecCode = 5996607 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-12', SecMapEndDate = '2026-03-09', PermQuoteRetireDate = '2026-03-12', endDate = '2026-03-09' WHERE SecCode = 6271271 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6431509 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2026-03-11', endDate = '2026-03-11' WHERE SecCode = 6554792 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '2025-11-24' WHERE SecCode = 6567888 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6580781 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6590637 AND Type_ = 10; UPDATE data_universe SET Name = 'NUOBIKAN ARTIFICIA CNY0.1 H' WHERE SecCode = 6612484 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6627600 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6635166 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6658281 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 6705695 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 10778640 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'VITL.UN', Name = 'VITAL INFRASTRUCTURE PPTY TR TR UNIT', PermSecMapEndDate = '2026-03-11', endDate = '2026-03-11' WHERE SecCode = 10934600 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10961120 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11037077 AND Type_ = 1; UPDATE data_universe SET RkdListingType = 'OSR', ShPerListing = NULL WHERE SecCode = 11073795 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11161916 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11189963 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11192690 AND Type_ = 1; UPDATE data_universe SET Name = 'X3 HOLDINGS CO LTD SHS CL A' WHERE SecCode = 11195616 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'BMG053842040', RkdTicker = 'AHL PR E', RkdSEDOL = 'BKDJPD', RkdCUSIP = 'G0538420', RkdRIC = 'AHL_pe', RkdDisplayRIC = 'AHL_pe.N', RkdCode = 144472.0, RkdIssueID = 1.0, RkdIssueCode = 184613.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'EDR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', ShPerListing = 0.001, PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11199469 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11200546 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 11214215 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'QUCY', RkdRIC = 'QUCY.O', RkdDisplayRIC = 'QUCY.OQ' WHERE SecCode = 11233390 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TRCTD', Name = 'TRACTION URANIUM CORP COM', PermSecMapEndDate = '2026-03-11', endDate = '2026-03-11' WHERE SecCode = 11233691 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'SHAZ', QuotePermID = 236803112780.0, IsPrimaryQuote = 1.0, PermQuoteStatus = 'AC', ExchCode = 'NAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-02-18', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11235952 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'GRML', RkdRIC = 'GRML.O', RkdDisplayRIC = 'GRML.OQ', Name = 'GREENLAND MINES LTD COM' WHERE SecCode = 11241417 AND Type_ = 1; UPDATE data_universe SET Name = 'US GOLDMINING INC *W EXP 04/24/2026' WHERE SecCode = 11252345 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG3016G1293', RkdSEDOL = 'BS0DML', RkdCUSIP = 'G3016G12', DsPrimQtSedol = 'BS0DML9' WHERE SecCode = 11252534 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'GMEX', RkdRIC = 'GMEX.O', RkdDisplayRIC = 'GMEX.OQ', Name = 'GMEX ROBOTICS CORPORATION SHS CL A' WHERE SecCode = 11256200 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11257615 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11268211 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5096759285.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11270085 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11276921 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11290725 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11290726 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'CAST', IsMajorSec = 'Y', QuotePermID = 236803182168.0, InstrPermID = 232847066544.0, OrgPermID = 5039373794.0, PriTrdQuotePermID = 236803182168.0, PriValQuotePermID = 25727034204.0, PriInstrPermID = 232847066544.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951197.0, PermOrgIPODate = '2026-03-10', PermSecMapStartDate = '2026-02-19', startDate = '2026-02-19' WHERE SecCode = 11293067 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'Y', QuotePermID = 236804073528.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293113 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'Y', IsPrimaryQuote = 1.0 WHERE SecCode = 11293114 AND Type_ = 1;