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 b.address = a.addresswhere b.track_inflow = trueand a.value > 0and a.block_time > date('2019-01-01')and b.etf_ticker = 'GBTC'),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 b.address = a.addresswhere b.track_outflow = trueand a.value > 0and a.block_time > date('2019-01-01')and b.etf_ticker = 'GBTC'),etf_issuer as (select distinct issuer,etf_tickerfrom query_3378085),filler as (select a.block_time,b.issuer,b.etf_ticker,null as ETF_Flow,0 as Amount_BTCfrom(unnest(sequence(date('2019-01-01'), date(NOW()), interval '1' day)) AS s(block_time)) ainner join etf_issuer bon 1=1where b.etf_ticker = 'GBTC'),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,