cheeyoung-kekDistinct Wallets (zkSync)
    Updated 2022-06-17

    with amount_deposited as (
    select date_trunc('day', block_timestamp::date) as date_by_day , tx_hash, origin_from_address, sum(event_inputs:amount/1e18) as amount_deposit from ethereum.core.fact_event_logs where event_name='Deposit'
    and contract_address='0xabea9132b05a70803a4e85094fd0e1800777fbef' and tx_status='SUCCESS'
    group by 1,2,3

    )
    select count (distinct a.origin_from_address) as distinct_wallet,
    from amount_deposited a
    inner join ethereum.core.ez_eth_transfers b
    on a.tx_hash =b.tx_hash
    where date_by_day >= current_date - 60


    Run a query to Download Data