AnalyticSagesoptimism-total-users-over-time
    Updated 2024-04-15
    SELECT
    date_trunc('day', block_timestamp) as date,
    COUNT(DISTINCT origin_from_address) as total_users

    FROM optimism.defi.ez_dex_swaps
    WHERE date(block_timestamp) >= '2024-01-01'
    GROUP BY 1
    ORDER BY 1 DESC


    QueryRunArchived: QueryRun has been archived