HadisehDaily Active User 5
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tb as ( SELECT date(block_timestamp) as date,
project_name,
count(DISTINCT trader) as total_user
FROM osmosis.core.fact_swaps
LEFT outer JOIN osmosis.core.dim_labels
ON to_currency = address
GROUP BY date, project_name)
SELECT project_name, avg(total_user) as users
FROM tb
GROUP BY project_name
ORDER by users DESC
LIMIT 5
Run a query to Download Data