bera-terminalget lp from usercmd copy copy
Updated 2024-09-09
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH relevant_txs AS (
SELECT
DISTINCT tx_hash,
left(input, 10) as function_sig
FROM
berachain.testnet.fact_traces
WHERE
to_address = LOWER('{{lp_address}}')
AND tx_succeeded = true
AND block_timestamp > '2024-06-12'
AND function_sig != '0x095ea7b3'
LIMIT
10
), token_transfers AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
utils.udf_hex_to_int(
CASE
WHEN to_address = LOWER('{{lp_address}}') THEN regexp_substr_all(SUBSTR(input, 11), '.{64}') [4]
ELSE COALESCE(
NULLIF(
regexp_substr_all(SUBSTR(input, 11), '.{64}') [2],
''
),
regexp_substr_all(SUBSTR(input, 11), '.{64}') [1]
)
END :: string
) as token_value
FROM
berachain.testnet.fact_traces
WHERE
tx_hash IN (
SELECT
QueryRunArchived: QueryRun has been archived