INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (186814, 10, '@CYTOT1', NULL, 'DE000A41YD32', 'T5O', 'T5O', 'BVVJXX', 'D1T4Z914', 'T5Ok.F', 'T5Ok.F', 'BIOXXMED AG NPV (POST SPLIT)', 'DE', 'DEU', 33526, 18478, 16760, 'Y', 'A', 'BVVJXX6', 'EQ', 'XET', 'DE', 'EUR', 57230, 1, 73863, 'C', 1, 1, 'OSR', 'FRA', 'DEU', NULL, 'EQU', NULL, NULL, 'IND', 55836525598, 8589985021, 4295869172, NULL, 55836525598.0, 8589985021.0, 1, 1, 'AC', 'AC', 'FRA', 'ORD', 'ORD', 'COM', 'DEU', 'DEU', 4294951265.0, NULL, '2006-12-12', '2006-12-12', '2079-06-06', NULL, '2007-05-18', '2006-12-13', NULL, '2006-12-12', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (346740, 10, '@NZFAR1', 'NZNZSE0001S7', 'NZNZSE0001S7', 'NZS', 'NZS', 'B2B0RY', 'Q6991N10', 'NZS.NZ^L12', 'NZS.NZ', 'NZ FARMING SYSTEMS NPV', 'NZ', 'NZL', 148041, 120430, 97063, 'Y', 'D', 'B2B0RY5', 'EQ', 'NZE', 'NZ', 'NZD', 67241, 1, 85239, 'C', 0, 1, 'OSR', 'NZE', 'NZL', NULL, 'EQU', NULL, NULL, 'IND', 55838842692, 8589955603, 4295885194, NULL, 55838842692.0, 8589955603.0, 1, 1, 'DC', 'DC', 'NZC', 'FULLPAID', 'FULLPAID', 'COM', 'NZL', 'NZL', 4294951446.0, '2012-12-06', '2007-12-18', '2007-12-18', '2012-12-06', '2012-12-06', NULL, '2007-12-17', '2012-12-10', '2007-12-17', '2012-12-06');
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (3110564, 10, '@CLERH1', NULL, 'ES0105121000', 'CLR', 'CLR', 'BZ5ZS8', 'E3074P10', 'CLRE.MC', 'CLRE.MC', 'CLERHP ESTRUCTURAS EUR0.04', 'ES', 'ESP', 288588, 213853, 167768, 'Y', 'A', 'BZ5ZS88', 'EQ', 'MAD', 'ES', 'EUR', 107435, 1, 134861, 'C', 1, 1, 'OSR', 'MCE', 'ESP', NULL, 'EQU', NULL, NULL, 'IND', 21583860660, 21583858457, 5050649452, NULL, 21583860660.0, 21583858457.0, 1, 1, 'AC', 'AC', 'MCE', 'ORD', 'ORD', 'COM', 'ESP', 'ESP', 4294951812.0, NULL, '2016-03-10', '2016-03-10', '2079-06-06', NULL, '2016-03-10', '2016-03-09', NULL, '2016-03-09', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (4958003, 10, '@FIRST1122', NULL, 'GB00BNR45554', '1SN', '1SN', 'BNR455', 'G3488D10', '1SN.L', '1SN.L', 'FIRST TIN PLC ORD GBP0.001', 'GB', 'GBR', 353816, 248495, 193169, 'Y', 'A', 'BNR4555', 'EQ', 'LON', 'GB', 'GBP', 132888, 1, 168742, 'C', 1, 1, 'OSR', 'LON', 'GBR', NULL, 'EQU', NULL, NULL, 'IND', 21885461948, 21885453573, 5081470234, NULL, 21885461948.0, 21885453573.0, 1, 1, 'AC', 'AC', 'LSE', 'ORD', 'ORD', 'COM', 'GBR', 'GBR', 4294951896.0, NULL, '2022-04-07', '2022-04-07', '2079-06-06', NULL, '2022-04-08', '2022-04-07', NULL, '2022-04-07', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (5496146, 10, '@JAMES42', NULL, 'AU0000433351', 'BKB', 'BKB', 'BV4G79', 'Q5062U15', 'BKB.AX', 'BKB.AX', 'BLACK BEAR MINERAL NPV', 'AU', 'AUS', 366762, 255993, 198703, 'Y', 'A', 'BV4G798', 'EQ', 'ASX', 'AU', 'AUD', 137587, 1, 174907, 'C', 1, 1, 'OSR', 'ASX', 'AUS', NULL, 'EQU', NULL, NULL, 'IND', 236778559474, 232813180211, 5086687266, NULL, 236778559474.0, 232813180211.0, 1, 1, 'AC', 'AC', 'ASX', 'FULLPAID', 'FULLPAID', 'COM', 'AUS', 'AUS', 4294951901.0, NULL, '2023-09-12', '2023-09-12', '2079-06-06', NULL, '2023-09-12', '2023-07-31', NULL, '2023-07-31', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (5859825, 10, '@TSGIT1', NULL, 'IL0012094772', 'TSG', 'TSG', 'BSWT6L', 'M8824V13', 'TSG.TA', 'TSG.TA', 'TSG IT ADVANCED NPV', 'IL', 'ISR', 374754, 260462, 202292, 'Y', 'A', 'BSWT6L3', 'EQ', 'TAE', 'IL', 'ILS', 139970, 1, 178391, 'C', 1, 1, 'OSR', 'TLV', 'ISR', NULL, 'EQU', NULL, NULL, 'IND', 236784957879, 232852373294, 5049099331, NULL, 236784957879.0, 232852373294.0, 1, 1, 'AC', 'AC', 'TLV', 'ORD', 'ORD', 'COM', 'ISR', 'ISR', 4294951211.0, NULL, '2024-08-02', '2024-08-05', '2079-06-06', NULL, '2024-08-04', '2024-08-01', NULL, '2024-08-01', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6441608, 10, '@STLNE1', NULL, 'INE1VXE01018', 'STLNETWORK', 'STLNETWORK', 'BTJSJ4', 'Y8T9PW10', 'STLW.NS', 'STLW.NS', 'STL NETWORKS LIMIT INR2', 'IN', 'IND', 386141, 267276, 209597, 'Y', 'A', 'BTJSJ44', 'EQ', 'NSE', 'IN', 'INR', 143950, 1, 183855, 'C', 1, 1, 'OSR', 'NSE', 'IND', NULL, 'EQU', NULL, NULL, '', 236795183032, 232898804728, 5086565891, NULL, 236795183032.0, 232898804728.0, 1, 1, 'AC', 'AC', 'NSI', 'ORD', 'ORD', 'COM', 'IND', 'IND', 4294951211.0, NULL, '2025-09-04', '2025-09-04', '2079-06-06', NULL, '2025-09-04', '2025-09-02', NULL, '2025-09-02', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (10914011, 1, '88514910', NULL, 'CA8851491040', 'THX', 'THX', 'B413SZ', '88514910', 'THX.V', 'THX.V', 'THOR EXPLORATIONS LTD NEW COM', 'CA', 'CAN', 59229, 8702, 25998, 'Y', 'A', 'B413SZ6', 'EQ', 'TSX', 'CA', 'CAD', 95267, 1, 120002, 'C', 1, 1, 'OSR', 'CVE', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 55838858681, 8589966631, 4295918443, NULL, 55838858681.0, 8589966631.0, 1, 1, 'AC', 'AC', 'CVE', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951922.0, NULL, '1990-02-07', '2009-09-01', '2079-06-06', NULL, '1981-05-22', '2009-09-01', NULL, '1981-05-22', NULL);