SELECT

trunc(block_timestamp,'{{granularity}}') as date,

COUNT(DISTINCT tx_hash) as transfers,

sum(transfers) over (order by date) as cum_transfers,

sum(amount) as amounts,

sum(amounts) over (order by date) as cum_volume,

avg(amount) as avg_transfer_amount

FROM avalanche.core.ez_avax_transfers

WHERE block_timestamp>='2023-01-22'

GROUP BY 1