Query editor
WITH BTC AS(selectavg(price) as usd_btc,date_trunc('day',minute) as daysfrom prices.usdwhere contract_address is null and symbol='BTC'and minute>=date_trunc('hour',now()-interval '730' day)group by date_trunc('day',minute)order by date_trunc('day',minute)),SOL AS (selectavg(price) as USD_SOL,date_trunc('day',minute) as daysfrom prices.usdwhere contract_address is null and symbol='SOL'and minute>=date_trunc('hour',now()-interval '730' day)group by date_trunc('day',minute)order by date_trunc('day',minute)),ETH AS (selectavg(price) as USD_ETH,date_trunc('day',minute) as daysfrom prices.usdwhere contract_address is null and symbol='ETH'and minute>=date_trunc('hour',now()-interval '730' day)group by date_trunc('day',minute)order by date_trunc('day',minute))SELECT A.DAYS,A.USD_BTC,B.USD_SOL,C.USD_ETHFROM BTC ALEFT JOIN SOL B ON A.DAYS = B.DAYSLEFT JOIN ETH C ON A.DAYS = C.DAYSORDER BY A.DAYS