headitmanagerDeposited Total Counts Over Time
    Updated 2022-06-17
    with total_count as (select count(*),symbol from ethereum.core.ez_token_transfers
    where TO_ADDRESS='0xabea9132b05a70803a4e85094fd0e1800777fbef'
    and block_timestamp::date>current_date - interval '60 days'
    group by symbol
    order by count(*) desc)
    ,total_count_overtime as (select count(*),block_timestamp::date from ethereum.core.ez_token_transfers
    where TO_ADDRESS='0xabea9132b05a70803a4e85094fd0e1800777fbef'
    and block_timestamp::date>current_date - interval '60 days'
    group by block_timestamp::date
    )
    ,volume as (select sum(amount),symbol from ethereum.core.ez_token_transfers
    where TO_ADDRESS='0xabea9132b05a70803a4e85094fd0e1800777fbef'
    and block_timestamp::date>current_date - interval '60 days'
    group by symbol
    order by sum(amount) desc)
    ,volume_overtime as (select sum(amount),block_timestamp::date from ethereum.core.ez_token_transfers
    where TO_ADDRESS='0xabea9132b05a70803a4e85094fd0e1800777fbef'
    and block_timestamp::date>current_date - interval '60 days'
    group by block_timestamp::date
    )
    select * from total_count_overtime
    Run a query to Download Data