cheeyoung-kekDistinct Wallets (zkSync)
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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