TOTAL_MINT_TRANSACTIONS | TOTAL_BURN_TRANSACTIONS | TOTAL_MINTERS | TOTAL_BURN_USERS | TOTAL_MUSD_MINTED | TOTAL_MUSD_BURNT | CURRENT_SUPPLY | MINIMUM_MUSD_MINTED | MAXIMUM_MUSD_MINTED | |
|---|---|---|---|---|---|---|---|---|---|
1 | 5601 | 20 | 4657 | 12 | 139153831.056179 | 126022.46195 | 139027808.594229 | 0 | 10000000 |
pepperatzi$mUSD Metrics on Mezo Testnet
Updated 2025-04-11
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
32
33
34
35
36
›
⌄
with mints as (
select
block_timestamp,
tx_hash,
'MINT' as event,
'0x' || substr(topic_2, 27) as minter,
livequery.utils.udf_hex_to_int(data) / '1e18' as musd
from mezo.testnet.fact_event_logs
where topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topic_1 = '0x0000000000000000000000000000000000000000000000000000000000000000'
and contract_address = lower('0x637e22A1EBbca50EA2d34027c238317fD10003eB')
),
burn as (
select
block_timestamp,
tx_hash,
'BURN' as event,
'0x' || substr(topic_1, 27) as minter,
livequery.utils.udf_hex_to_int(data) / '1e18' as musd
from mezo.testnet.fact_event_logs
where topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topic_2 = '0x0000000000000000000000000000000000000000000000000000000000000000'
and contract_address = lower('0x637e22A1EBbca50EA2d34027c238317fD10003eB')
),
combined as (
select * from mints
union all
select * from burn
)
select
count(distinct case when event = 'MINT' then tx_hash end) as total_mint_transactions,
count(distinct case when event = 'BURN' then tx_hash end) as total_burn_transactions,
count(distinct case when event = 'MINT' then minter end) as total_minters,
count(distinct case when event = 'BURN' then minter end) as total_Burn_users,
sum(case when event = 'MINT' then musd end) as total_mUSD_minted,
Last run: 15 days ago
1
77B
6s