WITH transfer_data AS (

SELECT

tx_hash,

block_timestamp,

tx_signer AS sender_address,

tx_receiver AS receiver_address,

deposit / POW(10, 24) AS transfer_amount

FROM

near.core.fact_transfers

),

sender AS (

SELECT

sender_address,

SUM(transfer_amount) AS total_sent

FROM

transfer_data

GROUP BY

sender_address

),

receiver AS (

SELECT

receiver_address,

SUM(transfer_amount) AS total_received

FROM

transfer_data

GROUP BY

receiver_address

),

transfer_summary AS (

SELECT

COALESCE(r.receiver_address, s.sender_address) AS address,