Mrftiinternal-crimson
    Updated 4 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'
    AND a.BLOCK_TIMESTAMP > '2025-02-18 00:00:00.000'
    )

    select
    "Staker",
    sum ("$MON Staked") as "Total $MON Staked",
    count (distinct TX_HASH) as "Stake tx"
    from database
    group by 1
    order by 2 desc
    limit 100
    Last run: about 4 hours agoAuto-refreshes every 12 hours
    Staker
    Total $MON Staked
    Stake tx
    1
    0x4d02af17a29cda77416a1f60eae9092bb6d9c026250001
    2
    0x15935ec6176290369194c9d73cb82c2f2400f8a7160001
    3
    0x1f0b86f4e27798b56fcce50bdaa12f8ac21697f5100001
    4
    0x5043afa2f5656a7c25a63b6c78f717a058dd98ab55013
    5
    0xad08506e384bd79e2a0f647c49d436f921483460536516
    6
    0xdb2a8a0c4c1b5333621883a5dc414e189a5e522031253
    7
    0xb80d0dbca7404fb93130e3465c444b1988f9ad053033.82818
    8
    0x6147aea777f72e5343ea1be54c3e8f5be193db6c2607.2532
    9
    0x469381d77b755e5b92246a29c9ab586d15b6ebc925209
    10
    0x13ffeeb209e7adc70e550508ed4bd09bf79108d325001
    11
    0xf30ed549df7f78c660b20c388712f295da5f257a2253.2834
    12
    0x720b851bbebd76740c5af9fca4aa990917d457f821055
    13
    0xccb3c6ed6cb22da170304a5143b76453997ae3fd2053.42532
    14
    0x5534a3407e6d717a1791eb185089f32486abb1302034.6946810
    15
    0x59737d3e4911180e0b6fa62d516d5d0e43e6b7252013.8311
    16
    0x4ab571d259c6ea9c7332e1045ad0c6327a8c8dfa20001
    17
    0x61b84cab9dd4b629cc934bb2d1d69f9dc43f0d3420001
    18
    0x86e17ea9debca8c8f7a5b4009f9c37fe8d97f3231715.5635
    19
    0x2e5f455909b88aee06478bc5efd2bade29a440301524.4176599
    20
    0x1d08e9241f35b5f92b0a0a50c53ff026461251101500.412
    100
    5KB
    90s