UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 1925 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 2816 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0, DsSecDelistDate = '2026-01-31', PermQuoteRetireDate = '2026-02-02', endDate = '2026-01-31' WHERE SecCode = 6887 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 7578 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 7675 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 7745 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 8113 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA', IncCntry = 'USA' WHERE SecCode = 9053 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA', IncCntry = 'USA' WHERE SecCode = 9054 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 10911 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA5894981045', RkdCUSIP = '58949810', RkdIssueStatus = 0.0, PrimaryIssueCode = 23301.0, RelType = 2.0 WHERE SecCode = 12845 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 13709 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 14110 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 15770 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 16217 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 16299 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951282.0 WHERE SecCode = 16432 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17392 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17393 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 17399 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 23395 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 25101 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 26418 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 30843 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 34070 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 35364 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 35776 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'TULP' WHERE SecCode = 36165 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 39504 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 39834 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802155837.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-01-28' WHERE SecCode = 42810 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 45229 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MPT' WHERE SecCode = 45558 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 47142 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 47165 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 47959 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 49118 AND Type_ = 1; UPDATE data_universe SET DomCntry = NULL, IncCntry = NULL WHERE SecCode = 52947 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 53371 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 53541 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 56200 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 58684 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'DEU', IncCntry = 'DEU' WHERE SecCode = 63127 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 68153 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68266 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 70740 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 72599 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2017-01-02' WHERE SecCode = 73342 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2017-01-02' WHERE SecCode = 73343 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 75065 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 75783 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 76012 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951474.0 WHERE SecCode = 76215 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 76218 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 77417 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 77938 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'GRIV0RG', QuotePermID = 55838823916.0, ExchCode = 'JKT', PermQuoteRetireDate = '2007-05-02' WHERE SecCode = 80954 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '0009.HK^B26' WHERE SecCode = 81938 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 82232 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 84013 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 91909 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 91910 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 93847 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 94284 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 95957 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OTMC', RkdSEDOL = 'BVYDH6' WHERE SecCode = 98786 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2017-01-02' WHERE SecCode = 99753 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'USA', IncCntry = 'USA' WHERE SecCode = 176083 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 350553 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 21530871393.0, ExchCode = 'CHI' WHERE SecCode = 437391 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 907800 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TEC' WHERE SecCode = 936823 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BRY' WHERE SecCode = 1142412 AND Type_ = 10; UPDATE data_universe SET DomCntry = NULL, IncCntry = NULL WHERE SecCode = 1546589 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2566806 AND Type_ = 10; UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 2585435 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'GATEG.E' WHERE SecCode = 2827902 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 3318040 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'USA', IncCntry = 'USA' WHERE SecCode = 4382210 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 QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 21931099970.0 WHERE SecCode = 5247313 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631799 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631800 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631801 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631802 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631803 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631804 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631805 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631806 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631807 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631808 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631809 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631810 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631811 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631812 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631813 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6631814 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '544686', QuotePermID = 236802292820.0, PriValQuotePermID = 236802292820.0, PriInstrPermID = 232918161875.0, IsPrimaryQuote = 1.0, ExchCode = 'BSE' WHERE SecCode = 6635168 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2026-01-30' WHERE SecCode = 6635170 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236802260864.0 WHERE SecCode = 6635226 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 11009217 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-30' WHERE SecCode = 11015059 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BVYDBG' WHERE SecCode = 11022684 AND Type_ = 1; UPDATE data_universe SET ModelCntry = 'KY', DomCntry = NULL, IncCntry = NULL WHERE SecCode = 11143029 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 11156282 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BVYDBF', RkdCUSIP = '02919L80' WHERE SecCode = 11156315 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 11202192 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 11210203 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802155855.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-01-28' WHERE SecCode = 11233331 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA74449F4078', RkdSEDOL = 'BVMLHZ', RkdCUSIP = '74449F40' WHERE SecCode = 11235543 AND Type_ = 1; UPDATE data_universe SET DomCntry = NULL, IncCntry = NULL WHERE SecCode = 11274609 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 11287206 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'DSEAF' WHERE SecCode = 11288084 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11289253 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232902938593.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11289288 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232905774029.0 WHERE SecCode = 11289357 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-02-02' WHERE SecCode = 11289468 AND Type_ = 1; UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11289847 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802138283.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291137 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802138247.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291142 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802138265.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291143 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802155153.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11291179 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802230181.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11291207 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236802230161.0, PriTrdQuotePermID = 236802230161.0, PriValQuotePermID = 25727037890.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS', startDate = '2025-12-09' WHERE SecCode = 11291254 AND Type_ = 1;