distinct ETH_TO_ADDRESS,

count(distinct ETH_FROM_ADDRESS) as no_users,

sum(amount) as volume,

avg(amount) as average_volume,

sum (amount_usd) as volume_usd

from gnosis.core.ez_xdai_transfers

where block_timestamp >= current_date - 30

group by 1

order by 2 desc limit 10