commanderjoseph-761gwXLBGT/WBERA Liquidity Pool
Updated 2024-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
block_timestamp,
origin_from_address,
'0x'||SUBSTR(topics[2], 27, 40) AS liquidity_provider,
utils.udf_hex_to_int(SUBSTR(data, 837, 64))/POW(10, 18) AS lbgt_amount,
utils.udf_hex_to_int(SUBSTR(data, 261, 64))/POW(10, 18) AS token_out_amount,
utils.udf_hex_to_int(SUBSTR(data, 325, 64))/POW(10, 18) AS wbera_out_amount,
tx_hash
FROM
berachain.testnet.fact_event_logs
WHERE
origin_to_address = '0xfdb2925ae2d3e2eacfe927611305e5e56aa5f832'
AND
topics[0] = '0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78'
AND
topics[1] = '0x6acbbedecd914de8295428b4ee51626a1908bb12000000000000000000000010'
AND
tx_succeeded = 'TRUE'
LIMIT
100
QueryRunArchived: QueryRun has been archived