SELECT week,
count(DISTINCT TRADER)
FROM ( SELECT
date_trunc('week', day) as week,
TRADER,
count(*) as actvie_days
FROM ( SELECT
date_trunc('day', block_timestamp) as day,
TRADER
FROM
osmosis.core.fact_swaps
where
block_timestamp >= '2022-01-01'
GROUP BY 1,2
)
GROUP BY 1,2
)
WHERE
actvie_days >= 4 GROUP BY 1