mcfemi6MONTHLY ACTIVE USERS ON UNISWAP (V3)
    Updated 2022-11-17
    SELECT date_trunc('month', block_timestamp) as Month, PLATFORM, COUNT(DISTINCT TX_HASH) AS TRANSACTIONs, COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS USERS
    FROM ETHEREUM.core.ez_dex_swaps
    Where platform = 'uniswap-v3' and event_name = 'Swap' and Month >=CURRENT_DATE - Interval '1 year'
    GROUP BY 1, 2
    ORDER BY 1 DESC
    Run a query to Download Data