aPrioriaPriori_total_TVL v2
    Updated 19 hours ago
    with token_deposit_raw_dwd as (
    select
    BLOCK_TIMESTAMP
    ,TX_HASH
    ,from_address
    ,to_address
    ,depoist_value
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    from (
    select
    BLOCK_NUMBER
    ,BLOCK_TIMESTAMP
    ,TX_HASH
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    ,TOPICS
    ,'0x' || RIGHT(TOPIC_1, 40) as from_address
    ,'0x' || RIGHT(TOPIC_2, 40) as to_address
    ,TOPIC_0
    ,TOPIC_1
    ,TOPIC_2
    ,TOPIC_3
    ,DATA as block_data
    ,ORIGIN_FROM_ADDRESS
    ,ORIGIN_TO_ADDRESS
    ,ORIGIN_FUNCTION_SIGNATURE
    ,TX_SUCCEEDED
    ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(LEFT(DATA, 66),3)))/1e18 AS depoist_value
    from monad.testnet.fact_event_logs
    where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))
    and TX_SUCCEEDED
    and TOPICS[0]='0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7'
    and BLOCK_TIMESTAMP>='2025-02-18 00:00:00.000'
    )
    ),