Hessishkintsu tvl
    Updated 2025-04-16
    with stk as

    (select
    a.BLOCK_TIMESTAMP,
    a.ORIGIN_FROM_ADDRESS,
    value as amount,
    CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS mint_amount,
    a.tx_hash
    from monad.testnet.fact_event_logs a
    join monad.testnet.fact_traces b
    on a.tx_hash = b.tx_hash
    where a.block_timestamp >= '2025-02-19 19:00:00.000' and
    a.ORIGIN_FUNCTION_SIGNATURE = '0x3a4b66f1'
    and a.TX_SUCCEEDED = 'TRUE'
    and a.ORIGIN_TO_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
    and a.CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'


    union


    select
    a.BLOCK_TIMESTAMP,
    a.ORIGIN_FROM_ADDRESS,
    value as amount,
    CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS mint_amount,
    a.tx_hash
    from monad.testnet.fact_event_logs a
    join monad.testnet.fact_traces b
    on a.tx_hash = b.tx_hash
    and a.ORIGIN_FROM_ADDRESS = b.FROM_ADDRESS
    where a.block_timestamp >= '2025-02-19 19:00:00.000' and
    a.ORIGIN_FUNCTION_SIGNATURE = '0x1c3477dd'
    and a.TX_SUCCEEDED = 'TRUE'
    and a.ORIGIN_TO_ADDRESS = '0xe1d2439b75fb9746e7bc6cb777ae10aa7f7ef9c5'
    Last run: 3 months ago
    TIME
    TVL
    1
    2025-04-15 00:00:00.000664997.819209449
    2
    2025-04-14 00:00:00.000653751.901009386
    3
    2025-04-13 00:00:00.000643847.756383798
    4
    2025-04-12 00:00:00.000634560.430938567
    5
    2025-04-11 00:00:00.000621823.266576163
    6
    2025-04-08 00:00:00.000615776.498250725
    7
    2025-04-07 00:00:00.000611068.255455484
    8
    2025-04-06 00:00:00.000605389.256505748
    9
    2025-04-05 00:00:00.000598953.584038351
    10
    2025-04-04 00:00:00.000592815.495171397
    11
    2025-04-03 00:00:00.000585238.985423589
    12
    2025-04-02 00:00:00.000578458.787634703
    13
    2025-04-01 00:00:00.000562975.667685522
    14
    2025-03-31 00:00:00.000554336.232784284
    15
    2025-03-30 00:00:00.000549077.14940885
    16
    2025-03-29 00:00:00.000542397.17422344
    17
    2025-03-28 00:00:00.000536668.520983896
    18
    2025-03-27 00:00:00.000527180.85215138
    19
    2025-03-26 00:00:00.000508661.094887126
    20
    2025-03-25 00:00:00.000494534.50666838
    54
    2KB
    186s