commanderjoseph-761gwXHoney Withdraw in the last 24hr
Updated 2024-09-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
block_timestamp,
origin_from_address AS withdrawer,
utils.udf_hex_to_int(SUBSTR(data, 3, 64)) /POW(10, 18) AS honey_amount,
utils.udf_hex_to_int(SUBSTR(data, 67, 64)) /POW(10, 18) AS bhoney_amount,
tx_hash
--topics[0]
FROM
berachain.testnet.fact_event_logs
WHERE
origin_to_address = lower('0x1306D3c36eC7E38dd2c128fBe3097C2C2449af64')
AND
topics[0] = '0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db' --WITHDRAW
AND
origin_from_address != '0x0000000000000000000000000000000000000000'
AND
TX_SUCCEEDED = 'TRUE'
AND
block_timestamp > CURRENT_TIMESTAMP - INTERVAL '1 day'
ORDER
BY
1
DESC
QueryRunArchived: QueryRun has been archived