date_trunc('week', block_timestamp) as week,

sum(

CASE WHEN nft_from_address = '0x0000000000000000000000000000000000000000' THEN 1

WHEN nft_to_address = '0x0000000000000000000000000000000000000000' THEN -1

end

) as net_alive_frenpets,

sum(net_alive_frenpets) over (order by week) as total_alive_frenpet

FROM base.nft.ez_nft_transfers

WHERE NFT_address = lower('0x5b51Cf49Cb48617084eF35e7c7d7A21914769ff1')

GROUP BY 1