Total stake tx | Total unique stakers | Total $MON staked | Total $sMON received | Total fee ($MON) | |
---|---|---|---|---|---|
1 | 2247499 | 962931 | 800047.141076192 | 793879.29704 | 14987.1823512 |
MrftiKintsu overview
Updated 16 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
›
⌄
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 "$sMON 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 = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and a.ORIGIN_TO_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and a.ORIGIN_FUNCTION_SIGNATURE = '0x3a4b66f1'
and a.TX_SUCCEEDED = 'TRUE'
)
select
count (distinct tx_hash) as "Total stake tx",
count (distinct "Staker") as "Total unique stakers",
sum ("$MON Staked") as "Total $MON staked",
sum ("$sMON Received") as "Total $sMON received",
sum ("Fee ($MON)") as "Total fee ($MON)"
from database
Last run: about 17 hours agoAuto-refreshes every 12 hours
1
62B
217s