Tier | Total Unstakers | |
|---|---|---|
1 | Tier1: only 1 Unstake tx | 199351 |
2 | Tier2: 1-5 Unstake tx | 108705 |
3 | Tier3: 6-10 Unstake tx | 9555 |
4 | Tier4: 10-100 Unstake tx | 5423 |
5 | Tier5: more than 100 Unstake tx | 125 |
Mrftisimilar-red copy copy
Updated 5 hours ago
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
›
⌄
-- forked from similar-red copy @ https://flipsidecrypto.xyz/studio/queries/50182505-8640-45aa-96f5-e540dd95c000
-- forked from similar-red @ https://flipsidecrypto.xyz/studio/queries/db98084c-e534-452d-aefe-0d6c6341b4f1
with usertbl as
(WITH database AS (
SELECT
a.BLOCK_TIMESTAMP,
a.TX_HASH,
a.ORIGIN_FROM_ADDRESS as "Unstaker",
CAST(ethereum.public.udf_hex_to_int(data) AS decimal) / 1e18 AS "$sMON Burned",
b.tx_fee as "Fee ($MON)"
FROM
monad.testnet.fact_event_logs a
join
monad.testnet.fact_transactions b on a.tx_hash = b.tx_hash
where a.CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and a.ORIGIN_TO_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and a.ORIGIN_FUNCTION_SIGNATURE = '0x30af6b2e'
and a.TX_SUCCEEDED = 'TRUE'
AND a.BLOCK_TIMESTAMP > '2025-02-18 00:00:00.000'
)
select
"Unstaker",
sum ("$sMON Burned") as "Total $sMON Burned",
count (distinct TX_HASH) as "Unstake tx"
from database
group by 1
)
SELECT
case
when "Unstake tx" = 1 then 'Tier1: only 1 Unstake tx'
Last run: about 5 hours agoAuto-refreshes every 12 hours
5
176B
111s