flipside

    Kintsu overview copy
    MrftiKintsu overview copy
    Updated 13 hours ago
    -- forked from Kintsu overview @ https://flipsidecrypto.xyz/studio/queries/874cc1ed-62ef-4672-b67b-4e792d1f12d1

    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
    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("$sMON Received") AS "Total $sMON minted",
    sum ("Total $sMON minted") over (order by date) as "Cumualtive $sMON 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
    Last run: about 13 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 $sMON minted
    Cumualtive $sMON minted
    Total fee ($MON)
    Cumualtive fee ($MON)
    1
    		2025-02-18 00:00:00.00013134412.682212.682212.62582812.6258280.06138083560.0613808356
    2
    		2025-02-19 00:00:00.00016611674138413881555.4451651568.1273651548.0870511560.71287911.52151973211.582900568
    3
    		2025-02-20 00:00:00.000405957333350473810782.801147912350.928512910728.96653812289.67941724.35876500335.941665571
    4
    		2025-02-21 00:00:00.00030298762231570538823.49572044621174.4242333468777.20968721066.88910416.91577429752.857439868
    5
    		2025-02-22 00:00:00.000110431980583991545256978.95063078978153.37486413556664.01393477730.90303872.933079419125.790519287
    6
    		2025-02-23 00:00:00.00018396382011319928651100688.925185413178842.300049547100106.236003177837.139041130.219243153256.00976244
    7
    		2025-02-24 00:00:00.0002289161092164584510953265.002073855232107.30212340252940.280137230777.419178172.562862473428.572624913
    8
    		2025-02-25 00:00:00.00053938115030384698357871802.692067391303909.99419079371344.129597302121.548775464.040350535892.612975448
    9
    		2025-02-26 00:00:00.0001279952430258654817012660335.234009112364245.22819990659933.830837362055.379612983.4862000081876.099175456
    10
    		2025-02-27 00:00:00.0001076973507227962624975262021.687869029426266.91606893461593.944036423649.323648705.4435131382581.542688594
    11
    		2025-02-28 00:00:00.0001138304645529009033984234383.80638449460650.72245342534134.735668457784.059316781.1867891033362.729477697
    12
    		2025-03-01 00:00:00.000856615502136713340697531058.331867033491709.05432045830824.286731488608.346047588.7692956313951.498773328
    13
    		2025-03-02 00:00:00.000937406439537259147956626762.23496244518471.28928289726552.919079515161.265126608.003524044559.502297368
    14
    		2025-03-03 00:00:00.000773287212815946053902619973.284376136538444.57365903319811.539583534972.804709526.3351785665085.837475934
    15
    		2025-03-04 00:00:00.000775437988245625659528220278.487046365558723.06070539920108.442619555081.247328515.3036001055601.141076039
    16
    		2025-03-05 00:00:00.000658798647034621464149617895.368689283576618.42939468117740.210512572821.45784461.8424044466062.983480486
    17
    		2025-03-06 00:00:00.000894649541676724970874513345.089708435589963.51910311713225.594554586047.052394593.0805984026656.064078888
    18
    		2025-03-07 00:00:00.0007393310281005576876451314533.044948366604496.56405148314398.896173600445.948567521.4952121577177.559291045
    19
    		2025-03-08 00:00:00.0006883410969345154981606212958.723765297617455.2878167812835.520599613281.469166464.4459768817642.005267926
    20
    		2025-03-09 00:00:00.0006236911593034470586076713160.673138241630615.96095502113031.764905626313.234071431.3133828068073.318650732
    27
    4KB
    466s