siwakondevGetting Started
    Updated 2024-08-12
    SELECT
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    left(input, 10) as function_sig,
    regexp_substr_all(SUBSTR(input, 11), '.{64}') AS segmented,
    utils.udf_hex_to_int(segmented [0] :: string) as value0,
    utils.udf_hex_to_int(segmented [1] :: string) as value1,
    utils.udf_hex_to_int(segmented [2] :: string) as value2,
    utils.udf_hex_to_int(segmented [3] :: string) as value3,
    utils.udf_hex_to_int(segmented [4] :: string) as value4,
    utils.udf_hex_to_int(segmented [5] :: string) as value5,
    -- wei_value / pow(10, 18) as lp_value
    FROM
    berachain.testnet.fact_traces
    WHERE
    tx_hash = '0x460b12be8d64e58515bf6e730525970a04ebf8b0ca32f25028648584b24eff49'
    -- from_address = LOWER('0xAB827b1Cc3535A9e549EE387A6E9C3F02F481B49')
    -- and to_address = LOWER('0x0e4aaf1351de4c0264c5c7056ef3777b41bd8e03') -- token0
    -- and to_address = LOWER('0xd6d83af58a19cd14ef3cf6fe848c9a4d21e5727c') -- token1
    -- and to_address = LOWER('0x8de058ec8f64b60431eb9aaee95c7266d0d5c311') -- worm path
    -- and to_address = LOWER('0x8de058ec8f64b60431eb9aaee95c7266d0d5c311') -- lp contract
    and function_sig != '0x61010060'
    AND tx_succeeded = true
    QueryRunArchived: QueryRun has been archived