mboveiriHOP 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
23
24
25
26
›
⌄
with hop as (select
block_timestamp::date as date,
(EVENT_INPUTS:amount/pow(10,18)) as amount_deposited,
ORIGIN_FROM_ADDRESS as Wallet,
case
when EVENT_INPUTS:amount/pow(10,18) <= 1 then 'Chick'
when EVENT_INPUTS:amount/pow(10,18) > 1 and EVENT_INPUTS:amount/pow(10,18) <= 5 then 'Normal'
when EVENT_INPUTS:amount/pow(10,18) > 5 then 'Whale'
else null
end as wallet_type
from ethereum.core.fact_event_logs where contract_address = lower('0xb8901acb165ed027e32754e0ffe830802919727f')
and event_name = 'TransferSentToL2'
and EVENT_INPUTS:chainId ='10'
--limit 100
--group by date)
)
select
--count(wallet),
wallet_type,
count(wallet_type),
sum(amount_deposited)
from hop
group by wallet_type
Run a query to Download Data