Eman-RazETH transferred to Layer 2: Optimism vs Hop
    Updated 2022-06-18
    with op as (select date_trunc('day',block_timestamp) as day, sum(AMOUNT) as ETH_Optimism
    from ethereum.core.ez_eth_transfers
    where ETH_TO_ADDRESS=lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') and day>=current_date-61 and day<=current_date-1
    group by 1
    order by 1),

    hop as (select date_trunc('day',block_timestamp) as day, sum(AMOUNT) as ETH_Hop
    from ethereum.core.ez_eth_transfers
    where ETH_TO_ADDRESS='0xb8901acb165ed027e32754e0ffe830802919727f' and day>=current_date-61 and day<=current_date-1
    group by 1
    order by 1)

    select op.day, ETH_Optimism, ETH_Hop
    from op full outer join hop
    on op.day=hop.DAY
    order by 1
    Run a query to Download Data