Query editor
select date_trunc('day', minute) as day,avg(price) as pricefrom prices.usdwhere contract_address is nulland minute >= now() - interval '5' yearand symbol = 'BTC'group by 1
Query editor
1select date_trunc('day', minute) as day,2avg(price) as price3from prices.usd4where contract_address is null5and minute >= now() - interval '5' year6and symbol = 'BTC'7group by 18