aPrioriKINTSU_TVL
    Updated 2025-03-13
    with event_logs_dim as
    (
    SELECT
    BLOCK_TIMESTAMP,
    ORIGIN_FROM_ADDRESS,
    tx_hash,
    data,
    ORIGIN_FUNCTION_SIGNATURE
    from monad.testnet.fact_event_logs
    where ORIGIN_FUNCTION_SIGNATURE in ('0x3a4b66f1','0x30af6b2e')
    and TX_SUCCEEDED = 'TRUE'
    and CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
    ),

    lst_deposit_action_dim as
    (
    select
    BLOCK_TIMESTAMP
    ,tx_hash
    ,value as stake_amount
    from monad.testnet.fact_traces
    where tx_hash in (select tx_hash from event_logs_dim group by 1)
    and ORIGIN_FUNCTION_SIGNATURE='0x3a4b66f1'
    and value>0
    ),


    lst_redeem_action_dim as
    (
    select
    BLOCK_TIMESTAMP
    ,tx_hash
    ,CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS redeem_amount
    from event_logs_dim
    where ORIGIN_FUNCTION_SIGNATURE='0x30af6b2e'

    QueryRunArchived: QueryRun has been archived