SELECT

signer_id,

min(date_trunc('day', block_timestamp)) as create_date

FROM near.social.fact_addkey_events

GROUP BY 1

),

withdraw as (

SELECT

TX_SIGNER,

sum(deposit / power(10, 24)) as total_volume_withdraw

FROM near.core.fact_transfers

GROUP BY 1

),

deposit as (

SELECT

tx_receiver,

sum(deposit / power(10, 24)) as total_volume_deposit

FROM near.core.fact_transfers

GROUP BY 1

),

final as (

SELECT

tx_receiver,

total_volume_deposit - total_volume_withdraw as total_balance

FROM deposit

LEFT OUTER join withdraw

on tx_signer = tx_receiver

WHERE tx_signer in (

SELECT

DISTINCT signer_id

FROM new_near_social_users

WHERE create_date BETWEEN '{{ From_day }}' AND '{{ To_day }}'