defianalystquickswap- v3 active users
    Updated 2024-09-04
    -- forked from somkene / quickswap- v3 active users @ https://flipsidecrypto.xyz/somkene/q/fslRgPIJFi5a/quickswap--v3-active-users

    SELECT
    date_trunc('day', block_timestamp) AS date,
    platform,
    COUNT(DISTINCT origin_from_address) AS active_users
    FROM polygon.defi.ez_dex_swaps
    WHERE event_name = 'Swap'
    AND amount_in_usd IS NOT NULL
    AND platform = 'quickswap-v3'
    AND DATE(block_timestamp) >= '2023-02-01'
    GROUP BY 1,2
    ORDER BY 1 DESC
    LIMIT 1000


    QueryRunArchived: QueryRun has been archived