Abbas_ra21staking daily stats
    Updated 2022-07-03
    select
    A.Day AS Day,
    unstaked,
    staked
    from
    (
    select
    DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) AS Day,
    +sum(RAW_AMOUNT/1e9) AS unstaked
    from ethereum.core.ez_token_transfers
    where
    FROM_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0x990966d5'
    AND BLOCK_TIMESTAMP > DateAdd(d, -89, GetDate())
    group by 1) A
    inner join
    (select
    DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) AS Day,
    (sum(RAW_AMOUNT/1e9)) AS staked
    from ethereum.core.ez_token_transfers
    where
    TO_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0xd866c9d8'
    AND BLOCK_TIMESTAMP > DateAdd(d, -89, GetDate())
    group by 1)B
    on A.Day=B.Day
    Run a query to Download Data