node-queries.sql

-- GET NODE FREE BALANCE ACROSS ALL CHANNELS FOR TOKEN
SELECT ("latestState" #> '{balances}' -> (
	SELECT array_position(
	array(
		SELECT jsonb_array_elements_text("latestState" #> '{tokenAddresses}')),
		'0xEcFcaB0A285d3380E488A39B4BB21e777f8A4EaC' -- TOKEN ADDRESS
	)::integer - 1
) #> '{0,amount,_hex}')
FROM channel INNER JOIN app_instance 
ON app_instance."channelMultisigAddress" = channel."multisigAddress" 
WHERE app_instance.type = 'FREE_BALANCE';