sum(post.value - pre.value)

FROM (

SELECT pre_balances,

post_balances

FROM flipside_prod_db.solana.fact_transactions

WHERE contract_address =)

LEFT JOIN table(flatten(input => pre_balances)) pre

LEFT JOIN table(flatten(input => post_balances)) post