jackguyss swaps 3
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
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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 active_days = 1 then 'a/ 1 Day'
when active_days <= 5 then 'b/ 2 - 5 Days'
when active_days <= 10 then 'c/ 5 - 10 Days'
when active_days <= 25 then 'd/ 10 - 25 Days'
when active_days <= 50 then 'e/ 25 - 50 Days'
else 'f/ 50+ Days' end as active_days,
count(*) as users
FROM tab1
group BY 1
Run a query to Download Data