from ethereum.core.fact_event_logs

where

event_inputs:to='0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3'

or event_inputs:to='0x19b3eb3af5d93b77a5619b047de0eed7115a19e7'

group by 1

UNION

select date_trunc('week', block_timestamp),sum(event_inputs:value/pow(10,18)) ,'outflow'

from ethereum.core.fact_event_logs

where

event_inputs:from='0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3'

or event_inputs:from='0x19b3eb3af5d93b77a5619b047de0eed7115a19e7'

group by 1