MrftiMagma overview
    Updated 5 hours ago
    -- forked from Kintsu overview copy @ https://flipsidecrypto.xyz/studio/queries/0147cdf7-b1fa-45bd-a475-80831ca021ac

    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
    DATE_TRUNC(DAY, BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT TX_HASH) AS "Total stake tx",
    sum ("Total stake tx") over (order by date) as "Cumualtive stake tx",
    COUNT(DISTINCT "Staker") AS "Total unique stakers",
    sum ("Total unique stakers") over (order by date) as "Cumualtive stakers",
    SUM("$MON Staked") AS "Total $MON staked",
    sum ("Total $MON staked") over (order by date) as "Cumualtive $MON staked",
    SUM("$gMON Received") AS "Total $gMON minted",
    sum ("Total $gMON minted") over (order by date) as "Cumualtive $gMON minted",
    SUM("Fee ($MON)") AS "Total fee ($MON)",
    sum ("Total fee ($MON)") over (order by date) as "Cumualtive fee ($MON)"
    FROM database
    GROUP BY 1
    order by 1