date(block_timestamp) as date,

count(distinct tx_hash) as transactions_count ,

sum(amount) as amount,

sum(amount_usd) as amount_usd,

count(distinct eth_from_address) as wallets_count

from

ethereum.core.ez_eth_transfers

where

(eth_to_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419' or eth_from_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419') and

block_timestamp >= '2022-01-01'

group by date(block_timestamp)

order by date(block_timestamp)