SELECT

block_timestamp::date AS date,

amount,

tx_to AS recipient,

tx_from AS sender

FROM

solana.core.fact_transfers

WHERE

mint = '{{BERT_MINT_ADDRESS}}'

),

wallet_daily_amounts AS (

SELECT

wallet,

date,

SUM(amount) AS net_amount

FROM (

SELECT

date,

recipient AS wallet,

amount

FROM

token_transfers

UNION ALL

SELECT

date,

sender AS wallet,

-amount AS amount

FROM

token_transfers

) t

GROUP BY

wallet,

date

),

daily_balances AS (