AmiRNew swappers
    Updated 2024-10-02
    with t1 as
    (SELECT ORIGIN_FROM_ADDRESS as swapper,
    min(block_timestamp::date) as date
    from arbitrum.defi.ez_dex_swaps
    where platform='camelot-v3'
    GROUP by 1)
    SELECT date,
    count(DISTINCT swapper) as New_swappers
    from t1
    where date >= current_date - 60
    group by 1 ORDER by 1
    QueryRunArchived: QueryRun has been archived