SWAPPERS | BREAKDOWN | |
|---|---|---|
1 | 7549 | 10-50 |
2 | 1080 | 100-500 |
3 | 2033 | 50-100 |
4 | 122061 | <= 10 |
5 | 361 | > 500 |
SniperUsers Breakdown by Sawps
Updated 2025-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with pharaoh as ( select
origin_from_address,
count(DISTINCT TX_HASH) as transactions
from avalanche.defi.ez_dex_swaps
where platform LIKE '%pharaoh%'
GROUP by 1
)
select count(DISTINCT origin_from_address) as swappers,
case when transactions <= 10 then '<= 10'
when transactions <= 50 then '10-50'
when transactions <= 100 then '50-100'
when transactions <= 500 then '100-500'
when transactions > 500 then '> 500' end as breakdown
from pharaoh
group by 2
order by 2 asc
Last run: about 1 month ago
5
80B
2s