Ali3NBenqi Stakers Distribution By Loyalty Status (Avalanche's Benqi vs Aptos's Amnis)
Updated 2025-02-22
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 Staket as (
select distinct origin_from_address
from avalanche.core.ez_decoded_event_logs
where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
and event_name ilike 'Submitted'
group by 1),
Unstaket as (
select distinct origin_from_address
from avalanche.core.ez_decoded_event_logs
where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
and event_name ilike 'Redeem'
group by 1
union all
select distinct origin_from_address
from avalanche.core.ez_decoded_event_logs
where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
and event_name ilike 'UnlockRequested'
group by 1),
Staket1 as (
select distinct sender
from aptos.core.fact_events t1 join aptos.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash
where t1.event_resource in ('MintEvent')
and t1.event_module = 'stapt_token'
and t1.payload_function like '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a%'
group by 1),
Unstaket1 as (
select distinct sender
from aptos.core.fact_events t1 join aptos.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash
where t1.event_resource in ('BurnEvent')
and t1.event_module = 'stapt_token'
and t1.payload_function like '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a%'
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived