Unstaker | Unstake tx | Total $sMON Burned | |
|---|---|---|---|
1 | 0x9ea3ffcc40e725da125161161b9573bfeb70c715 | 2828 | 70.535984 |
2 | 0xce939cb4b6ef609e9f870a5c105f95fb24d86426 | 1294 | 1.1599 |
3 | 0xb878d6d297b0d7df16898ead0810d83ae451de09 | 1267 | 0.2986 |
4 | 0xc0040244be4abfbce637d11ad48ddb273521c489 | 1120 | 1.0998 |
5 | 0x422198fefd7272c32fb605058fb9cceb9dddc034 | 753 | 9.759 |
6 | 0xa4f972a0405dce4372b23d1db67bb21192cad6e3 | 752 | 0.8999 |
7 | 0x6f7132b46658ad86ad4844dc804af820aeba22f0 | 605 | 1.6139 |
8 | 0x615549858409031665d46fa8bba8a772534ab8d3 | 604 | 0.3958 |
9 | 0xb617b20321664c1e3b976eebf92b20b4a4b2cfe6 | 601 | 0.7088 |
10 | 0xd452051091ae38989d262ce132f2ae4e69fa9db6 | 546 | 0.1207 |
11 | 0xe4ac9ee86ceb440e6e8305b6a6f599b614ea23e1 | 526 | 0.0526 |
12 | 0xa2a2819ed645bd58ec0a44587bf55e81c210e4c4 | 447 | 2.5805 |
13 | 0x16a59681de8a36bf6985f48d49ab7466126d83dc | 431 | 17.283 |
14 | 0x6aaada0125713670b61352b5e3c84c7bc9063a14 | 400 | 1.7388 |
15 | 0x3758f2ec40e788ea4362c959e9e565d08d3edb5a | 388 | 0.784 |
16 | 0x67f0ad65d9e051055a941d07801214213cb02845 | 364 | 0.388 |
17 | 0x86143c875bcae83a5e4ee14ab93a9ec634c17b96 | 323 | 0.1289 |
18 | 0x6b92752b2797f33b48bf8081358a6972a0d20e3a | 317 | 2.2548 |
19 | 0xec04faf82c7f59eba3266d03ec37bf83f5fa83b5 | 268 | 3.7072 |
20 | 0xc976c65a5d441def6aca69eb937fc33c772464d6 | 260 | 2.6995 |
Mrftiinternal-crimson copy copy
Updated 12 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 internal-crimson copy @ https://flipsidecrypto.xyz/studio/queries/822a3133-bd3c-4faa-9e03-703ab2b8c765
-- 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",
count (distinct TX_HASH) as "Unstake tx",
sum ("$sMON Burned") as "Total $sMON Burned"
from database
group by 1
order by 2 desc
limit 100
Last run: about 12 hours agoAuto-refreshes every 12 hours
100
6KB
114s