INSERT INTO data_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 (93874, 1, 'FLA.V', NULL, 'CA30515P1099', NULL, NULL, NULL, '30515P10', 'FLAh.V^J16', 'FLAh.V^J16', 'FAIRMILE GOLDTECH INC COM', 'CA', 'CAN', 231618, 174087, 138859, 'Y', 'D', '2635295', 'EQ', 'TSX', 'CA', 'CAD', 37711.0, 1.0, 49779.0, 'C', 0.0, 1.0, 'OSR', 'NEX', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 55838820831.0, 8590188731.0, 4296065967.0, NULL, 55838820831.0, 8590188731.0, 1.0, 1.0, 'DC', 'DC', 'NEX', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951922.0, '2016-10-27', '1990-05-01', '2000-09-19', '2079-06-06', '2016-10-28', NULL, '1753-01-01', '2016-10-28', '1753-01-01', '2016-10-27');
INSERT INTO data_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 (94434, 1, '37943520', NULL, 'CA3794352094', 'GII.UN', 'GII.UN', 'B06J1J', '37943520', 'GII_u.TO^A17', 'GII_u.TO', 'GLOBAL DIVRSFD INVT GR INCM UT 2005-1 FXRS', 'CA', 'CAN', 56348, 39815, 42652, 'Y', 'D', 'B06J1J6', 'EQ', 'TSE', 'CA', 'CAD', 58809.0, 1.0, 76098.0, 'C', 0.0, 1.0, 'OSR', 'TSE', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 55838823179.0, 8590017750.0, 4297115896.0, NULL, 55838823179.0, 8590017750.0, 1.0, 1.0, 'DC', 'DC', 'TOR', 'UNT', 'UNT', 'CINV', 'CAN', 'CAN', 4294951307.0, '2017-01-03', '2005-03-11', '2005-03-11', '2079-06-06', '2017-01-03', NULL, '2005-03-12', '2017-01-03', '2005-03-11', '2017-01-03');
INSERT INTO data_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 (271059, 1, 'PTAP.V', NULL, 'CA88688R1047', NULL, NULL, 'BG4TSZ', '88688R10', 'TILT.NLB^K25', 'TILT.NLB', 'SANTE VERITAS HLDGS INC COM', 'CA', 'CAN', 68636, 46387, 41642, 'Y', 'D', 'BG4TSZ5', 'EQ', 'NLB', 'CA', 'CAD', 57466.0, 1.0, 73992.0, 'C', 0.0, 1.0, 'OSR', 'NLB', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 21560711247.0, 8590022775.0, 5063768015.0, NULL, 21560711247.0, 8590022775.0, 1.0, 1.0, 'DC', 'AC', 'NLB', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951266.0, '2025-11-19', '2007-02-13', '2007-02-09', '2079-06-06', '2025-11-19', '2018-12-06', '2021-08-17', '2025-11-19', '2007-02-09', '2025-11-19');
INSERT INTO data_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 (4043176, 10, '@GOREG1', NULL, 'DE000A3EX3G0', 'GAG0', 'GAG0', 'BPBKQ0', 'D3R2WF10', 'GAG0k.MU', 'GAG0k.MU', 'GORE GERMAN OFFICE NPV (POST SPLIT)', 'DE', 'DEU', 321404, 231330, 181659, 'Y', 'A', 'BPBKQ05', 'EQ', 'MUN', 'DE', 'EUR', 130786.0, 1.0, 165896.0, 'C', 1.0, 1.0, 'OSR', 'MNC', 'DEU', NULL, 'EQU', NULL, NULL, 'IND', 21724941674.0, 21724928362.0, 5072791967.0, NULL, 21724941674.0, 21724928362.0, 1.0, 1.0, 'AC', 'AC', 'MUN', 'ORD', 'ORD', 'COM', 'DEU', 'DEU', 4294951328.0, NULL, '2019-12-13', '2019-12-13', '2079-06-06', NULL, '2020-07-23', '2019-12-13', NULL, '2019-12-13', NULL);
INSERT INTO data_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 (6558285, 10, '@ZIJIN16', NULL, NULL, NULL, 'ZIJIN13', NULL, NULL, NULL, NULL, 'EURONEXT DEV EUROPE SMID CAP(TRN', 'TH', 'NLD', 389525, 269187, 34991, 'N', 'A', 'BSSDPV2', 'EQ', 'BKK', 'TH', 'THB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236799028706.0, 232908858137.0, 4295892803.0, NULL, 236799028706.0, 8590931186.0, 1.0, 0.0, 'AC', 'AC', 'SET', 'DRC', 'DRC', 'COM', 'THA', 'THA', 4294951368.0, NULL, '2025-11-19', '2025-11-19', '2079-06-06', NULL, '1989-12-15', '2025-11-18', NULL, '2025-11-18', NULL);
INSERT INTO data_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 (6558286, 10, '@WUXIB15', NULL, NULL, NULL, 'WUXI13', NULL, NULL, NULL, NULL, 'EURONEXT DEV EUROZONE S/CAP', 'TH', 'NLD', 389529, 269186, 34991, 'N', 'A', 'BSSDPW3', 'EQ', 'BKK', 'TH', 'THB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236799035049.0, 232908858136.0, 4295892803.0, NULL, 236799035049.0, 8590931186.0, 1.0, 0.0, 'AC', 'AC', 'SET', 'DRC', 'DRC', 'COM', 'THA', 'THA', 4294951368.0, NULL, '2025-11-19', '2025-11-19', '2079-06-06', NULL, '1989-12-15', '2025-11-18', NULL, '2025-11-18', NULL);
INSERT INTO data_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 (6558287, 10, '@SEMIC21', NULL, NULL, NULL, 'SMIC13', NULL, NULL, NULL, NULL, 'EURONEXT DEV EUROZONE S/CAP(TRG', 'TH', 'NLD', 389526, 269188, 34991, 'N', 'A', 'BSSDPY5', 'EQ', 'BKK', 'TH', 'THB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236799028691.0, 232908858138.0, 4295892803.0, NULL, 236799028691.0, 8590931186.0, 1.0, 0.0, 'AC', 'AC', 'SET', 'DRC', 'DRC', 'COM', 'THA', 'THA', 4294951368.0, NULL, '2025-11-19', '2025-11-19', '2079-06-06', NULL, '1989-12-15', '2025-11-18', NULL, '2025-11-18', NULL);
INSERT INTO data_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 (6558294, 10, '@TENNE13', NULL, NULL, NULL, 'TENNIND', NULL, NULL, NULL, NULL, 'NORTHERN TRUST UCI NT WLD SMLLCP LOWCRBN EQIDX', 'IN', 'IRL', 389528, 269185, 210907, 'Y', 'A', 'BVBGZ64', 'EQ', 'NSE', 'IN', 'INR', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236794556013.0, 232895145304.0, 5071523335.0, NULL, 236794556013.0, 232895145304.0, 1.0, 1.0, 'AC', 'AC', 'NSI', 'ORD', 'ORD', 'COM', 'IND', 'IND', 4294951702.0, NULL, '2025-11-19', '2025-11-19', '2079-06-06', NULL, '2025-11-19', '2025-11-10', NULL, '2025-11-10', NULL);
INSERT INTO data_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 (6721483, 10, '@NOSES1', NULL, 'JP3759280005', '527A', '527A', 'BS2LC8', 'J2226510', '527A.T', '527A.T', 'NOSE SHOP INC NPV', 'JP', 'JPN', 396121, 272485, 213328, 'Y', 'A', 'BS2LC88', 'EQ', 'TKS', 'JP', 'JPY', 144478.0, 1.0, 184619.0, 'C', 1.0, 1.0, 'OSR', 'TYO', 'JPN', NULL, 'EQU', NULL, NULL, 'IND', 236804090560.0, 232924860517.0, 5085729151.0, NULL, 236804090560.0, 232924860517.0, 1.0, 1.0, 'AC', 'AC', 'TYO', 'ORD', 'ORD', 'COM', 'JPN', 'JPN', 4294951504.0, NULL, '2026-03-17', '2026-03-17', '2079-06-06', NULL, '2026-03-17', '2026-03-11', NULL, '2026-03-11', NULL);
INSERT INTO data_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 (6769155, 10, '@BCCFU3', NULL, NULL, NULL, '890235', NULL, NULL, NULL, NULL, 'BCC FUBA INDIA LTD', 'IN', 'IND', 395991, 272438, 147045, 'N', 'A', 'BS88VC0', 'EQ', 'BOM', 'IN', 'INR', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236805309049.0, 232923546810.0, 4295872892.0, NULL, 236805309049.0, 8589973511.0, 1.0, 0.0, 'AC', 'AC', 'BSE', 'PARTPAID', 'PARTPAID', 'COM', 'IND', 'IND', 4294951260.0, NULL, '2026-04-07', '2026-04-07', '2079-06-06', NULL, '1990-09-04', '2026-04-02', NULL, '2026-04-02', NULL);
INSERT INTO data_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 (6769158, 10, '@AGAOG1', NULL, 'TREAGVR00014', 'AAGYO.E', 'AAGYO.E', 'BTMQKP', 'M0R24611', 'AAGYO.IS', 'AAGYO.IS', 'AGAOGLU AVRASYA GA TRY1', 'TR', 'TUR', 396122, 272486, 213329, 'Y', 'A', 'BTMQKP3', 'EQ', 'IST', 'TR', 'TRY', 143859.0, 1.0, 183727.0, 'C', 1.0, 1.0, 'OSR', 'IST', 'TUR', NULL, 'EQU', NULL, NULL, '', 236805411740.0, 232914343798.0, 5097102226.0, NULL, 236805411740.0, 232914343798.0, 1.0, 1.0, 'AC', 'AC', 'IST', 'ORD', 'ORD', 'CINV', 'TUR', 'TUR', 4294951329.0, NULL, '2026-04-09', '2026-04-09', '2079-06-06', NULL, '2026-04-09', '2026-04-08', NULL, '2026-04-08', NULL);
INSERT INTO data_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 (6769169, 10, '@SOFTT6', NULL, 'JP3436070001', '550A', '550A', 'BX115P', 'J7596S10', '550A.T', '550A.T', 'SOFTTEX CO LTD NPV', 'JP', 'JPN', 396057, 272471, 213315, 'Y', 'A', 'BX115P2', 'EQ', 'TKS', 'JP', 'JPY', 144446.0, 1.0, 184539.0, 'C', 1.0, 1.0, 'OSR', 'TYO', 'JPN', NULL, 'EQU', NULL, NULL, 'IND', 236804069278.0, 232924319699.0, 5040759784.0, NULL, 236804069278.0, 232924319699.0, 1.0, 1.0, 'AC', 'AC', 'TYO', 'ORD', 'ORD', 'COM', 'JPN', 'JPN', 4294951211.0, NULL, '2026-04-09', '2026-04-09', '2079-06-06', NULL, '2026-04-09', '2026-03-09', NULL, '2026-03-09', NULL);
INSERT INTO data_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 (11189353, 1, 'BHHKF', NULL, 'CA2241301043', 'CFT', NULL, 'BPBPKL', '22413010', 'CFT.CD', 'CFT.CD', 'CRAFTPORT CANNABIS CORP COM', 'CA', 'CAN', 241601, 183444, 140600, 'Y', 'S', 'BPBPKL9', 'EQ', 'CNQ', 'CA', 'CAD', 80378.0, 1.0, 101577.0, 'C', 1.0, 1.0, 'OSR', 'CNQ', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 25727414578.0, 21474958569.0, 5059004656.0, NULL, 21475083703.0, 21474958569.0, 0.0, 1.0, 'DC', 'AC', 'PNK', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 1004365417.0, NULL, '2010-08-12', '2017-11-02', '2079-06-06', '2026-02-27', '2017-11-03', '2017-12-12', '2026-02-27', '2010-08-12', '2026-02-27');
INSERT INTO data_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 (11293937, 1, '13861580', NULL, NULL, NULL, 'CFTR PR A', NULL, NULL, NULL, NULL, 'CANTOR FITZGERALD INCOME TR 9.5 CUM SR A PFD', 'US', 'USA', 396020, 272450, 213294, 'Y', 'A', 'BQMJMG6', 'PREF', 'NYS', 'US', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236805232449.0, 232927526703.0, 5052144435.0, 236805431637.0, 236805232449.0, 232927526703.0, 1.0, 1.0, 'AC', 'AC', 'NYQ', 'CUM', 'CUM', 'CINV', 'USA', 'USA', 4294951322.0, NULL, '2026-04-01', '2026-04-01', '2079-06-06', NULL, NULL, '2026-04-01', NULL, '2026-04-01', NULL);