drone-mostafaUNI tatal
    Updated 2023-05-12
    with base as (SELECT
    ORIGIN_FROM_ADDRESS, min (BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP
    FROM ethereum.core.ez_dex_swaps WHERE PLATFORM LIKE '%uniswap%'
    GROUP by 1)

    SELECT
    count (DISTINCT ORIGIN_FROM_ADDRESS) as New_Users
    FROM base WHERE BLOCK_TIMESTAMP >= current_date -365
    Run a query to Download Data