ramishoowUntitled Query
    Updated 2022-11-16
    SELECT "TIME", count(DISTINCT TRADER) as "Swappers " FROM ( SELECT date_trunc('week', day) as "TIME",
    TRADER, count(*) as actvie_days FROM ( SELECT date_trunc('day', block_timestamp) as day, TRADER
    --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