MrftiKintsu overview
    Updated 16 hours ago
    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
    Total stake tx
    Total unique stakers
    Total $MON staked
    Total $sMON received
    Total fee ($MON)
    1
    2247499962931800047.141076192793879.2970414987.1823512
    1
    62B
    217s