NFT_TO_ADDRESS as holder,

tokenid,

sum(

CASE when NFT_FROM_ADDRESS LIKE '0x0000000000000000000000000000000000000000' then ERC1155_VALUE

when NFT_TO_ADDRESS LIKE '0x0000000000000000000000000000000000000000' then -1 * ERC1155_VALUE

end

) as token_amt

from polygon.core.ez_nft_transfers

WHERE NFT_ADDRESS LIKE lower('0xfaa85a0903985baaf3ba9ede37db6b9e325630b7')

and not holder LIKE '0x0000000000000000000000000000000000000000'

GROUP BY 1,2