maybeyonasaddress_bals
    Updated 2021-10-13
    with eth_in as(
    select
    to_address as address,
    amount as eth
    from ethereum.udm_events
    where event_type = 'native_eth'
    ),
    eth_out as(
    select
    from_address as address,
    -amount as eth
    from ethereum.udm_events
    where event_type = 'native_eth'
    ),
    gas as(
    select
    from_address as address,
    -tx_fee as eth
    from ethereum.transactions
    ),
    all_eth as(
    select * from eth_in
    union all
    select * from eth_out
    union all
    select * from gas
    ),
    eth_bal as(
    select
    address,
    sum(eth) as eth
    from all_eth
    group by 1
    ),
    eth_today as(
    select date(hour) as date
    Run a query to Download Data