with bridge_ERC20_from_near_to_ethereum as (

select

block_timestamp,

tx_hash::string as tx_hash, (parse_json(trim(args))):amount as asset_amount,

(parse_json(args)):recipient as eth_address

from near.core.fact_actions_events_function_call

where action_name = 'FunctionCall'

and method_name = 'withdraw' -- ERC20 tokens

and args::string like '{"%'

and (parse_json(trim(args))):amount::string is not null

and (parse_json(trim(args))):recipient::string is not null

, bridge_NEAR_from_near_to_ethereum as (

select

block_timestamp,

tx_hash::string as tx_hash,

deposit as asset_amount,

(parse_json(args)):eth_recipient as eth_address

from near.core.fact_actions_events_function_call

where action_name = 'FunctionCall'

and method_name = 'migrate_to_ethereum' -- NEAR

and args::string like '{"%'

and (parse_json(args)):eth_recipient is not null

, bridge_all_from_near_to_ethereum as (

select * from bridge_ERC20_from_near_to_ethereum

union all

select * from bridge_NEAR_from_near_to_ethereum

, join_with_txs as (

select

block_timestamp,

tx_hash, asset_amount, eth_address, TX_RECEIVER as contract_in_near, TX_SIGNER as sender_near_address,

case