Total Unstake tx | Total unique Unstakers | Total $sMON Burned | Total fee ($MON) | |
|---|---|---|---|---|
1 | 699890 | 321199 | 415392.059416 | 4185.788582697 |
MrftiKintsu overview copy
Updated 9 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
›
⌄
-- forked from Kintsu overview @ https://flipsidecrypto.xyz/studio/queries/874cc1ed-62ef-4672-b67b-4e792d1f12d1
--Unstaking analysis
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 "$sMON 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 = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and a.ORIGIN_TO_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and a.ORIGIN_FUNCTION_SIGNATURE = '0x30af6b2e'
and a.TX_SUCCEEDED = 'TRUE'
)
select
count (distinct tx_hash) as "Total Unstake tx",
count (distinct "Unstaker") as "Total unique Unstakers",
sum ("$sMON Burned") as "Total $sMON Burned",
sum ("Fee ($MON)") as "Total fee ($MON)"
from database
Last run: about 9 hours agoAuto-refreshes every 12 hours
1
46B
173s