0-MIDdaily volume net
Updated 2023-09-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select BLOCK_TIMESTAMP::date as date
,sum(case when FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')then ETH_VALUE end) as "DEPOSIT VALUE"
,-sum(case when TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')then ETH_VALUE end) as "WITHDRAW VALUE"
,"DEPOSIT VALUE"+"WITHDRAW VALUE" as "DAILY NET FLOW"
,sum("DAILY NET FLOW")over(order by date) as "TOTAL NET FLOW"
from base.core.fact_transactions
where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
or TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
group by 1
Run a query to Download Data