Ecuador's Stock Market (BVG)

Weekly changes in stocks at the Bolsa de Valores de Guayaquil (BVG)

@kaggle.aleespinosa_mercado_accionario_bvg

Table List

1 table(12.03 KB)

Stats Bvg Latest

@kaggle.aleespinosa_mercado_accionario_bvg.stats_bvg_latest

12.03 KB
684 rows
11 columns

emisores Emisores	valor_nominal Valor Nominal	n__ltimo_precio Último Precio	p_u_veces P/U Veces	p_vl P/VL	capitalizaci_n Capitalización	d_p_yield D/P Yield	presencia_burs_til Presencia Bursátil	n__ndice_de_rotaci_n Índice De Rotación	l_quidez Líquidez	fecha Fecha
Meriza S.A.	1	40	(25.71)	0.84	3200000	0.00%	0.40%	0.0125	Líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Rio Congo Forestal C.A.	1	40	(34.85)	0.83	3600000	0.22%	2.40%	0.058444	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
El Tecal C.A. ELTECA	1	35	(21.45)	0.76	3150000	0.00%	1.20%	0.055	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
La Reserva Forestal (Reforest S.A.)	1	32.73	(27.68)	0.8	2945700	0.00%	1.20%	0.545	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Cerro Verde Forestal (Bigforest S.A.)	1	31.91	(76.86)	0.81	3191000	0.58%	2.40%	0.083	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
La Campiña Forestal (Strongforest S.A.)	1	31.5	(28.98)	0.86	3150000	0.00%	3.60%	0.064	Líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
El Refugio Forestal (Homeforest S.A.)	1	25.68	(28.19)	0.78	3210000	0.00%	2.40%	0.0582	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
El Sendero Forestal (Pathforest)	1	22.05	(31.97)	0.86	2976750	0.00%	1.61%	0.053793	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
La Estancia Forestal (Forestead)	1	21.5	(49.13)	0.96	3225000	0.00%	0.40%	0.0447	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
La Colina Forestal (Hillforest)	1	18	(35.77)	0.89	3600000	0.00%	0.81%	0.034665	No líquida	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE stats_bvg_latest (
  "emisores" VARCHAR,
  "valor_nominal" DOUBLE,
  "n__ltimo_precio" DOUBLE,
  "p_u_veces" VARCHAR,
  "p_vl" DOUBLE,
  "capitalizaci_n" BIGINT,
  "d_p_yield" VARCHAR,
  "presencia_burs_til" VARCHAR,
  "n__ndice_de_rotaci_n" DOUBLE,
  "l_quidez" VARCHAR,
  "fecha" TIMESTAMP
);