Query editor
with deposits as(select 'deposit' as ETF_Flow,date_trunc('day',a.block_time) as day,a.value as Amount_BTC,b.issuer,b.address,b.etf_tickerfrom bitcoin.outputs ainner join query_3378085 bon a.address = b.addresswhere a.value > 0and a.block_time >= NOW()- interval '1' day),withdrawn as (select 'Withdrawn' as ETF_Flow,date_trunc('day',a.block_time) as day,-1*a.value as Amount_BTC,b.issuer,b.address,b.etf_tickerfrom bitcoin.inputs ainner join query_3378085 bon a.address = b.addresswhere a.value > 0and a.block_time > NOW()- interval '1' day),etf_issuer as (select distinct issuer,etf_tickerfrom query_3378085),dates as (select distinct date_trunc('day',block_time) as dayfrom bitcoin.outputswhere block_time > NOW()- interval '1' day),filler as (select a.day,b.issuer,b.etf_ticker,null as ETF_Flow,0 as Amount_BTCfrom dates ainner join etf_issuer bon 1=1),deposit_agg as(select day,etf_ticker,issuer,sum(Amount_BTC) as Amount_BTCfrom depositsgroup by day,etf_ticker,issuerorder by day),withdrawn_agg as (select day,etf_ticker,issuer,