aPrioriaPriori User Withdraw Request Action
    Updated 4 days ago
    with token_withdraw_request_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(REPLACE(data, '0x', ''), 1, 64)))/1e18 as shares
    -- ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 65, 64)))/1e18 as assets
    ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 129, 64)))/1e18 as request_amount
    -- ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(LEFT(DATA, 66),3)))/1e18 AS depoist_value
    -- ,SUBSTR(LEFT(DATA, 66),3) as first_half
    Last run: 4 days ago
    STAT_DATE
    WITHDRAW_REQUEST_ADDRESS
    WITHDRAW_REQUEST_AMOUNT
    WITHDRAW_REQUEST_TX_COUNT
    1
    2025-02-19 00:00:00.00015581146.2827611755
    2
    2025-02-20 00:00:00.000827962656.255489386
    3
    2025-02-21 00:00:00.000830723619.3599329844
    4
    2025-02-22 00:00:00.0001135637299.82602414159
    5
    2025-02-23 00:00:00.00014568212453.30910622740
    6
    2025-02-24 00:00:00.0001826840079.64813728668
    7
    2025-02-25 00:00:00.0003462262202.12142354892
    8
    2025-02-26 00:00:00.0006979678385.419107115697
    9
    2025-02-27 00:00:00.0004031757680.17945168615
    10
    2025-02-28 00:00:00.0003741654692.26591759950
    11
    2025-03-01 00:00:00.0003100057214.14662449865
    12
    2025-03-02 00:00:00.0004192057753.18139357413
    13
    2025-03-03 00:00:00.0003193937714.76010844848
    14
    2025-03-04 00:00:00.0003119541857.96132843032
    15
    2025-03-05 00:00:00.0003182326833.21074142219
    16
    2025-03-06 00:00:00.0003654529726.91849147098
    17
    2025-03-07 00:00:00.0004245423188.86406753605
    18
    2025-03-08 00:00:00.0004211943225.76087751468
    19
    2025-03-09 00:00:00.0003990826217.70530949465
    20
    2025-03-10 00:00:00.0004663524562.45584960778
    27
    1KB
    30s