SENDER, RECIPIENT, AMOUNT,

CASE

WHEN LOWER(SENDER) = 'null' THEN AMOUNT

WHEN LOWER(RECIPIENT) = 'null' THEN -AMOUNT

ELSE 0

END AS stflow

FROM flow.core.ez_token_transfers

WHERE TOKEN_CONTRACT = 'A.d6f80565193ad727.stFlowToken'

LIMIT 10;