Fin. Multiples Of Russian Companies (MOEX)

Financial multiples and its stocks prices of Russian companies (MOEX)

@kaggle.redeugene_rus_stocks_funds

Table List

1 table(63.59 KB)

Rus Stocks Funds

@kaggle.redeugene_rus_stocks_funds.rus_stocks_funds

63.59 KB
411 rows
27 columns

total_issued_ordinary_shares Total Issued Ordinary Shares	n__number_of_shares_available_for_sale Number Of Shares Available For Sale	n__number_of_employees Number Of Employees	n__number_of_shareholders Number Of Shareholders	n__price_profit Price/Profit	n__price_sales Price/Sales	n__price_cash_flow Price/Cash Flow	n__price_book_value Price/Book Value	n__company_value Company Value	n__company_value_ebitda Company Value/EBITDA	n__profit_per_share_total_assets Profit Per Share Total Assets %	n__return_on_equity Return On Equity %	n__return_on_invested_capital Return On Invested Capital %	n__gross_margin Gross Margin %	n__operating_margin Operating Margin %	n__ebitda_margin EBITDA Margin %	n__net_return Net Return%	n__rapid_liquidity Rapid Liquidity	n__current_liquidity_ratio Current Liquidity Ratio	n__inventory_turnover Inventory Turnover	n__asset_turnover Asset Turnover	n__debt_assets Debt/Assets	n__debt_equity Debt/Equity	n__long_term_debt_total_assets Long-term Debt/total Assets	n__average_stock_price Average Stock Price	n__ticker Ticker	n__year Year
22980000000	10760000000	459600	45660	18.86	0.55	1.64	0.31	4938410000000	2.47	1.11	1.66	1.39	45.44	27.88	36.5	2.9	1.5	1.86	4.81	0.38	0.18	0.27	0.15	138.02844	gazp	2014
22980000000	10760000000	462400	45660	3.98	0.52	1.63	0.3	5523840000000	2.5	4.88	7.71	6.19	43.78	28.33	36.94	13.15	1.5	1.88	4.56	0.37	0.2	0.32	0.16	143.49767999999997	gazp	2015
22130000000	9540000000	467400	45660	3.67	0.59	2.32	0.31	5758080000000	3.11	5.6	8.78	7.09	37.16	21.43	31.01	15.95	1.31	1.68	4.95	0.35	0.17	0.25	0.14	142.7926984126984	gazp	2016
22130000000	9540000000	469600	45660	4.04	0.45	2.62	0.25	5633960000000	2.73	4.06	6.29	5.2	40.81	22.67	32.28	11.19	1.04	1.34	5.09	0.36	0.18	0.27	0.13	128.88214285714292	gazp	2017
22130000000	9520000000	466100	45660	2.32	0.41	2.21	0.25	6844990000000	2.29	7.43	11.68	9.51	50.27	28.39	36.27	17.71	1.34	1.7	4.86	0.42	0.18	0.28	0.16	147.41614173228356	gazp	2018
23640000000	11740000000	473800	45660	4.8	0.75	3.56	0.43	9661570000000	4.94	5.59	8.78	7.08	38.42	16.18	25.52	15.7	1.14	1.51	5.08	0.36	0.19	0.28	0.15	208.33146825396815	gazp	2019
23640000000				7.38	0.6	2.83	0.3	8727500000000	5.25	2.49	3.96	3.12	33.71	11.63	23.1	-6.68	1.24	1.62	5.61	0.32	0.21	0.32	0.18	217.1078333333334	gazp	Q1 20
23640000000				11.23	0.71	4.11	0.33	9000700000000	7.06	1.82	2.92	2.3	23.57	-4.5	12.46	12.82	1.07	1.48	4.82	0.3	0.21	0.32	0.18	192.3531147540984	gazp	Q2 20
23640000000					0.64	3.25	0.29	9240400000000	7.96	-0.29	-0.46	-0.36	29.3	3.45	17.59	-17.97	0.93	1.4	4.32	0.28	0.23	0.36	0.2	185.0433846153846	gazp	Q3 20
23640000000				37.75	0.8	2.79	0.36	9847880000000	7.68	0.59	0.95	0.74	34.58	14.16	24.25	17.43	1.07	1.44	4.54	0.28	0.22	0.36	0.2	180.91796875000003	gazp	Q4 20


CREATE TABLE rus_stocks_funds (
  "total_issued_ordinary_shares" DOUBLE,
  "n__number_of_shares_available_for_sale" DOUBLE,
  "n__number_of_employees" DOUBLE,
  "n__number_of_shareholders" DOUBLE,
  "n__price_profit" DOUBLE,
  "n__price_sales" DOUBLE,
  "n__price_cash_flow" DOUBLE,
  "n__price_book_value" DOUBLE,
  "n__company_value" DOUBLE,
  "n__company_value_ebitda" DOUBLE,
  "n__profit_per_share_total_assets" DOUBLE,
  "n__return_on_equity" DOUBLE,
  "n__return_on_invested_capital" DOUBLE,
  "n__gross_margin" DOUBLE,
  "n__operating_margin" DOUBLE,
  "n__ebitda_margin" DOUBLE,
  "n__net_return" DOUBLE,
  "n__rapid_liquidity" DOUBLE,
  "n__current_liquidity_ratio" DOUBLE,
  "n__inventory_turnover" DOUBLE,
  "n__asset_turnover" DOUBLE,
  "n__debt_assets" DOUBLE,
  "n__debt_equity" DOUBLE,
  "n__long_term_debt_total_assets" DOUBLE,
  "n__average_stock_price" DOUBLE,
  "n__ticker" VARCHAR,
  "n__year" VARCHAR
);