(select date_trunc('day', block_timestamp) as block_day, sum(amount) as USDC_withdraw

from ethereum.udm_events

where symbol = 'USDC' and from_address = '0x40ec5b33f54e0e8a33a975908c5ba1c14e5bbbdf'

group by 1

order by 1 desc),

eth as

(select date_trunc('day', block_timestamp) as block_day, sum(event_inputs:amount/1e18) as ETH_withdraw

from ethereum.events_emitted

where event_name = 'ExitedEther' and contract_address = '0x8484ef722627bf18ca5ae6bcf031c23e6e922b30' --polygon bridge

group by 1

order by 1 desc)

select A.block_day, A.USDC_withdraw, B.ETH_withdraw

from usdc A

join eth B on A.block_day = B.block_day

order by 1 desc