Query editor
with MSTR as(select DATE_PARSE(quotedate, '%m/%d/%Y') as Days, closefrom dune.agarciaut.dataset_mstr_prices_upload),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 '365' day)group by date_trunc('day',minute)order by date_trunc('day',minute))select a.days, a.close, b.usd_btcfrom MSTR a, BTC bwhere a.days = b.days