binhachonETH Deposited or Withdrawn - #1
    Updated 2022-06-27
    with deposit_transactions as (
    select
    block_timestamp,
    eth_from_address as user_address,
    amount
    from ethereum.core.ez_eth_transfers
    where origin_function_signature = '0xb6b55f25'
    and eth_to_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
    ),
    deposit_amount as (
    select
    date_trunc('week', block_timestamp) as time,
    sum(amount) as deposit_amount,
    count(distinct user_address) as number_of_depositors
    from deposit_transactions
    group by 1
    ),
    withdraw_transactions as (
    select
    block_timestamp,
    eth_to_address as user_address,
    amount
    from ethereum.core.ez_eth_transfers
    where origin_function_signature = '0x00f714ce'
    and eth_from_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
    ),
    withdraw_amount as (
    select
    date_trunc('week', block_timestamp) as time,
    sum(amount) as withdraw_amount,
    count(distinct user_address) as number_of_withdrawers
    from withdraw_transactions
    group by 1
    ),
    timetable as (
    select
    Run a query to Download Data