Query editor
SELECTDATE_TRUNC('day', minute) AS time,symbol,AVG(price) AS priceFROM prices.usdWHERE symbol = 'ETH'AND contract_address IS NULLGROUP BY 1,2ORDER BY time ASC
Query editor
1SELECT2DATE_TRUNC('day', minute) AS time,3symbol,4AVG(price) AS price5FROM prices.usd6WHERE symbol = 'ETH'7AND contract_address IS NULL8GROUP BY 1,29ORDER BY time ASC