COUNT(DISTINCT(TX_HASH)) AS NO_OF_TRANSFERS,

round(SUM(AMOUNT_USD),2) AS TOTAL_AMOUNT_TRANSFERRED,

round(avg(AMOUNT_USD),2) As avg_AMOUNT_TRANSFERRED

FROM gnosis.core.ez_xdai_transfers where

BLOCK_TIMESTAMP >= dateadd(month, -1, getdate())

GROUP BY DAY