flipside

    Kintsu: stake vs unstake copy
    MrftiKintsu: stake vs unstake copy
    Updated 21 hours ago
    -- forked from Kintsu: stake vs unstake @ https://flipsidecrypto.xyz/studio/queries/e088db1c-01bc-4256-ba88-d61de9b4a223

    WITH stake_data AS (
    SELECT
    DATE_TRUNC(DAY, a.BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT a.TX_HASH) AS "Total stake tx",
    COUNT(DISTINCT a.ORIGIN_FROM_ADDRESS) AS "Total unique stakers",
    SUM(b.value) AS "Total $MON staked",
    SUM(CAST(ethereum.public.udf_hex_to_int(a.data) AS decimal) / 1e18) AS "Total $gMON minted",
    SUM(b.tx_fee) AS "Total 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'
    GROUP BY 1
    ),

    unstake_data AS (
    SELECT
    DATE_TRUNC(DAY, a.BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT a.TX_HASH) AS "Total Unstake tx",
    COUNT(DISTINCT a.ORIGIN_FROM_ADDRESS) AS "Total unique Unstakers",
    SUM(CAST(ethereum.public.udf_hex_to_int(a.data) AS decimal) / 1e18) AS "Total $gMON Burned",
    SUM(b.tx_fee) AS "Total 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'
    GROUP BY 1
    )

    SELECT
    Last run: about 21 hours agoAuto-refreshes every 12 hours
    DATE
    Total stake tx
    Total unique stakers
    Total $MON staked
    Total Unstake tx
    Total unique Unstakers
    Total $gMON Burned
    1
    		2025-02-13 00:00:00.00013160-2-1-11
    2
    		2025-02-14 00:00:00.000210.4000
    3
    		2025-02-15 00:00:00.000311.562681256000
    4
    		2025-02-17 00:00:00.000310.0568893537000
    5
    		2025-02-18 00:00:00.0001165.766413129-6-5-52.61
    6
    		2025-02-19 00:00:00.00022301814970.560050751-290-170-165.145299
    7
    		2025-02-20 00:00:00.0001897514684138304.28769717-4532-3302-42733.426405
    8
    		2025-02-21 00:00:00.0002325516303134449.214741115-6013-4078-26586.273358
    9
    		2025-02-22 00:00:00.000300181602171015.110258375-9093-4276-69626.57356
    10
    		2025-02-23 00:00:00.0005698524264173345.990192104-22168-6192-204578.950048
    11
    		2025-02-24 00:00:00.0008121527368879131.976593285-40056-8072-865339.022324
    12
    		2025-02-25 00:00:00.00016629356651823904.208628179-70540-16771-820836.860509
    13
    		2025-02-26 00:00:00.000332598137801695311.640090216-153318-33018-677004.354002
    14
    		2025-02-27 00:00:00.000284587117452182835.436493318-137655-25953-166058.600286
    15
    		2025-02-28 00:00:00.000299374123842461458.137503742-176633-52834-445679.779837
    16
    		2025-03-01 00:00:00.00020011189987210635.593224522-87561-27379-198035.358723
    17
    		2025-03-02 00:00:00.00022487199932298297.689745875-119240-39657-315313.299576
    18
    		2025-03-03 00:00:00.00017467810430075596.228214222-70807-35954-76385.565082
    19
    		2025-03-04 00:00:00.000180844102108106732.544760825-100929-52273-107660.16987
    20
    		2025-03-05 00:00:00.000191376118851117187.122761389-98488-57172-84125.685673
    33
    3KB
    212s