barbodETH
    Updated 2022-06-15
    with st as (SELECT
    date_trunc(day,block_timestamp) as day1,
    SUM(amount) as amt1
    --sum(AMOUNT_USD) as amt_usd_1
    FROM ethereum.udm_events
    WHERE block_timestamp > CURRENT_DATE - 95 and block_timestamp < CURRENT_DATE - 5
    AND to_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and origin_function_signature IN ('0xa1903eab', '0xa9059cbb') and EVENT_NAME = 'transfer'
    GROUP BY 1
    ORDER BY 1 DESC),

    unst as (SELECT
    date_trunc(day,block_timestamp) as day2,
    SUM(amount) as amt2
    --sum(AMOUNT_USD) as amt_usd_2
    FROM ethereum.udm_events
    WHERE block_timestamp > CURRENT_DATE - 95 and block_timestamp < CURRENT_DATE - 5 and from_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and EVENT_NAME = 'transfer'
    GROUP BY 1
    ORDER BY 1 DESC)

    select
    st.day1 as day,
    st.amt1 as staked_ETH,
    unst.amt2 as unstaked_eth
    from st , unst where day1 = day2
    order by 1

    Run a query to Download Data