SELECT tx_hash,

logs,

Split_part(value,'Sending ',2) a,

Try_to_numeric(Split_part(a,' yNEAR',1))/1e24 AS amount,

Split_part(a,'@',2)::string AS receiver

FROM near.core.fact_receipts,

lateral flatten(input => logs) b

WHERE receiver_id = 'multisender.app.near'

AND status_value ilike '%SuccessValue%'

AND logs[0] IS NOT NULL ) , multi_send AS

SELECT a.tx_hash,

tx_signer AS sender,

receiver,

amount

FROM base1 a

JOIN near.core.fact_transactions b

using (tx_hash) ) ,multi_receive AS

SELECT tx_hash,

split_part(value,'Sending ',2) a,

split_part(a,'@',2) AS receiver,

try_to_numeric(split_part(a,' yNEAR',1))/1e24 AS amount

FROM near.core.fact_receipts,

lateral flatten(input => logs) b

WHERE receiver_id = 'multisender.app.near'

AND status_value ilike '%SuccessValue%'

AND logs[0] IS NOT NULL ) , inflowing_txns AS

SELECT tx_hash,

tx_receiver AS receiver,

deposit/1e24 AS amount

FROM near.core.fact_transfers

WHERE status = true ) , trans_send AS