Query editor
select date_trunc('day', minute) as block_date,symbol,avg(price) as pricefrom prices.usdwhere symbol = 'WETH'and blockchain = 'ethereum'and minute >= date('2024-01-01')group by 1,2order by 1
Query editor
1select date_trunc('day', minute) as block_date,2symbol,3avg(price) as price4from prices.usd5where symbol = 'WETH'6and blockchain = 'ethereum'7and minute >= date('2024-01-01')8group by 1,29order by 1