siwakondevGetting Started
Updated 2024-08-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
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