maybeyonaszk_distinct_wallets_overall
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with
op_data as (
select
block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
origin_function_signature,
amount,
case
when origin_function_signature = '0x2d2da806' then 'eth deposit'
when origin_function_signature = '0xe17376b5' then 'erc20 deposit'
else 'sus' end as action
from ethereum.core.ez_eth_transfers
where origin_to_address = '0xabea9132b05a70803a4e85094fd0e1800777fbef' -- main bridge
and action != 'sus'
)
select
-- date(block_timestamp) as date,
-- action,
count(tx_hash) as txs,
count(distinct origin_from_address) as users,
sum(amount) as eth_vol
from op_data
where block_timestamp > current_date - interval '60 days'
-- group by 1,2
Run a query to Download Data