DATE | TRANSACTIONS | WMON | ACTION | |
|---|---|---|---|---|
1 | 2025-03-09 00:00:00.000 | 149672 | 591414.920945 | unwrapped |
2 | 2025-03-10 00:00:00.000 | 187598 | 500214.751208 | unwrapped |
3 | 2025-03-10 00:00:00.000 | 452205 | 529359.186818 | wrapped |
4 | 2025-02-21 00:00:00.000 | 12027 | 1018158.815924 | unwrapped |
5 | 2025-03-02 00:00:00.000 | 197893 | 598560.758853 | unwrapped |
6 | 2025-03-03 00:00:00.000 | 393176 | 569773.851838 | wrapped |
7 | 2025-02-26 00:00:00.000 | 1212677 | 985835.236505 | wrapped |
8 | 2025-02-22 00:00:00.000 | 25194 | 841452.981827 | unwrapped |
9 | 2025-03-01 00:00:00.000 | 239865 | 786987.881301 | unwrapped |
10 | 2025-02-23 00:00:00.000 | 279824 | 1422301.785342 | wrapped |
11 | 2025-03-08 00:00:00.000 | 471571 | 502172.094065 | wrapped |
12 | 2025-03-08 00:00:00.000 | 197040 | 489616.598058 | unwrapped |
13 | 2025-02-25 00:00:00.000 | 224789 | 836176.731439 | unwrapped |
14 | 2025-02-19 00:00:00.000 | 10465 | 1412942.100457 | wrapped |
15 | 2025-02-27 00:00:00.000 | 791962 | 884143.07743 | wrapped |
16 | 2025-02-19 00:00:00.000 | 2453 | 1562298.034617 | unwrapped |
17 | 2025-03-01 00:00:00.000 | 454203 | 783095.137795 | wrapped |
18 | 2025-03-04 00:00:00.000 | 163990 | 553642.163481 | unwrapped |
19 | 2025-03-11 00:00:00.000 | 234365 | 461076.40588 | unwrapped |
20 | 2025-03-12 00:00:00.000 | 180932 | 105662.301188 | wrapped |
magwrapping & unwrapping mon - wmon
Updated 8 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
›
⌄
with actions as
(SELECT
a.BLOCK_TIMESTAMP,
a.ORIGIN_FROM_ADDRESS,
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
a.TX_SUCCEEDED = 'TRUE'
and ORIGIN_FUNCTION_SIGNATURE in ('0xd0e30db0','0x2e1a7d4d')
and a.ORIGIN_TO_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and a.CONTRACT_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701')
select
date_trunc('day',block_timestamp) as date,
count(distinct tx_hash) as transactions,
sum(amount) as "WMON",
case
when ORIGIN_FUNCTION_SIGNATURE = '0xd0e30db0' then 'wrapped'
when ORIGIN_FUNCTION_SIGNATURE = '0x2e1a7d4d' then 'unwrapped'
end as action
from actions
where block_timestamp::date >= '2025-02-19 04:00:00'
group by all
Last run: 8 days ago
44
3KB
20s