binhachonThe Merge - State diffs stats
    Updated 2022-03-24
    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