WITH active_users as (

SELECT

count(distinctdate_trunc('week',block_timestamp)) as n_days,

tx_from as users

FROM osmosis.core.fact_transactions

WHERE tx_from is not null

GROUP BY users

having n_days >= {{days}} / 1.75

ORDER BY n_days desc )

SELECT date_trunc('week',block_timestamp) as week,

count(distinct tx_from) as n_DAUs_weekly

FROM osmosis.core.fact_transactions

WHERE tx_from in (select users from active_users)

group by 1