date(block_timestamp) as day,

COUNT(DISTINCT tx_hash) as no_of_txns,

COUNT(DISTINCT ETH_FROM_ADDRESS) as no_of_users,

round(

sum(amount),

2

) as tot_eth_volume,

round(

sum(amount_usd),

2

) as tot_eth_volume_usd,

round(

avg(amount),

2

) as avg_eth_volume,

round(

avg(amount_usd),

2

) as avg_eth_volume_usd

FROM

ethereum.core.ez_eth_transfers

WHERE

day >= dateadd(

month,

-1,

getdate()

)

and amount > 0

and amount_usd > 0

GROUP by

day

ORDER by

day desc