TO_CHAR(block_timestamp, 'YYYY-MM-DD') AS Date,

symbol,

sum(amount_usd) as Volume_USD,

count(distinct from_address) as Unique_User,

count(distinct tx_hash) as transactions

from ethereum.core.ez_token_transfers

where block_timestamp > current_date - 120

and symbol in ('USDC', 'USDT', 'DAI')

group by 1,2