UPDATE data_universe SET Name = 'HORIZON BANCORP IND COM' WHERE SecCode = 33942 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 37358 AND Type_ = 10;
UPDATE data_universe SET QuoteClass = 'UNT', InstrClass = 'UNT' WHERE SecCode = 43807 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ILK2', PermIDTicker = 'ILK2', RkdRIC = 'ILK2.SG', RkdDisplayRIC = 'ILK2.SG' WHERE SecCode = 48342 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-03-13', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-13' WHERE SecCode = 57722 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 73154 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 73457 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '036180.KQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-17', SecMapEndDate = '2026-03-16', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 74558 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 22316.0 WHERE SecCode = 74703 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75040 AND Type_ = 10;
UPDATE data_universe SET Name = 'ASPERMONT NPV' WHERE SecCode = 75796 AND Type_ = 10;
UPDATE data_universe SET Name = 'NURTURE WELL INDS INR1 (POST SUBD)' WHERE SecCode = 77682 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951906.0 WHERE SecCode = 78618 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87170 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 87224 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 95349 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 95355 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 95364 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 95365 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-18' WHERE SecCode = 95463 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 96577 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsExchMnem = 'NGO', PriValQuotePermID = 55838787971.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-17', SecMapEndDate = '2026-03-17', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 97224 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-17' WHERE SecCode = 99024 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 22316.0 WHERE SecCode = 99970 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CH1499059983', RkdTicker = 'ROP', PermIDTicker = 'ROP', RkdSEDOL = 'BTMJD1', RkdCUSIP = 'H6929326', RkdRIC = 'ROPC.S', RkdDisplayRIC = 'ROPC.S', DsPrimQtSedol = 'BTMJD19' WHERE SecCode = 100511 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2015-02-06', SecMapEndDate = '2015-05-04' WHERE SecCode = 117552 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1998-03-27' WHERE SecCode = 123563 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475425489.0, ExchCode = 'LSE', PermQuoteRetireDate = '2008-12-04', endDate = '2008-10-31' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248733.0, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836325407.0, ExchCode = 'BER', PermQuoteRetireDate = '2012-08-01' WHERE SecCode = 297213 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 323357 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 346154 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473202.0, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951768.0 WHERE SecCode = 717242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 796671 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 820885 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 855895 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1224601 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3655.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-17', SecMapEndDate = '2026-03-16', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 1298142 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NWF.AX^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2024-09-30', PermQuoteRetireDate = '2026-03-16', PermSecMapEndDate = '2026-03-16', endDate = '2024-09-30' WHERE SecCode = 1599536 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 2378970 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2574384 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2893034 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 2914990 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21568326330.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08', endDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 2955167 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2981415 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21614525595.0, ExchCode = 'TDG' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NKGEN BIOTECH KORE KRW500' WHERE SecCode = 3007952 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'UPLAND RES LTD ORD NPV' WHERE SecCode = 3017876 AND Type_ = 10;
UPDATE data_universe SET Name = 'AI ENERGY ENGINEER HKD0.05' WHERE SecCode = 3283636 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 DsCtryQtStatus = 'A' WHERE SecCode = 3321113 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3378171 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 ISIN = NULL, Name = 'LUMO KODIT OYJ NPV' WHERE SecCode = 3522229 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET Name = 'STERLING GROUP HOL HKD0.01(POST)' WHERE SecCode = 3629679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3773536 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 4362627 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4466617 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4577869 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 4895598 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4921167 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 5018942 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 5779226 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6341743 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6533413 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-10-28', startDate = '2025-10-28' WHERE SecCode = 6572062 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-17', SecMapEndDate = '2026-03-16', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 6643258 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-17', SecMapEndDate = '2026-03-16', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 6683887 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA38065C6009', RkdSEDOL = 'BTMRWN', RkdCUSIP = '38065C60', DsPrimQtSedol = 'BTMRWN8' WHERE SecCode = 10924415 AND Type_ = 1;
UPDATE data_universe SET Name = 'VITAL INFRASTRUCTURE PPTY TR TR UNIT' WHERE SecCode = 10934600 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-03-12', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-03-16', endDate = '2026-03-12' WHERE SecCode = 11005926 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11065308 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-03-13', PermQuoteRetireDate = '2026-03-16', PermSecMapEndDate = '2026-03-16', endDate = '2026-03-13' WHERE SecCode = 11157024 AND Type_ = 1;
UPDATE data_universe SET Name = 'VIVOPOWER PLC SHS' WHERE SecCode = 11166235 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'LYRA.PK', RkdDisplayRIC = 'LYRA.PK', RkdExchCode = 'OTC' WHERE SecCode = 11207449 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.6667 WHERE SecCode = 11225764 AND Type_ = 1;
UPDATE data_universe SET Name = 'FRONTIER NUCLEAR AND MINERALS COM' WHERE SecCode = 11234421 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11240331 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11241417 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MTLC.CD^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-17', endDate = '2026-03-17' WHERE SecCode = 11259308 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SGN.A^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-17', SecMapEndDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 11259688 AND Type_ = 1;
UPDATE data_universe SET Name = 'ZJK INDL CO. LTD. SHS CL A' WHERE SecCode = 11270118 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, ModelCntry = 'KY', DsCtryQtStatus = 'D', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = 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-03-17', SecMapEndDate = '2026-03-16', PermOrgIPODate = NULL, PermSecMapStartDate = NULL, endDate = '2026-03-16' WHERE SecCode = 11271326 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US5901061003', RkdTicker = 'MRLN', RkdSEDOL = 'BTBJF7', RkdCUSIP = '59010610', RkdRIC = 'MRLN.O', RkdDisplayRIC = 'MRLN.OQ', Name = 'MERLIN INC SHS CL A', DsPrimQtSedol = 'BTBJF70' WHERE SecCode = 11272207 AND Type_ = 1;
UPDATE data_universe SET Name = 'WETOUR ROBOTICS LIMITED SHS' WHERE SecCode = 11275372 AND Type_ = 1;
UPDATE data_universe SET Name = 'BRBI BR PARTNERS SA SPONSORED ADR' WHERE SecCode = 11285384 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11290921 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11290981 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11290990 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11290991 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293177 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9831H1011', RkdTicker = 'XCBE', PermIDTicker = 'XCBE', RkdSEDOL = 'BTMRD8', RkdCUSIP = 'G9831H10', RkdRIC = 'XCBE.O', RkdDisplayRIC = 'XCBE.OQ', ModelCntry = 'US', RkdCode = 144238.0, RkdIssueID = 3.0, RkdIssueCode = 184637.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 3.0, RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND', QuotePermID = 236804171410.0, InstrPermID = 232901029194.0, OrgPermID = 5096773352.0, PriTrdQuotePermID = 236804171410.0, PriValQuotePermID = 25727030638.0, PriInstrPermID = 232901029194.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-01-21', PermSecMapStartDate = '2026-03-12', startDate = '2026-01-21' WHERE SecCode = 11293245 AND Type_ = 1;
