count(DISTINCT TRADER) as swappers

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

GROUP BY 1,2

)

GROUP BY 1,2

)

WHERE actvie_days >=4

GROUP BY 1