Unstaker | Total $aprMON Burned | Unstake tx | |
|---|---|---|---|
1 | 0x1a0c55c986e0fd3b96ed72a2a43e39369957d095 | 103307.351628 | 17 |
2 | 0xffd4b61816f5f04510562bb87a5c0dbd50082d50 | 84100 | 1 |
3 | 0xdb2a8a0c4c1b5333621883a5dc414e189a5e5220 | 67099 | 5 |
4 | 0xad08506e384bd79e2a0f647c49d436f921483460 | 27699.997 | 41 |
5 | 0x20ce27b140a0eeeccef880e01d2082558400fdd6 | 26288.001977 | 13 |
6 | 0x0e635b5cfb9dc7c4151d3fce2b6c8a2e0ea322f9 | 23586.177741 | 36 |
7 | 0x0ad0ed704eefc04638695a7a51ed57b563b9bf18 | 20001 | 1 |
8 | 0xf7ff0bf900f774fd6921f74f53de9d54923a6195 | 13150.023622 | 41 |
9 | 0x5ee5b26911278af4f46c3a2506c6fbd432727d12 | 11916.039391 | 73 |
10 | 0x469381d77b755e5b92246a29c9ab586d15b6ebc9 | 11707.001 | 8 |
11 | 0xa618a9d914036356b9b5f9311f3b96a9d54b872f | 11050.631759 | 9 |
12 | 0xed0b6f10fe999bdc57e6bc0fc5e9a0e32ad211f5 | 10608.553346 | 5 |
13 | 0xead68dcc30b40d824b3a07b36e56d0d703d84ba9 | 10500.64068 | 7 |
14 | 0x624f3b6bd5a60113c3e4b3fa267ffa16a8be3375 | 10425.2 | 1 |
15 | 0xcadae1df02954acf40f751f06234138beb03dc1d | 10399.995984 | 2 |
16 | 0xfa5c1a67e86af7f0fcd1a59d9710e7e7a76900f4 | 10005.610174 | 3 |
17 | 0x5043afa2f5656a7c25a63b6c78f717a058dd98ab | 10000.4 | 1 |
18 | 0x779337231e4294186e90e5521bd0af03bce2c06b | 9999.8999 | 3 |
19 | 0xcbb7274ec82a7cca079ca22488026cc998453d65 | 9941.6 | 30 |
20 | 0xbcfdd1de11a2321785df86fc853d21df7ee634d4 | 9596.2342 | 18 |
Mrftiunstakers
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
›
⌄
-- forked from internal-crimson copy copy @ https://flipsidecrypto.xyz/studio/queries/17c0fcfa-9a3e-489e-b5a5-c56df394280f
WITH database AS (
SELECT
a.BLOCK_TIMESTAMP,
a.TX_HASH,
a.ORIGIN_FROM_ADDRESS as "Unstaker",
CAST(ethereum.public.udf_hex_to_int(a.data) AS decimal) / 1e18 AS "$aprMON 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 = lower ('0xb2f82d0f38dc453d596ad40a37799446cc89274a')
and a.ORIGIN_TO_ADDRESS = lower ('0xb2f82d0f38dc453d596ad40a37799446cc89274a')
and a.ORIGIN_FUNCTION_SIGNATURE = '0x492e47d2'
and a.TX_SUCCEEDED = 'TRUE'
and topic_3 is null
)
select
"Unstaker",
sum ("$aprMON Burned") as "Total $aprMON Burned",
count (distinct TX_HASH) as "Unstake tx"
from database
group by 1
order by 2 desc
limit 100
Last run: about 12 hours agoAuto-refreshes every 12 hours
100
6KB
239s