SniperAverage Weekly Osmosis Swappers
Updated 2022-10-18
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
›
⌄
WITH
Q1 as (
SELECT
date_trunc('day', block_timestamp) as day,
TRADER
FROM osmosis.core.fact_swaps
GROUP BY day,TRADER
),
Q2 As(
SELECT
date_trunc('week', day) as week,
TRADER,
count(*) as actvie_days
From Q1
GROUP BY week,TRADER
),
Q3 As (
select
week,
count(DISTINCT TRADER) as users_per_week
from Q2
WHERE actvie_days >= 4
Group by week
)
select
avg(users_per_week) As AvrageUserPeerWeek,
max(users_per_week) As MaxUserPeerWeek
FROM Q3
Run a query to Download Data