Mrftiinternal-crimson copy copy
    Updated 19 hours ago
    -- forked from internal-crimson copy @ https://flipsidecrypto.xyz/studio/queries/5d2c84e9-ca9c-47e2-8b61-bbe936557395

    -- forked from internal-crimson @ https://flipsidecrypto.xyz/studio/queries/dadc0674-864e-4c76-8adc-946a9bde97b0

    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 "$gMON 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 = lower ('0x2c9C959516e9AAEdB2C748224a41249202ca8BE7')
    and a.ORIGIN_TO_ADDRESS = lower ('0x2c9C959516e9AAEdB2C748224a41249202ca8BE7')
    and a.ORIGIN_FUNCTION_SIGNATURE = '0x6fed1ea7'
    and a.TX_SUCCEEDED = 'TRUE'
    )

    select
    "Unstaker",
    sum ("$gMON Burned") as "Total $gMON Burned",
    count (distinct TX_HASH) as "Unstake tx"
    from database
    group by 1
    order by 2 desc
    limit 100