USERS_COUNT | SWAP_COUNT | |
|---|---|---|
1 | 5968 | 1-5 |
2 | 556 | >10 |
3 | 23615 | 1 |
4 | 550 | 5-10 |
hrst79users dist
Updated 2025-04-01
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
›
⌄
with base as (
select
DISTINCT from_address as users,
count(DISTINCT tx_hash) as swaps
from
ink.core.fact_transactions
where
TO_ADDRESS = '0x5839389261d1f38aac7c8e91dcda85646becb414'
group by
1
)
select
count (users) as users_count,
case
when swaps = 1 then '1'
when swaps > 1
and swaps <= 5 then '1-5'
when swaps > 5
and swaps <= 10 then '5-10'
else '>10'
end as swap_count
from
base
group by
2
Last run: 24 days ago
4
51B
2s