Current status | USERS | |
|---|---|---|
1 | Active depositors | 23030 |
2 | Inactive depositors | 9641 |
Hessishmntrew- tier 1
Updated 2025-03-21
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
28
29
30
31
32
33
34
35
36
›
⌄
with deps as
(select amount,
amount_usd,
ethereum.public.udf_hex_to_int(SUBSTR(b.DATA, 131, 194))/86400 as "lock-up duration" ,
from_ADDRESS as user,
a.tx_hash,
a.block_timestamp::date as date
from mantle.core.ez_native_transfers a
join mantle.core.fact_event_logs b on a.tx_hash = b.tx_hash
where a.ORIGIN_FUNCTION_SIGNATURE = '0xe5853f56'
and a.TO_ADDRESS = '0xed884f0460a634c69dbb7def54858465808aacef'
and b.TOPIC_0 = '0x71a810dd86885cd9fea6e9b97fe8287ec71dd6475db601e9b925679c9f3ec3d1'
union
select amount,
amount_usd,
0 as "lock-up duration" ,
from_ADDRESS as user,
a.tx_hash ,
a.block_timestamp::date as date
from mantle.core.ez_native_transfers a
where a.ORIGIN_FUNCTION_SIGNATURE = '0xb6b55f25'
and a.TO_ADDRESS = '0xed884f0460a634c69dbb7def54858465808aacef'),
withds as
(select amount ,
amount_usd ,
'-' as "lock-up duration" ,
to_ADDRESS as user,
a.tx_hash,
a.block_timestamp::date as date
from mantle.core.ez_native_transfers a
where a.ORIGIN_FUNCTION_SIGNATURE = '0x00f714ce'
Last run: 17 days ago
2
58B
36s