
INSERT INTO `fe_asset_class` (`id`, `name`, `description`) VALUES
(1, 'Equity', 'An equity market is a market in which shares of companies are issued and traded, either through exchanges or over-the-counter markets. Also known as the stock market, it is one of the most vital areas of a market economy. It gives companies access to capital to grow their business, and investors a piece of ownership in a company with the potential to realize gains in their investment based on the company s future performance.'),
(2, 'Bonds', 'The bond market (also debt market or credit market) is a financial market where participants can issue new debt, known as the primary market, or buy and sell debt securities, known as the secondary market. This is usually in the form of bonds, but it may include notes, bills, and so for public and private expenditures. The bond market has largely been dominated by the United States, which accounts for about 39% of the market. As of 2017, the size of the worldwide bond market (total debt outstanding) is estimated at $100.13 trillion, according to Securities Industry and Financial Markets Association');

INSERT INTO `fe_indicator` (`id`, `name`) VALUES
(1, 'Cash Position'),
(2, 'Valorisation'),
(3, 'P&L'),
(4, 'Sharp Ratio'),
(5, 'VaR95'),
(6, 'VaR99'),
(7, 'Beta'),
(8, 'Max DD'),
(9, 'Volatility'),
(10, 'Ranking');

INSERT INTO `fe_market` (`id`, `name`, `ticker`, `description`) VALUES
(1, 'CAC40', '^FCHI', 'Le CAC 40 est le principal indice boursier de la Bourse de Paris.  \r\nCréé avec 1 000 points de base au 31 décembre 1987 par la Compagnie des agents de change, l indice CAC 40 (CAC signifiant Cotation Assistée en Continu) est déterminé à partir des cours de quarante actions cotées en continu sur le premier marché parmi les cent sociétés dont les échanges sont les plus abondants sur Euronext Paris, \r\nqui fait partie d Euronext, la première bourse européenne. Ces sociétés, représentatives des différentes branches d activités, reflètent en principe la tendance globale de\r\n l économie des grandes entreprises françaises et leur liste est revue régulièrement pour maintenir cette représentativité'),
(2, 'DAX', '^GDAXI', 'Le DAX ou Deutscher AktienindeX est le principal indice boursier allemand. \r\n Sa valeur est fondée sur le cours des actions des 30 plus importantes entreprises cotées à la Bourse de Francfort (Francfort-sur-le-Main).\r\n Le cours des actions est tiré du système de trading électronique Xetra. Selon Deutsche Börse, \r\n opérateur de Xetra, le DAX mesure la performance des trente plus importantes sociétés allemandes du Prime Standard en matière de volume \r\n de transactions et de capitalisation boursière');


INSERT INTO `fe_asset` (`id`, `name`, `ticker`, `sector`, `market_id`, `asset_class_id`) VALUES
(1, 'Air Liquide', 'AI.PA', 'Basic Materials', 1, 1),
(2, 'Airbus', 'AIR.PA', 'Industrials', 1, 1),
(3, 'Alstom', 'ALO.PA', 'Industrials', 1, 1),
(4, 'Arcelor Mittal', 'MT.AS', 'Basic Materials', 1, 1),
(5, 'Atos', 'ATO.PA', 'Technology', 1, 1),
(6, 'Axa', 'CS.PA', 'Financial Services', 1, 1),
(7, 'Bnp Paribas', 'BNP.PA', 'Financial Services', 1, 1),
(8, 'Bouygues', 'EN.PA', 'Industrials', 1, 1),
(9, 'CapGemini', 'CAP.PA', 'Technology', 1, 1),
(10, 'Carrefour', 'CA.PA', 'Consumer Defensive', 1, 1),
(11, 'Credit Agricole', 'ACA.PA', 'Financial Services', 1, 1),
(12, 'Danone', 'BN.PA', 'Consumer Defensive', 1, 1),
(13, 'Dassault Systemes', 'DSY.PA', 'Technology', 1, 1),
(14, 'Engie', 'ENGI.PA', 'Utilities', 1, 1),
(15, 'Essilor', 'EI.PA', 'Healthcare', 1, 1),
(16, 'Hermes', 'RMS.PA', 'Consumer Cyclical', 1, 1),
(17, 'Kering', 'KER.PA', 'Consumer Cyclical', 1, 1),
(18, 'L Oréal', 'OR.PA', 'Consumer Defensive', 1, 1),
(19, 'Legrand SA', 'LR.PA', 'Industrials', 1, 1),
(20, 'LVMH', 'MC.PA', 'Consumer Cyclical', 1, 1),
(21, 'Michelin', 'ML.PA', 'Industrials', 1, 1),
(22, 'Orange', 'ORA.PA', 'Communication Services', 1, 1),
(23, 'Pernod Ricard', 'RI.PA', 'Consumer Defensive', 1, 1),
(24, 'Publicis', 'PUB.PA', 'Communication Services', 1, 1),
(25, 'Renault', 'RNO.PA', 'Consumer Cyclical', 1, 1),
(26, 'Safran', 'SAF.PA', 'Industrials', 1, 1),
(27, 'Saint Gobain', 'SGO.PA', 'Industrials', 1, 1),
(28, 'Sanofi', 'SAN.PA', 'Healthcare', 1, 1),
(29, 'Schneider Electric', 'SU.PA', 'Industrials', 1, 1),
(30, 'Societe Generale', 'GLE.PA', 'Financial Services', 1, 1),
(31, 'Stellantis', 'STLA.PA', 'Consumer Cyclical', 1, 1),
(32, 'Stmicroelectronics', 'STM.PA', 'Technology', 1, 1),
(33, 'Teleperformance', 'TEP.PA', 'Industrials', 1, 1),
(34, 'Thales', 'HO.PA', 'Industrials', 1, 1),
(35, 'Total', 'FP.PA', 'Energy', 1, 1),
(36, 'Unibail Rodamco Wes', 'URW.AS', 'Real Estate', 1, 1),
(37, 'Veolia Environ.', 'VIE.PA', 'Industrials', 1, 1),
(38, 'Vinci', 'DG.PA', 'Industrials', 1, 1),
(39, 'Vivendi', 'VIV.PA', 'Communication Services', 1, 1),
(40, 'Worldline', 'WLN.PA', 'Technology', 1, 1),
(41, 'Beiersdorf', 'BEI.DE', 'Consumer Defensive', 2, 1),
(42, 'Fresenius Medical Care', 'FME.DE', 'Healthcare', 2, 1),
(43, 'Henkel & Co.', 'HEN3.DE', 'Consumer Defensive', 2, 1),
(44, 'MERCK', 'MRK.DE', 'Healthcare', 2, 1),
(45, 'HeidelbergCement', 'HEI.DE', 'Basic Materials', 2, 1),
(46, 'Linde', 'LIN.DE', 'Basic Materials', 2, 1),
(47, 'Allianz', 'ALV.DE', 'Financial Services', 2, 1),
(48, 'Bayer', 'BAYN.DE', 'Healthcare', 2, 1),
(49, 'Volkswagen', 'VOW3.DE', 'Consumer Cyclical', 2, 1),
(50, 'MUV2', 'MUV2.DE', 'Financial Services', 2, 1),
(51, 'Daimler', 'DAI.DE', 'Consumer Cyclical', 2, 1),
(52, 'SAP', 'SAP.DE', 'Technology', 2, 1),
(53, 'Fresenius', 'FRE.DE', 'Healthcare', 2, 1),
(54, 'Infineon', 'IFX.DE', 'Technology', 2, 1),
(55, 'Deutsche Börse', 'DB1.DE', 'Financial Services', 2, 1),
(56, 'E.ON', 'EOAN.DE', 'Utilities', 2, 1),
(57, 'Deutsche Telekom', 'DTE.DE', 'Communication Services', 2, 1),
(58, 'Vonovia', 'VNA.DE', 'Real Estate', 2, 1),
(59, 'RWE', 'RWE.DE', 'Utilities', 2, 1),
(60, 'Adidas', 'ADS.DE', 'Consumer Cyclical', 2, 1),
(61, 'Siemens', 'SIE.DE', 'Industrials', 2, 1),
(62, 'Continental', 'CON.DE', 'Consumer Cyclical', 2, 1),
(63, 'Deutsche Post', 'DPW.DE', 'Industrials', 2, 1),
(64, 'Deutsche Wohnen', 'DWNI.DE', 'Real Estate', 2, 1),
(65, 'BASF', 'BAS.DE', 'Basic Materials', 2, 1),
(66, 'Deutsche Bank', 'DBK.DE', 'Financial Services', 2, 1),
(67, 'BMW', 'BMW.DE', 'Consumer Cyclical', 2, 1),
(68, 'Delivery Hero', 'DHER.DE', 'Consumer Cyclical', 2, 1),
(69, 'Covestro', '1COV.DE', 'Basic Materials', 2, 1),
(70, 'MULTI-UNITS LUXEMBOURG - Lyxor Euro Government Bond (DR) UCITS ETF - Acc', 'MTX.DE', 'Other', 2, 1);