web3senseiActive Users in September
    Updated 2024-09-29
    SELECT
    date_trunc('day', block_timestamp) AS date,
    platform,
    COUNT(DISTINCT origin_from_address) AS active_users
    FROM polygon.defi.ez_dex_swaps
    WHERE event_name = 'Swap'
    AND amount_in_usd IS NOT NULL
    AND platform = 'balancer'
    AND DATE(block_timestamp) >= '2021-07-01'
    GROUP BY 1,2
    ORDER BY 1 DESC
    LIMIT 35


    QueryRunArchived: QueryRun has been archived