-- 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