WITH daily_active_traders AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS TradeDate,
COUNT(DISTINCT origin_from_address) AS TotalActiveTraders
FROM
polygon.defi.ez_dex_swaps
WHERE
platform = 'quickswap-v3'
AND block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)
GROUP BY
TradeDate
)
SELECT
AVG(TotalActiveTraders) AS AvgActiveTradersPerDay
FROM
daily_active_traders;