aPriorisensible-blush
    Updated 2025-03-06
    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
    -- ,SUBSTR(REPLACE(data, '0x', ''), 1, 64) as sender
    ,'0x' || UPPER(SUBSTR(REPLACE(data, '0x', ''), 25, 40)) AS sender
    ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 65, 64)))/1e18 as shares
    ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 129, 64)))/1e18 as assets
    -- ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(LEFT(DATA, 66),3)))/1e18 AS depoist_value
    Last run: 13 days ago
    SENDER
    TX_COUNT
    1
    0x25573AF1BAEBE490068A3A57ADF42DFEAC24191C149
    2
    0x8F52F5EAFFA522FFEF4577687041188E34FE8081123
    3
    0x8FC4C1492F10A9310DCD94C2E9A2CB68A3DB7CDC119
    4
    0x06BB6DF0A3956A01240E3D31438633E7D61DD123118
    5
    0x6D2023499622D5E29098BAC54995CFCFEF973CC8116
    6
    0x5D18B6E6D9612341E043961D57D1C74B66DED583110
    7
    0x89A1EBDDF4A8A55F060D1C675A2E01711663E7F2109
    8
    0x9AA439B644273C1E1833C71264BE79D9BA30907C105
    9
    0x07B3172D3D91661C5B9DE297DEE3C091C7FA51CE102
    10
    0xC2B67053AB979812090E586A5F88F72E191B8CAB101
    11
    0x8E2BD737A5909A2B554EDDD430085FECEC96395B90
    12
    0x8DE1CBA1A5B5AAB335BE4E5E97A2DEB6F8D350CA78
    13
    0xA68D066D56FC4F57F86F4AD9748F3E1F2625F95373
    14
    0x7EE6ADD64CF3821167B80BAEBDEBADC3B76C3A3972
    15
    0x5D24EAB5D3BF5742C62A214932D3B37B979F8CFD70
    16
    0x8E8B3A1E230413CACCE34E28CFAC6D50CD751A0E69
    17
    0x173DE563646A934F30C36016734E13D3791A56F868
    18
    0xD81E07E124E20A1D81B4A2CF4D4AB1878D4965E164
    19
    0xBA2AC535E7E283057395CC5CBDC3E8D1F417B77062
    20
    0x6C36188B7CD1FF83C73D9416664261CE4F64A57558
    ...
    50770
    2MB
    5s