SUM(amount) AS daily_volume

FROM ethereum.core.fact_token_transfers

GROUP BY DATE(timestamp)

ORDER BY DATE(timestamp);