date_trunc('day', block_timestamp) as date,

sum(abs(amount1_usd)) as volume

FROM ethereum.uniswapv3.ez_swaps

WHERE date(block_timestamp) >= CURRENT_DATE - INTERVAL '90 Days'

AND amount1_usd IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC