TX_COUNT | MINTS_COUNT | REDEEMS_COUNT | TOTAL_USERS | MINTERS_COUNT | REDEEMERS_COUNT | COLLATERAL_MINT | COLLATERAL_REDEEM | AVUSD_MINT | AVUSD_REDEEM | NET_COLLATERAL | NET_AVUSD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 554 | 504 | 50 | 252 | 250 | 43 | 13363212.509009 | 403660.762252 | 13360682.638913 | 405689.208292 | 12959551.746757 | 12954993.430621 |
elsinaTotal
Updated 2025-03-09
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
›
⌄
with base as (
select
event_name,
block_timestamp,
tx_hash,
decoded_log:"benefactor" as users,
decoded_log:"collateral_amount"/pow(10,6) as collateral,
decoded_log:"avusd_amount"/pow(10,18) as mint_amount
from avalanche.core.ez_decoded_event_logs
where
contract_address = '0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51' and
event_name in ('Mint', 'Redeem') and
tx_succeeded = 'TRUE'
)
select
count(distinct tx_hash) as tx_count,
count(distinct iff(event_name = 'Mint', tx_hash, null)) as mints_count,
count(distinct iff(event_name = 'Redeem', tx_hash, null)) as redeems_count,
count(distinct users) as total_users,
count(distinct iff(event_name = 'Mint', users, null)) as minters_count,
count(distinct iff(event_name = 'Redeem', users, null)) as redeemers_count,
sum(iff(event_name = 'Mint', collateral, 0)) as collateral_mint,
sum(iff(event_name = 'Redeem', collateral, 0)) as collateral_redeem,
sum(iff(event_name = 'Mint', mint_amount, 0)) as avusd_mint,
sum(iff(event_name = 'Redeem', mint_amount, 0)) as avusd_redeem,
collateral_mint - collateral_redeem as net_collateral,
avusd_mint - avusd_redeem as net_avusd,
from base
Last run: about 2 months ago
1
117B
3s