date_trunc('day', block_timestamp) date,

COUNT(DISTINCT origin_from_address) Users

--platform,

--symbol_in,

--amount_in,

--amount_in_usd,

--tx_hash

--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 >= '2023-01-01'

GROUP BY

1

ORDER BY 1 DESC

LIMIT 1000