(

select block_timestamp,

tx_hash as tx_id,

parse_json(actions):"receipt":"Action":"actions"[0]:"Transfer":"deposit" /pow(10,24) as amount,

parse_json(actions):"receipt":"Action":"signer_id" as sender,

parse_json(actions):"receiver_id" as reciever

from near.core.fact_receipts

where 1=1

-- and tx_hash='BSudcmqufUaHRZcvPqdgexGHYBM7xrfDC9JF7uHy6wAy'

and sender = '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558'

and reciever!='79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558'

and RECEIVER_ID !='metricsdao.multisafe.near'

and amount is not null

),

near_txns_in as

(

select block_timestamp,

tx_hash as tx_id,

parse_json(actions):"receipt":"Action":"actions"[0]:"Transfer":"deposit" /pow(10,24) as amount,

parse_json(actions):"receipt":"Action":"signer_id" as sender,

parse_json(actions):"receiver_id" as reciever

from near.core.fact_receipts

where 1=1

-- and tx_hash='BSudcmqufUaHRZcvP̦qdgexGHYBM7xrfDC9JF7uHy6wAy'

and reciever = '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558'

-- and sender!='79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558'

-- and RECEIVER_ID ='metricsdao.multisafe.near'

and amount is not null

select sum(amount) from near_txns_in

union

select sum(amount) from near_txns_out