sriniall transfers eth and tokens agg
    Updated 2022-11-01
    with all_transfers as (
    select month, origin_to_address, sum(amount_usd) as amount_usd
    from (
    select
    date_trunc('month', block_timestamp) as month,
    origin_to_address,
    sum(amount_usd) as amount_usd
    from ethereum.core.ez_token_transfers
    where has_price = true
    group by 1, 2
    union all
    select
    date_trunc('month', block_timestamp) as month,
    origin_to_address,
    sum(amount_usd) as amount_usd
    from ethereum.core.ez_eth_transfers
    group by 1, 2
    ) t1
    group by 1, 2
    )

    select *
    from all_transfers
    order by month desc
    limit 10
    Run a query to Download Data