DATE(block_timestamp) AS date,

SUM(value) AS total_avax_transferred

FROM

avalanche.core.fact_transactions

GROUP BY

date

ORDER BY

date;