Query editor
with usdc as (select date_trunc('DAY',block_time) as DAY,token_pair,-- project,SUM(amount_usd) AS VOLfrom dex.tradeswhere token_bought_symbol IN ('BTC','WBTC')and token_sold_symbol = 'USDT'and block_time >= date('2023-01-01')GROUP BY 1,2ORDER BY 1,2),btc as (selectavg(price) as usd_btc,date_trunc('day',minute) as dayfrom prices.usdwhere contract_address is null and symbol='BTC'and minute>= date('2023-01-01')group by date_trunc('day',minute)order by date_trunc('day',minute))select a.day,a.vol,b.usd_btc as btcfrom usdc aleft join btc b on a.day = b.dayorder by a.day