with crosschain_activity as (

tx_hash,

block_timestamp::date as day,

decoded_log:depositor::string as actor,

decoded_log:token::string as token_contract,

decoded_log:amount/pow(10,decimals) as amount,

symbol as token_symbol,

'Deposit'as action,

'BSC' as chain

from bsc.core.ez_decoded_event_logs l

inner join bsc.core.dim_contracts c on c.address = l.decoded_log:token

where event_name = 'Deposit'

and contract_address = '0xf1f25a26499b023200b3f9a30a8ecee87b031ee1'

and origin_function_signature = '0x6e553f65'

UNION all

tx_hash,

block_timestamp::date as day,

decoded_log:from::string as actor,

contract_address::string as token_contract,

decoded_log:value/pow(10,decimals) as amount,

symbol as token_symbol,

'Deposit'as action,

'Polygon' as chain

from polygon.core.ez_decoded_event_logs l

inner join polygon.core.dim_contracts c on c.address = l.contract_address

where event_name = 'Transfer'

and contract_address = '0xc2132d05d31c914a87c6611c10748aeb04b58e8f'

and origin_function_signature = '0x9583e13c'

and decoded_log:to = '0x9b5a073e16738d567ff11eb1b75d6541c47b6ff7'