Afonso_Diaz2023-09-09 11:04 PM
Updated 2023-09-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
›
⌄
with t as (
select
tx_hash,
block_timestamp,
liquidity_provider as user
from ethereum.uniswapv3.ez_lp_actions
),
t2 as (
select
user,
count(distinct tx_hash) as transactions
from t
group by 1
)
select
case
when transactions = 1 then '1 Transaction'
when transactions <= 5 then '2 - 5 Transactions'
when transactions <= 10 then '6 - 15 Transactions'
when transactions <= 15 then '16 - 25 Transactions'
when transactions <= 20 then '26 - 50 Transactions'
else 'More than 50 Transactions'
end as type,
count(distinct user) as users
from t2
group by 1
order by users desc
Run a query to Download Data