binhachonThe Merge - State diffs stats
Updated 2022-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with deposit_transaction as (
select
timestamp,
curr_value::float/1e18 as ETH_amount,
(curr_value::float - prev_value::float)/1e18 as deposit_amount
from tokenflow_eth.state_diffs
where address = '0x00000000219ab540356cbb839cbe05303d7705fa'
and reason = 'eth transfer'
and status = 'TRUE'
)
select
date_trunc('week', timestamp) as time,
max(ETH_amount) as ETH_amount,
avg(deposit_amount) as average_deposit_amount,
count(*) as deposit_frequency
from deposit_transaction
group by time
Run a query to Download Data