jackguyss swaps 4
Updated 2023-10-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
›
⌄
with tab1 as (
SELECT
SWAPPER,
count(DISTINCT date(block_timestamp)) as active_days,
count(DISTINCT TX_ID) as swaps
from sei.defi.fact_dex_swaps
where platform LIKE 'seaswap'
--LIMIT 100
GROUP by 1
)
SELECT
case when swaps = 1 then 'a/ 1 Swaps'
when swaps <= 5 then 'b/ 2 - 5 Swaps'
when swaps <= 10 then 'c/ 5 - 10 Swaps'
when swaps <= 25 then 'd/ 10 - 25 Swaps'
when swaps <= 50 then 'e/ 25 - 50 Swaps'
else 'f/ 50+ Swaps' end as swaps,
count(*) as users
FROM tab1
group BY 1
Run a query to Download Data