TIME | MON amount | WALLET | ACTION | |
|---|---|---|---|---|
1 | 2025-03-10 04:49:49.000 | 0.0003 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Cancel |
2 | 2025-03-09 20:53:53.000 | 0.0003 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Unlock |
3 | 2025-02-23 12:17:20.000 | 121.685 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Unlock |
4 | 2025-02-23 12:16:54.000 | 1.9891 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Cancel |
5 | 2025-02-23 12:16:44.000 | 119.6962 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Cancel |
6 | 2025-02-23 12:00:52.000 | 119.6962 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Unlock |
7 | 2025-02-22 16:48:32.000 | 1.9891 | 0x71ec32542461f77d82f73fe99df4c5735f7105d6 | Unlock |
bgbz-8j1pHvGet unlock all unlock_requests/cancels during
Updated 7 days ago
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
›
⌄
with actions as (
SELECT
a.BLOCK_TIMESTAMP,
LOWER(a.ORIGIN_FROM_ADDRESS) AS wallet,
CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS amount,
a.tx_hash,
a.ORIGIN_FUNCTION_SIGNATURE
from
monad.testnet.fact_event_logs a
where
ORIGIN_FUNCTION_SIGNATURE in ('0x30af6b2e', '0x1610247b')
and a.CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
and wallet = '0x71ec32542461f77d82f73fe99df4c5735f7105d6'
)
select
block_timestamp as time,
amount as "MON amount",
wallet,
case
when ORIGIN_FUNCTION_SIGNATURE = '0x30af6b2e' then 'Unlock'
when ORIGIN_FUNCTION_SIGNATURE = '0x1610247b' then 'Cancel'
end as action
from
actions
order by
TIME desc
Last run: 7 days ago
7
629B
39s