LABEL | VALUE | |
|---|---|---|
1 | total_wrapped | 19169864.195171 |
2 | total_unwrapped | 20217414.373357 |
mag$WMON to Unwrapped $MON Ratio
Updated 6 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
27
28
29
30
31
›
⌄
SELECT
'total_wrapped' as label,
SUM(CASE WHEN a.origin_function_signature = '0xd0e30db0' THEN CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 ELSE 0 END) AS value
from
monad.testnet.fact_event_logs a
join
monad.testnet.fact_transactions t
on
a.tx_hash = t.tx_hash
where
a.TX_SUCCEEDED = 'TRUE'
and a.ORIGIN_TO_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and a.CONTRACT_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and a.block_timestamp::date >= '2025-02-19 04:00:00'
union all
SELECT
'total_unwrapped' as label,
SUM(CASE WHEN a.origin_function_signature = '0x2e1a7d4d' THEN CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 ELSE 0 END) AS value
from
monad.testnet.fact_event_logs a
join
monad.testnet.fact_transactions t
on
a.tx_hash = t.tx_hash
where
a.TX_SUCCEEDED = 'TRUE'
and a.ORIGIN_TO_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and a.CONTRACT_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and a.block_timestamp::date >= '2025-02-19 04:00:00'
Last run: 6 days ago
2
71B
35s