SELECT nft_from_address AS user_address

, nft_address

, '-1' AS flow

FROM ethereum.core.ez_nft_transfers

WHERE nft_address ilike '0x49cF6f5d44E70224e2E23fDcdd2C053F30aDA28B'

UNION ALL

SELECT nft_to_address AS user_address

, nft_address

, '1' AS flow

FROM ethereum.core.ez_nft_transfers

WHERE nft_address ilike '0x49cF6f5d44E70224e2E23fDcdd2C053F30aDA28B'

),

holdings AS (

SELECT user_address

, nft_address

, SUM(flow) AS holdings

FROM raw

GROUP BY 1, 2

having holdings > 0

SELECT CURRENT_DATE AS balance_date, *

FROM holdings

ORDER BY holdings DESC

limit 10