maybeyonasUntitled Query
    Updated 2022-10-15
    with
    eth_movement as (
    select
    block_timestamp,
    ETH_FROM_ADDRESS as user,
    -amount as eth_moved
    from ethereum.core.ez_eth_transfers
    union all
    select
    block_timestamp,
    ETH_TO_ADDRESS as user,
    amount as eth_moved
    from ethereum.core.ez_eth_transfers
    union all
    select
    block_timestamp,
    from_address,
    -tx_fee as eth_moved
    from ethereum.core.fact_transactions
    )

    select
    user,
    sum(eth_moved) as eth_bal
    from eth_movement
    where user = lower('0x364f7fd945b8c76c3c77d6ac253f1fea3b65e00d')
    group by 1
    limit 100

    Run a query to Download Data