0xbrun0cum flow for given wallet and token
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with
net_flow as (
SELECT
block_timestamp,
case
when to_address = '0xaa396035888d00d3490d4b100548c674b4bca267' then raw_amount / 1e6
when from_address = '0xaa396035888d00d3490d4b100548c674b4bca267' then - raw_amount / 1e6
end as net_flow
from
arbitrum.core.fact_token_transfers
where
(
to_address = '0xaa396035888d00d3490d4b100548c674b4bca267'
or from_address = '0xaa396035888d00d3490d4b100548c674b4bca267'
)
and contract_address = lower('0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9')
order by
block_timestamp desc
)
select f.block_timestamp,
sum(f.net_flow) over( partition by NULL ORDER BY f.block_timestamp ASC rows UNBOUNDED PRECEDING ) as cum_sum
from net_flow f
Run a query to Download Data