lock-up duration | Total volume | Deposit txs | |
|---|---|---|---|
1 | no lock_up | 2219735981.31292 | 34292 |
2 | 200 Days | 8306790.94710074 | 2455 |
3 | 100 Days | 52785748.3138057 | 7330 |
4 | 300 Days | 43166160.8821627 | 12733 |
5 | 50 Days | 42733607.3357801 | 13878 |
Hessishmntrew- locks
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
›
⌄
with deps as
(select amount,
amount_usd,
ethereum.public.udf_hex_to_int(SUBSTR(b.DATA, 131, 194))/86400 as "lock-up dur" ,
from_ADDRESS,
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 dur" ,
from_ADDRESS,
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')
SELECT case when "lock-up dur" = 0 then 'no lock_up'
else round("lock-up dur")||' Days' end as "lock-up duration",
sum(amount) as "Total volume", count(DISTINCT tx_hash) as "Deposit txs"
from deps
group by all
Last run: 17 days ago
5
180B
27s