Unstaker | Total $gMON Burned | Unstake tx | |
|---|---|---|---|
1 | 0x61252faadcd832aa7279c78e033c95c762cd7215 | 2638498.681 | 4138 |
2 | 0x899768b085a22a1807409db79a79a30880f8b099 | 99986.455032 | 803 |
3 | 0xdb2a8a0c4c1b5333621883a5dc414e189a5e5220 | 73204 | 8 |
4 | 0x686e1d2b21ec1809d3d1385224982325cd819c9e | 51659.912637 | 24 |
5 | 0x255ec4a7dfefeed4889dbeb03d7ac06adccc2d24 | 51100 | 8 |
6 | 0x734fbf880bf9473e41415fce28d6e7b05f6b9cbd | 48146.438542 | 41 |
7 | 0xb80d0dbca7404fb93130e3465c444b1988f9ad05 | 43411.466665 | 229 |
8 | 0x5f8d2b7a5d92eadbad7cc2517f54bd86c0c4bd28 | 34684.791 | 1196 |
9 | 0x37c7ff89d1eeadcb0a46f1f3d862a869e54f5d06 | 32100 | 107 |
10 | 0x1a4e0e21dc401c07829ee50f9095fd4445260915 | 29736.7454 | 204 |
11 | 0x4ed099965aec755b79203514e56e7bcd1dfacf34 | 27612.512821 | 620 |
12 | 0xbfc40c5738e5336971ab0b5310a9c1a934b7021b | 27292.0051 | 1348 |
13 | 0xad08506e384bd79e2a0f647c49d436f921483460 | 23860 | 89 |
14 | 0x1ffcd3a19afd26b633c14aa12abcf4d3eb4255fd | 23355 | 7 |
15 | 0x6e11cbee1f6f417043818495c4cec5b03bcf19cb | 23299.697994 | 95 |
16 | 0x7b5693dabfb5e88ee10ff397c9eb0f124fc3254b | 22552 | 1339 |
17 | 0xe767b9253426ed34b7cd69872e9310bf3278ea66 | 19837.406675 | 51 |
18 | 0x5844b62532b74c5abc4f8c8929dadfc5d0e89f1f | 18285.498561 | 216 |
19 | 0x10a819d4578ce6444869edf6bac6517185cb87be | 18195.766144 | 46 |
20 | 0xe8577e5189a05eeb6fd136876cdad65a2ffb39d8 | 18142.05 | 161 |
Mrftiinternal-crimson copy copy
Updated 20 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
›
⌄
-- forked from internal-crimson copy @ https://flipsidecrypto.xyz/studio/queries/5d2c84e9-ca9c-47e2-8b61-bbe936557395
-- 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 "$gMON 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 ('0x2c9C959516e9AAEdB2C748224a41249202ca8BE7')
and a.ORIGIN_TO_ADDRESS = lower ('0x2c9C959516e9AAEdB2C748224a41249202ca8BE7')
and a.ORIGIN_FUNCTION_SIGNATURE = '0x6fed1ea7'
and a.TX_SUCCEEDED = 'TRUE'
)
select
"Unstaker",
sum ("$gMON Burned") as "Total $gMON Burned",
count (distinct TX_HASH) as "Unstake tx"
from database
group by 1
order by 2 desc
limit 100
Last run: about 20 hours agoAuto-refreshes every 12 hours
100
6KB
91s