flipside

    Magma overview
    MrftiMagma overview
    Updated 11 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
    Last run: about 11 hours agoAuto-refreshes every 12 hours
    DATE
    Total stake tx
    Cumualtive stake tx
    Total unique stakers
    Cumualtive stakers
    Total $MON staked
    Cumualtive $MON staked
    Total $gMON minted
    Cumualtive $gMON minted
    Total fee ($MON)
    Cumualtive fee ($MON)
    1
    		2025-02-13 00:00:00.000131311606060600.0553003880.055300388
    2
    		2025-02-14 00:00:00.000215120.460.40.460.40.00853919550.0638395835
    3
    		2025-02-15 00:00:00.000318131.56268125661.9626812561.56268261.9626820.0124424040.0762819875
    4
    		2025-02-17 00:00:00.000321140.056889353762.0195706090.05688962.0195710.0124424040.0887243915
    5
    		2025-02-18 00:00:00.00011326105.76641312967.7859837385.76641367.7859840.05909624240.1478206339
    6
    		2025-02-19 00:00:00.0002230226218141824970.5600507511038.346034489970.5600511038.34603512.80926015412.957080788
    7
    		2025-02-20 00:00:00.00018975212371468416508138304.28769717139342.633731659138304.287706139342.633741123.091644201136.048724989
    8
    		2025-02-21 00:00:00.00023255444921630332811134449.214741115273791.848472774134449.214741273791.848482174.824873961310.873598951
    9
    		2025-02-22 00:00:00.0003001874510160214883271015.110258375344806.95873114971015.11024344806.958722188.382163496499.255762447
    10
    		2025-02-23 00:00:00.000569851314952426473096173345.990192104518152.948923253173345.990224518152.948946471.418353031970.674115478
    11
    		2025-02-24 00:00:00.0008121521271027368100464879131.9765932841397284.92551654879131.9766231397284.925569728.1110561291698.785171607
    12
    		2025-02-25 00:00:00.00016629337900356651157115823904.2086281792221189.13414472823904.208792221189.1343591580.8193294053279.604501012
    13
    		2025-02-26 00:00:00.000332598711601137801294916695311.6400902162916500.77423493695311.6404482916500.7748073445.3643580916724.968859102
    14
    		2025-02-27 00:00:00.000284587996188117452412368182835.4364933183099336.21072825182835.4367413099336.2115482626.5287800599351.497639161
    15
    		2025-02-28 00:00:00.0002993741295562123842536210461458.1375037423560794.34823199461458.1377633560794.3493112386.99643180111738.494070962
    16
    		2025-03-01 00:00:00.000200111149567389987626197210635.5932245223771429.94145651210635.593293771429.9426011509.85147503813248.345545999
    17
    		2025-03-02 00:00:00.000224871172054499932726129298297.6897458754069727.63120239298297.689724069727.6323211568.74205091514817.087596915
    18
    		2025-03-03 00:00:00.000174678189522210430083042975596.2282142224145323.8594166175596.2282634145323.8605841322.28846417116139.376061086
    19
    		2025-03-04 00:00:00.0001808442076066102108932537106732.5447608254252056.40417744106732.544734252056.4053141290.93996541317430.316026498
    20
    		2025-03-05 00:00:00.00019137622674421188511051388117187.1227613894369243.52693883117187.1227394369243.5280531380.15101885618810.467045355
    33
    5KB
    141s