aPriorishMonad_TVL
    Updated 5 days ago
    -- with stake_event_logs_dim as
    -- (
    SELECT
    tx_hash,
    ORIGIN_FUNCTION_SIGNATURE
    from monad.testnet.fact_event_logs
    where TX_SUCCEEDED
    -- and ORIGIN_FUNCTION_SIGNATURE = '0xd5575982'
    -- and ORIGIN_TO_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'
    and CONTRACT_ADDRESS =lower('0x3a98250F98Dd388C211206983453837C8365BDc1')
    and tx_hash='0x8233b4967fa7706c70c75b77704f0d6742666e7a9296b06e1d32e9eb76833c78'
    group by 1,2
    -- )

    -- lst_deposit_action_dim as
    -- (
    -- select
    -- BLOCK_TIMESTAMP
    -- ,FROM_ADDRESS
    -- ,TO_ADDRESS
    -- ,tx_hash
    -- ,value as stake_amount
    -- from monad.testnet.fact_traces
    -- -- where tx_hash in (select tx_hash from stake_event_logs_dim where ORIGIN_FUNCTION_SIGNATURE='0xd5575982')
    -- where tx_hash in (select tx_hash from stake_event_logs_dim group by 1 )
    -- and TO_ADDRESS=lower('0x3a98250F98Dd388C211206983453837C8365BDc1')
    -- and value>0
    -- ),



    -- lst_redeem_action_dim as
    -- (
    -- select
    -- BLOCK_TIMESTAMP
    -- ,FROM_ADDRESS
    Last run: 5 days ago
    No Data to Display
    0
    2B
    13s