block_timestamp::date as day,

sum(amount) as amount_bnb

from bsc.core.ez_bnb_transfers

where bnb_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

or bnb_from_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

group by day