MrftishMONAD overview
    Updated 2025-05-28
    -- forked from Magma overview copy @ https://flipsidecrypto.xyz/studio/queries/bcfbb17b-d9fa-4b63-8861-b8c14d1cc7e1

    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(SUBSTRING(a.Data, 19, 48)) AS decimal) / 1e18 AS "$shMON 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 ('0x3a98250f98dd388c211206983453837c8365bdc1')
    and a.ORIGIN_TO_ADDRESS = lower ('0x3a98250f98dd388c211206983453837c8365bdc1')
    and a.ORIGIN_FUNCTION_SIGNATURE = '0x6e553f65'
    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("$shMON Received") AS "Total $shMON minted",
    sum ("Total $shMON minted") over (order by date) as "Cumualtive $shMON minted",
    SUM("Fee ($MON)") AS "Total fee ($MON)",
    sum ("Total fee ($MON)") over (order by date) as "Cumualtive fee ($MON)"
    FROM database
    where date > '2025-02-18 00:00:00.000 '
    GROUP BY 1
    Last run: 3 months ago
    DATE
    Total stake tx
    Cumualtive stake tx
    Total unique stakers
    Cumualtive stakers
    Total $MON staked
    Cumualtive $MON staked
    Total $shMON minted
    Cumualtive $shMON minted
    Total fee ($MON)
    Cumualtive fee ($MON)
    1
    2025-02-19 00:00:00.000718718485485761.278299386761.278299386761.2783761.27835.1468804585.146880458
    2
    2025-02-20 00:00:00.00025183236162821135842.9925621416604.2708615275842.9926026604.27090217.02293561722.169816076
    3
    2025-02-21 00:00:00.00036826918203241457157.36840833413761.6392698617157.36572913761.63663126.49775822748.667574303
    4
    2025-02-22 00:00:00.0005777126953754789911028.71371413924790.35298411028.24396724789.88059840.6645236389.332097932
    5
    2025-02-23 00:00:00.0001511827813103891828830621.40166135955411.7546453630617.81086455407.69146299.872695545189.204793478
    6
    2025-02-24 00:00:00.0001622044033111452943312394.15692233467805.91156769412392.06383867799.7553104.581011951293.785805428
    7
    2025-02-25 00:00:00.0004373687769323786181141075.321641608108881.23320930141066.709332108866.464632286.673030213580.458835641
    8
    2025-02-26 00:00:00.0001200662078358920615101738867.287250918147748.52046021938858.145413147724.610045747.5674133121328.026248954
    9
    2025-02-27 00:00:00.0007297728081251802202819104551.344542575252299.865002794104524.595496252249.205541466.8556959961794.881944949
    10
    2025-02-28 00:00:00.0008053236134446821249640430535.289678199682835.154680993430418.677786682667.883327524.2223409842319.104285933
    11
    2025-03-01 00:00:00.0006218742353140287289927133664.870262494816500.024943487133627.800941816295.684268391.0205142852710.124800217
    12
    2025-03-02 00:00:00.0009958452311561015350942292665.2878345031109165.31277799292581.3382521108877.02252632.9344906873343.059290905
    13
    2025-03-03 00:00:00.000596605827754676739770940859.0702494081150024.383027440846.9101461149723.932666401.3303415553744.38963246
    14
    2025-03-04 00:00:00.00014274272551799203496912274990.2843294811425014.66735688274906.5321191424630.464785945.1633284614689.552960921
    15
    2025-03-05 00:00:00.00013478686030370830567742141609.3535119591566624.02086884141565.7214931566196.186278897.493062435587.046023351
    16
    2025-03-06 00:00:00.0001129909732937083263857478294.6367182071644918.6575870578270.3426511644466.528929799.439957976386.485981321
    17
    2025-03-07 00:00:00.00012379410970877508171365593011.3739478091737930.0315348592982.2817651737448.810694910.8557331257297.341714445
    18
    2025-03-08 00:00:00.000108420120550759610773265111103.0274663591849033.05900121111067.9535981848516.764292846.5653191538143.907033599
    19
    2025-03-09 00:00:00.000110750131625757191830456155474.8990773562004507.95807857155425.4509492003942.215241783.6150552958927.522088893
    20
    2025-03-10 00:00:00.00011348014297377527390572993012.915518022097520.8735965992983.0686582096925.283899841.2039706659768.726059559
    98
    14KB
    520s