dannyamahArbitrum Active Users Over Time
    Updated 2024-03-13
    SELECT
    DATE_TRUNC(day, block_timestamp) AS date,
    COUNT(DISTINCT origin_from_address) AS Active_Users
    FROM arbitrum.defi.ez_dex_swaps
    WHERE amount_in_usd IS NOT NULL
    AND date(block_timestamp) >= '2023-02-22'
    GROUP BY 1
    ORDER BY 1 DESC
    LIMIT 1000
    QueryRunArchived: QueryRun has been archived