select sum(raw_amount/pow(10,decimals)) as volume ,dayname(block_timestamp)
from
ethereum.core.ez_token_transfers
where
to_address='0xabea9132b05a70803a4e85094fd0e1800777fbef'
and to_date(block_timestamp) > getdate() - interval '60 days' and amount is not null
group by 2