Query editor
with Exchange as (select distinct address,exchangefrom query_2613158WHERE EXCHANGE = 'KuCoin'),bin_outflow as (select date_trunc('day', a.block_time) as Day,b.exchange,sum(a.value)*-1 as Amountfrom bitcoin.inputs ainner join exchange bon a.address = b.addressand a.block_time >= date('2020-01-01')group by 1,2order by 1,2),bin_inflow as (select date_trunc('day', a.block_time) as Day,b.exchange,sum(a.value) as Amountfrom bitcoin.outputs ainner join exchange bon a.address = b.addressand a.block_time >= date('2020-01-01')group by 1,2order by 1,2),days as (select cast(day as timestamp) as day,'KuCoin' as exchange fromunnest(sequence(date('2020-01-01'), date(now()), interval '1' day)) AS t(day)),net_flow as (select a.day,a.exchange,coalesce(b.amount,0) as inflow,coalesce(c.amount,0) as outflowfrom days aleft join bin_inflow bon a.day = b.dayand a.exchange = b.exchangeleft join bin_outflow con a.day = c.dayand a.exchange = b.exchangeorder by a.day, a.exchange),final as (select day,exchange,(inflow +outflow) as Net_flowfrom net_floworder by day, exchange),btc_price as (select date_trunc('day', minute) as Day,avg(price) as Amountfrom prices.usdwhere minute >= date('2020-01-01')and contract_address is null and symbol='BTC'group by 1order by 1)