Query editor
selecttime,sum(price*amount)/sum(amount) as vwap,min(price) as low_price,max(price) as high_pricefrom (selectDATE_TRUNC('minute', evt_block_time) as time,"tokens_sold"/"tokens_bought" as price,"tokens_bought" as amountfrom curvefi."steth_swap_evt_TokenExchange"where sold_id = 0unionselectDATE_TRUNC('minute', evt_block_time) as time,"tokens_bought"/"tokens_sold" as price,"tokens_sold" as amountfrom curvefi."steth_swap_evt_TokenExchange"where sold_id = 1 and "tokens_bought" > 0) price_bothwhere amount > 1 -- getting ghost values w/ amount = 1 [gwei]group by 1order by 1