flipside

    Kintsu overview copy
    MrftiKintsu overview copy
    Updated 24 hours ago
    -- forked from Kintsu overview copy @ https://flipsidecrypto.xyz/studio/queries/0147cdf7-b1fa-45bd-a475-80831ca021ac

    -- 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 "Unstaker",
    CAST(ethereum.public.udf_hex_to_int(data) AS decimal) / 1e18 AS "$sMON Burned",
    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 = '0x30af6b2e'
    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 Unstake tx",
    sum ("Total Unstake tx") over (order by date) as "Cumualtive Unstake tx",
    COUNT(DISTINCT "Unstaker") AS "Total unique Unstakers",
    sum ("Total unique Unstakers") over (order by date) as "Cumualtive Unstakers",
    SUM("$sMON Burned") AS "Total $sMON Burned",
    sum ("Total $sMON Burned") over (order by date) as "Cumualtive $sMON Burned",
    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 24 hours agoAuto-refreshes every 12 hours
    DATE
    Total Unstake tx
    Cumualtive Unstake tx
    Total unique Unstakers
    Cumualtive Unstakers
    Total $sMON Burned
    Cumualtive $sMON Burned
    Total fee ($MON)
    Cumualtive fee ($MON)
    1
    		2025-02-18 00:00:00.0002211660.008868780.00886878
    2
    		2025-02-19 00:00:00.000203205151152203.2709209.27091.0359336561.044802436
    3
    		2025-02-20 00:00:00.0007909956588101758.03041967.30133.8215257444.86632818
    4
    		2025-02-21 00:00:00.00069216875561366574.66772541.9693.1324278317.998756011
    5
    		2025-02-22 00:00:00.00027454432191732834113.6224126655.59141212.21759053820.216346549
    6
    		2025-02-23 00:00:00.0005579100113723700620797.06298727452.65439929.06508032649.281426875
    7
    		2025-02-24 00:00:00.00068131682444281143414521.22410241973.87850132.36026480981.641691684
    8
    		2025-02-25 00:00:00.0001723834062111312256524615.06950766588.94800892.758219079174.399910764
    9
    		2025-02-26 00:00:00.0004590379965290345159927223.42689193812.374899382.069731822556.469642585
    10
    		2025-02-27 00:00:00.00053787133752248157641471051.210784164863.585683386.887445289943.357087874
    11
    		2025-02-28 00:00:00.000359111696632914810556224200.972664189064.558347214.5788679811157.935955855
    12
    		2025-03-01 00:00:00.000213401910031455312011517060.913827206125.472174142.8930037311300.828959586
    13
    		2025-03-02 00:00:00.000290772200802272914284418609.249003224734.721177167.1547389671467.983698553
    14
    		2025-03-03 00:00:00.000215102415901691115975519366.17285244100.894027153.0308579131621.014556466
    15
    		2025-03-04 00:00:00.000240512656411924617900130117.71674274218.610767148.1236474721769.138203938
    16
    		2025-03-05 00:00:00.000193942850351429619329719935.35267294153.963437129.8091013011898.947305239
    17
    		2025-03-06 00:00:00.000183593033941329320659013897.580565308051.544002103.868194542002.815499779
    18
    		2025-03-07 00:00:00.000242573276511860522519511395.228886319446.772888144.0844992392146.899999019
    19
    		2025-03-08 00:00:00.000293453569962351524871013274.815973332721.588861168.380741822315.280740839
    20
    		2025-03-09 00:00:00.000262933832892053426924410614.214995343335.803856156.5593463832471.840087221
    30
    3KB
    390s