SELECT
date_trunc('day', block_timestamp) Date,
--origin_from_address,
--amount_in_usd,
platform,
--symbol_in,
COUNT(DISTINCT origin_from_address) No_Of_Active_Users
--event_name
FROM ethereum.defi.ez_dex_swaps
WHERE event_name = 'Swap'AND amount_in_usd IS NOT NULL
AND platform = 'uniswap-v3'
AND DATE(block_timestamp) >= '2023-01-01'
GROUP BY 1,2
ORDER BY 1 DESC
LIMIT 1000