Average Daily Stakers | Average Daily Stake tx | Average Daily Fee ($MON) | Average Daily $MON Staked | Average Daily $sMON minted | |
|---|---|---|---|---|---|
1 | 57822.466667 | 77541.833333 | 515.757572634 | 26897.496488894 | 26689.03371773333 |
MrftiDaily averages
Updated 10 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
›
⌄
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 minted",
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'
AND a.BLOCK_TIMESTAMP > '2025-02-18 00:00:00.000'
)
, daily_metrics AS (
SELECT
DATE(BLOCK_TIMESTAMP) AS "Date",
count (distinct "Staker") as "Total Daily Stakers",
count (distinct TX_HASH) as "Total Daily Stake tx",
SUM("Fee ($MON)") AS "Total Daily Fee ($MON)",
SUM("$MON Staked") AS "Total Daily $MON Staked",
SUM("$sMON minted") AS "Total Daily $sMON minted"
FROM database
group by 1
)
SELECT
AVG("Total Daily Stakers") AS "Average Daily Stakers",
AVG("Total Daily Stake tx") AS "Average Daily Stake tx",
AVG("Total Daily Fee ($MON)") AS "Average Daily Fee ($MON)",
AVG("Total Daily $MON Staked") AS "Average Daily $MON Staked",
AVG("Total Daily $sMON minted") AS "Average Daily $sMON minted"
FROM
Last run: about 10 hours agoAuto-refreshes every 12 hours
1
77B
305s