Alexaydau
Updated 2022-10-19
9
1
2
3
4
5
6
7
8
›
⌄
SELECT week, count(distinct tx_from) as dau
from ( SELECT distinct tx_from, date_trunc('week',block_timestamp) as week, count(distinct date_trunc('day',block_timestamp)) as days
from osmosis.core.fact_transactions
group by tx_from, week)
where days>4
group by 1
order by 1
Run a query to Download Data