flipside

    Daily Active User 5
    jackguyDaily Active User 5
    Updated 2022-10-16
    SELECT
    date_trunc('week', block_timestamp) as week,
    project_name,
    count(DISTINCT trader) as actvie_users
    FROM osmosis.core.fact_swaps
    LEFT outer JOIN osmosis.core.dim_labels
    ON to_currency = address
    GROUP BY 1,2
    Run a query to Download Data