pinktest_usa_2417|MWTCY|Short Name|pe_ratio|shareholder_yield_ttm|enterprise_value|cash_on_hand|average_volume_30|one_year_return|price|ps_ratio|market_beta_12_month|total_deposits|dividend_yield|average_shares_outs_diluted|price_next_month|price_second_month pinktest_usa_2417|MWTCY|Long Name|Manila Water Co Inc PE Ratio|Manila Water Co Inc Shareholder Yield (TTM)|Manila Water Co Inc Enterprise Value (USD)|Manila Water Co Inc Cash and Short Term Investments (Quarterly) (USD)|Manila Water Co Inc 30-Day Average Daily Volume|Manila Water Co Inc 1 Year Price Returns (Daily)|Manila Water Co Inc Price (USD)|Manila Water Co Inc PS Ratio|Manila Water Co Inc Beta (1Y)|Manila Water Co Inc Total Deposits (Quarterly) (USD)|Manila Water Co Inc Dividend Yield|Manila Water Co Inc Average Diluted Shares Outstanding (Quarterly)|| pinktest_usa_2417|MWTCY|Unit|figure_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric|figure_money_USD_price|figure_USD_metric|figure_USD_beta|mil_figure_money_USD_metric|percent_USD_metric|mil_figure_USD_metric|| pinktest_usa_2417|MWTCY|200903||||||||||||96.9152|| pinktest_usa_2417|MWTCY|200906||||||||||||96.2178|| pinktest_usa_2417|MWTCY|200909||||||||||||99.3229|| pinktest_usa_2417|MWTCY|200912||||167.1215||||||||97.2271|| pinktest_usa_2417|MWTCY|201003||||167.5357||||||||101.7411|| pinktest_usa_2417|MWTCY|201006||||130.5357||||||||98.2994|| pinktest_usa_2417|MWTCY|201009||||117.7866||||||||81.2363|| pinktest_usa_2417|MWTCY|201012||||90.6273||||||||97.3039|| pinktest_usa_2417|MWTCY|201103||||147.7129||||||||81.3131|| pinktest_usa_2417|MWTCY|201106||||361.0223||||||||81.3131|| pinktest_usa_2417|MWTCY|201109||||363.1913||||||||95.9218|| pinktest_usa_2417|MWTCY|201112||||134.4226||||||||97.4856|| pinktest_usa_2417|MWTCY|||||149.8701||||||||81.1299|8|8 pinktest_usa_2417|MWTCY|201206|13.3299||1744.9928|171.0915|||14|4.267||||97.4956|15.75|15.75 pinktest_usa_2417|MWTCY|201209|15.2425||1996.133|138.8763|||16.3|4.9526||||79.6242|16.8|16.8 pinktest_usa_2417|MWTCY|201212|16.4017||2381.9971|135.4013|2299.7333||19.78|5.5203||||96.2178|19.8|19.8 pinktest_usa_2417|MWTCY|201303||||154.7632|2414.7667||23.1|6.1844||||98.768|24.72|24.72 pinktest_usa_2417|MWTCY|201306||||112.3444|2210.3667|22.9091|19.23|4.4549|2.6039|||98.6048|18.07|18.07 pinktest_usa_2417|MWTCY|201309||||238.4335|2155.9667|0.1227|16.59|4.5156|0.7104|||98.7114|16.29|16.29 pinktest_usa_2417|MWTCY|201312||||154.874||||3.7056|1.1752|||96.6121|12.93|12.93 pinktest_usa_2417|MWTCY|201403|9.7694||1755.118|173.2023|505.6|-41.9048|13.42|3.7702|0.2813|||104.0965|13.42|13.42 pinktest_usa_2417|MWTCY|201406||||169.4254|299.3|-38.2907|14.73|4.3149|-0.9347|||103.1107|15.14|15.14 pinktest_usa_2417|MWTCY|201409||||181.927|302.5667|-0.6028|15.88|4.8167|-0.7462|||102.9956|16.07|16.07 pinktest_usa_2417|MWTCY|201412||||144.0855||||4.5112|-0.0194|||96.6121|18|18 pinktest_usa_2417|MWTCY|201503|12.2457|3.7181|1968.4995|140.6139|283.9667|17.3621|15.75|4.5663|0.9847||3.1938|104.2872|15.4|15.4 pinktest_usa_2417|MWTCY|201506||||132.3143||||4.3107|1.0757|||102.7192|13.13|13.13 pinktest_usa_2417|MWTCY|201509||||158.9622|230.2333|-32.5627|10.21|2.9353|1.555||7.0534|102.8841|| pinktest_usa_2417|MWTCY|201512||||145.9726||||2.9565|1.1299|||98.1467|| pinktest_usa_2417|MWTCY|201603||||256.7807||||2.8541|0.441|||88.4191|| pinktest_usa_2417|MWTCY|201606||||154.0523||||2.8393|0.5039|||97.4709|14.36|14.36 pinktest_usa_2417|MWTCY|201609|11.6406||2003.5978|154.7214|226.9333|53.2811|15.65|4.352|-0.4085||2.8207|111.9032|16.27|16.27 pinktest_usa_2417|MWTCY|201612||||82.0052|234.4667|31.2439|13.4|3.6607|-0.6663||3.2751|82.1467|15.18|15.18 pinktest_usa_2417|MWTCY|201703|14.5173|2.7074|2051.1917|79.4961|194.0333|56.2194|15.77|4.3082|-1.9606||2.6679|82.1467|15.91|15.91 pinktest_usa_2417|MWTCY|201706||||127.5429||||4.2456|-2.1523|||98.3531|15.95|15.95 pinktest_usa_2417|MWTCY|201709||||250.3148|235.3333|-1.4687|15.43|3.847|-0.1043||2.7578|76.0293|14.45|14.45 pinktest_usa_2417|MWTCY|201712|12.5054||1934.4023|181.2267|246.5333|4.1791|13.96|3.4805|-0.2196||2.9906|82.1578|13.55|13.55 pinktest_usa_2417|MWTCY|201803|9.8438|-2.8245|1929.9675|142.9869|252.6667|-16.8361|13.09|3.2452|-0.2169||3.1464|100.8761|13.09|13.09 pinktest_usa_2417|MWTCY|201806||||148.081|265.3333|-20.6452|12.3|3.149|-0.1397||3.3485|98.1668|10.7|10.7 pinktest_usa_2417|MWTCY|201809||||216.3985|335|-30.849|10.67|2.9075|-0.4304||3.86|97.9499|12.02|12.02 pinktest_usa_2417|MWTCY|201812|9.9953|0.0377|1964.7408|178.7499|311.1|-14.0401|12|3.2699|-0.6552||3.3885|98.5936|12|12 pinktest_usa_2417|MWTCY|201903|9.9166|0.8908|2060.9944|140.8051|6.6667|-4.8892|12.45|3.5083|-0.479||3.3497|102.7668|12.45|12.45 pinktest_usa_2417|MWTCY|201906|10.7436|2.6687|2065.4999|123.3449|0|1.2195|12.45|3.5024|-0.3435||3.3497|98.1582|12.45|12.45 pinktest_usa_2417|MWTCY|201909|10.7699|2.1936|2083.6297|114.3678|0|13.4021|12.1|3.3422|-0.2416||3.4466|99.3464|12.1|12.1 pinktest_usa_2417|MWTCY|201912|3.2123|2.0837|1368.5801|178.494|23.9333|-59.1667|3.7|0.986|-0.1594||8.9486|82.5936|4.9|4.9 pinktest_usa_2417|MWTCY|202003|5.7818|-0.6615|1467.0119|253.4756|40.1667|-50.6827|6.14|1.5137|-1.297||7.1414|98.3462|6.14|6.14 pinktest_usa_2417|MWTCY|202006|5.6593|-9.2261|1550.0854|358.6296|16.4333|-50.5221|6.16|1.4447|-1.1932||7.1182|82.5936|6.16|6.16 pinktest_usa_2417|MWTCY|202009|7.6916||1731.4641||13.3333|-42.1488|7|1.5548|-1.1099||6.264||7|7