EVENT_NAME | WALLET | N_TRANSACTIONS | TOTAL_AVUSD_AMT | TOTAL_COLL_AMT_USDC | |
|---|---|---|---|---|---|
1 | Mint | 0xbcade668402fbce9af08ebd5012d2a729fbbb9fe | 56 | 6804127 | 6804221.07 |
2 | Mint | 0x2cd78ad719a8c74898c5283f5bc70920d8a061fd | 10 | 2304505 | 2306510 |
3 | Mint | 0x187b6ab771482ccfee7cd2c35176080631082368 | 3 | 1500000 | 1500000 |
4 | Mint | 0x5020c6eb0fe5321071942847b56349a68c7342dd | 4 | 854345.41 | 855000.41 |
5 | Redeem | 0xbcade668402fbce9af08ebd5012d2a729fbbb9fe | 6 | 544900 | 542175.5 |
6 | Mint | 0x23439166feec267f1a66e2815369a02f7b7920c4 | 1 | 500000 | 500000 |
7 | Mint | 0x63e7549ea16f52bcb0415b308f17f3fee6415138 | 3 | 318165.54 | 318415.54 |
8 | Mint | 0xa2e06c19ee14255889f0ec0ca37f6d0778d06754 | 1 | 200000 | 200000 |
9 | Mint | 0x4fbdef91e2c63b5fc4bf3ec002b805b70c79843a | 2 | 199167.16 | 199283.66 |
10 | Mint | 0xeb75f366a6ffe07c0ff12cf5ea01087bddb05dfb | 1 | 149850 | 150000 |
11 | Mint | 0xb5360072a6252bba9844280b24cc00337ed2c551 | 2 | 146838.51 | 146838.51 |
12 | Mint | 0xc638fc731ffd77b17c486f5ae4a85d40ad9db4fc | 6 | 114772.56 | 114772.56 |
13 | Mint | 0x465993dca24e5a95df1f79067c084dbf68804f31 | 2 | 100000 | 100000 |
14 | Mint | 0x247c7b87bfa5c6f1638f83fb988f03b036c0dc55 | 1 | 80170.6 | 80170.6 |
15 | Mint | 0x0e3359c346553aa1304420424f9251c4928f21b4 | 2 | 67722.81 | 67722.81 |
16 | Mint | 0xadd78875b8c993bd138ad2578381887e475361bc | 3 | 53338.51 | 53378.51 |
17 | Mint | 0xdbcb594b62f5aba69a9575da938a93286836228b | 1 | 51631.01 | 51631.01 |
18 | Mint | 0x8dee2dce2e3295d8931382d340e7b3566f258a89 | 3 | 50647.04 | 50697.74 |
19 | Mint | 0x898170d98cba3213399a72b266a39fc93984b54c | 3 | 50105 | 50105 |
20 | Mint | 0x91eb12839003631e3a1550f0b4b59148be822dca | 1 | 50000 | 50000 |
0xHaM-dLeaderboard[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
24
25
26
27
28
29
30
31
›
⌄
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,
user_add as wallet,
count(*) as n_transactions,
round(sum(avusd_amount),2) as total_avusd_amt,
round(sum(collateral_amount_usdc),2) as total_coll_amt_usdc,
from eventTb
group by 1,2
order by 4 desc
limit 100
Last run: 30 days ago
100
7KB
3s