Staking Size | Number of Staking | |
|---|---|---|
1 | 10-100 KAITO | 9165 |
2 | 1-10 KAITO | 7449 |
3 | 100-1k KAITO | 3066 |
4 | <= 1 KAITO | 983 |
5 | 1k-10k KAITO | 843 |
6 | > 10k KAITO | 220 |
Eman-RazDistribution of Transactions By Staking Volume
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select tx_hash, case
when amount<=1 then '<= 1 KAITO'
when amount>1 and amount<=10 then '1-10 KAITO'
when amount>10 and amount<=100 then '10-100 KAITO'
when amount>100 and amount<=1000 then '100-1k KAITO'
when amount>1000 and amount<=10000 then '1k-10k KAITO'
when amount>10000 then '> 10k KAITO'
end as "Staking Size"
from base.core.ez_token_transfers
where origin_function_signature='0x6e553f65' and origin_to_address='0x548d3b444da39686d1a6f1544781d154e7cd1ef7'
and contract_address='0x98d0baa52b2d063e780de12f615f963fe8537553' and from_address=origin_from_address
and origin_to_address=to_address and symbol='KAITO')
select "Staking Size", count(distinct tx_hash) as "Number of Staking"
from tab1
group by 1
order by 2 desc
Last run: 5 days ago
6
125B
31s