leo-lZzln2Daily Number of Unique Users in Sushiswap & Uniswap
    Updated 2022-10-13
    select 'uniswapv3' as sushi_uni , count(*) as swap , count(distinct RECIPIENT ) as users , BLOCK_TIMESTAMP::date from ethereum.uniswapv3.ez_swaps
    where BLOCK_TIMESTAMP::date >= '2022-01-01'
    group by 4
    UNION

    select 'sushiswap' as sushi_uni , count(*) as swap , count(distinct ORIGIN_FROM_ADDRESS) as users , BLOCK_TIMESTAMP::date from ethereum.sushi.ez_swaps
    where BLOCK_TIMESTAMP::date >= '2022-01-01'
    group by 4
    Run a query to Download Data