aPrioriaprMON Stat
    Updated 19 hours ago
    with token_transfer_raw_dwd as
    (
    select
    BLOCK_TIMESTAMP
    ,TX_HASH
    ,from_address
    ,to_address
    ,transfer_value/1e18 as transfer_value
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    from
    (
    select
    BLOCK_NUMBER
    ,BLOCK_TIMESTAMP
    ,TX_HASH
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    ,TOPICS
    ,'0x' || RIGHT(TOPICS[1], 40) as from_address
    ,'0x' || RIGHT(TOPICS[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(DATA, 3))) AS transfer_value
    from monad.testnet.fact_event_logs
    where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))
    and TX_SUCCEEDED
    -- and TX_HASH='0x11376bfba87753d01faa55b94da60c098cb8353dc050e7474f3f1c8061282d6d'
    and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'