EVENT_NAME | N_TRANSACTIONS | N_USERS | TOTAL_COLLAT_AMOUNT_USDC | TOTAL_AVUSD_AMOUNT | |
|---|---|---|---|---|---|
1 | Mint | 552 | 280 | 14438624.271442 | 14435018.989583 |
2 | Redeem | 56 | 47 | 605661.312568 | 608704.83675 |
0xHaM-dTotal by Action[Mint/Redeem]
Updated 2025-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with eventTb as (
select
EVENT_NAME,
BLOCK_TIMESTAMP,
TX_HASH,
DECODED_LOG,
DECODED_LOG:beneficiary::string as user_add,
DECODED_LOG:collateral_amount::float/1e6 as collateral_amount_usdc,
DECODED_LOG:avusd_amount::float/1e18 as avusd_amount,
from avalanche.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51'
and EVENT_NAME in ('Mint', 'Redeem')
and TX_SUCCEEDED = TRUE
)
select
EVENT_NAME,
-- teunc(BLOCK_TIMESTAMP, 'd') as date,
count(*) as n_transactions,
count(distinct user_add) as n_users,
sum(collateral_amount_usdc) as total_collat_amount_usdc,
sum(avusd_amount) as total_avusd_amount,
from eventTb
group by 1
Last run: 12 days ago
2
94B
2s