UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 12167 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-07-02', PermQuoteRetireDate = '2026-07-03', endDate = '2026-07-02' WHERE SecCode = 12192 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTCL724' WHERE SecCode = 18047 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 27772 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 66432 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 67906 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 70153 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951609.0 WHERE SecCode = 72714 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77957 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BXN', DsPrimQtSedol = 'B7Z3MX9' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81363 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 0.0, PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85718 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 88648 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 90314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91257 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BSBFLF1' WHERE SecCode = 93821 AND Type_ = 1;
UPDATE data_universe SET Name = 'GETTY COPPER INC COM SHS' WHERE SecCode = 94367 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '600608.SS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 95203 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-22' WHERE SecCode = 96636 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97691 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97907 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 98717 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236809206338.0 WHERE SecCode = 101252 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-02' WHERE SecCode = 104996 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113490 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140844 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 145731 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VOIM', RkdRIC = 'VOIM.OL', RkdDisplayRIC = 'VOIM.OL' WHERE SecCode = 212058 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-06-24', PermQuoteRetireDate = '2026-07-03', endDate = '2026-06-24' WHERE SecCode = 243344 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-02', SecMapEndDate = '2026-06-22', PermQuoteRetireDate = '2026-07-02', endDate = '2026-06-22' WHERE SecCode = 283464 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 319543 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'NMAD', RkdRIC = 'NMAD.O', RkdDisplayRIC = 'NMAD.OQ' WHERE SecCode = 320972 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-02', SecMapEndDate = '2026-06-22', PermQuoteRetireDate = '2026-07-02', endDate = '2026-06-22' WHERE SecCode = 341321 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 345666 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL WHERE SecCode = 409378 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ELMP.WA^F26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 513474 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NZKMDE0007S0', RkdSEDOL = 'BTHVCS', RkdCUSIP = 'Q5213W14' WHERE SecCode = 552491 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ALUNI', RkdRIC = 'ALUNI.PA', RkdDisplayRIC = 'ALUNI.PA' WHERE SecCode = 555021 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 566782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 593629 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ERAP.WA^F26', RkdIssueStatus = 0.0 WHERE SecCode = 706545 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-03-13', PermQuoteRetireDate = '2026-07-03', endDate = '2026-03-13' WHERE SecCode = 780397 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 797593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 854182 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-02' WHERE SecCode = 863623 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-02' WHERE SecCode = 863867 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 891406 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2011-02-23' WHERE SecCode = 1025098 AND Type_ = 10;
UPDATE data_universe SET Name = 'GUOTAI HAITON SECU VND10000' WHERE SecCode = 1254319 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BXN', DsPrimQtSedol = 'B7Z3MX9' WHERE SecCode = 1522818 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 1602938 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1934499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2008398 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BJC HEAVY INDUSTRI THB1 (LOCAL)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2417295 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BJC HEAVY INDUSTRI THB1 (NVDR)' WHERE SecCode = 2417296 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BRCFQ25' WHERE SecCode = 2528745 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BV5L060' WHERE SecCode = 2594252 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'POLR.SI', RkdDisplayRIC = 'POLR.SI', DsExchQtStartDate = '2014-07-22', startDate = '2014-07-16' WHERE SecCode = 2598711 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ROOTK CO LTD KRW500' WHERE SecCode = 2865468 AND Type_ = 10;
UPDATE data_universe SET Name = 'ADHERIUM LTD NPV DFD 07/07/26(EX-SPLIT)' WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236801075390.0, IsPrimaryQuote = 0.0, ExchCode = 'KNT' WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BV5KZJ5' WHERE SecCode = 3282409 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BSBB2P6' WHERE SecCode = 3317576 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-02' WHERE SecCode = 3371087 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'AQT.WA^F26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BSBB2G7' WHERE SecCode = 3396295 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858705514.0, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'DDG', RkdRIC = 'DDG.HNO', RkdDisplayRIC = 'DDG.HNO', DsExchMnem = 'HNX', RkdIssueStatus = 1.0, RkdExchCode = 'UPC' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3772579 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-01' WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 4036738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4043055 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 4223306 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21776462902.0 WHERE SecCode = 4388174 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 4451253 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '605081.SS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 4494105 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236808501799.0, PermQuoteStatus = 'AC', ExchCode = 'LSE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-15', endDate = NULL WHERE SecCode = 4633023 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VOEPL', QuotePermID = 236809169007.0, ExchCode = 'NSI' WHERE SecCode = 5155289 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsPrimQtSedol = NULL, DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-07-02', PermQuoteRetireDate = '2026-07-03', endDate = '2026-07-02' WHERE SecCode = 5842652 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARTGO HOLDINGS LTD HKD0.1' WHERE SecCode = 5853200 AND Type_ = 10;
UPDATE data_universe SET DsCmpyCode = 214844 WHERE SecCode = 6039875 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236788414637.0 WHERE SecCode = 6043600 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236803707463.0 WHERE SecCode = 6258213 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236793240767.0 WHERE SecCode = 6356130 AND Type_ = 10;
UPDATE data_universe SET Name = 'CROWDSTRIKE HOLDIN DR1250:1 CROWDSTRIKE HOLDIN' WHERE SecCode = 6476475 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 6569470 AND Type_ = 10;
UPDATE data_universe SET Name = 'PRABHA ENERGY LTD INR144 (PPD 96.48 UPD 47.52' WHERE SecCode = 6772975 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y1R6TD14' WHERE SecCode = 6839608 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 6870723 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-07-02', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-05-27', endDate = '2026-07-02' WHERE SecCode = 6880047 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-07-02', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-05-27', endDate = '2026-07-02' WHERE SecCode = 6880048 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6923709 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007PD2', RkdTicker = '6132', RkdSEDOL = 'BTGRRQ', RkdCUSIP = 'Y322TS10', RkdRIC = '6132.HK', RkdDisplayRIC = '6132.HK', RkdCode = 145124.0, RkdIssueID = 1.0, RkdIssueCode = 185687.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6937616 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0, PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = '2026-07-01' WHERE SecCode = 6951895 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-01' WHERE SecCode = 6955124 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955125 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955126 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955127 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955128 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955129 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955130 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955131 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955132 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6955133 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 6955162 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA70137X4030', RkdSEDOL = 'BRSD2G', RkdCUSIP = '70137X40' WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTH25W8' WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11002274 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2011-12-07' WHERE SecCode = 11016720 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA25466C1077', RkdCUSIP = '25466C10', DsPrimQtSedol = 'BSBFLD9', SecMapEndDate = '2026-07-02', endDate = '2026-07-02' WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX59M39' WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTCL713' WHERE SecCode = 11182627 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NRDMF' WHERE SecCode = 11185275 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11196721 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FXHO' WHERE SecCode = 11222087 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11223225 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIRC' WHERE SecCode = 11229331 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11240570 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2023-05-23', startDate = '2023-05-23' WHERE SecCode = 11253247 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG5T40M1045', RkdSEDOL = 'BSBB33', RkdCUSIP = 'G5T40M10' WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11274178 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000174710.0, PriInstrPermID = 232866697735.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '2025-02-28' WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11275764 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-02-28', startDate = '2025-02-28' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-02', PermSecMapEndDate = '2026-07-02' WHERE SecCode = 11277714 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SECZ', Country = 'USA', DsPrimQtSedol = 'BPXZLS1', DsExchMnem = 'NYS', ExchCode = 'NYS' WHERE SecCode = 11277957 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IQMX', DsPrimQtSedol = 'BTCLFZ3', ExchCode = 'NSM', QuoteClass = 'ADR', InstrClass = 'ADR', PermSecMapEndDate = '2026-07-02', endDate = '2026-07-02' WHERE SecCode = 11278832 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-04-21' WHERE SecCode = 11294772 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11295910 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232913236424.0 WHERE SecCode = 11296943 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297024 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297683 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298134 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11298205 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ITG', QuotePermID = 236809208572.0, InstrPermID = 232939465189.0, OrgPermID = 5052142486.0, PriInstrPermID = 232939465189.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'MPS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951808.0, PermOrgIPODate = '2026-07-01', PermSecMapStartDate = '2026-07-01' WHERE SecCode = 11298541 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-07-01' WHERE SecCode = 11298557 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AESP', IsMajorSec = 'Y', QuotePermID = 236809208536.0, InstrPermID = 232913236424.0, OrgPermID = 5096956708.0, PriInstrPermID = 232913236424.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'MPG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-03', PermSecMapStartDate = '2026-07-01' WHERE SecCode = 11298594 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OSPRU', QuotePermID = 236808850113.0, InstrPermID = 232941776992.0, OrgPermID = 6000165942.0, PriTrdQuotePermID = 236808850113.0, PriValQuotePermID = 25727016275.0, PriInstrPermID = 232941776992.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-07-01', PermSecMapStartDate = '2026-06-30', startDate = '2026-06-30' WHERE SecCode = 11298597 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-07-01' WHERE SecCode = 11298598 AND Type_ = 1;
