mboveiriNative bridge deposit - Wallet Type
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with op as (select block_timestamp::date as date,
eth_from_address as wallet,
--count(distinct(eth_from_address)) as count ,
amount as amount_deposited,
case
when amount <= 1 then 'Chick'
when amount > 1 and amount <= 5 then 'Normal'
when amount > 5 then 'Whale'
else null
end as wallet_type
from ethereum.core.ez_eth_transfers
where (eth_to_address = lower('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1') or eth_to_address = lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC'))
--and date >= current_date - 60
)
select
--count(wallet),
wallet_type,
count(wallet_type),
sum(amount_deposited)
from op
group by wallet_type
Run a query to Download Data