TYPE | USERS | |
|---|---|---|
1 | 5. 1K ~ 5K | 33 |
2 | 3. 100 ~ 500 | 23 |
3 | 4. 500 ~ 1K | 14 |
4 | 2. 10 ~ 100 | 55 |
5 | 6. >5K | 62 |
6 | 1. <10 | 62 |
mamad-5XN3k3Avant avUSD (Stakers Distribution)
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
32
33
34
35
36
›
⌄
⌄
with rawt as (
select
'Deposit' as type,
TX_HASH,
BLOCK_TIMESTAMP,
DECODED_LOG:"sender" as user,
DECODED_LOG:"owner" as owner,
DECODED_LOG:"assets"/1e18 as avusd_amount,
DECODED_LOG:"shares"/1e18 as savusd_amount
from avalanche.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = lower('0x06d47f3fb376649c3a9dafe069b3d6e35572219e')
and EVENT_NAME = 'Deposit'
and ORIGIN_FUNCTION_SIGNATURE = '0x6e553f65'
and TX_SUCCEEDED = 'TRUE'
--group by 1,2
union
select
'Withdraw' as type,
TX_HASH,
BLOCK_TIMESTAMP,
DECODED_LOG:"receiver" as user,
DECODED_LOG:"owner" as owner,
DECODED_LOG:"assets"/1e18 as avusd_amount,
DECODED_LOG:"shares"/1e18 as savusd_amount
from avalanche.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = lower('0x06d47f3fb376649c3a9dafe069b3d6e35572219e')
and EVENT_NAME = 'Withdraw'
and ORIGIN_FUNCTION_SIGNATURE = '0x9343d9e1'
and TX_SUCCEEDED = 'TRUE'
--group by 1,2
)
/*select
date_trunc('week',BLOCK_TIMESTAMP) as date,
Last run: about 1 month ago
6
105B
4s