0xtollexActive users
    Updated 2024-02-22
    SELECT
    DATE_TRUNC(month,block_timestamp) date,
    --origin_to_address,
    --Platform,
    COUNT(DISTINCT origin_from_address) Active_user
    --symbol_in,
    --amount_in_usd

    FROM optimism.defi.ez_dex_swaps

    WHERE
    --AND platform = 'uniswap-v3'
    event_name = 'Swap'
    AND amount_in_usd IS NOT NULL
    AND DATE(block_timestamp) >= '2023-01-01'

    GROUP BY 1
    ORDER BY 1 DESC
    LIMIT 1000
    QueryRunArchived: QueryRun has been archived