Staker | Total $MON Staked | Stake tx | |
|---|---|---|---|
1 | 0x61252faadcd832aa7279c78e033c95c762cd7215 | 3208783.681 | 4977 |
2 | 0xc9ca79af6969315fa19b69ea3333e29cd35d0d5c | 1644796.5 | 2690 |
3 | 0x7c2a757af89a2e0d8b6590ebfa279561596a9c5d | 279348.55 | 325 |
4 | 0x7b699a3b214f36922c03465d2ea030b0fe73f0fe | 204527.5 | 723 |
5 | 0x69743a215ad25adfef6a8e2f062d09acca5d70c9 | 183301.942158187 | 299 |
6 | 0xf0b44216cf3ceaa2caa78cc6a412891cc4dd4299 | 127403.6 | 142 |
7 | 0x00cf67a50124b3c71c89f4ca10da42c5c15ff380 | 102467 | 775 |
8 | 0x899768b085a22a1807409db79a79a30880f8b099 | 99992.970931972 | 816 |
9 | 0x80b52b5077e11ba008fbbb288ee5e8b744d7ea31 | 92609.77145 | 76 |
10 | 0xcaef42d212f54c4f3de3fe28c1fd22b3d08fd66e | 88491 | 88 |
11 | 0xdb2a8a0c4c1b5333621883a5dc414e189a5e5220 | 75001 | 37 |
12 | 0x1a4e0e21dc401c07829ee50f9095fd4445260915 | 70034.397 | 311 |
13 | 0x7b5693dabfb5e88ee10ff397c9eb0f124fc3254b | 64441 | 1957 |
14 | 0x1b2d134fc716561afbf8ccef56568d18c28a34aa | 62561.2 | 63 |
15 | 0x41ccb8544c29d887d5af91ae04c06f3080f65158 | 61993.5 | 87 |
16 | 0x20ce27b140a0eeeccef880e01d2082558400fdd6 | 60248.613 | 64 |
17 | 0x463c0864b8d11b39176a86635b92169c2cd10e2f | 59828.56229556 | 1597 |
18 | 0x359457bd4fcc8e2a24c170617ac2018e856a06d5 | 56772.270127224 | 15 |
19 | 0x1839ccbbed22f8259de91be648e4de921cb99809 | 56311 | 170 |
20 | 0x686e1d2b21ec1809d3d1385224982325cd819c9e | 54003.4 | 8 |
Mrftiinternal-crimson 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
›
⌄
-- 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 "Staker",
b.value AS "$MON Staked",
CAST(ethereum.public.udf_hex_to_int(data) AS decimal) / 1e18 AS "$gMON Received",
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 = '0xd5575982'
and a.TX_SUCCEEDED = 'TRUE'
)
select
"Staker",
sum ("$MON Staked") as "Total $MON Staked",
count (distinct TX_HASH) as "Stake tx"
from database
group by 1
order by 2 desc
limit 100
Last run: about 12 hours agoAuto-refreshes every 12 hours
100
6KB
251s