Unstaker | Total $sMON Burned | Unstake tx | |
|---|---|---|---|
1 | 0x4d02af17a29cda77416a1f60eae9092bb6d9c026 | 24024.853 | 2 |
2 | 0x1f0b86f4e27798b56fcce50bdaa12f8ac21697f5 | 18940 | 3 |
3 | 0xad08506e384bd79e2a0f647c49d436f921483460 | 8396.3 | 5 |
4 | 0xdb2a8a0c4c1b5333621883a5dc414e189a5e5220 | 5963 | 2 |
5 | 0x5043afa2f5656a7c25a63b6c78f717a058dd98ab | 5472.5574 | 5 |
6 | 0x0f7695ecdb4f31bf9fb238d58b1afde357f3b8b2 | 3932.9927 | 49 |
7 | 0x8b8c62316090fa74d59bb14a710e27a700142370 | 3172.3248 | 7 |
8 | 0xb80d0dbca7404fb93130e3465c444b1988f9ad05 | 3097.708 | 6 |
9 | 0x2cc1d749736911c59c585f7801b8620f7d6ed185 | 2904.9083 | 5 |
10 | 0x86e17ea9debca8c8f7a5b4009f9c37fe8d97f323 | 2707.177 | 2 |
11 | 0x469381d77b755e5b92246a29c9ab586d15b6ebc9 | 2556.726 | 7 |
12 | 0x2e5f455909b88aee06478bc5efd2bade29a44030 | 2519.169 | 28 |
13 | 0x66f0fed0ac5b6e7a671d0efd36870259d047a6b0 | 2488.356 | 166 |
14 | 0x5534a3407e6d717a1791eb185089f32486abb130 | 2028.33 | 7 |
15 | 0x59737d3e4911180e0b6fa62d516d5d0e43e6b725 | 1987.6998 | 2 |
16 | 0x4ab571d259c6ea9c7332e1045ad0c6327a8c8dfa | 1900.266 | 3 |
17 | 0x11ebaa109a0a0388f82c5bdea6fafc0ec78cb4d1 | 1871.339 | 3 |
18 | 0x5844b62532b74c5abc4f8c8929dadfc5d0e89f1f | 1607.7622 | 37 |
19 | 0x1d08e9241f35b5f92b0a0a50c53ff02646125110 | 1482 | 2 |
20 | 0x6147aea777f72e5343ea1be54c3e8f5be193db6c | 1390.723 | 2 |
Mrftiinternal-crimson copy
Updated 9 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
›
⌄
-- forked from internal-crimson @ https://flipsidecrypto.xyz/studio/queries/dadc0674-864e-4c76-8adc-946a9bde97b0
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
order by 2 desc
limit 100
Last run: about 9 hours agoAuto-refreshes every 12 hours
100
6KB
218s